Metadata-Version: 1.1
Name: sqlitemgr
Version: 1.2.6
Summary: A wrapper class for basic setup and management of an SQLite database.
Home-page: https://github.com/aescwork/sqlitemgr
Author: aescwork
Author-email: aescwork@protonmail.com
License: MIT
Description-Content-Type: UNKNOWN
Description: sqlitemgr
        =========
        
        This package can be found at https://github.com/aescwork/sqlitemgr. 
         
        In the github repository there is sphinx-generated documentation: the main page is docs/index.html. 
        
        
        
        sqlitemgr -- the SQLite Manager module -- is a wrapper class for basic management of an sqlite database and its
        tables.  It can be used to create and delete database files, tables, create and return a connection to a database file as 
        well as a cursor which is used for executing statements against an sqlite database.  
        
        It has two main purposes: 1. to encapsulate all of the basic database management actions in one class, and 2. to create
        tables with the option of not having to directly enter the structured query language necessary.  Specific methods for
        composing and executing sql statements can be chained together for creating tables (including specifying column names, data types
        and constraints) in an sqlite database.  
        
        There are also a few utility methods for managing data in and getting information about the tables.  These can get the
        number of tables in a database, get the number of rows in a table, or re-index a column which is used for storing numbers.
        
        This module was written as a companion to the sqliteminor module, whose functionality focuses on creating, reading, updating and deleting
        data in sqlite database columns.  
        
        NOTE:
        
        This module requires sqlite3 to be installed prior to use.
        
        
        After installation of this package is complete, trying to use the module might result in the following error: "ImportError: No module named sqlitemgr"
        or some other error message.
        
        This probably indicates that the Python interpreter may not be able to locate the module.  In this case,
        the following is recommended:
        
        	On Linux:
        
        		Locate where the package was installed.  In the terminal, navigate to the root directory and execute the following command:
        
        												sudo find . -name sqlitemgr.py
        
        
        		This should give a path to the sqlitemgr.py file.  
        		Create a file called "local_python.sh" and put the following text in it:
        
        								PYTHONPATH="/usr/local/lib/python*.*/dist-packages/sqlitemgr/":"${PYTHONPATH}"
        								export PYTHONPATH
        
        		To make the module available to all users, place this file in /etc/profile.d.  Then place a line to execute this
        		file somewhere in .bashrc or one of the other bash configuration files in the individual (non-root) user's terminal: 
        
        										    . /etc/profile.d/local_python.sh
        
        		This should cause the python interpreter to locate the sqlitemgr.py file in the module.   
        
        
        	On MS Windows:
        		
        		The following was tested on a machine running Windows 10. 
        		
        		(This assumes that Python is installed on the machine.)
        
        		Locate where the package was installed.  On Windows 10, Look for the Python folder.  Its usually right under the C: drive. 
        		The name of the folder probably has the version number in it as well, like "Python27".  Look for the sqlitemgr folder: it should
        		be in "Lib\" and then "site-packages\" folder.  
        
        		Open up the System Properties Panel.  (You can find this by clicking on the "Settings" icon and entering "Environment Variables" in the 
        		search bar.  When the panel comes up, Click the "Environment Variables" button.  Under "System variables", click "New" and type in the full path to
        		the sqlitemgr folder.
        
        		Test this by opening the command line application and starting the Python interpreter (type the command "python" and press enter).
        		Now try to import the module and instantiate an sqlitemgr object.  Type the following:
        	
        		>>> import sqlitemgr
        		>>> sg = sqlitemgr.SQLiteMinor()
        		>>> sg.result
        
        		If everything went well, 'None' should print out on the screen.  If there was an "ImportError" or any other error, try importing the
        		module again and test as follows: 
        
        
        		>>> import sqlitemgr.sqlitemgr as sqlitemgr
        		>>> sg = sqlitemgr.SQLiteMgr()
        		>>> sg.result
        
        
        
        
Keywords: sqlitemgr sqlite development database sqlite3
Platform: UNKNOWN
Classifier: Development Status :: 5 - Production/Stable
Classifier: Intended Audience :: Developers
Classifier: Topic :: Database
Classifier: Topic :: Software Development :: Libraries :: Python Modules
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3.5
