Knight KE / Mbed OS Game_Master

Important changes to repositories hosted on mbed.com

Mbed hosted mercurial repositories are deprecated and are due to be permanently deleted in July 2026.

To keep a copy of this software download the repository Zip archive or clone locally using Mercurial.

It is also possible to export all your personal repositories from the account settings page.

mbed-os/tools/test_db.py@0:9b3d4731edbb, 2018-06-21 (annotated)

Committer:
WFKnight
Date:
Thu Jun 21 13:51:43 2018 +0000
Revision:
0:9b3d4731edbb
UART, RTOS, LED

Who changed what in which revision?

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