Safe Haskell	None
Language	Haskell2010

Hasura.Backends.MSSQL.Meta

Contents

Loader
Local types
Transform
Helpers

Description

Metadata related types, functions and helpers.

Provides a single function which loads the MSSQL database metadata. See the file at src-rsrmssqlmssql_table_metadata.sql for the SQL we use to build this metadata. See DBTableMetadata for the Haskell type we use forall storing this metadata.

Synopsis

loadDBMetadata :: MonadIO m => TxET QErr m (DBTablesMetadata 'MSSQL)
data SysTable = SysTable {
- staName :: Text
- staObjectId :: Int
- staJoinedSysColumn :: [SysColumn]
- staJoinedSysSchema :: SysSchema
- staJoinedSysPrimaryKey :: Maybe SysPrimaryKey
}
newtype SysPrimaryKeyColumn = SysPrimaryKeyColumn {
- spkcName :: Text
}
data SysPrimaryKey = SysPrimaryKey {
- spkName :: Text
- spkIndexId :: Int
- spkColumns :: NESeq SysPrimaryKeyColumn
}
data SysSchema = SysSchema {
- ssName :: Text
- ssSchemaId :: Int
}
data SysColumn = SysColumn {
- scName :: Text
- scColumnId :: Int
- scUserTypeId :: Int
- scIsNullable :: Bool
- scIsIdentity :: Bool
- scIsComputed :: Bool
- scJoinedSysType :: SysType
- scJoinedForeignKeyColumns :: [SysForeignKeyColumn]
}
data SysType = SysType {
- styName :: Text
- stySchemaId :: Int
- styUserTypeId :: Int
}
data SysForeignKeyColumn = SysForeignKeyColumn {
- sfkcConstraintObjectId :: Int
- sfkcConstraintColumnId :: Int
- sfkcParentObjectId :: Int
- sfkcParentColumnId :: Int
- sfkcReferencedObjectId :: Int
- sfkcReferencedColumnId :: Int
- sfkcJoinedReferencedTableName :: Text
- sfkcJoinedReferencedColumnName :: Text
- sfkcJoinedReferencedSysSchema :: SysSchema
}
transformTable :: SysTable -> (TableName, DBTableMetadata 'MSSQL)
transformColumn :: SysColumn -> (RawColumnInfo 'MSSQL, [ForeignKey 'MSSQL])
transformPrimaryKey :: SysPrimaryKey -> PrimaryKey 'MSSQL (Column 'MSSQL)
coalesceKeys :: [ForeignKey 'MSSQL] -> [ForeignKey 'MSSQL]
parseScalarType :: Text -> ScalarType

Loader

loadDBMetadata :: MonadIO m => TxET QErr m (DBTablesMetadata 'MSSQL) Source #

Local types

data SysTable Source #

Constructors

SysTable
Fields staName :: Text staObjectId :: Int staJoinedSysColumn :: [SysColumn] staJoinedSysSchema :: SysSchema staJoinedSysPrimaryKey :: Maybe SysPrimaryKey

newtype SysPrimaryKeyColumn Source #

Constructors

SysPrimaryKeyColumn
Fields spkcName :: Text

data SysPrimaryKey Source #

Constructors

SysPrimaryKey
Fields spkName :: Text spkIndexId :: Int spkColumns :: NESeq SysPrimaryKeyColumn

data SysSchema Source #

Constructors

SysSchema
Fields ssName :: Text ssSchemaId :: Int

data SysColumn Source #

Constructors

SysColumn
Fields scName :: Text scColumnId :: Int scUserTypeId :: Int scIsNullable :: Bool scIsIdentity :: Bool scIsComputed :: Bool scJoinedSysType :: SysType scJoinedForeignKeyColumns :: [SysForeignKeyColumn]

data SysType Source #

Constructors

SysType
Fields styName :: Text stySchemaId :: Int styUserTypeId :: Int

data SysForeignKeyColumn Source #

Constructors

SysForeignKeyColumn
Fields sfkcConstraintObjectId :: Int sfkcConstraintColumnId :: Int sfkcParentObjectId :: Int sfkcParentColumnId :: Int sfkcReferencedObjectId :: Int sfkcReferencedColumnId :: Int sfkcJoinedReferencedTableName :: Text sfkcJoinedReferencedColumnName :: Text sfkcJoinedReferencedSysSchema :: SysSchema

Transform

transformTable :: SysTable -> (TableName, DBTableMetadata 'MSSQL) Source #

transformColumn :: SysColumn -> (RawColumnInfo 'MSSQL, [ForeignKey 'MSSQL]) Source #

transformPrimaryKey :: SysPrimaryKey -> PrimaryKey 'MSSQL (Column 'MSSQL) Source #

Helpers

coalesceKeys :: [ForeignKey 'MSSQL] -> [ForeignKey 'MSSQL] Source #

parseScalarType :: Text -> ScalarType Source #