cursor = conn.cursor() ; cursor.execute("insert into athletes(name,birthday)values(?,?)",(athlete.name,athlete.birth)); conn.commit() ; conn.close() ; def insert_detail(db_name,athlete,id): # @ReservedAssignment conn = sqlite3.connect(db_name); cursor = conn.cursor() ; cursor.execute("insert into athletes_datas(athlete_id,value)values(?,?)",(id,str(athlete.top))); conn.commit() ; conn.close() ; james = 'james2.txt' ; athlete = get_data_in_file(james) ; insert_data(db_name,athlete); insert_detail(db_name,athlete,1); def select_data(db_name,id): # @ReservedAssignment conn = sqlite3.connect(db_name) ; cursor = conn.cursor() ; results = cursor.execute("select name,birthday,value from athletes ath left join athletes_datas det on ath.id = det.athlete_id where ath.id = ? ",(id,)) ; (name,birth,value) = results.fetchone(); # print(name); # print(birth); # print(value); return Athlete(name,birth,value);
''' Created on 2014-1-21 @author: Administrator ''' #import class/method from athelets import get_data_filelist, get_data_in_file james = get_data_in_file('james2.txt') print(james.name); print(get_data_filelist(['james2.txt']));