This repository has been archived by the owner on Apr 16, 2019. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
/
db_tables.py
62 lines (49 loc) · 1.89 KB
/
db_tables.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
#! /usr/bin/env python
import util
from app_config import db
class Usage(db.Model):
__tablename__ = "usage"
id = db.Column(db.Integer, primary_key=True)
clustername = db.Column(db.String(128))
username = db.Column(db.String(128))
runningcores = db.Column(db.Integer)
notrunningcores = db.Column(db.Integer)
created = db.Column(db.DateTime)
def __init__(self, clustername, username, runningcores, notrunningcores, created):
self.clustername = clustername
self.username = username
self.runningcores = runningcores
self.notrunningcores = notrunningcores
self.created = created
def __repr__(self):
return "<{0:20s} on {1:10s} at {2} - running_cores: {3:8d}; not_running_cores: {4:8d}".format(
self.username, self.clustername,
util.format_datetime(self.created),
self.runningcores, self.notrunningcores)
class Account(db.Model):
__tablename__ = "account"
id = db.Column(db.Integer, primary_key=True)
email = db.Column(db.String(128))
password = db.Column(db.String(128))
created = db.Column(db.DateTime)
def __init__(self, email, password, created):
self.email = email
self.password = password
self.created = created
def __repr__(self):
return "<{0} joined at {1})>".format(
self.email,
util.format_datetime(self.created))
class Figure(db.Model):
__tablename__ = 'figure'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(128))
# db.BINARY doesn't work, haven't tried db.BLOB
content = db.Column(db.LargeBinary)
created = db.Column(db.DateTime)
def __init__(self, name, content, created):
self.name = name
self.content = content
self.created = created
def __repr(self):
return "<{0} created on {1}>".format(self.name, self.created)