DAOModel
An instant CRUD layer for your Python models.
DAOModel is a powerful yet beginner-friendly database toolkit built on top of industry-standard libraries (SQLModel, Pydantic, and SQLAlchemy). It provides everything you need to get your database-backed project up and running quickly.
- Eliminate repetitive work by auto-creating your DAOs
- Make your code more straightforward and readable
- Write less code, which means:
- having a usable product sooner
- reduced testing burden
- minimal potential bugs
Purpose
Assembled from a collection of duplicated logic found across several projects, this library serves as a starting point for your Python project. Though great for complex apps, it's also a great starting point for simple projects. DAOModel will benefit new developers the most by providing a straight forward start to writing code.
A goal of my libraries is to remove upfront hurdles to facilitate learning along the way. Following the Guides, anyone can get started without knowledge of relational databases or SQLAlchemy. If any documentation or design is unclear, please submit a ticket so that I can be sure that even beginners are able to benefit from this project.
Features
- Expands upon SQLModel; works seamlessly with existing models
- SQLAlchemy under the hood; keep existing logic while using DAOModel functions for new code
- A proven, reliable data layer
- Advanced search capabilities without raw SQL
- Quality-of-life additions
Looking for more? Check out my other projects on GitHub
Installation
Python 3.10+ is required.
SQLModel, SQLAlchemy, and all other dependencies will be installed with the pip cmd:
pip install DAOModel
or, given that this project is a development tool, you will likely add DAOModel to requirements.txt or pyproject.toml.
Next, move on to the Getting Started page to begin developing your DAOModels.
Caveats
Database Support
Most testing has been completed using SQLite, though since SQLModel/SQLAlchemy support other database solutions, DAOModel is expected to as well.
Speaking of SQLite, this library configures Foreign Key constraints to be enforced by default in SQLite.
Table Names
Table names are configured to be snake_case which differs from SQLModel. See Table Naming for more information.
Unsupported Functionality
Not all functionality will work as intended through DAOModel. If something isn't supported, submit a ticket or pull request. And remember that you may always use what you can and then override the code or use the query method in DAO to do the rest. It should still save you a lot of lines of code.
1 maintainer
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file daomodel-0.10.3.tar.gz.
File metadata
- Download URL: daomodel-0.10.3.tar.gz
- Upload date:
- Size: 55.8 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
pdm/2.28.1 CPython/3.14.7 Linux/6.17.0-1022-azure
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
edc1cb2c826f6289c0bd43613593345fa779faf244a4d8737211477f5b835e45
|
|
| MD5 |
5b9e58d385d2a252da98ca9ddbfbbede
|
|
| BLAKE2b-256 |
1cbd15689a7fe11663f20345a827c4c84c4537536e666d9fe0adb9f4a195301d
|
File details
Details for the file daomodel-0.10.3-py3-none-any.whl.
File metadata
- Download URL: daomodel-0.10.3-py3-none-any.whl
- Upload date:
- Size: 34.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
pdm/2.28.1 CPython/3.14.7 Linux/6.17.0-1022-azure
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
b929cad5c55d26d5747797dfd5f3a7aaee236f8d9622e1a42cd85fd78f45d388
|
|
| MD5 |
f484bf25a3655443042a783973205110
|
|
| BLAKE2b-256 |
d126bcf3450ef6c54f02b7e243e2dc488d32a1fd00001eefb8ddb281f8206c62
|
