Able to access data through pyodbc and SELECT statements, but no new tables show up in SQL

Question

I have the following code which is working with no errors and returning the expected output when I print the results of the pyodbc cursor I created.

cnxn = pyodbc.connect(MY_URL)
cursor = cnxn.cursor()
cursor.execute(
    '''
    CREATE TABLE tablename(
        filename VARCHAR(100),
        synopsis TEXT,
        abstract TEXT,
        original TEXT,
        PRIMARY KEY (filename)
    )
    '''
)
for file in file_names_1:
    try:
        query = produce_row_query(file, tablename, find_tag_XML)
        cursor.execute(query)
    except pyodbc.DatabaseError as p:
        print(p)

result = cursor.execute(
    '''
    SELECT filename, 
    DATALENGTH(synopsis), 
    DATALENGTH(abstract), 
    original
    FROM ml_files
    '''
)

for row in cursor.fetchall():
    print(row)

However, no new tables are showing up in my actual MS SQL server. Am I missing a step to push the changes or something of that nature?

Did you specify a target database? – Ross Bush Jun 13 '19 at 15:23 — Ross Bush, Jun 13 '19 at 15:23
Side note - NO ONE should be using the text datatype. – SMor Jun 13 '19 at 15:29 — SMor, Jun 13 '19 at 15:29

score 1 · Answer 1 · answered Jun 13 '19 at 17:07

1

You need to commit changes or else they will not be updated in your actual database.

cnxn.commit()

answered Jun 13 '19 at 17:07

Able to access data through pyodbc and SELECT statements, but no new tables show up in SQL

1 Answers1