def test_DDL_autocommit(shared_instance, dbapi_database):
    'Check that DDLs in autocommit mode are immediately executed.'
    conn = Connection(shared_instance, dbapi_database)
    conn.autocommit = True
    cur = conn.cursor()
    cur.execute('\n        CREATE TABLE Singers (\n            SingerId     INT64 NOT NULL,\n            Name    STRING(1024),\n        ) PRIMARY KEY (SingerId)\n    ')
    conn.close()
    conn = Connection(shared_instance, dbapi_database)
    cur = conn.cursor()
    cur.execute('DROP TABLE Singers')
    conn.commit()
Check that DDLs in autocommit mode are immediately executed.
def test_DDL_autocommit(shared_instance, dbapi_database):
    
    conn = Connection(shared_instance, dbapi_database)
    conn.autocommit = True
    cur = conn.cursor()
    cur.execute('\n        CREATE TABLE Singers (\n            SingerId     INT64 NOT NULL,\n            Name    STRING(1024),\n        ) PRIMARY KEY (SingerId)\n    ')
    conn.close()
    conn = Connection(shared_instance, dbapi_database)
    cur = conn.cursor()
    cur.execute('DROP TABLE Singers')
    conn.commit()