Assignment #7 Due 11/4/21, 10/24/2021, 2:43 PM, English, 10/24/2021, 2:43 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

10/24/2021, 2:43 PM

Assignment #7 Due 11/4/21

Reminder please shut off or delete your SQL Instance

BigQuery

Select a Public Dataset from the available BiQuery Datasets

Pick one of the Sample Queries available

Run the query

Export the output to a file

Email the file along with reason you picked the Dataset and explain
the data you are sending

Note: Do not use the NY Times Covid that is in the example.

stop your SQL instance, 10/22/2021, 1:40 PM, English, 10/22/2021, 1:40 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

10/22/2021, 1:40 PM

If you submitted assignment #5 stop your SQL instance so charges will
not continue

Office Hours 5pm, 10/21/2021, 4:56 PM, English, 10/21/2021, 4:56 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

10/21/2021, 4:56 PM

office hours 5:00pm to 6:00pm

https://uconn-cmr.webex.com/meet/jai17003

Office Hours tonight at 5PM to 6PM, 10/19/2021, 2:34 PM, English, 10/19/2021, 2:34 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

10/19/2021, 2:34 PM

Office Hours tonight at 5PM to 6PM

https://uconn-cmr.webex.com/join/jai17003

Assignment #6 dues 10/28, 10/17/2021, 7:44 PM, English, 10/17/2021, 7:44 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

10/17/2021, 7:44 PM

Please let me know if anyone wants office hours tuesday 5:00pm to 6:00pm

https://uconn-cmr.webex.com/meet/jai17003

https://uconnstamfordslp.blogspot.com/p/assignment-exercise-python-datastore.html
Assignment # 6

Recreate the app engine project above and send me a working link from
app engine screen.

Create a datastore entity called Custinfo

Load programs nper link

Note: Need to have Google Translate API turned on in order to read data

Assignment #6 Document Storage, 10/11/2021, 7:44 PM, English, 10/11/2021, 7:44 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

10/11/2021, 7:44 PM

Please let me know if anyone wants office hours tomorrow 5:00pm to 6:00pm

https://uconn-cmr.webex.com/meet/jai17003

https://uconnstamfordslp.blogspot.com/p/assignment-exercise-python-datastore.html
Assignment # 6

Recreate the app engine project above and send me a working link from
app engine screen.

Create a datastore entity called Custinfo

Load programs nper link

Note: Need to have Google Translate API turned on in order to read data

Midterm Exam 10/11 and 10/13 at 7:30pm, 10/9/2021, 9:57 AM, English, 10/9/2021, 9:57 AM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

10/9/2021, 9:57 AM

Midterm Exam 10/11 and 10/13 at 7:30pm
Format is short answers. The first 3 questions below:
What is the Google Cloud?
What are the benefits to using the Google Cloud?
Explain the benefits of replication?
Always good to understand the job market no matter what year you are in.

Computer science minors can help your opportunities and career growth.

https://money.usnews.com/careers/best-jobs/software-developer/salary
https://www.mtu.edu/engineering/outreach/welcome/salary/

custadd, 10/6/2021, 8:30 PM, English, 10/6/2021, 8:30 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

10/6/2021, 8:30 PM

# This file contains all the code used in the codelab.
import sqlalchemy

# Depending on which database you are using, you'll set some variables
differently.
# In this code we are inserting only one field with one value.
# Feel free to change the insert statement as needed for your own
table's requirements.

# Uncomment and set the following variables depending on your specific
instance and database:
connection_name = 'uconn-engr:us-central1:customer'
table_name = 'customer'
db_name = 'customer'
db_user = 'root'
db_password = 'uconnstamford'

# If your database is MySQL, uncomment the following two lines:
driver_name = 'mysql+pymysql'
query_string = dict({"unix_socket": "/cloudsql/{}".format(connection_name)})

# If your database is PostgreSQL, uncomment the following two lines:
#driver_name = 'postgres+pg8000'
#query_string = dict({"unix_sock":
"/cloudsql/{}/.s.PGSQL.5432".format(connection_name)})

# If the type of your table_field value is a string, surround it with
double quotes.

def custadd(request):
request_json = request.get_json()
request_data = request.values
email = request_data['myemail']
lname = request_data['mylastname']
fname = request_data['myfirstname']
addr = request_data['myaddress']
city = request_data['mycity']
state = request_data['mystcode']
zipcode = request_data['myzipcode']
stmt = sqlalchemy.text('insert into customer (email, LastName,
FirstName, Address, City, StateCode, ZipCode) values
("'+email+'","'+lname+'","'+fname+'","'+addr+'","'+city+'","'+state+'","'+zipcode+'")')





db = sqlalchemy.create_engine(
sqlalchemy.engine.url.URL(
drivername=driver_name,
username=db_user,
password=db_password,
database=db_name,
query=query_string,
),
pool_size=5,
max_overflow=2,
pool_timeout=30,
pool_recycle=1800
)
try:
with db.connect() as conn:
conn.execute(stmt)
except Exception as e:
return 'Error: {}'.format(str(e))
return '<!DOCTYPE html><html><h1>You Entered</h1><br><p>Customer
Successfully Added</p></html>'

Assignment #5 Due 10/21, 10/6/2021, 7:24 PM, English, 10/6/2021, 7:24 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

10/6/2021, 7:24 PM

Please let me know if anyone wants office hours tomorrow 5:00pm to 6:00pm

https://uconn-cmr.webex.com/meet/jai17003
Late assignments will be penalized.
Assignment #5 Due 10/21
Create a web site on your cloud storage bucket that
will allow customers to add, change, delete and list their customer information
Using google cloud python functions, html forms and mysql database
tables from the SQL customer table.

https://uconnstamfordslp.blogspot.com/p/mysql-exercise.html
https://uconnstamfordslp.blogspot.com/p/cloud-function-project-python.html

Midterm exam, 10/11 at 7:30 and 10/13 at 7:30, 10/4/2021, 6:16 PM, English, 10/4/2021, 6:16 PM

Your assigned language is: English
Classroom blog: googleclouduconn.blogspot.com

10/4/2021, 6:16 PM

Midterm exam based on book chapters 1,3, 8, 9, 11, 12 and 4 scheduled
Monday 10/11 and Wednesday 10/13 at 7:30pm