name: htsn-import
-version: 0.0.1
+version: 0.2.0
cabal-version: >= 1.8
author: Michael Orlitzky
maintainer: Michael Orlitzky <michael@orlitzky.com>
license-file: doc/LICENSE
build-type: Simple
extra-source-files:
- doc/htsnrc-import.example
+ doc/dbschema/*.png
+ doc/htsn-importrc.example
doc/man1/htsn-import.1
+ doc/CHANGES.database
+ doc/README.development
+ doc/TODO
makefile
- test/xml/*.xml
schema/*.dtd
- schemagen/*/*.xml
+ schemagen/AutoRacingResultsXML/*.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_Scoring_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_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/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/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/recapxml/*.xml
+ schemagen/Schedule_Changes_XML/*.xml
+ schemagen/scoresxml/*.xml
+ schemagen/Transactions_XML/*.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/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:
.
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.
.
executable htsn-import
build-depends:
- base == 4.*,
+ base >= 4.6 && < 5,
cmdargs >= 0.10.6,
- configurator == 0.2.*,
- directory == 1.2.*,
- filepath == 1.3.*,
- hslogger == 1.2.*,
- htsn-common == 0.0.1,
- hxt == 9.3.*,
- groundhog == 0.4.*,
- groundhog-postgresql == 0.4.*,
- groundhog-sqlite == 0.4.*,
- groundhog-th == 0.4.*,
- MissingH == 1.2.*,
- old-locale == 1.0.*,
- tasty == 0.7.*,
- tasty-hunit == 0.4.*,
- time == 1.4.*,
- transformers == 0.3.*,
- tuple == 0.2.*
+ configurator >= 0.2,
+ directory >= 1.2,
+ filepath >= 1.3,
+ hslogger >= 1.2,
+ htsn-common >= 0.0.1,
+ hxt >= 9.3,
+ generics-sop >= 0.1,
+ groundhog >= 0.5,
+ groundhog-postgresql >= 0.5,
+ groundhog-sqlite >= 0.5,
+ groundhog-th >= 0.5,
+ MissingH >= 1.2,
+ old-locale >= 1,
+ split >= 0.2,
+ tasty >= 0.8,
+ tasty-hunit >= 0.8,
+ time >= 1.4,
+ transformers >= 0.3,
+ tuple >= 0.2
main-is:
Main.hs
Configuration
ConnectionString
ExitCodes
+ Generics
OptionalConfiguration
TSN.Codegen
+ TSN.Database
TSN.DbImport
+ TSN.Location
+ TSN.Parse
TSN.Picklers
+ TSN.Team
TSN.XmlImport
+ TSN.XML.AutoRacingDriverList
+ TSN.XML.AutoRacingResults
+ TSN.XML.AutoRacingSchedule
+ TSN.XML.EarlyLine
+ TSN.XML.GameInfo
TSN.XML.Heartbeat
TSN.XML.Injuries
TSN.XML.InjuriesDetail
+ TSN.XML.JFile
+ TSN.XML.MLBBoxScore
+ TSN.XML.MLBEarlyLine
TSN.XML.News
TSN.XML.Odds
+ TSN.XML.ScheduleChanges
+ TSN.XML.Scores
+ TSN.XML.SportInfo
+ TSN.XML.Weather
Xml
ghc-options:
-Wall
+ -fcontext-stack=50
-fwarn-hi-shadowing
-fwarn-missing-signatures
-fwarn-name-shadowing
-fwarn-incomplete-record-updates
-fwarn-monomorphism-restriction
-fwarn-unused-do-bind
- -rtsopts
- -threaded
- -optc-O3
- -optc-march=native
-O2
ghc-prof-options:
-prof
- -auto-all
- -caf-all
+ -fprof-auto
+ -fprof-cafs
+ -- The following unbreak profiling with template haskell. We have
+ -- to build the program twice; once without profile and again with
+ -- these flags.
+ -hisuf hi_p
+ -osuf o_p
test-suite testsuite
hs-source-dirs: src test
main-is: TestSuite.hs
build-depends:
- base == 4.*,
+ base >= 4.6 && < 5,
cmdargs >= 0.10.6,
- configurator == 0.2.*,
- directory == 1.2.*,
- filepath == 1.3.*,
- hslogger == 1.2.*,
- htsn-common == 0.0.1,
- hxt == 9.3.*,
- groundhog == 0.4.*,
- groundhog-postgresql == 0.4.*,
- groundhog-sqlite == 0.4.*,
- groundhog-th == 0.4.*,
- MissingH == 1.2.*,
- old-locale == 1.0.*,
- tasty == 0.7.*,
- tasty-hunit == 0.4.*,
- time == 1.4.*,
- transformers == 0.3.*,
- tuple == 0.2.*
+ configurator >= 0.2,
+ directory >= 1.2,
+ filepath >= 1.3,
+ hslogger >= 1.2,
+ htsn-common >= 0.0.1,
+ hxt >= 9.3,
+ generics-sop >= 0.1,
+ groundhog >= 0.5,
+ groundhog-postgresql >= 0.5,
+ groundhog-sqlite >= 0.5,
+ groundhog-th >= 0.5,
+ MissingH >= 1.2,
+ old-locale >= 1,
+ split >= 0.2,
+ tasty >= 0.8,
+ tasty-hunit >= 0.8,
+ time >= 1.4,
+ transformers >= 0.3,
+ tuple >= 0.2
-- 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-incomplete-record-updates
-fwarn-monomorphism-restriction
-fwarn-unused-do-bind
- -rtsopts
- -threaded
- -optc-O3
- -optc-march=native
-O2
hs-source-dirs: test
main-is: Doctests.hs
build-depends:
- base == 4.*,
+ base >= 4.6 && < 5,
-- Additional test dependencies.
- doctest == 0.9.*
+ doctest >= 0.9
-- 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
-O2
+-- These won't work without shelltestrunner installed in your
+-- $PATH. Maybe there is some way to tell Cabal that.
+test-suite shelltests
+ type: exitcode-stdio-1.0
+ hs-source-dirs: test
+ main-is: ShellTests.hs
+
+ build-depends:
+ base >= 4.6 && < 5,
+ cmdargs >= 0.10.6,
+ configurator >= 0.2,
+ directory >= 1.2,
+ filepath >= 1.3,
+ generics-sop >= 0.1,
+ 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,
+ MissingH >= 1.2,
+ old-locale >= 1,
+ split >= 0.2,
+ process >= 1.1,
+ tasty >= 0.8,
+ tasty-hunit >= 0.8,
+ time >= 1.4,
+ transformers >= 0.3,
+ tuple >= 0.2
+
+
+
source-repository head
type: git
location: http://michael.orlitzky.com/git/htsn-import.git
projects / dead / htsn-import.git / blobdiff