napkin-backend-mssql-2.0.0
Safe HaskellNone
LanguageGHC2024

Napkin.Run.MsSql

Documentation

msGetAnnotations :: MonadNapkin MsSql m => BackendConn MsSql -> Ref Table -> m TableAnnotations #

enableDoubleQuotedIdens :: MonadNapkin MsSql m => IO Connection -> m Connection #

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

retryDeadLockVictim :: forall q a m. (MonadNapkin MsSql m, RenderSql q MsSql) => (q -> IO a) -> q -> m a #

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

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

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

fromOdbcValue :: TimeZone -> Value -> Value #

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

msAnnotate :: MonadNapkin MsSql m => BackendConn MsSql -> Ref Table -> Annotation -> m () #

msObtainTableKind :: MonadNapkin MsSql m => BackendConn MsSql -> Ref Table -> m TableKind #

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

fieldTypeByName :: Text -> Type #

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

getMsSqlSchema :: MonadNapkin MsSql m => BackendConn MsSql -> (Text, Text) -> m [BackendSchemaField MsSql] #

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

relationSchema :: MonadNapkin MsSql m => BackendConn MsSql -> Relation -> m [BackendSchemaField MsSql] #

getDefaultSchema :: MonadNapkin MsSql m => BackendConn MsSql -> m Name #

listViewsTables :: MonadNapkin MsSql m => Set Prefix -> BackendConn MsSql -> m (Set ListedTable) #

msCheckTableExists :: MonadNapkin MsSql m => BackendConn MsSql -> Ref Table -> m Bool #

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

listViewsTablesQuery :: [Text] -> Query #

renameTableAndMoveSchema :: MonadNapkin MsSql m => BackendConn MsSql -> RenameRelation -> m () #

Orphan instances

Backend MsSql # 
Instance details

Associated Types

data BackendConn MsSql 
Instance details

Defined in Napkin.Run.MsSql

data BackendConn MsSql = MsSqlConn {}

Methods

backendConnectionString :: BackendConn MsSql -> ConnectionString #

backendExecute :: (MonadNapkin MsSql m, RenderSql command MsSql) => BackendConn MsSql -> command -> m () #

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

backendCheckTableExists :: MonadNapkin MsSql m => BackendConn MsSql -> Ref Table -> m Bool #

backendGetTableKind :: MonadNapkin MsSql m => BackendConn MsSql -> Ref Table -> m TableKind #

backendGetRelationSchema :: MonadNapkin MsSql m => BackendConn MsSql -> Ref Table -> Relation -> m [BackendSchemaField MsSql] #

backendGetAnnotations :: MonadNapkin MsSql m => BackendConn MsSql -> Ref Table -> m TableAnnotations #

backendAnnotate :: MonadNapkin MsSql m => BackendConn MsSql -> Ref Table -> Annotation -> m () #

backendCreateAs :: (command ~ CreateRelation MsSql, RenderSql command MsSql, MonadNapkin MsSql m) => BackendConn MsSql -> command -> m () #

backendCreate :: (command ~ CreateTableSchema MsSql, RenderSql command MsSql, MonadNapkin MsSql m) => BackendConn MsSql -> command -> m () #

backendCopyTable :: (MonadNapkin MsSql m, RenderSql DeleteRows MsSql, RenderSql InsertInto MsSql, RenderSql (CreateRelation MsSql) MsSql, Default (BackendMeta 'KindTable MsSql)) => BackendConn MsSql -> Ref Table -> Ref Table -> TableWriteStrategy -> m () #

backendDrop :: MonadNapkin MsSql m => BackendConn MsSql -> DropRelation -> m () #

backendInsertInto :: (command ~ InsertInto, RenderSql command MsSql, MonadNapkin MsSql m) => BackendConn MsSql -> command -> m () #

backendRename :: MonadNapkin MsSql m => BackendConn MsSql -> RenameRelation -> m () #

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

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

RunBackendConn MsSql # 
Instance details

Methods

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

FromRow TableKind # 
Instance details

Methods

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

FromRow AnnotationRow # 
Instance details

Methods

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

CSVImport MsSql # 
Instance details

Methods

chunkLimit :: Int #

isEnabled :: Bool #

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 #

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 Text #

FromJSON (DbBackendOptions MsSql) # 
Instance details

Methods

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

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

omittedField :: Maybe (DbBackendOptions MsSql) #

Default (DbBackendOptions MsSql) # 
Instance details

Methods

def :: 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-backend-mssql-2.0.0-DUZ2oAOWMDC4ldwnbKmiTf" '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 #

Eq (DbBackendOptions MsSql) # 
Instance details

Methods

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

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

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-backend-mssql-2.0.0-DUZ2oAOWMDC4ldwnbKmiTf" '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 #