def insert(): db_class = DBUtil.Database() sql = "INSERT INTO testDB.testTable(test) \ VALUES('%s')" % ('testData') db_class.execute(sql) db_class.commit() return render_template('register.html', result='insert is done!', resultData=None, resultUPDATE=None)
def select(): db_class = DBUtil.Database() sql = "SELECT idx, test \ FROM testDB.testTable" row = db_class.executeAll(sql) print(row) return render_template('find.html', result=None, resultData=row[0], resultUPDATE=None)
def update(): db_class = DBUtil.Database() sql = "UPDATE testDB.testTable \ SET test='%s' \ WHERE test='testData'" % ('update_Data') db_class.execute(sql) db_class.commit() sql = "SELECT idx, test \ FROM testDB.testTable" row = db_class.executeAll(sql) return render_template('update.html', result=None, resultData=None, resultUPDATE=row[0])