Skip to content

Use a SQLITE3 databse, and do look-up, update, delete, commands per user request using Python functions and SQL commands.

Notifications You must be signed in to change notification settings

ajaysug5361/Interact-with-a-database-using-Python-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 

Repository files navigation

This is a database running on SQLITE3. You can see the database contents from DB Browser (which you can download and install separately). Above is an example from the "Movie" table from the database. We connect to the database importing necessary modules. Once there, we provide options in the Python code for users to look-up movie records and display them, update records or even delete records from the database. All these are made possible by Python functions, so they are dynamic and not hard-coded to any particular record. I also added logging parameters which is helpful to provide messages, warnings, or alerts while connecting to the database, table, retrieving results, and updating output to the end-user.

About

Use a SQLITE3 databse, and do look-up, update, delete, commands per user request using Python functions and SQL commands.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages