def cursor(database=DATABASE):
"""Establish the connection with the database.
Will change in beta version so that only one connection is used throughout app."""
DSN = dbconn2.read_cnf()
DSN['db'] = database
conn = dbconn2.connect(DSN)
return conn.cursor(MySQLdb.cursors.DictCursor)
def dictCursor():
global dbconn
dsn = dbconn2.read_cnf('/home/hugh9/.my.cnf')
dsn['db'] = 'janice'
dbconn = dbconn2.connect(dsn)
curs = dbconn.cursor(MySQLdb.cursors.DictCursor)
return curs
def server(database):
'''Returns a cursor to the database'''
dsn = dbconn2.read_cnf('/students/dormdata/.my.cnf')
dsn['db'] = database
conn = dbconn2.connect(dsn)
conn.autocommit(True)
return conn.cursor(MySQLdb.cursors.DictCursor)
def init():
dsn = dbconn2.read_cnf(".my.cnf")
dsn['db'] = 'wzhang2_db'
dsn['host'] = 'localhost'
conn = dbconn2.connect(dsn)
conn.autocommit(True)
return conn
def connect(database, user):
'''
Connects to the provided database using my cnf file and returns the connection
'''
dsn = dbconn2.read_cnf('/students/' + user + '/.my.cnf')
dsn['db'] = database
conn = dbconn2.connect(dsn)
return conn
def row_iter(query):
dsn = dbconn2.read_cnf()
conn = dbconn2.connect(dsn)
curs = conn.cursor(MySQLdb.cursors.DictCursor)
numrows = curs.execute(query)
print 'total of {} rows'.format(numrows)
while True:
row = curs.fetchone()
if row is None:
raise StopIteration
yield row
'''
calpal
Mollee Jain, Serry Park, Selina Sotomayor
schedule.py
This is a file that includes helper functions that helps the CGI python file collect the data and
display what the user wants.
Last updated: 5/15/2016
'''
#imports
import MySQLdb
import dbconn2
#setup
dsn = dbconn2.read_cnf('/students/calpal/.my.cnf')
dsn['db'] = 'random' #current database being used
dsn['host'] = 'localhost'
conn = dbconn2.connect(dsn)
curs = conn.cursor()
#queryCourse()
#Takes in the crn of a course and returns the entire course entry in raw data (in a tuple format)
def queryCourse(crn):
if (crn == '' or crn is None):
return "Please enter CRN"
curs.execute("SELECT * FROM course_data WHERE CRN = %s", (crn, ))
courseList = curs.fetchone()
if courseList is None or courseList == '':
return "CRN not in database"
# CS304-Final Project
# Created by: Megan Shum, Maxine Hood, Mina Hattori
#!/usr/local/bin/python2.7
# This file handles all the SQL calls for the search page.
import sys
import MySQLdb
import dbconn2
def searchExists(conn, username):
'''Returns all of the user's pic post from the database in the form of a dictionary'''
curs = conn.cursor(MySQLdb.cursors.DictCursor) # results as Dictionaries
curs.execute('select username from user where username = %s', [username])
exists = curs.fetchone()
return bool(exists)
# ================================================================
# This starts the ball rolling, *if* the script is run as a script,
# rather than just being imported.
if __name__ == '__main__':
if len(sys.argv) < 2:
print "Usage: {name} nm".format(name=sys.argv[0])
else:
DSN = dbconn2.read_cnf()
DSN['db'] = 'mmm_db' # the database we want to connect to
dbconn2.connect(DSN)
print lookupByNM(sys.argv[1])
def cursor(database=DATABASE):
DSN = dbconn2.read_cnf()
DSN['db'] = database
conn = dbconn2.connect(DSN)
return conn.cursor(MySQLdb.cursors.DictCursor)
def get_dsn():
return dbconn2.read_cnf()
def get_dsn(db='yourroom_db'):
dsn = dbconn2.read_cnf()
dsn['db'] = db
return dsn
else:
return "The dish " + dish + " already exists for the restaurant " + resName + "."
# def main(dishID):
# dsn = dbconn2.read_cnf(".my.cnf")
# dsn['db'] = 'twen2_db'
# dsn['host'] = 'localhost'
# conn = dbconn2.connect(dsn)
# conn.autocommit(True)
# curs = conn.cursor(MySQLdb.cursors.DictCursor)
# curs.execute('''UPDATE dishes SET num_of_likes = %s WHERE id = %s''', (like, dishID))
# return
if __name__ == "__main__":
dsn = dbconn2.read_cnf(".my.cnf")
dsn['db'] = 'twen2_db'
dsn['host'] = 'localhost'
conn = dbconn2.connect(dsn)
conn.autocommit(True)
data = cgi.FieldStorage()
dishID = data.getfirst('dishID')
dishLike = data.getfirst('dishLike')
imcrementLike(conn, dishID, dishLike)
# update the number of like for each dish after user click the like button
def incrementLike(conn, dishID, userID, like):
curs = conn.cursor(MySQLdb.cursors.DictCursor)
curs.execute('''UPDATE dishes SET num_of_likes = %s WHERE id = %s''',
(like, dishID))
pid = request.form['projectID']
updateDB.deleteProject(conn, pid)
flash("Project Deleted")
projects = updateDB.getUserProjects(conn, uid)
return render_template('clientProjects.html',
projects = projects,
role = roleCheck
)
else:
flash('Only clients have access to this page, please login with a client account')
return redirect( url_for('index') )
else:
flash('You are not logged in. Please login or join')
return redirect( url_for('index') )
except Exception as e:
flash(e)
return redirect( url_for('index') )
if __name__ == '__main__':
if len(sys.argv) > 1:
# arg, if any, is the desired port number
port = int(sys.argv[1])
assert(port>1024)
else:
port = os.getuid()
dsn = dbconn2.read_cnf()
dsn['db'] = 'wprojdb_db'
app.debug = True
app.run('0.0.0.0',port)
def connectToDB(path_to_cnf, db_name):
dsn = dbconn2.read_cnf(path_to_cnf)
dsn['db'] = db_name
conn = dbconn2.connect(dsn)
return conn
def getConn():
DSN = dbconn2.read_cnf('~/.my.cnf')
DSN['db'] = 'codemode_db'
conn = dbconn2.connect(DSN)
return conn
def main():
dsn = dbconn2.read_cnf()
dbconn2.connect(dsn)
compute_insulin_on_board(conn)
def dictCursor():
dsn = dbconn2.read_cnf('/home/hugh9/.my.cnf')
conn = dbconn2.connect(dsn)
curs = conn.cursor(MySQLdb.cursors.DictCursor)
return curs
def get_dsn(file='/home/hugh9/.my.cnf'):
if DSN is None:
DSN = dbconn2.read_cnf('/home/hugh9/.my.cnf')
return DSN
def getConn():
DSN = dbconn2.read_cnf()
DSN['db'] = 'scottai_db'
return dbconn2.connect(DSN)
def get_dsn():
global DSN
if DSN is None:
DSN = dbconn2.read_cnf('/home/hugh9/.my.cnf')
return DSN
calpal
Mollee Jain, Serry Park, Selina Sotomayor
schedule.py
This is a file that includes helper functions that helps the CGI python file collect the data and
display what the user wants.
Last updated: 5/15/2016
'''
#imports
import MySQLdb
import dbconn2
#setup
dsn = dbconn2.read_cnf('/students/calpal/.my.cnf')
dsn['db'] = 'random' #current database being used
dsn['host'] = 'localhost'
conn = dbconn2.connect(dsn)
curs = conn.cursor()
#queryCourse()
#Takes in the crn of a course and returns the entire course entry in raw data (in a tuple format)
def queryCourse(crn):
if (crn == '' or crn is None):
return "Please enter CRN"
curs.execute("SELECT * FROM course_data WHERE CRN = %s",(crn,))
courseList = curs.fetchone()
if courseList is None or courseList == '':
return "CRN not in database"
return courseList
def getConn(db='yourroom_db'):
dsn = dbconn2.read_cnf()
dsn['db'] = db
return dbconn2.connect(dsn)
def getConn(): DSN = dbconn2.read_cnf() DSN['db'] = 'bramanud_db' #LOSER return dbconn2.connect(DSN)
