#!/bin/python ''' return the args type information as xml format: for example: <vms> <vm> <id></id> <name></name> </vm> <vm>...</vm> . . . </vms> ''' from dbop import Mysql vms_xml = '<?xml version="1.0" encoding="utf-8"?>\n' vms_xml += '<vms>\n' sql_conn = Mysql() sql_conn.connect() data = sql_conn.query("select * from vmtb") for x in data: vms_xml+= '<vm>\n' vms_xml+= '<id>'+str(x[0])+'</id>\n' vms_xml+= '<name>'+str(x[1])+'</name>\n' vms_xml+= '</vm>\n' vms_xml+='</vms>' sql_conn.close() print vms_xml
#!/bin/python ''' return the args type information as xml format: for example: <argtypes> <types> <id></id> <name></name> </types> <types>...</types> . . . </argtypes> ''' from dbop import Mysql types_xml = '<?xml version="1.0" encoding="utf-8"?>\n' types_xml += '<argtypes>\n' sql_conn = Mysql() sql_conn.connect() data = sql_conn.query("select * from argtypestb") for x in data: types_xml+= '<types>\n' types_xml+= '<id>'+str(x[0])+'</id>\n' types_xml+= '<name>'+str(x[1])+'</name>\n' types_xml+= '</types>\n' types_xml+='</argtypes>' sql_conn.close() print types_xml
#!/bin/python from dbop import Mysql conn = Mysql() conn.connect() conn.insertsvtb('sv1', '2', '192.168.1.1', '8090', 'http://asdfasdfasd')
#!/bin/python from dbop import Mysql conn = Mysql() conn.connect() conn.insertsvtb('sv1','2','192.168.1.1','8090','http://asdfasdfasd')