def mysql_data(data):
handle = MysqlHandle()
for mysqlData in data:
for courseData in mysqlData:
sql="INSERT INTO cs_cnow(cid,ctime,teacher,classroom,week,class) VALUES('%s','%s','%s','%s','%s','%s')" %(courseData[0],courseData[1],courseData[2],courseData[3],courseData[4],courseData[5])
if handle.execute_sql(sql) == False :
print "error"
return
handle.close_sql()
def dnspodSync():
print time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())
dnsp = dnspod_api.Dnspod()
try:
domlst = dnsp.get_domainlist()
Dnspod_records.objects.filter().delete()
Dnspod_domains.objects.filter().delete()
new_domlst = []
for dlst in domlst:
new_domlst.append(Dnspod_domains(domain_id=dlst["id"],domain=dlst["name"]))
Dnspod_domains.objects.bulk_create(new_domlst)
for v in domlst:
print v
domain_id = v["id"]
record = dnsp.Get_Record(domain_id)
record_lst = []
for line in record:
record_lst.append(Dnspod_records(record_id=line["id"], record=line["name"], record_type=line["type"],domain_id_id=domain_id,record_value=line["value"],record_line=line["line"]))
Dnspod_records.objects.bulk_create(record_lst)
sql = """insert into dnsmanagev2.dnspod_stat (domain,record_count) select b.domain ,count(a.domain_id_id) as record_count from dnsmanagev2.dnspod_records a join dnsmanagev2.dnspod_domains b on a.domain_id_id=b.domain_id group by a.domain_id_id;"""
db = MysqlHandle.database()
db.update(sql)
db.close()
except Exception,e:
print e
#if __name__ == '__main__':
# CdnSync()
strResult = strResult.split("或")
for row in strResult:
if row.find("(") == -1:
token = row
continue
row = token + row
preRow = reg_match(preReg, row)[0]
preResult.append((cid, preRow, _group))
_group += 1
return preResult
else:
return False
if __name__ == "__main__":
handle = MysqlHandle()
for row in read_file():
courseInfo = get_course_info(get_html(courseurl % row[1]))
sql = sql = (
"INSERT INTO cs_course(cid,examway,credit,faculty,cname,detail) VALUES('%s','%s','%s','%s','%s','%s')"
% (
courseInfo["cid"],
courseInfo["examway"],
courseInfo["credit"],
courseInfo["faculty"],
courseInfo["cname"],
courseInfo["detail"],
)
)
if handle.execute_sql(sql) == False:
print "error"
