Database Operations

Library for simplifying database operations. Contains standard functions for database operations.

GitHub Page : https://github.com/NotShrirang/pydbops

Importing pydbops:

from pydbops import *

Methods in Database:

1. openDatabase() - Creates a database and returns a Database object.
2. createTable() - Creates table of given name.
3. addEntry() - Function for inserting values in database.
4. databaseVersion() - Returns sqlite3 version.
5. dropTable() - Function for deleting table.
6. fetchInOrder() - Function for fetching database entries in given order.
7. getData() - Function for getting all data.
8. getFieldNames() - Function for getting field names.
9. getTable() - Creates Table instance.
10. intersection() - Performs intersection and returns all distinct rows selected by query.
11. length() - Returns length of database.
12. minus() - Fetches rows which are present in first query but absent in second.
13. removeEntry() - Function for removing records from database.
14. searchEntry() - Function for searching in database.
15. tableNames() - Function for retrieving tables in a database.
16. union() - Performs union and returns all distinct rows selected by query.
17. updateEntry() - Function for updating values in database.

For printing data in database, you can use default print() method by passing Database object in it.