-
Notifications
You must be signed in to change notification settings - Fork 3
/
modeli.py
50 lines (39 loc) · 1.31 KB
/
modeli.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
from dataclasses import dataclass, field
from datetime import date
import psycopg2, psycopg2.extensions, psycopg2.extras
psycopg2.extensions.register_type(psycopg2.extensions.UNICODE) # se znebimo problemov s šumniki
@dataclass
class app_user:
id_user: int = field(default=0)
name: str = field(default="")
surname: str = field(default="")
date_of_birth: date = field(default=(date(2000, 1, 1)))
user_name: str = field(default="")
password: str = field(default="")
@dataclass
class pair:
symbol: str = field(default="")
name: str = field(default="")
@dataclass
class price_history:
symbol_id: str = field(default="")
date: str = field(default="")
price: float = field(default=0)
@dataclass
class asset:
user_id: int = field(default=0)
symbol_id: str = field(default="")
amount: float = field(default=0)
@dataclass
class trade:
user_id: int
symbol_id: str
type: str
date: str
pnl: str
id_trade: int = field(default=0)
strategy: str = field(default=psycopg2.extensions.AsIs('NULL'))
rr: float = field(default=psycopg2.extensions.AsIs('NULL'))
target: float = field(default=psycopg2.extensions.AsIs('NULL'))
duration: str = field(default=psycopg2.extensions.AsIs('NULL'))
tp: int = field(default=psycopg2.extensions.AsIs('NULL'))