Ejemplos de StcnThemeNewsSpiderUtils.getMySQLConn en Python

Ejemplo n.º 1

Archivo: StcnThemeNewsSpider.py Proyecto: nicevoice/SpiderKTServer

def writeDailyThemeNews():
    link = 'http://stock.stcn.com/bankuai/1.shtml'
    currentList = crawDailyThemeNews(link)
    conn = StcnThemeNewsSpiderUtils.getMySQLConn()
    cursor = conn.cursor()    
    try:
        cursor.execute("DELETE FROM STOCK_POOL_THEME_NEWS_TABLE WHERE SOURCEFLAG = 'STCNNET'")
        conn.commit()
    except conn.Error,e:
        print "Mysql Error %d: %s" % (e.args[0], e.args[1])
        conn.rollback()

Ejemplo n.º 2

def writeDailyThemeNews():
    link = 'http://stock.stcn.com/bankuai/1.shtml'
    currentList = crawDailyThemeNews(link)
    conn = StcnThemeNewsSpiderUtils.getMySQLConn()
    cursor = conn.cursor()    
    try:
        cursor.execute("DELETE FROM STOCK_POOL_THEME_NEWS_TABLE WHERE SOURCEFLAG = 'STCNNET'")
        conn.commit()
    except conn.Error,e:
        print "Mysql Error %d: %s" % (e.args[0], e.args[1])
        conn.rollback()