summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authoremkael <emkael@tlen.pl>2018-07-10 16:15:13 +0200
committeremkael <emkael@tlen.pl>2018-07-10 16:15:13 +0200
commit4443f880a714344485df0898363d95f8d7a1f167 (patch)
tree3553ed62c74b83a6d19ab3c574eb43164ece6d10
parente75f7670fac8720baec45f4769d0964fe456bb65 (diff)
2018 British GP
-rw-r--r--rate.log56
-rw-r--r--sql/results.sql82
2 files changed, 138 insertions, 0 deletions
diff --git a/rate.log b/rate.log
index 1a92e7b..87ceb48 100644
--- a/rate.log
+++ b/rate.log
@@ -74511,3 +74511,59 @@ Podium rating: 7411.02 7446.07
Average rating: 2181.1695
Average rating change: 37.34
+usage: elo.py [-h] [--date DATE] [--limit LIMIT] [-v] [--force] [COMMAND]
+elo.py: error: argument COMMAND: invalid choice: 'rate.log' (choose from 'print', 'rate', 'reset', 'init')
+2018 British Grand Prix - qualifying (2018-07-07)
+
+#44 (<Lewis Hamilton (#1140)>) 1[1] 2599.73 2602.32
+#5 (<Sebastian Vettel (#1135)>) 2[2] 2525.26 2527.78
+#7 (<Kimi Räikkönen (#1141)>) 3[3] 2496.35 2497.96
+#77 (<Valtteri Bottas (#1161)>) 4[4] 2464.01 2464.83
+#33 (<Max Verstappen (#1172)>) 5[5] 2424.46 2424.75
+#3 (<Daniel Ricciardo (#1157)>) 6[6] 2418.17 2417.03
+#20 (<Kevin Magnussen (#1165)>) 7[7] 2158.32 2164.58
+#8 (<Romain Grosjean (#1144)>) 8[8] 2137.69 2143.21
+#16 (<Charles Leclerc (#1184)>) 9[9] 2119.37 2124.06
+#31 (<Esteban Ocon (#1179)>) 10[10] 2045.58 2051.84
+#27 (<Nico Hülkenberg (#1148)>) 11[11] 2164.43 2164.04
+#11 (<Sergio Pérez (#1155)>) 12[12] 2126.87 2126.45
+#14 (<Fernando Alonso (#1127)>) 13[13] 2163.17 2159.63
+#10 (<Pierre Gasly (#1182)>) 14[14] 2040.4 2040.48
+#26179 (<Marcus Ericsson (#1167)>) 15[15] 2038.22 2036.8
+#55 (<Carlos Sainz (#1170)>) 16[16] 2173.12 2164.37
+#2 (<Stoffel Vandoorne (#1178)>) 17[17] 1877.33 1877.41
+#35 (<Sergey Sirotkin (#1185)>) 18[18] 1893.75 1890.73
+#18 (<Lance Stroll (#1181)>) 19[19] 1854.07 1850.28
+#28 (<Brendon Hartley (#1183)>) 20[20] 1903.09 1894.85
+
+Podium rating: 7621.34 7628.06
+Average rating: 2181.1695
+Average rating change: 3.0715
+
+2018 British Grand Prix (2018-07-08)
+
+#5 (<Sebastian Vettel (#1135)>) 1[1] 2527.78 2562.77
+#44 (<Lewis Hamilton (#1140)>) 2[2] 2602.32 2600.19
+#7 (<Kimi Räikkönen (#1141)>) 3[2] 2497.96 2514.92
+#77 (<Valtteri Bottas (#1161)>) 4[3] 2464.83 2456.84
+#3 (<Daniel Ricciardo (#1157)>) 5[3] 2417.03 2419.94
+#27 (<Nico Hülkenberg (#1148)>) 6[4] 2164.04 2184.69
+#31 (<Esteban Ocon (#1179)>) 7[4] 2051.84 2112.75
+#14 (<Fernando Alonso (#1127)>) 8[4] 2159.63 2181.82
+#20 (<Kevin Magnussen (#1165)>) 9[4] 2164.58 2185.04
+#11 (<Sergio Pérez (#1155)>) 10[4] 2126.45 2160.41
+#2 (<Stoffel Vandoorne (#1178)>) 11[5] 1877.41 1928.42
+#18 (<Lance Stroll (#1181)>) 12[5] 1850.28 1910.28
+#10 (<Pierre Gasly (#1182)>) 13[5] 2040.48 2021.46
+#35 (<Sergey Sirotkin (#1185)>) 14[5] 1890.73 1937.03
+#33 (<Max Verstappen (#1172)>) R[0] 2424.75 2424.75
+#16 (<Charles Leclerc (#1184)>) R[0] 2124.06 2124.06
+#28 (<Brendon Hartley (#1183)>) R[0] 1894.85 1894.85
+#8 (<Romain Grosjean (#1144)>) R[6] 2143.21 2019.19
+#55 (<Carlos Sainz (#1170)>) R[6] 2164.37 2032.9
+#9 (<Marcus Ericsson (#1167)>) R[6] 2036.8 1951.09
+
+Podium rating: 7628.06 7677.88
+Average rating: 2181.17
+Average rating change: 43.5694117647
+
diff --git a/sql/results.sql b/sql/results.sql
index 95c6c24..5588e81 100644
--- a/sql/results.sql
+++ b/sql/results.sql
@@ -2619,6 +2619,8 @@ INSERT INTO `races` VALUES(2613, '2018 French Grand Prix - qualifying', '2018-06
INSERT INTO `races` VALUES(2614, '2018 French Grand Prix', '2018-06-24', 0, 4);
INSERT INTO `races` VALUES(2615, '2018 Austrian Grand Prix - qualifying', '2018-06-30', 0, 3);
INSERT INTO `races` VALUES(2616, '2018 Austrian Grand Prix', '2018-07-01', 0, 4);
+INSERT INTO `races` VALUES(2617, '2018 British Grand Prix - qualifying', '2018-07-07', 0, 3);
+INSERT INTO `races` VALUES(2618, '2018 British Grand Prix', '2018-07-08', 0, 4);
INSERT INTO `countries` VALUES(9, 'Argentina');
INSERT INTO `countries` VALUES(18, 'Australia');
@@ -60049,6 +60051,46 @@ INSERT INTO `entries` VALUES(56200, 'R', 28, 0, 2616);
INSERT INTO `entries` VALUES(56201, 'R', 3, 0, 2616);
INSERT INTO `entries` VALUES(56202, 'R', 77, 0, 2616);
INSERT INTO `entries` VALUES(56203, 'R', 27, 0, 2616);
+INSERT INTO `entries` VALUES(56204, '1', 44, 1, 2617);
+INSERT INTO `entries` VALUES(56205, '2', 5, 2, 2617);
+INSERT INTO `entries` VALUES(56206, '3', 7, 3, 2617);
+INSERT INTO `entries` VALUES(56207, '4', 77, 4, 2617);
+INSERT INTO `entries` VALUES(56208, '5', 33, 5, 2617);
+INSERT INTO `entries` VALUES(56209, '6', 3, 6, 2617);
+INSERT INTO `entries` VALUES(56210, '7', 20, 7, 2617);
+INSERT INTO `entries` VALUES(56211, '8', 8, 8, 2617);
+INSERT INTO `entries` VALUES(56212, '9', 16, 9, 2617);
+INSERT INTO `entries` VALUES(56213, '10', 31, 10, 2617);
+INSERT INTO `entries` VALUES(56214, '11', 27, 11, 2617);
+INSERT INTO `entries` VALUES(56215, '12', 11, 12, 2617);
+INSERT INTO `entries` VALUES(56216, '13', 14, 13, 2617);
+INSERT INTO `entries` VALUES(56217, '14', 10, 14, 2617);
+INSERT INTO `entries` VALUES(56218, '15', 26179, 15, 2617);
+INSERT INTO `entries` VALUES(56219, '16', 55, 16, 2617);
+INSERT INTO `entries` VALUES(56220, '17', 2, 17, 2617);
+INSERT INTO `entries` VALUES(56221, '18', 35, 18, 2617);
+INSERT INTO `entries` VALUES(56222, '19', 18, 19, 2617);
+INSERT INTO `entries` VALUES(56223, '20', 28, 20, 2617);
+INSERT INTO `entries` VALUES(56224, '1', 5, 1, 2618);
+INSERT INTO `entries` VALUES(56225, '2', 44, 2, 2618);
+INSERT INTO `entries` VALUES(56226, '3', 7, 2, 2618);
+INSERT INTO `entries` VALUES(56227, '4', 77, 3, 2618);
+INSERT INTO `entries` VALUES(56228, '5', 3, 3, 2618);
+INSERT INTO `entries` VALUES(56229, '6', 27, 4, 2618);
+INSERT INTO `entries` VALUES(56230, '7', 31, 4, 2618);
+INSERT INTO `entries` VALUES(56231, '8', 14, 4, 2618);
+INSERT INTO `entries` VALUES(56232, '9', 20, 4, 2618);
+INSERT INTO `entries` VALUES(56233, '10', 11, 4, 2618);
+INSERT INTO `entries` VALUES(56234, '11', 2, 5, 2618);
+INSERT INTO `entries` VALUES(56235, '12', 18, 5, 2618);
+INSERT INTO `entries` VALUES(56236, '13', 10, 5, 2618);
+INSERT INTO `entries` VALUES(56237, '14', 35, 5, 2618);
+INSERT INTO `entries` VALUES(56238, 'R', 33, 0, 2618);
+INSERT INTO `entries` VALUES(56239, 'R', 8, 6, 2618);
+INSERT INTO `entries` VALUES(56240, 'R', 55, 6, 2618);
+INSERT INTO `entries` VALUES(56241, 'R', 9, 6, 2618);
+INSERT INTO `entries` VALUES(56242, 'R', 16, 0, 2618);
+INSERT INTO `entries` VALUES(56243, 'R', 28, 0, 2618);
INSERT INTO `driver_entries` VALUES(1, 1, 1);
INSERT INTO `driver_entries` VALUES(2, 2, 2);
@@ -116393,3 +116435,43 @@ INSERT INTO `driver_entries` VALUES(1183, 56200, 56340);
INSERT INTO `driver_entries` VALUES(1157, 56201, 56341);
INSERT INTO `driver_entries` VALUES(1161, 56202, 56342);
INSERT INTO `driver_entries` VALUES(1148, 56203, 56343);
+INSERT INTO `driver_entries` VALUES(1140, 56204, 56344);
+INSERT INTO `driver_entries` VALUES(1135, 56205, 56345);
+INSERT INTO `driver_entries` VALUES(1141, 56206, 56346);
+INSERT INTO `driver_entries` VALUES(1161, 56207, 56347);
+INSERT INTO `driver_entries` VALUES(1172, 56208, 56348);
+INSERT INTO `driver_entries` VALUES(1157, 56209, 56349);
+INSERT INTO `driver_entries` VALUES(1165, 56210, 56350);
+INSERT INTO `driver_entries` VALUES(1144, 56211, 56351);
+INSERT INTO `driver_entries` VALUES(1184, 56212, 56352);
+INSERT INTO `driver_entries` VALUES(1179, 56213, 56353);
+INSERT INTO `driver_entries` VALUES(1148, 56214, 56354);
+INSERT INTO `driver_entries` VALUES(1155, 56215, 56355);
+INSERT INTO `driver_entries` VALUES(1127, 56216, 56356);
+INSERT INTO `driver_entries` VALUES(1182, 56217, 56357);
+INSERT INTO `driver_entries` VALUES(1167, 56218, 56358);
+INSERT INTO `driver_entries` VALUES(1170, 56219, 56359);
+INSERT INTO `driver_entries` VALUES(1178, 56220, 56360);
+INSERT INTO `driver_entries` VALUES(1185, 56221, 56361);
+INSERT INTO `driver_entries` VALUES(1181, 56222, 56362);
+INSERT INTO `driver_entries` VALUES(1183, 56223, 56363);
+INSERT INTO `driver_entries` VALUES(1135, 56224, 56364);
+INSERT INTO `driver_entries` VALUES(1140, 56225, 56365);
+INSERT INTO `driver_entries` VALUES(1141, 56226, 56366);
+INSERT INTO `driver_entries` VALUES(1161, 56227, 56367);
+INSERT INTO `driver_entries` VALUES(1157, 56228, 56368);
+INSERT INTO `driver_entries` VALUES(1148, 56229, 56369);
+INSERT INTO `driver_entries` VALUES(1179, 56230, 56370);
+INSERT INTO `driver_entries` VALUES(1127, 56231, 56371);
+INSERT INTO `driver_entries` VALUES(1165, 56232, 56372);
+INSERT INTO `driver_entries` VALUES(1155, 56233, 56373);
+INSERT INTO `driver_entries` VALUES(1178, 56234, 56374);
+INSERT INTO `driver_entries` VALUES(1181, 56235, 56375);
+INSERT INTO `driver_entries` VALUES(1182, 56236, 56376);
+INSERT INTO `driver_entries` VALUES(1185, 56237, 56377);
+INSERT INTO `driver_entries` VALUES(1172, 56238, 56378);
+INSERT INTO `driver_entries` VALUES(1144, 56239, 56379);
+INSERT INTO `driver_entries` VALUES(1170, 56240, 56380);
+INSERT INTO `driver_entries` VALUES(1167, 56241, 56381);
+INSERT INTO `driver_entries` VALUES(1184, 56242, 56382);
+INSERT INTO `driver_entries` VALUES(1183, 56243, 56383);