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()))