def get_or_create_school(name):
    sid = db.find_one_val('select id from school where name=%s', [name])
    if sid is not None:
        return sid
    else:
        print 'insert'
        return db.insert('school', {'name': name})
    if info.has_key('workInfo'):
        save_work_info(uid, info['workInfo'])
        del info['workInfo']

    if info.has_key('frd_list'):
        save_friends_info(uid, info['frd_list'])
        del info['frd_list']

    save_basic_info(uid, info)


# uid = '21441'
# print 'get_info'
# info = get_info(uid)
# print 'info', json.dumps(info, encoding="UTF-8", ensure_ascii=False)


while True:
    uid = db.find_one_val('select uid from student where has_visit_info=0 limit 1')
    if uid:
        print '--------------------',uid
        info = get_info(uid)
        if info == False:
            print 'error'
            break
        print json.dumps(info, encoding="UTF-8", ensure_ascii=False)
        save_info(uid, info)
        # break
    else:
        break