postgres-adm


Namepostgres-adm JSON
Version 1.0.2 PyPI version JSON
download
home_page
SummaryPostgreSQL has the function of facilitating the use of methods for executing SQL statements.
upload_time2024-02-12 00:48:13
maintainer
docs_urlNone
authorRyan Souza Anselmo
requires_python
licenseMIT License
keywords postgres-adm
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            # Postgres ADM
PostgreSQL has the function of facilitating the use of methods for executing SQL statements.

# How to import?
from postgres_adm import *

# How to create the instance?
bank = PostgreSQL(dbname="my_db", user="my_user", password="my_password", host="localhost", port="5432")

# How to connect?
bank.connect()

# How to disconnect?
bank.disconnect()

# How to check the bank version?
bank.version()

# How to execute instructions?
bank.execute("instructions")

# How to save changes?
bank.commit()

# How to create delete a table?
bank.deleteTable(table='my_table')

# How to get all values within the database?
bank.get(table='my_table')

# How to get a single value?
bank.getSingleData(value='my_value',table='my_table',column='my_column')

# How to obtain complete data?
bank.getFullData(table='my_table',unique='my_unique')

            

Raw data

            {
    "_id": null,
    "home_page": "",
    "name": "postgres-adm",
    "maintainer": "",
    "docs_url": null,
    "requires_python": "",
    "maintainer_email": "",
    "keywords": "postgres-adm",
    "author": "Ryan Souza Anselmo",
    "author_email": "ryansouza.cwb@email.com",
    "download_url": "https://files.pythonhosted.org/packages/95/06/3cf932390033016e9a39cf669d4af6693ffa2da8c8baf44f2fcfaf9dd04b/postgres-adm-1.0.2.tar.gz",
    "platform": null,
    "description": "# Postgres ADM\r\nPostgreSQL has the function of facilitating the use of methods for executing SQL statements.\r\n\r\n# How to import?\r\nfrom postgres_adm import *\r\n\r\n# How to create the instance?\r\nbank = PostgreSQL(dbname=\"my_db\", user=\"my_user\", password=\"my_password\", host=\"localhost\", port=\"5432\")\r\n\r\n# How to connect?\r\nbank.connect()\r\n\r\n# How to disconnect?\r\nbank.disconnect()\r\n\r\n# How to check the bank version?\r\nbank.version()\r\n\r\n# How to execute instructions?\r\nbank.execute(\"instructions\")\r\n\r\n# How to save changes?\r\nbank.commit()\r\n\r\n# How to create delete a table?\r\nbank.deleteTable(table='my_table')\r\n\r\n# How to get all values within the database?\r\nbank.get(table='my_table')\r\n\r\n# How to get a single value?\r\nbank.getSingleData(value='my_value',table='my_table',column='my_column')\r\n\r\n# How to obtain complete data?\r\nbank.getFullData(table='my_table',unique='my_unique')\r\n",
    "bugtrack_url": null,
    "license": "MIT License",
    "summary": "PostgreSQL has the function of facilitating the use of methods for executing SQL statements.",
    "version": "1.0.2",
    "project_urls": null,
    "split_keywords": [
        "postgres-adm"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "95063cf932390033016e9a39cf669d4af6693ffa2da8c8baf44f2fcfaf9dd04b",
                "md5": "b05434c5ba93ecb3319505d40726b7a6",
                "sha256": "9a3a4403de07f0cbe4aa582fa815413005daac82ca02b9b5955b9eaf59bc97db"
            },
            "downloads": -1,
            "filename": "postgres-adm-1.0.2.tar.gz",
            "has_sig": false,
            "md5_digest": "b05434c5ba93ecb3319505d40726b7a6",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 2980,
            "upload_time": "2024-02-12T00:48:13",
            "upload_time_iso_8601": "2024-02-12T00:48:13.663040Z",
            "url": "https://files.pythonhosted.org/packages/95/06/3cf932390033016e9a39cf669d4af6693ffa2da8c8baf44f2fcfaf9dd04b/postgres-adm-1.0.2.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-02-12 00:48:13",
    "github": false,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "lcname": "postgres-adm"
}
        
Elapsed time: 0.84121s