本文整理汇总了Python中querybuilder.query.Query.get_insert_sql方法的典型用法代码示例。如果您正苦于以下问题：Python Query.get_insert_sql方法的具体用法？Python Query.get_insert_sql怎么用？Python Query.get_insert_sql使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类querybuilder.query.Query的用法示例。
在下文中一共展示了Query.get_insert_sql方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Python代码示例。
示例1: test_insert_single_row
# 需要导入模块: from querybuilder.query import Query [as 别名]
# 或者: from querybuilder.query.Query import get_insert_sql [as 别名]
def test_insert_single_row(self):
G(User, id=1)
query = Query().from_table(
table=Account,
fields=[
'user_id',
'first_name',
'last_name'
]
)
rows = [
[1, 'Test', 'User']
]
sql, sql_params = query.get_insert_sql(rows)
self.assertEqual(
sql,
(
'INSERT INTO tests_account (user_id, first_name, last_name) VALUES (%s, %s, %s)'
)
)
self.assertEqual(sql_params[0], 1)
self.assertEqual(sql_params[1], 'Test')
self.assertEqual(sql_params[2], 'User')
query.insert(rows)
sql = self.logger.get_log()[2]['sql']
self.assertEqual(sql, "INSERT INTO tests_account (user_id, first_name, last_name) VALUES (1, 'Test', 'User')")示例2: test_insert_multiple_rows
# 需要导入模块: from querybuilder.query import Query [as 别名]
# 或者: from querybuilder.query.Query import get_insert_sql [as 别名]
def test_insert_multiple_rows(self):
query = Query().from_table(
table=Account,
fields=[
'user_id',
'first_name',
'last_name'
]
)
rows = [
[1, 'Test', 'User'],
[2, 'Test2', 'User2'],
]
sql, sql_params = query.get_insert_sql(rows)
self.assertEqual(
sql,
'INSERT INTO tests_account (user_id, first_name, last_name) VALUES (%s, %s, %s), (%s, %s, %s)'
)
self.assertEqual(sql_params[0], 1)
self.assertEqual(sql_params[1], 'Test')
self.assertEqual(sql_params[2], 'User')
self.assertEqual(sql_params[3], 2)
self.assertEqual(sql_params[4], 'Test2')
self.assertEqual(sql_params[5], 'User2')
query.insert(rows)
sql = self.logger.get_log()[0]['sql']
self.assertEqual(
sql,
("INSERT INTO tests_account (user_id, first_name, last_name) "
"VALUES (1, 'Test', 'User'), (2, 'Test2', 'User2')")
)