def main(): username = sys.argv[1] password = sys.argv[2] user = User() user.username = username s = sha1() s.update(password) user.password = s.hexdigest() user.level = 3 user.is_staff = True user.last_factura = 0 user.bodega_factura_id = 1 with dbapi.session: dbapi.create(user)
def main(): with dbapi.session: # x = ProdTag(tag='hot_items', description='70 best sellers that contribute to 50% of revenue', created_by='han qi') # dbapi.create(x) # dbapi.db_session.commit() with open('tags.txt') as f: for x in f.readlines(): tag, prod_id = x.strip().split()[:2] itemgroup = dbapi.getone(ProdItemGroup, prod_id=prod_id) if itemgroup is None: print 'missing', prod_id continue if dbapi.getone(ProdTagContent, tag=tag, itemgroup_id=itemgroup.uid) is None: dbapi.create(ProdTagContent(tag=tag, itemgroup_id=itemgroup.uid)) print 'created itemgroup', itemgroup.uid dbapi.db_session.commit()
def backfill_item(list_of_price): if not list_of_price: return with_plus = None without_plus = None result = [] for x in list_of_price: if x.prod_id[-1] == '+': with_plus = x else: without_plus = x if without_plus is None: prod_id = with_plus.prod_id[:-1] ig = dbapi.getone(ProdItemGroup, prod_id=prod_id) if ig is None: ig = make_item_plused(with_plus) igid = dbapi.create(ig) result.append('itemgroup') else: igid = ig.uid print ig.serialize() else: ig = dbapi.getone(ProdItemGroup, prod_id=without_plus.prod_id) if ig is None: ig = make_item_group(without_plus) igid = dbapi.create(ig) result.append('itemgroup') else: igid = ig.uid if without_plus: item = dbapi.getone(ProdItem, prod_id=without_plus.prod_id) if item is None: item = make_item(without_plus) item.itemgroupid = igid dbapi.create(item) result.append('item {}'.format(item.prod_id)) if with_plus: item = dbapi.getone(ProdItem, prod_id=with_plus.prod_id) if item is None: item = make_item(with_plus) item.itemgroupid = igid dbapi.create(item) result.append('item {}'.format(item.prod_id)) return result
import sys import json from henry.base.serialization import json_dumps from henry.importation.dao import Unit, ALL_UNITS from coreapi import dbapi with dbapi.session: for x in sys.stdin.readlines(): u = Unit.deserialize(json.loads(x)) dbapi.create(u)