def add(): email = request.form["email"] print fname #cmd = "insert into EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) VALUES (?,?,?,?,?)",(fname,lname,age,sex,income)) cmd = "insert into EMPLOYEE(emailId) VALUES ('%s')" %(email)) conn, cursor = querydb.conn() status = querydb.insert(cmd,conn, cursor) return status
def add(): fname = request.form["firstname"] print fname lname = request.form["lastname"] age = request.form["age"] sex = request.form["sex"] income = request.form["income"] #cmd = "insert into EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) VALUES (?,?,?,?,?)",(fname,lname,age,sex,income)) cmd = "insert into EMPLOYEE(FIRST_NAME, LAST_NAME, AGE, SEX, INCOME) VALUES ('%s','%s',%d,'%s',%d)" %(fname,lname,int(age),sex,long(income)) conn, cursor = querydb.conn() status = querydb.insert(cmd,conn, cursor) return status
def show(): #pdb.set_trace() retValue = [] user_name = request.form["username"] if user_name in ['All','all','ALL']: #if re.search ('^All$', user_name, re.I) != None: cmd = '''select * from EMPLOYEE''' else: print "else path" print user_name cmd = """select * from EMPLOYEE where FIRST_NAME = '%s'""" %(user_name) conn, cursor = querydb.conn() results = querydb.show(cmd,conn,cursor) #return "ok" for row in results: FIRST_NAME = row[0] LAST_NAME = row[1] AGE = row[2] SEX = row[3] INCOME = row[4] retValue.append("FIRST_NAME=%s, LAST_NAME=%s, AGE=%d, SEX=%s, INCOME=%d " % \ (FIRST_NAME,LAST_NAME,AGE,SEX,INCOME)) return str(retValue)