elseagle/insert.py

Created May 25, 2019 02:49

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/elseagle/0dc7ce99bebeda65b08fdf6767045649.js"></script>
Save elseagle/0dc7ce99bebeda65b08fdf6767045649 to your computer and use it in GitHub Desktop.

Download ZIP

Raw

+def insert(item):
+        connection = sqlite3.connect('data.db')
+        cursor = connection.cursor()
+        query = "INSERT INTO {table} VALUES(?, ?)"
+        cursor.execute(query, (item['name'], item['price']))
+        connection.commit()
+        connection.close()

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment