pydeas 1.0.2

A simple db package

Pydeas

Pydeas is a Python library for dealing in an efficent way with information storage.

Installation

Use the package manager pip to install Pydeas

pip install pydeas

Get Started

This library is based on pandas and memorize the information in csv files, the database is relational but you can work with multiple folders and files, in this way you can create a dynamic and comprehensible db structure.

from pydeas import PydeasDB



def db() -> None:

    main_folder = PydeasDB.Folder('Database') # create the main folder in the current folder

    password_file = main_folder.create_file('passwords') # create a 'passwords' file in the main folder

    password_file.add_columns(['App', 'Email', 'Username', 'Password']) # add the column to the table of the file

Now we created a "passwords.csv" in the database folder, and configured the file adding columns; we can now start working with Pydeas

Output in ./Database/passwords.csv

#,App,Email,Username,Password

Add an element to the table

password_file.add_row(['Github', '[e-mail]', 'Foo', 'Bar']) # add a row to the table of the file

Output in ./Database/passwords.csv

#,App,Email,Username,Password

1,Github,[e-mail],Foo,Bar

As you can see this library is pretty easy to use and all the methods name are auto-explicative, but you can navigate further in this documentation

Query

A pydeas database can be queryied in 2 different ways:

one resembles the way of doing things in relational databases

(we recommend using this when queryies are more complex)

def get_config(app_name, email):

    print(password_file.query(f'App == "{app_name}" & Email == "{email}"'))

        

# This function will print the list of objects or None (if nothing is found)

for reference you can check the query method of pandas library which also takes a string and works in the exact same way;

While the other one resembles the non-relational databases (such as MongoDb etc.)

def get_config(app_name, email):

    print(password_file.search({

        "App": app_name,

        'Email': email

    }))

# This function will print the list of objects or None (if nothing is found)

Update

The update function takes 2 arguments: the first one is the query string, the second one the new row

def update_by_appname(app_name, new_email, new_username, new_password) -> None:

    response = password_file.update(f'App == "{app_name}"', {

        'App': app_name,

        'Email': new_email,

        'Username': new_username,

        'Password': new_password

    })

    print(response)

# This function will print true if the operation is completed succesfully

Delete

The delete function the query string as argument

def delete_by_appname(app_name) -> None:

    response = password_file.delete(f'App == "{app_name}"')

    print(response)

# This function will print true if the operation is completed succesfully

Pydeas v1.0.2