def create_volume(): ed_user = Volume(name='vmax_vol', fullname='vmax_vol pool 1 ', pool='pool1') # Let's add the user and its addresses we've created to the DB and commit. session.add(ed_user) session.commit()
def create_user(): ed_user = User(name='ed', fullname='Ed Jones', password='******') ed_user.addresses = [ Address(email_address='*****@*****.**'), Address(email_address='*****@*****.**') ] # Let's add the user and its addresses we've created to the DB and commit. session.add(ed_user) session.commit()
def commit_unlock_tables(session): """Commit and unlock tables for supported backends: MySQL and PostgreSQL""" session.commit() session.execute('COMMIT') # execute COMMIT on DB backend # because sqlalchemy session does not guarantee # exact boundary correspondence to DB backend transactions # We must guarantee DB commits transaction before UNLOCK # unlock if is_mysql(): session.execute('UNLOCK TABLES')
def commit_unlock_tables(session): """Commit and unlock tables for supported backends: MySQL and PostgreSQL""" try: session.execute('COMMIT') # execute COMMIT on DB backend session.commit() # because sqlalchemy session does not guarantee # exact boundary correspondence to DB backend transactions # We must guarantee DB commits transaction before UNLOCK # unlock if is_mysql(): session.execute('UNLOCK TABLES') # postgres automatically releases lock at transaction end except db_exc.DBDataError as exc: LOG.exception('Database backend experienced data error.') raise congress_exc.DatabaseDataError(data=exc)