connectors-to-databases 0.0.5

Python module for connect with PostgreSQL

Connector to database

Connector to database – easy package for connect with database PostgreSQL.

Installation

Install the current version with PyPI:

pip install connectors-to-databases

Or from GitHub:

pip install https://github.com/k0rsakov/connectors_to_databases/archive/refs/heads/main.zip

Example

you can create as many database connectors as you want.

from connectors_to_databases import PostgreSQL

pg = PostgreSQL()

pg_other = PostgreSQL(
    host='0.0.0.0',
    port=0,
    database='main',
    login='admin',
    password='admin',
)

Creating a table for examples

pg.execute_script('CREATE TABLE simple_ (id int)')

Filling the table with data

# simple pd.DataFrame
df = pd.DataFrame(data={'id':[1]})

pg.into_pg_table(
    df=df,
    pg_table_name='simple_'
)

Getting data from a table

pg.execute_to_df(
    '''select * from simple_'''
)

Getting a connector to the database. It can be used as you need.

pg.get_uri()

What does the connector look like

Engine(postgresql://postgres:***@localhost:5432/postgres)

Delete our simple_ table

pg.execute_script('DROP TABLE simple_')

Contributing

Bug reports and/or pull requests are welcome

License

The module is available as open source under the terms of the Apache License, Version 2.0