def test_sql_execute_conn_set():
key = 'rjrxwnsq'
conn = 'conn-label'
element = ET.fromstring(iSqlPrepare(key, QUERY, {'conn': conn}).xml_in())
assert (element.tag == 'sql')
assert (len(element.attrib) == 1)
assert ('var' in element.attrib)
assert (element.attrib['var'] == key)
assert (element.text == '\n')
children = tuple(iter(element))
assert (len(children) == 1)
element = children[0]
assert (element.tag == 'prepare')
assert (element.text == QUERY)
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():
key = 'mulblnxo'
element = ET.fromstring(iSqlPrepare(key, QUERY).xml_in())
assert (element.tag == 'sql')
assert (len(element.attrib) == 1)
assert ('var' in element.attrib)
assert (element.attrib['var'] == key)
assert (element.text == '\n')
children = tuple(iter(element))
assert (len(children) == 1)
element = children[0]
assert (element.tag == 'prepare')
assert (element.text == QUERY)
assert (len(element.attrib) == 2)
assert ('error' in element.attrib)
assert (element.attrib['error'] == 'fast')
assert ('var' in element.attrib)
assert (element.attrib['var'] == key)
def test_sql_execute_options_set():
key = 'ktmqazzp'
options = 'options-label'
element = ET.fromstring(
iSqlPrepare(key, QUERY, {
'options': options
}).xml_in())
assert (element.tag == 'sql')
assert (len(element.attrib) == 1)
assert ('var' in element.attrib)
assert (element.attrib['var'] == key)
assert (element.text == '\n')
children = tuple(iter(element))
assert (len(children) == 1)
element = children[0]
assert (element.tag == 'prepare')
assert (element.text == QUERY)
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_prepare_error_off():
key = 'ysdifjyx'
error = 'off'
element = ET.fromstring(iSqlPrepare(key, QUERY, {'error': error}).xml_in())
assert (element.tag == 'sql')
assert (len(element.attrib) == 1)
assert ('var' in element.attrib)
assert (element.attrib['var'] == key)
assert (element.text == '\n')
children = tuple(iter(element))
assert (len(children) == 1)
element = children[0]
assert (element.tag == 'prepare')
assert (element.text == QUERY)
assert (len(element.attrib) == 2)
assert ('error' in element.attrib)
assert (element.attrib['error'] == error)
assert ('var' in element.attrib)
assert (element.attrib['var'] == key)
def test_sql_execute_stmt_set():
key = 'pivywaqm'
stmt = 'stmt-label'
element = ET.fromstring(iSqlPrepare(key, QUERY, {'stmt': stmt}).xml_in())
assert (element.tag == 'sql')
assert (len(element.attrib) == 1)
assert ('var' in element.attrib)
assert (element.attrib['var'] == key)
assert (element.text == '\n')
children = tuple(iter(element))
assert (len(children) == 1)
element = children[0]
assert (element.tag == 'prepare')
assert (element.text == QUERY)
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)