\r\nimport sqlite3\r\nconnection = sqlite3.connect(\"accucloud.db\")<\/code><\/pre>\n<\/div>\nThe inclusion of `import sqlite3`<\/strong> provides our Python program with access to the SQLite3 module. When we invoke the `sqlite3.connect()` function<\/strong>, it yields a Connection object, serving as our gateway to interact with the SQLite database stored in the “accucloud.db”<\/strong> file. It’s worth noting that if the “accucloud.db”<\/strong> file doesn’t exist on our computer, sqlite3.connect()<\/strong> will create it automatically.<\/p>\nTo confirm the successful creation of our connection object, we can execute the following:<\/p>\n
<\/div>\n\r\nprint(connection.total_changes)<\/code><\/pre>\n<\/div>\n\r\nOutput:0<\/code><\/pre>\n<\/div>\nconnection.total_changes tells us how many rows in the database have been changed by our connection. We
\nhaven’t made any changes right now, so it’s okay that it shows 0.<\/p>\n
2. Putting Information into the SQLite Database<\/h2>\n
With our connection to the “accucloud.db”<\/strong> SQLite database established, we can begin adding and retrieving data.<\/p>\nIn a SQL database, information is organized within tables. These tables define specific columns and can house multiple rows, each holding data related to those defined columns.<\/p>\n
\t\t\n\t\t\t \n \n \n \n \n \n \t\t\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t <\/div>\n <\/div>\n <\/div>\n <\/section>\n \t\t<\/div>\n\t\t<\/div>\n<\/div>\nOur next step involves creating a table named “car,”<\/strong> which will be used to record and manage the following data:<\/p>\n![\"SQLite](\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2023\/12\/SMq0fhFJlxoQhwbwWs6hnTqsCdg1m7ntkgfo6kC5.png\" "\\"SQLite")
<\/a><\/p>\nThe car table is designed to record information for each car in the showroom, including the brand name, model, and price. Three sample car entries are provided: one for Lamborghini, another for Porsche, and a third for Land Rover.<\/p>\n
You can establish this car table in SQLite by utilizing the connection established in Step 1.<\/p>\n
<\/div>\n\r\ncursor = connection.cursor()\r\ncursor.execute(\"CREATE TABLE car (Brand TEXT, Model TEXT, Price TEXT)\")<\/code><\/pre>\n<\/div>\nExplanation<\/h3>\ncursor = connection.cursor():<\/h4>\n
This line creates a cursor object. A cursor is a database object that allows you to interact with a database using SQL commands. In this case, it is created from the connection object, presumably representing a connection to an SQLite database. The cursor executes SQL commands and fetches results from the database.<\/p>\n
cursor.execute(“CREATE TABLE car (Brand TEXT, Model TEXT, Price TEXT)”):<\/b><\/h4>\n
This line uses the execute method of the cursor object to execute an SQL command. The SQL command being executed here is a “CREATE TABLE”<\/strong> statement. It creates a table named “car”<\/strong> in the connected database with three columns: “Brand,”<\/strong> “Model,”<\/strong> and “Price.”<\/strong> Each column is defined with the data type “TEXT,”<\/strong> meaning these columns will store text (string) values.<\/p>\nWith the table successfully created, we can now add data rows to it:<\/p>\n
<\/div>\n\r\ncursor.execute(\"INSERT INTO car VALUES ('Lamborghini', 'Urus', '$233,263')\")\r\ncursor.execute(\"INSERT INTO car VALUES ('Porsche', 'Taycan', '$86,700')\")\r\ncursor.execute(\"INSERT INTO car VALUES ('Land Rover', 'Range Rover', '$52,600')\")<\/code><\/pre>\n<\/div>\nThe above code executes SQL `INSERT` statements to add rows of car data to the “car” table in an SQLite database, including information about each car’s brand, model, and price.<\/p>\n
3. Retrieving Data from the SQLite Database<\/h2>\n
After inserting three rows into the SQLite table named “car”<\/strong> in Step 2, we can access and retrieve this data using a SELECT SQL statement:<\/p>\n<\/div>\n\r\nrows = cursor.execute(\"SELECT Brand, Model, Price FROM car\").fetchall()\r\nprint(rows)<\/code><\/pre>\n<\/div>\nIf we run this code, we will see output like the following:<\/p>\n