def conveyToSchoolTable(schoolname, schooltable): '将education表中所有大学的微博用户添加到表中' global GetConnect sql = "select * from education where school = '%s'" % schoolname myconnect = GetConnect() results = myconnect.getData(sql) school_d = School_Db(schooltable) if results: for r in results: schoolers = School_Info(r[1]) school_d.insertIntoDB(schoolers) #print r[1] countsql = "select * from %s" % schooltable count = myconnect.getCount(countsql) return count
def conveyToSchoolTable(schoolname): '将education表中所有大连理工大学的微博用户添加到dlut表中' global GetConnect sql = "select * from education where school = '%s'" % schoolname myconnect = GetConnect() results = myconnect.getData(sql) dlut_d = Dlut_Db() if results: for r in results: dluters = Dlut(r[1]) dlut_d.insertIntoDB(dluters) #print r[1] countsql = "select * from dlut" count = myconnect.getCount(countsql) return count
def main(sourcetable, destable): myconnect = GetConnect() sql = "select * from %s" % sourcetable numrows = myconnect.getCount(sql) myconnect2 = GetConnect() for r in xrange(numrows): row = myconnect.cursor.fetchone() wmd5, weiboid, wcontent = row[0], row[1], row[3] segments = str(getSegments(wcontent)) keywords, is_meaningful = getKeywordsAndIs_Meaningful(wcontent) insert_sql = "replace into %s(wmd5, weiboid, segments, keywords, is_meaningful) values('%s', '%s', '%s', '%s', %s)" % (destable, wmd5, weiboid, segments, keywords, is_meaningful) try: myconnect2.executeDB(insert_sql) except Exception, e: print "Error %d: %s" % (e.args[0],e.args[1])
def main(sourcetable, destable): myconnect = GetConnect() sql = "select * from %s" % sourcetable numrows = myconnect.getCount(sql) myconnect2 = GetConnect() for r in xrange(numrows): row = myconnect.cursor.fetchone() wmd5, weiboid, wcontent = row[0], row[1], row[3] segments = str(getSegments(wcontent)) keywords, is_meaningful = getKeywordsAndIs_Meaningful(wcontent) insert_sql = "replace into %s(wmd5, weiboid, segments, keywords, is_meaningful) values('%s', '%s', '%s', '%s', %s)" % ( destable, wmd5, weiboid, segments, keywords, is_meaningful) try: myconnect2.executeDB(insert_sql) except Exception, e: print "Error %d: %s" % (e.args[0], e.args[1])