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
101
102
103
104
105
106
|
from peewee import *
from .base import TestModel
class Person(TestModel):
first = CharField()
last = CharField()
dob = DateField(index=True)
class Meta:
indexes = (
(('first', 'last'), True),
)
class Note(TestModel):
author = ForeignKeyField(Person)
content = TextField()
class Category(TestModel):
parent = ForeignKeyField('self', backref='children', null=True)
name = CharField(max_length=20, primary_key=True)
class Relationship(TestModel):
from_person = ForeignKeyField(Person, backref='relations')
to_person = ForeignKeyField(Person, backref='related_to')
class Register(TestModel):
value = IntegerField()
class User(TestModel):
username = CharField()
class Meta:
table_name = 'users'
class Account(TestModel):
email = CharField()
user = ForeignKeyField(User, backref='accounts', null=True)
class Tweet(TestModel):
user = ForeignKeyField(User, backref='tweets')
content = TextField()
timestamp = TimestampField()
class Favorite(TestModel):
user = ForeignKeyField(User, backref='favorites')
tweet = ForeignKeyField(Tweet, backref='favorites')
class Sample(TestModel):
counter = IntegerField()
value = FloatField(default=1.0)
class SampleMeta(TestModel):
sample = ForeignKeyField(Sample, backref='metadata')
value = FloatField(default=0.0)
class A(TestModel):
a = TextField()
class B(TestModel):
a = ForeignKeyField(A, backref='bs')
b = TextField()
class C(TestModel):
b = ForeignKeyField(B, backref='cs')
c = TextField()
class Emp(TestModel):
first = CharField()
last = CharField()
empno = CharField(unique=True)
class Meta:
indexes = (
(('first', 'last'), True),
)
class OCTest(TestModel):
a = CharField(unique=True)
b = IntegerField(default=0)
c = IntegerField(default=0)
class UKVP(TestModel):
key = TextField()
value = IntegerField()
extra = IntegerField()
class Meta:
# Partial index, the WHERE clause must be reflected in the conflict
# target.
indexes = [
SQL('CREATE UNIQUE INDEX "ukvp_kve" ON "ukvp" ("key", "value") '
'WHERE "extra" > 1')]
|
