Overview
Python package to help out in working with SQL database-related operation.
It is a python package which uses database (SQL) functionality to help the developer to perform SQL operations on their desired database. This project aims the developer ring to focus on their main code rather than focusing on the database related headaches.
This python package uses the sqlite
functionality to store databases on the local and MySQL
for directly connect with the database setup on the host also some built-in features for working with MongoDB
related operations.
Constants in SQL-Tools
SQL-Tools
use several constants to work properly with the databases. These are used to determine many properties about the databases. You can also use it to verify some things, but it will not be very useful to you because these are just constants that the library use.
Global constants
Here're some constants that are used by every sub-package
of SQL-Tools & may be useful for you:
__startTime__
: To determine the start time of an execution.__stopTime__
: To determine the stop time of an execution.__query__
: To determine the last query executed.__status__
: To determine the current status of a function.__history__
: Array of all the executed queries.
MySQL specific
MySQL uses constants that are specific to it. Some of them are listed below:
__dbMysql__
: To determine the connected databases.__credentials__
: To store the credentials temporarily.__charset__
: To determine the character set to be used for execution.
SQLite specific
SQLite uses constants that are specific to it. Some of them are listed below:
__dbSqlite__
: To determine the connected databases.
Resources
You can contribute to it through GitHub
View project at GitHub
Last updated