# square_database
## about
database layer for my personal server.
## installation
```shell
pip install square_database[all]
```
## usage (WIP)
### change password in config.ini.
### CREATE_SCHEMA = True to create database from scratch.
### LOG_FILE_NAME and configure logger
### link to square_database_structure
## config
square_database\data\config.ini
## env
- python>=3.12.0
## changelog
### v2.4.0
- set allow_credentials=True.
### v2.3.0
- expanded apply_filters to support additional conditions: ne, lt, lte, gt, gte, like, in_.
### v2.2.1
- update test for root
### v2.2.0
- standardize output format for all endpoints.
- edit_rows is not patch method.
- bug fix in get rows for column selection.
- added total count in get rows.
- added affected count in insert, edit, and delete rows.
### v2.1.0
- standardize filter input to forward facing data structure.
- rename ignore_all to apply_filters.
- add columns in get rows.
- stricter type checking in pydantic models.
- refactor logic to apply filters into common function.
- add pydantic as explicit requirement.
### v2.0.0
- append version number for each endpoint in the api.
### v1.1.0
- remove table creation logic (move to square_database_structure).
### v1.0.3
- add limit, offset and order by in get rows.
### v1.0.2
- database creation logic change.
### v1.0.1
- no changes. (password erase from history.)
### v1.0.0
- initial commit.
## Feedback is appreciated. Thank you!
Raw data
{
"_id": null,
"home_page": "https://github.com/thepmsquare/square_database",
"name": "square-database",
"maintainer": null,
"docs_url": null,
"requires_python": null,
"maintainer_email": null,
"keywords": null,
"author": "thePmSquare",
"author_email": "thepmsquare@gmail.com",
"download_url": "https://files.pythonhosted.org/packages/ee/f0/2b4b2aa3076cdefbecf06c6d62473eefa7e678e6b2ad8cfaf13f9de24065/square_database-2.4.0.tar.gz",
"platform": null,
"description": "# square_database\n\n## about\n\ndatabase layer for my personal server.\n\n## installation\n\n```shell\npip install square_database[all]\n```\n\n## usage (WIP)\n\n### change password in config.ini.\n\n### CREATE_SCHEMA = True to create database from scratch.\n\n### LOG_FILE_NAME and configure logger\n\n### link to square_database_structure\n\n## config\n\nsquare_database\\data\\config.ini\n\n## env\n\n- python>=3.12.0\n\n## changelog\n\n### v2.4.0\n\n- set allow_credentials=True.\n\n### v2.3.0\n\n- expanded apply_filters to support additional conditions: ne, lt, lte, gt, gte, like, in_.\n\n### v2.2.1\n\n- update test for root\n\n### v2.2.0\n\n- standardize output format for all endpoints.\n- edit_rows is not patch method.\n- bug fix in get rows for column selection.\n- added total count in get rows.\n- added affected count in insert, edit, and delete rows.\n\n### v2.1.0\n\n- standardize filter input to forward facing data structure.\n- rename ignore_all to apply_filters.\n- add columns in get rows.\n- stricter type checking in pydantic models.\n- refactor logic to apply filters into common function.\n- add pydantic as explicit requirement.\n\n### v2.0.0\n\n- append version number for each endpoint in the api.\n\n### v1.1.0\n\n- remove table creation logic (move to square_database_structure).\n\n### v1.0.3\n\n- add limit, offset and order by in get rows.\n\n### v1.0.2\n\n- database creation logic change.\n\n### v1.0.1\n\n- no changes. (password erase from history.)\n\n### v1.0.0\n\n- initial commit.\n\n## Feedback is appreciated. Thank you!\n\n\n",
"bugtrack_url": null,
"license": null,
"summary": "database layer for my personal server.",
"version": "2.4.0",
"project_urls": {
"Homepage": "https://github.com/thepmsquare/square_database"
},
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "91f15b9a0d216575d62cf7513801a99cc1e1263b7850f602f73050b596afde69",
"md5": "3afe8c358cd66d98e15dc7ba42328593",
"sha256": "659c70127c218bf359bb3330e6e601971aad952cc56fed4d023f9efbf675a454"
},
"downloads": -1,
"filename": "square_database-2.4.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "3afe8c358cd66d98e15dc7ba42328593",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": null,
"size": 8747,
"upload_time": "2024-12-21T14:36:47",
"upload_time_iso_8601": "2024-12-21T14:36:47.474294Z",
"url": "https://files.pythonhosted.org/packages/91/f1/5b9a0d216575d62cf7513801a99cc1e1263b7850f602f73050b596afde69/square_database-2.4.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "eef02b4b2aa3076cdefbecf06c6d62473eefa7e678e6b2ad8cfaf13f9de24065",
"md5": "18e20f67f04020c9ae1249fe6e4b0970",
"sha256": "a74a0044929cb3c99368338f4d805a0b528fb40430f197fbab65bd4035d16aeb"
},
"downloads": -1,
"filename": "square_database-2.4.0.tar.gz",
"has_sig": false,
"md5_digest": "18e20f67f04020c9ae1249fe6e4b0970",
"packagetype": "sdist",
"python_version": "source",
"requires_python": null,
"size": 7960,
"upload_time": "2024-12-21T14:36:49",
"upload_time_iso_8601": "2024-12-21T14:36:49.650319Z",
"url": "https://files.pythonhosted.org/packages/ee/f0/2b4b2aa3076cdefbecf06c6d62473eefa7e678e6b2ad8cfaf13f9de24065/square_database-2.4.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2024-12-21 14:36:49",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "thepmsquare",
"github_project": "square_database",
"travis_ci": false,
"coveralls": false,
"github_actions": true,
"lcname": "square-database"
}
JSON
