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)