def deal_editOsname():
    osname = ""
    osid = ""

    """
    Get data from cgi
    """
    form_data = cgi.FieldStorage()
    # print form_data
    if "osname" in form_data and "osid" in form_data:
        osname = form_data["osname"].value
        osid = form_data["osid"].value

    conn = connect()
    cursor = conn.cursor()

    """
    Update db if u_sp's data changed!
    """
    if osname != "" and osid != "":
        ms = """update u_sp set name="%s" where id=%s""" % (osname, osid)
        # print ms
        cursor.execute(ms)
        conn.commit()
    editOsname()
Beispiel #2
0
def pubop():          
    msg = ('''SELECT
    sp.name,sp.id,sta.status
    from u_sp as sp,
    u_hurl as url,u_status as sta where
    sp.id = url.spid 
    and url.statusid <> 3 and url.statusid = sta.id''')
    editOsname('项目上线','OsPublish.py',msg)
Beispiel #3
0
def offop():
    msg = ('''SELECT
    sp.name,sp.id,sta.status
    from u_sp as sp,
    u_hurl as url,u_status as sta where
    sp.id = url.spid 
    and url.statusid = 3 and url.statusid = sta.id''')    
    editOsname('项目下线','osOff.py',msg)
Beispiel #4
0
#!/usr/bin/env python
#coding:utf-8
from my_sql import connect
import cgi
import cgitb
from rice import editOsname        
        
editOsname("deal_editOsname.py")