polytropos-rel8 (empty) → 0.1.0.2
raw patch · 6 files changed
+979/−0 lines, 6 filesdep +basedep +polytropos-coredep +polytropos-plugin
Dependencies added: base, polytropos-core, polytropos-plugin, polytropos-rel8, primitive, rel8, rel8-internal, tasty, tasty-hunit, text
Files
- CHANGELOG.md +7/−0
- LICENSE +391/−0
- README.md +40/−0
- polytropos-rel8.cabal +63/−0
- src/Polytropos/Rel8.hs +302/−0
- test/Main.hs +176/−0
+ CHANGELOG.md view
@@ -0,0 +1,7 @@+# Changelog for polytropos-rel8++## 0.1.0.0 — Initial Release++- High-level type-safe PostgreSQL database mapping connecting open rows to `rel8`+- `PolyRow` higher-kinded `Rel8able` schema representation derived from type-level row specifications+- Slot-by-slot conversions between Rel8 columnar tables and flat `SmallArray` row representations
+ LICENSE view
@@ -0,0 +1,391 @@+Polytropos Dual Licensing++Copyright (c) 2026, Nadia Yvette Chambers <nadia.yvette.chambers@ik.me>+All rights reserved.++SPDX-License-Identifier: EUPL-1.2 OR Apache-2.0++Polytropos is dual-licensed: you may use, copy, modify, merge, publish,+distribute, sublicense, and/or sell copies of the software under the terms+of EITHER:++1. The European Union Public Licence, version 1.2 (EUPL-1.2), as published by+ the European Commission (available in 23 authentic language versions); OR+2. The Apache License, Version 2.0 (Apache-2.0).++You may choose whichever license best fits your requirements and compliance+environment.++Individual license files are available in the LICENSES/ directory:+- LICENSES/EUPL-1.2.txt+- LICENSES/Apache-2.0.txt++================================================================================+1. European Union Public Licence v. 1.2 (EUPL-1.2)+================================================================================++ EUROPEAN UNION PUBLIC LICENCE v. 1.2+ EUPL © the European Union 2007, 2016++This European Union Public Licence (the ‘EUPL’) applies to the Work (as defined+below) which is provided under the terms of this Licence. Any use of the Work,+other than as authorised under this Licence is prohibited (to the extent such+use is covered by a right of the copyright holder of the Work).++The Work is provided under the terms of this Licence when the Licensor (as+defined below) has placed the following notice immediately following the+copyright notice for the Work:++ Licensed under the EUPL++or has expressed by any other means his willingness to license under the EUPL.++1. Definitions++In this Licence, the following terms have the following meaning:++- ‘The Licence’: this Licence.++- ‘The Original Work’: the work or software distributed or communicated by the+ Licensor under this Licence, available as Source Code and also as Executable+ Code as the case may be.++- ‘Derivative Works’: the works or software that could be created by the+ Licensee, based upon the Original Work or modifications thereof. This Licence+ does not define the extent of modification or dependence on the Original Work+ required in order to classify a work as a Derivative Work; this extent is+ determined by copyright law applicable in the country mentioned in Article 15.++- ‘The Work’: the Original Work or its Derivative Works.++- ‘The Source Code’: the human-readable form of the Work which is the most+ convenient for people to study and modify.++- ‘The Executable Code’: any code which has generally been compiled and which is+ meant to be interpreted by a computer as a program.++- ‘The Licensor’: the natural or legal person that distributes or communicates+ the Work under the Licence.++- ‘Contributor(s)’: any natural or legal person who modifies the Work under the+ Licence, or otherwise contributes to the creation of a Derivative Work.++- ‘The Licensee’ or ‘You’: any natural or legal person who makes any usage of+ the Work under the terms of the Licence.++- ‘Distribution’ or ‘Communication’: any act of selling, giving, lending,+ renting, distributing, communicating, transmitting, or otherwise making+ available, online or offline, copies of the Work or providing access to its+ essential functionalities at the disposal of any other natural or legal+ person.++2. Scope of the rights granted by the Licence++The Licensor hereby grants You a worldwide, royalty-free, non-exclusive,+sublicensable licence to do the following, for the duration of copyright vested+in the Original Work:++- use the Work in any circumstance and for all usage,+- reproduce the Work,+- modify the Work, and make Derivative Works based upon the Work,+- communicate to the public, including the right to make available or display+ the Work or copies thereof to the public and perform publicly, as the case may+ be, the Work,+- distribute the Work or copies thereof,+- lend and rent the Work or copies thereof,+- sublicense rights in the Work or copies thereof.++Those rights can be exercised on any media, supports and formats, whether now+known or later invented, as far as the applicable law permits so.++In the countries where moral rights apply, the Licensor waives his right to+exercise his moral right to the extent allowed by law in order to make effective+the licence of the economic rights here above listed.++The Licensor grants to the Licensee royalty-free, non-exclusive usage rights to+any patents held by the Licensor, to the extent necessary to make use of the+rights granted on the Work under this Licence.++3. Communication of the Source Code++The Licensor may provide the Work either in its Source Code form, or as+Executable Code. If the Work is provided as Executable Code, the Licensor+provides in addition a machine-readable copy of the Source Code of the Work+along with each copy of the Work that the Licensor distributes or indicates, in+a notice following the copyright notice attached to the Work, a repository where+the Source Code is easily and freely accessible for as long as the Licensor+continues to distribute or communicate the Work.++4. Limitations on copyright++Nothing in this Licence is intended to deprive the Licensee of the benefits from+any exception or limitation to the exclusive rights of the rights owners in the+Work, of the exhaustion of those rights or of other applicable limitations+thereto.++5. Obligations of the Licensee++The grant of the rights mentioned above is subject to some restrictions and+obligations imposed on the Licensee. Those obligations are the following:++Attribution right: The Licensee shall keep intact all copyright, patent or+trademarks notices and all notices that refer to the Licence and to the+disclaimer of warranties. The Licensee must include a copy of such notices and a+copy of the Licence with every copy of the Work he/she distributes or+communicates. The Licensee must cause any Derivative Work to carry prominent+notices stating that the Work has been modified and the date of modification.++Copyleft clause: If the Licensee distributes or communicates copies of the+Original Works or Derivative Works, this Distribution or Communication will be+done under the terms of this Licence or of a later version of this Licence+unless the Original Work is expressly distributed only under this version of the+Licence — for example by communicating ‘EUPL v. 1.2 only’. The Licensee+(becoming Licensor) cannot offer or impose any additional terms or conditions on+the Work or Derivative Work that alter or restrict the terms of the Licence.++Compatibility clause: If the Licensee Distributes or Communicates Derivative+Works or copies thereof based upon both the Work and another work licensed under+a Compatible Licence, this Distribution or Communication can be done under the+terms of this Compatible Licence. For the sake of this clause, ‘Compatible+Licence’ refers to the licences listed in the appendix attached to this Licence.+Should the Licensee's obligations under the Compatible Licence conflict with+his/her obligations under this Licence, the obligations of the Compatible+Licence shall prevail.++Provision of Source Code: When distributing or communicating copies of the Work,+the Licensee will provide a machine-readable copy of the Source Code or indicate+a repository where this Source will be easily and freely available for as long+as the Licensee continues to distribute or communicate the Work.++Legal Protection: This Licence does not grant permission to use the trade names,+trademarks, service marks, or names of the Licensor, except as required for+reasonable and customary use in describing the origin of the Work and+reproducing the content of the copyright notice.++6. Chain of Authorship++The original Licensor warrants that the copyright in the Original Work granted+hereunder is owned by him/her or licensed to him/her and that he/she has the+power and authority to grant the Licence.++Each Contributor warrants that the copyright in the modifications he/she brings+to the Work are owned by him/her or licensed to him/her and that he/she has the+power and authority to grant the Licence.++Each time You accept the Licence, the original Licensor and subsequent+Contributors grant You a licence to their contributions to the Work, under the+terms of this Licence.++7. Disclaimer of Warranty++The Work is a work in progress, which is continuously improved by numerous+Contributors. It is not a finished work and may therefore contain defects or+‘bugs’ inherent to this type of development.++For the above reason, the Work is provided under the Licence on an ‘as is’ basis+and without warranties of any kind concerning the Work, including without+limitation merchantability, fitness for a particular purpose, absence of defects+or errors, accuracy, non-infringement of intellectual property rights other than+copyright as stated in Article 6 of this Licence.++This disclaimer of warranty is an essential part of the Licence and a condition+for the grant of any rights to the Work.++8. Disclaimer of Liability++Except in the cases of wilful misconduct or damages directly caused to natural+persons, the Licensor will in no event be liable for any direct or indirect,+material or moral, damages of any kind, arising out of the Licence or of the use+of the Work, including without limitation, damages for loss of goodwill, work+stoppage, computer failure or malfunction, loss of data or any commercial+damage, even if the Licensor has been advised of the possibility of such damage.+However, the Licensor will be liable under statutory product liability laws as+far such laws apply to the Work.++9. Additional agreements++While distributing the Work, You may choose to conclude an additional agreement,+defining obligations or services consistent with this Licence. However, if+accepting obligations, You may act only on your own behalf and on your sole+responsibility, not on behalf of the original Licensor or any other Contributor,+and only if You agree to indemnify, defend, and hold each Contributor harmless+for any liability incurred by, or claims asserted against such Contributor by+the fact You have accepted any warranty or additional liability.++10. Acceptance of the Licence++The provisions of this Licence can be accepted by clicking on an icon ‘I agree’+placed under the bottom of a window displaying the text of this Licence or by+affirming consent in any other similar way, in accordance with the rules of+applicable law. Clicking on that icon indicates your clear and irrevocable+acceptance of this Licence and all of its terms and conditions.++Similarly, you irrevocably accept this Licence and all of its terms and+conditions by exercising any rights granted to You by Article 2 of this Licence,+such as the use of the Work, the creation by You of a Derivative Work or the+Distribution or Communication by You of the Work or copies thereof.++11. Information to the public++In case of any Distribution or Communication of the Work by means of electronic+communication by You (for example, by offering to download the Work from a+remote location) the distribution channel or media (for example, a website) must+at least provide to the public the information requested by the applicable law+regarding the Licensor, the Licence and the way it may be accessible, concluded,+stored and reproduced by the Licensee.++12. Termination of the Licence++The Licence and the rights granted hereunder will terminate automatically upon+any breach by the Licensee of the terms of the Licence.++Such a termination will not terminate the licences of any person who has+received the Work from the Licensee under the Licence, provided such persons+remain in full compliance with the Licence.++13. Miscellaneous++Without prejudice of Article 9 above, the Licence represents the complete+agreement between the Parties as to the Work.++If any provision of the Licence is invalid or unenforceable under applicable+law, this will not affect the validity or enforceability of the Licence as a+whole. Such provision will be construed or reformed so as necessary to make it+valid and enforceable.++The European Commission may publish other linguistic versions or new versions of+this Licence or updated versions of the Appendix, so far this is required and+reasonable, without reducing the scope of the rights granted by the Licence. New+versions of the Licence will be published with a unique version number.++All linguistic versions of this Licence, approved by the European Commission,+have identical value. Parties can take advantage of the linguistic version of+their choice.++14. Jurisdiction++Without prejudice to specific agreement between parties,++- any litigation resulting from the interpretation of this License, arising+ between the European Union institutions, bodies, offices or agencies, as a+ Licensor, and any Licensee, will be subject to the jurisdiction of the Court+ of Justice of the European Union, as laid down in article 272 of the Treaty on+ the Functioning of the European Union,++- any litigation arising between other parties and resulting from the+ interpretation of this License, will be subject to the exclusive jurisdiction+ of the competent court where the Licensor resides or conducts its primary+ business.++15. Applicable Law++Without prejudice to specific agreement between parties,++- this Licence shall be governed by the law of the European Union Member State+ where the Licensor has his seat, resides or has his registered office,++- this licence shall be governed by Belgian law if the Licensor has no seat,+ residence or registered office inside a European Union Member State.++Appendix++‘Compatible Licences’ according to Article 5 EUPL are:++- GNU General Public License (GPL) v. 2, v. 3+- GNU Affero General Public License (AGPL) v. 3+- Open Software License (OSL) v. 2.1, v. 3.0+- Eclipse Public License (EPL) v. 1.0+- CeCILL v. 2.0, v. 2.1+- Mozilla Public Licence (MPL) v. 2+- GNU Lesser General Public Licence (LGPL) v. 2.1, v. 3+- Creative Commons Attribution-ShareAlike v. 3.0 Unported (CC BY-SA 3.0) for+ works other than software+- European Union Public Licence (EUPL) v. 1.1, v. 1.2+- Québec Free and Open-Source Licence — Reciprocity (LiLiQ-R) or Strong+ Reciprocity (LiLiQ-R+).++The European Commission may update this Appendix to later versions of the above+licences without producing a new version of the EUPL, as long as they provide+the rights granted in Article 2 of this Licence and protect the covered Source+Code from exclusive appropriation.++All other changes or additions to this Appendix require the production of a new+EUPL version.++================================================================================+2. Apache License, Version 2.0 (Apache-2.0)+================================================================================++Apache License+Version 2.0, January 2004+http://www.apache.org/licenses/++TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION++1. Definitions.++"License" shall mean the terms and conditions for use, reproduction, and distribution as defined by Sections 1 through 9 of this document.++"Licensor" shall mean the copyright owner or entity authorized by the copyright owner that is granting the License.++"Legal Entity" shall mean the union of the acting entity and all other entities that control, are controlled by, or are under common control with that entity. For the purposes of this definition, "control" means (i) the power, direct or indirect, to cause the direction or management of such entity, whether by contract or otherwise, or (ii) ownership of fifty percent (50%) or more of the outstanding shares, or (iii) beneficial ownership of such entity.++"You" (or "Your") shall mean an individual or Legal Entity exercising permissions granted by this License.++"Source" form shall mean the preferred form for making modifications, including but not limited to software source code, documentation source, and configuration files.++"Object" form shall mean any form resulting from mechanical transformation or translation of a Source form, including but not limited to compiled object code, generated documentation, and conversions to other media types.++"Work" shall mean the work of authorship, whether in Source or Object form, made available under the License, as indicated by a copyright notice that is included in or attached to the work (an example is provided in the Appendix below).++"Derivative Works" shall mean any work, whether in Source or Object form, that is based on (or derived from) the Work and for which the editorial revisions, annotations, elaborations, or other modifications represent, as a whole, an original work of authorship. For the purposes of this License, Derivative Works shall not include works that remain separable from, or merely link (or bind by name) to the interfaces of, the Work and Derivative Works thereof.++"Contribution" shall mean any work of authorship, including the original version of the Work and any modifications or additions to that Work or Derivative Works thereof, that is intentionally submitted to Licensor for inclusion in the Work by the copyright owner or by an individual or Legal Entity authorized to submit on behalf of the copyright owner. For the purposes of this definition, "submitted" means any form of electronic, verbal, or written communication sent to the Licensor or its representatives, including but not limited to communication on electronic mailing lists, source code control systems, and issue tracking systems that are managed by, or on behalf of, the Licensor for the purpose of discussing and improving the Work, but excluding communication that is conspicuously marked or otherwise designated in writing by the copyright owner as "Not a Contribution."++"Contributor" shall mean Licensor and any individual or Legal Entity on behalf of whom a Contribution has been received by Licensor and subsequently incorporated within the Work.++2. Grant of Copyright License. Subject to the terms and conditions of this License, each Contributor hereby grants to You a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable copyright license to reproduce, prepare Derivative Works of, publicly display, publicly perform, sublicense, and distribute the Work and such Derivative Works in Source or Object form.++3. Grant of Patent License. Subject to the terms and conditions of this License, each Contributor hereby grants to You a perpetual, worldwide, non-exclusive, no-charge, royalty-free, irrevocable (except as stated in this section) patent license to make, have made, use, offer to sell, sell, import, and otherwise transfer the Work, where such license applies only to those patent claims licensable by such Contributor that are necessarily infringed by their Contribution(s) alone or by combination of their Contribution(s) with the Work to which such Contribution(s) was submitted. If You institute patent litigation against any entity (including a cross-claim or counterclaim in a lawsuit) alleging that the Work or a Contribution incorporated within the Work constitutes direct or contributory patent infringement, then any patent licenses granted to You under this License for that Work shall terminate as of the date such litigation is filed.++4. Redistribution. You may reproduce and distribute copies of the Work or Derivative Works thereof in any medium, with or without modifications, and in Source or Object form, provided that You meet the following conditions:++ (a) You must give any other recipients of the Work or Derivative Works a copy of this License; and++ (b) You must cause any modified files to carry prominent notices stating that You changed the files; and++ (c) You must retain, in the Source form of any Derivative Works that You distribute, all copyright, patent, trademark, and attribution notices from the Source form of the Work, excluding those notices that do not pertain to any part of the Derivative Works; and++ (d) If the Work includes a "NOTICE" text file as part of its distribution, then any Derivative Works that You distribute must include a readable copy of the attribution notices contained within such NOTICE file, excluding those notices that do not pertain to any part of the Derivative Works, in at least one of the following places: within a NOTICE text file distributed as part of the Derivative Works; within the Source form or documentation, if provided along with the Derivative Works; or, within a display generated by the Derivative Works, if and wherever such third-party notices normally appear. The contents of the NOTICE file are for informational purposes only and do not modify the License. You may add Your own attribution notices within Derivative Works that You distribute, alongside or as an addendum to the NOTICE text from the Work, provided that such additional attribution notices cannot be construed as modifying the License.++ You may add Your own copyright statement to Your modifications and may provide additional or different license terms and conditions for use, reproduction, or distribution of Your modifications, or for any such Derivative Works as a whole, provided Your use, reproduction, and distribution of the Work otherwise complies with the conditions stated in this License.++5. Submission of Contributions. Unless You explicitly state otherwise, any Contribution intentionally submitted for inclusion in the Work by You to the Licensor shall be under the terms and conditions of this License, without any additional terms or conditions. Notwithstanding the above, nothing herein shall supersede or modify the terms of any separate license agreement you may have executed with Licensor regarding such Contributions.++6. Trademarks. This License does not grant permission to use the trade names, trademarks, service marks, or product names of the Licensor, except as required for reasonable and customary use in describing the origin of the Work and reproducing the content of the NOTICE file.++7. Disclaimer of Warranty. Unless required by applicable law or agreed to in writing, Licensor provides the Work (and each Contributor provides its Contributions) on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied, including, without limitation, any warranties or conditions of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A PARTICULAR PURPOSE. You are solely responsible for determining the appropriateness of using or redistributing the Work and assume any risks associated with Your exercise of permissions under this License.++8. Limitation of Liability. In no event and under no legal theory, whether in tort (including negligence), contract, or otherwise, unless required by applicable law (such as deliberate and grossly negligent acts) or agreed to in writing, shall any Contributor be liable to You for damages, including any direct, indirect, special, incidental, or consequential damages of any character arising as a result of this License or out of the use or inability to use the Work (including but not limited to damages for loss of goodwill, work stoppage, computer failure or malfunction, or any and all other commercial damages or losses), even if such Contributor has been advised of the possibility of such damages.++9. Accepting Warranty or Additional Liability. While redistributing the Work or Derivative Works thereof, You may choose to offer, and charge a fee for, acceptance of support, warranty, indemnity, or other liability obligations and/or rights consistent with this License. However, in accepting such obligations, You may act only on Your own behalf and on Your sole responsibility, not on behalf of any other Contributor, and only if You agree to indemnify, defend, and hold each Contributor harmless for any liability incurred by, or claims asserted against, such Contributor by reason of your accepting any such warranty or additional liability.++END OF TERMS AND CONDITIONS++APPENDIX: How to apply the Apache License to your work.++To apply the Apache License to your work, attach the following boilerplate notice, with the fields enclosed by brackets "[]" replaced with your own identifying information. (Don't include the brackets!) The text should be enclosed in the appropriate comment syntax for the file format. We also recommend that a file or class name and description of purpose be included on the same "printed page" as the copyright notice for easier identification within third-party archives.++Copyright [yyyy] [name of copyright owner]++Licensed under the Apache License, Version 2.0 (the "License");+you may not use this file except in compliance with the License.+You may obtain a copy of the License at++http://www.apache.org/licenses/LICENSE-2.0++Unless required by applicable law or agreed to in writing, software+distributed under the License is distributed on an "AS IS" BASIS,+WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.+See the License for the specific language governing permissions and+limitations under the License.
+ README.md view
@@ -0,0 +1,40 @@+# polytropos-rel8++High-level type-safe PostgreSQL database mapping connecting [polytropos](https://github.com/NadiaYvette/polytropos) open rows to Oliver Charles' `rel8` framework.++## Overview++`polytropos-rel8` exposes `PolyRow`, a higher-kinded `Rel8able` schema representation whose columns are derived directly from the row's type-level field specification into an `HProduct` tree.++## Features++- **`PolyRow` Table Schema**: Higher-kinded record schema representation implementing `Rel8able`.+- **Zero-Tuple Mapping**: Converts directly between `rel8` columnar tables and `SmallArray` row representations without intermediate Haskell tuples.+- **Sub-Row Projection**: Slices wide SQL tables into compact view records via `projectRecord`.++## Quick Example++```haskell+{-# LANGUAGE DataKinds #-}+{-# LANGUAGE TypeApplications #-}+{-# OPTIONS_GHC -fplugin=Polytropos.Plugin #-}++import Data.Int (Int64)+import Rel8+import Polytropos+import Polytropos.Rel8++type AccountRow = '["id" ':= Int64, "balance" ':= Double]+type AccountTable = PolyRow AccountRow++-- Lift an open record directly into a Rel8 SQL expression row:+rec :: Record AccountRow+rec = REC { id = 42 :: Int64, balance = 1000.50 :: Double }++sqlExpr :: AccountTable Expr+sqlExpr = litRecord rec+```++## License++Dual-licensed under `EUPL-1.2 OR Apache-2.0`.
+ polytropos-rel8.cabal view
@@ -0,0 +1,63 @@+cabal-version: 3.0+name: polytropos-rel8+version: 0.1.0.2+synopsis: rel8 Rel8able table schemas and queries over polytropos open rows+description:+ High-level type-safe PostgreSQL database mapping connecting <https://hackage.haskell.org/package/polytropos polytropos> open rows+ to Oliver Charles' <https://hackage.haskell.org/package/rel8 rel8> framework.++ Exposes 'Polytropos.Rel8.PolyRow', a higher-kinded 'Rel8.Rel8able' schema representation whose columns+ are derived directly from the row's type-level field specification into an @HProduct@+ tree. Conversions between @rel8@'s columnar representation and the flat 'Data.Primitive.SmallArray.SmallArray'+ payload execute slot-by-slot in row order without intermediate tuples or arity limits.++ Start at the front door module "Polytropos.Rel8" for complete documentation,+ schema definitions, and worked query examples.+license: EUPL-1.2 OR Apache-2.0+license-file: LICENSE+author: Nadia Yvette Chambers+maintainer: nadia.yvette.chambers@ik.me+category: Database, PostgreSQL+homepage: https://github.com/NadiaYvette/polytropos+bug-reports: https://github.com/NadiaYvette/polytropos/issues+extra-doc-files:+ README.md+ , CHANGELOG.md+build-type: Simple++source-repository head+ type: git+ location: https://github.com/NadiaYvette/polytropos+ subdir: packages/polytropos-rel8++library+ default-language: GHC2021+ hs-source-dirs: src+ exposed-modules: Polytropos.Rel8+ ghc-options: -Wall+ build-depends:+ base >= 4.14 && < 5,+ primitive >= 0.7 && < 0.10,+ text >= 1.2 && < 2.2,+ rel8 >= 1.8 && < 1.9,+ rel8-internal >= 1.8 && < 1.9,+ polytropos-core >= 0.1 && < 0.2,+ polytropos-plugin >= 0.1 && < 0.2++test-suite polytropos-rel8-test+ type: exitcode-stdio-1.0+ default-language: GHC2021+ hs-source-dirs: test+ main-is: Main.hs+ ghc-options: -Wall -fplugin=Polytropos.Plugin+ build-depends:+ base,+ primitive,+ text,+ rel8,+ rel8-internal,+ polytropos-core,+ polytropos-rel8,+ polytropos-plugin,+ tasty,+ tasty-hunit
+ src/Polytropos/Rel8.hs view
@@ -0,0 +1,302 @@+{-# LANGUAGE AllowAmbiguousTypes #-}+{-# LANGUAGE DataKinds #-}+{-# LANGUAGE DerivingStrategies #-}+{-# LANGUAGE FlexibleContexts #-}+{-# LANGUAGE FlexibleInstances #-}+{-# LANGUAGE PolyKinds #-}+{-# LANGUAGE RankNTypes #-}+{-# LANGUAGE ScopedTypeVariables #-}+{-# LANGUAGE StandaloneKindSignatures #-}+{-# LANGUAGE TypeApplications #-}+{-# LANGUAGE TypeFamilies #-}+{-# LANGUAGE TypeOperators #-}+{-# LANGUAGE UndecidableInstances #-}+{-# LANGUAGE UndecidableSuperClasses #-}++{-|+Module : Polytropos.Rel8+Description : rel8 Rel8able instances and columnar schemas over Polytropos open rows+Copyright : (c) 2026 The Polytropos Authors+License : EUPL-1.2 OR Apache-2.0+Maintainer : nadia.yvette.chambers@ik.me+Stability : experimental+Portability : non-portable (GHC extensions)++Integration of @polytropos@ open rows with Oliver Charles' @rel8@ PostgreSQL+framework.++= Architectural Overview & Rationale++@t'PolyRow'@ provides rel8's 'Rel8able' for the product row @r@:+* Its column schema is a right-nested 'H.HProduct' tree of 'H.HLabel'ed 'H.HIdentity'+ columns built directly from the row's type-level field list.+* The flat 'Data.Primitive.SmallArray.SmallArray' payload of the underlying @t'Polytropos.Core.Rep'@+ is read and written slot by slot — one slot per column, in row order.+* Conversion to and from rel8's columnar representation never materialises an+ intermediate tuple and is unbounded in arity, completely avoiding GHC's 62-column+ tuple limit.++= When to Use This Module++* When defining database schemas and type-safe SQL queries with @rel8@ where rows+ are modelled as open @polytropos@ records.++= Worked Example++= Worked Example++> {-# LANGUAGE DataKinds #-}+> {-# LANGUAGE TypeApplications #-}+> {-# OPTIONS_GHC -fplugin=Polytropos.Plugin #-}+>+> import Rel8+> import Polytropos+> import Polytropos.Rel8+>+> type AccountRow = '["id" ':= Int64, "balance" ':= Double]+> type AccountTable = PolyRow AccountRow+>+> -- Lift a record to a Rel8 SQL expression row:+> rec :: Record AccountRow+> rec = REC { id = 42 :: Int64, balance = 1000.50 :: Double }+>+> sqlExpr :: AccountTable Expr+> sqlExpr = litRecord rec+-}+module Polytropos.Rel8+ ( -- * A rel8 Table from an Open Row+ PolyRow (..)+ , toRecord+ , fromRecord++ -- * Schema & Rel8able Row Class+ , Rel8able+ , Rel8ableRow (..)+ , RowHTable+ , AllSql++ -- * Entry points for Identity/Result+ , rowToColumns+ , columnsToRow++ -- * Lifting to SQL Expressions+ , litPolyRow+ , litRecord++ -- * Columnar Combinators+ , hfield+ , hfieldAt+ , htabulate+ , hmap+ , htraverse+ , hzipWith+ ) where++import Data.Kind (Type, Constraint)+import Data.Functor.Identity (Identity (..))+import Data.Primitive.SmallArray+ ( SmallArray+ , indexSmallArray+ , sizeofSmallArray+ , smallArrayFromList+ )+import GHC.Exts (Any)+import GHC.TypeLits (KnownSymbol)+import Unsafe.Coerce (unsafeCoerce)++import Rel8 (Rel8able, Expr, lit)+import qualified Rel8.Internal.Generic.Rel8able as G+import Rel8.Internal.Generic.Rel8able (GColumns, GFromExprs)+import qualified Rel8.Internal.Schema.HTable as H+import qualified Rel8.Internal.Schema.HTable.Identity as H+import qualified Rel8.Internal.Schema.HTable.Product as H+import qualified Rel8.Internal.Schema.HTable.Label as H+import qualified Rel8.Internal.Schema.Kind as K+import Rel8.Internal.Schema.Null (Sql)+import Rel8.Internal.Schema.Result (Result)+import Rel8.Internal.Type (DBType)++import Polytropos (Record)+import Polytropos.Core+ ( Row+ , RowRep (..)+ , RowType (..)+ , Rep (..)+ , Pair (..)+ , Field (..)+ , FieldIndex (..)+ )++{-------------------------------------------------------------------------------+ Schema: row -> HTable (closed type family)+-------------------------------------------------------------------------------}++-- | Map a polytropos product row to rel8's HTable: a right-nested 'H.HProduct'+-- tree of 'H.HLabel'ed 'H.HIdentity' columns, one per field, named by the field's+-- 'GHC.TypeLits.Symbol'.+type RowHTable :: Row -> K.HTable+type family RowHTable r where+ RowHTable '[n ':= a] = H.HLabel n (H.HIdentity a)+ RowHTable (n ':= a ': r) = H.HProduct (H.HLabel n (H.HIdentity a)) (RowHTable r)++-- | Constraint: every field label has a 'GHC.TypeLits.KnownSymbol' instance and its type is a PostgreSQL+-- 'Sql' 'DBType'.+type AllSql :: Row -> Constraint+type family AllSql r where+ AllSql '[] = ()+ AllSql '[n ':= a] = (KnownSymbol n, Sql DBType a)+ AllSql (n ':= a ': r) = (KnownSymbol n, Sql DBType a, AllSql r)++{-------------------------------------------------------------------------------+ Rel8ableRow class+-------------------------------------------------------------------------------}++-- | Type class providing bidirectional conversion between a flat 'SmallArray'+-- of slots and the nested rel8 'RowHTable' column tree.+class (AllSql r, H.HTable (RowHTable r)) => Rel8ableRow (r :: Row) where+ -- | Convert a flat array into the nested HTable tree at a given starting offset.+ toHTable :: forall context. SmallArray (context Any) -> Int -> (RowHTable r context, Int)++ -- | Unroll the nested HTable tree into a list of erased column context slots.+ fromHTable :: forall context. RowHTable r context -> [context Any]++ -- | Lift column values at 'Result' (t'Data.Functor.Identity.Identity') into PostgreSQL expressions ('Expr').+ litHTable :: RowHTable r Result -> RowHTable r Expr++ -- | Arity (number of columns).+ rowArity :: Int++instance (KnownSymbol n, Sql DBType a) => Rel8ableRow '[n ':= a] where+ rowArity = 1+ toHTable arr offset =+ let val = unsafeCoerce (indexSmallArray arr offset) :: context a+ in (H.HLabel (H.HIdentity val), offset + 1)+ fromHTable (H.HLabel (H.HIdentity val)) =+ [unsafeCoerce val]+ litHTable (H.HLabel (H.HIdentity (Identity a))) =+ H.HLabel (H.HIdentity (lit a))++instance (KnownSymbol n, Sql DBType a, Rel8ableRow (r1 ': rs)) => Rel8ableRow (n ':= a ': r1 ': rs) where+ rowArity = 1 + rowArity @(r1 ': rs)+ toHTable arr offset =+ let val = unsafeCoerce (indexSmallArray arr offset) :: context a+ (rest, nextOffset) = toHTable @(r1 ': rs) arr (offset + 1)+ in (H.HProduct (H.HLabel (H.HIdentity val)) rest, nextOffset)+ fromHTable (H.HProduct (H.HLabel (H.HIdentity val)) rest) =+ unsafeCoerce val : fromHTable @(r1 ': rs) rest+ litHTable (H.HProduct (H.HLabel (H.HIdentity (Identity a))) rest) =+ H.HProduct (H.HLabel (H.HIdentity (lit a))) (litHTable @(r1 ': rs) rest)++{-------------------------------------------------------------------------------+ The Rel8able+-------------------------------------------------------------------------------}++-- | A rel8 table row backed by an open polytropos product row @r@.+--+-- The newtype is polymorphic in the rel8 context functor @context@ so that rel8+-- can use the same 'Rel8able' at 'Result', 'Expr', 'Rel8.Name', etc.+newtype PolyRow (r :: Row) (context :: Type -> Type) = PolyRow+ { unPolyRow :: RowRep context 'ProductRowT r ()+ }++-- | Convert a @t'PolyRow' r 'Result'@ to a polytropos @'Record' r@.+toRecord :: PolyRow r Result -> Record r+toRecord (PolyRow rep) = rep++-- | Wrap a polytropos @'Record' r@ as a @t'PolyRow' r 'Result'@.+fromRecord :: Record r -> PolyRow r Result+fromRecord rep = PolyRow rep++instance Eq (Record r) => Eq (PolyRow r Result) where+ PolyRow a == PolyRow b = a == b++instance Show (Record r) => Show (PolyRow r Result) where+ showsPrec d (PolyRow a) = showsPrec d a++instance Rel8ableRow r => Rel8able (PolyRow r) where+ type GColumns (PolyRow r) = RowHTable r+ type GFromExprs (PolyRow r) = PolyRow r Result++ gfromColumns _ cols =+ PolyRow (RowRep (Rep 0 (smallArrayFromList (fromHTable @r cols))))+ gtoColumns _ (PolyRow (RowRep (Rep _ arr))) =+ fst (toHTable @r arr 0)+ gfromResult cols =+ PolyRow (RowRep (Rep 0 (smallArrayFromList (fromHTable @r cols))))+ gtoResult (PolyRow (RowRep (Rep _ arr))) =+ fst (toHTable @r arr 0)++{-------------------------------------------------------------------------------+ Identity / Result round-trip entry points+-------------------------------------------------------------------------------}++-- | Pack a @'Record' r@ into its rel8 column tree at t'Data.Functor.Identity.Identity'.+rowToColumns :: forall r. Rel8ableRow r => Record r -> RowHTable r Identity+rowToColumns (RowRep (Rep _ arr)) = fst (toHTable @r arr 0)++-- | Unpack rel8 columns (at t'Data.Functor.Identity.Identity') back into a @'Record' r@.+columnsToRow :: forall r. Rel8ableRow r => RowHTable r Identity -> Record r+columnsToRow cols = RowRep (Rep 0 (smallArrayFromList (fromHTable @r cols)))++{-------------------------------------------------------------------------------+ Lifting to SQL Expressions+-------------------------------------------------------------------------------}++-- | Lift a @t'PolyRow' r 'Result'@ to a @t'PolyRow' r 'Expr'@.+litPolyRow :: forall r. Rel8ableRow r => PolyRow r Result -> PolyRow r Expr+litPolyRow (PolyRow (RowRep (Rep _ arr))) =+ let (resCols, _) = toHTable @r arr 0+ exprCols = litHTable @r resCols+ in PolyRow (RowRep (Rep 0 (smallArrayFromList (fromHTable @r exprCols))))++-- | Lift a polytropos @'Record' r@ directly into a @t'PolyRow' r 'Expr'@.+litRecord :: forall r. Rel8ableRow r => Record r -> PolyRow r Expr+litRecord = litPolyRow . fromRecord++{-------------------------------------------------------------------------------+ Columnar Combinators+-------------------------------------------------------------------------------}++-- | Read a field by name using 'FieldIndex'.+hfield :: forall name r context a. FieldIndex name r a+ => Field name -> PolyRow r context -> context a+hfield _ (PolyRow (RowRep (Rep _ arr))) =+ unsafeCoerce (indexSmallArray arr (fieldIndex @_ @name @r @a))++-- | Read a field at a slot index from a t'PolyRow'.+hfieldAt :: Int -> PolyRow r context -> context Any+hfieldAt i (PolyRow (RowRep (Rep _ arr))) = indexSmallArray arr i++-- | Build a t'PolyRow' by evaluating a generator across each column slot.+htabulate :: forall r context. Rel8ableRow r+ => (Int -> context Any) -> PolyRow r context+htabulate f =+ let n = rowArity @r+ vals = [f i | i <- [0 .. n - 1]]+ in PolyRow (RowRep (Rep 0 (smallArrayFromList vals)))++-- | Map a natural transformation across all columns in a t'PolyRow'.+hmap :: forall r f g. Rel8ableRow r+ => (forall a. f a -> g a) -> PolyRow r f -> PolyRow r g+hmap f (PolyRow (RowRep (Rep _ arr))) =+ let n = sizeofSmallArray arr+ vals = [unsafeCoerce (f (unsafeCoerce (indexSmallArray arr i))) | i <- [0 .. n - 1]]+ in PolyRow (RowRep (Rep 0 (smallArrayFromList vals)))++-- | Traverse all columnar fields in a t'PolyRow'.+htraverse :: forall r f g m. (Applicative m, Rel8ableRow r)+ => (forall a. f a -> m (g a)) -> PolyRow r f -> m (PolyRow r g)+htraverse f (PolyRow (RowRep (Rep _ arr))) =+ let n = sizeofSmallArray arr+ go i+ | i >= n = pure []+ | otherwise = (:) <$> f (unsafeCoerce (indexSmallArray arr i)) <*> go (i + 1)+ in fmap (\res -> PolyRow (RowRep (Rep 0 (smallArrayFromList (map unsafeCoerce res))))) (go 0)++-- | Zip two columnar records slot-by-slot in a tight vector loop.+hzipWith :: forall r f g h. Rel8ableRow r+ => (forall a. f a -> g a -> h a) -> PolyRow r f -> PolyRow r g -> PolyRow r h+hzipWith f (PolyRow (RowRep (Rep _ a))) (PolyRow (RowRep (Rep _ b))) =+ let n = sizeofSmallArray a+ vals = [unsafeCoerce (f (unsafeCoerce (indexSmallArray a i)) (unsafeCoerce (indexSmallArray b i))) | i <- [0 .. n - 1]]+ in PolyRow (RowRep (Rep 0 (smallArrayFromList vals)))
+ test/Main.hs view
@@ -0,0 +1,176 @@+{-# LANGUAGE DataKinds #-}+{-# LANGUAGE OverloadedStrings #-}+{-# LANGUAGE TypeApplications #-}+{-# LANGUAGE TypeOperators #-}+{-# OPTIONS_GHC -fplugin=Polytropos.Plugin #-}++module Main (main) where++import Data.Functor.Const (Const (..))+import Data.Functor.Identity (Identity (..))+import Data.Int (Int64)+import Data.Text (Text)+import qualified Data.Text as T+import Test.Tasty (TestTree, defaultMain, testGroup)+import Test.Tasty.HUnit (testCase, (@?=), assertBool)+import Unsafe.Coerce (unsafeCoerce)++import Rel8 (TableSchema (..), namesFromLabels, each, values, showQuery)+import Rel8.Internal.Schema.Name (Name (..))++import Polytropos+ ( Record+ , Pair (..)+ , Field (..)+ , emptyRecord+ , insertField+ )+import Polytropos.Rel8+ ( PolyRow+ , toRecord+ , fromRecord+ , rowToColumns+ , columnsToRow+ , litPolyRow+ , litRecord+ , hfield+ , hfieldAt+ , htabulate+ , hmap+ , htraverse+ , hzipWith+ )++{-------------------------------------------------------------------------------+ Test Schemas and Records+-------------------------------------------------------------------------------}++type UserRow = '["id" ':= Int64, "name" ':= Text, "active" ':= Bool]++userSchema :: TableSchema (PolyRow UserRow Name)+userSchema = TableSchema+ { name = "users"+ , columns = Rel8.namesFromLabels+ }++userRecord :: Record UserRow+userRecord = REC { id = 42 :: Int64, name = "Alice" :: Text, active = True }++type SingleRow = '["value" ':= Int64]++singleSchema :: TableSchema (PolyRow SingleRow Name)+singleSchema = TableSchema+ { name = "singles"+ , columns = Rel8.namesFromLabels+ }++singleRecord :: Record SingleRow+singleRecord = REC { value = 100 :: Int64 }++{-------------------------------------------------------------------------------+ Main Test Tree+-------------------------------------------------------------------------------}++main :: IO ()+main = defaultMain tests++tests :: TestTree+tests = testGroup "polytropos-rel8"+ [ testGroup "Table Schema & Name Synthesis"+ [ testCase "namesFromLabels synthesizes column names from Symbol labels" $ do+ let TableSchema { columns = cols } = userSchema+ Name idCol = hfield (Field @"id") cols+ Name nameCol = hfield (Field @"name") cols+ Name activeCol = hfield (Field @"active") cols+ idCol @?= "id_1"+ nameCol @?= "name_2"+ activeCol @?= "active_3"++ , testCase "each userSchema generates SELECT query with column projections" $ do+ let q = T.pack (showQuery (each userSchema))+ assertBool "contains table name 'users'" (T.isInfixOf "users" q)+ assertBool "contains 'id_1'" (T.isInfixOf "id_1" q)+ assertBool "contains 'name_2'" (T.isInfixOf "name_2" q)+ assertBool "contains 'active_3'" (T.isInfixOf "active_3" q)+ ]++ , testGroup "Lifting & Query Generation"+ [ testCase "values with litRecord generates VALUES query" $ do+ let q = T.pack (showQuery (values [litRecord userRecord]))+ assertBool "contains 'VALUES'" (T.isInfixOf "VALUES" q)+ assertBool "contains '42'" (T.isInfixOf "42" q)+ assertBool "contains 'Alice'" (T.isInfixOf "Alice" q)+ assertBool "contains 'TRUE'" (T.isInfixOf "TRUE" q)++ , testCase "values with litPolyRow generates VALUES query" $ do+ let q = T.pack (showQuery (values [litPolyRow (fromRecord userRecord)]))+ assertBool "contains 'VALUES'" (T.isInfixOf "VALUES" q)+ assertBool "contains 'Alice'" (T.isInfixOf "Alice" q)+ ]++ , testGroup "Conversions & Roundtrips"+ [ testCase "toRecord . fromRecord is identity" $ do+ toRecord (fromRecord userRecord) @?= userRecord++ , testCase "columnsToRow . rowToColumns is identity" $ do+ columnsToRow (rowToColumns userRecord) @?= userRecord+ ]++ , testGroup "Columnar Combinators"+ [ testCase "hfield reads fields by type-level label" $ do+ let polyRes = fromRecord userRecord+ runIdentity (hfield (Field @"id") polyRes) @?= (42 :: Int64)+ runIdentity (hfield (Field @"name") polyRes) @?= ("Alice" :: Text)+ runIdentity (hfield (Field @"active") polyRes) @?= True++ , testCase "hfieldAt reads raw slots by slot index" $ do+ let polyRes = fromRecord userRecord+ val0 = unsafeCoerce (hfieldAt 0 polyRes) :: Identity Int64+ val1 = unsafeCoerce (hfieldAt 1 polyRes) :: Identity Text+ val2 = unsafeCoerce (hfieldAt 2 polyRes) :: Identity Bool+ runIdentity val0 @?= 42+ runIdentity val1 @?= "Alice"+ runIdentity val2 @?= True++ , testCase "htabulate constructs row from column indices" $ do+ let tab = htabulate @UserRow @(Const Int) (\i -> Const (i * 10))+ fId = hfield (Field @"id") tab :: Const Int Int64+ fName = hfield (Field @"name") tab :: Const Int Text+ fActive = hfield (Field @"active") tab :: Const Int Bool+ getConst fId @?= 0+ getConst fName @?= 10+ getConst fActive @?= 20++ , testCase "hmap maps natural transformation across columns" $ do+ let polyRes = fromRecord userRecord+ mappedId = hmap id polyRes+ toRecord mappedId @?= userRecord++ let constRow = hmap (\(Identity _) -> Const (99 :: Int)) polyRes+ fId = hfield (Field @"id") constRow :: Const Int Int64+ getConst fId @?= 99++ , testCase "htraverse traverses row with applicative" $ do+ let polyRes = fromRecord userRecord+ traversed = htraverse (\(Identity x) -> Identity (Identity x)) polyRes+ runIdentity traversed @?= polyRes++ , testCase "hzipWith combines columns slot-by-slot" $ do+ let polyRes = fromRecord userRecord+ zipped = hzipWith (\(Identity a) (Identity _) -> Identity a) polyRes polyRes+ zipped @?= polyRes+ ]++ , testGroup "Single-Column Row"+ [ testCase "single-column table schema and queries" $ do+ let TableSchema { columns = cols } = singleSchema+ Name valCol = hfield (Field @"value") cols+ valCol @?= "value_1"++ let qEach = T.pack (showQuery (each singleSchema))+ assertBool "contains 'singles'" (T.isInfixOf "singles" qEach)++ let qVal = T.pack (showQuery (values [litRecord singleRecord]))+ assertBool "contains '100'" (T.isInfixOf "100" qVal)+ ]+ ]