Name | postgres-adm JSON |
Version |
1.0.2
JSON |
| download |
home_page | |
Summary | PostgreSQL has the function of facilitating the use of methods for executing SQL statements. |
upload_time | 2024-02-12 00:48:13 |
maintainer | |
docs_url | None |
author | Ryan Souza Anselmo |
requires_python | |
license | MIT 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"
}