投稿時間:2021-07-04 00:19:22 RSSフィード2021-07-04 00:00 分まとめ(25件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	ITmedia 総合記事一覧	[ITmedia ビジネスオンライン] 堀江貴文氏「正直、機体の動作はパーフェクト」　インターステラテクノロジズ「ねじのロケット」が同社2度目となる宇宙空間の到達に成功	https://www.itmedia.co.jp/business/articles/2107/03/news056.html	itmedia	2021-07-03 23:06:00
js	JavaScriptタグが付けられた新着投稿 - Qiita	[JavaScript]canvasで多角形の作成と描画	https://qiita.com/deepgreenAN/items/01dadf6552a17c47c069		2021-07-03 23:59:50
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	【HTML/CSS】perfect-scrollbar.jsが動かない	https://teratail.com/questions/347513?rss=all	【HTMLCSS】perfectscrollbarjsが動かないoverflownbspscrollとwebkitscrollbarthumbのオプションでスマホの横スクロールバーを常時表示したかったのですが、Androidのみ表示されました。	2021-07-03 23:59:07
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	arudino→PC間のシリアル通信について	https://teratail.com/questions/347512?rss=all	arudino→PC間のシリアル通信についてarudinoとPC間でデータのやり取りをおこなうVCプログラムを作ろうとしています。	2021-07-03 23:59:06
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	JS/React 購入ボタンを押される度に在庫の数をデクリメントしたい	https://teratail.com/questions/347511?rss=all	JSReact購入ボタンを押される度に在庫の数をデクリメントしたいJavaScriptnbspReact初心者です。	2021-07-03 23:58:33
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	SyntaxErrorの解消	https://teratail.com/questions/347510?rss=all	if文を勉強中なのですが、何度やってもエラーが解消されません。	2021-07-03 23:48:24
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	Unity　タッチして消えるアイテムを、元通り復活させるListの使用法	https://teratail.com/questions/347509?rss=all	同じアイテムが元通り復活して、再びタッチできるようになる発生している問題GameObjectのListを用いて上記動作を実現しようとしていますが、うまくいきません。	2021-07-03 23:40:21
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	VBA　シートのコピー方法	https://teratail.com/questions/347508?rss=all	VBAシートのコピー方法前提・実現したいことエクセルのあるシートのコピーを別ブックへとコピーしたいしかしコピーするシートにはworksheetnbspchangeイベントが既に記入してありコピーする先へは、イベントを引き継ぎたくない。	2021-07-03 23:39:22
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	webの要素を取得する言語	https://teratail.com/questions/347507?rss=all	webの要素を取得する言語例として、GoogleのGmailに新しいメールが届いたときに通知をしてくれるようなプログラムを作りたいです。	2021-07-03 23:37:10
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	css gridで並べたアイテムを正方形にしたい	https://teratail.com/questions/347506?rss=all	cssgridで並べたアイテムを正方形にしたい前提・実現したいことデモグリッドレイアウトで列に並べています。	2021-07-03 23:32:58
Program	[全てのタグ]の新着質問一覧｜teratail（テラテイル）	dataframeの特定のカラムに対する処理の仕方について	https://teratail.com/questions/347505?rss=all	dataframeの特定のカラムに対する処理の仕方について質問をご覧いただいてありがとうございます。	2021-07-03 23:06:09
Ruby	Rubyタグが付けられた新着投稿 - Qiita	使用するテスト言語と期待される生成テストコード	https://qiita.com/cyril/items/17ee758e162bae144a07	早速ですが、フレームワークがどのようにテストを構築・実行するのかを理解するために、DSLの構文と生成されたRubyのコードの対応関係をご紹介する。	2021-07-03 23:56:03
AWS	AWSタグが付けられた新着投稿 - Qiita	AWS Configの結果をSNS Topic通してメール通知するCloudformationサンプル	https://qiita.com/yomon8/items/19223d6c70f389c6c743	AWSConfigの結果をSNSTopic通してメール通知するCloudformationサンプル作ったのでメモとして残しておきます。	2021-07-03 23:50:21
技術ブログ	Developers.IO	CloudTrailの証跡データをS3ライフサイクルでGlacierに移行する際の損益分岐点を探る	https://dev.classmethod.jp/articles/explore-breakeven-points-when-migrating-cloudtrail-trail-data-to-glacier-in-s3-lifecycles/	cloudtrail	2021-07-03 14:51:45
海外TECH	DEV Community	Automated Airtime Disbursal using Google Forms, Python, Africas Talking Airtime Api and Heroku	https://dev.to/ken_mwaura1/automated-airtime-disbursal-using-google-forms-python-africas-talking-airtime-api-and-heroku-3ef2	Automated Airtime Disbursal using Google Forms Python Africas Talking Airtime Api and HerokuMy previous article on automating customer rewards using airtime garnered a lot of attention and reads Automate Customer Rewards using Python Postgresql and Africas Talking Zoo Codes・Apr ・ min read python tutorial postgres africastalking This of course lead me to realize a good number of people are interested in the topic This article will cover similar topics only with a different workflow Quick life update I recently joined the prestigious Moringa School to update my software development skills Now due to Covid pandemic we are mostly learning remotely this necessitates an internet connection The school provides airtime via a rd party company However I got an idea for a DIY cloud based option hence this project This project will make use of Google Forms to collect student information name phone number Google Sheets to store and verify the data Python as our language of choice to get the required data send requests to the airtime endpoint of Africas Talking ApiHeroku to host and schedule our script PrerequisitesTo follow along this post and code the same features You re going to need a few things Python and pip I am currently using Any version above should work An Africas Talking account Api Key and username from your account Create an app and take note of the api key Additionally you will need to request them to enable airtime access for your account Email their airtime team for further clarificationOnce you ve got the above sorted Create a new directory and change into it mkdir Automated Airtime Disbursal cd Automated Airtime DisbursalCreate a new virtual environment for the project or activate the previous one Using python package manager pip install africastalking python sdk python dotenv library gspread libraries Save the installed libraries in a requirements txt file python m venv source bin activate pip install africastalking python dotenv gspread pip freeze gt requirements txtAlternatively check the finished code on Github KenMwaura Automated Airtime Disbursal This is a simple python script to automate airtime disbursal using google forms python and AfricasTalking Forms For EveryoneTo kickoff this process lets first create a Google form Visit this linkand create a new form Example as shown below The next step is authenticate the python script and our local development environment with Google This enables us to access Google Form data from Google Drive by enabling the Google Drive Api in Google Cloud Platformconsole To complete setting up our form Go to the Google FormResponses Tab Click the spreadsheet iconAnd create a new Destination Spreadsheet for our Google form The spreadsheet will be created and stored Google Drive To integrate our Python environment and Google Drive First we have to authenticate with Google Authentication For the Win Now to interact with the Google Drive Api we have to setup our account enable Google Drive and Google Sheets Api and obtain a credentials json file Go to the Google Cloud Platform Console click on New Project Projects →New Project on the GCP Toolbar Enter a name for our project and click Create To access spreadsheets via the Google Sheets Api authentication is required There are two ways to go about it Service Account Mainly used to access spreadsheets on behalf of a bot OAuth Client ID If you d like to access spreadsheets on behalf of end users including yourself Api access for our projectHead to Google Developers Console and create a new project or select the one you already have In the box labeled “Search for APIs and Services search for “Google Drive API and enable it In the box labeled “Search for APIs and Services search for “Google Sheets API and enable it Service Account SetupFor this project I used the Service Account However feel free to go the Oauth route if you prefer A service account is a special type of Google account intended to represent a non human user that needs to authenticate and be authorized to access data in Google APIs Since it s a separate account by default it does not have access to any spreadsheet until you share it with this account Just like any other Google account Here s how to get one Enable API Access for a Project as shown above if you haven t done it yet Go to “APIs amp Services gt Credentials and choose “Create credentials gt Service account key Fill out the form Click “Create and “Done Press “Manage service accounts above Service Accounts Press on ⋮near recently created service account and select “Manage keys and then click on “ADD KEY gt Create new key Select JSON key type and press “Create You will automatically download a JSON file with credentials It may look like this type service account project id api project XXX private key id cd …ba private key BEGIN PRIVATE KEY nNrDyLw …jINQh n END PRIVATE KEY n client email yoursisdifferent developer gserviceaccount com client id …hd apps googleusercontent com Place the downloaded credentials file in our currently working folder In my case I renamed it to airtime credentials json Go back to the Google Console in our current project Click on the credentials tab copy theemail under service accounts Alternatively check the downloaded json file for value client emailVery important Go to your spreadsheet and share it with a client email from the step above Just like you do with any other Google account If you don t do this you ll get a gspread exceptions SpreadsheetNotFound exception when trying to access this spreadsheet from your application or a script Note This secret json file and the Python File created below should be present in the same directory Data Extraction from Google SheetsThis is our google sheet that we will be extracting data from Take note of the name as well as the columns as they integral to data extraction After we ve completed the steps above lets now get the data from our spreadsheets Create a file to hold all of our code import of our required libraries touch airtime disbursal py airtime disbursal py import osimport africastalking as atfrom dotenv import load dotenvimport gspreadNow create a variable using the gspread library service account method and our downloaded json file to authenticate our request Then we will create a function get spreadsheet data that accepts spreadsheet name and index of required worksheet as arguments The function will query for the specified spreadsheet and worksheet then return all the values except the column headers def get spreadsheet data sheet name worksheet index make a request to Google specifying the spreadsheet required sheet gc open sheet name get worksheet worksheet index by specifying the index we remove the column headers return sheet get all values Inorder for us to call the above defined function we need to define a few variables as well as assign it to a variableto make the resultant data easier to work with sheet index airtime sheet name Contact Information Responses sheet data get spreadsheet data airtime sheet name sheet index print sheet data Airtime for Everyone Let s create a env file in our working folder to hold all of our environment variables that we dont want to expose to everyone Enter the following changing the placeholders with the proper credentials touch env env at username enter your at usernameat api key enter your api keyEnsure you get your correct credentials from your Africas talking portal Load our sensitive information using environment variablesload dotenv get the environment values from the env fileat username os getenv at username at api key os getenv at api key initialize africas talking using username and api keyat initialize at username at api key airtime at Airtimeaccount at ApplicationThe snippet above uses load dotenv function to load our sensitive data from environment variables We then assign variables to each environment value We then instantiate Africas Talking client by passing our api key and at username variables Finally we assign the Airtime and Application classes to variables def airtime disbursal number airtime amount str airtime currency code str print account fetch application data try response airtime send phone number number amount amount currency code currency code print response except Exception as e print f Encountered an error while sending airtime More error details below n e The snippet above creates a airtime disbursal function that accepts arguments number phone number of each recipient airtime amount amount of airtime to send to each recipient and airtime currency code digit currency code required by Africas Talking We then proceed to print out our account balance using fetch application data method Finally we write a try catch block to hold the logic for sending airtime Here we pass our arguments as needed Read the docs for more information Set The Letter ISO currency code and the amountamount currency code KES Unpack the list of valuesfor item in sheet data print item mobile number item for each number in the sheet send airtime top up as specified airtime disbursal mobile number amount currency code print account fetch application data The code block above defines an amount variable and assigns a value of This is ofcourse a demo in a production environment you will probably have variable amounts for different recipients We then define our currency code as KES This is important as it tells the API what currency to disburse the airtime in We then add a for loop to unpack our sheet data list The last item in the list contains the required phone number We proceed to assign it to a variable We then call our airtime disbursal function on each value on the list The function will run passing along a different phone number on each run until the list is complete We then query the balance of our account after the completion of the loop DeploymentNow for our solution to be automated we need to deploy it to the cloud and have it run on scheduled intervals There a lot of good cloud vendors we could use however Heroku takes the cake for its ease of deployment and free tier that will be enough for demo purposes It is easy enough to choose any other cloud provider e g Digital Ocean AWS GCP etc After creating an account and logging in I recommend you install the heroku cli for easier time during deploying Now lets begin deployment just do a heroku create app automatic airtime If you go on your app dashboard you ll see your new app Alternatively use the browser to create the app We need to create a runtime txt file to tell Heroku which version of python we want it run I set mine to to replicate my development environment echo python gt runtime txtWe also need to specify config vars that heroku will use during runtime This similar how we ve beenstoring our credentials in a env file You could either set them via the heroku console in the browser or terminal using the Heroku cli Make sure you change the values to your actual credentials heroku config set at api key api key here heroku config set at username Username hereWe now need to initialize a git repo and push the code on Heroku git init heroku git remote a heroku create app automatic airtime git add git commit am Deploy airtime disbursal script git push heroku masterIncase you get an error running the above commands change your app name as its usually required to be unique Your app is now on Heroku but it is not doing anything Since this little script can t accept HTTP requests going to automatic airtime herokuapp com won t do anything But that should not be a problem To have this script running on as scheduled basis we need to use a Heroku add on called Advanced Scheduler To install this add on click on the Configure Add ons button on your app dashboard Then on the search bar look for Advanced Scheduler Click on the result select the free plan and click on Submit Order Form If you go back to your App dashboard you ll see the add on Click on the Advanced Scheduler link to configure a job Then click on Create trigger Here enter a name for the trigger set the timezone and for run command select python airtime disbursal py Set the state to active Type to recurring and select Schedule helper in the schedule section In this case I set the unit of time to weekly for demo purposes However feel free to adjust as your needs dictate For the interval its set for Every Friday at pm While everything we used so far on Heroku is free the Advanced Scheduler will run the job on the Free trial Which allows for triggers up to runs which fits OK here from there it goes up to month Check further on pricing page ConclusionWe initially set out to build a DIY solution to scheduled airtime disbursal using set number of tools For usthe workflow is Google Forms gt Google Sheets gt Python gt Africas Talking gt Heroku gt Recipient Now this approach works well and as expected however it requires understanding the various parts and services needed thus not for everyone As stated in the beginning of this article there various rd party that plug and play options Pickthe best option for your use case I hope that you liked this post and that you learned things reading it I truly believe that this kind of project is one of the best ways to learn new tools and concepts If you have any question or comments Let me know in the comments or on Twitter Happy Coding	2021-07-03 14:16:22
Apple	AppleInsider - Frontpage News	Ransomware attack of 200 firms by group behind Apple extortion attempt	https://appleinsider.com/articles/21/07/03/ransomware-attack-of-200-firms-by-group-behind-apple-extortion-attempt?utm_medium=rss	Ransomware attack of firms by group behind Apple extortion attemptA ransomware attack has potentially impacted hundreds of companies on the July th weekend an attack by the same group that attempted to extort Apple in April On Friday it was revealed IT management firm Kaseya has been the focus of a new ransomware attack that deals with software tools it produces The Florida based Kaseya disclosed that its VSA software was part of a potential security incident prompting the shutdown of its servers and notifying customers to shut down related VSA servers As Kaseya operates a platform for managed service providers MSPs to offer remote support and software update services to other businesses ransomware could have been distributed using VSA servers to MSP clients This has the potential to harm hundreds of companies that use MSPs that rely on Kaseya s platform Read more	2021-07-03 14:59:36
Apple	AppleInsider - Frontpage News	Public betas, bigger iPad Pro, and AirPower -- This Week in Apple	https://appleinsider.com/articles/21/07/03/public-betas-bigger-ipad-pro-and-airpower----this-week-in-apple?utm_medium=rss	Public betas bigger iPad Pro and AirPower This Week in AppleIn this week s roundup Apple s supply chain is preparing for this year s product updates as well as rumors about the iPad Pro and the possibility that AirPower may still exist Keep up with the last week of Apple newsEach week AppleInsider posts tons of stories about Apple its products rumors and information about related vendors and other firms Our weekend video series This Week in Apple condenses down the week s stories into an easy to digest video recap Read more	2021-07-03 14:28:29
海外TECH	Engadget	OnePlus is integrating its mobile operating system with Oppo's	https://www.engadget.com/oneplus-oppo-oxygenos-coloros-shared-codebase-141211007.html?src=rss	OnePlus is integrating its mobile operating system with Oppo x sHalf a month after OnePlus announced that it s becoming an Oppo sub brand it has revealed that it s also merging its OxygenOS with its new parent company s ColorOS The two brands have come to the decision to quot best leverage their shared resources quot and to standardize the software experience across their portfolio But what does OnePlus mean exactly when it said that they re quot working on integrating the codebase of OxygenOS and ColorOS quot It said you may not even notice a difference because the changes are happening behind the scenes OxygenOS will still be the operating system for OnePlus devices released globally As toGoogle notes OnePlus phones released in China already run ColorOS and that will likely remain the case ーit s just that the operating systems will now shade a codebase All new devices the sub brand will release will run the new OxygenOS while current devices that are still receiving updates will get the new platform via an over the air update nbsp Speaking of updates OnePlus is promising better and longer Android update support which now rivals Samsung s with the change The OnePlus series and the brand s newer flagships will receive three major Android updates and four years of security updates going forward Meanwhile the first Nord and any newer Nord and Nord CE devices will receive two major Android and three years of security updates Finally the affordable Nord N series phones starting from the N and the N will get one major Android update and three years of security updates Unfortunately you can continue expecting two major Android and three years of security updates if you have a flagship older than the OnePlus When the merge was announced the companies said OnePlus will remain independently operated Since the move was meant to pool their resources and to better streamline their operations though linking their operating systems more closely doesn t come as surprise	2021-07-03 14:12:11
ニュース	BBC News - Home	Wimbledon 2021: Emma Raducanu, 18, defeats Sorana Cirstea in straight sets to reach fourth round	https://www.bbc.co.uk/sport/tennis/57706687	Wimbledon Emma Raducanu defeats Sorana Cirstea in straight sets to reach fourth roundEmma Raducanu s dream debut run at Wimbledon continues into the fourth round with victory over Romania s world number Sorana Cirstea	2021-07-03 14:51:03
ニュース	BBC News - Home	Vatican embezzlement trial: Cardinal Angelo Becciu among 10 charged	https://www.bbc.co.uk/news/world-europe-57706618	vatican	2021-07-03 14:19:56
ニュース	BBC News - Home	Japan landslide: 20 missing in Atami city	https://www.bbc.co.uk/news/world-asia-57704967	heavy	2021-07-03 14:09:40
ニュース	BBC News - Home	Verstappen on pole with Norris second in Austria	https://www.bbc.co.uk/sport/formula1/57707904	lando	2021-07-03 14:12:01
北海道	北海道新聞	「世界一健康なマチ」へ東川町と連携　スノボ竹内選手、体づくり指導	https://www.hokkaido-np.co.jp/article/563163/	竹内智香	2021-07-03 23:13:43
北海道	北海道新聞	ポケモンキャラそっくり？　模型やパネル、古生物と比較　三笠で特別展	https://www.hokkaido-np.co.jp/article/563156/	人気ゲーム	2021-07-03 23:10:28
北海道	北海道新聞	ばんだい号墜落から５０年、安全運航誓う　七飯・横津岳	https://www.hokkaido-np.co.jp/article/563159/	日本航空	2021-07-03 23:06:49