def test_sql_query():
key = 'dmmyeozq'
element = ET.fromstring(iSqlParm(key, DATA).xml_in())
assert (element.tag == 'parm')
assert (element.text == DATA)
assert (len(element.attrib) == 2)
assert ('io' in element.attrib)
assert (element.attrib['io'] == 'both')
assert ('var' in element.attrib)
assert (element.attrib['var'] == key)
def test_sql_execute_options_set():
key = 'qeficmfx'
options = 'options-label'
element = ET.fromstring(iSqlParm(key, DATA, {'options': options}).xml_in())
assert (element.tag == 'parm')
assert (element.text == DATA)
assert (len(element.attrib) == 3)
assert ('options' in element.attrib)
assert (element.attrib['options'] == options)
assert ('var' in element.attrib)
assert (element.attrib['var'] == key)
def test_sql_execute_stmt_set():
key = 'miecefin'
stmt = 'stmt-label'
element = ET.fromstring(iSqlParm(key, DATA, {'stmt': stmt}).xml_in())
assert (element.tag == 'parm')
assert (element.text == DATA)
assert (len(element.attrib) == 3)
assert ('stmt' in element.attrib)
assert (element.attrib['stmt'] == stmt)
assert ('var' in element.attrib)
assert (element.attrib['var'] == key)
def test_sql_execute_conn_set():
key = 'jrntesje'
conn = 'conn-label'
element = ET.fromstring(iSqlParm(key, DATA, {'conn': conn}).xml_in())
assert (element.tag == 'parm')
assert (element.text == DATA)
assert (len(element.attrib) == 3)
assert ('conn' in element.attrib)
assert (element.attrib['conn'] == conn)
assert ('var' in element.attrib)
assert (element.attrib['var'] == key)
def test_sql_prepare_io_out():
key = 'vqsjrnkv'
io = 'out'
element = ET.fromstring(iSqlParm(key, DATA, {'io': io}).xml_in())
assert (element.tag == 'parm')
assert (element.text == DATA)
assert (len(element.attrib) == 2)
assert ('io' in element.attrib)
assert (element.attrib['io'] == io)
assert ('var' in element.attrib)
assert (element.attrib['var'] == key)