search

laingsimon / courage_scores

Record the scores of courage league darts fixtures
http://thecourageleague.co.uk
Apache License 2.0
0 stars 0 forks source link

Import data from current website #158

Closed laingsimon closed 1 year ago

laingsimon commented 1 year ago
laingsimon commented 1 year ago

player = 180s and hi-checks leghistory = score card data (except for man of the match)

laingsimon commented 1 year ago

fixleft, 24 row/s

  1. fixtlistno Int16
  2. fixldate DateTime
  3. flhomepub String
  4. flawaypub String
  5. won Int32
  6. lost Int32
  7. status String
  8. compind String
  9. flhomename String
  10. flawayname String
  11. fixleth Int32
  12. fixleta Int32
  13. AvB String
  14. weekno Int32
  15. latecard String
  16. division Int32

    fixlist, 56 row/s

  17. fixtlistno Int32
  18. fixldate DateTime
  19. flhomepub String
  20. flawaypub String
  21. won Int32
  22. lost Int32
  23. notes String
  24. compind String
  25. flhomename String
  26. flawayname String
  27. fixleth Int32
  28. fixleta Int32
  29. AvB String
  30. weekno Int32
  31. latecard String
  32. division Int32
  33. card recd DateTime
  34. DIFFERENCE Int32

    FIXRES, 0 row/s

    leghistory, 512 row/s

  35. fixtureno Int16
  36. legkey Int32
  37. hplay String
  38. hplay2 String
  39. hplay3 String
  40. aplay String
  41. aplay2 String
  42. aplay3 String
  43. gamplay Byte
  44. gamwon Byte
  45. gamlost Byte
  46. legswon Int32
  47. legslost Int32
  48. homepub String
  49. awaypub String
  50. fixdate DateTime
  51. Position Byte
  52. division Byte
  53. otherplayer String
  54. homeplayer String
  55. w/l String
  56. opponents String
  57. playerpoints Int32

    legnew, 0 row/s

    Paste Errors, 0 row/s

    player, 48 row/s

  58. playcode String
  59. pubcode String
  60. playername String
  61. singplayed Int32
  62. played Byte
  63. won Byte
  64. lost Byte
  65. pairswon Int32
  66. pairslost Int32
  67. threeswon Int32
  68. threeslost Int32
  69. totwin Int32
  70. totlost Int32
  71. legswon Byte
  72. legslost Byte
  73. legsdiff Double
  74. percent Decimal
  75. points Int32
  76. 180s Byte
  77. hicheck Byte
  78. hicheck2 Int32
  79. hicheck3 Int32
  80. sex String
  81. League Ranking Int32
  82. windiff Int16
  83. pubname String
  84. division Byte
  85. date added DateTime
  86. shortname String

    pub, 7 row/s

  87. pubcode String
  88. pubname String
  89. gamesplay Byte
  90. gameswon Byte
  91. gamesdrawn Int32
  92. gameslost Byte
  93. legswon Int16
  94. legslost Int16
  95. legsdiff Int16
  96. points per leg Int32
  97. points Int16
  98. position Int32
  99. To Play String
  100. fixletter Int32
  101. paired Int32
  102. pubphone String
  103. lower name String
  104. Sing-recd Boolean
  105. pair-recd Boolean
  106. division Int32
  107. Threes received Boolean
  108. Fours received Boolean
  109. Nameforplaylge String
  110. sven String
  111. pven String
  112. tven String
  113. fven String
  114. sthru String
  115. pthru String
  116. tthru String
  117. fthru String
  118. oldpts String
  119. checkpoints Int32
  120. checklegsfor Int32
  121. checklegsag Int32

    pubhistory, 64 row/s

  122. fixtureno Int16
  123. homepub String
  124. awaypub String
  125. gamplay Byte
  126. gamwon Byte
  127. gamlost Byte
  128. points Byte
  129. points per leg Int32
  130. fixtdate DateTime
  131. legswon Double
  132. legslost Double
  133. carddate DateTime
  134. counter1 Int32
  135. home/away String
  136. opponent String
  137. winorlose String
  138. currentpos String
  139. division Byte
  140. status String
  141. update String
laingsimon commented 1 year ago

leghistory

fixtureno legkey hplay hplay2 hplay3 aplay aplay2 aplay3 gamplay gamwon gamlost legswon legslost homepub awaypub fixdate Position division otherplayer homeplayer w/l opponents playerpoints
1102 11768 STEPT YOUND RAIKN JAMEA 1 0 1 3 2 RWY TSD 26/01/2023 00:00:00 6 1 Neil Raikes Taylor Stephens W The Shed 0
1102 11769 TURNM HURLC BLACKP BRYAA 1 0 1 1 3 RWY TSD 26/01/2023 00:00:00 7 1 Paul Blackstone Mike Turner L The Shed 0
1102 11770 YOUND STEPT TURNM BRYAA RAIKN BLACKP 1 0 1 1 3 RWY TSD 26/01/2023 00:00:00 8 1 Andy Bryant Dean Young L The Shed 0
1103 11771 HODDS DUNST 1 1 0 3 0 PDP CRE 26/01/2023 00:00:00 1 1 Tony Dunscombe Sam Hoddinott W Crown Exiles 0
1103 11772 PADDG LILLJ 1 1 0 3 1 PDP CRE 26/01/2023 00:00:00 2 1 John Lilley Guy Paddock W Crown Exiles 0
1103 11773 SMITL BRONM 1 1 0 3 0 PDP CRE 26/01/2023 00:00:00 3 1 Mark Branson Lee Smith W Crown Exiles 0
1103 11774 GOULM GREGL 1 1 0 3 1 PDP CRE 26/01/2023 00:00:00 4 1 Lee Gregory Mark Gould W Crown Exiles 0
1103 11775 SNITM COLML 1 1 0 3 1 PDP CRE 26/01/2023 00:00:00 5 1 Lance Coleman Martin Smith W Crown Exiles 0
1103 11776 HODDS ASHMK DANIC GREGL 1 1 0 3 1 PDP CRE 26/01/2023 00:00:00 6 1 Chris Daniels Sam Hoddinott W Crown Exiles 0
1103 11777 SMITL PADDG LILLJ BRONM 1 1 0 2 3 PDP CRE 26/01/2023 00:00:00 7 1 John Lilley Lee Smith L Crown Exiles 0
game.id game.match.id match.homePlayer[0].id match.homePlayer[1].id match.homePlayer[2].id match.awayPlayer[0].id match.awayPlayer[1].id match.awayPlayer[2].id - - - match.homeScore match.awayScore game.home.id game.away.id game.date match.index game.division match.awayPlayer[0].name match.homePlayer[0].name - game.away.name -
fixtureno legkey hplay hplay2 hplay3 aplay aplay2 aplay3 gamplay gamwon gamlost legswon legslost homepub awaypub fixdate Position division otherplayer homeplayer w/l opponents playerpoints
laingsimon commented 1 year ago

player

playcode pubcode playername singplayed played won lost pairswon pairslost threeswon threeslost totwin totlost legswon legslost legsdiff percent points 180s hicheck hicheck2 hicheck3 sex League Ranking windiff pubname division date added shortname
dunst cre Tony Dunscombe 8 15 2 6 2 1 2 2 6 9 24 38 -14 0.25 8 1 0 0 0 m 0 -4 Crown Exiles 1 31/10/2022 20:56:40
stept rwy Taylor Stephens 9 23 3 6 3 5 1 5 7 16 41 60 -19 0.3333 17 0 132 0 0 m 0 -3 Railway 1 31/10/2022 20:58:30
Hards tsd Steve Hardiee 7 11 0 7 1 0 3 0 4 7 13 32 -19 0.0000 6 1 0 0 0 m 0 -7 The Shed 1 16/10/2022 13:55:05
lains riv Simon Laing 0 3 0 0 0 1 1 1 1 2 6 8 0 0.0000 0 0 0 0 0 m 0 0 Riverside 1 02/11/2022 18:34:13
MALLS RIV Sam Mallon 9 23 4 5 4 4 1 5 9 14 44 56 -12 0.4444 16 0 140 0 0 m 0 -1 Riverside 1 05/05/2010 13:41:34
hodds pdp Sam Hoddinott 8 22 7 1 7 0 7 0 21 1 59 33 26 0.875 22 3 115 0 0 m 0 6 Peasedown Posse 1 02/11/2022 18:38:16
palmr tsd Ryan Palmer 4 11 4 0 4 0 3 0 11 0 31 13 18 1 12 1 135 0 0 m 0 4 The Shed 1 02/11/2022 18:32:14
blackp tsd Paul Blackstone 10 27 8 2 9 1 6 1 23 4 76 44 32 0.8 28 6 150 0 0 m 0 6 The Shed 1 16/10/2022 13:54:51
raikn tsd Neil Raikes 8 23 8 0 5 4 4 2 17 6 62 39 23 1 24 2 154 0 0 m 0 8 The Shed 1 16/10/2022 13:59:36
turnm rwy Mike Turner 9 21 3 6 2 4 2 4 7 14 41 49 -8 0.3333 17 1 134 0 0 m 0 -3 Railway 1 31/10/2022 20:58:56
player.id team.id player.name - - - - - - - - - - - - - - - - - - - - - - team.name team.division.id player.created -
playcode pubcode playername singplayed played won lost pairswon pairslost threeswon threeslost totwin totlost legswon legslost legsdiff percent points 180s hicheck hicheck2 hicheck3 sex League Ranking windiff pubname division date added shortname
laingsimon commented 1 year ago
  1. player → Create team lookup, upsert teams as appropriate
  2. player → Create player lookup, upsert players as appropriate
    1. Requires team lookup
  3. leghistory → Create fixture lookup, upsert fixtures as appropriate
    1. Requires team lookup
    2. Requires player lookup
laingsimon commented 1 year ago

--filePath "D:\temp\league\Blank 5 Legs div1 (1).mdb" --database league_import --season "c41da828-268d-44b3-926a-450cb727e73e" --division "0af902c2-8060-43fe-af00-aab395711ce7"