MySQLDBAccess Class Reference

Connects to DB and returns DB object

Connects to database using db_url (database url parsing),
    store host, username, password, db_name

detect database and return VERION data structure or string (verbose=True)

Close DB connection

Escapes string so it can be put in SQL query between quotes

Returns database type. E.g. 'mysql', 'sqlLite' etc.

Useful when creating build_id in database
    Function returns (hostname, uname) which can be used as (build_id_name, build_id_desc)

Insert new build_id (DB unique build like ID number to send all test results)

Checks for entries in tables with two columns (<TABLE_NAME>_pk, <column>)
    If update_db is True updates table entry if value in specified column doesn't exist

Execute INSERT query, define if you want to commit

Inserts test result entry to database. All checks regarding existing
    toolchain names in DB are performed.
    If some data is missing DB will be updated

Inserts test result entry to database. All checks regarding existing
    toolchain names in DB are performed.
    If some data is missing DB will be updated

Returns True if we are connected to database

Parsing SQL DB connection string. String should contain:
    - DB Name, user name, password, URL (DB host), name
    Function should return tuple with parsed (host, user, passwd, db) or None if error
    E.g. connection string: 'mysql://username:password@127.0.0.1/db_name'

Reconnects to DB and returns DB object using stored host name,
    database name and credentials (user name and password)

Execute SELECT query and get all results

Update additional data inside build_id table
    Examples:
    db.update_build_id_info(build_id, _status_fk=self.BUILD_ID_STATUS_COMPLETED, _shuffle_seed=0.0123456789):

Updates table entry if value in specified column doesn't exist
    Locks table to perform atomic read + update