This library is used to read or write data in Postgres or Google Sheets
Project description
Overview
Justogres is a connector to comunicate pandas.DataFrame objects with postgres database
Quick start
for more details review documentation
Install or upgrade package
install:
pip install justogres
upgrade:
pip install justogres --upgrade
Init module
from justogres import clientPsql
psql = clientPsql(
host = "<your host>",
user = "<your user>",
password = "<your password>",
db_name = "<your database name>",
)
Insert data into postgres
import pandas as pd
example_df = pd.DataFrame(data=example_data)
psql.insert(
example_df,
table_name=<your table name>, #if doesn't exist table, will be created
schema=<your schema name>, #should be created previously
#optional
chunksize=<your chunksize to load (default: 1000)>,
column_types={<name_column_df>:<data_type postgres>})# if not declare column types, will be assigned automatically
Read table of postgres
we have 2 ways to read DB, both return pandas.DataFrame object but its main difference is the type of data that is assigned to the columns of the dataframe
1. use exec_query() -> all columns are defines as object (string datatype in pandas)
query_example_to_read="""SELECT *
FROM schema_name.table_name;"""
df = psql.exec_query(
query_example_to_read,
#optional
chunksize=<your chunksize to load (default: 1000)>
)
2. use read_with_pandas() -> columns are defined with datatype declare for each column into DB
query_example_to_read="""SELECT *
FROM schema_name.table_name;"""
df = psql.read_with_pandas(
query_example_to_read,
#optional
**kwargs=<all attributes we can use with pandas.read_sql()>
)
for more info of pandas.read_sql()
Execute sql queries
this method doesn't return anything
query_example="""DELETE
FROM schema_name.table_name
WHERE column_name='value';"""
psql.exec_query(
query_example,
#optional
chunksize=<your chunksize to load (default: 1000)>
)
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
justogres-3.0.7.tar.gz
(6.8 kB
view hashes)
Built Distribution
Close
Hashes for justogres-3.0.7-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | a7a44e7556d1e22400fa0a59810c3a908151a27ccf2b69a2637538f64d90f1e7 |
|
MD5 | d84a72e9cf3e179c659b31af8fc7cb24 |
|
BLAKE2b-256 | db7a3a581703650012e9b550b36ea6d0234fcbd188c50268d574775433807d80 |