DryORM
Code
Result
no cache
SQLite
PostgreSQL 17.4
MariaDB 11.4.5
Select a template
dryorm features
basic
bulk create
bulk fake
csv import
basic fk
self fk
user profile
dryorm tabular output
from django.db import models from datetime import datetime, timedelta class Seizure(models.Model): timestamp = models.DateTimeField() def run(): base_date = datetime(2024, 12, 15) seizures = [] for i in range(10): day_offset = i * 2 seizure_time = base_date + timedelta(days=day_offset, hours=i) seizures.append(Seizure(timestamp=seizure_time)) Seizure.objects.bulk_create(seizures) query = """ SELECT date_series::date AS id, date_series::date AS date, COUNT(app_seizure.timestamp) AS count FROM generate_series('2024-12-15'::date, '2025-01-03'::date, '1 day'::interval) AS date_series LEFT JOIN app_seizure ON app_seizure.timestamp::date = date_series::date GROUP BY date_series ORDER BY date_series; """ results = Seizure.objects.raw(query) for row in results: print(f"{row.date} -> {row.count}")
Output
Show Template
No output.
Queries
TCL
T
DDL
D
SELECT
S
INSERT
I
UPDATE
U
DELETE
D
Queries
Q
(
0
)
No queries.
✖ Close
Save & Share
✖
private?
Save
Save & Copy