def account_createtable():
form = CreateTableForm(request.form)
if form.validate():
tableid = DB.add_table(form.tablenumber.data, current_user.get_id())
new_url = BH.shorten_url(config.base_url + "newrequest/" + tableid)
DB.update_table(tableid, new_url)
return redirect(url_for('account'))
return render_template("account.html", createtableform=form, tables=DB.get_tables(current_user.get_id()))
def account_createtable():
form = CreateTableForm(request.form)
if form.validate():
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", createtableform=form, tables=DB.get_tables(current_user.get_id()))
def account_createtable():
form = CreateTableForm(request.form)
if form.validate():
tableid = DB.add_table(form.tablenumber.data, current_user.get_id())
new_url = Config.BASE_URL + 'newrequest/' + tableid
DB.update_table(tableid, new_url)
return redirect(url_for('account'))
return render_template('account.html', createtableform=form, tables=DB.get_tables(current_user.get_id()))
def account_createtable():
form = CreateTableForm(flask.request.form)
if form.validate():
DB.add_table(form.tablename.data, flask_login.current_user.get_id())
return flask.redirect(flask.url_for('account'))
return flask.render_template("account.html",
createtableform=form,
tables=DB.get_tables(
flask_login.current_user.get_id()))
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 account_createtable():
form = CreateTableForm(request.form)
if form.validate():
tableid = DB.add_table(form.tableNumber.data, current_user.get_id())
new_url = config.base_url + "/newrequest/" + tableid
DB.update_table(tableid, new_url)
return redirect(url_for('account'))
tablename = request.form.get("tablenumber")
tableid = DB.add_table(tablename, current_user.get_id())
new_url = config.base_url + "/newrequest/" + tableid
# new_url = BH.shortenUrl(new_urli) for bitly url shortening
DB.update_table(tableid, new_url)
return redirect(url_for('account'))
def account_createtable():
form = CreateTableForm(request.form)
if form.validate():
# We are using current_user method from FlaskLogin here.
tableid = DB.add_table(form.tablenumber.data, current_user.get_id())
# new_url = config.base_url + "newrequest/" + tableid
# We are using str(tableid) because we are using ObjectId for Mongo.
# This will ensure that tableid is always a string before we concatenate
# it to our URL.
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",
createTableForm=form,
tables=DB.get_tables(current_user.get_id()))
def account():
form_create_table = CreateTableForm()
form_delete_table = DeleteTableForm()
return render_template("account.html",
user=current_user.get_id(),
createtableform=form_create_table,
deletetableform=form_delete_table,
table=DB.get_tables(current_user.get_id()))
def account_deletetable():
form = DeleteTableForm(request.form)
if form.validate():
DB.delete_table(form.tablenumber.data)
return redirect(url_for('account'))
return render_template("account.html", createtableform=CreateTableForm(),
tables=DB.get_tables(current_user.get_id()),
deletetableform=form)
def account_createtable(): #This route function belongs to the account
form = CreateTableForm(
request.form) #request.form to get access to all form-fields
if form.validate():
tableid = DB.add_table(
form.tablenumber.data,
current_user.get_id()) #Flask Login function to get
#the id of the current user
new_url = BH.shorten_url(
config.base_url + "newrequest/" +
str(tableid)) #Creates the table URL shortend by bitly.
DB.update_table(tableid, new_url)
return redirect(url_for('account'))
return render_template("account.html",
createtableform=form,
tables=DB.get_tables(current_user.get_id()))
def account_deletetable():
form = DeleteTableForm(request.form)
print form.tableid.data
if form.validate():
DB.delete_table(form.tableid.data)
return redirect(url_for('account'))
# return render_template('account.html', deletetableform=form,
# tables=DB.get_table(current_user.get_id()))
return render_template('account.html',
createtableform=CreateTableForm(),
deletetableform=form,
tables=DB.get_table(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)
def database(database_name: str):
edit_table_form = EditDeleteTableForm()
create_table_form = CreateTableForm()
join_tables_form = JoinTablesForm()
try:
if request.method == 'POST':
if _edit_table_button in request.form:
return redirect(url_for('table',
database_name=database_name,
table_name=edit_table_form.edit_delete_table_name.data
))
except Exception as e:
flash(f'Exception occurred: {str(e)}', 'danger')
return render_template(_database_template,
edit_table_form=edit_table_form,
create_table_form=create_table_form,
join_tables_form=join_tables_form)
def account():
tables = DB.get_tables(flask.ext.login.current_user.get_id())
return render_template("account.html",
tables=tables,
createtableform=CreateTableForm())
def account():
tables = DB.get_tables(current_user.get_id())
return render_template("account.html",
createtableform=CreateTableForm(),
tables=tables,
routing_prefix=config.routing_prefix)
def account():
return render_template('account.html',
createtableform=CreateTableForm(),
tables=db.get_tables(current_user.get_id()))
def account():
tables = DB.get_tables(current_user.get_id())
return render_template("account.html",
createtableform=CreateTableForm(),
tables=tables)
def account():
return flask.render_template("account.html",
createtableform=CreateTableForm(),
tables=DB.get_tables(
flask_login.current_user.get_id()))
