Python Database Connectivity

Rumman Ansari   Software Engineer   2023-02-06   1567 Share
☰ Table of Contents

Table of Content:

1. Database Connectivity 1- Connect to Database and create Table

Connect to a sample database 'SAMPLE.db'.

Hint: Use sqlite as the backend database, and sqlite3 DB-API.

Create a connection cursor cursor.

• Create table ITEMS with attributes item_id, item_name, item_description, item_category and quantity_in_stock.

commit and close the connection.

• Use the 'Test against custom input' box to output the result for debugging. Use 'print(res)' to display the output.

Solutions 


#!/bin/python3
import sys
import os
import sqlite3
# Complete the following function:
def main():
    conn = sqlite3.connect('SAMPLE.db')
    #create connection cursor
    cursor = conn.cursor()
    #create table ITEMS using the cursor
    items = '''CREATE TABLE ITEMS(item_id INT,item_name CHAR(10),item_description CHAR(20),item_category CHAR(10),quantity_in_stock INT)'''
    #commit connection 
    cursor.execute(items)
    #close connection
    conn.close() 

'''To test the code, no input is required'''

if __name__ == "__main__":
    f = open(os.environ['OUTPUT_PATH'], 'w')

    res = main();
    f.write(str(res) + "\n")


    f.close()
‹ Previous not possible this is first one.
Next › -   Database Connectivity 2 - Insert records in table