]> gitweb.michael.orlitzky.com - dead/htsn-import.git/log
dead/htsn-import.git
10 years agoFix the TSN.Team unique constraint name.
Michael Orlitzky [Sat, 5 Jul 2014 23:26:52 +0000 (19:26 -0400)]
Fix the TSN.Team unique constraint name.

10 years agoAdd a function to TSN.XML.Weather to detect the unsupported second type.
Michael Orlitzky [Sat, 5 Jul 2014 23:00:31 +0000 (19:00 -0400)]
Add a function to TSN.XML.Weather to detect the unsupported second type.
Fail with ImportUnsupported instead of an error when we encounter the second type of weatherxml.
Update the man page with a mention of the unsupported weatherxml handling.
Remove a TODO.
Add tests for the unsupported weather document and its underlying function.

10 years agoAdd a sample contained Detailed_Weather to the weatherxml schemagen.
Michael Orlitzky [Sat, 5 Jul 2014 17:35:20 +0000 (13:35 -0400)]
Add a sample contained Detailed_Weather to the weatherxml schemagen.
Update the test/schema DTD for weatherxml.

10 years agoAdd support for the new Detailed_Weather elements.
Michael Orlitzky [Sat, 5 Jul 2014 17:34:09 +0000 (13:34 -0400)]
Add support for the new Detailed_Weather elements.
Add another test case for the weather.
Update the TODO.

10 years agoReport the path along with the error message when an import fails.
Michael Orlitzky [Sat, 5 Jul 2014 17:29:45 +0000 (13:29 -0400)]
Report the path along with the error message when an import fails.

10 years agoMove the weird weatherxml example out of schemagen/ and under doc/.
Michael Orlitzky [Sat, 5 Jul 2014 16:18:37 +0000 (12:18 -0400)]
Move the weird weatherxml example out of schemagen/ and under doc/.
Allow weather forecasts to contain multiple leagues.

10 years agoMake the Odds team rotation numbers optional.
Michael Orlitzky [Sat, 5 Jul 2014 14:51:24 +0000 (10:51 -0400)]
Make the Odds team rotation numbers optional.
Update the Odds dbschema diagram.

10 years agoAdd a note to the man page about the double-SMS in a news sample.
Michael Orlitzky [Fri, 4 Jul 2014 20:29:36 +0000 (16:29 -0400)]
Add a note to the man page about the double-SMS in a news sample.

10 years agoCrop the AutoRacingResults dbschema diagram.
Michael Orlitzky [Fri, 4 Jul 2014 19:52:25 +0000 (15:52 -0400)]
Crop the AutoRacingResults dbschema diagram.
Make the Injuries teamno field a String thanks to a new sample.
Update the Injuries dbschema diagram.

10 years agoChange the AutoRacingResults track length to a String (yeah).
Michael Orlitzky [Fri, 4 Jul 2014 19:42:25 +0000 (15:42 -0400)]
Change the AutoRacingResults track length to a String (yeah).
Update the AutoRacingResults dbschema diagram.

10 years agoUpdate the TODO with some more tasks revealed by testing.
Michael Orlitzky [Fri, 4 Jul 2014 16:24:03 +0000 (12:24 -0400)]
Update the TODO with some more tasks revealed by testing.

10 years agoMove the deployment section from README.development to the man page.
Michael Orlitzky [Fri, 4 Jul 2014 07:23:07 +0000 (03:23 -0400)]
Move the deployment section from README.development to the man page.
Remove another entry from the TODO.

10 years agoCreate a direct relationship between the Odds games and teams.
Michael Orlitzky [Fri, 4 Jul 2014 07:07:37 +0000 (03:07 -0400)]
Create a direct relationship between the Odds games and teams.
Update the Odds_XML dbschema diagram.

10 years agoComment fix.
Michael Orlitzky [Fri, 4 Jul 2014 07:01:00 +0000 (03:01 -0400)]
Comment fix.

10 years agoUpdate JFile to have a direct relationship between the games/teams.
Michael Orlitzky [Fri, 4 Jul 2014 06:47:29 +0000 (02:47 -0400)]
Update JFile to have a direct relationship between the games/teams.
Add the jfilexml dbschema diagram.

10 years agoAdd the XmlImportFkTeams class.
Michael Orlitzky [Fri, 4 Jul 2014 06:40:15 +0000 (02:40 -0400)]
Add the XmlImportFkTeams class.

10 years agoUpdate TSN.XML modules to use the new Child class.
Michael Orlitzky [Fri, 4 Jul 2014 06:39:40 +0000 (02:39 -0400)]
Update TSN.XML modules to use the new Child class.

10 years agoSplit the (Parent a) associated type into a new Child class.
Michael Orlitzky [Fri, 4 Jul 2014 06:38:48 +0000 (02:38 -0400)]
Split the (Parent a) associated type into a new Child class.

10 years agoFinish the documentation for ScheduleChanges.
Michael Orlitzky [Fri, 4 Jul 2014 05:56:42 +0000 (01:56 -0400)]
Finish the documentation for ScheduleChanges.
Finalize the schema for ScheduleChanges.
Add the Schedule_Changes_XML schema diagram.
Remove pointless "team_" prefix from two Team fields.
Update Odds/JFile for the Team changes.

10 years agoAdd the FromXmlFkTeams class.
Michael Orlitzky [Fri, 4 Jul 2014 05:25:12 +0000 (01:25 -0400)]
Add the FromXmlFkTeams class.

10 years agoUpdate TODO again.
Michael Orlitzky [Fri, 4 Jul 2014 04:29:55 +0000 (00:29 -0400)]
Update TODO again.

10 years agoAdd the initial implementation of TSN.XML.ScheduleChanges.
Michael Orlitzky [Fri, 4 Jul 2014 04:28:00 +0000 (00:28 -0400)]
Add the initial implementation of TSN.XML.ScheduleChanges.

10 years agoFix two capitalizations in comments.
Michael Orlitzky [Fri, 4 Jul 2014 04:24:56 +0000 (00:24 -0400)]
Fix two capitalizations in comments.

10 years agoFix misleading comments and reorder two operations in JFile/Odds.
Michael Orlitzky [Fri, 4 Jul 2014 04:23:53 +0000 (00:23 -0400)]
Fix misleading comments and reorder two operations in JFile/Odds.

10 years agoAdd test XML for Schedule_Changes_XML.dtd.
Michael Orlitzky [Fri, 4 Jul 2014 04:23:10 +0000 (00:23 -0400)]
Add test XML for Schedule_Changes_XML.dtd.

10 years agoAdd a few TODOs.
Michael Orlitzky [Fri, 4 Jul 2014 04:22:49 +0000 (00:22 -0400)]
Add a few TODOs.

10 years agoAdd sample Schedule_Changes_XML and the generated DTD.
Michael Orlitzky [Thu, 3 Jul 2014 20:17:12 +0000 (16:17 -0400)]
Add sample Schedule_Changes_XML and the generated DTD.

10 years agoRemove a completed TODO item.
Michael Orlitzky [Thu, 3 Jul 2014 18:31:02 +0000 (14:31 -0400)]
Remove a completed TODO item.

10 years agoMove two READMEs into the man page.
Michael Orlitzky [Thu, 3 Jul 2014 18:29:12 +0000 (14:29 -0400)]
Move two READMEs into the man page.
Move the list of supported document types to the end of the man page.
Add a man page section about new/removed column migrations.

10 years agoUpdate the Odds schema diagram.
Michael Orlitzky [Wed, 2 Jul 2014 15:03:51 +0000 (11:03 -0400)]
Update the Odds schema diagram.

10 years agoAdd League_Name, AStarter, and HStarter support to Odds.
Michael Orlitzky [Tue, 1 Jul 2014 14:31:06 +0000 (10:31 -0400)]
Add League_Name, AStarter, and HStarter support to Odds.
Add another test case for Odds.
Rename a few columns (dropping the "game" prefix) in the Odds tables.

10 years agoAdd a new Odds_XML schema sample and update the DTD.
Michael Orlitzky [Sat, 28 Jun 2014 02:07:06 +0000 (22:07 -0400)]
Add a new Odds_XML schema sample and update the DTD.

10 years agoMake team names and abbreviations optional.
Michael Orlitzky [Sat, 28 Jun 2014 01:45:58 +0000 (21:45 -0400)]
Make team names and abbreviations optional.

10 years agoAdd a new JFile test case and update the shelltest script.
Michael Orlitzky [Sat, 28 Jun 2014 01:31:07 +0000 (21:31 -0400)]
Add a new JFile test case and update the shelltest script.

10 years agoUpdate the list of schemagen files in htsn-import.cabal.
Michael Orlitzky [Sat, 28 Jun 2014 01:18:37 +0000 (21:18 -0400)]
Update the list of schemagen files in htsn-import.cabal.
Remove a TODO.

10 years agoAdd jfilexml to the list of supported document types.
Michael Orlitzky [Sat, 28 Jun 2014 00:16:55 +0000 (20:16 -0400)]
Add jfilexml to the list of supported document types.
Update the TODO.

10 years agoWrite the database code for TSN.XML.JFile.
Michael Orlitzky [Fri, 27 Jun 2014 19:54:48 +0000 (15:54 -0400)]
Write the database code for TSN.XML.JFile.
Add tests for TSN.XML.JFile.
Enable JFile import in Main.
Fixup the shell test expected output.
Simplify the big case statement (guard) in Main.

10 years agoRename xp_racedate to xp_datetime.
Michael Orlitzky [Fri, 27 Jun 2014 19:54:21 +0000 (15:54 -0400)]
Rename xp_racedate to xp_datetime.
Add an xp_time_dots (un)pickler.

10 years agoUse the TSN.Team type in TSN.XML.JFile.
Michael Orlitzky [Tue, 24 Jun 2014 21:26:21 +0000 (17:26 -0400)]
Use the TSN.Team type in TSN.XML.JFile.
Add team pickling to TSN.XML.JFile.

10 years agoAdd a TODO comment to TSN.XML.AutoRacingResults.
Michael Orlitzky [Tue, 24 Jun 2014 21:05:49 +0000 (17:05 -0400)]
Add a TODO comment to TSN.XML.AutoRacingResults.

10 years agoUpdate TSN.XML.Odds to use the new TSN.Team type.
Michael Orlitzky [Tue, 24 Jun 2014 21:05:30 +0000 (17:05 -0400)]
Update TSN.XML.Odds to use the new TSN.Team type.

10 years agoAdd the TSN.Team module housing a common database representation of teams.
Michael Orlitzky [Tue, 24 Jun 2014 20:58:18 +0000 (16:58 -0400)]
Add the TSN.Team module housing a common database representation of teams.

10 years agoBegin work on the TSN.XML.JFile module.
Michael Orlitzky [Tue, 24 Jun 2014 17:11:26 +0000 (13:11 -0400)]
Begin work on the TSN.XML.JFile module.

10 years agoExport the Game types from TSN.XML.Odds.
Michael Orlitzky [Tue, 24 Jun 2014 17:11:06 +0000 (13:11 -0400)]
Export the Game types from TSN.XML.Odds.

10 years agoInsignificant comment fix.
Michael Orlitzky [Tue, 24 Jun 2014 17:10:46 +0000 (13:10 -0400)]
Insignificant comment fix.

10 years agoAdd the jfilexml DTD and the XML used to infer it.
Michael Orlitzky [Tue, 24 Jun 2014 13:09:13 +0000 (09:09 -0400)]
Add the jfilexml DTD and the XML used to infer it.

10 years agoUpdate the TODO with a list of unhandled DTDs.
Michael Orlitzky [Mon, 23 Jun 2014 20:10:47 +0000 (16:10 -0400)]
Update the TODO with a list of unhandled DTDs.

10 years agoAdd SportInfo support for MLB_Fielding_XML.dtd (overlooked somehow).
Michael Orlitzky [Mon, 23 Jun 2014 19:49:44 +0000 (15:49 -0400)]
Add SportInfo support for MLB_Fielding_XML.dtd (overlooked somehow).
Create the list of SportInfo test cases from the DTD list.
Remove one TODO and replace it with another about the missing SportInfo types.

10 years agoAdd SportInfo support for WNBATurnoversXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 19:38:39 +0000 (15:38 -0400)]
Add SportInfo support for WNBATurnoversXML.dtd.

10 years agoAdd SportInfo support for WNBAStealsXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 19:34:49 +0000 (15:34 -0400)]
Add SportInfo support for WNBAStealsXML.dtd.

10 years agoAdd SportInfo support for wnbastandxml.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 19:31:56 +0000 (15:31 -0400)]
Add SportInfo support for wnbastandxml.dtd.

10 years agoAdd SportInfo support for WNBAScorersXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 19:28:00 +0000 (15:28 -0400)]
Add SportInfo support for WNBAScorersXML.dtd.

10 years agoAdd SportInfo support for WNBAReboundsXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 19:23:33 +0000 (15:23 -0400)]
Add SportInfo support for WNBAReboundsXML.dtd.

10 years agoAdd SportInfo support for WNBAMinutesXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 19:14:28 +0000 (15:14 -0400)]
Add SportInfo support for WNBAMinutesXML.dtd.

10 years agoAdd SportInfo support for WNBAFTPctXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 19:11:03 +0000 (15:11 -0400)]
Add SportInfo support for WNBAFTPctXML.dtd.

10 years agoAdd SportInfo support for WNBAFoulsXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 19:05:49 +0000 (15:05 -0400)]
Add SportInfo support for WNBAFoulsXML.dtd.

10 years agoAdd SportInfo support for WNBAFGPctXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 19:02:28 +0000 (15:02 -0400)]
Add SportInfo support for WNBAFGPctXML.dtd.

10 years agoAdd SportInfo support for WNBABlocksXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 18:50:47 +0000 (14:50 -0400)]
Add SportInfo support for WNBABlocksXML.dtd.

10 years agoAdd SportInfo support for WNBAAssistsXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 18:38:17 +0000 (14:38 -0400)]
Add SportInfo support for WNBAAssistsXML.dtd.

10 years agoAdd SportInfo support for WNBA3PPctXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 18:33:02 +0000 (14:33 -0400)]
Add SportInfo support for WNBA3PPctXML.dtd.

10 years agoAdd SportInfo support for WNBA_Team_Leaders_XML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 18:29:56 +0000 (14:29 -0400)]
Add SportInfo support for WNBA_Team_Leaders_XML.dtd.

10 years agoAdd SportInfo support for Weekly_Sched_XML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 18:23:09 +0000 (14:23 -0400)]
Add SportInfo support for Weekly_Sched_XML.dtd.

10 years agoAdd SportInfo support for Transactions_XML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 18:19:14 +0000 (14:19 -0400)]
Add SportInfo support for Transactions_XML.dtd.

10 years agoAdd SportInfo support for NFL_Team_Stats_XML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 18:10:37 +0000 (14:10 -0400)]
Add SportInfo support for NFL_Team_Stats_XML.dtd.

10 years agoAdd SportInfo support for NFL_Roster_XML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 18:05:46 +0000 (14:05 -0400)]
Add SportInfo support for NFL_Roster_XML.dtd.

10 years agoAdd SportInfo support for NFL_NBA_Draft_XML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 15:01:24 +0000 (11:01 -0400)]
Add SportInfo support for NFL_NBA_Draft_XML.dtd.

10 years agoAdd SportInfo support for NFL_KickingLeaders_XML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 14:51:28 +0000 (10:51 -0400)]
Add SportInfo support for NFL_KickingLeaders_XML.dtd.

10 years agoAdd SportInfo support for NFLTotalYardageXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 14:37:47 +0000 (10:37 -0400)]
Add SportInfo support for NFLTotalYardageXML.dtd.

10 years agoAdd SportInfo support for NFLTopPerformanceXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 14:33:32 +0000 (10:33 -0400)]
Add SportInfo support for NFLTopPerformanceXML.dtd.

10 years agoAdd SportInfo support for NFLTeamRankingsXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 14:04:04 +0000 (10:04 -0400)]
Add SportInfo support for NFLTeamRankingsXML.dtd.

10 years agoAdd SportInfo support for nflstandxml.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 14:01:19 +0000 (10:01 -0400)]
Add SportInfo support for nflstandxml.dtd.

10 years agoAdd SportInfo support for NFLSackLeadersXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 13:57:56 +0000 (09:57 -0400)]
Add SportInfo support for NFLSackLeadersXML.dtd.

10 years agoAdd SportInfo support for NFLQBStartsXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 13:50:43 +0000 (09:50 -0400)]
Add SportInfo support for NFLQBStartsXML.dtd.

10 years agoAdd SportInfo support for NFLPassLeadXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 13:43:53 +0000 (09:43 -0400)]
Add SportInfo support for NFLPassLeadXML.dtd.
Mark DTDs for which no sample XML exists "no xml" instead of "no dtd."

10 years agoAdd SportInfo support for NFLMondayNightXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 13:38:10 +0000 (09:38 -0400)]
Add SportInfo support for NFLMondayNightXML.dtd.

10 years agoAdd SportInfo support for NFLKickoffsXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 13:32:45 +0000 (09:32 -0400)]
Add SportInfo support for NFLKickoffsXML.dtd.

10 years agoAdd SportInfo support for NFLInside20XML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 13:29:18 +0000 (09:29 -0400)]
Add SportInfo support for NFLInside20XML.dtd.

10 years agoAdd SportInfo support for NFLGiveTakeXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 13:25:55 +0000 (09:25 -0400)]
Add SportInfo support for NFLGiveTakeXML.dtd.

10 years agoAdd SportInfo support for NFLFumbleLeaderXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 13:22:51 +0000 (09:22 -0400)]
Add SportInfo support for NFLFumbleLeaderXML.dtd.

10 years agoAdd SportInfo support for nflfirstdownxml.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 13:19:42 +0000 (09:19 -0400)]
Add SportInfo support for nflfirstdownxml.dtd.

10 years agoAdd SportInfo support for NCAA_Conference_Schedule_XML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 01:51:48 +0000 (21:51 -0400)]
Add SportInfo support for NCAA_Conference_Schedule_XML.dtd.

10 years agoAdd SportInfo support for NBATurnoversXML.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 01:49:02 +0000 (21:49 -0400)]
Add SportInfo support for NBATurnoversXML.dtd.

10 years agoAdd SportInfo support for nbatripledoublexml.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 01:44:21 +0000 (21:44 -0400)]
Add SportInfo support for nbatripledoublexml.dtd.

10 years agoAdd SportInfo support for nbateamleadersxml.dtd.
Michael Orlitzky [Mon, 23 Jun 2014 01:40:25 +0000 (21:40 -0400)]
Add SportInfo support for nbateamleadersxml.dtd.

10 years agoAdd SportInfo support for NBAStealsXML.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 23:08:05 +0000 (19:08 -0400)]
Add SportInfo support for NBAStealsXML.dtd.

10 years agoAdd SportInfo support for nbastandxml.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 22:31:49 +0000 (18:31 -0400)]
Add SportInfo support for nbastandxml.dtd.

10 years agoAdd SportInfo support for NBAScorersXML.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 22:21:40 +0000 (18:21 -0400)]
Add SportInfo support for NBAScorersXML.dtd.

10 years agoAdd SportInfo support for NBAReboundsXML.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 22:18:02 +0000 (18:18 -0400)]
Add SportInfo support for NBAReboundsXML.dtd.

10 years agoAdd SportInfo support for NBAMinutesXML.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 21:53:10 +0000 (17:53 -0400)]
Add SportInfo support for NBAMinutesXML.dtd.

10 years agoAdd SportInfo support for NBAFTPctXML.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 21:48:18 +0000 (17:48 -0400)]
Add SportInfo support for NBAFTPctXML.dtd.

10 years agoAdd SportInfo support for NBAFoulsXML.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 21:43:36 +0000 (17:43 -0400)]
Add SportInfo support for NBAFoulsXML.dtd.

10 years agoAdd SportInfo support for NBAFGPctXML.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 21:39:52 +0000 (17:39 -0400)]
Add SportInfo support for NBAFGPctXML.dtd.

10 years agoAdd SportInfo support for nbadivisionsxml.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 21:27:11 +0000 (17:27 -0400)]
Add SportInfo support for nbadivisionsxml.dtd.

10 years agoAdd SportInfo support for nbadaysxml.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 21:22:09 +0000 (17:22 -0400)]
Add SportInfo support for nbadaysxml.dtd.

10 years agoAdd SportInfo support for nbaconfrecxml.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 21:16:38 +0000 (17:16 -0400)]
Add SportInfo support for nbaconfrecxml.dtd.

10 years agoAdd SportInfo support for NBABlocksXML.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 21:10:06 +0000 (17:10 -0400)]
Add SportInfo support for NBABlocksXML.dtd.

10 years agoAdd SportInfo support for NBAAssistsXML.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 19:43:23 +0000 (15:43 -0400)]
Add SportInfo support for NBAAssistsXML.dtd.

10 years agoAdd SportInfo support for NBA3PPctXML.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 19:37:44 +0000 (15:37 -0400)]
Add SportInfo support for NBA3PPctXML.dtd.

10 years agoAdd SportInfo support for NBA_Team_Stats_XML.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 19:34:30 +0000 (15:34 -0400)]
Add SportInfo support for NBA_Team_Stats_XML.dtd.

10 years agoAdd SportInfo support for MLB_Pitching_WL_Leaders.dtd.
Michael Orlitzky [Sun, 22 Jun 2014 19:30:50 +0000 (15:30 -0400)]
Add SportInfo support for MLB_Pitching_WL_Leaders.dtd.