def roar_main(iworkmode):
croardb=roar_db_cls.cls_roar_db()
## xdatarel=croardb.load_table('object_action_2', \
## ['object','preposition'],['action'])
dbtable='test1'
## dfields={'fieldx1' : 'varchar(20)', 'fieldx2' : 'varchar(20)', 'fieldy' : 'integer[3]'}
## croardb.create_table(dbtable,dfields)
## lfields=list(dfields.keys())
## lfields.sort()
## datavalues=({'fieldx1' : '11', 'fieldx2' : '12', 'fieldy' : [1,None,3] },
## {'fieldx1' : '21', 'fieldx2' : '22', 'fieldy' : [1,None,3] },
## {'fieldx1' : '31', 'fieldx2' : '32', 'fieldy' : [1,2,3] })
## ## datavalues=({'fieldx1' : 11, 'fieldx2' : 12, 'fieldy' : '{1,2,3}'},
## ## {'fieldx1' : 21, 'fieldx2' : 22, 'fieldy' : '{1,2,3}'},
## ## {'fieldx1' : 31, 'fieldx2' : 32, 'fieldy' : '{1,2,3}'})
## ## croardb.insert_table(dbtable,lfields,datavalues)
## datavalues=({'fieldx1' : '11', 'fieldx2' : '12', 'fieldy' : [3,4,5] },
## {'fieldx1' : '21', 'fieldx2' : '22', 'fieldy' : [3,4,5] },
## {'fieldx1' : '31', 'fieldx2' : '32', 'fieldy' : [3,4,5] })
## ## datavalues=({'fieldx1' : '11', 'fieldx2' : '12', 'fieldy' : '{4,5,6}'},
## ## {'fieldx1' : '21', 'fieldx2' : '22', 'fieldy' : '{4,5,6}'},
## ## {'fieldx1' : '31', 'fieldx2' : '32', 'fieldy' : '{4,5,6}' })
## ## croardb.update_table(dbtable,lfields,datavalues)
## ## croardb.load_table(dbtable,lfields[:2],lfields[2:])
## croardb.load_table_mmr(dbtable,lfields)
dfields={'fieldx' : 'integer[3]', 'fieldy' : 'integer[3]'}
croardb.create_table(dbtable,dfields)
lfields=list(dfields.keys())
lfields.sort()
datavalues=({'fieldx' : [4,5,6], 'fieldy' : [1,2,3] },
{'fieldx' : [4,5,6], 'fieldy' : [1,2,3] },
{'fieldx' : [4,5,6], 'fieldy' : [1,2,3] })
croardb.insert_table(dbtable,lfields,datavalues)
datavalues=({'fieldx' : [4,5,6], 'fieldy' : [5,2,3] },
{'fieldx' : [4,5,6], 'fieldy' : [5,2,3] },
{'fieldx' : [4,5,6], 'fieldy' : [5,2,3] })
croardb.update_table(dbtable,lfields,datavalues)
(X,Y)=croardb.load_table_mmr(dbtable,lfields[:1],lfields[1:])
dval=croardb.pyarrays2sqlarray(lfields[:1],lfields[1:],X,Y)
croardb.update_table(dbtable,lfields,dval)
print('Bye')
return
def roar_main(iworkmode):
croardb=roar_db_cls.cls_roar_db()
xdatarel=croardb.load_table('object_action_2', \
['object','preposition'],['action'])
nitem=len(xdatarel[0])
pval=0.1
for i in range(nitem):
## qval=np.random.rand(1)[0]
## if qval<pval:
if i==100:
xdatarel[2][i]=15.0
## croardb.update(xdatarel,'score')
print('Bye')
return
def roar_main(iworkmode):
croardb = roar_db_cls.cls_roar_db()
## xdatarel=croardb.load_table('object_action_2', \
## ['object','preposition'],['action'])
dbtable = 'test1'
## dfields={'fieldx1' : 'varchar(20)', 'fieldx2' : 'varchar(20)', 'fieldy' : 'integer[3]'}
## croardb.create_table(dbtable,dfields)
## lfields=list(dfields.keys())
## lfields.sort()
## datavalues=({'fieldx1' : '11', 'fieldx2' : '12', 'fieldy' : [1,None,3] },
## {'fieldx1' : '21', 'fieldx2' : '22', 'fieldy' : [1,None,3] },
## {'fieldx1' : '31', 'fieldx2' : '32', 'fieldy' : [1,2,3] })
## ## datavalues=({'fieldx1' : 11, 'fieldx2' : 12, 'fieldy' : '{1,2,3}'},
## ## {'fieldx1' : 21, 'fieldx2' : 22, 'fieldy' : '{1,2,3}'},
## ## {'fieldx1' : 31, 'fieldx2' : 32, 'fieldy' : '{1,2,3}'})
## ## croardb.insert_table(dbtable,lfields,datavalues)
## datavalues=({'fieldx1' : '11', 'fieldx2' : '12', 'fieldy' : [3,4,5] },
## {'fieldx1' : '21', 'fieldx2' : '22', 'fieldy' : [3,4,5] },
## {'fieldx1' : '31', 'fieldx2' : '32', 'fieldy' : [3,4,5] })
## ## datavalues=({'fieldx1' : '11', 'fieldx2' : '12', 'fieldy' : '{4,5,6}'},
## ## {'fieldx1' : '21', 'fieldx2' : '22', 'fieldy' : '{4,5,6}'},
## ## {'fieldx1' : '31', 'fieldx2' : '32', 'fieldy' : '{4,5,6}' })
## ## croardb.update_table(dbtable,lfields,datavalues)
## ## croardb.load_table(dbtable,lfields[:2],lfields[2:])
## croardb.load_table_mmr(dbtable,lfields)
dfields = {'fieldx': 'integer[3]', 'fieldy': 'integer[3]'}
croardb.create_table(dbtable, dfields)
lfields = list(dfields.keys())
lfields.sort()
datavalues = ({
'fieldx': [4, 5, 6],
'fieldy': [1, 2, 3]
}, {
'fieldx': [4, 5, 6],
'fieldy': [1, 2, 3]
}, {
'fieldx': [4, 5, 6],
'fieldy': [1, 2, 3]
})
croardb.insert_table(dbtable, lfields, datavalues)
datavalues = ({
'fieldx': [4, 5, 6],
'fieldy': [5, 2, 3]
}, {
'fieldx': [4, 5, 6],
'fieldy': [5, 2, 3]
}, {
'fieldx': [4, 5, 6],
'fieldy': [5, 2, 3]
})
croardb.update_table(dbtable, lfields, datavalues)
(X, Y) = croardb.load_table_mmr(dbtable, lfields[:1], lfields[1:])
dval = croardb.pyarrays2sqlarray(lfields[:1], lfields[1:], X, Y)
croardb.update_table(dbtable, lfields, dval)
print('Bye')
return
