]> gitweb.michael.orlitzky.com - dead/htsn-import.git/log
dead/htsn-import.git
10 years agoAdd a pickler for AutoRacingResults <RaceDate> elements.
Michael Orlitzky [Thu, 12 Jun 2014 19:52:59 +0000 (15:52 -0400)]
Add a pickler for AutoRacingResults <RaceDate> elements.
Add a padded variant of xp_date and use it in two places.

10 years agoRemove unused StandaloneDeriving pragmas.
Michael Orlitzky [Thu, 12 Jun 2014 18:17:51 +0000 (14:17 -0400)]
Remove unused StandaloneDeriving pragmas.

10 years agoAdd TSN.XML.AutoRacingResults, unimplemented. Tests currently broken.
Michael Orlitzky [Wed, 11 Jun 2014 23:26:23 +0000 (19:26 -0400)]
Add TSN.XML.AutoRacingResults, unimplemented. Tests currently broken.

10 years agoAdd another TODO item.
Michael Orlitzky [Wed, 11 Jun 2014 23:07:40 +0000 (19:07 -0400)]
Add another TODO item.

10 years agoManually fix schema/AutoRacingResultsXML.dtd.
Michael Orlitzky [Wed, 11 Jun 2014 21:23:41 +0000 (17:23 -0400)]
Manually fix schema/AutoRacingResultsXML.dtd.

10 years agoAdd a generated DTD and its source files for AutoRacingResultsXML.
Michael Orlitzky [Wed, 11 Jun 2014 21:13:43 +0000 (17:13 -0400)]
Add a generated DTD and its source files for AutoRacingResultsXML.

10 years agoFix "Race" -> "Racing" in the TODO.
Michael Orlitzky [Wed, 11 Jun 2014 21:09:42 +0000 (17:09 -0400)]
Fix "Race" -> "Racing" in the TODO.

10 years agoUpdate the TODO after a successful mass import of Auto_Racing_Schedule_XML.
Michael Orlitzky [Wed, 11 Jun 2014 21:08:47 +0000 (17:08 -0400)]
Update the TODO after a successful mass import of Auto_Racing_Schedule_XML.

10 years agoAdd SportInfo support for CBASK_BlocksXML.dtd.
Michael Orlitzky [Wed, 11 Jun 2014 21:00:04 +0000 (17:00 -0400)]
Add SportInfo support for CBASK_BlocksXML.dtd.

10 years agoRemove some incorrect SportInfo DTD names.
Michael Orlitzky [Wed, 11 Jun 2014 20:55:32 +0000 (16:55 -0400)]
Remove some incorrect SportInfo DTD names.

10 years agoAdd SportInfo support for Cbask_Awards_XML.dtd.
Michael Orlitzky [Wed, 11 Jun 2014 20:50:40 +0000 (16:50 -0400)]
Add SportInfo support for Cbask_Awards_XML.dtd.

10 years agoAdd a minor TODO note.
Michael Orlitzky [Wed, 11 Jun 2014 20:46:10 +0000 (16:46 -0400)]
Add a minor TODO note.

10 years agoAdd SportInfo support for CBASK_AssistsXML.dtd.
Michael Orlitzky [Wed, 11 Jun 2014 20:45:28 +0000 (16:45 -0400)]
Add SportInfo support for CBASK_AssistsXML.dtd.

10 years agoAdd SportInfo support for Cbask_All_Tourn_Teams_XML.dtd.
Michael Orlitzky [Wed, 11 Jun 2014 20:40:27 +0000 (16:40 -0400)]
Add SportInfo support for Cbask_All_Tourn_Teams_XML.dtd.

10 years agoEnable SportInfo imports in Main.
Michael Orlitzky [Wed, 11 Jun 2014 20:36:19 +0000 (16:36 -0400)]
Enable SportInfo imports in Main.

10 years agoCopy the GameInfo code into SportInfo.
Michael Orlitzky [Wed, 11 Jun 2014 20:33:06 +0000 (16:33 -0400)]
Copy the GameInfo code into SportInfo.
Add SportInfo support for CBASK_3PPctXML.dtd.

10 years agoFix sports_info -> sport_info in the man page.
Michael Orlitzky [Wed, 11 Jun 2014 01:30:37 +0000 (21:30 -0400)]
Fix sports_info -> sport_info in the man page.
Remove the GameInfo TODO, it's completed.

10 years agoAdd GameInfo support for WorldBaseballPreviewXML.dtd.
Michael Orlitzky [Wed, 11 Jun 2014 01:27:43 +0000 (21:27 -0400)]
Add GameInfo support for WorldBaseballPreviewXML.dtd.

10 years agoAdd GameInfo support for NFL_NCAA_FB_Matchup_XML.dtd.
Michael Orlitzky [Wed, 11 Jun 2014 00:34:35 +0000 (20:34 -0400)]
Add GameInfo support for NFL_NCAA_FB_Matchup_XML.dtd.

10 years agoRemove MLB.dtd and NBA.dtd from the GameInfo list -- they're not in feed.zip.
Michael Orlitzky [Tue, 10 Jun 2014 23:40:32 +0000 (19:40 -0400)]
Remove MLB.dtd and NBA.dtd from the GameInfo list -- they're not in feed.zip.

10 years agoAdd GameInfo support for nflpreviewxml.dtd.
Michael Orlitzky [Tue, 10 Jun 2014 23:37:48 +0000 (19:37 -0400)]
Add GameInfo support for nflpreviewxml.dtd.
Separate the GameInfo document types in the man page.

10 years agoAdd GameInfo support for NCAA_FB_Preview_XML.dtd.
Michael Orlitzky [Tue, 10 Jun 2014 21:03:51 +0000 (17:03 -0400)]
Add GameInfo support for NCAA_FB_Preview_XML.dtd.

10 years agoAdd GameInfo support for Matchup_NBA_NHL_XML.dtd.
Michael Orlitzky [Tue, 10 Jun 2014 20:57:37 +0000 (16:57 -0400)]
Add GameInfo support for Matchup_NBA_NHL_XML.dtd.

10 years agoAdd GameInfo support for cflpreviewxml.dtd.
Michael Orlitzky [Tue, 10 Jun 2014 20:50:00 +0000 (16:50 -0400)]
Add GameInfo support for cflpreviewxml.dtd.

10 years agoAdd GameInfo support for cbaskpreviewxml.dtd.
Michael Orlitzky [Mon, 9 Jun 2014 18:38:43 +0000 (14:38 -0400)]
Add GameInfo support for cbaskpreviewxml.dtd.

10 years agoAdd GameInfo support for CBASK_Lineup_XML.dtd.
Michael Orlitzky [Mon, 9 Jun 2014 18:26:38 +0000 (14:26 -0400)]
Add GameInfo support for CBASK_Lineup_XML.dtd.

10 years agoAdd the game_info table diagram.
Michael Orlitzky [Tue, 3 Jun 2014 18:22:54 +0000 (14:22 -0400)]
Add the game_info table diagram.

10 years agoAdd GameInfo DTDs and an explanation to the man page.
Michael Orlitzky [Mon, 2 Jun 2014 20:20:47 +0000 (16:20 -0400)]
Add GameInfo DTDs and an explanation to the man page.
Enable GameInfo import in Main.

10 years agoAdd tests for TSN.XML.GameInfo.
Michael Orlitzky [Sun, 1 Jun 2014 18:27:00 +0000 (14:27 -0400)]
Add tests for TSN.XML.GameInfo.
Fix a find command used in an existing shell test.
Add unsafe_read_document to the Xml module (used in GameInfo tests).

10 years agoAdd DTDs and sample documents for a number of GameInfo types.
Michael Orlitzky [Sun, 1 Jun 2014 14:39:48 +0000 (10:39 -0400)]
Add DTDs and sample documents for a number of GameInfo types.
Comment which types are missing DTDs in TSN.XML.GameInfo.

10 years agoAdd initial database code for TSN.XML.GameInfo.
Michael Orlitzky [Sun, 1 Jun 2014 13:16:51 +0000 (09:16 -0400)]
Add initial database code for TSN.XML.GameInfo.

10 years agoBegin the implementation of TSN.XML.GameInfo.
Michael Orlitzky [Sun, 1 Jun 2014 04:13:42 +0000 (00:13 -0400)]
Begin the implementation of TSN.XML.GameInfo.

10 years agoAdd a .ghci file useful for debugging.
Michael Orlitzky [Sun, 1 Jun 2014 04:13:08 +0000 (00:13 -0400)]
Add a .ghci file useful for debugging.

10 years agoMove some things from TSN.Picklers into TSN.Parse.
Michael Orlitzky [Sun, 1 Jun 2014 04:12:39 +0000 (00:12 -0400)]
Move some things from TSN.Picklers into TSN.Parse.
Add XML tree parsing functions to TSN.Parse.

10 years agoUse a UTCTime for the Heartbeat timestamp.
Michael Orlitzky [Sun, 1 Jun 2014 04:11:37 +0000 (00:11 -0400)]
Use a UTCTime for the Heartbeat timestamp.

10 years agoVersion bump with loosened dependency bounds. 0.0.5
Michael Orlitzky [Thu, 29 May 2014 17:02:29 +0000 (13:02 -0400)]
Version bump with loosened dependency bounds.
Fix a deprecation warning.

10 years agoRemove leading/trailing space from the time_stamp format string (GHC bug #9150).
Michael Orlitzky [Thu, 29 May 2014 17:01:32 +0000 (13:01 -0400)]
Remove leading/trailing space from the time_stamp format string (GHC bug #9150).

10 years agoRemove the regular-xmlpickler TODO, mixed-case tags mess everything up.
Michael Orlitzky [Wed, 23 Apr 2014 13:26:38 +0000 (09:26 -0400)]
Remove the regular-xmlpickler TODO, mixed-case tags mess everything up.

10 years agoAdd dummy TSN.XML.{Game,Sport}Info modules that only list DTDs for now.
Michael Orlitzky [Sun, 20 Apr 2014 22:52:05 +0000 (18:52 -0400)]
Add dummy TSN.XML.{Game,Sport}Info modules that only list DTDs for now.

10 years agoReplace all raw DELETE queries with deleteAll.
Michael Orlitzky [Sun, 20 Apr 2014 22:29:28 +0000 (18:29 -0400)]
Replace all raw DELETE queries with deleteAll.
Set a new lower bound on groundhog for the deleteAll function.

10 years agoUpdate TODO.
Michael Orlitzky [Wed, 9 Apr 2014 14:33:43 +0000 (10:33 -0400)]
Update TODO.

10 years agoFix tasty dependencies and bump to 0.0.4. 0.0.4
Michael Orlitzky [Wed, 9 Apr 2014 02:33:39 +0000 (22:33 -0400)]
Fix tasty dependencies and bump to 0.0.4.

10 years agoUse --format=ustar when creating a source tarball.
Michael Orlitzky [Wed, 9 Apr 2014 02:33:18 +0000 (22:33 -0400)]
Use --format=ustar when creating a source tarball.

10 years agoDocument the DEBUG log level.
Michael Orlitzky [Mon, 27 Jan 2014 19:38:10 +0000 (14:38 -0500)]
Document the DEBUG log level.

10 years agoUpdate the TODO now that scoresxml support is complete.
Michael Orlitzky [Mon, 27 Jan 2014 01:24:04 +0000 (20:24 -0500)]
Update the TODO now that scoresxml support is complete.

10 years agoAdd the DB schema diagram for scoresxml.
Michael Orlitzky [Sun, 26 Jan 2014 21:21:37 +0000 (16:21 -0500)]
Add the DB schema diagram for scoresxml.
Fix a table name in TSN.XML.Scores.

10 years agoAdd another TODO item.
Michael Orlitzky [Sat, 25 Jan 2014 02:11:44 +0000 (21:11 -0500)]
Add another TODO item.

10 years agoAdd database support and tests for TSN.XML.Scores.
Michael Orlitzky [Sat, 25 Jan 2014 02:10:10 +0000 (21:10 -0500)]
Add database support and tests for TSN.XML.Scores.

10 years agoExport a "dtd" function from each XML module and use that instead of hard-coding...
Michael Orlitzky [Sat, 25 Jan 2014 01:31:08 +0000 (20:31 -0500)]
Export a "dtd" function from each XML module and use that instead of hard-coding the DTD names in Main.

10 years agoAdd the TSN.XML.Scores module (no db support yet) and update docs and tests for it.
Michael Orlitzky [Fri, 24 Jan 2014 20:27:47 +0000 (15:27 -0500)]
Add the TSN.XML.Scores module (no db support yet) and update docs and tests for it.

10 years agoRemove unnecessary dbName.
Michael Orlitzky [Fri, 24 Jan 2014 20:27:18 +0000 (15:27 -0500)]
Remove unnecessary dbName.

10 years agoAdd test documents for the scoresxml type.
Michael Orlitzky [Fri, 24 Jan 2014 20:26:29 +0000 (15:26 -0500)]
Add test documents for the scoresxml type.

10 years agoAdd sample scoresxml files and the generated DTD.
Michael Orlitzky [Fri, 24 Jan 2014 18:35:23 +0000 (13:35 -0500)]
Add sample scoresxml files and the generated DTD.

10 years agoUpdate the TODO.
Michael Orlitzky [Fri, 24 Jan 2014 15:45:32 +0000 (10:45 -0500)]
Update the TODO.

10 years agoAdd the new module to the cabal file.
Michael Orlitzky [Fri, 24 Jan 2014 04:41:32 +0000 (23:41 -0500)]
Add the new module to the cabal file.

10 years agoAdd missing test XML file.
Michael Orlitzky [Fri, 24 Jan 2014 04:36:20 +0000 (23:36 -0500)]
Add missing test XML file.

10 years agoDocument the new TSN.XML.AutoRacingSchedule module.
Michael Orlitzky [Fri, 24 Jan 2014 04:35:39 +0000 (23:35 -0500)]
Document the new TSN.XML.AutoRacingSchedule module.

10 years agoAdd a schema diagram for Auto_Racing_Schedule_XML.
Michael Orlitzky [Fri, 24 Jan 2014 04:18:54 +0000 (23:18 -0500)]
Add a schema diagram for Auto_Racing_Schedule_XML.
Add the new doctype to the man page.
Add files for the new doctype to the cabal file.

10 years agoAdd a new module, TSN.XML.AutoRacingSchedule, and its tests.
Michael Orlitzky [Thu, 23 Jan 2014 20:38:45 +0000 (15:38 -0500)]
Add a new module, TSN.XML.AutoRacingSchedule, and its tests.

10 years agoAdd a new (un)pickler for the auto racing schedule "TBA"-able time field.
Michael Orlitzky [Thu, 23 Jan 2014 20:37:53 +0000 (15:37 -0500)]
Add a new (un)pickler for the auto racing schedule "TBA"-able time field.

10 years agoFix a typo.
Michael Orlitzky [Thu, 23 Jan 2014 20:37:37 +0000 (15:37 -0500)]
Fix a typo.

10 years agoBump the version number.
Michael Orlitzky [Thu, 23 Jan 2014 18:25:00 +0000 (13:25 -0500)]
Bump the version number.

10 years agoAdd the DTD for Auto_Racing_Schedule_XML and an XML file to generate it.
Michael Orlitzky [Thu, 23 Jan 2014 18:24:23 +0000 (13:24 -0500)]
Add the DTD for Auto_Racing_Schedule_XML and an XML file to generate it.

10 years agoAdd the shell test scripts to the cabal file. 0.0.2
Michael Orlitzky [Thu, 23 Jan 2014 01:49:53 +0000 (20:49 -0500)]
Add the shell test scripts to the cabal file.

10 years agoImplement the other ON DELETE CASCADE tests and update the TODO.
Michael Orlitzky [Thu, 23 Jan 2014 01:44:51 +0000 (20:44 -0500)]
Implement the other ON DELETE CASCADE tests and update the TODO.

10 years agoUpdate TODO and add a cascading delete test for newsxml.
Michael Orlitzky [Thu, 23 Jan 2014 00:45:41 +0000 (19:45 -0500)]
Update TODO and add a cascading delete test for newsxml.

10 years agoAdd a shelltestrunner test suite.
Michael Orlitzky [Wed, 22 Jan 2014 22:48:04 +0000 (17:48 -0500)]
Add a shelltestrunner test suite.
Add a test for duplicate message insertion.
Remove an item from the TODO.

10 years agoMunge the XML_File_ID of a newsxml sample since it was modified by hand from another...
Michael Orlitzky [Wed, 22 Jan 2014 22:44:19 +0000 (17:44 -0500)]
Munge the XML_File_ID of a newsxml sample since it was modified by hand from another sample.

10 years agoChange "imported" to "processed" in some output.
Michael Orlitzky [Wed, 22 Jan 2014 22:43:53 +0000 (17:43 -0500)]
Change "imported" to "processed" in some output.

10 years agoDisable the threaded runtime for now and drop overkill CFLAGS.
Michael Orlitzky [Wed, 22 Jan 2014 04:57:09 +0000 (23:57 -0500)]
Disable the threaded runtime for now and drop overkill CFLAGS.

10 years agoAdd some tests for the ON DELETE CASCADE behavior.
Michael Orlitzky [Wed, 22 Jan 2014 04:48:46 +0000 (23:48 -0500)]
Add some tests for the ON DELETE CASCADE behavior.

10 years agoRemove an unused import.
Michael Orlitzky [Wed, 22 Jan 2014 04:48:19 +0000 (23:48 -0500)]
Remove an unused import.

10 years agoMinor indentation fix.
Michael Orlitzky [Wed, 22 Jan 2014 04:47:59 +0000 (23:47 -0500)]
Minor indentation fix.

10 years agoRemove unused dbimport_generic function.
Michael Orlitzky [Wed, 22 Jan 2014 04:20:43 +0000 (23:20 -0500)]
Remove unused dbimport_generic function.

10 years agoFix two typos that broke cascading delete.
Michael Orlitzky [Wed, 22 Jan 2014 02:48:25 +0000 (21:48 -0500)]
Fix two typos that broke cascading delete.

10 years agoAdd extra docs to the source tarball. 0.0.1
Michael Orlitzky [Wed, 22 Jan 2014 00:49:03 +0000 (19:49 -0500)]
Add extra docs to the source tarball.

10 years agoUpdate TODO.
Michael Orlitzky [Wed, 22 Jan 2014 00:42:56 +0000 (19:42 -0500)]
Update TODO.

10 years agoUpdate all of the schema diagrams again.
Michael Orlitzky [Wed, 22 Jan 2014 00:42:20 +0000 (19:42 -0500)]
Update all of the schema diagrams again.

10 years agoDocument the weird weather sample.
Michael Orlitzky [Tue, 21 Jan 2014 21:27:17 +0000 (16:27 -0500)]
Document the weird weather sample.

10 years agoFix some docs in Odds and Weather.
Michael Orlitzky [Tue, 21 Jan 2014 21:26:47 +0000 (16:26 -0500)]
Fix some docs in Odds and Weather.

10 years agoAdd a new weatherxml sample that messes everything up.
Michael Orlitzky [Tue, 21 Jan 2014 21:07:00 +0000 (16:07 -0500)]
Add a new weatherxml sample that messes everything up.

10 years agoAdd a new module, TSN.Database, and use it to clean up TSN.XML.News.
Michael Orlitzky [Tue, 21 Jan 2014 19:19:51 +0000 (14:19 -0500)]
Add a new module, TSN.Database, and use it to clean up TSN.XML.News.

10 years agoUpdate docs in TSN.XML.Injuries.
Michael Orlitzky [Tue, 21 Jan 2014 19:05:43 +0000 (14:05 -0500)]
Update docs in TSN.XML.Injuries.

10 years agoUpdate docs in TSN.XML.InjuriesDetail.
Michael Orlitzky [Tue, 21 Jan 2014 19:01:04 +0000 (14:01 -0500)]
Update docs in TSN.XML.InjuriesDetail.

10 years agoFix an error message in TSN.XML.Heartbeat.
Michael Orlitzky [Tue, 21 Jan 2014 19:00:22 +0000 (14:00 -0500)]
Fix an error message in TSN.XML.Heartbeat.

10 years agoUpdate the database schema docs.
Michael Orlitzky [Tue, 21 Jan 2014 19:00:05 +0000 (14:00 -0500)]
Update the database schema docs.

10 years agoFix a News test.
Michael Orlitzky [Tue, 21 Jan 2014 18:54:00 +0000 (13:54 -0500)]
Fix a News test.

10 years agoUpdate TSN.XML.Weather for the new typeclass hierarchy.
Michael Orlitzky [Tue, 21 Jan 2014 18:29:41 +0000 (13:29 -0500)]
Update TSN.XML.Weather for the new typeclass hierarchy.
Update the weatherxml schema diagram.

10 years agoAdd time_stamp and xml_file_id to Weather.
Michael Orlitzky [Tue, 21 Jan 2014 17:45:22 +0000 (12:45 -0500)]
Add time_stamp and xml_file_id to Weather.

10 years agoRewrite TSN.XML.Odds for the new typeclass hierarchy.
Michael Orlitzky [Tue, 21 Jan 2014 17:35:16 +0000 (12:35 -0500)]
Rewrite TSN.XML.Odds for the new typeclass hierarchy.
Add a unique xml_file_id to Odds.
Add a time_stamp to Odds.
Replace a many-to-many relationship with a one-to-many in Odds.

10 years agoUpdate the Odds db schema diagram, but it's outdated again.
Michael Orlitzky [Tue, 21 Jan 2014 17:34:48 +0000 (12:34 -0500)]
Update the Odds db schema diagram, but it's outdated again.

10 years agoAdd a unique xml_file_id to News.
Michael Orlitzky [Tue, 21 Jan 2014 17:34:27 +0000 (12:34 -0500)]
Add a unique xml_file_id to News.

10 years agoAdd a unique xml_file_id to InjuriesDetail.
Michael Orlitzky [Tue, 21 Jan 2014 17:34:02 +0000 (12:34 -0500)]
Add a unique xml_file_id to InjuriesDetail.

10 years agoAdd a unique xml_file_id to Injuries.
Michael Orlitzky [Tue, 21 Jan 2014 17:33:38 +0000 (12:33 -0500)]
Add a unique xml_file_id to Injuries.

10 years agoSet "withSubstDTDEntities no" for now.
Michael Orlitzky [Tue, 21 Jan 2014 07:16:12 +0000 (02:16 -0500)]
Set "withSubstDTDEntities no" for now.

10 years agoUpdate TSN.XML.InjuriesDetail for the new typeclass hierarchy.
Michael Orlitzky [Tue, 21 Jan 2014 04:30:12 +0000 (23:30 -0500)]
Update TSN.XML.InjuriesDetail for the new typeclass hierarchy.
Add InjuriesDetail and InjuriesDetailListing to the database.
Update the database schema diagram for Injuries_Detail_XML.

10 years agoUpdate TSN.XML.Injuries for the new typeclass hierarchy.
Michael Orlitzky [Tue, 21 Jan 2014 04:29:41 +0000 (23:29 -0500)]
Update TSN.XML.Injuries for the new typeclass hierarchy.

10 years agoAdd XmlImportFk, a total copy of XmlImport for instances of FromXmlFk. This could...
Michael Orlitzky [Tue, 21 Jan 2014 04:25:50 +0000 (23:25 -0500)]
Add XmlImportFk, a total copy of XmlImport for instances of FromXmlFk. This could probably use a redesign.

10 years agoAdd the FromXmlFk class, like FromXml except it requires an FK (old idea).
Michael Orlitzky [Tue, 21 Jan 2014 04:12:27 +0000 (23:12 -0500)]
Add the FromXmlFk class, like FromXml except it requires an FK (old idea).
Split the (Db a) associated type out into its own class, ToDb.
Update News, Odds, and Weather for the new typeclass hierarchy.

10 years agoUpdate the DB schema diagram for injuriesxml.
Michael Orlitzky [Tue, 21 Jan 2014 01:44:20 +0000 (20:44 -0500)]
Update the DB schema diagram for injuriesxml.