semvec/pypi-packages huggingface dataset:
postgres-csv-uploader 0.2.0
A small utility to upload CSVs to Postgres without needing to specify the table schema
License: MIT
Requires Python: >=3.7

# Postgres CSV Uploader

This package provides a simple utility to upload CSV files to a Postgres DB without explicitly specifying the table schema in advance by inferring the column types from the corresponding Pandas dtypes.

Libraries such as SQLAlchemy provide systems to do this -- however, the SQLAlchemy ORM is substantially slower than interacting with the database driver directly (which is done by libraries like psycopg2). As a result, there was a (very small, very specific) need to create a smoother interface for uploading CSVs to Postgres quickly and with some kind of type inference.

Note that this is a *very* limited library. It requires being able to load the dataset into memory, and currently doesn't do any kind of partitioning or support parallelism. It also requires superadmin privileges within the DB. However, it does work decently well on small datasets.

As a word of caution, uploading is a *destructive* operation, meaning that it will *overwrite* the the existing table specified by the `table_name` parameter if it exists.

## Example Usage:
    from postgres_csv_uploader.uploader import PostgresCSVUploader
    import psycopg2 as ps

    conn = ps.connect(
        host="hostname",
        user="username",
        password="password",
        port=5432
    )
    uploader = PostgresCSVUploader(conn)
    uploader.upload(
        "my_file.csv",
        "my_table_name",
        index_col="uid",
        datetime_cols=["first_date", "second_date"]
    )
psec 1.3.0
A Python package for cryptography in payment systems
License: MIT
Requires Python: >=3.6
Keywords: payment security cvv cvd cvc mac iso9797 tdes aes tr31

|pypi| |coverage|

``psec`` package provides tools for protecting sensitive data and
cardholder authentication in retail payment transactions.

Installation
------------

``psec`` is published on `PyPI`__ and can be installed from there:

.. code-block::

    pip install psec

__ https://pypi.org/project/psec/

Modules
-------

- tr31 - TR-31 key block wrapping and unwrapping
- cvv - Card Verification Value generation
- des - Triple DES utilities (a wrapper over cryptography_)
- aes - AES utilities (a wrapper over cryptography_)
- mac - Message Authentication Code generation
- pin - Personal Identification Number generation
- pinblock - PIN Blocks encoding and decoding

Contributors
------------

- `Konstantin Novichikhin <https://github.com/knovichikhin>`_

  - Author

- `David Schmid <https://github.com/5n00py>`_

  - PIN block ISO 4 support

.. _cryptography:  https://pypi.org/project/cryptography/

.. |pypi| image:: https://img.shields.io/pypi/v/psec.svg
    :alt: PyPI
    :target:  https://pypi.org/project/psec/

.. |coverage| image:: https://codecov.io/gh/knovichikhin/psec/branch/master/graph/badge.svg
    :alt: Test coverage
    :target: https://codecov.io/gh/knovichikhin/psec