class Author(ormar.Model): class Meta(BaseMeta): tablename = "authors" id: int = ormar.Integer(primary_key=True) name: str = ormar.String(max_length=100, **default_fernet) uuid_test = ormar.UUID(default=uuid.uuid4, uuid_format="string") uuid_test2 = ormar.UUID(nullable=True, uuid_format="string") password: str = ormar.String( max_length=128, encrypt_secret="udxc32", encrypt_backend=ormar.EncryptBackends.HASH, ) birth_year: int = ormar.Integer( nullable=True, encrypt_secret="secure89key%^&psdijfipew", encrypt_backend=ormar.EncryptBackends.FERNET, ) test_text: str = ormar.Text(default="", **default_fernet) test_bool: bool = ormar.Boolean(nullable=False, **default_fernet) test_float: float = ormar.Float(**default_fernet) test_float2: float = ormar.Float(nullable=True, **default_fernet) test_datetime = ormar.DateTime(default=datetime.datetime.now, **default_fernet) test_date = ormar.Date(default=datetime.date.today, **default_fernet) test_time = ormar.Time(default=datetime.time, **default_fernet) test_json = ormar.JSON(default={}, **default_fernet) test_bigint: int = ormar.BigInteger(default=0, **default_fernet) test_decimal = ormar.Decimal(scale=2, precision=10, **default_fernet) test_decimal2 = ormar.Decimal(max_digits=10, decimal_places=2, **default_fernet) custom_backend: str = ormar.String( max_length=200, encrypt_secret="asda8", encrypt_backend=ormar.EncryptBackends.CUSTOM, encrypt_custom_backend=DummyBackend, )
class UniquePotatoModel(ormar.Model): class Meta(BaseMeta): pass id = ormar.Integer(primary_key=True) thickness = ormar.Float() mass = ormar.Float() color = ormar.String(max_length=255, unique=True) type = ormar.String(max_length=255)
class CustomPotatoModel(ormar.Model): class Meta(BaseMeta): tablename = "custom_potatoes" potato_id = ormar.Integer(primary_key=True) thickness = ormar.Float() mass = ormar.Float() color = ormar.String(max_length=255) type = ormar.String(max_length=255)
class InvoicePosition(ormar.Model): class Meta(BaseMeta): tablename = "invoiceposition" id = ormar.Integer(primary_key=True) name = ormar.String(max_length=50) vat_rate_id = ormar.ForeignKey(VatRate) num_items = ormar.Float() price_net = ormar.Float() invoice_id = ormar.ForeignKey(Invoice, ondelete="CASCADE")
class Organisation(ormar.Model): class Meta: tablename = "org" metadata = metadata database = database id: int = ormar.Integer(primary_key=True) ident: str = ormar.String(max_length=100, choices=["ACME Ltd", "Other ltd"]) priority: int = ormar.Integer(choices=[1, 2, 3, 4, 5]) priority2: int = ormar.BigInteger(choices=[1, 2, 3, 4, 5]) expire_date: datetime.date = ormar.Date( choices=[datetime.date(2021, 1, 1), datetime.date(2022, 5, 1)]) expire_time: datetime.time = ormar.Time( choices=[datetime.time(10, 0, 0), datetime.time(12, 30)]) expire_datetime: datetime.datetime = ormar.DateTime(choices=[ datetime.datetime(2021, 1, 1, 10, 0, 0), datetime.datetime(2022, 5, 1, 12, 30), ]) random_val: float = ormar.Float(choices=[2.0, 3.5]) random_decimal: decimal.Decimal = ormar.Decimal( scale=2, precision=4, choices=[decimal.Decimal(12.4), decimal.Decimal(58.2)]) random_json: pydantic.Json = ormar.JSON(choices=["aa", '{"aa":"bb"}']) random_uuid: uuid.UUID = ormar.UUID(choices=[uuid1, uuid2]) enum_string: str = ormar.String(max_length=100, choices=list(EnumTest))
class CarrotModel(ormar.Model): class Meta(BaseMeta): pass id = ormar.Integer(primary_key=True) length = ormar.Float() color = ormar.String(max_length=255)
class VatRate(ormar.Model): class Meta(BaseMeta): tablename = "vatrate" id = ormar.Integer(primary_key=True) vat_rate = ormar.Float() comment = ormar.String(max_length=255) enterprise_id = ormar.ForeignKey(Enterprise, ondelete="CASCADE")
class Product(ormar.Model): class Meta(BaseMeta): tablename = "product" id: int = ormar.Integer(primary_key=True) name: str = ormar.String(max_length=100) rating: float = ormar.Float(minimum=1, maximum=5) category = ormar.ForeignKey(Category)
class Weather(ormar.Model): class Meta(MainMeta): pass id: int = ormar.Integer(primary_key=True) temperature: float = ormar.Float() icon: str = ormar.String(max_length=150) pub_date: datetime.datetime = ormar.DateTime(default=datetime.datetime.now)
class Movie(ormar.Model): class Meta: tablename = "movies" metadata = metadata database = database id: int = ormar.Integer(primary_key=True) name: str = ormar.String(max_length=100, nullable=False, name="title") year: int = ormar.Integer() profit: float = ormar.Float() director: Optional[Director] = ormar.ForeignKey(Director)
class Track(ormar.Model): """ `tracks` table mapping. Attributes ---------- id: str, primary key name: str href: str popularity: int, optional danceability: float, optional energy: float, optional loudness: float, optional speechiness: float, optional acousticness: float, optional instrumentalness: float, optional liveness: float, optional valence: float, optional tempo: float, optional key: int, optional mode: int, optional duration_ms: int, optional time_signature: int, optional """ class Meta(BaseMeta): pass id: str = ormar.Text(primary_key=True) name: str = ormar.Text() href: str = ormar.Text() uri: str = ormar.Text() popularity: int = ormar.Integer() danceability: float = ormar.Float(nullable=True) energy: float = ormar.Float(nullable=True) loudness: float = ormar.Float(nullable=True) speechiness: float = ormar.Float(nullable=True) acousticness: float = ormar.Float(nullable=True) instrumentalness: float = ormar.Float(nullable=True) liveness: float = ormar.Float(nullable=True) valence: float = ormar.Float(nullable=True) tempo: float = ormar.Float(nullable=True) key: int = ormar.Integer(nullable=True) mode: int = ormar.Integer(nullable=True) duration_ms: int = ormar.Integer(nullable=True) time_signature: int = ormar.Integer(nullable=True)
class Example(ormar.Model): class Meta: tablename = "example" metadata = metadata database = database id: int = ormar.Integer(primary_key=True) name: str = ormar.String(max_length=200, default="aaa") created: datetime.datetime = ormar.DateTime(default=datetime.datetime.now) created_day: datetime.date = ormar.Date(default=datetime.date.today) created_time: datetime.time = ormar.Time(default=time) description: str = ormar.Text(nullable=True) value: float = ormar.Float(nullable=True) data: pydantic.Json = ormar.JSON(default={})
class ExampleModel(Model): class Meta: tablename = "example" metadata = metadata test: int = ormar.Integer(primary_key=True) test_string: str = ormar.String(max_length=250) test_text: str = ormar.Text(default="") test_bool: bool = ormar.Boolean(nullable=False) test_float: ormar.Float() = None # type: ignore test_datetime = ormar.DateTime(default=datetime.datetime.now) test_date = ormar.Date(default=datetime.date.today) test_time = ormar.Time(default=datetime.time) test_json = ormar.JSON(default={}) test_bigint: int = ormar.BigInteger(default=0) test_decimal = ormar.Decimal(scale=2, precision=10) test_decimal2 = ormar.Decimal(max_digits=10, decimal_places=2)