]> gitweb.michael.orlitzky.com - dead/htsn-import.git/blobdiff - htsn-import.cabal
Allow "TBA" laps in TSN.XML.AutoRacingSchedule.
[dead/htsn-import.git] / htsn-import.cabal
index 1e291e701ca7f911e216bf1016b6f4f723ad403a..d470346fae7fbccc3111d18b06129772852d6010 100644 (file)
@@ -1,5 +1,5 @@
 name:           htsn-import
 name:           htsn-import
-version:        0.0.5
+version:        0.2.4
 cabal-version:  >= 1.8
 author:         Michael Orlitzky
 maintainer:    Michael Orlitzky <michael@orlitzky.com>
 cabal-version:  >= 1.8
 author:         Michael Orlitzky
 maintainer:    Michael Orlitzky <michael@orlitzky.com>
@@ -11,22 +11,197 @@ extra-source-files:
   doc/dbschema/*.png
   doc/htsn-importrc.example
   doc/man1/htsn-import.1
   doc/dbschema/*.png
   doc/htsn-importrc.example
   doc/man1/htsn-import.1
-  doc/README.dbschema
-  doc/README.schemagen
+  doc/CHANGES.database
+  doc/README.development
   doc/TODO
   makefile
   schema/*.dtd
   doc/TODO
   makefile
   schema/*.dtd
+  schemagen/AutoRacingResultsXML/*.xml
   schemagen/Auto_Racing_Schedule_XML/*.xml
   schemagen/Auto_Racing_Schedule_XML/*.xml
+  schemagen/CBASK_3PPctXML/*.xml
+  schemagen/Cbask_All_Tourn_Teams_XML/*.xml
+  schemagen/CBASK_AssistsXML/*.xml
+  schemagen/Cbask_Awards_XML/*.xml
+  schemagen/CBASK_BlocksXML/*.xml
+  schemagen/Cbask_Conf_Standings_XML/*.xml
+  schemagen/Cbask_DivII_III_Indv_Stats_XML/*.xml
+  schemagen/Cbask_DivIII_Team_Stats_XML/*.xml
+  schemagen/Cbask_DivII_Team_Stats_XML/*.xml
+  schemagen/CBASK_FGPctXML/*.xml
+  schemagen/CBASK_FoulsXML/*.xml
+  schemagen/CBASK_FTPctXML/*.xml
+  schemagen/Cbask_Indv_No_Avg_XML/*.xml
+  schemagen/Cbask_Indv_Scoring_XML/*.xml
+  schemagen/Cbask_Indv_Shooting_XML/*.xml
+  schemagen/CBASK_Lineup_XML/*.xml
+  schemagen/CBASK_MinutesXML/*.xml
+  schemagen/Cbask_Polls_XML/*.xml
+  schemagen/cbaskpreviewxml/*.xml
+  schemagen/CBASK_ReboundsXML/*.xml
+  schemagen/CBASK_ScoringLeadersXML/*.xml
+  schemagen/Cbask_Team_Scoring_Rebound_Margin_XML/*.xml
+  schemagen/Cbask_Team_Scoring_XML/*.xml
+  schemagen/Cbask_Team_Shooting_Pct_XML/*.xml
+  schemagen/Cbask_Team_ThreePT_Made_XML/*.xml
+  schemagen/Cbask_Team_ThreePT_PCT_XML/*.xml
+  schemagen/Cbask_Team_Win_Pct_XML/*.xml
+  schemagen/CBASK_TopTwentyFiveResult_XML/*.xml
+  schemagen/Cbask_Top_Twenty_Five_XML/*.xml
+  schemagen/Cbask_Tourn_Awards_XML/*.xml
+  schemagen/Cbask_Tourn_Champs_XML/*.xml
+  schemagen/Cbask_Tourn_Indiv_XML/*.xml
+  schemagen/Cbask_Tourn_Leaders_XML/*.xml
+  schemagen/Cbask_Tourn_MVP_XML/*.xml
+  schemagen/Cbask_Tourn_Records_XML/*.xml
+  schemagen/cflpreviewxml/*.xml
+  schemagen/earlylineXML/*.xml
   schemagen/Heartbeat/*.xml
   schemagen/Heartbeat/*.xml
-  schemagen/injuriesxml/*.xml
   schemagen/Injuries_Detail_XML/*.xml
   schemagen/Injuries_Detail_XML/*.xml
+  schemagen/injuriesxml/*.xml
+  schemagen/jfilexml/*.xml
+  schemagen/LeagueScheduleXML/*.xml
+  schemagen/Matchup_NBA_NHL_XML/*.xml
+  schemagen/Minor_Baseball_League_Leaders_XML/*.xml
+  schemagen/Minor_Baseball_Standings_XML/*.xml
+  schemagen/Minor_Baseball_Transactions_XML/*.xml
+  schemagen/minorscoresxml/*.xml
+  schemagen/mlbbattingavgxml/*.xml
+  schemagen/mlbdoublesleadersxml/*.xml
+  schemagen/MLB_Boxscore_XML/*.xml
+  schemagen/MLB_ERA_Leaders/*.xml
+  schemagen/MLB_Fielding_XML/*.xml
+  schemagen/MLBGamesPlayedXML/*.xml
+  schemagen/MLB_Gaming_Matchup_XML/*.xml
+  schemagen/MLBGIDPXML/*.xml
+  schemagen/MLBHitByPitchXML/*.xml
+  schemagen/mlbhitsleadersxml/*.xml
+  schemagen/mlbhomerunsxml/*.xml
+  schemagen/MLBHRFreqXML/*.xml
+  schemagen/MLBIntWalksXML/*.xml
+  schemagen/MLBKORateXML/*.xml
+  schemagen/MLB_Lineup_XML/*.xml
+  schemagen/MLB_Matchup_XML/*.xml
+  schemagen/mlbonbasepctxml/*.xml
+  schemagen/MLBOPSXML/*.xml
+  schemagen/MLB_earlylineXML/*.xml
+  schemagen/MLB_Pitching_Appearances_Leaders/*.xml
+  schemagen/MLB_Pitching_Balks_Leaders/*.xml
+  schemagen/MLB_Pitching_CG_Leaders/*.xml
+  schemagen/MLB_Pitching_ER_Allowed_Leaders/*.xml
+  schemagen/MLB_Pitching_Hit_Batters_Leaders/*.xml
+  schemagen/MLB_Pitching_Hits_Allowed_Leaders/*.xml
+  schemagen/MLB_Pitching_HR_Allowed_Leaders/*.xml
+  schemagen/MLB_Pitching_IP_Leaders/*.xml
+  schemagen/MLB_Pitching_Runs_Allowed_Leaders/*.xml
+  schemagen/MLB_Pitching_Saves_Leaders/*.xml
+  schemagen/MLB_Pitching_Shut_Outs_Leaders/*.xml
+  schemagen/MLB_Pitching_Starts_Leaders/*.xml
+  schemagen/MLB_Pitching_Strike_Outs_Leaders/*.xml
+  schemagen/MLB_Pitching_Walks_Leaders/*.xml
+  schemagen/MLB_Pitching_WHIP_Leaders/*.xml
+  schemagen/MLB_Pitching_Wild_Pitches_Leaders/*.xml
+  schemagen/MLB_Pitching_Win_Percentage_Leaders/*.xml
+  schemagen/MLB_Pitching_WL_Leaders/*.xml
+  schemagen/MLBPlateAppsXML/*.xml
+  schemagen/mlbpreviewxml/*.xml
+  schemagen/mlbrbisxml/*.xml
+  schemagen/mlbrunsleadersxml/*.xml
+  schemagen/MLBSacFliesXML/*.xml
+  schemagen/MLBSacrificesXML/*.xml
+  schemagen/MLBSBSuccessXML/*.xml
+  schemagen/mlbsluggingpctxml/*.xml
+  schemagen/mlbstandxml/*.xml
+  schemagen/mlbstandxml_preseason/*.xml
+  schemagen/mlbstolenbasexml/*.xml
+  schemagen/mlbtotalbasesleadersxml/*.xml
+  schemagen/mlbtriplesleadersxml/*.xml
+  schemagen/MLBWalkRateXML/*.xml
+  schemagen/mlbwalksleadersxml/*.xml
+  schemagen/MLBXtraBaseHitsXML/*.xml
+  schemagen/MLS_Preview_XML/*.xml
+  schemagen/NBA3PPctXML/*.xml
+  schemagen/NBAAssistsXML/*.xml
+  schemagen/NBABlocksXML/*.xml
+  schemagen/nbaconfrecxml/*.xml
+  schemagen/nbadaysxml/*.xml
+  schemagen/nbadivisionsxml/*.xml
+  schemagen/NBAFGPctXML/*.xml
+  schemagen/NBAFoulsXML/*.xml
+  schemagen/NBAFTPctXML/*.xml
+  schemagen/NBA_Gaming_Matchup_XML/*.xml
+  schemagen/NBALineupXML/*.xml
+  schemagen/NBAMinutesXML/*.xml
+  schemagen/NBA_Playoff_Matchup_XML/*.xml
+  schemagen/nbapreviewxml/*.xml
+  schemagen/NBAReboundsXML/*.xml
+  schemagen/NBAScorersXML/*.xml
+  schemagen/nbastandxml/*.xml
+  schemagen/NBAStealsXML/*.xml
+  schemagen/nbateamleadersxml/*.xml
+  schemagen/NBA_Team_Stats_XML/*.xml
+  schemagen/nbatripledoublexml/*.xml
+  schemagen/NBATurnoversXML/*.xml
+  schemagen/NCAA_Conference_Schedule_XML/*.xml
+  schemagen/NCAA_FB_Preview_XML/*.xml
   schemagen/newsxml/*.xml
   schemagen/newsxml/*.xml
+  schemagen/nflfirstdownxml/*.xml
+  schemagen/NFLFumbleLeaderXML/*.xml
+  schemagen/NFLGiveTakeXML/*.xml
+  schemagen/NFLGrassTurfDomeOutsideXML/*.xml
+  schemagen/NFLInside20XML/*.xml
+  schemagen/NFLInterceptionLeadersXML/*.xml
+  schemagen/NFL_KickingLeaders_XML/*.xml
+  schemagen/NFLKickoffsXML/*.xml
+  schemagen/NFLMondayNightXML/*.xml
+  schemagen/NFL_NBA_Draft_XML/*.xml
+  schemagen/NFL_NCAA_FB_Matchup_XML/*.xml
+  schemagen/NFLPassingLeadersXML/*.xml
+  schemagen/NFLPassLeadXML/*.xml
+  schemagen/nflpreviewxml/*.xml
+  schemagen/NFL_PuntingLeaders_XML/*.xml
+  schemagen/NFLQBStartsXML/*.xml
+  schemagen/NFLReceivingLeadersXML/*.xml
+  schemagen/NFL_Roster_XML/*.xml
+  schemagen/NFLRushingLeadersXML/*.xml
+  schemagen/NFLSackLeadersXML/*.xml
+  schemagen/nflstandxml/*.xml
+  schemagen/NFLTackleFFLeadersXML/*.xml
+  schemagen/NFLTeamRankingsXML/*.xml
+  schemagen/NFL_Team_Stats_XML/*.xml
+  schemagen/NFLTopKickoffReturnXML/*.xml
+  schemagen/NFLTopPerformanceXML/*.xml
+  schemagen/NFLTopPuntReturnXML/*.xml
+  schemagen/NFLTotalYardageXML/*.xml
+  schemagen/NFLYardsXML/*.xml
+  schemagen/nhlpreviewxml/*.xml
   schemagen/Odds_XML/*.xml
   schemagen/Odds_XML/*.xml
+  schemagen/recapxml/*.xml
+  schemagen/Schedule_Changes_XML/*.xml
   schemagen/scoresxml/*.xml
   schemagen/scoresxml/*.xml
+  schemagen/Transactions_XML/*.xml
   schemagen/weatherxml/*.xml
   schemagen/weatherxml/*.xml
+  schemagen/Weekly_Sched_XML/*.xml
+  schemagen/WNBA3PPctXML/*.xml
+  schemagen/WNBAAssistsXML/*.xml
+  schemagen/WNBABlocksXML/*.xml
+  schemagen/WNBAFGPctXML/*.xml
+  schemagen/WNBAFoulsXML/*.xml
+  schemagen/WNBAFTPctXML/*.xml
+  schemagen/WNBAMinutesXML/*.xml
+  schemagen/WNBAReboundsXML/*.xml
+  schemagen/WNBAScorersXML/*.xml
+  schemagen/wnbastandxml/*.xml
+  schemagen/WNBAStealsXML/*.xml
+  schemagen/WNBA_Team_Leaders_XML/*.xml
+  schemagen/WNBATurnoversXML/*.xml
+  schemagen/WorldBaseballPreviewXML/*.xml
   test/shell/*.test
   test/xml/*.xml
   test/xml/*.dtd
   test/shell/*.test
   test/xml/*.xml
   test/xml/*.dtd
+  test/xml/gameinfo/*.xml
+  test/xml/gameinfo/*.dtd
+  test/xml/sportinfo/*.xml
+  test/xml/sportinfo/*.dtd
 synopsis:
   Import XML files from The Sports Network into an RDBMS.
 description:
 synopsis:
   Import XML files from The Sports Network into an RDBMS.
 description:
@@ -43,7 +218,7 @@ description:
   .
   The purpose of /htsn-import/ is to take these XML documents and
   get them into something we can use, a relational database management
   .
   The purpose of /htsn-import/ is to take these XML documents and
   get them into something we can use, a relational database management
-  system (RDBMS), loosely known as a SQL database. The structure of
+  system (RDBMS), i.e. \"a SQL database\". The structure of
   relational database, is, well, relational, and the feed XML is not. So
   there is some work to do before the data can be inserted.
   .
   relational database, is, well, relational, and the feed XML is not. So
   there is some work to do before the data can be inserted.
   .
@@ -76,17 +251,20 @@ executable htsn-import
     base                        >= 4.6 && < 5,
     cmdargs                     >= 0.10.6,
     configurator                >= 0.2,
     base                        >= 4.6 && < 5,
     cmdargs                     >= 0.10.6,
     configurator                >= 0.2,
+    containers                  >= 0.5,
     directory                   >= 1.2,
     filepath                    >= 1.3,
     directory                   >= 1.2,
     filepath                    >= 1.3,
+    fixed-vector-hetero         >= 0.3,
     hslogger                    >= 1.2,
     htsn-common                 >= 0.0.1,
     hxt                         >= 9.3,
     hslogger                    >= 1.2,
     htsn-common                 >= 0.0.1,
     hxt                         >= 9.3,
-    groundhog                   >= 0.5,
-    groundhog-postgresql        >= 0.5,
-    groundhog-sqlite            >= 0.5,
-    groundhog-th                >= 0.5,
+    groundhog                   >= 0.7,
+    groundhog-postgresql        >= 0.7,
+    groundhog-sqlite            >= 0.7,
+    groundhog-th                >= 0.7,
     MissingH                    >= 1.2,
     old-locale                  >= 1,
     MissingH                    >= 1.2,
     old-locale                  >= 1,
+    split                       >= 0.2,
     tasty                       >= 0.8,
     tasty-hunit                 >= 0.8,
     time                        >= 1.4,
     tasty                       >= 0.8,
     tasty-hunit                 >= 0.8,
     time                        >= 1.4,
@@ -105,19 +283,29 @@ executable htsn-import
     Configuration
     ConnectionString
     ExitCodes
     Configuration
     ConnectionString
     ExitCodes
+    Misc
     OptionalConfiguration
     TSN.Codegen
     TSN.Database
     TSN.DbImport
     OptionalConfiguration
     TSN.Codegen
     TSN.Database
     TSN.DbImport
+    TSN.Location
+    TSN.Parse
     TSN.Picklers
     TSN.Picklers
+    TSN.Team
     TSN.XmlImport
     TSN.XmlImport
+    TSN.XML.AutoRacingDriverList
+    TSN.XML.AutoRacingResults
     TSN.XML.AutoRacingSchedule
     TSN.XML.AutoRacingSchedule
+    TSN.XML.EarlyLine
     TSN.XML.GameInfo
     TSN.XML.Heartbeat
     TSN.XML.Injuries
     TSN.XML.InjuriesDetail
     TSN.XML.GameInfo
     TSN.XML.Heartbeat
     TSN.XML.Injuries
     TSN.XML.InjuriesDetail
+    TSN.XML.JFile
+    TSN.XML.MLBEarlyLine
     TSN.XML.News
     TSN.XML.Odds
     TSN.XML.News
     TSN.XML.Odds
+    TSN.XML.ScheduleChanges
     TSN.XML.Scores
     TSN.XML.SportInfo
     TSN.XML.Weather
     TSN.XML.Scores
     TSN.XML.SportInfo
     TSN.XML.Weather
@@ -125,6 +313,7 @@ executable htsn-import
 
   ghc-options:
     -Wall
 
   ghc-options:
     -Wall
+    -fcontext-stack=50
     -fwarn-hi-shadowing
     -fwarn-missing-signatures
     -fwarn-name-shadowing
     -fwarn-hi-shadowing
     -fwarn-missing-signatures
     -fwarn-name-shadowing
@@ -155,17 +344,20 @@ test-suite testsuite
     base                        >= 4.6 && < 5,
     cmdargs                     >= 0.10.6,
     configurator                >= 0.2,
     base                        >= 4.6 && < 5,
     cmdargs                     >= 0.10.6,
     configurator                >= 0.2,
+    containers                  >= 0.5,
     directory                   >= 1.2,
     filepath                    >= 1.3,
     directory                   >= 1.2,
     filepath                    >= 1.3,
+    fixed-vector-hetero         >= 0.3,
     hslogger                    >= 1.2,
     htsn-common                 >= 0.0.1,
     hxt                         >= 9.3,
     hslogger                    >= 1.2,
     htsn-common                 >= 0.0.1,
     hxt                         >= 9.3,
-    groundhog                   >= 0.5,
-    groundhog-postgresql        >= 0.5,
-    groundhog-sqlite            >= 0.5,
-    groundhog-th                >= 0.5,
+    groundhog                   >= 0.7,
+    groundhog-postgresql        >= 0.7,
+    groundhog-sqlite            >= 0.7,
+    groundhog-th                >= 0.7,
     MissingH                    >= 1.2,
     old-locale                  >= 1,
     MissingH                    >= 1.2,
     old-locale                  >= 1,
+    split                       >= 0.2,
     tasty                       >= 0.8,
     tasty-hunit                 >= 0.8,
     time                        >= 1.4,
     tasty                       >= 0.8,
     tasty-hunit                 >= 0.8,
     time                        >= 1.4,
@@ -175,6 +367,7 @@ test-suite testsuite
   -- It's not entirely clear to me why I have to reproduce all of this.
   ghc-options:
     -Wall
   -- It's not entirely clear to me why I have to reproduce all of this.
   ghc-options:
     -Wall
+    -fcontext-stack=50
     -fwarn-hi-shadowing
     -fwarn-missing-signatures
     -fwarn-name-shadowing
     -fwarn-hi-shadowing
     -fwarn-missing-signatures
     -fwarn-name-shadowing
@@ -199,6 +392,7 @@ test-suite doctests
   -- It's not entirely clear to me why I have to reproduce all of this.
   ghc-options:
     -Wall
   -- It's not entirely clear to me why I have to reproduce all of this.
   ghc-options:
     -Wall
+    -fcontext-stack=50
     -fwarn-hi-shadowing
     -fwarn-missing-signatures
     -fwarn-name-shadowing
     -fwarn-hi-shadowing
     -fwarn-missing-signatures
     -fwarn-name-shadowing
@@ -226,17 +420,20 @@ test-suite shelltests
     base                        >= 4.6 && < 5,
     cmdargs                     >= 0.10.6,
     configurator                >= 0.2,
     base                        >= 4.6 && < 5,
     cmdargs                     >= 0.10.6,
     configurator                >= 0.2,
+    containers                  >= 0.5,
     directory                   >= 1.2,
     filepath                    >= 1.3,
     directory                   >= 1.2,
     filepath                    >= 1.3,
+    fixed-vector-hetero         >= 0.3,
     hslogger                    >= 1.2,
     htsn-common                 >= 0.0.1,
     hxt                         >= 9.3,
     hslogger                    >= 1.2,
     htsn-common                 >= 0.0.1,
     hxt                         >= 9.3,
-    groundhog                   >= 0.5,
-    groundhog-postgresql        >= 0.5,
-    groundhog-sqlite            >= 0.5,
-    groundhog-th                >= 0.5,
+    groundhog                   >= 0.7,
+    groundhog-postgresql        >= 0.7,
+    groundhog-sqlite            >= 0.7,
+    groundhog-th                >= 0.7,
     MissingH                    >= 1.2,
     old-locale                  >= 1,
     MissingH                    >= 1.2,
     old-locale                  >= 1,
+    split                       >= 0.2,
     process                     >= 1.1,
     tasty                       >= 0.8,
     tasty-hunit                 >= 0.8,
     process                     >= 1.1,
     tasty                       >= 0.8,
     tasty-hunit                 >= 0.8,