Skip to main content

Making psycopg2 a little simpler to use.

Usage:

from psyshort import Psyshort
psy = Psyshort(
    hostname="db.example.com",
    dbname="example_database",
    username="postgres_user",
    password="pa$$w0rd"
    )
select = psy.select(
    table="my_table", # Table's name (mandatory).
    fields=[
        "id",
        "first_name",
        "last_name",
        "phone",
        ], # Fields to include in the result (optional).
    where="last_name = 'Smith'", # Select only rows where last_name = 'Smith' applies (optional).
    limit=1000, # Limit result to 1000 records (optional).
    order_by="first_name" # Order the result by 'first_name' column (optional).
    )
result = select["result"] # The selected records.
duration = select["duration"] # The duration of the operation.

psy.insert(
    table="my_table", # Table's name (mandatory).
    columns=[
        "first_name",
        "last_name",
        "phone",
        ], # Columns by which to insert values (mandatory).
    row={
        "first_name": "John",
        "last_name": "Smith",
        "phone": "KL5-2390"
        } # Row to insert to the table (mandatory).
    )

psy.disconnect() # Occurs on psy.__del__

Metadata

Release files for psyshort 0.1.6

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for psyshort 0.1.6
File Size Uploaded Provenance Actions
psyshort-0.1.6.tar.gz 2.9 kB Without provenance Details for psyshort-0.1.6.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for psyshort 0.1.6
File Interpreter ABI Platform Actions
psyshort-0.1.6-py3-none-any.whl Python 3 none any Details for psyshort-0.1.6-py3-none-any.whl

Total release size: 7.8 kB

Release files / psyshort-0.1.6.tar.gz

Download URL psyshort-0.1.6.tar.gz
Size 2.9 kB
Tags Source
SHA-256 checksum
How to use checksums
1afbd3f93f476baafdbb2f6974688bae74eeae3add336d6be63014c9af53cb90
BLAKE2b-256 checksum
How to use checksums
5a4c532400a9c8f8a217b6a9121bd02be01e7f47a67a41d7ff03cc088f5cff9b
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Release files / psyshort-0.1.6-py3-none-any.whl

Download URL psyshort-0.1.6-py3-none-any.whl
Size 4.9 kB
Tags Python 3
SHA-256 checksum
How to use checksums
c6b9758b602ee9186b581913fb4187890350f3630c03a55f75f9cad50bc0ccde
BLAKE2b-256 checksum
How to use checksums
1691c1199b1e8bcae35f0e31744277b0afeb023b34a95f0c26902223856f924a
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No

Security for psyshort 0.1.6

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page