Executing SQL query using python doesn't do anything

Question

I'm coding a tracking stock prices program. I'm trying to execute INSERT query and it executes, but doesn't do anything.

Here's my method in my class SQLDatabaseOperator

def insert_data_to_database(self, ticker_name, api_data_dict):
    self.connect_to_database()

    sqlite_insert_data_query = '''INSERT INTO {}(open_price, high_price, low_price, previous_close_price, date)\
                                                  VALUES ({}, {}, {}, {}, 'data');'''.format(ticker_name,\
                                                                                            api_data_dict['o'],\
                                                                                            api_data_dict['h'],\
                                                                                            api_data_dict['l'],\
                                                                                            api_data_dict['pc'])
    cursor = self.sqliteConnection.cursor()
    cursor.execute(sqlite_insert_data_query)
    cursor.close()
    self.close_connection()

And here's my sample test.

name = 'NIO'
data = {'o': 24.123, 'h': 30.02, 'l': 22.03, 'pc': 23}
test = SQLDatabaseOperator()
test.insert_data_to_database(name, data)

Nothing is in the database. I don't know what to do. I'm using SQLite. This is my database.

Make sure you call self.sqliteConnection.commit() after the INSERT query. — mechanical_meat
– mechanical_meat, Commented Mar 29, 2021 at 21:59
After cursor.execute(), but before you're closing the connection. — mechanical_meat
– mechanical_meat, Commented Mar 29, 2021 at 22:02

Paweł Długosz · Accepted Answer · 2021-03-29 22:06:46Z

1

The answear was simple - I just need to use

self.sqliteConnection.commit()

after executing cursor. Regards for https://stackoverflow.com/users/42346/mechanical-meat for solving my problem.

answered Mar 29, 2021 at 22:06

Paweł Długosz

1292 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Executing SQL query using python doesn't do anything

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related