Ejemplo n.º 1
0
def apply():
    with connection_factory() as connection:
        connection.executescript('''
            CREATE TABLE links (
                pk INTEGER PRIMARY KEY,
                url TEXT,
                key TEXT UNIQUE,
                created_at TIMESTAMP
            );
            ''')
Ejemplo n.º 2
0
def apply():
    with connection_factory() as connection:
        connection.executescript(
            '''
            CREATE TABLE links (
                pk INTEGER PRIMARY KEY,
                url TEXT,
                key TEXT UNIQUE,
                created_at TIMESTAMP
            );
            '''
        )
Ejemplo n.º 3
0
def rollback():
    with connection_factory() as connection:
        connection.executescript('DROP TABLE links')
Ejemplo n.º 4
0
def rollback():
    with connection_factory() as connection:
        connection.executescript('DROP TABLE links')