Python Query.into方法代码示例

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_columns_from_star(self):
        query = Query.into(self.table_abc).columns(
              self.table_abc.foo, self.table_abc.bar, self.table_abc.buz,
        ).from_(self.table_efg).select('*')

        self.assertEqual('INSERT INTO "abc" ("foo","bar","buz") '
                         'SELECT * FROM "efg"', str(query))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_from_columns(self):
        query = Query.into(self.table_abc).from_(self.table_efg).select(
              self.table_efg.fiz, self.table_efg.buz, self.table_efg.baz
        )

        self.assertEqual('INSERT INTO "abc" '
                         'SELECT "fiz","buz","baz" FROM "efg"', str(query))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_all_columns_multi_rows_chained_mixed(self):
        query = Query.into(self.table_abc).insert(
              (1, 'a', True), (2, 'b', False)
        ).insert(3, 'c', True)

        self.assertEqual('INSERT INTO "abc" VALUES '
                         '(1,\'a\',true),(2,\'b\',false),'
                         '(3,\'c\',true)', str(query))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_join_table_on_insert_query(self):
        a, b, c = Tables('a', 'b', 'c')
        q = Query.into(c).from_(a) \
            .join(b).on(a.fkey_id == b.id) \
            .where(b.foo == 1) \
            .select('a.*', 'b.*')

        self.assertEqual('INSERT INTO "c" '
                         'SELECT "a"."a.*","a"."b.*" '
                         'FROM "a" JOIN "b" '
                         'ON "a"."fkey_id"="b"."id" '
                         'WHERE "b"."foo"=1', str(q))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_subquery_wrapped_in_brackets(self):
        purchase_order_item, part = Tables("purchase_order_item", "part")

        q = Query.into(purchase_order_item) \
            .columns(purchase_order_item.id_part, purchase_order_item.id_customer) \
            .insert(Query.from_(part)
                    .select(part.part_id)
                    .where(part.part_number == "FOOBAR"), 12345)

        self.assertEqual('INSERT INTO "purchase_order_item" '
                         '("id_part","id_customer") '
                         'VALUES '
                         '((SELECT "part_id" FROM "part" WHERE "part_number"=\'FOOBAR\'),12345)', str(q))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_columns_from_columns_with_join(self):
        query = Query.into(self.table_abc).columns(
              self.table_abc.c1, self.table_abc.c2, self.table_abc.c3, self.table_abc.c4
        ).from_(self.table_efg).select(
              self.table_efg.foo, self.table_efg.bar
        ).join(self.table_hij).on(
              self.table_efg.id == self.table_hij.abc_id
        ).select(
              self.table_hij.fiz, self.table_hij.buz
        )

        self.assertEqual('INSERT INTO "abc" ("c1","c2","c3","c4") '
                         'SELECT "efg"."foo","efg"."bar","hij"."fiz","hij"."buz" FROM "efg" '
                         'JOIN "hij" ON "efg"."id"="hij"."abc_id"', str(query))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_none_skipped(self):
        query = Query.into(self.table_abc).insert()

        self.assertEqual('', str(query))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_ignore(self):
        query = Query.into(self.table_abc).insert(1).ignore()

        self.assertEqual('INSERT IGNORE INTO "abc" VALUES (1)', str(query))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_one_column(self):
        query = Query.into(self.table_abc).insert(1)

        self.assertEqual('INSERT INTO "abc" VALUES (1)', str(query))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_selected_columns(self):
        query = Query.into(self.table_abc).columns(
              self.table_abc.foo, self.table_abc.bar, self.table_abc.buz
        ).insert(1, 'a', True)

        self.assertEqual('INSERT INTO "abc" ("foo","bar","buz") VALUES (1,\'a\',true)', str(query))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_all_columns_single_element(self):
        query = Query.into(self.table_abc).insert((1, 'a', True))

        self.assertEqual('INSERT INTO "abc" VALUES (1,\'a\',true)', str(query))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_all_columns_multi_rows(self):
        query = Query.into(self.table_abc).insert((1, 'a', True), (2, 'b', False))

        self.assertEqual('INSERT INTO "abc" VALUES (1,\'a\',true),(2,\'b\',false)', str(query))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_multiple_rows_with_array_value(self):
        query = Query.into(self.table_abc).insert((1, ['a', 'b', 'c']),
                                                  (2, ['c', 'd', 'e']), )

        self.assertEqual('INSERT INTO "abc" '
                         'VALUES (1,[\'a\',\'b\',\'c\']),(2,[\'c\',\'d\',\'e\'])', str(query))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_one_column_multi_element_array(self):
        query = Query.into(self.table_abc).insert((1,), (2,))

        self.assertEqual('INSERT INTO "abc" VALUES (1),(2)', str(query))

# 需要导入模块: from pypika import Query [as 别名]
# 或者: from pypika.Query import into [as 别名]
    def test_insert_null(self):
        query = Query.into(self.table_abc).insert(None)

        self.assertEqual('INSERT INTO "abc" VALUES (NULL)', str(query))