fastsql/db_dc.py at main · AnswerDotAI/fastsql · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
__all__ = ["Album", "Artist", "Customer", "Employee", "Genre", "Invoice", "Invoiceline", "Mediatype", "Playlist", "Playlisttrack", "Track"]
from dataclasses import dataclass
from fastsql.core import UNSET
import datetime, decimal
@dataclass
class Album:
    AlbumId: int | None = UNSET
    Title: str | None = UNSET
    ArtistId: int | None = UNSET

@dataclass
class Artist:
    ArtistId: int | None = UNSET
    Name: str | None = UNSET

@dataclass
class Customer:
    CustomerId: int | None = UNSET
    FirstName: str | None = UNSET
    LastName: str | None = UNSET
    Company: str | None = UNSET
    Address: str | None = UNSET
    City: str | None = UNSET
    State: str | None = UNSET
    Country: str | None = UNSET
    PostalCode: str | None = UNSET
    Phone: str | None = UNSET
    Fax: str | None = UNSET
    Email: str | None = UNSET
    SupportRepId: int | None = UNSET

@dataclass
class Employee:
    EmployeeId: int | None = UNSET
    LastName: str | None = UNSET
    FirstName: str | None = UNSET
    Title: str | None = UNSET
    ReportsTo: int | None = UNSET
    BirthDate: datetime.datetime | None = UNSET
    HireDate: datetime.datetime | None = UNSET
    Address: str | None = UNSET
    City: str | None = UNSET
    State: str | None = UNSET
    Country: str | None = UNSET
    PostalCode: str | None = UNSET
    Phone: str | None = UNSET
    Fax: str | None = UNSET
    Email: str | None = UNSET

@dataclass
class Genre:
    GenreId: int | None = UNSET
    Name: str | None = UNSET

@dataclass
class Invoice:
    InvoiceId: int | None = UNSET
    CustomerId: int | None = UNSET
    InvoiceDate: datetime.datetime | None = UNSET
    BillingAddress: str | None = UNSET
    BillingCity: str | None = UNSET
    BillingState: str | None = UNSET
    BillingCountry: str | None = UNSET
    BillingPostalCode: str | None = UNSET
    Total: decimal.Decimal | None = UNSET

@dataclass
class Invoiceline:
    InvoiceLineId: int | None = UNSET
    InvoiceId: int | None = UNSET
    TrackId: int | None = UNSET
    UnitPrice: decimal.Decimal | None = UNSET
    Quantity: int | None = UNSET

@dataclass
class Mediatype:
    MediaTypeId: int | None = UNSET
    Name: str | None = UNSET

@dataclass
class Playlist:
    PlaylistId: int | None = UNSET
    Name: str | None = UNSET

@dataclass
class Playlisttrack:
    PlaylistId: int | None = UNSET
    TrackId: int | None = UNSET

@dataclass
class Track:
    TrackId: int | None = UNSET
    Name: str | None = UNSET
    AlbumId: int | None = UNSET
    MediaTypeId: int | None = UNSET
    GenreId: int | None = UNSET
    Composer: str | None = UNSET
    Milliseconds: int | None = UNSET
    Bytes: int | None = UNSET
    UnitPrice: decimal.Decimal | None = UNSET