def do_insert(first_name, last_name, age, sex, income): try: db = DBUtils.db_connect() cursor = db.cursor() query = "insert into employee values(%s,%s,%s,%s,%s)" cursor.execute(query, (first_name, last_name, age, sex, income)) db.commit() print("insert success") except TypeError as e: db.rollback() print("insert failed, do rollback", e) finally: db.close() print("Insert Process Done")
def do_delete(first_name): try: db = DBUtils.db_connect() cursor = db.cursor() query = "delete from employee where username = %s" cursor.execute(query, first_name) db.commit() print("delete success") except TypeError as e: db.rollback() print("delete failed, do rollback", e) finally: db.close() print("Delete Process Done")
def do_update(first_name, age): try: db = DBUtils.db_connect() cursor = db.cursor() #query = "Update employee set age = "+age+ " where first_name= %s" #cursor.execute(query, age) query = "update employee set age = %s where first_name = %s" param = (age, first_name, "azda") cursor.execute(query, param) db.commit() print("update success") except TypeError as e: db.rollback() print("update failed, do rollback", e) finally: db.close() print("Update Process Done")
def do_search(): try: db = DBUtils.db_connect() cursor = db.cursor() query = "select * from employee" cursor.execute(query) result = cursor.fetchall() count = 0 for i in result: count += 1 print("Data ke : ", count) print("First Name : ", i[0]) print("Last Name : ", i[1]) print("Age : ", i[2]) print("Sex : ", i[3]) print("Income : ", i[4]) print("-----------------") except TypeError as e: print("searc failed ", e) finally: db.close()
''' Created on 8 Nov 2017 @author: DEV-SYB-AF ''' from utils import Constant from utils import DBUtils print(Constant.CONFIG_PATH) db = DBUtils.db_connect() #try: cursor = db.cursor() #insert #query = "insert into employee values(%s,%s,%s,%s,%s)" #cursor.execute(query,(1,2,3,4,5)) #db.commit() #select #query = "select * from employee where income > '%s'" #cursor.execute(query,300) #result = cursor.fetchall() #for row in result: # print(row[0],row[1],row[2],row[3],row[4]) #update #query = "update employee set age = 100 where first_name = %s" #cursor.execute(query, "azda") #db.commit()