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 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 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])
