def main(argv=sys.argv):
if len(argv) != 2:
usage(argv)
config_uri = argv[1]
setup_logging(config_uri)
settings = get_appsettings(config_uri)
engine = engine_from_config(settings, 'sqlalchemy.')
DBSession.configure(bind=engine)
Base.metadata.create_all(engine)
with transaction.manager:
model = UsersTable(username='******', name_first='Robert')
DBSession.add(model)
def create(self, user_info):
user = UsersTable(username=user_info['username'])
status = DBSession.add(user)
try:
transaction.commit()
except:
return {'status': '1', 'data': 'Username Exists'}
return {'status': '0', 'data': 'Create User Successful'}
