This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Request: Move VendorLink ccc40b92-3894-4b30-9515-37116d018136 from +18002221111(dev) to +13238419525(prod) and the CD 'Custom dash test' | |
Steps: | |
1] Extract group_id for user with phone_number of +13238419525 in prod | |
Log on to Prod instance in a terminal on root of lanely repo: | |
./bin/prod_db | |
Run the query select a.default_group_id from "account" a left join "user" u on u.id = a.user_id where u.phone_number='+13238419525'; | |
2] Extract the data to ingest into Prod as CSV's | |
Log on to Dev instance in a terminal on root of lanely repo: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1. Log on to Prod instance in a terminal on root of lanely repo: | |
./bin/prod_db | |
Reference: https://github.com/rcrdclub/lanley#read-only-access-to-devprod-dbs | |
2. Run \copy command on your favorite PGCLI client: (This copies Bmi Links and updates the group_id to be hardcoded to a specific group_id for the dev account this needs to be linked to) | |
\copy (SELECT id, '01d95391-d582-4ff3-a375-1fcef7f867aa', vendor_account_id, login_name, login_password, created_at, updated_at, enabled, vendor from vendor_link where vendor='bmi' and login_name IS NOT NULL and login_password IS NOT NULL and enabled='t') to '/home/asachdeva/bmilinks.csv' with csv | |
3. Log out of Prod instance | |
4. Log into Dev Instance with Read/Write capabilities: |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Programming Assignment: | |
The Twitter Streaming API provides real-time access to public tweets. | |
In this assignment you will build an application that connects to the Streaming API and processes | |
incoming tweets to compute various statistics. | |
We'd like to see this as a Scala project, but otherwise feel free to use any libraries you want to | |
accomplish this task. The sample endpoint provides a random sample of approximately 1% of the full tweet stream. | |
Your app should consume this sample stream and keep track of the following: | |
1] Total number of tweets received | |
2] Average tweets per hour/minute/second | |
3] Top emojis in tweets |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Programming Assignment:The Twitter Streaming API provides real-time access to public tweets. In this assignment you will build an application that connects to the Streaming API and processes incoming tweets to compute various statistics. We'd like to see this as a Scala project, but otherwise feel free to use any libraries you want to accomplish this task.The sample endpoint provides a random sample of approximately 1% of the full tweet stream. Your app should consume this sample stream and keep track of the following: | |
Total number of tweets received | |
Average tweets per hour/minute/second | |
Top emojis in tweets | |
Percent of tweets that contains emojis | |
Top hashtags | |
Percent of tweets that contain a url | |
Percent of tweets that contain a photo url (pic.twitter.com or instagram) | |
Top domains of urls in tweets | |
The emoji-data project provides a convenient emoji.json file that you can use to determine which emoji unicode characters to look for in the tweet text.Your app should also provide some way to report these values to |