def ft_channels_off(): #print(yate.start_response()) obj = deal_mysql() form_data = cgi.FieldStorage() chidlist = form_data.getvalue('which_channel') ''' #if users checked one option the chidlist is a number, else if users checked more then one options, chidlist will be a list instance ''' if isinstance(chidlist,list): for item in chidlist: msg1 = """delete from ulv_opchannels where chid=%s""" % int(item) #print(msg1) obj.updateDb(msg1) msg2 = """delete from ulv_genchannels where channel_id=%s""" % int(item) obj.updateDb(msg2) msg3 = """update tvs_channel set status=0 where chid=%s """ % int(item) obj.updateDb(msg3) else: msg1 = """delete from ulv_opchannels where chid=%s""" % int(chidlist) #print(msg1) obj.updateDb(msg1) msg2 = """delete from ulv_genchannels where channel_id=%s""" % int(chidlist) obj.updateDb(msg2) msg3 = """update tvs_channel set status=0 where chid=%s """ % int(chidlist) obj.updateDb(msg3) obj.Close() channels_offline(True)
def channelop(): respData = get_formData('channel_id','sort_id') obj = deal_mysql() msg=('''insert into ulv_genchannels (channel_id,sort_id) select %s,%s from DUAL WHERE not exists (SELECT channel_id,sort_id from ulv_genchannels WHERE channel_id=%s and sort_id=%s)''' % (respData[0],respData[1],respData[0],respData[1])) obj.updateDb(msg) msgn = """UPDATE tvs_channel set `status`=1 where chid=%s""" % respData[0] obj.updateDb(msgn) obj.Close() printChannels.channels_offline(False)
#!/usr/bin/env python #coding=utf-8 import printChannels printChannels.channels_offline(True)
#!/usr/bin/env python #coding=utf-8 import printChannels printChannels.channels_offline(False)