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
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
|
##############################################################################
# Copyright (c) 2016 Huawei Technologies Co.,Ltd and others.
#
# All rights reserved. This program and the accompanying materials
# are made available under the terms of the Apache License, Version 2.0
# which accompanies this distribution, and is available at
# http://www.apache.org/licenses/LICENSE-2.0
##############################################################################
import datetime
from sqlalchemy import Column, Integer, String, DateTime
from sqlalchemy.ext.declarative import declarative_base
from dovetail.utils import util
from dovetail.db import exception
BASE = declarative_base()
class MarkTimestamp(object):
created = Column(DateTime, default=lambda: datetime.datetime.now())
updated = Column(DateTime, default=lambda: datetime.datetime.now(),
onupdate=lambda: datetime.datetime.now())
class ModelHandler(object):
def initialize(self):
self.update()
def update(self):
pass
@staticmethod
def type_check(value, column_type):
if value is None:
return True
if not hasattr(column_type, 'python_type'):
return True
column_python_type = column_type.python_type
if isinstance(value, column_python_type):
return True
if issubclass(column_python_type, basestring):
return isinstance(value, basestring)
if column_python_type in [int, long]:
return type(value) in [int, long]
if column_python_type in [float]:
return type(value) in [float]
if column_python_type in [bool]:
return type(value) in [bool]
return False
def validate(self):
columns = self.__mapper__.columns
for key, column in columns.items():
value = getattr(self, key)
if not self.type_check(value, column.type):
raise exception.InvalidParameter(
'column %s value %r type is unexpected: %s' % (
key, value, column.type
)
)
def to_dict(self):
"""General function to convert record to dict.
Convert all columns not starting with '_' to
{<column_name>: <column_value>}
"""
keys = self.__mapper__.columns.keys()
dict_info = {}
for key in keys:
if key.startswith('_'):
continue
value = getattr(self, key)
if value is not None:
if isinstance(value, datetime.datetime):
value = util.format_datetime(value)
dict_info[key] = value
return dict_info
class Result(BASE, MarkTimestamp, ModelHandler):
__tablename__ = 'result'
id = Column(Integer, primary_key=True)
test_id = Column(String(120), unique=True)
name = Column(String(120))
data = Column(String(64000))
def __init__(self, **kwargs):
super(Result, self).__init__(**kwargs)
def __repr__(self):
return '<Result %r>' % (self.name)
def __str__(self):
return 'Result[%s:%s]' % (self.name, self.test_id)
def to_dict(self):
dict_info = super(Result, self).to_dict()
dict_info['name'] = self.name
dict_info['test_id'] = self.test_id
dict_info['data'] = self.data
return dict_info
|