-- time_stamp.
--
module TSN.XML.Injuries (
+ dtd,
pickle_message,
-- * Tests
injuries_tests,
import Data.Data ( Data )
import Data.Time ( UTCTime )
import Data.Typeable ( Typeable )
-import Database.Groundhog ( migrate )
+import Database.Groundhog (
+ countAll,
+ deleteAll,
+ migrate,
+ runMigration,
+ silentMigrationLogger )
import Database.Groundhog.Core ( DefaultKey )
+import Database.Groundhog.Generic ( runDbConn )
import Database.Groundhog.TH (
groundhog,
mkPersist )
+import Database.Groundhog.Sqlite ( withSqliteConn )
import Data.Tuple.Curry ( uncurryN )
import Test.Tasty ( TestTree, testGroup )
import Test.Tasty.HUnit ( (@?=), testCase )
FromXmlFk(..),
ToDb(..),
pickle_unpickle,
- unpickleable )
+ unpickleable,
+ unsafe_unpickle )
+
+
+
+-- | The DTD to which this module corresponds. Used to invoke dbimport.
+--
+dtd :: String
+dtd = "injuriesxml.dtd"
+
+--
+-- DB/XML Data types
+--
+
+-- * InjuriesTeam
-- | XML/Database representation of a team as they appear in the
-- injuries documents.
deriving (Data, Eq, Show, Typeable)
--- | XML/Database representation of the injury listings.
+-- * InjuriesListing/InjuriesListingXml
+
+-- | XML representation of the injury listings.
--
data InjuriesListingXml =
InjuriesListingXml {
db_injuries = xml_injuries,
db_updated = xml_updated }
+-- | This allows us to insert the XML representation
+-- 'InjuriesListingXml' directly.
+--
instance XmlImportFk InjuriesListingXml
+
+-- * Injuries/Message
+
-- | XML representation of an injuriesxml \<message\>.
--
data Message =
xml_time_stamp :: UTCTime }
deriving (Eq, Show)
--- | Database representation of a 'Message'. We really only care about
--- the time stamp.
+-- | Database representation of a 'Message'.
--
data Injuries =
Injuries {
+ db_xml_file_id :: Int,
db_sport :: String,
db_time_stamp :: UTCTime }
--
from_xml Message{..} =
Injuries {
+ db_xml_file_id = xml_xml_file_id,
db_sport = xml_sport,
db_time_stamp = xml_time_stamp }
+-- | This allows us to insert the XML representation 'Message'
+-- directly.
+--
instance XmlImport Message
+--
+-- Database code
+--
+
instance DbImport Message where
dbmigrate _ =
run_dbmigrate $ do
migrate (undefined :: Injuries)
migrate (undefined :: InjuriesListing)
- -- | We import a 'Message' by inserting all of its 'listings'.
+ -- | We import a 'Message' by inserting all of its 'listings', but
+ -- the listings require a foreign key to the parent 'Message'.
--
dbimport msg = do
msg_id <- insert_xml msg
mkPersist tsn_codegen_config [groundhog|
- entity: Injuries
+ constructors:
+ - name: Injuries
+ uniques:
+ - name: unique_injuries
+ type: constraint
+ # Prevent multiple imports of the same message.
+ fields: [db_xml_file_id]
- entity: InjuriesListing
dbName: injuries_listings
|]
+--
+-- XML Picklers
+--
+
+
-- | A pickler for 'InjuriesTeam's that can convert them to/from XML.
--
pickle_injuries_team :: PU InjuriesTeam
to_tuple m = (db_team_name m, db_team_league m)
--- | A pickler for 'InjuriesListingXml's that can convert them to/from XML.
+-- | A pickler for 'InjuriesListingXml's that can convert them to/from
+-- XML.
--
pickle_listing :: PU InjuriesListingXml
pickle_listing =
injuries_tests =
testGroup
"Injuries tests"
- [ test_pickle_of_unpickle_is_identity,
+ [ test_on_delete_cascade,
+ test_pickle_of_unpickle_is_identity,
test_unpickle_succeeds ]
test_unpickle_succeeds :: TestTree
test_unpickle_succeeds =
testCase "unpickling succeeds" $ do
- let path = "test/xml/injuriesxml.xml"
- actual <- unpickleable path pickle_message
- let expected = True
- actual @?= expected
+ let path = "test/xml/injuriesxml.xml"
+ actual <- unpickleable path pickle_message
+ let expected = True
+ actual @?= expected
+
+
+-- | Make sure everything gets deleted when we delete the top-level
+-- record.
+--
+test_on_delete_cascade :: TestTree
+test_on_delete_cascade =
+ testCase "deleting an injuries deletes its children" $ do
+ let path = "test/xml/injuriesxml.xml"
+ inj <- unsafe_unpickle path pickle_message
+ let a = undefined :: Injuries
+ let b = undefined :: InjuriesListing
+ actual <- withSqliteConn ":memory:" $ runDbConn $ do
+ runMigration silentMigrationLogger $ do
+ migrate a
+ migrate b
+ _ <- dbimport inj
+ deleteAll a
+ count_a <- countAll a
+ count_b <- countAll b
+ return $ count_a + count_b
+ let expected = 0
+ actual @?= expected