Simple sqlite3-based ORM
Project description
wurm
Wurm is a simple sqlite3-based ORM.
Usage
# create a table:
@dataclass
class Point(wurm.Table):
x: int
y: int
# types currently supported: int, str, bytes, bool, float
# sqlite3 connections cannot be shared, so call setup_connection once per thread
wurm.setup_connection(sqlite3.connect(":memory:"))
# adding new instances to the database:
point = Point(1, 0)
print(point.rowid) # None
point.insert()
print(point.rowid) # 1
# making changes:
point.x = 2
point.commit()
# simple queries:
point = Point[1] # get by rowid
del Point[1] # delete by rowid
point.delete() # delete from an object
all_points = list(Point) # iterate over a table to get instances for all rows
number_of_points = len(Point) # get the total number of rows in the table
Installation
wurm is distributed on PyPI as a universal wheel and is available on Linux/macOS and Windows and supports Python 3.7+.
$ pip install wurm
Changelog
0.0.2
Ensure tables are created, even in edge cases.
Add support for date, time, datetime and Path.
Add wurm.Unique[T].
License
wurm is distributed under the terms of the MIT License.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
wurm-0.0.2.tar.gz
(5.3 kB
view hashes)
Built Distribution
wurm-0.0.2-py3-none-any.whl
(4.6 kB
view hashes)