| Name | fullmetalalchemy JSON |
| Version |
1.2.0
JSON |
| download |
| home_page | |
| Summary | Easy to use functions for making changes to sql tables using SqlAlchemy. |
| upload_time | 2023-08-11 17:27:26 |
| maintainer | |
| docs_url | None |
| author | Odos Matthews |
| requires_python | >=3.8 |
| license | MIT |
| keywords |
|
| VCS |
|
| bugtrack_url |
|
| requirements |
No requirements were recorded.
|
| Travis-CI |
No Travis.
|
| coveralls test coverage |
No coveralls.
|
-----------------
# FullmetalAlchemy: Easy to use functions for sql table changes
[](https://pypi.org/project/fullmetalalchemy/)
## What is it?
**FullmetalAlchemy** is a Python package with easy to use functions for inserting, deleting, updating, selecting records in SQL tables.
## Where to get it
The source code is currently hosted on GitHub at:
https://github.com/eddiethedean/fullmetalalchemy
```sh
# PyPI
pip install fullmetalalchemy
```
## Dependencies
- [SQLAlchemy - Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL](https://www.sqlalchemy.org/)
## Example
```sh
import fullmetalalchemy as fa
# Create SqlAlchemy engine to connect to database.
engine = fa.create_engine('sqlite:///foo.db')
# Get a SqlAlchemy table to pass to FullmetalAlchemy functions
table = fa.features.get_table('xy', engine)
# Select records
fa.select.select_records_all(table)
[{'id': 1, 'x': 1, 'y': 2}, {'id': 1, 'x': 2, 'y': 3}]
# Insert records
fa.insert.insert_records(table, [{'id': 3, 'x': 3, 'y': 4}, {'id': 4, 'x': 5, 'y': 6}])
# Delete records
fa.delete.delete_records(table, 'id', [1, 3])
# Update records
fa.update.update_records(table, [{'id': 1, 'x': 11, 'y': 22}, {'id': 1, 'x': 23, 'y': 34}], 'id')
```
Raw data
{
"_id": null,
"home_page": "",
"name": "fullmetalalchemy",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.8",
"maintainer_email": "",
"keywords": "",
"author": "Odos Matthews",
"author_email": "",
"download_url": "https://files.pythonhosted.org/packages/5d/f1/60ac9feeea23ff4b028a31106ee5dc7fd1630e15c3f13f952c9d5f70aa00/fullmetalalchemy-1.2.0.tar.gz",
"platform": "unix",
"description": "\n-----------------\n\n# FullmetalAlchemy: Easy to use functions for sql table changes\n[](https://pypi.org/project/fullmetalalchemy/)\n\n\n## What is it?\n\n**FullmetalAlchemy** is a Python package with easy to use functions for inserting, deleting, updating, selecting records in SQL tables.\n\n## Where to get it\nThe source code is currently hosted on GitHub at:\nhttps://github.com/eddiethedean/fullmetalalchemy\n\n```sh\n# PyPI\npip install fullmetalalchemy\n```\n\n## Dependencies\n- [SQLAlchemy - Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL](https://www.sqlalchemy.org/)\n\n\n## Example\n```sh\nimport fullmetalalchemy as fa\n\n# Create SqlAlchemy engine to connect to database.\nengine = fa.create_engine('sqlite:///foo.db')\n\n# Get a SqlAlchemy table to pass to FullmetalAlchemy functions\ntable = fa.features.get_table('xy', engine)\n\n# Select records\nfa.select.select_records_all(table)\n[{'id': 1, 'x': 1, 'y': 2}, {'id': 1, 'x': 2, 'y': 3}]\n\n# Insert records\nfa.insert.insert_records(table, [{'id': 3, 'x': 3, 'y': 4}, {'id': 4, 'x': 5, 'y': 6}])\n\n# Delete records\nfa.delete.delete_records(table, 'id', [1, 3])\n\n# Update records\nfa.update.update_records(table, [{'id': 1, 'x': 11, 'y': 22}, {'id': 1, 'x': 23, 'y': 34}], 'id')\n```\n",
"bugtrack_url": null,
"license": "MIT",
"summary": "Easy to use functions for making changes to sql tables using SqlAlchemy.",
"version": "1.2.0",
"project_urls": null,
"split_keywords": [],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "72a21be9d59aa931fab0a64857c8402b214aeea28ed733bf5cffc7ad6d15ed66",
"md5": "cb5d956539454438706c19339d8ba41a",
"sha256": "632a217499943891e808c37cb895c67d40fe5cc3573f87de52d3ea92608c4280"
},
"downloads": -1,
"filename": "fullmetalalchemy-1.2.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "cb5d956539454438706c19339d8ba41a",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8",
"size": 30077,
"upload_time": "2023-08-11T17:27:23",
"upload_time_iso_8601": "2023-08-11T17:27:23.772037Z",
"url": "https://files.pythonhosted.org/packages/72/a2/1be9d59aa931fab0a64857c8402b214aeea28ed733bf5cffc7ad6d15ed66/fullmetalalchemy-1.2.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "5df160ac9feeea23ff4b028a31106ee5dc7fd1630e15c3f13f952c9d5f70aa00",
"md5": "17ef6d81b022b6f08043273f2fd5e510",
"sha256": "7d249400b1eb0f2e723a688ea191727b60330148383b821c624dadddf0c02318"
},
"downloads": -1,
"filename": "fullmetalalchemy-1.2.0.tar.gz",
"has_sig": false,
"md5_digest": "17ef6d81b022b6f08043273f2fd5e510",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8",
"size": 27260,
"upload_time": "2023-08-11T17:27:26",
"upload_time_iso_8601": "2023-08-11T17:27:26.568316Z",
"url": "https://files.pythonhosted.org/packages/5d/f1/60ac9feeea23ff4b028a31106ee5dc7fd1630e15c3f13f952c9d5f70aa00/fullmetalalchemy-1.2.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-08-11 17:27:26",
"github": false,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"lcname": "fullmetalalchemy"
}
