def genetare_opchannels(): obj = deal_mysql() results = get_formData('which_sp','which_channel') sp_id = results.pop(0) chidlist = results.pop(0) for element in chidlist: msg = ('''insert into ulv_opchannels (sp_id,chid) select %s,%s from DUAL WHERE not exists (SELECT sp_id,chid from ulv_opchannels WHERE sp_id=%s and chid=%s)''' % (sp_id, element, sp_id, element)) obj.updateDb(msg) obj.Close() ''' #Store file to cache ''' json_channelsinfo(int(sp_id)) printChannels.print_operationboundary()
#!/usr/bin/env python #coding:utf-8 import cgi import cgitb from printChannels import print_operationboundary print_operationboundary()