Python Database Connectivity: A Comprehensive Guide

Rumman Ansari   Software Engineer   2024-08-03 02:53:17   1424  Share
Subject Syllabus DetailsSubject Details 11 Questions
☰ TContent
☰Fullscreen

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()


Stay Ahead of the Curve! Check out these trending topics and sharpen your skills.