def __init__(self): self.tab_post2catalog = CabPost2Catalog self.tab_catalog = CabCatalog self.tab_post = CabPost try: CabPost2Catalog.create_table() except: pass
def __init__(self): self.tab = CabPost2Catalog self.tab_post2catalog = CabPost2Catalog self.tab_catalog = CabCatalog self.tab_post = CabPost try: CabPost2Catalog.create_table() except: pass
def get_by_info(self, post_id, catalog_id): recs = CabPost2Catalog.select().where( (CabPost2Catalog.post == post_id) & (CabPost2Catalog.catalog == catalog_id)) if recs.count() > 1: for rec in recs: self.delete_by_id(rec.uid) return False elif recs.count() == 1: return CabPost2Catalog.get((CabPost2Catalog.post == post_id) & (CabPost2Catalog.catalog == catalog_id)) else: return False
def add_record(self, post_id, catalog_id, order=1): tt = self.get_by_info(post_id, catalog_id) if tt == False: print('a') entry = CabPost2Catalog.create( uid=str(uuid.uuid1()), post=post_id, catalog=catalog_id, order=order, ) else: entry = CabPost2Catalog.update( order=order, ).where(CabPost2Catalog.uid == tt.uid) entry.execute()
def query_count(self): recs = CabPost2Catalog.select(CabPost2Catalog.catalog, peewee.fn.COUNT(CabPost2Catalog.catalog).alias('num')).group_by( CabPost2Catalog.catalog) return (recs)
def query_by_id(self, idd): return CabPost2Catalog.select().join(CabCatalog).where(CabPost2Catalog.post == idd)
def query_by_catid(self, catid): return CabPost2Catalog.select().where(CabPost2Catalog.catalog == catid)
def query_all(self): recs = CabPost2Catalog.select().order_by(CabPost2Catalog.order) return (recs)
def catalog_record_number(self, cat_id): return CabPost2Catalog.select().where(CabPost2Catalog.catalog == cat_id).count()
def query_catalog(self, post_id): return CabPost2Catalog.select().where(CabPost2Catalog.post == post_id)
def catalog_record_number(self, cat_id): return CabPost2Catalog.select().where( CabPost2Catalog.catalog == cat_id).count()
def delete_by_id(self, uid): entry = CabPost2Catalog.delete().where(CabPost2Catalog.uid == uid) entry.execute()
def query_count(self): recs = CabPost2Catalog.select( CabPost2Catalog.catalog, peewee.fn.COUNT(CabPost2Catalog.catalog).alias('num')).group_by( CabPost2Catalog.catalog) return (recs)
def query_by_id(self, idd): return CabPost2Catalog.select().join(CabCatalog).where( CabPost2Catalog.post == idd)
def __init__(self): try: CabPost2Catalog.create_table() except: pass