def insertProduct():
if request.method == 'POST':
upload_file = request.files["file"]
image_data = upload_file.read()
nombre=request.form['Nombre'].encode("UTF-8")
marca=request.form['Marca'].encode("UTF-8")
descripcion=request.form['Descripcion'].encode("UTF-8")
cantidad=request.form['Cantidad'].encode("UTF-8")
costo=request.form['Costo'].encode("UTF-8")
precioFinal=request.form['PrecioFinal'].encode("UTF-8")
descuentoMaximo=request.form['DescuentoMaximo'].encode("UTF-8")
if image_data == "":
flash("Por favor seleccione una imagen")
else:
ex=("EXEC sp_insertarProducto "+
" @pNombre = '"+nombre+
"', @pMarca = '"+marca+
"', @pDescripcion = '"+descripcion+
"', @pCantidad = "+cantidad+
", @pCosto = """+costo+
", @pPrecioFinal = "+precioFinal+
", @pDescuentoMaximo = "+descuentoMaximo+
", @pFoto = '"+image_data.encode('hex_codec')+"'")
sqlCon = SQLConnection(current_user.userType, current_user.userid)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.execute(ex)
con.commit()
sqlCon.close(con)
return index()
return render_template('insertProduct.html')
def index():
sqlCon = SQLConnection("consulta", None,None)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('sp_consultarProductos')
DBproducts = []
for product in cursor:
product['Foto'] = base64.b64encode(product['Foto'])
DBproducts.append(product)
if request.method == 'POST':
try:
productId = request.values.get('idProduct')
opcion=request.values.get('opcion')
if (opcion == "1"):
return redirect(url_for('verRecetas',id=productId))
elif (opcion ==2):
return redirect(url_for('editarRecetas',id=productId))
else:
return redirect(url_for('modifyProduct',id=productId))
except Exception as e:
return render_template('index.html', products=DBproducts)
return render_template('index.html', products=DBproducts)
def checkLogin(user):
try:
sqlCon = SQLConnection(user.userType, user.userid)
con = sqlCon.connect()
return True
except:
return False
def dbModifyParticipant(userType, userId,alias, name, lastName,email,address):
sqlCon = SQLConnection(userType, userId)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspModifyParticipantData', (alias, name, lastName,address,email,))
checkError(cursor,"Participant Modified Successfully!")
con.commit()
sqlCon.close(con)
def dbActivateAgent(userType, userId, alias):
sqlCon = SQLConnection(userType, userId)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspAllowAgent', (alias,))
checkError(cursor,"Agent Activated!")
con.commit()
sqlCon.close(con)
def dbSetUpSystem(userType,userId,commission,minimumIncrease):
sqlCon = SQLConnection(userType, userId)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspSetSystemParameters', (commission,minimumIncrease,))
checkError(cursor,"Values Successfully updated to DB!")
con.commit()
sqlCon.close(con)
def dbSuspendParticipant(userType, userId, alias):
sqlCon = SQLConnection(userType, userId)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspSuspendParticipant', (alias,))
checkError(cursor,"Participant Suspended!")
con.commit()
sqlCon.close(con)
def dbNewParticipant(userType,userId,name, lastName, alias,
password,address,personalId,email):
sqlCon = SQLConnection(userType, userId)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspNewParticipant', (alias,password, name, lastName,address,personalId,email,))
checkError(cursor,"Participant Successfully added to DB!")
con.commit()
sqlCon.close(con)
def dbComment(userType, alias, comment, auctionId):
sqlCon = SQLConnection(userType, alias)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspNewComment', (alias,comment,
auctionId,))
con.commit()
checkError(cursor,"Your comment was added")
sqlCon.close(con)
def dbPlaceBid(userType, itemId, alias, newBid):
sqlCon = SQLConnection(userType)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspNewBid', (itemId, alias,newBid,))
checkError(cursor,"Your bid for " + newBid + " was successfull!")
con.commit()
sqlCon.close(con)
def dbNewAdmin(userType,userId,name, lastName, alias,
password,address,personalId):
sqlCon = SQLConnection(userType, userId)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspAddNewAdmin', (alias,password, name, lastName,address,personalId,))
checkError(cursor,"Admin Successfully added to DB!")
con.commit()
sqlCon.close(con)
def use_token(self, username):
obj = SQLConnection()
token = obj.get_plaid_token(username)
self.client = Client(client_id='57cccae6cfbf49f67b01fd5a',
secret='2c13981884395fc691fda11148ed67',
access_token=token)
response = self.client.connect_get(token)
self.plaid_results = response.content
return response.content
def __init__(self, f_id):
db = SQLConnection()
feed_info = db.get_feed(f_id)
self.previous_frame = None
if feed_info:
self.url = feed_info["url"]
self.vid_cap = cv2.VideoCapture(self.url)
self.exist = True
else:
self.exist = False
def get_photo(userType,id):
sqlCon = SQLConnection(userType)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('sp_getPhoto', (id,))
for row in cursor:
byteString = row['Foto']
sqlCon.close(con)
return byteString
def dbRePublishListing(userType, alias, auctionId,
description, listingEndDate, startingPrice):
sqlCon = SQLConnection(userType, alias)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspRestartAuction', (alias,auctionId, description, listingEndDate,startingPrice,))
checkError(cursor,"Listing had been added!")
con.commit()
sqlCon.close(con)
def dbAddCard(userType,userId,alias, cardNumber, securityCode,
cardName, expirationDate):
sqlCon = SQLConnection(userType, userId)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspAddCard', (alias,securityCode,
cardNumber, cardName,expirationDate,))
checkError(cursor,"Card added Successfully!")
con.commit()
sqlCon.close(con)
def dbNewListing(userType, alias,
description, category, subCategory, listingEndDate, startingPrice, image):
sqlCon = SQLConnection(userType, alias)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspNewAuction', (alias, description, category,
subCategory, listingEndDate,startingPrice,image,))
checkError(cursor,"Listing had been added!")
con.commit()
sqlCon.close(con)
def dbAddPhones(userType,userId,alias,phones):
sqlCon = SQLConnection(userType, userId)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
for phone in phones:
if phone!="":
cursor.callproc('uspAddPhoneNumber', (alias,phone,))
if len(phones)!=0:
checkError(cursor,"Phones were added to the DB!")
else:
checkError(cursor,"")
con.commit()
sqlCon.close(con)
def dbBids(userType, alias, itemId):
sqlCon = SQLConnection(userType, alias)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspViewBidsForAnAuction', (itemId,alias,))
pastBids = []
for row in cursor:
pastBids.append(row)
checkError(cursor,"")
sqlCon.close(con)
return pastBids
def checkLogin(alias, password):
result = False
sqlCon = SQLConnection()
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspCheckLogin', (alias,password,))
for row in cursor:
if row['EXITO'] == 1:
result = True
sqlCon.close(con)
return result
def editarRecetas(id):
if request.method == 'POST':
nombre=request.form['Nombre'].encode("UTF-8")
descripcion=request.form['Descripcion'].encode("UTF-8")
sqlCon = SQLConnection(current_user.userType, current_user.userid)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('sp_modificarReceta',(id,nombre,descripcion))
con.commit()
sqlCon.close(con)
sqlCon = SQLConnection(current_user.userType, current_user.userid)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('sp_obtenerReceta',(id,))
for receta in cursor:
DBReceta = receta
sqlCon.close(con)
return render_template('editarReceta.html',receta=DBReceta)
def calculate_social(self):
db=SQLConnection()
db.daily_xp_difference()
db.update_score_si()
db.set_last_day_xp_to_xp()
#social().calculate_social()
# def hash_password(password):
# # uuid is used to generate a random number
# salt = uuid.uuid4().hex
# return hashlib.sha256(salt.encode() + password.encode()).hexdigest() + ':' + salt
# def check_password(hashed_password, user_password):
# password, salt = hashed_password.split(':')
# return password == hashlib.sha256(salt.encode() + user_password.encode()).hexdigest()
# # new_pass = raw_input('Please enter a password: '******'The string to store in the db is: ' + hashed_password)
# old_pass = raw_input('Now please enter the password again to check: ')
# if check_password(hashed_password, old_pass):
# print('You entered the right password')
# else:
# print('I am sorry but the password does not match')
def getFailedAuctionsByUser(userType, userId):
listings = []
if userType == 'participant':
sqlCon = SQLConnection(userType, userId)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
#get all listings
cursor.callproc('uspViewFailedAuctions', (userId,))
for row in cursor:
listings.append(row)
checkError(cursor,"")
sqlCon.close(con)
return listings
def modifyProduct(id):
sqlCon = SQLConnection(current_user.userType, current_user.userid)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('sp_obtenerProducto',(id,))
for product in cursor:
product['Foto'] = base64.b64encode(product['Foto'])
DBproduct = product
if request.method == 'POST':
upload_file = request.files["file"]
image_data = upload_file.read()
nombre=request.form['Nombre'].encode("UTF-8")
marca=request.form['Marca'].encode("UTF-8")
descripcion=request.form['Descripcion'].encode("UTF-8")
cantidad=request.form['Cantidad'].encode("UTF-8")
costo=request.form['Costo'].encode("UTF-8")
precioFinal=request.form['PrecioFinal'].encode("UTF-8")
descuentoMaximo=request.form['DescuentoMaximo'].encode("UTF-8")
if image_data == "":
ex=("EXEC sp_modificarProducto "+
"@pIdProducto = "+id+
", @pNombre = '"+nombre+
"', @pMarca = '"+marca+
"', @pDescripcion = '"+descripcion+
"', @pCantidad = "+cantidad+
", @pCosto = """+costo+
", @pPrecioFinal = "+precioFinal+
", @pDescuentoMaximo = "+descuentoMaximo)
else:
ex=("EXEC sp_modificarProducto "+
"@pIdProducto = "+id+
", @pNombre = '"+nombre+
"', @pMarca = '"+marca+
"', @pDescripcion = '"+descripcion+
"', @pCantidad = "+cantidad+
", @pCosto = """+costo+
", @pPrecioFinal = "+precioFinal+
", @pDescuentoMaximo = "+descuentoMaximo+
", @pFoto = '"+image_data.encode('hex_codec')+"'")
sqlCon = SQLConnection(current_user.userType, current_user.userid)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.execute(ex)
con.commit()
sqlCon.close(con)
sqlCon = SQLConnection(current_user.userType, current_user.userid)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('sp_obtenerProducto',(id,))
for product in cursor:
product['Foto'] = base64.b64encode(product['Foto'])
DBproduct = product
return render_template('modifyProduct.html',product=DBproduct)
return render_template('modifyProduct.html',product=DBproduct)
def getWinningListingsByUser(user, userId, userType):
if user == "----":
user = None
listings = []
sqlCon = SQLConnection(userType, userId)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
#get all listings
cursor.callproc('uspViewWonAuctionHistory', (user,userId,))
for row in cursor:
listings.append(row)
checkError(cursor,"")
sqlCon.close(con)
return listings
def GetNewAccessToken(self, RefToken, username):
print "Getting a new access token"
#Form the data payload
BodyText = {'grant_type': 'refresh_token', 'refresh_token': RefToken}
#URL Encode it
BodyURLEncoded = urllib.urlencode(BodyText)
print "Using this as the body when getting access token >>" + BodyURLEncoded
#Start the request
tokenreq = urllib2.Request(self.TokenURL, BodyURLEncoded)
#Add the headers, first we base64 encode the client id and client secret with a : inbetween and create the authorisation header
tokenreq.add_header(
'Authorization',
'Basic ' + base64.b64encode(self.OAuthTwoClientID + ":" +
self.ClientOrConsumerSecret))
tokenreq.add_header('Content-Type',
'application/x-www-form-urlencoded')
#Fire off the request
try:
db = SQLConnection()
tokenresponse = urllib2.urlopen(tokenreq)
#See what we got back. If it's this part of the code it was OK
FullResponse = tokenresponse.read()
#Need to pick out the access token and write it to the config file. Use a JSON manipluation module
ResponseJSON = json.loads(FullResponse)
#Read the access token as a string
NewAccessToken = str(ResponseJSON['access_token'])
NewRefreshToken = str(ResponseJSON['refresh_token'])
#Write the access token to the ini file
db.update_fitbit_acc_token(username, NewAccessToken,
NewRefreshToken)
#self.WriteConfig(NewAccessToken,NewRefreshToken) #HERE YOU GO ROOS LOOK HERE BUDDY LOOK LOOK LOOK ################)
print "New access token output >>> " + FullResponse
except urllib2.URLError as e:
#Gettin to this part of the code means we got an error
print "An error was raised when getting the access token. Need to stop here"
print e.code
print e.read()
sys.exit()
def newListing():
sqlCon = SQLConnection(current_user.userType, current_user.userid)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspViewCategories')
cate1 = []
cate2 = []
for row in cursor:
if (row['category']) not in cate1:
cate1.append(row['category'])
if (row['subCategory']) not in cate2:
cate2.append(row['subCategory'])
#close connection
sqlCon.close(con)
cate1.sort()
cate2.sort()
if request.method == 'POST':
category1 = request.form['category1']
category2 = request.form['category2']
description = request.form['description']
listingEndDate = request.form['listingEndDate']
listingEndTime = request.form['listingEndTime']
startingPrice = request.form['startingPrice']
image = request.form['img']
listingEndDate = fixDate(listingEndDate, listingEndTime)
print listingEndDate
try:
dbNewListing(current_user.userType, current_user.userid,
description, category1, category2, listingEndDate,
startingPrice, image)
except Exception as e:
print e
flash(errorMsj)
return render_template('newListing.html', cate1=cate1, cate2=cate2)
def insertarReceta():
if request.method == 'POST':
nombre=request.form['Nombre'].encode("UTF-8")
descripcion=request.form['Descripcion'].encode("UTF-8")
nombreProducto=request.form['NombreProducto'].encode("UTF-8")
ex=("EXEC sp_insertarReceta "+
" @pNombre = '"+nombre+
"', @pNombreProducto = '"+nombreProducto+
"', @pDescripcion = '"+descripcion+"'")
sqlCon = SQLConnection(current_user.userType, current_user.userid)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.execute(ex)
con.commit()
sqlCon.close(con)
return index()
return render_template('insertarReceta.html')
def dbGetAgents(userType,userId, JustSuspended):
sqlCon = SQLConnection(userType, userId)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
if JustSuspended==0:
cursor.callproc('uspGetAgents',(0,))
elif JustSuspended==1:
cursor.callproc('uspGetAgents',(1,))
else:
cursor.callproc('uspGetAgents',(2,))
agents = []
for row in cursor:
agents.append(row['Alias'])
checkError(cursor,"")
#close connection
sqlCon.close(con)
return agents
def getUserType(alias):
sqlCon = SQLConnection()
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('upsGetKindOfUser', (alias,))
for row in cursor:
if row['Exito'] == 0:
sqlCon.close(con)
return None
elif row['Administrator'] == 1:
sqlCon.close(con)
return 'admin'
elif row['Agent'] == 1:
sqlCon.close(con)
return 'agent'
elif row['Participant'] == 1:
sqlCon.close(con)
return 'participant'
def first_time_plaid_transactions(
self, username
): # add all plaid transactions that already occured into db
obj = SQLConnection()
id = obj.find_id_of_user(username)
data = self.use_token(username)
data = json.loads(data)
for items in data['transactions']:
add = False
try:
for things in items["category"]:
if things == "Fast Food" or things == "Restaurants":
add = True
except:
pass
if add == True:
obj.add_plaid_transactions_in_db(
id, items["_id"]
) #adds the transaction id of any restraunts/fast_food
def verRecetas(id):
sqlCon = SQLConnection('consulta', None)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('sp_consultarRecetas',(id,))
DBRecetas = []
for receta in cursor:
DBRecetas.append(receta)
if request.method == 'POST':
try:
recetaId = request.values.get('idReceta')
return redirect(url_for('editarRecetas',id=recetaId))
except Exception as e:
return render_template('index.html', products=DBproducts)
return render_template('verRecetas.html',recetas=DBRecetas)
def GetConfig(self, username):
print "Reading from the config file"
db = SQLConnection()
#Open the file
# FileObj = open(IniFile,'r')
# #Read first two lines - first is the access token, second is the refresh token
# AccToken = FileObj.readline()
# RefToken = FileObj.readline()
AccToken = db.get_fitbit_acc_token(username)
RefToken = db.get_fitbit_ref_token(username)
# #Close the file
# FileObj.close()
#See if the strings have newline characters on the end. If so, strip them
if (AccToken.find("\n") > 0):
AccToken = AccToken[:-1]
if (RefToken.find("\n") > 0):
RefToken = RefToken[:-1]
#Return values
return AccToken, RefToken
def dbGetParticipants(userType, userid,JustSuspended):
print 'user is type =' + userType
print 'Hola = '+ userid
sqlCon = SQLConnection(userType, userid)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
if JustSuspended==0:
cursor.callproc('uspGetParticipants',(0,))
elif JustSuspended==1:
cursor.callproc('uspGetParticipants',(1,))
else:
cursor.callproc('uspGetParticipants',(2,))
participants = []
error=False;
for row in cursor:
participants.append(row['Alias'])
checkError(cursor,"")
#close connection
sqlCon.close(con)
return participants
def csv_to_db(db_name):
# Create db object
db = open(f'data/{db_name}.db', 'w')
# Close file
db.close()
# Connect to created database
conn = SQLConnection(f'data/{db_name}.db')
# Get data from CSV using pandas
sea_level_data = pd.read_csv(f'data/{db_name}.csv')
# if_exists can be 'replace', 'append' or 'error' and defines behaviour when chosen table name already exists
# conn defines the db this table is being added to
sea_level_data.to_sql(db_name, conn, if_exists = 'replace', index = False)
# Define a queue
q = f'SELECT * FROM {db_name}'
# Iterate through connection printing each row
for r in conn.queue(q):
print(r)
def feeds(a_id):
db = SQLConnection()
feeds = db.get_area_feeds(a_id)
if not feeds:
return {"Error": "Could not area with given a_id"}, 404
return feeds
def count(a_id):
db = SQLConnection()
return db.get_counts(a_id, time_start=datetime.now() - timedelta(days=1))
def prediction(a_id):
db = SQLConnection()
return db.get_predictions(a_id, time_end=datetime.now() + timedelta(days=1))
def add_events_fitness(self):
db = SQLConnection()
users = db.get_all_users()
category = "fitness"
for username in users:
if db.is_fitbit_setup(username):
pet_name = db.find_pet_of_user(username)
xp_change = self.make_score_fitness(username)
type1 = 1
wore_fitbit = True
if xp_change == None:
db.insert_events(
username, category, "no_effect", 0,
"You did not sleep with your fitbit, so your score was uneffected",
type1)
wore_fitbit = False
if wore_fitbit:
db.change_xp(username, xp_change)
if xp_change <= -300:
message = "You have seriously harmed " + pet_name + " from neglagence yesterday. Make it up to " + pet_name + " by exercising today"
pet_status = "sick"
elif xp_change <= 100:
message = pet_name + " is sad from the lack of exercise yesterday"
pet_status = "sick"
elif xp_change <= 300:
message = pet_name + " got some exercise yesterday, but is still eager to play today "
pet_status = "happy"
else:
message = pet_name + " got plenty of exercise yesterday and as a result he is very happy! +" + str(
xp_change) + " xp"
pet_status = "happy"
print "added"
current_xp = db.get_xp(username)
db.insert_events(username, category, pet_status, xp_change,
message, type1, current_xp)
def make_score_sleep(self):
type = "sleep"
db = SQLConnection()
users = db.get_all_users()
for username in users:
if db.is_fitbit_setup(username):
pet_name = db.find_pet_of_user(username)
result = self.get_user_data(username, type)
print result
result = result['summary']['totalTimeInBed']
db.change_xp(username, result)
print result
db = SQLConnection()
current_xp = db.get_xp(username)
if result == 0:
db.insert_events(
username, "sleep", "home", 0,
"You did not sleep with your fitbit, so your score was uneffected",
"1", current_xp)
elif result <= 400:
db.insert_events(
username, "sleep", "tired", -250,
pet_name + " is tired from the lack of sleep. -250 xp",
"1", current_xp)
elif result <= 420:
db.insert_events(
username, "sleep", "tired", -125,
pet_name + " is tired from the lack of sleep. -250 xp",
"1", current_xp)
else:
db.insert_events(
username, "sleep", "home", 250, pet_name +
" feels great today! It must be from getting enough sleep. +250 xp",
"1", current_xp)
def create_user_plaid(self, username, account_type, bank_username,
bank_password):
try:
response = self.client.connect(account_type, {
'username': bank_username,
'password': bank_password
})
d = json.loads(response.content)
access_token = d["access_token"]
print access_token
except plaid_errors.PlaidError, e:
print e
else:
if response.status_code == 200:
#print response.content
db = SQLConnection()
db.first_time_plaid(username, access_token)
data = response.json()
elif response.status_code == 201:
print "yo"
# MFA required
try:
mfa_response = answer_mfa(response.json())
except plaid_errors.PlaidError, e:
print e
else:
print "@@@@@@@@@@@@@@@@@@"
# check for 200 vs 201 responses
# 201 indicates that additional MFA steps required
# db.close()
def check_plaid_event(
self,
username): #checks the database ids and plaid ids for differences
plaid_list = self.get_list_of_restraunt_transactions(username)
obj = SQLConnection()
user_id = obj.find_id_of_user(username)
database_list = obj.get_users_transactions(username)
test = list(set(plaid_list) - set(database_list))
if test != []: #if there is a difference aka update
data = self.plaid_results
data = json.loads(data)
for items in test:
for things in data['transactions']:
if things['_id'] == items:
fast_food = False
for classifications in things["category"]:
if classifications == "Fast Food":
fast_food = True
if fast_food == True:
obj.add_event_list(user_id, "1")
obj.add_plaid_transactions_in_db(
user_id, things['_id'])
obj.change_xp(username, -500)
else:
obj.add_event_list(user_id, "2")
obj.add_plaid_transactions_in_db(
user_id, things['_id'])
obj.change_xp(username, -250)
return "done"
# plaid().check_plaid_event("rwr21")
#plaid().check_plaid_event("rwr21")
# print type(response)
# print type (response.content)
# d = json.loads(response.content)
# #print d
# print type(d)
# # print response.content
# for items in d['transactions']:
# #TODO SQL DATABSE TO KEEP TRACK OF LVL FAST FOOD -200 restraunt -100
# # print items['date']
# try:
# for things in items['category']:
# fast_food=False
# if things=="Fast Food": #finds if user bought fast food
# fast_food=True
# #print items['name']
# if fast_food==False:
# for things in items['category']:
# if things=="Restaurants":
# print things
# print items['name']#finds name of restraunt that is not fast food
# except:
# pass
# #print items
# #print type (response.content.)
# # User connected
# data = response.json()
#
#rint SQLConnection().get_users_transactions("rwr21")
#plaid().first_time_plaid_transactions("rwr21")
#print plaid().use_token("rwr21")
#plaid().create_user("rwr21","chase","rratcliffe57",p)
#plaid().check_plaid_event("rwr21")
def areas():
# https://stackoverflow.com/questions/48218065/programmingerror-sqlite-objects-created-in-a-thread-can-only-be-used-in-that-sa
# using different connection and cursor instead of not checking same thread, in case of data corruption
db = SQLConnection()
return db.get_all_area()
def index():
sqlCon = SQLConnection(current_user.userType, current_user.userid)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
cursor.callproc('uspViewCategories')
cate1 = []
cate2 = []
# for row in cursor:
# for cat in cate1:
# if cat[0] != row['category']:
# cate2.append([row['category']])
# if (row['subCategory']) not in cat:
# cat.append(row['subCategory'])
#
# print cate1
for row in cursor:
if (row['category']) not in cate1:
cate1.append(row['category'])
if (row['subCategory']) not in cate2:
cate2.append(row['subCategory'])
#close connection
sqlCon.close(con)
cate1.sort()
cate2.sort()
if request.method == 'POST':
try: #if user selected newBid button
item = request.values.get('idItem')
#show them all past bids and let them bid
return redirect(url_for('bids', itemId=item))
except Exception as e:
category1 = request.form['category1']
category2 = request.form['category2']
if category1 == "----":
category1 = None
if category2 == "----":
category2 = None
sqlCon = SQLConnection(current_user.userType, current_user.userid)
con = sqlCon.connect()
cursor = con.cursor(as_dict=True)
#get all listings
cursor.callproc('uspViewAvailableAuctions', (current_user.userid,
category1, category2,))
entries = []
for row in cursor:
entries.append(row)
sqlCon.close(con)
return render_template('index.html',
entries=entries, cate1=cate1, cate2=cate2)
return render_template('index.html', cate1 = cate1, cate2 = cate2)
def feed(f_id):
db = SQLConnection()
feed = db.get_feed(f_id)
if not feed:
return {"Error": "Could not find the feed with given f_id"}, 404
return feed
