postpy | Postgresql utilities for ETL and data analysis | Data Migration library

by portfoliome Python Version: 0.0.9 License: MIT

X-Ray Key Features Code Snippets(1)Community Discussions(1)Vulnerabilities Install Support

kandi X-RAY | postpy Summary

postpy is a Python library typically used in Migration, Data Migration, Oracle applications. postpy has no bugs, it has no vulnerabilities, it has build file available, it has a Permissive License and it has low support. You can install using 'pip install postpy' or download it from GitHub, PyPI.

Postgresql utilities for ETL and data analysis.

Support

Quality

Security

License

Reuse

Support

postpy has a low active ecosystem.

It has 23 star(s) with 3 fork(s). There are 6 watchers for this library.

It had no major release in the last 12 months.

postpy has no issues reported. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of postpy is 0.0.9

Quality

postpy has 0 bugs and 0 code smells.

Security

postpy has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

postpy code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

postpy is licensed under the MIT License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

postpy releases are available to install and integrate.

Deployable package is available in PyPI.

Build file is available. You can build the component from source.

Installation instructions are not available. Examples and code snippets are available.

postpy saves you 662 person hours of effort in developing the same functionality from scratch.

It has 1535 lines of code, 215 functions and 29 files.

It has low code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed postpy and discovered the below as its top functions. This is intended to give you an instant insight into postpy implemented functionality, and help decide if they suit your requirements.

Copy data from csv to file
Create a copy from a csv file
Formats a copy of the given table
Format the force_not_not_null column
Returns a copy of the table
Make a temporary copy of the table
Generate a random table name
Create a new table
Register uuid extensions
Check if an extension is installed
Install Postgres extension
Install PostgreSQL extensions
Generates a SQL query to delete from the database
Generate SQL statement to delete a joined table
Format an upsert
Create an INSERT statement
Make the INSERT query
Format an upsert statement
Return uuid_sequence_generate_sequence_generate_sequence_sequence function
Generate a random UUID function
Execute a transaction
Insert records into a table
Read the requirements from a given file
Connect to PostgreSQL
Register the extension

Get all kandi verified functions for this library.

postpy Key Features

No Key Features are available at this moment for postpy.

postpy Examples and Code Snippets

Example Usage

Python

Lines of Code : 31

License : Permissive (MIT)

Copy

import csv

from foil.fileio import DelimitedReader
from foil.parsers import parse_str, parse_int, passthrough

from postpy import dml

ENCODING = 'utf-8'

class DataDialect(csv.Dialect):
    delimiter = '|'
    quotechar = '"'
    lineterminator = '

Community Discussions

Vulnerabilities

No vulnerabilities reported

Install postpy

You can install using 'pip install postpy' or download it from GitHub, PyPI.
You can use postpy like any standard Python library. You will need to make sure that you have a development environment consisting of a Python distribution including header files, a compiler, pip, and git installed. Make sure that your pip, setuptools, and wheel are up to date. When using pip it is generally recommended to install packages in a virtual environment to avoid changes to the system.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: