Startup stuff, sourced from startup.ipy



In [1]:

    
# %load startup.ipy
#! /usr/bin/env python3

import sys
sys.path.append('./python')

import logging.config
import os

import xbx.database as xbxdb
import xbx.util as xbxu
import xbx.config as xbxc
import xbx.build as xbxb
import xbx.run as xbxr

logging.config.fileConfig("logging.ini", disable_existing_loggers=False)

CONFIG_PATH="config.ini"

xbxdb.init(xbxu.get_db_path(CONFIG_PATH))
config = xbxc.Config(CONFIG_PATH)

dbsession = xbxdb.scoped_session()

List RunSessions, ordered by descending timestamp



In [2]:

    
s=dbsession
l = s.query(xbxr.RunSession).order_by(xbxr.RunSession.timestamp.desc())
print([i.timestamp for i in l])









    



[datetime.datetime(2016, 12, 2, 22, 38, 2, 458804)]

Print latest RunSession



In [3]:

    
rs=l.first()
print(rs)









    



({'build_session_id': 3, 'config_hash': 'ab41539b8b851cf0746a44d7be30ca023384ea4bb19b6f086f63114d806e1108', 'host': 'ubuntu-pc', 'id': 1, 'timestamp': datetime.datetime(2016, 12, 2, 22, 38, 2, 458804), 'xbh_mac': '001AB602FFA9', 'xbh_rev': 'd9350af', 'xbx_version': '12a34a63309ac2bc477cc798b8adc06762739d2f'}, ['drift_measurements', 'build_execs', 'build_session', 'config'])

We have overridden the __repr__ function in the base class for SqlAlchemy tables to print out the type, a dictionary of contents, and a list of relations.

Let's print out all build executions:



In [4]:

    
print([i for i in rs.build_execs])









    



[({'build_id': 19, 'id': 1, 'run_session_id': 1, 'test_ok': True}, ['build', 'runs', 'run_session'])]

Not much information here. Let's print out information on the builds associated with the build executions:



In [5]:

    
print([(i, i.build) for i in rs.build_execs])









    



[(({'build_id': 19, 'id': 1, 'run_session_id': 1, 'test_ok': True}, ['build', 'runs', 'run_session']), ({'bss': 5320, 'build_ok': True, 'build_session_id': 3, 'compiler_idx': 0, 'data': 0, 'exe_path': 'ek-tm4c123gxl_16mhz/crypto_aead/icepole128v1/ref/0/xbdprog.bin', 'hex_checksum': 'f0fee4952c9e6175acbe366846ca6ebda573998efca268df5cca1390474edcf6', 'hex_path': 'ek-tm4c123gxl_16mhz/crypto_aead/icepole128v1/ref/0/xbdprog.hex', 'id': 19, 'implementation_hash': 'c05a01689d79fca13908d316cbf33f52604daa122d16f0779b6228507f643374', 'log': b'LINK\nPOSTLINK\n', 'operation_name': 'crypto_aead', 'parallel_make': False, 'platform_hash': '659a6aa136e8dd11fe7a6f3673b536f00286703e58cffaa09f7182a0f5a9d538', 'primitive_name': 'icepole128v1', 'rebuilt': True, 'text': 20624, 'timestamp': datetime.datetime(2016, 12, 2, 22, 37, 46, 588863), 'work_path': 'ek-tm4c123gxl_16mhz/crypto_aead/icepole128v1/ref/0'}, ['platform', 'compiler', 'operation', 'primitive', 'implementation', 'build_session']))]

Not very readable. Let's use prettyprint:



In [6]:

    
import pprint
pp = pprint.PrettyPrinter(indent=4)
pp.pprint([(i, i.build) for i in rs.build_execs])









    



[   (   ({'build_id': 19, 'id': 1, 'run_session_id': 1, 'test_ok': True}, ['build', 'runs', 'run_session']),
        ({'bss': 5320, 'build_ok': True, 'build_session_id': 3, 'compiler_idx': 0, 'data': 0, 'exe_path': 'ek-tm4c123gxl_16mhz/crypto_aead/icepole128v1/ref/0/xbdprog.bin', 'hex_checksum': 'f0fee4952c9e6175acbe366846ca6ebda573998efca268df5cca1390474edcf6', 'hex_path': 'ek-tm4c123gxl_16mhz/crypto_aead/icepole128v1/ref/0/xbdprog.hex', 'id': 19, 'implementation_hash': 'c05a01689d79fca13908d316cbf33f52604daa122d16f0779b6228507f643374', 'log': b'LINK\nPOSTLINK\n', 'operation_name': 'crypto_aead', 'parallel_make': False, 'platform_hash': '659a6aa136e8dd11fe7a6f3673b536f00286703e58cffaa09f7182a0f5a9d538', 'primitive_name': 'icepole128v1', 'rebuilt': True, 'text': 20624, 'timestamp': datetime.datetime(2016, 12, 2, 22, 37, 46, 588863), 'work_path': 'ek-tm4c123gxl_16mhz/crypto_aead/icepole128v1/ref/0'}, ['platform', 'compiler', 'operation', 'primitive', 'implementation', 'build_session']))]

Better, but not good. The overridden repr implementation is supposed to be evalable. Note that we need to import datetime and call repr explicitly. Let's try:



In [7]:

    
import datetime
pp.pprint([(eval(repr(i)), eval(repr(i.build))) for i in rs.build_execs])









    



[   (   (   {'build_id': 19, 'id': 1, 'run_session_id': 1, 'test_ok': True},
            ['build', 'runs', 'run_session']),
        (   {   'bss': 5320,
                'build_ok': True,
                'build_session_id': 3,
                'compiler_idx': 0,
                'data': 0,
                'exe_path': 'ek-tm4c123gxl_16mhz/crypto_aead/icepole128v1/ref/0/xbdprog.bin',
                'hex_checksum': 'f0fee4952c9e6175acbe366846ca6ebda573998efca268df5cca1390474edcf6',
                'hex_path': 'ek-tm4c123gxl_16mhz/crypto_aead/icepole128v1/ref/0/xbdprog.hex',
                'id': 19,
                'implementation_hash': 'c05a01689d79fca13908d316cbf33f52604daa122d16f0779b6228507f643374',
                'log': b'LINK\nPOSTLINK\n',
                'operation_name': 'crypto_aead',
                'parallel_make': False,
                'platform_hash': '659a6aa136e8dd11fe7a6f3673b536f00286703e58cffaa09f7182a0f5a9d538',
                'primitive_name': 'icepole128v1',
                'rebuilt': True,
                'text': 20624,
                'timestamp': datetime.datetime(2016, 12, 2, 22, 37, 46, 588863),
                'work_path': 'ek-tm4c123gxl_16mhz/crypto_aead/icepole128v1/ref/0'},
            [   'platform',
                'compiler',
                'operation',
                'primitive',
                'implementation',
                'build_session']))]

Much better. We can see the 0hash and icepole implementations succeeded but the 0hash implementation failed. The log is mostly empty since we've rebuilt and thus there's not much makefile output.

We want to know why the aesgcm implementations failed. To do this, we must examine the runs relation.



In [8]:

    
import datetime
for i in rs.build_execs:
    if not i.test_ok:
        for j in i.runs:
            print(j)

Too much stuff. Let's clean it up:



In [9]:

    
import datetime
for i in rs.build_execs:
    if not i.test_ok:
        for j in i.runs:
            print('{}: {}'.format(i.build.buildid,j.checksumfail_cause))



In [9]:



In [ ]: