def test_three_relations(self): sql = chained_join(self.Catalog.category, self.Category.sub_category, self.SubCategory.product) assert str(sql) == ( "category JOIN sub_category ON category._id = " "sub_category._category_id JOIN product ON sub_category._id = " "product._sub_category_id" )
def test_three_relations(self, Catalog, Category, SubCategory): sql = chained_join(Catalog.category, Category.sub_category, SubCategory.product) assert str(sql) == ( 'category JOIN sub_category ON category._id = ' 'sub_category._category_id JOIN product ON sub_category._id = ' 'product._sub_category_id')
def test_two_relations(self, Catalog, Category): sql = chained_join(Catalog.categories, Category.sub_categories) assert str(sql) == ( 'catalog_category JOIN category ON category._id = ' 'catalog_category.category_id JOIN category_subcategory ON ' 'category._id = category_subcategory.category_id JOIN ' 'sub_category ON sub_category._id = ' 'category_subcategory.subcategory_id')
def test_two_relations(self): sql = chained_join(self.Catalog.categories, self.Category.sub_categories) assert str(sql) == ( "catalog_category JOIN category ON category._id = " "catalog_category.category_id JOIN category_subcategory ON " "category._id = category_subcategory.category_id JOIN " "sub_category ON sub_category._id = " "category_subcategory.subcategory_id" )
def test_two_relations(self, Catalog, Category): sql = chained_join( Catalog.category, Category.sub_category ) assert str(sql) == ( 'category JOIN sub_category ON category._id = ' 'sub_category._category_id' )
def test_three_relations(self, Catalog, Category, SubCategory): sql = chained_join(Catalog.categories, Category.sub_categories, SubCategory.products) assert str(sql) == ( 'catalog_category JOIN category ON category._id = ' 'catalog_category.category_id JOIN category_subcategory ON ' 'category._id = category_subcategory.category_id JOIN sub_category' ' ON sub_category._id = category_subcategory.subcategory_id JOIN ' 'subcategory_product ON sub_category._id = ' 'subcategory_product.subcategory_id JOIN product ON product._id =' ' subcategory_product.product_id')
def test_three_relations(self): sql = chained_join(self.Catalog.categories, self.Category.sub_categories, self.SubCategory.products) assert str(sql) == ( "catalog_category JOIN category ON category._id = " "catalog_category.category_id JOIN category_subcategory ON " "category._id = category_subcategory.category_id JOIN sub_category" " ON sub_category._id = category_subcategory.subcategory_id JOIN " "subcategory_product ON sub_category._id = " "subcategory_product.subcategory_id JOIN product ON product._id =" " subcategory_product.product_id" )
def test_three_relations(self, Catalog, Category, SubCategory): sql = chained_join( Catalog.category, Category.sub_category, SubCategory.product ) assert str(sql) == ( 'category JOIN sub_category ON category._id = ' 'sub_category._category_id JOIN product ON sub_category._id = ' 'product._sub_category_id' )
def test_two_relations(self, Catalog, Category): sql = chained_join( Catalog.categories, Category.sub_categories ) assert str(sql) == ( 'catalog_category JOIN category ON category._id = ' 'catalog_category.category_id JOIN category_subcategory ON ' 'category._id = category_subcategory.category_id JOIN ' 'sub_category ON sub_category._id = ' 'category_subcategory.subcategory_id' )
def test_three_relations(self, Catalog, Category, SubCategory): sql = chained_join( Catalog.categories, Category.sub_categories, SubCategory.products ) assert str(sql) == ( 'catalog_category JOIN category ON category._id = ' 'catalog_category.category_id JOIN category_subcategory ON ' 'category._id = category_subcategory.category_id JOIN sub_category' ' ON sub_category._id = category_subcategory.subcategory_id JOIN ' 'subcategory_product ON sub_category._id = ' 'subcategory_product.subcategory_id JOIN product ON product._id =' ' subcategory_product.product_id' )
def test_two_relations(self): sql = chained_join(self.Catalog.category, self.Category.sub_category) assert str(sql) == ("category JOIN sub_category ON category._id = " "sub_category._category_id")
def test_simple_join(self): assert str(chained_join(self.Catalog.category)) == "category"
def test_simple_join(self, Catalog): assert str(chained_join(Catalog.categories)) == ( 'catalog_category JOIN category ON ' 'category._id = catalog_category.category_id' )
def test_two_relations(self, Catalog, Category): sql = chained_join(Catalog.category, Category.sub_category) assert str(sql) == ('category JOIN sub_category ON category._id = ' 'sub_category._category_id')
def test_simple_join(self, Catalog): assert str(chained_join(Catalog.category)) == 'category'
def test_two_relations(self): sql = chained_join(self.Catalog.categories, self.Category.sub_categories) assert str(sql) == ('category JOIN sub_category ON category._id = ' 'sub_category._category_id')
def test_simple_join(self, Catalog): assert str(chained_join(Catalog.categories)) == ( 'catalog_category JOIN category ON ' 'category._id = catalog_category.category_id')
def test_simple_join(self, Catalog): assert str(chained_join(Catalog.category)) == 'category'
def test_simple_join(self): assert str(chained_join(self.Catalog.categories)) == ( "catalog_category JOIN category ON " "category._id = catalog_category.category_id" )
def test_simple_join(self): assert str(chained_join(self.Catalog.categories)) == 'category'