18 lines
632 B
Python
18 lines
632 B
Python
from app.models import get_db
|
|
from app.models.sample import SampleRecord
|
|
from app.models.order import OrderRecord
|
|
from sqlalchemy import func
|
|
|
|
db = next(get_db())
|
|
|
|
min_sample = db.query(func.min(SampleRecord.date)).scalar()
|
|
max_sample = db.query(func.max(SampleRecord.date)).scalar()
|
|
count_sample = db.query(SampleRecord).count()
|
|
|
|
min_order = db.query(func.min(OrderRecord.date)).scalar()
|
|
max_order = db.query(func.max(OrderRecord.date)).scalar()
|
|
count_order = db.query(OrderRecord).count()
|
|
|
|
print(f"Samples: {count_sample}, Min: {min_sample}, Max: {max_sample}")
|
|
print(f"Orders: {count_order}, Min: {min_order}, Max: {max_order}")
|