relational-schemas-0.1.2.2: RDBMSs' schema templates for relational-query

Copyright2013 Kei Hibino
LicenseBSD3
Maintainerex8k.hibino@gmail.com
Stabilityexperimental
Portabilityunknown
Safe HaskellNone
LanguageHaskell2010

Database.Relational.Schema.IBMDB2

Description

This module implements queries to get table schema and table constraint informations from system catalog of IBM DB2.

Synopsis

Documentation

normalizeColumn :: String -> String Source

Normalize column name string to query DB2 system catalog

notNull :: Columns -> Bool Source

Not-null attribute information of column.

getType Source

Arguments

:: Map String TypeQ

Type mapping specified by user

-> Columns

Column info in system catalog

-> Maybe (String, TypeQ)

Result normalized name and mapped Haskell type

Get column normalized name and column Haskell type.

columnsQuerySQL :: Query (String, String) Columns Source

Phantom typed Query to get Columns from schema name and table name.

primaryKeyQuerySQL :: Query (String, String) String Source

Phantom typed Query to get primary key name from schema name and table name.