Python DBSession.execute Examples

Example #1

File: 559ce6eb0949_update_node_path_column.py Project: adamchainz/Kotti

def upgrade():

    from kotti.resources import DBSession

    from alembic.context import get_bind

    conn = get_bind()

    if conn.engine.dialect.name == 'mysql':
        update = "update nodes set path = concat(path, '/') where path not \
like '%/'"
    else:
        update = "update nodes set path = path || '/' where path not like '%/'"
    DBSession.execute(update)

Example #2

File: 559ce6eb0949_update_node_path_column.py Project: cruxlog/Kotti

def upgrade():

    from kotti.resources import DBSession

    from alembic.context import get_bind

    conn = get_bind()

    if conn.engine.dialect.name == 'mysql':
        update = "update nodes set path = concat(path, '/') where path not \
like '%/'"

    else:
        update = "update nodes set path = path || '/' where path not like '%/'"
    DBSession.execute(update)

Example #3

File: 559ce6eb0949_update_node_path_column.py Project: umeboshi2/Kotti

def upgrade():

    from kotti.resources import DBSession

    from alembic.context import get_bind

    conn = get_bind()

    if conn.engine.dialect.name == 'mysql':
        update = "UPDATE nodes " \
                 "SET path = concat(path, '/') " \
                 "WHERE path NOT LIKE '%/'"
    else:
        update = "UPDATE nodes " \
                 "SET path = path || '/' " \
                 "WHERE path NOT LIKE '%/'"
    DBSession.execute(update)

Example #4

File: 559ce6eb0949_update_node_path_column.py Project: majortom64/Kotti

def upgrade():

    from kotti.resources import DBSession
    DBSession.execute(
        "update nodes set path = path || '/' where path not like '%/'"
    )