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