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'}