Python SYMetalNetSpiderUtils.getMySQLConn Examples

Example #1

File: SYMetalNetSpider.py Project: nicevoice/SpiderKTServer

def writeDailyMetalComments():
    link = "http://unews.fx678.com/union/ifx/hjsc.html"
    webNet = "http://unews.fx678.com/union/ifx/"
    currentList = crawDailyMetalComments(link, webNet)
    conn = SYMetalNetSpiderUtils.getMySQLConn()
    cursor = conn.cursor()
    try:
        cursor.execute("DELETE  FROM  COMMENTS_METAL_RESOURCE_TABLE  WHERE  SOURCEFLAG = 'SYNET'")
        conn.commit()
    except conn.Error, e:
        print "Mysql Error %d: %s" % (e.args[0], e.args[1])
        conn.rollback()

Example #2

File: SYMetalNetSpider.py Project: wusezhangserver/kttspider

def writeDailyMetalComments():
    link = 'http://unews.fx678.com/union/ifx/hjsc.html'
    webNet = 'http://unews.fx678.com/union/ifx/'
    currentList = crawDailyMetalComments(link, webNet)
    conn = SYMetalNetSpiderUtils.getMySQLConn()
    cursor = conn.cursor()
    try:
        cursor.execute(
            "DELETE  FROM  COMMENTS_METAL_RESOURCE_TABLE  WHERE  SOURCEFLAG = 'SYNET'"
        )
        conn.commit()
    except conn.Error, e:
        print "Mysql Error %d: %s" % (e.args[0], e.args[1])
        conn.rollback()