def batch_insert(conn, cur): users = [] u1 = User('a', 11, 99) u2 = User('b', 12, 100) users.append(u1) users.append(u2) success = User.batch_insert(conn, cur, users) print('成功插入' + s(success) + '条用户数据')
def get_single(cur, id): user = User.get_by_id(cur, id) return user
def query(cur): user_list = User.get_all(cur) for user in user_list: user.info()
def insert(conn, cur): user_1 = User('煤球', 33) stat = user_1.save_user(conn, cur) print('插入成功' if stat > 0 else '插入失败')