napkin-1.0.0
Safe HaskellNone
LanguageGHC2021

Napkin.Run.MsSql

Synopsis

Documentation

enableDoubleQuotedIdens :: (Katip m, MonadIO m) => IO Connection -> m Connection #

withMsSqlString :: MonadIO m => LogEnv -> Natural -> Text -> (BackendConn MsSql -> m b) -> m b #

retryDeadLockVictim :: (Katip m, RenderSql q MsSql) => (q -> IO a) -> q -> m a #

query :: forall m q a. (FromRow a, Katip m, RenderSql q MsSql, MonadUnliftIO m) => BackendConn MsSql -> q -> m [a] #

toOdbcQuery :: RenderSql q MsSql => q -> Query #

queryWithColumns :: (Katip m, RenderSql q MsSql, MonadUnliftIO m) => BackendConn MsSql -> q -> m [Map Text Value] #

fromOdbcValue :: TimeZone -> Value -> Value #

execute :: (Katip m, MonadUnliftIO m, RenderSql q MsSql) => BackendConn MsSql -> q -> m () #

execute' :: (Katip m, RenderSql q MsSql, MonadUnliftIO m) => BackendConn MsSql -> q -> m Int #

annotate :: (Katip m, MonadUnliftIO m) => BackendConn MsSql -> AnnotateCommand -> m () #

obtainTableKind :: (Katip m, MonadUnliftIO m) => BackendConn MsSql -> GetTableKind -> m TableKind #

tellRowsAffected :: MonadNapkin MsSql m => Int -> m () #

fieldTypeByName :: Text -> Type #

normalizedTableMap :: (Katip m, MonadUnliftIO m) => BackendConn MsSql -> Set (Ref Table) -> m (Map (Ref Table) NormalizedTable) #

getMsSqlSchema :: (Katip m, MonadIO m, MonadUnliftIO m) => BackendConn MsSql -> (String, String) -> m [MsSchemaField] #

refFqTable :: forall {k} (a :: k). Ref a -> (String, String) #

relationSchema :: forall f viewMeta. (viewMeta ~ BackendViewMeta MsSql, MonadNapkin MsSql f) => BackendConn MsSql -> Relation -> f [MsSchemaField] #

Introspect schema of a Relation

getDefaultSchema :: (Katip m, MonadUnliftIO m) => BackendConn MsSql -> m Name #

listViewsTables :: (Katip m, MonadUnliftIO m) => BackendConn MsSql -> Set Prefix -> m (Set ListedTable) #

checkTableExists' :: (Katip m, MonadUnliftIO m) => BackendConn MsSql -> Ref Table -> m Bool #

tableExistsQuery :: Text -> Text -> Q () #

listViewsTablesQuery :: [Text] -> Query #

renameTableAndMoveSchema :: (Katip m, MonadUnliftIO m) => BackendConn MsSql -> RenameTable -> m () #

Orphan instances

Backend MsSql # 
Instance details

Associated Types

data BackendConn MsSql 
Instance details

Defined in Napkin.Run.MsSql

data BackendConn MsSql = MsSqlConn {}

Methods

backendQuery :: (MonadNapkin MsSql m, RenderSql q MsSql) => BackendConn MsSql -> q -> m [Map Text Value] #

backendConnectionString :: BackendConn MsSql -> ConnectionString #

RunBackendConn MsSql # 
Instance details

Methods

runBackendConn :: LogEnv -> DbBackendOptions MsSql -> ConnectionString -> AppName -> Maybe CredentialsPath -> SpecFile -> Maybe AuthPort -> (Pipeline -> BackendConn MsSql -> IO a) -> IO a #

FromRow AnnotationRow # 
Instance details

Methods

fromRow :: [Value] -> Either String AnnotationRow #

FromRow TableKind # 
Instance details

Methods

fromRow :: [Value] -> Either String TableKind #

HasBackendSchemaField MsSql # 
Instance details

Associated Types

data BackendSchemaField MsSql 
Instance details

Defined in Napkin.Run.MsSql

data BackendSchemaField MsSql = MsSqlSchemaField MsSchemaField

Methods

fieldName :: BackendSchemaField MsSql -> Text #

fieldType :: BackendSchemaField MsSql -> Type #

CSVImport MsSql # 
Instance details

Methods

chunkLimit :: Int #

isEnabled :: Bool #

HasBackendQueryStats MsSql # 
Instance details

Associated Types

data BackendQueryStats MsSql 
Instance details

Defined in Napkin.Run.MsSql

data BackendQueryStats MsSql = BackendQueryStats

Methods

prettyPrint :: BackendQueryStats MsSql -> Maybe String #

Command AEDA TableDiagnostics MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> AEDA -> m TableDiagnostics #

Command AnnotateCommand () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> AnnotateCommand -> m () #

Command CheckTableExists Bool MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> CheckTableExists -> m Bool #

Command CopyTable () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> CopyTable -> m () #

Command DeleteFrom () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> DeleteFrom -> m () #

Command DropTable () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> DropTable -> m () #

Command DropView () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> DropView -> m () #

Command GetTableKind TableKind MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> GetTableKind -> m TableKind #

Command InsertIntoQuery () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> InsertIntoQuery -> m () #

Command InsertIntoTable () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> InsertIntoTable -> m () #

Command ReadAnnotationCommand TableAnnotations MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> ReadAnnotationCommand -> m TableAnnotations #

Command RenameTable () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> RenameTable -> m () #

Command Grant () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> Grant -> m () #

Command UpdateQuery () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> UpdateQuery -> m () #

Command GetRelationSchema [BackendSchemaField MsSql] MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> GetRelationSchema -> m [BackendSchemaField MsSql] #

Command ListTables (Set ListedTable) MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> ListTables -> m (Set ListedTable) #

Command NormalizeTableNames (Map (Ref Table) NormalizedTable) MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> NormalizeTableNames -> m (Map (Ref Table) NormalizedTable) #

FromJSON (DbBackendOptions MsSql) # 
Instance details

Methods

parseJSON :: Value -> Parser (DbBackendOptions MsSql) #

parseJSONList :: Value -> Parser [DbBackendOptions MsSql] #

omittedField :: Maybe (DbBackendOptions MsSql) #

Generic (DbBackendOptions MsSql) # 
Instance details

Associated Types

type Rep (DbBackendOptions MsSql) 
Instance details

Defined in Napkin.Run.MsSql

type Rep (DbBackendOptions MsSql) = D1 ('MetaData "DbBackendOptions" "Napkin.Run.MsSql" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'True) (C1 ('MetaCons "MsSqlOptions" 'PrefixI 'False) (S1 ('MetaSel ('Nothing :: Maybe Symbol) 'NoSourceUnpackedness 'NoSourceStrictness 'DecidedLazy) (Rec0 Natural)))

Methods

from :: DbBackendOptions MsSql -> Rep (DbBackendOptions MsSql) x #

to :: Rep (DbBackendOptions MsSql) x -> DbBackendOptions MsSql #

Show (DbBackendOptions MsSql) # 
Instance details

Methods

showsPrec :: Int -> DbBackendOptions MsSql -> ShowS #

show :: DbBackendOptions MsSql -> String #

showList :: [DbBackendOptions MsSql] -> ShowS #

Default (DbBackendOptions MsSql) # 
Instance details

Methods

def :: DbBackendOptions MsSql #

Eq (DbBackendOptions MsSql) # 
Instance details

Methods

(==) :: DbBackendOptions MsSql -> DbBackendOptions MsSql -> Bool #

(/=) :: DbBackendOptions MsSql -> DbBackendOptions MsSql -> Bool #

Command (CreateMaterializedView MsSqlMaterializedViewMeta) () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> CreateMaterializedView MsSqlMaterializedViewMeta -> m () #

Command (CreateTable TableMeta) () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> CreateTable TableMeta -> m () #

Command (CreateTableDDL TableMeta) () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> CreateTableDDL TableMeta -> m () #

Command (CreateView ()) () MsSql # 
Instance details

Methods

execCommand :: MonadNapkin MsSql m => BackendConn MsSql -> CreateView () -> m () #

FromJSON (BackendQueryStats MsSql) # 
Instance details

Methods

parseJSON :: Value -> Parser (BackendQueryStats MsSql) #

parseJSONList :: Value -> Parser [BackendQueryStats MsSql] #

omittedField :: Maybe (BackendQueryStats MsSql) #

ToJSON (BackendQueryStats MsSql) # 
Instance details

Methods

toJSON :: BackendQueryStats MsSql -> Value #

toEncoding :: BackendQueryStats MsSql -> Encoding #

toJSONList :: [BackendQueryStats MsSql] -> Value #

toEncodingList :: [BackendQueryStats MsSql] -> Encoding #

omitField :: BackendQueryStats MsSql -> Bool #

Monoid (BackendQueryStats MsSql) # 
Instance details

Methods

mempty :: BackendQueryStats MsSql #

mappend :: BackendQueryStats MsSql -> BackendQueryStats MsSql -> BackendQueryStats MsSql #

mconcat :: [BackendQueryStats MsSql] -> BackendQueryStats MsSql #

Semigroup (BackendQueryStats MsSql) # 
Instance details

Methods

(<>) :: BackendQueryStats MsSql -> BackendQueryStats MsSql -> BackendQueryStats MsSql #

sconcat :: NonEmpty (BackendQueryStats MsSql) -> BackendQueryStats MsSql #

stimes :: Integral b => b -> BackendQueryStats MsSql -> BackendQueryStats MsSql #

Generic (BackendQueryStats MsSql) # 
Instance details

Associated Types

type Rep (BackendQueryStats MsSql) 
Instance details

Defined in Napkin.Run.MsSql

type Rep (BackendQueryStats MsSql) = D1 ('MetaData "BackendQueryStats" "Napkin.Run.MsSql" "napkin-1.0.0-5YkWAC9Wc776PT0LDghaFb" 'False) (C1 ('MetaCons "BackendQueryStats" 'PrefixI 'False) (U1 :: Type -> Type))

Methods

from :: BackendQueryStats MsSql -> Rep (BackendQueryStats MsSql) x #

to :: Rep (BackendQueryStats MsSql) x -> BackendQueryStats MsSql #

Show (BackendSchemaField MsSql) # 
Instance details

Methods

showsPrec :: Int -> BackendSchemaField MsSql -> ShowS #

show :: BackendSchemaField MsSql -> String #

showList :: [BackendSchemaField MsSql] -> ShowS #

Show (BackendQueryStats MsSql) # 
Instance details

Methods

showsPrec :: Int -> BackendQueryStats MsSql -> ShowS #

show :: BackendQueryStats MsSql -> String #

showList :: [BackendQueryStats MsSql] -> ShowS #

Eq (BackendSchemaField MsSql) # 
Instance details

Methods

(==) :: BackendSchemaField MsSql -> BackendSchemaField MsSql -> Bool #

(/=) :: BackendSchemaField MsSql -> BackendSchemaField MsSql -> Bool #

Eq (BackendQueryStats MsSql) # 
Instance details

Methods

(==) :: BackendQueryStats MsSql -> BackendQueryStats MsSql -> Bool #

(/=) :: BackendQueryStats MsSql -> BackendQueryStats MsSql -> Bool #