databases/py-aesqlapius 0.0.9_1 FreeBSD
Manage SQL queries as a Python API
- System
- FreeBSD
- Repository
- FreeBSD ports
- Maintainer
- [email protected]
- License
- MIT
- Categories
- databases, python
- Package size
- 33.1 KiB, 177.2 KiB installed
Description
So you don't want to use ORM, and want to organize your SQL queries in a convenient way. Don't mix them with your python code, don't write `execute` and `fetchrow`s by hand for each query. With aesqlapius:
- Store your SQL queries separate from the code, in a dedicated file or directory hierarchy
- Annotate each query with python-like function definition specifying input arguments and output types and patterns
aesqlapius builds a class out of this, where you can call your queries as plain methods. It handles arguments (pass positional or keyword arguments as you like, default values are also handled) and output types and patterns (you may specify whether a method returns iterator, list, dict of rows, or a single row, where row may be represented as a tuple, list, dict, single value or a custom type such as a dataclass).
In the other systems
| System | Port | Version |
|---|---|---|
| FreeBSD | databases/py-aesqlapius | 0.0.9_1 |
| DragonFly | databases/py-aesqlapius | 0.0.9_1 |
Install
Binary package:
pkg install py312-aesqlapius
From the ports tree:
cd /usr/ports/databases/py-aesqlapius/ && make install clean
To depend on this port in another port's Makefile:
RUN_DEPENDS= py312-aesqlapius>0:databases/py-aesqlapius
Packages
The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.
| Repository | aarch64 | amd64 | armv6 | armv7 | i386 |
|---|---|---|---|---|---|
| FreeBSD:14:latest | 0.0.9_1 | 0.0.9_1 | 0.0.9 | 0.0.9_1 | 0.0.9_1 |
| FreeBSD:14:quarterly | 0.0.9_1 | 0.0.9_1 | n/a | 0.0.9_1 | 0.0.9_1 |
| FreeBSD:15:latest | 0.0.9_1 | 0.0.9_1 | n/a | 0.0.9_1 | 0.0.9_1 |
| FreeBSD:15:quarterly | 0.0.9_1 | 0.0.9_1 | n/a | n/a | n/a |
| FreeBSD:16:latest | 0.0.9_1 | 0.0.9_1 | n/a | n/a | n/a |
| FreeBSD:16:quarterly | n/a | n/a | n/a | n/a | n/a |
Dependencies
As this port's Makefile names them.
Test 4
${PYTHON_PKGNAMEPREFIX}pytest>=0: devel/py-pytest${PYTHON_PKGNAMEPREFIX}pytest-asyncio>=0: devel/py-pytest-asyncio${PYTHON_PKGNAMEPREFIX}pytest-datadir>=0: devel/py-pytest-datadir${PYTHON_PKGNAMEPREFIX}sqlite3>=0: databases/py-sqlite3
The full lists below include those, and their dependencies in turn.
Build dependencies 11
Run dependencies 7
No port depends on this one.
Configuration
No options to configure.
- USES
- python
- Service scripts
- none
Files
distinfo 1
| File | Size | SHA256 |
|---|---|---|
| aesqlapius-0.0.9.tar.gz | 24835 | 7c373c47c418352228be4545de936f20a67c79fe089512f9bcec125f66df3e6f |
Master sites 1
- PYPI
Commit history 0
No commits in the history this site was built from.