Quick Start
The following is an example of a Cherry
, showing the definition of the model, the addition and deletion of data, etc.
| from datetime import date
from typing import Optional
import cherry
db = cherry.Database("sqlite+aiosqlite:///:memory:")
class Student(cherry.Model):
id: int = cherry.Field(primary_key=True)
name: str = cherry.Field(unique=True, index=True)
age: int
birthday: date = cherry.Field(default_factory=date.today)
school: cherry.ForeignKey[Optional["School"]] = None
cherry_config = cherry.CherryConfig(tablename="student", database=db)
class School(cherry.Model):
id: cherry.PrimaryKey[int]
name: str = cherry.Field(unique=True, index=True)
students: cherry.ReverseRelation[list[Student]] = []
cherry_config = cherry.CherryConfig(tablename="school", database=db)
async def main():
await db.init()
school = await School(id=1, name="school 1").insert()
student1 = await Student(id=1, name="student 1", age=15, school=school).insert()
await Student(id=2, name="student 2", age=18, school=school).insert()
await Student(id=3, name="student 3", age=20, school=school).insert()
student1.age += 1
await student1.save()
await school.fetch_related(School.students)
assert len(school.students) == 3
# Pythonic style
student2: Student = await Student.filter(Student.name == "student 2").get()
# Django style
student2: Student = await Student.filter(name="student 2").get()
students: list[Student] = await Student.filter(Student.age >= 18).all()
student_nums: int = await Student.filter(Student.age >= 18).count()
assert len(students) == student_nums
student_age_avg: Optional[int] = await Student.select().avg(Student.age)
student_with_school: Student = (
await Student.filter(Student.name == "student 3")
.prefetch_related(Student.school)
.get()
)
await Student.select().update(birthday=date(2023, 10, 1))
await Student.filter(Student.age >= 20).delete()
|