Database.MySQL.Hasqlator.Typed.Schema

Documentation

data TableInfo

Constructors

TableInfo

Fields

• tableName :: Text
• tableSchema :: Text
• tableColumns :: [ColumnInfo]

Instances

Show TableInfo

Defined in Database.MySQL.Hasqlator.Typed.Schema

Methods

showsPrec :: Int -> TableInfo -> ShowS

show :: TableInfo -> String

showList :: [TableInfo] -> ShowS

data ColumnInfo

Constructors

ColumnInfo

Fields

• columnTableSchema :: Text
• columnTableName :: Text
• columnName :: Text
• columnType :: ColumnType
• columnNullable :: Bool
• primaryKey :: Bool
• autoIncrement :: Bool
• foreignKey :: Maybe (Text, Text, Text)

Instances

Show ColumnInfo

Defined in Database.MySQL.Hasqlator.Typed.Schema

Methods

showsPrec :: Int -> ColumnInfo -> ShowS

show :: ColumnInfo -> String

showList :: [ColumnInfo] -> ShowS

fetchTableInfo :: MySQLConn -> [Text] -> IO [TableInfo]

Fetch TableInfo structures for each of the given schemas, using the given MySQLConn connection.

data Sign

Constructors

Signed

Unsigned

Instances

Show Sign

Defined in Database.MySQL.Hasqlator.Typed.Schema

Methods

showsPrec :: Int -> Sign -> ShowS

show :: Sign -> String

showList :: [Sign] -> ShowS

data ColumnType

Constructors

TinyIntColumn Sign

SmallIntColumn Sign

MediumIntColumn Sign

IntColumn Sign

BigIntColumn Sign

DecimalColumn Int Int Sign

VarCharColumn Int

CharColumn Int

TextColumn

BlobColumn

DateTimeColumn Int

TimestampColumn Int

DateColumn

TimeColumn Int

DoubleColumn

FloatColumn

EnumColumn [Text]

SetColumn [Text]

BinaryColumn Int

VarBinaryColumn Int

BitColumn Int

JsonColumn

Instances

Show ColumnType

Defined in Database.MySQL.Hasqlator.Typed.Schema

Methods

showsPrec :: Int -> ColumnType -> ShowS

show :: ColumnType -> String

showList :: [ColumnType] -> ShowS

pprTableInfo :: Text -> [TableInfo] -> Text

data Properties

Constructors

Properties

Fields

• fieldNameModifier :: ColumnInfo -> String
• tableNameModifier :: TableInfo -> String
• classNameModifier :: String -> String
• includeSchema :: Bool
• insertorTypeModifier :: TableInfo -> String
• insertorNameModifier :: TableInfo -> String
• selectorNameModifier :: TableInfo -> String
• fieldsQualifier :: String
• insertorFieldModifier :: ColumnInfo -> String

defaultProperties :: Properties

makeFields :: Properties -> Name -> [TableInfo] -> Q [Dec]

smartUpcase :: String -> String

smartDowncase :: String -> String

makeRecords :: Properties -> [TableInfo] -> Q [Dec]

makeSelectors :: Properties -> Name -> [TableInfo] -> Q [Dec]

makeInsertors :: Properties -> Name -> [TableInfo] -> Q [Dec]