From 4443f880a714344485df0898363d95f8d7a1f167 Mon Sep 17 00:00:00 2001 From: emkael Date: Tue, 10 Jul 2018 16:15:13 +0200 Subject: 2018 British GP --- rate.log | 56 +++++++++++++++++++++++++++++++++++++++ sql/results.sql | 82 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 138 insertions(+) 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 () 1[1] 2599.73 2602.32 +#5 () 2[2] 2525.26 2527.78 +#7 () 3[3] 2496.35 2497.96 +#77 () 4[4] 2464.01 2464.83 +#33 () 5[5] 2424.46 2424.75 +#3 () 6[6] 2418.17 2417.03 +#20 () 7[7] 2158.32 2164.58 +#8 () 8[8] 2137.69 2143.21 +#16 () 9[9] 2119.37 2124.06 +#31 () 10[10] 2045.58 2051.84 +#27 () 11[11] 2164.43 2164.04 +#11 () 12[12] 2126.87 2126.45 +#14 () 13[13] 2163.17 2159.63 +#10 () 14[14] 2040.4 2040.48 +#26179 () 15[15] 2038.22 2036.8 +#55 () 16[16] 2173.12 2164.37 +#2 () 17[17] 1877.33 1877.41 +#35 () 18[18] 1893.75 1890.73 +#18 () 19[19] 1854.07 1850.28 +#28 () 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 () 1[1] 2527.78 2562.77 +#44 () 2[2] 2602.32 2600.19 +#7 () 3[2] 2497.96 2514.92 +#77 () 4[3] 2464.83 2456.84 +#3 () 5[3] 2417.03 2419.94 +#27 () 6[4] 2164.04 2184.69 +#31 () 7[4] 2051.84 2112.75 +#14 () 8[4] 2159.63 2181.82 +#20 () 9[4] 2164.58 2185.04 +#11 () 10[4] 2126.45 2160.41 +#2 () 11[5] 1877.41 1928.42 +#18 () 12[5] 1850.28 1910.28 +#10 () 13[5] 2040.48 2021.46 +#35 () 14[5] 1890.73 1937.03 +#33 () R[0] 2424.75 2424.75 +#16 () R[0] 2124.06 2124.06 +#28 () R[0] 1894.85 1894.85 +#8 () R[6] 2143.21 2019.19 +#55 () R[6] 2164.37 2032.9 +#9 () 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); -- cgit v1.2.3