def MacAdd(): print(Osyate.start_response()) print(Osyate.addOms()) conn = connect('set_os.ini') cursor = conn.cursor() cursor.execute("""select id,name from u_sp""") result = cursor.fetchall() conn.close() print(Osyate.start_select_mac('deal_addMac.py')) for row in result: print(Osyate.sub_option({row[0]:row[1]})) print(Osyate.sub_pubend_next()) print(Osyate.include_footer())
def EpgUrlAdd(): print(Osyate.addOms()) conn = connect('set_os.ini') cursor = conn.cursor() cursor.execute("""SELECT sp.id,sp.name from u_sp as sp where sp.id not in (SELECT u_hurl.spid from u_hurl where u_hurl.statusid =2) or sp.id not in (SELECT u_hurl.spid from u_hurl)""") result = cursor.fetchall() conn.close() print(Osyate.start_select_Epg('deal_addEpgUrl.py')) for row in result: print(Osyate.sub_option({row[0]:row[1]})) print(Osyate.sub_pubend()) print(Osyate.include_footer())