Safe Haskell	None
Language	GHC2024

Napkin.Run.Sqlite

Contents

Orphan instances

Synopsis

listTables :: MonadNapkin Sqlite m => BackendConn Sqlite -> m (Set ListedTable)
normalize :: MonadNapkin Sqlite m => NormalizeTableNames -> m (Map (Ref Table) NormalizedTable)
slQuery :: (MonadNapkin Sqlite m, RenderSql q Sqlite) => BackendConn Sqlite -> q -> m [Map Text Value]
execute :: (MonadNapkin Sqlite m, RenderSql a Sqlite) => BackendConn Sqlite -> a -> m ()
slCheckTableExists :: MonadNapkin Sqlite m => BackendConn Sqlite -> Ref Table -> m Bool
sqliteUriSyntax :: Text -> IO FilePath
withSqliteString :: ConnectionString -> (BackendConn Sqlite -> IO b) -> IO b
tellRowsAffected :: MonadNapkin Sqlite m => Int64 -> m ()
slGetSchema :: MonadNapkin Sqlite m => BackendConn Sqlite -> Ref Table -> Relation -> m [BackendSchemaField Sqlite]
slObtainTableKind :: MonadNapkin Sqlite m => BackendConn Sqlite -> Ref Table -> m TableKind
extractSchema :: MonadNapkin Sqlite m => Ref Table -> BackendConn Sqlite -> m [BackendSchemaField Sqlite]
data SqliteSchemaError
- = UnsupportedSqliteOperation Text
- | MalformedSqliteURI Text

Documentation

listTables :: MonadNapkin Sqlite m => BackendConn Sqlite -> m (Set ListedTable) #

normalize :: MonadNapkin Sqlite m => NormalizeTableNames -> m (Map (Ref Table) NormalizedTable) #

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

execute :: (MonadNapkin Sqlite m, RenderSql a Sqlite) => BackendConn Sqlite -> a -> m () #

Executes sqlite command and returns the number of rows that were changed, inserted, or deleted by the most recent INSERT, DELETE, or UPDATE statement. see https://hackage.haskell.org/package/sqlite-simple-0.4.18.0/docs/Database-SQLite-Simple.html#v:changes

slCheckTableExists :: MonadNapkin Sqlite m => BackendConn Sqlite -> Ref Table -> m Bool #

Checks if the table or view exists.

sqliteUriSyntax :: Text -> IO FilePath #

withSqliteString :: ConnectionString -> (BackendConn Sqlite -> IO b) -> IO b #

tellRowsAffected :: MonadNapkin Sqlite m => Int64 -> m () #

slGetSchema :: MonadNapkin Sqlite m => BackendConn Sqlite -> Ref Table -> Relation -> m [BackendSchemaField Sqlite] #

slObtainTableKind :: MonadNapkin Sqlite m => BackendConn Sqlite -> Ref Table -> m TableKind #

extractSchema :: MonadNapkin Sqlite m => Ref Table -> BackendConn Sqlite -> m [BackendSchemaField Sqlite] #

data SqliteSchemaError #

Constructors

UnsupportedSqliteOperation Text
MalformedSqliteURI Text

Instances

Instances details

Exception SqliteSchemaError #
Instance details Defined in Napkin.Run.Sqlite Methods toException :: SqliteSchemaError -> SomeException # fromException :: SomeException -> Maybe SqliteSchemaError # displayException :: SqliteSchemaError -> String # backtraceDesired :: SqliteSchemaError -> Bool #
Show SqliteSchemaError #
Instance details Defined in Napkin.Run.Sqlite Methods showsPrec :: Int -> SqliteSchemaError -> ShowS # show :: SqliteSchemaError -> String # showList :: [SqliteSchemaError] -> ShowS #
Eq SqliteSchemaError #
Instance details Defined in Napkin.Run.Sqlite Methods (==) :: SqliteSchemaError -> SqliteSchemaError -> Bool # (/=) :: SqliteSchemaError -> SqliteSchemaError -> Bool #

Orphan instances

Backend Sqlite #

Instance details

Associated Types

data BackendConn Sqlite
Instance details Defined in Napkin.Run.Sqlite data BackendConn Sqlite = SqliteConn { connectionString :: ConnectionString sqliteConn :: Pool Connection }

Methods

backendConnectionString :: BackendConn Sqlite -> ConnectionString #

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

RunBackendConn Sqlite #

Instance details

Methods

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

FromField Value #

Instance details

Methods

fromField :: FieldParser Value #

FromRow Text #

Instance details

Methods

fromRow :: RowParser Text #

CSVImport Sqlite #

Instance details

Methods

chunkLimit :: Int #

isEnabled :: Bool #

HasBackendSchemaField Sqlite #

Instance details

Associated Types

data BackendSchemaField Sqlite
Instance details Defined in Napkin.Run.Sqlite data BackendSchemaField Sqlite = SqliteSchemaField { scdCid :: Int scdName :: Text scdType :: Text scdNullable :: Int scdDefaultValue :: Maybe Int scdPrimaryKey :: Int }

Methods

fieldName :: BackendSchemaField Sqlite -> Text #

fieldType :: BackendSchemaField Sqlite -> Type #

HasBackendQueryStats Sqlite #

Instance details

Associated Types

data BackendQueryStats Sqlite
Instance details Defined in Napkin.Run.Sqlite data BackendQueryStats Sqlite = BackendQueryStats

Methods

prettyPrint :: BackendQueryStats Sqlite -> Maybe Text #

FromJSON (DbBackendOptions Sqlite) #

Instance details

Methods

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

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

omittedField :: Maybe (DbBackendOptions Sqlite) #

Default (DbBackendOptions Sqlite) #

Instance details

Methods

def :: DbBackendOptions Sqlite #

Generic (DbBackendOptions Sqlite) #

Instance details

Associated Types

type Rep (DbBackendOptions Sqlite)
Instance details Defined in Napkin.Run.Sqlite type Rep (DbBackendOptions Sqlite) = D1 ('MetaData "DbBackendOptions" "Napkin.Run.Sqlite" "napkin-backend-sqlite-2.0.0-5tDB3kLlbnRYjGKat6306" 'False) (C1 ('MetaCons "SqliteOptions" 'PrefixI 'False) (U1 :: Type -> Type))

Methods

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

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

Show (DbBackendOptions Sqlite) #

Instance details

Methods

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

show :: DbBackendOptions Sqlite -> String #

showList :: [DbBackendOptions Sqlite] -> ShowS #

Eq (DbBackendOptions Sqlite) #

Instance details

Methods

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

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

FromJSON (BackendQueryStats Sqlite) #

Instance details

Methods

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

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

omittedField :: Maybe (BackendQueryStats Sqlite) #

ToJSON (BackendQueryStats Sqlite) #

Instance details

Methods

toJSON :: BackendQueryStats Sqlite -> Value #

toEncoding :: BackendQueryStats Sqlite -> Encoding #

toJSONList :: [BackendQueryStats Sqlite] -> Value #

toEncodingList :: [BackendQueryStats Sqlite] -> Encoding #

omitField :: BackendQueryStats Sqlite -> Bool #

Monoid (BackendQueryStats Sqlite) #

Instance details

Methods

mempty :: BackendQueryStats Sqlite #

mappend :: BackendQueryStats Sqlite -> BackendQueryStats Sqlite -> BackendQueryStats Sqlite #

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

Semigroup (BackendQueryStats Sqlite) #

Instance details

Methods

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

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

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

Generic (BackendQueryStats Sqlite) #

Instance details

Associated Types

type Rep (BackendQueryStats Sqlite)
Instance details Defined in Napkin.Run.Sqlite type Rep (BackendQueryStats Sqlite) = D1 ('MetaData "BackendQueryStats" "Napkin.Run.Sqlite" "napkin-backend-sqlite-2.0.0-5tDB3kLlbnRYjGKat6306" 'False) (C1 ('MetaCons "BackendQueryStats" 'PrefixI 'False) (U1 :: Type -> Type))