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>'