def init_db(): dbi.cache_cnf() dbi.use('uwushu_db')
#FindASubstitute #Bianca Pio, Alexandra Bullen-Smith, Margaret Harrigan #CS 304 Final Project #Submitted May 13, 2020 #data.py is the python file containing functions to navigate the database import database import cs304dbi as dbi dsn = dbi.cache_cnf() dbi.use('findasubstitute_db') #sees if an entered username already exists def usernameAvailability(conn, username): curs = dbi.dict_cursor(conn) sql = 'select * from employee1 where username = %s' vals = [username] curs.execute(sql, vals) available = curs.fetchall() if (len(available) == 1): return True #username already exists else: return False #unique username def emailAvailability(conn, email): curs = dbi.dict_cursor(conn) sql = 'select * from employee1 where email = %s' vals = [email] curs.execute(sql, vals)
'''URL for profiles on network, visible to other users.''' @app.route("/profile/<userID>") def alumnusPage(userID): conn = dbi.connect() profileInfo = sqlOperations.profileInfo(conn, userID) return render_template("alumnus.html", result=profileInfo) if __name__ == '__main__': import sys, os if len(sys.argv) > 1: # arg, if any, is the desired port number print(sys.argv[1]) port = int(sys.argv[1]) assert (port > 1024) if not (1943 <= port <= 1950): print('For CAS, choose a port from 1943 to 1950') sys.exit() else: port = os.getuid() cnf = dbi.cache_cnf() # defaults to ~/.my.cnf dbi.use(nameDB) conn = dbi.connect() app.debug = True app.run('0.0.0.0', port)
def init_db(): dbi.cache_cnf() dbi.use('techship_db')
return render_template('form_data.html', method=request.method, form_data={}) @app.route('/testform/') def testform(): return render_template('testform.html') if __name__ == '__main__': import sys, os 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() # the following database code works for both PyMySQL and SQLite3 dbi.cache_cnf() dbi.use('wmdb') conn = dbi.connect() curs = dbi.dict_cursor(conn) # the following query works for both MySQL and SQLite curs.execute('select current_timestamp as ct') row = curs.fetchone() ct = row['ct'] print('connected to WMDB at {}'.format(ct)) app.debug = True app.run('0.0.0.0', port)
song id, title, artist, and album for a song in that genre ''' curs = dbi.dict_cursor(conn) genre = '%' + genre + '%' curs.execute( '''select song_id, song_title, artist_name, artist_id, album_title, album_id from coda_song join coda_album using(album_id) join coda_artist using(artist_id) where coda_song.genre like %s''', [genre]) genreDictList = curs.fetchall() return genreDictList # ========================================================== # This starts the ball rolling, *if* the file is run as a # script, rather than just being imported. if __name__ == '__main__': dbi.cache_cnf() # defaults to ~/.my.cnf dbi.use('coda_db') conn = dbi.connect() # songInfo = get_song(conn, 1) # genres = get_genres(conn) # print(genres) # countrySongs = songs_by_genre(conn, 'Christmas') # print(countrySongs)
def init_db(): dbi.cache_cnf() dbi.use('foodie_db') # or whatever db
def startup(): dbi.cache_cnf() dbi.use('zipvote_db')
results = curs.fetchall() return results def allowed_file(filename): '''Helper function for uploadSyllabus that checks if the file is a pdf''' return '.' in filename and \ filename.rsplit('.', 1)[1].lower() in ALLOWED_EXTENSIONS def saveToDB(x, aFile): '''Helper function for uploadSyllabus that puts the file name in the database''' try: conn = dbi.connect() curs = dbi.dict_cursor(conn) curs.execute( ''' INSERT into syllabi(cid, filename) VALUES (%s, %s) ON DUPLICATE KEY UPDATE filename = %s''', [x, aFile, aFile]) conn.commit() flash('Upload successful') except Exception as err: flash('Upload failed {why}'.format(why=err)) if __name__ == '__main__': dbi.cache_cnf() # defaults to ~/.my.cnf dbi.use('syllabo_db') conn = dbi.connect()
def init_db(): dbi.cache_cnf() dbi.use('coda_db')
from flask import (Flask, render_template, make_response, url_for, request, redirect, flash, session, send_from_directory, jsonify) from werkzeug.utils import secure_filename import pymysql import cs304dbi as dbi dsn = dbi.cache_cnf() dbi.use('whealth_db') app = Flask(__name__) import random app.secret_key = 'your secret here' # replace that with a random key app.secret_key = ''.join([ random.choice(('ABCDEFGHIJKLMNOPQRSTUVXYZ' + 'abcdefghijklmnopqrstuvxyz' + '0123456789')) for i in range(20) ]) # This gets us better error messages for certain common request errors app.config['TRAP_BAD_REQUEST_ERRORS'] = True staffID = 1409 @app.route('/') def index(): return render_template('main.html') @app.route('/suggest/', methods=["GET", "POST"])
def is_username_unique(conn, username): # Checks if username is unique while user is registering. curs = dbi.cursor(conn) sql = '''select * from user where uid = %s;''' result = curs.execute(sql, [username]) conn.commit() if result == None: #username doesn't exist in db, so we can continue with registration return False else: return True if __name__ == '__main__': dbi.cache_cnf() # defaults to ~/.my.cnf dbi.use('techship_db') conn = dbi.connect() # print("By Company:") # print(getByCompany(conn,"Google")) # print("By Role:") # print(getByRole(conn,"Software Engineering")) # print("By Experience:") # fav = handleFavorite('jamie', 'https://careers.google.com/jobs/results/100877793807475398-software-engineering-intern-associates-summer-2021/') # test = getFavorites(conn, 'jamie') # print(test) # print(getByExperience(conn, "Senior")) # insertApplication("http://www.test.com","test","Data Science","Fall","2022","Freshman") # insertCompany("test2")
def init_db(): dbi.cache_cnf() dbi.use('sclark4_db') # or whatever db
def startup(): dbi.cache_cnf() dbi.use('tbanerji_db')
def init_db(): dbi.cache_cnf() dbi.use('housemate_db')
''' SELECT user.name,`datetime`,content,title FROM post INNER JOIN user ON user.userID=authorID WHERE post.content like %s or post.title like %s; ''', ['%' + keyword + "%", '%' + keyword + "%"]) return curs.fetchall() def updatePost(conn, postID, title, content): '''Edits post with specified postID and given information.''' curs = dbi.dict_cursor(conn) curs.execute( ''' UPDATE post SET title=%s, content=%s WHERE postID=%s;''', [title, content, postID]) conn.commit() def deletePost(conn, postID): '''Deletes post with specified postID.''' curs = dbi.dict_cursor(conn) curs.execute(''' DELETE from post WHERE postID=%s ''', [postID]) conn.commit() if __name__ == '__main__': dbi.cache_cnf() dbi.use('wcscdb_db') conn = dbi.connect()