예제 #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
            );
            ''')
예제 #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
            );
            '''
        )
예제 #3
0
def rollback():
    with connection_factory() as connection:
        connection.executescript('DROP TABLE links')
예제 #4
0
def rollback():
    with connection_factory() as connection:
        connection.executescript('DROP TABLE links')