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
|
# Copyright © 2017 Tom Hacohen
#
# This program is free software: you can redistribute it and/or modify
# it under the terms of the GNU Lesser General Public License as
# published by the Free Software Foundation, version 3.
#
# This library is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program. If not, see <http://www.gnu.org/licenses/>.
import peewee as pw
from . import db
class Config(db.BaseModel):
db_version = pw.IntegerField()
class User(db.BaseModel):
username = pw.CharField(unique=True, null=False)
class JournalEntity(db.BaseModel):
local_user = pw.ForeignKeyField(User, backref='journals')
version = pw.IntegerField()
uid = pw.CharField(null=False, index=True)
owner = pw.CharField(null=True)
encrypted_key = pw.BlobField(null=True)
content = pw.BlobField()
new = pw.BooleanField(null=False, default=False)
dirty = pw.BooleanField(null=False, default=False)
deleted = pw.BooleanField(null=False, default=False)
read_only = pw.BooleanField(null=False, default=False)
remote_last_uid = pw.CharField(null=True, default=None)
class Meta:
indexes = (
(('local_user', 'uid'), True),
)
class EntryEntity(db.BaseModel):
journal = pw.ForeignKeyField(JournalEntity, backref='entries')
uid = pw.CharField(null=False, index=True)
content = pw.BlobField()
new = pw.BooleanField(null=False, default=False)
class Meta:
indexes = (
(('journal', 'uid'), True),
)
order_by = ('id', )
class UserInfo(db.BaseModel):
user = pw.ForeignKeyField(User, primary_key=True, backref='user_info')
pubkey = pw.BlobField(null=False)
content = pw.BlobField(null=False)
|
