def _load_laps(self, line):
t = float(line[0])
if (t < self.cclock):
self.clap = Lap()
self.clap.session = self.session
self.clap.number = self.cnum + 1
self.clap.time = timedelta(0, self.timelaps[self.cnum])
self.clap.save()
self.cnum += 1
d = Data()
d.lap = self.clap
d.time = timedelta(0, float(line[0]))
d.distance = float(line[1])
d.glat = float(line[2])
d.yawrate = float(line[3])
d.steerangle = float(line[4])
d.speed = float(line[5])
d.glon = float(line[6])
d.gaspedal = float(line[7])
d.brakepedal = float(line[8])
d.gear = float(line[9])
d.save()
self.cclock = t
def _load_laps(self, line): t = float(line[0]) if (t < self.cclock): self.clap = Lap() self.clap.session = self.session self.clap.number = self.cnum + 1 self.clap.time = timedelta(0, self.timelaps[self.cnum]) self.clap.save() self.cnum += 1 d = Data() d.lap = self.clap d.time = timedelta(0, float(line[0])) d.distance = float(line[1]) d.glat = float(line[2]) d.yawrate = float(line[3]) d.steerangle = float(line[4]) d.speed = float(line[5]) d.glon = float(line[6]) d.gaspedal = float(line[7]) d.brakepedal = float(line[8]) d.gear = float(line[9]) d.save() self.cclock = t
class NetKarLoader(Loader):
session = None
timelaps = None
clap = None
cnum = None
cclock = None
def __init__(self, pilot, vehicle, raceway):
Loader.__init__(self, pilot, vehicle, raceway)
self.timelaps = list()
self.cnum = 0
self.cclock = 1
@transaction.commit_on_success
def load(self, fcsv):
timer = time()
self.session = Session()
self.session.pilot = self.pilot
self.session.vehicle = self.vehicle
self.session.raceway = self.raceway
rcsv = csv.reader(fcsv, delimiter=",", quotechar='"')
sdate = stime = sdur = None
nline = 1
for line in rcsv:
if (nline == 18):
self._load_session(sdate, stime, sdur)
elif (nline >= 19):
self._load_laps(line)
else:
if (nline == 7):
sdate = line[1]
elif (nline == 8):
stime = line[1]
elif (nline == 10):
sdur = line[1]
elif (nline == 12):
l = line[1].split(",")
i = 0
while (i < len(l)):
if (i == 0):
n = float(l[i])
self.timelaps.append(n)
else:
n = float(l[i]) - float(l[i - 1])
self.timelaps.append(n)
i += 1
nline += 1
fcsv.close()
self._stat_laps()
print("loaded in %g sec" % (time() - timer))
return self.session.id
def _load_session(self, sdate, stime, sdur):
t = sdate + " " + stime
self.session.date = datetime.strptime(t, "%m/%d/%y %H:%M:%S")
self.session.duration = timedelta(0, float(sdur))
self.session.save()
def _load_laps(self, line):
t = float(line[0])
if (t < self.cclock):
self.clap = Lap()
self.clap.session = self.session
self.clap.number = self.cnum + 1
self.clap.time = timedelta(0, self.timelaps[self.cnum])
self.clap.save()
self.cnum += 1
d = Data()
d.lap = self.clap
d.time = timedelta(0, float(line[0]))
d.distance = float(line[1])
d.glat = float(line[2])
d.yawrate = float(line[3])
d.steerangle = float(line[4])
d.speed = float(line[5])
d.glon = float(line[6])
d.gaspedal = float(line[7])
d.brakepedal = float(line[8])
d.gear = float(line[9])
d.save()
self.cclock = t
def _stat_laps(self):
cur = connection.cursor()
for lap in Lap.objects.filter(session=self.session):
sql = "Select Max(distance), Max(speed), Avg(speed), "
sql += "Max(Abs(glat)), Max(Abs(glon)), "
sql += "Avg(gaspedal), Avg(brakepedal), Avg(gear) "
sql += "From racestat_data Where lap_id = %s"
cur.execute(sql, [lap.id])
stat = cur.fetchone()
lap.distance = float(stat[0])
lap.max_speed = float(stat[1])
lap.avg_speed = float(stat[2])
lap.max_glat = float(stat[3])
lap.max_glon = float(stat[4])
lap.avg_gas = float(stat[5])
lap.avg_brake = float(stat[6])
lap.avg_gear = float(stat[7])
lap.save()
class NetKarLoader(Loader):
session = None
timelaps = None
clap = None
cnum = None
cclock = None
def __init__(self, pilot, vehicle, raceway):
Loader.__init__(self, pilot, vehicle, raceway)
self.timelaps = list()
self.cnum = 0
self.cclock = 1
@transaction.commit_on_success
def load(self, fcsv):
timer = time()
self.session = Session()
self.session.pilot = self.pilot
self.session.vehicle = self.vehicle
self.session.raceway = self.raceway
rcsv = csv.reader(fcsv, delimiter=",", quotechar='"')
sdate = stime = sdur = None
nline = 1
for line in rcsv:
if (nline == 18):
self._load_session(sdate, stime, sdur)
elif (nline >= 19):
self._load_laps(line)
else:
if (nline == 7):
sdate = line[1]
elif (nline == 8):
stime = line[1]
elif (nline == 10):
sdur = line[1]
elif (nline == 12):
l = line[1].split(",")
i = 0
while (i < len(l)):
if (i == 0):
n = float(l[i])
self.timelaps.append(n)
else:
n = float(l[i]) - float(l[i - 1])
self.timelaps.append(n)
i += 1
nline += 1
fcsv.close()
self._stat_laps()
print("loaded in %g sec" % (time() - timer))
return self.session.id
def _load_session(self, sdate, stime, sdur):
t = sdate + " " + stime
self.session.date = datetime.strptime(t, "%m/%d/%y %H:%M:%S")
self.session.duration = timedelta(0, float(sdur))
self.session.save()
def _load_laps(self, line):
t = float(line[0])
if (t < self.cclock):
self.clap = Lap()
self.clap.session = self.session
self.clap.number = self.cnum + 1
self.clap.time = timedelta(0, self.timelaps[self.cnum])
self.clap.save()
self.cnum += 1
d = Data()
d.lap = self.clap
d.time = timedelta(0, float(line[0]))
d.distance = float(line[1])
d.glat = float(line[2])
d.yawrate = float(line[3])
d.steerangle = float(line[4])
d.speed = float(line[5])
d.glon = float(line[6])
d.gaspedal = float(line[7])
d.brakepedal = float(line[8])
d.gear = float(line[9])
d.save()
self.cclock = t
def _stat_laps(self):
cur = connection.cursor()
for lap in Lap.objects.filter(session=self.session):
sql = "Select Max(distance), Max(speed), Avg(speed), "
sql += "Max(Abs(glat)), Max(Abs(glon)), "
sql += "Avg(gaspedal), Avg(brakepedal), Avg(gear) "
sql += "From racestat_data Where lap_id = %s"
cur.execute(sql, [lap.id])
stat = cur.fetchone()
lap.distance = float(stat[0])
lap.max_speed = float(stat[1])
lap.avg_speed = float(stat[2])
lap.max_glat = float(stat[3])
lap.max_glon = float(stat[4])
lap.avg_gas = float(stat[5])
lap.avg_brake = float(stat[6])
lap.avg_gear = float(stat[7])
lap.save()
