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"