trace=0)
mis.connect_to_metastore(dbms='mariadb',
host='localhost',
port=3306,
user='******',
password='******',
database='TRIADB',
trace=0)
# Set DataModel
eng = mis.restart(200, reset=True)
print(mis)
print(eng)
mis.get_entities()
mis.get_attributes()
# Set AssociativeSet
part_aset = mis.engine.get_aset(alias='PRT')
# Construct Associations from dictionaries
prt0 = {
'key': (7, 0),
'p_id': 223,
'p_name': 'Left Handed...',
'p_color': 'Red',
'p_weight': 15.5,
'p_unit': 'lb'
}
prt4 = {'key': (7, 4), 'p_id': 227, 'p_name': 'I Brake for Crop...'}
mis.connect_to_datastore(dbms='clickhouse', host='localhost', port=9000,
user='******', password='******', database='TriaDB', trace=0)
mis.connect_to_metastore(dbms='mariadb', host='localhost', port=3306,
user='******', password='******', database='TRIADB', trace=0)
# ===========================================================================
# Select DataModel, DataResource, Start MIS
# ===========================================================================
eng = mis.restart(500, reset=True)
print(mis)
print(eng)
mis.get_attributes(select='dim2, cname, alias')
mis.get_entities(select='dim2, cname, alias')
mis.get_asets()
# Selections Set
selections = [
eng.set_hacol(alias='p_color').cql.Select().Where("$v='Red'"),
eng.set_hacol(alias='c_price').cql.Select().Where('$v<20'),
eng.set_hacol(alias='c_quantity').cql.Select().Where('$v=200'),
eng.set_hacol(alias='c_check').cql.Select().Where('$v=0')
]
# Progressive (Single) filtering mode, filter ASETs each time with one selection
#
# Single Mode Filtering with one selection only
eng.filter_selections(selections[0])
# Single Mode Filtering with a set of selections