-
Notifications
You must be signed in to change notification settings - Fork 0
/
models.py
85 lines (63 loc) · 2.12 KB
/
models.py
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
import csv
import os
import peewee
from peewee import (AutoField, BooleanField, ForeignKeyField, IntegerField,
Model, TextField)
from playhouse.db_url import connect
database = connect(os.environ.get('DATABASE_URL'))
class UnknownField(object):
def __init__(self, *_, **__):
pass
class BaseModel(Model):
class Meta:
database = database
class Riddles(BaseModel):
answer = TextField()
difficulty = IntegerField(null=True)
riddle = TextField()
class Meta:
table_name = 'riddles'
class Users(BaseModel):
email = TextField(null=True)
password = TextField()
user_name = TextField(unique=True)
level = IntegerField()
class Meta:
table_name = 'users'
class Games(BaseModel):
game_id = AutoField()
user_name = ForeignKeyField(
column_name='user_name', field='user_name', model=Users)
class Meta:
table_name = 'games'
class GameResulte(BaseModel):
game = ForeignKeyField(column_name='game_id', field='game_id', model=Games)
game_result = BooleanField()
riddle = ForeignKeyField(column_name='riddle_id', model=Riddles)
class Meta:
table_name = 'game_resulte'
TABLES = [Users, Games, GameResulte, Riddles]
with database.connection_context():
database.create_tables(TABLES, safe=True)
database.commit()
database.close()
# Riddles.create_table()
# Users.create_table()
# Games.create_table()
# GameResulte.create_table()
# credit: falsetru
# link: https://stackoverflow.com/a/21572244
with open('riddles.csv') as f:
data = [{k: v for k, v in row.items()}
for row in csv.DictReader(f, skipinitialspace=True)]
try:
with database.atomic():
# https://github.com/sqlalchemy/sqlalchemy/issues/4656#issuecomment-489233090
# solution for: No value for argument 'database' in method callpylint(no-value-for-parameter)
# noqa pylint: disable=E1120
# noqa pylint: disable=no-value-for-parameter
Riddles.insert_many(data).execute()
database.commit()
except peewee.IntegrityError as err:
print(err, 'riddle db alreay updated')
database.close()