Daiki Kato / mbed-os-lychee

mbed-os for GR-LYCHEE

Dependents:   mbed-os-example-blinky-gr-lychee GR-Boads_Camera_sample GR-Boards_Audio_Recoder GR-Boads_Camera_DisplayApp ... more

tools/test_db.py@0:f782d9c66c49, 2018-02-02 (annotated)

Committer:
dkato
Date:
Fri Feb 02 05:42:23 2018 +0000
Revision:
0:f782d9c66c49
mbed-os for GR-LYCHEE

Who changed what in which revision?

UserRevisionLine numberNew contents of line
dkato 0:f782d9c66c49 1 """
dkato 0:f782d9c66c49 2 mbed SDK
dkato 0:f782d9c66c49 3 Copyright (c) 2011-2014 ARM Limited
dkato 0:f782d9c66c49 4
dkato 0:f782d9c66c49 5 Licensed under the Apache License, Version 2.0 (the "License");
dkato 0:f782d9c66c49 6 you may not use this file except in compliance with the License.
dkato 0:f782d9c66c49 7 You may obtain a copy of the License at
dkato 0:f782d9c66c49 8
dkato 0:f782d9c66c49 9 http://www.apache.org/licenses/LICENSE-2.0
dkato 0:f782d9c66c49 10
dkato 0:f782d9c66c49 11 Unless required by applicable law or agreed to in writing, software
dkato 0:f782d9c66c49 12 distributed under the License is distributed on an "AS IS" BASIS,
dkato 0:f782d9c66c49 13 WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
dkato 0:f782d9c66c49 14 See the License for the specific language governing permissions and
dkato 0:f782d9c66c49 15 limitations under the License.
dkato 0:f782d9c66c49 16
dkato 0:f782d9c66c49 17 Author: Przemyslaw Wirkus <Przemyslaw.Wirkus@arm.com>
dkato 0:f782d9c66c49 18 """
dkato 0:f782d9c66c49 19
dkato 0:f782d9c66c49 20 import re
dkato 0:f782d9c66c49 21 import json
dkato 0:f782d9c66c49 22
dkato 0:f782d9c66c49 23
dkato 0:f782d9c66c49 24 class BaseDBAccess():
dkato 0:f782d9c66c49 25 """ Class used to connect with test database and store test results
dkato 0:f782d9c66c49 26 """
dkato 0:f782d9c66c49 27 def __init__(self):
dkato 0:f782d9c66c49 28 self.db_object = None
dkato 0:f782d9c66c49 29 self.db_type = None
dkato 0:f782d9c66c49 30 # Connection credentials
dkato 0:f782d9c66c49 31 self.host = None
dkato 0:f782d9c66c49 32 self.user = None
dkato 0:f782d9c66c49 33 self.passwd = None
dkato 0:f782d9c66c49 34 self.db = None
dkato 0:f782d9c66c49 35
dkato 0:f782d9c66c49 36 # Test Suite DB scheme (table names)
dkato 0:f782d9c66c49 37 self.TABLE_BUILD_ID = 'mtest_build_id'
dkato 0:f782d9c66c49 38 self.TABLE_BUILD_ID_STATUS = 'mtest_build_id_status'
dkato 0:f782d9c66c49 39 self.TABLE_BUILD_ID_TYPE = 'mtest_build_id_type'
dkato 0:f782d9c66c49 40 self.TABLE_TARGET = 'mtest_target'
dkato 0:f782d9c66c49 41 self.TABLE_TEST_ENTRY = 'mtest_test_entry'
dkato 0:f782d9c66c49 42 self.TABLE_TEST_ID = 'mtest_test_id'
dkato 0:f782d9c66c49 43 self.TABLE_TEST_RESULT = 'mtest_test_result'
dkato 0:f782d9c66c49 44 self.TABLE_TEST_TYPE = 'mtest_test_type'
dkato 0:f782d9c66c49 45 self.TABLE_TOOLCHAIN = 'mtest_toolchain'
dkato 0:f782d9c66c49 46 # Build ID status PKs
dkato 0:f782d9c66c49 47 self.BUILD_ID_STATUS_STARTED = 1 # Started
dkato 0:f782d9c66c49 48 self.BUILD_ID_STATUS_IN_PROGRESS = 2 # In Progress
dkato 0:f782d9c66c49 49 self.BUILD_ID_STATUS_COMPLETED = 3 #Completed
dkato 0:f782d9c66c49 50 self.BUILD_ID_STATUS_FAILED = 4 # Failed
dkato 0:f782d9c66c49 51 # Build ID type PKs
dkato 0:f782d9c66c49 52 self.BUILD_ID_TYPE_TEST = 1 # Test
dkato 0:f782d9c66c49 53 self.BUILD_ID_TYPE_BUILD_ONLY = 2 # Build Only
dkato 0:f782d9c66c49 54
dkato 0:f782d9c66c49 55 def get_hostname(self):
dkato 0:f782d9c66c49 56 """ Useful when creating build_id in database
dkato 0:f782d9c66c49 57 Function returns (hostname, uname) which can be used as (build_id_name, build_id_desc)
dkato 0:f782d9c66c49 58 """
dkato 0:f782d9c66c49 59 # Get hostname from socket
dkato 0:f782d9c66c49 60 import socket
dkato 0:f782d9c66c49 61 hostname = socket.gethostbyaddr(socket.gethostname())[0]
dkato 0:f782d9c66c49 62 # Get uname from platform resources
dkato 0:f782d9c66c49 63 import platform
dkato 0:f782d9c66c49 64 uname = json.dumps(platform.uname())
dkato 0:f782d9c66c49 65 return (hostname, uname)
dkato 0:f782d9c66c49 66
dkato 0:f782d9c66c49 67 def get_db_type(self):
dkato 0:f782d9c66c49 68 """ Returns database type. E.g. 'mysql', 'sqlLite' etc.
dkato 0:f782d9c66c49 69 """
dkato 0:f782d9c66c49 70 return self.db_type
dkato 0:f782d9c66c49 71
dkato 0:f782d9c66c49 72 def detect_database(self, verbose=False):
dkato 0:f782d9c66c49 73 """ detect database and return VERION data structure or string (verbose=True)
dkato 0:f782d9c66c49 74 """
dkato 0:f782d9c66c49 75 return None
dkato 0:f782d9c66c49 76
dkato 0:f782d9c66c49 77 def parse_db_connection_string(self, str):
dkato 0:f782d9c66c49 78 """ Parsing SQL DB connection string. String should contain:
dkato 0:f782d9c66c49 79 - DB Name, user name, password, URL (DB host), name
dkato 0:f782d9c66c49 80 Function should return tuple with parsed (db_type, username, password, host, db_name) or None if error
dkato 0:f782d9c66c49 81
dkato 0:f782d9c66c49 82 (db_type, username, password, host, db_name) = self.parse_db_connection_string(db_url)
dkato 0:f782d9c66c49 83
dkato 0:f782d9c66c49 84 E.g. connection string: 'mysql://username:password@127.0.0.1/db_name'
dkato 0:f782d9c66c49 85 """
dkato 0:f782d9c66c49 86 result = None
dkato 0:f782d9c66c49 87 if type(str) == type(''):
dkato 0:f782d9c66c49 88 PATTERN = '^([\w]+)://([\w]+):([\w]*)@(.*)/([\w]+)'
dkato 0:f782d9c66c49 89 result = re.match(PATTERN, str)
dkato 0:f782d9c66c49 90 if result is not None:
dkato 0:f782d9c66c49 91 result = result.groups() # Tuple (db_name, host, user, passwd, db)
dkato 0:f782d9c66c49 92 return result # (db_type, username, password, host, db_name)
dkato 0:f782d9c66c49 93
dkato 0:f782d9c66c49 94 def is_connected(self):
dkato 0:f782d9c66c49 95 """ Returns True if we are connected to database
dkato 0:f782d9c66c49 96 """
dkato 0:f782d9c66c49 97 pass
dkato 0:f782d9c66c49 98
dkato 0:f782d9c66c49 99 def connect(self, host, user, passwd, db):
dkato 0:f782d9c66c49 100 """ Connects to DB and returns DB object
dkato 0:f782d9c66c49 101 """
dkato 0:f782d9c66c49 102 pass
dkato 0:f782d9c66c49 103
dkato 0:f782d9c66c49 104 def connect_url(self, db_url):
dkato 0:f782d9c66c49 105 """ Connects to database using db_url (database url parsing),
dkato 0:f782d9c66c49 106 store host, username, password, db_name
dkato 0:f782d9c66c49 107 """
dkato 0:f782d9c66c49 108 pass
dkato 0:f782d9c66c49 109
dkato 0:f782d9c66c49 110 def reconnect(self):
dkato 0:f782d9c66c49 111 """ Reconnects to DB and returns DB object using stored host name,
dkato 0:f782d9c66c49 112 database name and credentials (user name and password)
dkato 0:f782d9c66c49 113 """
dkato 0:f782d9c66c49 114 pass
dkato 0:f782d9c66c49 115
dkato 0:f782d9c66c49 116 def disconnect(self):
dkato 0:f782d9c66c49 117 """ Close DB connection
dkato 0:f782d9c66c49 118 """
dkato 0:f782d9c66c49 119 pass
dkato 0:f782d9c66c49 120
dkato 0:f782d9c66c49 121 def escape_string(self, str):
dkato 0:f782d9c66c49 122 """ Escapes string so it can be put in SQL query between quotes
dkato 0:f782d9c66c49 123 """
dkato 0:f782d9c66c49 124 pass
dkato 0:f782d9c66c49 125
dkato 0:f782d9c66c49 126 def select_all(self, query):
dkato 0:f782d9c66c49 127 """ Execute SELECT query and get all results
dkato 0:f782d9c66c49 128 """
dkato 0:f782d9c66c49 129 pass
dkato 0:f782d9c66c49 130
dkato 0:f782d9c66c49 131 def insert(self, query, commit=True):
dkato 0:f782d9c66c49 132 """ Execute INSERT query, define if you want to commit
dkato 0:f782d9c66c49 133 """
dkato 0:f782d9c66c49 134 pass
dkato 0:f782d9c66c49 135
dkato 0:f782d9c66c49 136 def get_next_build_id(self, name, desc='', location='', type=None, status=None):
dkato 0:f782d9c66c49 137 """ Insert new build_id (DB unique build like ID number to send all test results)
dkato 0:f782d9c66c49 138 """
dkato 0:f782d9c66c49 139 pass
dkato 0:f782d9c66c49 140
dkato 0:f782d9c66c49 141 def get_table_entry_pk(self, table, column, value, update_db=True):
dkato 0:f782d9c66c49 142 """ Checks for entries in tables with two columns (<TABLE_NAME>_pk, <column>)
dkato 0:f782d9c66c49 143 If update_db is True updates table entry if value in specified column doesn't exist
dkato 0:f782d9c66c49 144 """
dkato 0:f782d9c66c49 145 pass
dkato 0:f782d9c66c49 146
dkato 0:f782d9c66c49 147 def update_table_entry(self, table, column, value):
dkato 0:f782d9c66c49 148 """ Updates table entry if value in specified column doesn't exist
dkato 0:f782d9c66c49 149 Locks table to perform atomic read + update
dkato 0:f782d9c66c49 150 """
dkato 0:f782d9c66c49 151 pass
dkato 0:f782d9c66c49 152
dkato 0:f782d9c66c49 153 def update_build_id_info(self, build_id, **kw):
dkato 0:f782d9c66c49 154 """ Update additional data inside build_id table
dkato 0:f782d9c66c49 155 Examples:
dkato 0:f782d9c66c49 156 db.update_build_is(build_id, _status_fk=self.BUILD_ID_STATUS_COMPLETED, _shuffle_seed=0.0123456789):
dkato 0:f782d9c66c49 157 """
dkato 0:f782d9c66c49 158 pass
dkato 0:f782d9c66c49 159
dkato 0:f782d9c66c49 160 def insert_test_entry(self, build_id, target, toolchain, test_type, test_id, test_result, test_time, test_timeout, test_loop, test_extra=''):
dkato 0:f782d9c66c49 161 """ Inserts test result entry to database. All checks regarding existing
dkato 0:f782d9c66c49 162 toolchain names in DB are performed.
dkato 0:f782d9c66c49 163 If some data is missing DB will be updated
dkato 0:f782d9c66c49 164 """
dkato 0:f782d9c66c49 165 pass