def recreate_views(): """Drop views and recreate """ fileDir = os.path.dirname(os.path.realpath('__file__')) filename = os.path.join(fileDir, 'autoshop/sql/views.sql') file = open(filename) execute_sql(file)
def items(): """item_views create """ fileDir = os.path.dirname(os.path.realpath('__file__')) filename = os.path.join(fileDir, 'autoshop/sql/items.sql') file = open(filename) execute_sql(file)
def truncate(): """truncate """ click.echo('remove migrations and truncate') os.system('rm -rf migrations') fileDir = os.path.dirname(os.path.realpath('__file__')) filename = os.path.join(fileDir, 'autoshop/sql/truncate.sql') file = open(filename) execute_sql(file)
def reset(): """Drop db and remove migrations """ click.echo('remove migrations and drop db') os.system('rm -rf migrations') fileDir = os.path.dirname(os.path.realpath('__file__')) filename = os.path.join(fileDir, 'autoshop/sql/drop.sql') file = open(filename) execute_sql(file) db.drop_all()
def seed(): import datetime fileDir = os.path.dirname(os.path.realpath('__file__')) filename = os.path.join(fileDir, 'autoshop/sql/makes.sql') file = open(filename) execute_sql(file) entity = Entity( name='Floben Autoshop', email='*****@*****.**', phone='256770443322', address='Ntinda', created_by=1, date_created=datetime.datetime.now(), ) account = Account(owner_id=entity.uuid, acc_type='entity', created_by=1, group=entity.uuid) db.session.add(entity) db.session.add(account) ctype = CustomerType(uuid='in_fleet', name='IN FLEET', created_by=1, entity_id=entity.uuid) ctype1 = CustomerType(uuid='out_fleet', name='OUT FLEET', created_by=1, entity_id=entity.uuid) db.session.add(ctype1) db.session.add(ctype) db.session.commit()
def init(): """Init application, create database tables and create a new user named admin with password admin """ click.echo('create database') db.create_all() click.echo('done') click.echo('add account balances view') fileDir = os.path.dirname(os.path.realpath('__file__')) filename = os.path.join(fileDir, 'autoshop/sql/accounting.sql') file = open(filename) execute_sql(file) click.echo('add other views') filename2 = os.path.join(fileDir, 'autoshop/sql/views.sql') file2 = open(filename2) execute_sql(file2) fileDir = os.path.dirname(os.path.realpath('__file__')) filename = os.path.join(fileDir, 'autoshop/sql/items.sql') file = open(filename) execute_sql(file) click.echo('create user') role = Role(uuid='system_admin', name='System Admin', category='system', active=True, created_by=1) role2 = Role(uuid='system_user', name='System User', category='system', active=True, created_by=1) role3 = Role(uuid='entity_admin', name='Entity Admin', category='entity', active=True, created_by=1) role4 = Role(uuid='vendor_user', name='Vendor User', category='vendor', active=True, created_by=1) pay_type = PaymentType(uuid='bank', name='Bank', active=True, created_by=1) pay_type2 = PaymentType(uuid='cash', name='Cash', active=True, created_by=1) tran_type = TransactionType(uuid='bill', name='Bill', active=True, created_by=1) tran_type2 = TransactionType(uuid='payment', name='Payment', active=True, created_by=1) tran_type3 = TransactionType(uuid='reversal', name='Reversal', active=True, created_by=1) tran_type4 = TransactionType(uuid='adjustment', name='Adjustment', active=True, created_by=1) tran_type5 = TransactionType(uuid='expense', name='Expense', active=True, created_by=1) tran_type6 = TransactionType(uuid='purchase', name='Purchase', active=True, created_by=1) user = User( username=app.config['APP_KEY'], first_name='System', last_name='Administrator', email='*****@*****.**', password=app.config['APP_SECRET'], role_code='system_admin', active=True, company_id='system', ) pay_type.save() pay_type2.save() db.session.add(tran_type) db.session.add(tran_type2) db.session.add(tran_type3) db.session.add(tran_type4) db.session.add(tran_type5) db.session.add(tran_type6) db.session.add(role) db.session.add(role2) db.session.add(role3) db.session.add(role4) db.session.add(user) db.session.commit() click.echo('created user admin')