Skip to main content

A package to make database usage easier

Project description

EliteD

EliteD is a package to make database usage easier! Create database easily and read and update them.

Installing

To install the package you just need to execute the following in your command line:

pip3 install EliteD

Using the package

This is how you create and setup a Database

import EliteD #importing the package
database = EliteD.create_database(name="user.db", path="/path/to/db")
database.create_table(name="test", columns=[{"type": int, "name": "test"}]) 

The second line would create the database "user.db" at the given path The last line creates the table "test" in the database with the column "test" with integer as values. You can add as many columns as you want

If you already have a database, you can open the database like this:

import EliteD #import the module
database = EliteD.Database("/path/to/db") #Opens the database

If you need to delete a created table, you can do it like this:

import EliteD
database = EliteD.Database(path="/path/to/db")
database.delete_table("name of the table")

Writing values in a database

To add new values, you can use the insert_value method:

import EliteD
database = EliteD.Database(path="/path/to/db")
database.insert_value(table="test", values=("001", "bread"))

This would insert the values 001 and bread in the table test.

Reading, deleting and changing values of a database

To read a value of a database, you can use the read_value method:

import EliteD
database = EliteD.Database(path="/path/to/db")
read = database.read_value(table="test", values=["test"], conditions={"test": 0})
print(read)

values is the row you want to read from the table. You can give multiple values. To read out all values, you can use the EliteD.AllValues() class. Conditions can be specified when you only want to read out the values when a row (test in this case) has the specified value (0 in this case).

To delete database values you can use the delete_value method:

import EliteD
database = EliteD.Database(path="/path/to/db")
database.delete_value(table="test", row="trees", new_value=2, conditions={"floof": 1})

This would delete every value of the row trees from the table test if the value of floof is 1

To change database values, you can use update_value method:

import EliteD
database = EliteD.Database(path="/path/to/db")
database.update_value(table="test", row="roaw", new_value=2, conditions={"roawaaa": 1})

This would change every value of the row roaw from the table test to 2 if the value of roawaaa is 1

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

EliteD-1.1.tar.gz (4.7 kB view hashes)

Uploaded source

Built Distribution

EliteD-1.1-py3-none-any.whl (5.3 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