-- found within the \<PlayerListing\>s.
--
-- The player listings will be mapped to a database table called
--- "injuries_detail" automatically. The root "message" and "listing"
--- are not retained.
+-- \"injuries_detail_player_listings\" automatically. The root
+-- \"message\" and \"listing\" are not retained.
--
module TSN.XML.InjuriesDetail (
pickle_message,
PlayerListingConstructor(..) )
where
+-- System imports.
import Data.Time ( UTCTime )
import Data.Tuple.Curry ( uncurryN )
import Database.Groundhog (
xpText,
xpWrap )
+-- Local imports.
import TSN.Picklers( xp_date, xp_team_id )
import TSN.DbImport ( DbImport(..), ImportResult(..), run_dbmigrate )
import TSN.XmlImport ( XmlImport(..) )
import Xml ( FromXml(..), pickle_unpickle, unpickleable )
+-- | Database representation of a \<PlayerListing\>, the main type of
+-- element contains in Injuries_Detail_XML messages.
+--
data PlayerListing =
PlayerListing {
team_id :: String, -- ^ TeamIDs are (apparently) three characters long
}
deriving (Eq, Show)
+
instance FromXml PlayerListing where
+ -- | The DB analogue of a 'PlayerListing' is... itself!
type Db PlayerListing = PlayerListing
+
+ -- | To convert between a 'PlayerListing' and a 'PlayerListing',
+ -- we do nothing.
from_xml = id
+-- | This lets us call 'insert_xml' on a 'PlayerListing' without
+-- having to explicitly convert it to its database analogue first.
+--
instance XmlImport PlayerListing
+
+-- | XML incarnation of a \<Listing\> element. We don't store these;
+-- the data type is used only for parsing.
+--
data Listing =
Listing {
listing_team_id :: String -- ^ Avoid conflict with PlayerListing's team_id.
deriving (Eq, Show)
+-- | XML representation of the top-level \<message\> element. These
+-- are not stored; the data type is used only for parsing.
+--
data Message =
Message {
xml_file_id :: Int,
deriving (Eq, Show)
instance DbImport Message where
+ -- | To import a 'Message', we import all of its 'PlayerListing's,
+ -- which we have to dig out of its 'Listing's.
dbimport msg = do
mapM_ insert_xml (concatMap player_listings $ listings msg)
return ImportSucceeded
dbmigrate _ = run_dbmigrate $ migrate (undefined :: PlayerListing)
+
mkPersist defaultCodegenConfig [groundhog|
- entity: PlayerListing
dbName: injuries_detail_player_listings
- name: PlayerListing
fields:
- name: team_id
- type: varchar(3)
+ type: varchar(3) # We've only seen 3... so far.
|]
+-- | Convert 'PlayerListing's to/from XML.
+--
pickle_player_listing :: PU PlayerListing
pickle_player_listing =
xpElem "PlayerListing" $
injury_type pl)
+-- | Convert 'Listing's to/from XML.
+--
pickle_listing :: PU Listing
pickle_listing =
xpElem "Listing" $
to_tuple l = (listing_team_id l, full_name l, player_listings l)
+-- | Convert 'Message's to/from XML.
+--
pickle_message :: PU Message
pickle_message =
xpElem "message" $
listings m,
time_stamp m)
+
--
-- Tasty Tests
--