In this article, we will see how one can insert the user data using variables.
Here, we are using the sqlite module to work on a database but before that, we need to import that package.
To see the operation on a database level just download the SQLite browser database.
Note: For the demonstration, we have used certain values but you can take input instead of those sample values.
Steps to create and Insert variables in database
Code #1: Creat the database
We have initialised the database pythonDB.py. This instruction will create the database if the database doesn’t exist. If the database having the same name as defined exist than it will move further. In the second statement, we use a method of sqlite3 named
cursor(), this help you to initiate the database as active.
Cursors are created by the connection
cursor() method, they are bound to the connection for the entire lifetime and all the commands are executed in the context of the database session wrapped by the connection.
Code #2: Create table
We have created a function create_table. This will help you to create table if not exist, as written in the query for SQLite database. As we have initiated the table name by RecordONE. After that we pass as many parameters as we want, we just need to give an attribute name along with its type, here, we use REAL and Text.
Code #3: Inserting into table
Another function called data_entry. We are trying to add the values into the database with the help of user input or by variables. We use the
execute() method to execute the query. Then use the
commit() method to save the changes you have done above.
Code #4: Method calling and Close the connection.
We normally use the method call, also remember to close the connection and database for the next use if we want to write error-free code because without closing we can’t open the connection again.
Let’s see the complete example now.
Inserting one more value using data_entry() method.
Attention geek! Strengthen your foundations with the Python Programming Foundation Course and learn the basics.
To begin with, your interview preparations Enhance your Data Structures concepts with the Python DS Course.
- Read SQL database table into a Pandas DataFrame using SQLAlchemy
- Python | Inserting item in sorted list maintaining order
- Python VLC MediaList - Inserting Media
- Django ORM - Inserting, Updating & Deleting Data
- PyQt5 QCalendarWidget - Inserting QAction
- PyQt5 QCalendarWidget - Inserting Multiple QAction
- PyQt5 QCommandLinkButton - Inserting actions object
- MoviePy – Inserting Text in the Video
- PYGLET – Inserting Element in Formatted Document
- PYGLET – Inserting Text in Formatted Document
- Display the Pandas DataFrame in table style and border around the table and not around the rows
- Connect MySQL database using MySQL-Connector Python
- Create a database in MongoDB using Python
- Create MySQL Database Login Page in Python using Tkinter
- PostgreSQL - Connecting to the database using Python
- CRUD Operations on Postgres using Async Database In Python
- Create Database in MariaDB using PyMySQL in Python
- Using Google Sheets as Database in Python
- Extract Data from Database using MySQL-Connector and XAMPP in Python
- Working with database using Pandas
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.