def account_createtable():
form = CreateTableForm()
if form.validate_on_submit():
tableid = db.add_table(form.tablenumber.data, current_user.get_id())
new_url = BH.shorten_url(config.base_url + "newrequest/" +
str(tableid))
db.update_table(tableid, new_url)
return redirect(url_for('account'))
return render_template('account.html',
createtable=form,
tables=db.get_tables(current_user.get_id()))
def account_createtable():
form = CreateTableForm(request.form)
if form.validate_on_submit():
tablename = form.tablenumber.data
tableid = DB.add_table(tablename, current_user.get_id())
new_url = config.base_url + "newrequest/" + str(tableid)
DB.update_table(tableid, BH.shorten_url(new_url))
return redirect(url_for('account'))
else:
return render_template("account.html",
user=current_user.get_id(),
createtableform=form,
deletetableform=DeleteTableForm(),
table=DB.get_tables(current_user.get_id()))
def createtable():
form = CreateTableForm()
create_table = form.createtable.data
if not create_table:
return flask.render_template('querydetails.html',form = form)
else:
try:
if form.validate_on_submit():
# This creates the table
db.engine.execute(create_table)
# This gets all the table names in the schema
Tables_Query = "SELECT table_name FROM information_schema.tables WHERE table_schema = 'public';"
result = db.engine.execute(Tables_Query)
rows = map(list,result)
result_set = []
for row in rows:
tuple = [str(x) for x in row]
result_set.append(tuple)
flash("Table Creation Successfull !")
return flask.render_template('querydetails.html',form = form,result = result_set)
except Exception:
flash("Something Wrong With The Create Table Query")
return flask.render_template('querydetails.html',form = form)
