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())
def pubop():
#title = u'预发布运营项目'.encode('utf-8')
print(Osyate.addOms())
print(Osyate.sub_form_addOsName('deal_addOsName.py'))
print(Osyate.include_footer())
