def post(self):
schema = models.Schema()
schema.name = request.json.get('name')
schema.description = request.json.get('description')
schema.keywords = schema.name
if schema.name is not None:
schema.path = os.path.join(save_db_path, schema.name + '.db')
db.session.add(schema)
db.session.commit()
conn = sqlite3.connect(schema.path)
conn.close()
return {}, HTTP_Created
else:
return get_shortage_error_dic('name'), HTTP_Bad_Request
def post(self):
schema = models.Schema()
schema.name = request.json.get('name')
schema.description = request.json.get('description')
schema.keywords = schema.name
if schema.name is not None:
# schema.path = os.path.join(save_db_path + "\\\\", schema.name+'.db')
schema.path = r"D:\Code\Sql-Online-Judge-Server\db" + "\\" + schema.name + ".db"
print(schema.path)
db.session.add(schema)
db.session.commit()
conn = sqlite3.connect(schema.path)
conn.close()
return {}, HTTP_Created
else:
return get_shortage_error_dic('name'), HTTP_Bad_Request
def field_lengths(self, folder, program_type):
schema = models.Schema()
if program_type.lower() == 'stations':
maps = self._build_field_length_structure(schema.station)
elif program_type.lower() == 'results':
maps = self._build_field_length_structure(schema.result)
else:
raise Exception('flag must be stations or results')
for csv_file in self._csvs_on_disk(folder, program_type):
print 'processing {}'.format(csv_file)
with open(csv_file, 'r') as f:
data = csv.DictReader(f)
for row in data:
for key in maps.keys():
length = len(row[key])
if maps[key][1] < length:
maps[key][1] = length
return maps
global current_user
current_user = uid
viewbag_user = service.pulluser(uid)
viewbag_trans = service.pulltransactions(uid)
message=""
return render_template('viewuser.html', user = viewbag_user, transactions = viewbag_trans, message=message)
@app.route("/hub/<int:uid>",methods=['GET','POST'])
def hub(uid):
global current_user
if(current_user==uid):
if request.method == 'POST':
creds = request.form['amount']
uid2 = request.form['recipient']
user = current_user
message = service.pushtransaction(user,uid2,creds)
viewbag_user = service.pulluser(uid)
viewbag_trans = service.pulltransactions(uid)
return render_template('viewuser.html', user = viewbag_user, transactions = viewbag_trans, message = message)
else:
users = service.pullsenders(uid)
sender = service.pulluser(uid)
return render_template('hub.html', user=sender, ulist=users)
else:
return render_template('home.html')
if(__name__=="__main__"):
models.Schema()
app.run(debug=True)