def batch_insert(conn, cur, users):
sql = "INSERT INTO t_user (name, age) VALUES "
for i in range(len(users)):
u_name = users[i].name
u_age = users[i].age
sql += "('{}','{}')".format(u_name, u_age) if i == len(users)-1 else "('{}','{}'),".format(u_name, u_age)
return mysql_util.operate(conn, cur, sql)
def modify_user(self, conn, cur):
sql = "UPDATE t_user SET name = '{_name}', age = '{_age}' WHERE id = {_id}".format(_name=s(self.name),
_age=i(self.age),
_id=i(self.id))
return mysql_util.operate(conn, cur, sql)
def delete_user(self, conn, cur):
sql = "DELETE FROM t_user WHERE id = {_id}".format(_id=self.id)
return mysql_util.operate(conn, cur, sql)
def save_user(self, conn, cur):
sql = "INSERT INTO t_user (name, age) VALUES ('{_name}','{_age}')".format(_name=self.name, _age=self.age)
return mysql_util.operate(conn, cur, sql)
def execute_sql(conn, cur, sql):
return mysql_util.operate(conn, cur, sql)
