]> gitweb.michael.orlitzky.com - dead/htsn-import.git/log
dead/htsn-import.git
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.

10 years agoAdd a top-level injuries table for TSN.XML.Injuries.
Michael Orlitzky [Mon, 20 Jan 2014 21:24:35 +0000 (16:24 -0500)]
Add a top-level injuries table for TSN.XML.Injuries.

10 years agoAdd the FromXmlFk class which allows us to construct database representations from...
Michael Orlitzky [Mon, 20 Jan 2014 20:38:06 +0000 (15:38 -0500)]
Add the FromXmlFk class which allows us to construct database representations from XML ones.

10 years agoFix example connection string.
Michael Orlitzky [Mon, 20 Jan 2014 16:46:54 +0000 (11:46 -0500)]
Fix example connection string.

10 years agoAdd required test DTDs to the source distribution.
Michael Orlitzky [Mon, 20 Jan 2014 16:39:50 +0000 (11:39 -0500)]
Add required test DTDs to the source distribution.

10 years agoAdd the TSN.XML.Weather module to the cabal file.
Michael Orlitzky [Mon, 20 Jan 2014 16:36:25 +0000 (11:36 -0500)]
Add the TSN.XML.Weather module to the cabal file.

10 years agoAdd the example config file.
Michael Orlitzky [Mon, 20 Jan 2014 16:32:13 +0000 (11:32 -0500)]
Add the example config file.

10 years agoRemove errant man page option and fix a typo.
Michael Orlitzky [Mon, 20 Jan 2014 16:31:58 +0000 (11:31 -0500)]
Remove errant man page option and fix a typo.

10 years agoFix paths in cabal file.
Michael Orlitzky [Mon, 20 Jan 2014 16:31:42 +0000 (11:31 -0500)]
Fix paths in cabal file.

10 years agoFix doc typo.
Michael Orlitzky [Mon, 20 Jan 2014 16:08:07 +0000 (11:08 -0500)]
Fix doc typo.

10 years agoUpdate the schema documentation.
Michael Orlitzky [Mon, 20 Jan 2014 16:05:31 +0000 (11:05 -0500)]
Update the schema documentation.
Add ON DELETE CASCADE for the references in TSN.XML.Odds.

10 years agoUpdate the TODO again.
Michael Orlitzky [Mon, 20 Jan 2014 16:05:12 +0000 (11:05 -0500)]
Update the TODO again.

10 years agoUse the timestamp pickler in TSN.XML.News.
Michael Orlitzky [Mon, 20 Jan 2014 07:08:10 +0000 (02:08 -0500)]
Use the timestamp pickler in TSN.XML.News.
Set ON DELETE CASCADE where possible in TSN.XML.News.

10 years agoAdd a pickler for the <time_stamp> elements.
Michael Orlitzky [Mon, 20 Jan 2014 07:07:20 +0000 (02:07 -0500)]
Add a pickler for the <time_stamp> elements.

10 years agoAdd another TODO.
Michael Orlitzky [Mon, 20 Jan 2014 05:02:09 +0000 (00:02 -0500)]
Add another TODO.

10 years agoFix a typo.
Michael Orlitzky [Mon, 20 Jan 2014 04:58:58 +0000 (23:58 -0500)]
Fix a typo.

10 years agoUpdate makefile/cabalfile with better profiling support.
Michael Orlitzky [Mon, 20 Jan 2014 04:55:39 +0000 (23:55 -0500)]
Update makefile/cabalfile with better profiling support.
Add an XML file that will eventually be tested.

10 years agoUpdate the TODO file.
Michael Orlitzky [Mon, 20 Jan 2014 04:54:54 +0000 (23:54 -0500)]
Update the TODO file.

10 years agoAdd docs for TSN.XML.Weather.
Michael Orlitzky [Sun, 19 Jan 2014 15:45:22 +0000 (10:45 -0500)]
Add docs for TSN.XML.Weather.

10 years agoFix hlint suggestion.
Michael Orlitzky [Thu, 16 Jan 2014 01:34:34 +0000 (20:34 -0500)]
Fix hlint suggestion.

10 years agoMinimal undocumented implementation of TSN.XML.Weather.
Michael Orlitzky [Thu, 16 Jan 2014 01:33:19 +0000 (20:33 -0500)]
Minimal undocumented implementation of TSN.XML.Weather.
Add weatherxml.dtd support to Main.

10 years agoAdd a pickler for the forecast gamedate attribute.
Michael Orlitzky [Thu, 16 Jan 2014 01:32:40 +0000 (20:32 -0500)]
Add a pickler for the forecast gamedate attribute.

10 years agoAdd the schema diagram for weatherxml.
Michael Orlitzky [Thu, 16 Jan 2014 01:27:49 +0000 (20:27 -0500)]
Add the schema diagram for weatherxml.

10 years agoAdd the TSN.XML.Weather module (passing pickle/unpickle tests).
Michael Orlitzky [Wed, 15 Jan 2014 06:09:58 +0000 (01:09 -0500)]
Add the TSN.XML.Weather module (passing pickle/unpickle tests).

10 years agoFix typos and use xpAttrImplies where appropriate (one case).
Michael Orlitzky [Wed, 15 Jan 2014 06:09:29 +0000 (01:09 -0500)]
Fix typos and use xpAttrImplies where appropriate (one case).

10 years agoRemove two completed TODO items.
Michael Orlitzky [Wed, 15 Jan 2014 03:44:40 +0000 (22:44 -0500)]
Remove two completed TODO items.

10 years agoAdd a README for the generated dbschema diagrams.
Michael Orlitzky [Wed, 15 Jan 2014 03:41:13 +0000 (22:41 -0500)]
Add a README for the generated dbschema diagrams.
Add three more dbschema diagrams to replace the deleted PDF versions.

10 years agoRemove old and busted PDF diagrams, add a new hotness PNG diagram.
Michael Orlitzky [Wed, 15 Jan 2014 03:18:50 +0000 (22:18 -0500)]
Remove old and busted PDF diagrams, add a new hotness PNG diagram.

10 years agoCombine the odds game date/time into one DB field.
Michael Orlitzky [Wed, 15 Jan 2014 02:28:07 +0000 (21:28 -0500)]
Combine the odds game date/time into one DB field.

10 years agoDon't bother with the three-character limit on team_id fields; Postgres doesn't care.
Michael Orlitzky [Wed, 15 Jan 2014 01:47:22 +0000 (20:47 -0500)]
Don't bother with the three-character limit on team_id fields; Postgres doesn't care.

10 years agoAdd docs for Injuries/InjuriesDetail.
Michael Orlitzky [Tue, 14 Jan 2014 11:24:22 +0000 (06:24 -0500)]
Add docs for Injuries/InjuriesDetail.

10 years agoAdd some TODOs.
Michael Orlitzky [Tue, 14 Jan 2014 10:53:19 +0000 (05:53 -0500)]
Add some TODOs.

10 years agoFix a comment.
Michael Orlitzky [Tue, 14 Jan 2014 10:52:40 +0000 (05:52 -0500)]
Fix a comment.

10 years agoUn-haddock two comments that wound up in the wrong place due to template haskell.
Michael Orlitzky [Tue, 14 Jan 2014 10:51:14 +0000 (05:51 -0500)]
Un-haddock two comments that wound up in the wrong place due to template haskell.

10 years agoIgnore export lists for docs.
Michael Orlitzky [Tue, 14 Jan 2014 10:50:55 +0000 (05:50 -0500)]
Ignore export lists for docs.

10 years agoUpdate (or add) a bunch of documentation.
Michael Orlitzky [Tue, 14 Jan 2014 10:39:58 +0000 (05:39 -0500)]
Update (or add) a bunch of documentation.
Change two 'String' types to 'UTCTime' and pickle/unpickle them thusly.

10 years agoTry to clean up the makefile 'doc' target.
Michael Orlitzky [Tue, 14 Jan 2014 10:39:41 +0000 (05:39 -0500)]
Try to clean up the makefile 'doc' target.

10 years agoFix remaining compiler warnings.
Michael Orlitzky [Tue, 14 Jan 2014 00:48:43 +0000 (19:48 -0500)]
Fix remaining compiler warnings.

10 years agoFixing compiler warnings by exporting stuff that shouldn't be exported (woo).
Michael Orlitzky [Tue, 14 Jan 2014 00:20:52 +0000 (19:20 -0500)]
Fixing compiler warnings by exporting stuff that shouldn't be exported (woo).

10 years agoMinor makefile fix.
Michael Orlitzky [Tue, 14 Jan 2014 00:12:59 +0000 (19:12 -0500)]
Minor makefile fix.

10 years agoAdd the newsxml DB schema PDF.
Michael Orlitzky [Tue, 14 Jan 2014 00:12:15 +0000 (19:12 -0500)]
Add the newsxml DB schema PDF.

10 years agoAdd some more documentation to News.hs.
Michael Orlitzky [Tue, 14 Jan 2014 00:02:59 +0000 (19:02 -0500)]
Add some more documentation to News.hs.

10 years agoFinish documenting TSN.XML.News and fix all compiler warnings therein.
Michael Orlitzky [Mon, 13 Jan 2014 23:59:38 +0000 (18:59 -0500)]
Finish documenting TSN.XML.News and fix all compiler warnings therein.

10 years agoAdd the test file needed by the previous commit.
Michael Orlitzky [Mon, 13 Jan 2014 21:57:38 +0000 (16:57 -0500)]
Add the test file needed by the previous commit.

10 years agoAdd a test for unpickling large Odds_XML files.
Michael Orlitzky [Mon, 13 Jan 2014 21:57:01 +0000 (16:57 -0500)]
Add a test for unpickling large Odds_XML files.
Disable DTD validation so the new test passes.
Add a TODO item to re-enable validation.

10 years agoAdd the PDF of the injuries_detail DB schema.
Michael Orlitzky [Mon, 13 Jan 2014 20:55:13 +0000 (15:55 -0500)]
Add the PDF of the injuries_detail DB schema.

10 years agoAdd more files to 'make clean'.
Michael Orlitzky [Mon, 13 Jan 2014 20:39:47 +0000 (15:39 -0500)]
Add more files to 'make clean'.

10 years agoRemove unused import.
Michael Orlitzky [Mon, 13 Jan 2014 20:39:03 +0000 (15:39 -0500)]
Remove unused import.

10 years agoFix unpickling of non-integer team_ids in TSN.XML.Odds (with tests).
Michael Orlitzky [Mon, 13 Jan 2014 18:50:52 +0000 (13:50 -0500)]
Fix unpickling of non-integer team_ids in TSN.XML.Odds (with tests).

10 years agoFix unpickling of texttual over/under lines.
Michael Orlitzky [Mon, 13 Jan 2014 18:41:06 +0000 (13:41 -0500)]
Fix unpickling of texttual over/under lines.

10 years agoRemove unused imports.
Michael Orlitzky [Mon, 13 Jan 2014 18:40:52 +0000 (13:40 -0500)]
Remove unused imports.

10 years agoUse (xpOption xpText) instead of xpText0.
Michael Orlitzky [Mon, 13 Jan 2014 18:40:30 +0000 (13:40 -0500)]
Use (xpOption xpText) instead of xpText0.

10 years agoMake the text of a news URL optional.
Michael Orlitzky [Mon, 13 Jan 2014 17:57:49 +0000 (12:57 -0500)]
Make the text of a news URL optional.

10 years agoFix pickle/unpickle of non-interger team_ids and add a test case for it.
Michael Orlitzky [Mon, 13 Jan 2014 17:41:01 +0000 (12:41 -0500)]
Fix pickle/unpickle of non-interger team_ids and add a test case for it.

10 years agoAdd a sample Injuries_Detail_XML with a noninteger Team_ID.
Michael Orlitzky [Mon, 13 Jan 2014 15:11:35 +0000 (10:11 -0500)]
Add a sample Injuries_Detail_XML with a noninteger Team_ID.

10 years agoAdd the DB schema PDF for injuries documents.
Michael Orlitzky [Mon, 13 Jan 2014 07:10:12 +0000 (02:10 -0500)]
Add the DB schema PDF for injuries documents.

10 years agoUpdate the schemagen README.
Michael Orlitzky [Mon, 13 Jan 2014 05:37:02 +0000 (00:37 -0500)]
Update the schemagen README.

10 years agoAdd "correct" versions of all DTDs under schema/.
Michael Orlitzky [Mon, 13 Jan 2014 05:36:42 +0000 (00:36 -0500)]
Add "correct" versions of all DTDs under schema/.

10 years agoRemove an unused import.
Michael Orlitzky [Mon, 13 Jan 2014 05:05:35 +0000 (00:05 -0500)]
Remove an unused import.

10 years agoAdd a doctest suite with a big-ass caveat.
Michael Orlitzky [Mon, 13 Jan 2014 05:01:16 +0000 (00:01 -0500)]
Add a doctest suite with a big-ass caveat.

10 years agoUpdate documentation.
Michael Orlitzky [Mon, 13 Jan 2014 04:16:13 +0000 (23:16 -0500)]
Update documentation.

10 years agoRemove unused XmlPickler instances (this might need to be revisited if regular-xmlpic...
Michael Orlitzky [Mon, 13 Jan 2014 04:01:55 +0000 (23:01 -0500)]
Remove unused XmlPickler instances (this might need to be revisited if regular-xmlpickler sees a new release).

10 years agoSimplify some tests by passing a pickler instead of relying on a XmlPickler instance.
Michael Orlitzky [Mon, 13 Jan 2014 03:54:15 +0000 (22:54 -0500)]
Simplify some tests by passing a pickler instead of relying on a XmlPickler instance.

10 years agoAdd and update documentation.
Michael Orlitzky [Sun, 12 Jan 2014 23:33:00 +0000 (18:33 -0500)]
Add and update documentation.

10 years agoAdd a description to the cabal file, and begin to define extra modules/source files...
Michael Orlitzky [Sun, 12 Jan 2014 23:32:21 +0000 (18:32 -0500)]
Add a description to the cabal file, and begin to define extra modules/source files that will be needed for a release.

10 years agoAdd a preliminary man page.
Michael Orlitzky [Sun, 12 Jan 2014 22:47:59 +0000 (17:47 -0500)]
Add a preliminary man page.

10 years agoRename the "injuries" and "injuries_detail" tables to "injuries_listings" and "injuri...
Michael Orlitzky [Sun, 12 Jan 2014 05:32:45 +0000 (00:32 -0500)]
Rename the "injuries" and "injuries_detail" tables to "injuries_listings" and "injuries_detail_player_listings" respectively.

10 years agoUSe lowerCaseSuffixNamingStyle as our base in TSN.Codegen.
Michael Orlitzky [Sun, 12 Jan 2014 05:01:54 +0000 (00:01 -0500)]
USe lowerCaseSuffixNamingStyle as our base in TSN.Codegen.

10 years agoDon't remove imported files by default.
Michael Orlitzky [Sun, 12 Jan 2014 05:01:35 +0000 (00:01 -0500)]
Don't remove imported files by default.

10 years agoBeat TSN.XML.Odds into relational submission; file import actually works now.
Michael Orlitzky [Sat, 11 Jan 2014 23:44:27 +0000 (18:44 -0500)]
Beat TSN.XML.Odds into relational submission; file import actually works now.

10 years agoAdd some more customization to our codegen config.
Michael Orlitzky [Sat, 11 Jan 2014 23:43:50 +0000 (18:43 -0500)]
Add some more customization to our codegen config.

10 years agoUse run_dbmigrate instead of runMigration... everywhere.
Michael Orlitzky [Sat, 11 Jan 2014 23:42:59 +0000 (18:42 -0500)]
Use run_dbmigrate instead of runMigration... everywhere.

10 years agoAdd the insert_xml_or_select function to TSN.XmlImport and use it in TSN.XML.News.
Michael Orlitzky [Sat, 11 Jan 2014 23:34:26 +0000 (18:34 -0500)]
Add the insert_xml_or_select function to TSN.XmlImport and use it in TSN.XML.News.

10 years agoAdd run_dbmigrate to TSN.DbImport.
Michael Orlitzky [Sat, 11 Jan 2014 23:33:23 +0000 (18:33 -0500)]
Add run_dbmigrate to TSN.DbImport.

10 years agoGet the Odds module to compile and pass tests under the new regime.
Michael Orlitzky [Sat, 11 Jan 2014 08:37:44 +0000 (03:37 -0500)]
Get the Odds module to compile and pass tests under the new regime.

10 years agoAdd missing TSN.XmlImport module.
Michael Orlitzky [Sat, 11 Jan 2014 07:07:35 +0000 (02:07 -0500)]
Add missing TSN.XmlImport module.

10 years agoRewrite everything to use XmlImport/DbImport classes making things much more easy...
Michael Orlitzky [Sat, 11 Jan 2014 04:10:24 +0000 (23:10 -0500)]
Rewrite everything to use XmlImport/DbImport classes making things much more easy to understand. The docs need an update now.

10 years agoBegin reworking TSN.XML.Odds for the new inferred DTDs.
Michael Orlitzky [Fri, 10 Jan 2014 23:29:19 +0000 (18:29 -0500)]
Begin reworking TSN.XML.Odds for the new inferred DTDs.

10 years agoSimplify parse_opts now that we can validate against the DTDs.
Michael Orlitzky [Fri, 10 Jan 2014 21:53:12 +0000 (16:53 -0500)]
Simplify parse_opts now that we can validate against the DTDs.

10 years agoAdd the hand-crafted Odds_XML.dtd.
Michael Orlitzky [Fri, 10 Jan 2014 21:48:50 +0000 (16:48 -0500)]
Add the hand-crafted Odds_XML.dtd.

10 years agoAdd a note to the README about the hand-crafted schemas.
Michael Orlitzky [Fri, 10 Jan 2014 21:48:13 +0000 (16:48 -0500)]
Add a note to the README about the hand-crafted schemas.

10 years agoReplace the auto-generated Odds_XML.dtd used in tests with the hand-crafted one.
Michael Orlitzky [Fri, 10 Jan 2014 21:47:31 +0000 (16:47 -0500)]
Replace the auto-generated Odds_XML.dtd used in tests with the hand-crafted one.

10 years agoChange the Odds database type to 'Odds' in Main.hs.
Michael Orlitzky [Fri, 10 Jan 2014 21:46:56 +0000 (16:46 -0500)]
Change the Odds database type to 'Odds' in Main.hs.

10 years agoBegin validating the XML.
Michael Orlitzky [Fri, 10 Jan 2014 04:59:38 +0000 (23:59 -0500)]
Begin validating the XML.
Fix a bug in the Injuries pickling.

10 years agoUpdate the test TSN DTDs with the inferred ones.
Michael Orlitzky [Fri, 10 Jan 2014 04:53:27 +0000 (23:53 -0500)]
Update the test TSN DTDs with the inferred ones.