File size: 1,028 Bytes
d9dd7e1
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
from peewee import *

connection = SqliteDatabase('database.db')



class BaseModel(Model):
    class Meta:
        database = connection

class User(BaseModel):
    user_id = AutoField()
    login = CharField(unique=True)
    password = CharField()

    class Meta:
        db_table = 'Users'
        order_by = ('user_id',)


class Course(BaseModel):
    course_id = AutoField()
    name = CharField()
    progress = IntegerField()

    class Meta:
        db_table = 'Courses'
        order_by = ('course_id',)
from peewee import *

connection = SqliteDatabase('database.db')



class BaseModel(Model):
    class Meta:
        database = connection

class User(BaseModel):
    user_id = AutoField()
    login = CharField(unique=True)
    password = CharField()

    class Meta:
        db_table = 'Users'
        order_by = ('user_id',)


class Course(BaseModel):
    course_id = AutoField()
    name = CharField()
    progress = IntegerField()

    class Meta:
        db_table = 'Courses'
        order_by = ('course_id',)