Skip to main content

Intract with sqlite3 in python as simple as it can be.

Project description

pylite

Intract with sqlite3 in python as simple as it can be.

Install

pip install pylite

Tips

Import pylite :

from pylite import Pylite

Create a new database or open an existing database :

db = Pylite('dbname')

Add a table :

db.add_table('table_name',column1='datatype',column2='datatype',...,columnN='datatype')

Insert data :

db.insert('table_name','column1_value','column2_value',...,'columnN_value')

Remove items :

db.remove('table_name','condition')

Retrieve items :

db.get_items('table_name','condition')

Get all tables name :

db.get_tables()

Execute your sqlite queries:

db.query('your query')

Close connection :

db.close_connection()

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

pylite-0.1.0.tar.gz (2.4 kB view hashes)

Uploaded source

Built Distribution

pylite-0.1.0-py3-none-any.whl (3.7 kB view hashes)

Uploaded py3

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page