packages feed

pg-schema-0.9.0.0: pg-schema.cabal

cabal-version:  3.12
name:           pg-schema
version:        0.9.0.0
category:       Database
author:         Dmitry Olshansky
maintainer:     olshanskydr@gmail.com
copyright:      Dmitry Olshansky
license:        BSD-3-Clause
license-file:   LICENSE
build-type:     Simple
tested-with:
  GHC ==9.10.3
  , GHC ==9.12.4
  , GHC ==9.14.1
synopsis:       Type-level definition of database schema and safe DML for PostgreSQL.
description:
    == Schema definition

    Use @updateSchemaFile@ function from "PgSchema.Generation" module to generate type-level definition of database schema.
    You can make several schemas with any parts of your database.

    Usually you make executable which imports this module and run it to generate schema definition.
    You can run it on CI to check if schema definition is up to date.

    == Safe DML for PostgreSQL

    Use "PgSchema.DML" module to describe and generate (in runtime) safe DML for PostgreSQL.
    All operations are statically checked and you can't write invalid SQL.

    With @pg-schema@ you can select or insert/upsert data into tree-like ADT in one request.

    === Example

    Let's say we have tables @shop.ord@, @shop.ord_pos@ and @shop.article@, where @ord_pos@
    references @ord@ and @article@. The foreign keys have the default names given by PostgreSQL:
    @ord_pos_ord_id_fkey@ and @ord_pos_article_id_fkey@. There are articles with ids 41 and 42,
    and we have generated the schema @MySch@ with @updateSchemaFile@ from "PgSchema.Generation".

    Then we can insert an order with its positions, and select orders with their positions and
    articles, using conditions for orders and positions. Each operation is one request.

    > type ShopAnn tabName = 'Ann RenamerId MySch 5 ("shop" ->> tabName)
    >
    > -- An order with its positions to insert
    > type OrdIn = "num" := Text :. "ord_pos_ord_id_fkey" := [OrdPosIn]
    > type OrdPosIn = "num" := Int32 :. "article_id" := Int32 :. "price" := Double
    >
    > -- Orders to select: with positions and their articles
    > data Order = Order { num :: Text, created_at :: Day, ord_pos_ord_id_fkey :: [OrdPos] } deriving Generic
    > data OrdPos = OrdPos { num :: Int32, ord_pos_article_id_fkey :: Article, price :: Double } deriving Generic
    > data Article = Article { name :: Text } deriving Generic
    >
    > example :: Connection -> Day -> IO [Order]
    > example conn someDay = do
    >   void $ insertJSON_ (ShopAnn "ord") conn $ rowsOf @OrdIn
    >     [ "num1" :. [ 1 :. 42 :. 10, 2 :. 41 :. 15 ] ]
    >   fst <$> selectSch (ShopAnn "ord") conn (qRoot do
    >     qWhere $ "created_at" >=? someDay
    >     qOrderBy [descf "created_at", descf "num"]
    >     qPath "ord_pos_ord_id_fkey" do
    >       qWhere $ "price" >? (12 :: Double)
    >       qOrderBy [ascf "num"])

    Note that all table names, field names and foreign key constraint names are checked at compile time!

    === Structure of modules

    * "PgSchema.Generation" - module with generation functions.
      Usually you make executable which generates schema definition using this module.
    * "PgSchema.DML" - module with DML functions.
      Import this module into your application and use it to generate safe DML for PostgreSQL.
    * "PgSchema.Import" - generated schema module imports this module.

homepage:       https://github.com/odr/pg-schema/tree/master/pg-schema#readme
bug-reports:    https://github.com/odr/pg-schema/issues
extra-doc-files:
    ChangeLog.md
    README.md

source-repository head
  type: git
  location: https://github.com/odr/pg-schema

flag time
  description: Make CanConvert1 instances for Time types
  manual:      True
  default:     True

flag uuid
  description: Make CanConvert1 instances for UUID type
  manual:      True
  default:     True

flag case-insensitive
  description: Make CanConvert1 instances for CaseInsensitive type
  manual:      True
  default:     True

flag arbitrary
  description: Make Arbitrary instances for all types (Enums, PgTag)
  manual:      True
  default:     False

flag debug
  description: Trace queries
  manual:      True
  default:     False

flag flat
  description: Make Flat instances for all types (Enums, PgTag)
  manual:      True
  default:     False

flag hashable
  description: Make Hashable instances for all types (Enums, PgTag)
  manual:      True
  default:     False

common shared
  build-depends:
      base >= 4.20 && < 5
    , bytestring >= 0.10 && < 0.13
  default-language: GHC2021
  default-extensions:
    AllowAmbiguousTypes
    BlockArguments
    ExplicitNamespaces
    DataKinds
    -- ^^^ added in GHC2024
    DerivingStrategies
    FunctionalDependencies
    LambdaCase
    -- ^^^ added in GHC2024
    MultiWayIf
    OverloadedRecordDot
    OverloadedStrings
    PatternSynonyms
    RecordWildCards
    RequiredTypeArguments
    -- TemplateHaskell
    TypeAbstractions
    TypeFamilies
    ViewPatterns
  ghc-options:
    -Wall
    -Wunused-packages

library
  import: shared
  exposed-modules:
    -- PgSchema
    PgSchema.DML
    PgSchema.Generation
    PgSchema.Import
    PgSchema.Schema.Catalog
    PgSchema.Schema.Info
    PgSchema.GenDot
  other-modules:
    PgSchema.Ann
    PgSchema.DML.Delete
    PgSchema.DML.Insert
    PgSchema.DML.InsertJSON
    PgSchema.DML.Insert.Types
    PgSchema.DML.KeyedWrite
    PgSchema.DML.UpsertByKey
    PgSchema.DML.Select
    PgSchema.DML.Select.Types
    PgSchema.DML.Update
    PgSchema.Plain
    PgSchema.Schema
    PgSchema.Types
    PgSchema.Utils.CamelToSnake
    PgSchema.Utils.Instances
    PgSchema.Utils.Internal
    PgSchema.Utils.TF
    PgSchema.Utils.ShowType
    --
    Paths_pg_schema
    PackageInfo_pg_schema
  autogen-modules:
    Paths_pg_schema
    PackageInfo_pg_schema
  hs-source-dirs: src
  build-depends:
      aeson >= 2.0 && < 2.4
    , containers >= 0.7 && < 0.9
    , directory >= 1.3 && < 1.5
    , exceptions >= 0.9 && < 0.11
    , mtl >= 2.0 && < 2.4
    , postgresql-simple >= 0.6 && < 0.8
    , postgresql-libpq >= 0.11 && < 0.12
    , scientific >= 0.2 && < 0.4
    , singletons >= 3.0.3 && < 3.1
    , singletons-th >= 3.4 && < 3.6
    , text >= 2.0 && < 2.2
  if flag(time)
    build-depends:
      time >= 1.12 && < 2
    cpp-options: -DMK_TIME
  if flag(uuid)
    build-depends:
      uuid-types >= 1.0 && < 1.1
    cpp-options: -DMK_UUID
  if flag(case-insensitive)
    build-depends:
      case-insensitive >= 1.0 && < 1.3
    cpp-options: -DMK_CASE_INSENSITIVE
  if flag(flat)
    build-depends: flat >= 0.6 && < 0.7
    cpp-options: -DMK_FLAT
  if flag(arbitrary)
    build-depends:
      QuickCheck >= 2.14.0 && < 2.18
    cpp-options: -DMK_ARBITRARY
  if flag(hashable)
    build-depends:
      hashable >= 1.5.1 && < 1.6
    cpp-options: -DMK_HASHABLE
  if flag(debug)
    cpp-options: -DDEBUG

test-suite json-spec
  import: shared
  type: exitcode-stdio-1.0
  main-is: json-spec.hs
  other-modules:
    PgTagJsonSpec
    Paths_pg_schema
    PackageInfo_pg_schema
  autogen-modules:
    Paths_pg_schema
    PackageInfo_pg_schema
  hs-source-dirs: test
  build-depends:
      aeson
    , pg-schema
    , text

test-suite test-gen
  import: shared
  type:             exitcode-stdio-1.0
  hs-source-dirs:   test-gen
  main-is:          Main.hs
  other-modules:
    -- Paths and PackageInfo
    Paths_pg_schema
    PackageInfo_pg_schema
  autogen-modules:
    Paths_pg_schema
    PackageInfo_pg_schema
  build-depends:
      pg-schema
    , postgresql-simple >= 0.6 && < 0.8

test-suite test-pgs
  import: shared
  type:             exitcode-stdio-1.0
  hs-source-dirs:   test-pgs
  main-is:          Main.hs
  other-modules:
    Sch
    Tests.AggregateErrors
    Tests.Aggregates
    Tests.BaseConverts
    Tests.Conditions
    Tests.Hierarchy
    Tests.KeyedDML
    Tests.InsertJSONTransaction
    Tests.JsonNull
    Tests.Named
    Tests.NamedErrors
    Tests.UpsertUniqueKey
    Tests.Path
    Tests.PathErrors
    Tests.ReturningErrors
    Utils
    -- Paths and PackageInfo
    Paths_pg_schema
    PackageInfo_pg_schema
  autogen-modules:
    Paths_pg_schema
    PackageInfo_pg_schema
  build-depends:
    aeson,
    case-insensitive,
    hedgehog >= 1.1,
    pg-schema,
    postgresql-simple >= 0.6 && < 0.8,
    resource-pool,
    scientific,
    tasty >= 1.4,
    tasty-hedgehog >= 1.2,
    text,
    time,
    uuid-types,
    vector,
    -- they can be excluded by flags
    deepseq,
    ghc-heap
    ---------------
  if flag(hashable)
    build-depends:
      hashable >= 1.5.1 && < 1.6
    cpp-options: -DMK_HASHABLE