def getManufactureNull(self): products = Table('products', 'eg_product_staging') q = Query.from_(products).select('*').where( fn.IsNull(products.manufacturer_id) | products.manufacturer_id == '') records = self.db.fetchall(q.get_sql()) return records
def getProductNotTitle(self): products = Table('products', 'eg_product_staging') product_translations = Table('product_translations', 'eg_product_staging') mst_rc_syouhin_multi = Table('mst_rc_syouhin_multi', 'rc_products_multi') q = Query.from_(products).join( product_translations, how=JoinType.left ).on(products.id == product_translations.product_id).join( mst_rc_syouhin_multi, how=JoinType.left).on( products.sku == mst_rc_syouhin_multi.syouhin_sys_code).select( products.sku, product_translations.locale, product_translations.name, products.name, mst_rc_syouhin_multi.name.as_('sync_multi_name')).where( fn.IsNull(product_translations.name) & products.active == 1) records = self.db.fetchall(q.get_sql()) return records
def test_isnull(self): q = Q.from_('abc').select(fn.IsNull(F('foo'))) self.assertEqual('SELECT ISNULL(\"foo\") FROM \"abc\"', str(q))
def test_function_xor(self): c1 = fn.IsNull(Field("foo")) ^ (Field("bar") == 2) self.assertEqual('ISNULL("foo") XOR "bar"=2', str(c1))
def test_function_and(self): c1 = fn.IsNull(Field("foo")) & (Field("bar") == 2) self.assertEqual('ISNULL("foo") AND "bar"=2', str(c1))
def test_function_or(self): c1 = fn.IsNull(Field('foo')) | (Field('bar') == 2) self.assertEqual('ISNULL("foo") OR "bar"=2', str(c1))
def test_isnull(self): q = Q.from_("abc").select(fn.IsNull(F("foo"))) self.assertEqual('SELECT ISNULL("foo") FROM "abc"', str(q))