pydbops 0.0.5

Simplifies the database operations. Updated.

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:

(You will need to call openDatabase() method using db.)

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.

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