+
{-# LANGUAGE DeriveDataTypeable #-}
{-# LANGUAGE DeriveGeneric #-}
{-# LANGUAGE FlexibleInstances #-}
import Control.Monad ( forM_ )
import Data.Time ( UTCTime(..) )
import Data.Tuple.Curry ( uncurryN )
+import qualified Data.Vector.HFixed as H ( HVector, cons, convert )
import Database.Groundhog (
countAll,
deleteAll,
- migrate,
- runMigration,
- silentMigrationLogger )
+ migrate )
import Database.Groundhog.Core ( DefaultKey )
-import Database.Groundhog.Generic ( runDbConn )
+import Database.Groundhog.Generic ( runDbConn, runMigrationSilent )
import Database.Groundhog.Sqlite ( withSqliteConn )
import Database.Groundhog.TH (
groundhog,
xpWrap )
-- Local imports.
-import Generics ( Generic(..), to_tuple )
import TSN.Codegen (
tsn_codegen_config )
import TSN.DbImport ( DbImport(..), ImportResult(..), run_dbmigrate )
-import TSN.Picklers ( xp_date_padded, xp_tba_time, xp_time_stamp )
+import TSN.Picklers ( xp_date_padded, xp_tba_int, xp_tba_time, xp_time_stamp )
import TSN.XmlImport ( XmlImport(..), XmlImportFk(..) )
import Xml (
Child(..),
xml_time_stamp :: UTCTime }
deriving (Eq, GHC.Generic, Show)
--- | For 'Generics.to_tuple'.
+-- | For 'H.convert'.
--
-instance Generic Message
+instance H.HVector Message
instance ToDb Message where
db_track_name :: String,
db_location :: String,
db_tv_listing :: Maybe String,
- db_laps :: Int,
+ db_laps :: Maybe Int,
db_track_length :: String -- ^ Sometimes the word "miles" shows up.
}
xml_track_name :: String,
xml_location :: String,
xml_tv_listing :: Maybe String,
- xml_laps :: Int,
+ xml_laps :: Maybe Int,
xml_track_length :: String, -- ^ Sometimes the word \"miles\" shows up,
-- so we can't do the right thing and use
-- a 'Double'.
xml_race_results :: [AutoRacingScheduleListingRaceResult] }
deriving (Eq, GHC.Generic, Show)
--- | For 'Generics.to_tuple'.
+-- | For 'H.convert'.
--
-instance Generic AutoRacingScheduleListingXml
+instance H.HVector AutoRacingScheduleListingXml
-- | Pseudo-accessor to get the race result listings out of a
-- | Database representation of \<RaceResultListing\> within
-- \<RaceResults\> within \<Listing\> within... \<message\>!
+-- The leading underscores prevent unused field warnings.
--
data AutoRacingScheduleListingRaceResultRaceResultListing =
AutoRacingScheduleListingRaceResultRaceResultListing {
- db_auto_racing_schedules_listings_id ::
+ _db_auto_racing_schedules_listings_id ::
DefaultKey AutoRacingScheduleListing,
- db_finish_position :: Int,
- db_driver_id :: Int,
- db_name :: String,
- db_leading_laps :: Int,
- db_listing_laps :: Int, -- ^ Avoid clash with race's \"laps\" field.
- db_earnings :: String, -- ^ This should be an Int, but can have commas.
- db_status :: Maybe String -- ^ They can be empty
+ _db_finish_position :: Int,
+ _db_driver_id :: Int,
+ _db_name :: String,
+ _db_leading_laps :: Int,
+ _db_listing_laps :: Int, -- ^ Avoid clash with race's \"laps\" field.
+ _db_earnings :: String, -- ^ This should be an Int, but can have commas.
+ _db_status :: Maybe String -- ^ They can be empty
}
+ deriving ( GHC.Generic )
+
+-- | For 'H.cons'.
+--
+instance H.HVector AutoRacingScheduleListingRaceResultRaceResultListing
-- | XML Representation of an
-- 'AutoRacingScheduleListingRaceResultRaceResultListing'.
+-- The leading underscores prevent unused field warnings.
--
data AutoRacingScheduleListingRaceResultRaceResultListingXml =
AutoRacingScheduleListingRaceResultRaceResultListingXml {
- xml_finish_position :: Int,
- xml_driver_id :: Int,
- xml_name :: String,
- xml_leading_laps :: Int,
- xml_listing_laps :: Int, -- ^ Avoid clash with race's \"laps\" field.
- xml_earnings :: String, -- ^ Should be an 'Int', but can have commas.
- xml_status :: Maybe String -- ^ They can be empty
+ _xml_finish_position :: Int,
+ _xml_driver_id :: Int,
+ _xml_name :: String,
+ _xml_leading_laps :: Int,
+ _xml_listing_laps :: Int, -- ^ Avoids clash with race's \"laps\" field.
+ _xml_earnings :: String, -- ^ Should be an 'Int', but can have commas.
+ _xml_status :: Maybe String -- ^ They can be empty
}
deriving (Eq, GHC.Generic, Show)
--- | For 'Generics.to_tuple'.
+-- | For 'H.convert'.
--
-instance Generic AutoRacingScheduleListingRaceResultRaceResultListingXml
+instance H.HVector AutoRacingScheduleListingRaceResultRaceResultListingXml
instance ToDb AutoRacingScheduleListingRaceResultRaceResultListingXml where
-- 'AutoRacingScheduleListingRaceResultRaceResultListing', we just
-- add the foreign key to the parent 'AutoRacingScheduleListing'.
--
- from_xml_fk fk AutoRacingScheduleListingRaceResultRaceResultListingXml{..} =
- AutoRacingScheduleListingRaceResultRaceResultListing {
- db_auto_racing_schedules_listings_id = fk,
- db_finish_position = xml_finish_position,
- db_driver_id = xml_driver_id,
- db_name = xml_name,
- db_leading_laps = xml_leading_laps,
- db_listing_laps = xml_listing_laps,
- db_earnings = xml_earnings,
- db_status = xml_status }
+ from_xml_fk = H.cons
-- | This allows us to insert the XML representation
constructors:
- name: AutoRacingScheduleListingRaceResultRaceResultListing
fields:
- - name: db_auto_racing_schedules_listings_id
+ - name: _db_auto_racing_schedules_listings_id
reference:
onDelete: cascade
|]
pickle_message :: PU Message
pickle_message =
xpElem "message" $
- xpWrap (from_tuple, to_tuple) $
+ xpWrap (from_tuple, H.convert) $
xp8Tuple (xpElem "XML_File_ID" xpInt)
(xpElem "heading" xpText)
(xpElem "category" xpText)
pickle_listing :: PU AutoRacingScheduleListingXml
pickle_listing =
xpElem "Listing" $
- xpWrap (from_tuple, to_tuple) $
+ xpWrap (from_tuple, H.convert) $
xp10Tuple (xpElem "RaceID" xpInt)
(xpElem "Race_Date" xp_date_padded)
(xpElem "Race_Time" xp_tba_time)
(xpElem "TrackName" xpText)
(xpElem "Location" xpText)
(xpElem "TV_Listing" $ xpOption xpText)
- (xpElem "Laps" xpInt)
+ (xpElem "Laps" xp_tba_int)
(xpElem "TrackLength" xpText)
(xpList pickle_race_results)
where
PU AutoRacingScheduleListingRaceResultRaceResultListingXml
pickle_race_results_listing =
xpElem "RaceResultsListing" $
- xpWrap (from_tuple, to_tuple) $
+ xpWrap (from_tuple, H.convert) $
xp7Tuple (xpElem "FinishPosition" xpInt)
(xpElem "DriverID" xpInt)
(xpElem "Name" xpText)
let c = undefined :: AutoRacingScheduleListingRaceResultRaceResultListing
actual <- withSqliteConn ":memory:" $ runDbConn $ do
- runMigration silentMigrationLogger $ do
+ runMigrationSilent $ do
migrate a
migrate b
migrate c
projects / dead / htsn-import.git / blobdiff