dataframe-persistent (empty) → 0.1.0.0

raw patch · 8 files changed

+1681/−0 lines, 8 filesdep +HUnitdep +basedep +bytestring

Dependencies added: HUnit, base, bytestring, containers, dataframe, dataframe-persistent, monad-logger, persistent, persistent-sqlite, resourcet, template-haskell, temporary, text, time, transformers, vector

Files

• CHANGELOG.md +0/−0
• LICENSE +674/−0
• README.md +173/−0
• dataframe-persistent.cabal +72/−0
• src/DataFrame/IO/Persistent.hs +275/−0
• src/DataFrame/IO/Persistent/TH.hs +182/−0
• tests/Main.hs +14/−0
• tests/PersistentTests.hs +291/−0

@@ -0,0 +1,674 @@+                    GNU GENERAL PUBLIC LICENSE+                       Version 3, 29 June 2007++ Copyright (C) 2007 Free Software Foundation, Inc. <https://fsf.org/>+ Everyone is permitted to copy and distribute verbatim copies+ of this license document, but changing it is not allowed.++                            Preamble++  The GNU General Public License is a free, copyleft license for+software and other kinds of works.++  The licenses for most software and other practical works are designed+to take away your freedom to share and change the works.  By contrast,+the GNU General Public License is intended to guarantee your freedom to+share and change all versions of a program--to make sure it remains free+software for all its users.  We, the Free Software Foundation, use the+GNU General Public License for most of our software; it applies also to+any other work released this way by its authors.  You can apply it to+your programs, too.++  When we speak of free software, we are referring to freedom, not+price.  Our General Public Licenses are designed to make sure that you+have the freedom to distribute copies of free software (and charge for+them if you wish), that you receive source code or can get it if you+want it, that you can change the software or use pieces of it in new+free programs, and that you know you can do these things.++  To protect your rights, we need to prevent others from denying you+these rights or asking you to surrender the rights.  Therefore, you have+certain responsibilities if you distribute copies of the software, or if+you modify it: responsibilities to respect the freedom of others.++  For example, if you distribute copies of such a program, whether+gratis or for a fee, you must pass on to the recipients the same+freedoms that you received.  You must make sure that they, too, receive+or can get the source code.  And you must show them these terms so they+know their rights.++  Developers that use the GNU GPL protect your rights with two steps:+(1) assert copyright on the software, and (2) offer you this License+giving you legal permission to copy, distribute and/or modify it.++  For the developers' and authors' protection, the GPL clearly explains+that there is no warranty for this free software.  For both users' and+authors' sake, the GPL requires that modified versions be marked as+changed, so that their problems will not be attributed erroneously to+authors of previous versions.++  Some devices are designed to deny users access to install or run+modified versions of the software inside them, although the manufacturer+can do so.  This is fundamentally incompatible with the aim of+protecting users' freedom to change the software.  The systematic+pattern of such abuse occurs in the area of products for individuals to+use, which is precisely where it is most unacceptable.  Therefore, we+have designed this version of the GPL to prohibit the practice for those+products.  If such problems arise substantially in other domains, we+stand ready to extend this provision to those domains in future versions+of the GPL, as needed to protect the freedom of users.++  Finally, every program is threatened constantly by software patents.+States should not allow patents to restrict development and use of+software on general-purpose computers, but in those that do, we wish to+avoid the special danger that patents applied to a free program could+make it effectively proprietary.  To prevent this, the GPL assures that+patents cannot be used to render the program non-free.++  The precise terms and conditions for copying, distribution and+modification follow.++                       TERMS AND CONDITIONS++  0. Definitions.++  "This License" refers to version 3 of the GNU General Public License.++  "Copyright" also means copyright-like laws that apply to other kinds of+works, such as semiconductor masks.++  "The Program" refers to any copyrightable work licensed under this+License.  Each licensee is addressed as "you".  "Licensees" and+"recipients" may be individuals or organizations.++  To "modify" a work means to copy from or adapt all or part of the work+in a fashion requiring copyright permission, other than the making of an+exact copy.  The resulting work is called a "modified version" of the+earlier work or a work "based on" the earlier work.++  A "covered work" means either the unmodified Program or a work based+on the Program.++  To "propagate" a work means to do anything with it that, without+permission, would make you directly or secondarily liable for+infringement under applicable copyright law, except executing it on a+computer or modifying a private copy.  Propagation includes copying,+distribution (with or without modification), making available to the+public, and in some countries other activities as well.++  To "convey" a work means any kind of propagation that enables other+parties to make or receive copies.  Mere interaction with a user through+a computer network, with no transfer of a copy, is not conveying.++  An interactive user interface displays "Appropriate Legal Notices"+to the extent that it includes a convenient and prominently visible+feature that (1) displays an appropriate copyright notice, and (2)+tells the user that there is no warranty for the work (except to the+extent that warranties are provided), that licensees may convey the+work under this License, and how to view a copy of this License.  If+the interface presents a list of user commands or options, such as a+menu, a prominent item in the list meets this criterion.++  1. Source Code.++  The "source code" for a work means the preferred form of the work+for making modifications to it.  "Object code" means any non-source+form of a work.++  A "Standard Interface" means an interface that either is an official+standard defined by a recognized standards body, or, in the case of+interfaces specified for a particular programming language, one that+is widely used among developers working in that language.++  The "System Libraries" of an executable work include anything, other+than the work as a whole, that (a) is included in the normal form of+packaging a Major Component, but which is not part of that Major+Component, and (b) serves only to enable use of the work with that+Major Component, or to implement a Standard Interface for which an+implementation is available to the public in source code form.  A+"Major Component", in this context, means a major essential component+(kernel, window system, and so on) of the specific operating system+(if any) on which the executable work runs, or a compiler used to+produce the work, or an object code interpreter used to run it.++  The "Corresponding Source" for a work in object code form means all+the source code needed to generate, install, and (for an executable+work) run the object code and to modify the work, including scripts to+control those activities.  However, it does not include the work's+System Libraries, or general-purpose tools or generally available free+programs which are used unmodified in performing those activities but+which are not part of the work.  For example, Corresponding Source+includes interface definition files associated with source files for+the work, and the source code for shared libraries and dynamically+linked subprograms that the work is specifically designed to require,+such as by intimate data communication or control flow between those+subprograms and other parts of the work.++  The Corresponding Source need not include anything that users+can regenerate automatically from other parts of the Corresponding+Source.++  The Corresponding Source for a work in source code form is that+same work.++  2. Basic Permissions.++  All rights granted under this License are granted for the term of+copyright on the Program, and are irrevocable provided the stated+conditions are met.  This License explicitly affirms your unlimited+permission to run the unmodified Program.  The output from running a+covered work is covered by this License only if the output, given its+content, constitutes a covered work.  This License acknowledges your+rights of fair use or other equivalent, as provided by copyright law.++  You may make, run and propagate covered works that you do not+convey, without conditions so long as your license otherwise remains+in force.  You may convey covered works to others for the sole purpose+of having them make modifications exclusively for you, or provide you+with facilities for running those works, provided that you comply with+the terms of this License in conveying all material for which you do+not control copyright.  Those thus making or running the covered works+for you must do so exclusively on your behalf, under your direction+and control, on terms that prohibit them from making any copies of+your copyrighted material outside their relationship with you.++  Conveying under any other circumstances is permitted solely under+the conditions stated below.  Sublicensing is not allowed; section 10+makes it unnecessary.++  3. Protecting Users' Legal Rights From Anti-Circumvention Law.++  No covered work shall be deemed part of an effective technological+measure under any applicable law fulfilling obligations under article+11 of the WIPO copyright treaty adopted on 20 December 1996, or+similar laws prohibiting or restricting circumvention of such+measures.++  When you convey a covered work, you waive any legal power to forbid+circumvention of technological measures to the extent such circumvention+is effected by exercising rights under this License with respect to+the covered work, and you disclaim any intention to limit operation or+modification of the work as a means of enforcing, against the work's+users, your or third parties' legal rights to forbid circumvention of+technological measures.++  4. Conveying Verbatim Copies.++  You may convey verbatim copies of the Program's source code as you+receive it, in any medium, provided that you conspicuously and+appropriately publish on each copy an appropriate copyright notice;+keep intact all notices stating that this License and any+non-permissive terms added in accord with section 7 apply to the code;+keep intact all notices of the absence of any warranty; and give all+recipients a copy of this License along with the Program.++  You may charge any price or no price for each copy that you convey,+and you may offer support or warranty protection for a fee.++  5. Conveying Modified Source Versions.++  You may convey a work based on the Program, or the modifications to+produce it from the Program, in the form of source code under the+terms of section 4, provided that you also meet all of these conditions:++    a) The work must carry prominent notices stating that you modified+    it, and giving a relevant date.++    b) The work must carry prominent notices stating that it is+    released under this License and any conditions added under section+    7.  This requirement modifies the requirement in section 4 to+    "keep intact all notices".++    c) You must license the entire work, as a whole, under this+    License to anyone who comes into possession of a copy.  This+    License will therefore apply, along with any applicable section 7+    additional terms, to the whole of the work, and all its parts,+    regardless of how they are packaged.  This License gives no+    permission to license the work in any other way, but it does not+    invalidate such permission if you have separately received it.++    d) If the work has interactive user interfaces, each must display+    Appropriate Legal Notices; however, if the Program has interactive+    interfaces that do not display Appropriate Legal Notices, your+    work need not make them do so.++  A compilation of a covered work with other separate and independent+works, which are not by their nature extensions of the covered work,+and which are not combined with it such as to form a larger program,+in or on a volume of a storage or distribution medium, is called an+"aggregate" if the compilation and its resulting copyright are not+used to limit the access or legal rights of the compilation's users+beyond what the individual works permit.  Inclusion of a covered work+in an aggregate does not cause this License to apply to the other+parts of the aggregate.++  6. Conveying Non-Source Forms.++  You may convey a covered work in object code form under the terms+of sections 4 and 5, provided that you also convey the+machine-readable Corresponding Source under the terms of this License,+in one of these ways:++    a) Convey the object code in, or embodied in, a physical product+    (including a physical distribution medium), accompanied by the+    Corresponding Source fixed on a durable physical medium+    customarily used for software interchange.++    b) Convey the object code in, or embodied in, a physical product+    (including a physical distribution medium), accompanied by a+    written offer, valid for at least three years and valid for as+    long as you offer spare parts or customer support for that product+    model, to give anyone who possesses the object code either (1) a+    copy of the Corresponding Source for all the software in the+    product that is covered by this License, on a durable physical+    medium customarily used for software interchange, for a price no+    more than your reasonable cost of physically performing this+    conveying of source, or (2) access to copy the+    Corresponding Source from a network server at no charge.++    c) Convey individual copies of the object code with a copy of the+    written offer to provide the Corresponding Source.  This+    alternative is allowed only occasionally and noncommercially, and+    only if you received the object code with such an offer, in accord+    with subsection 6b.++    d) Convey the object code by offering access from a designated+    place (gratis or for a charge), and offer equivalent access to the+    Corresponding Source in the same way through the same place at no+    further charge.  You need not require recipients to copy the+    Corresponding Source along with the object code.  If the place to+    copy the object code is a network server, the Corresponding Source+    may be on a different server (operated by you or a third party)+    that supports equivalent copying facilities, provided you maintain+    clear directions next to the object code saying where to find the+    Corresponding Source.  Regardless of what server hosts the+    Corresponding Source, you remain obligated to ensure that it is+    available for as long as needed to satisfy these requirements.++    e) Convey the object code using peer-to-peer transmission, provided+    you inform other peers where the object code and Corresponding+    Source of the work are being offered to the general public at no+    charge under subsection 6d.++  A separable portion of the object code, whose source code is excluded+from the Corresponding Source as a System Library, need not be+included in conveying the object code work.++  A "User Product" is either (1) a "consumer product", which means any+tangible personal property which is normally used for personal, family,+or household purposes, or (2) anything designed or sold for incorporation+into a dwelling.  In determining whether a product is a consumer product,+doubtful cases shall be resolved in favor of coverage.  For a particular+product received by a particular user, "normally used" refers to a+typical or common use of that class of product, regardless of the status+of the particular user or of the way in which the particular user+actually uses, or expects or is expected to use, the product.  A product+is a consumer product regardless of whether the product has substantial+commercial, industrial or non-consumer uses, unless such uses represent+the only significant mode of use of the product.++  "Installation Information" for a User Product means any methods,+procedures, authorization keys, or other information required to install+and execute modified versions of a covered work in that User Product from+a modified version of its Corresponding Source.  The information must+suffice to ensure that the continued functioning of the modified object+code is in no case prevented or interfered with solely because+modification has been made.++  If you convey an object code work under this section in, or with, or+specifically for use in, a User Product, and the conveying occurs as+part of a transaction in which the right of possession and use of the+User Product is transferred to the recipient in perpetuity or for a+fixed term (regardless of how the transaction is characterized), the+Corresponding Source conveyed under this section must be accompanied+by the Installation Information.  But this requirement does not apply+if neither you nor any third party retains the ability to install+modified object code on the User Product (for example, the work has+been installed in ROM).++  The requirement to provide Installation Information does not include a+requirement to continue to provide support service, warranty, or updates+for a work that has been modified or installed by the recipient, or for+the User Product in which it has been modified or installed.  Access to a+network may be denied when the modification itself materially and+adversely affects the operation of the network or violates the rules and+protocols for communication across the network.++  Corresponding Source conveyed, and Installation Information provided,+in accord with this section must be in a format that is publicly+documented (and with an implementation available to the public in+source code form), and must require no special password or key for+unpacking, reading or copying.++  7. Additional Terms.++  "Additional permissions" are terms that supplement the terms of this+License by making exceptions from one or more of its conditions.+Additional permissions that are applicable to the entire Program shall+be treated as though they were included in this License, to the extent+that they are valid under applicable law.  If additional permissions+apply only to part of the Program, that part may be used separately+under those permissions, but the entire Program remains governed by+this License without regard to the additional permissions.++  When you convey a copy of a covered work, you may at your option+remove any additional permissions from that copy, or from any part of+it.  (Additional permissions may be written to require their own+removal in certain cases when you modify the work.)  You may place+additional permissions on material, added by you to a covered work,+for which you have or can give appropriate copyright permission.++  Notwithstanding any other provision of this License, for material you+add to a covered work, you may (if authorized by the copyright holders of+that material) supplement the terms of this License with terms:++    a) Disclaiming warranty or limiting liability differently from the+    terms of sections 15 and 16 of this License; or++    b) Requiring preservation of specified reasonable legal notices or+    author attributions in that material or in the Appropriate Legal+    Notices displayed by works containing it; or++    c) Prohibiting misrepresentation of the origin of that material, or+    requiring that modified versions of such material be marked in+    reasonable ways as different from the original version; or++    d) Limiting the use for publicity purposes of names of licensors or+    authors of the material; or++    e) Declining to grant rights under trademark law for use of some+    trade names, trademarks, or service marks; or++    f) Requiring indemnification of licensors and authors of that+    material by anyone who conveys the material (or modified versions of+    it) with contractual assumptions of liability to the recipient, for+    any liability that these contractual assumptions directly impose on+    those licensors and authors.++  All other non-permissive additional terms are considered "further+restrictions" within the meaning of section 10.  If the Program as you+received it, or any part of it, contains a notice stating that it is+governed by this License along with a term that is a further+restriction, you may remove that term.  If a license document contains+a further restriction but permits relicensing or conveying under this+License, you may add to a covered work material governed by the terms+of that license document, provided that the further restriction does+not survive such relicensing or conveying.++  If you add terms to a covered work in accord with this section, you+must place, in the relevant source files, a statement of the+additional terms that apply to those files, or a notice indicating+where to find the applicable terms.++  Additional terms, permissive or non-permissive, may be stated in the+form of a separately written license, or stated as exceptions;+the above requirements apply either way.++  8. Termination.++  You may not propagate or modify a covered work except as expressly+provided under this License.  Any attempt otherwise to propagate or+modify it is void, and will automatically terminate your rights under+this License (including any patent licenses granted under the third+paragraph of section 11).++  However, if you cease all violation of this License, then your+license from a particular copyright holder is reinstated (a)+provisionally, unless and until the copyright holder explicitly and+finally terminates your license, and (b) permanently, if the copyright+holder fails to notify you of the violation by some reasonable means+prior to 60 days after the cessation.++  Moreover, your license from a particular copyright holder is+reinstated permanently if the copyright holder notifies you of the+violation by some reasonable means, this is the first time you have+received notice of violation of this License (for any work) from that+copyright holder, and you cure the violation prior to 30 days after+your receipt of the notice.++  Termination of your rights under this section does not terminate the+licenses of parties who have received copies or rights from you under+this License.  If your rights have been terminated and not permanently+reinstated, you do not qualify to receive new licenses for the same+material under section 10.++  9. Acceptance Not Required for Having Copies.++  You are not required to accept this License in order to receive or+run a copy of the Program.  Ancillary propagation of a covered work+occurring solely as a consequence of using peer-to-peer transmission+to receive a copy likewise does not require acceptance.  However,+nothing other than this License grants you permission to propagate or+modify any covered work.  These actions infringe copyright if you do+not accept this License.  Therefore, by modifying or propagating a+covered work, you indicate your acceptance of this License to do so.++  10. Automatic Licensing of Downstream Recipients.++  Each time you convey a covered work, the recipient automatically+receives a license from the original licensors, to run, modify and+propagate that work, subject to this License.  You are not responsible+for enforcing compliance by third parties with this License.++  An "entity transaction" is a transaction transferring control of an+organization, or substantially all assets of one, or subdividing an+organization, or merging organizations.  If propagation of a covered+work results from an entity transaction, each party to that+transaction who receives a copy of the work also receives whatever+licenses to the work the party's predecessor in interest had or could+give under the previous paragraph, plus a right to possession of the+Corresponding Source of the work from the predecessor in interest, if+the predecessor has it or can get it with reasonable efforts.++  You may not impose any further restrictions on the exercise of the+rights granted or affirmed under this License.  For example, you may+not impose a license fee, royalty, or other charge for exercise of+rights granted under this License, and you may not initiate litigation+(including a cross-claim or counterclaim in a lawsuit) alleging that+any patent claim is infringed by making, using, selling, offering for+sale, or importing the Program or any portion of it.++  11. Patents.++  A "contributor" is a copyright holder who authorizes use under this+License of the Program or a work on which the Program is based.  The+work thus licensed is called the contributor's "contributor version".++  A contributor's "essential patent claims" are all patent claims+owned or controlled by the contributor, whether already acquired or+hereafter acquired, that would be infringed by some manner, permitted+by this License, of making, using, or selling its contributor version,+but do not include claims that would be infringed only as a+consequence of further modification of the contributor version.  For+purposes of this definition, "control" includes the right to grant+patent sublicenses in a manner consistent with the requirements of+this License.++  Each contributor grants you a non-exclusive, worldwide, royalty-free+patent license under the contributor's essential patent claims, to+make, use, sell, offer for sale, import and otherwise run, modify and+propagate the contents of its contributor version.++  In the following three paragraphs, a "patent license" is any express+agreement or commitment, however denominated, not to enforce a patent+(such as an express permission to practice a patent or covenant not to+sue for patent infringement).  To "grant" such a patent license to a+party means to make such an agreement or commitment not to enforce a+patent against the party.++  If you convey a covered work, knowingly relying on a patent license,+and the Corresponding Source of the work is not available for anyone+to copy, free of charge and under the terms of this License, through a+publicly available network server or other readily accessible means,+then you must either (1) cause the Corresponding Source to be so+available, or (2) arrange to deprive yourself of the benefit of the+patent license for this particular work, or (3) arrange, in a manner+consistent with the requirements of this License, to extend the patent+license to downstream recipients.  "Knowingly relying" means you have+actual knowledge that, but for the patent license, your conveying the+covered work in a country, or your recipient's use of the covered work+in a country, would infringe one or more identifiable patents in that+country that you have reason to believe are valid.++  If, pursuant to or in connection with a single transaction or+arrangement, you convey, or propagate by procuring conveyance of, a+covered work, and grant a patent license to some of the parties+receiving the covered work authorizing them to use, propagate, modify+or convey a specific copy of the covered work, then the patent license+you grant is automatically extended to all recipients of the covered+work and works based on it.++  A patent license is "discriminatory" if it does not include within+the scope of its coverage, prohibits the exercise of, or is+conditioned on the non-exercise of one or more of the rights that are+specifically granted under this License.  You may not convey a covered+work if you are a party to an arrangement with a third party that is+in the business of distributing software, under which you make payment+to the third party based on the extent of your activity of conveying+the work, and under which the third party grants, to any of the+parties who would receive the covered work from you, a discriminatory+patent license (a) in connection with copies of the covered work+conveyed by you (or copies made from those copies), or (b) primarily+for and in connection with specific products or compilations that+contain the covered work, unless you entered into that arrangement,+or that patent license was granted, prior to 28 March 2007.++  Nothing in this License shall be construed as excluding or limiting+any implied license or other defenses to infringement that may+otherwise be available to you under applicable patent law.++  12. No Surrender of Others' Freedom.++  If conditions are imposed on you (whether by court order, agreement or+otherwise) that contradict the conditions of this License, they do not+excuse you from the conditions of this License.  If you cannot convey a+covered work so as to satisfy simultaneously your obligations under this+License and any other pertinent obligations, then as a consequence you may+not convey it at all.  For example, if you agree to terms that obligate you+to collect a royalty for further conveying from those to whom you convey+the Program, the only way you could satisfy both those terms and this+License would be to refrain entirely from conveying the Program.++  13. Use with the GNU Affero General Public License.++  Notwithstanding any other provision of this License, you have+permission to link or combine any covered work with a work licensed+under version 3 of the GNU Affero General Public License into a single+combined work, and to convey the resulting work.  The terms of this+License will continue to apply to the part which is the covered work,+but the special requirements of the GNU Affero General Public License,+section 13, concerning interaction through a network will apply to the+combination as such.++  14. Revised Versions of this License.++  The Free Software Foundation may publish revised and/or new versions of+the GNU General Public License from time to time.  Such new versions will+be similar in spirit to the present version, but may differ in detail to+address new problems or concerns.++  Each version is given a distinguishing version number.  If the+Program specifies that a certain numbered version of the GNU General+Public License "or any later version" applies to it, you have the+option of following the terms and conditions either of that numbered+version or of any later version published by the Free Software+Foundation.  If the Program does not specify a version number of the+GNU General Public License, you may choose any version ever published+by the Free Software Foundation.++  If the Program specifies that a proxy can decide which future+versions of the GNU General Public License can be used, that proxy's+public statement of acceptance of a version permanently authorizes you+to choose that version for the Program.++  Later license versions may give you additional or different+permissions.  However, no additional obligations are imposed on any+author or copyright holder as a result of your choosing to follow a+later version.++  15. Disclaimer of Warranty.++  THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY+APPLICABLE LAW.  EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT+HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY+OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO,+THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR+PURPOSE.  THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM+IS WITH YOU.  SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF+ALL NECESSARY SERVICING, REPAIR OR CORRECTION.++  16. Limitation of Liability.++  IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING+WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MODIFIES AND/OR CONVEYS+THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY+GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE+USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED TO LOSS OF+DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD+PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS),+EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF+SUCH DAMAGES.++  17. Interpretation of Sections 15 and 16.++  If the disclaimer of warranty and limitation of liability provided+above cannot be given local legal effect according to their terms,+reviewing courts shall apply local law that most closely approximates+an absolute waiver of all civil liability in connection with the+Program, unless a warranty or assumption of liability accompanies a+copy of the Program in return for a fee.++                     END OF TERMS AND CONDITIONS++            How to Apply These Terms to Your New Programs++  If you develop a new program, and you want it to be of the greatest+possible use to the public, the best way to achieve this is to make it+free software which everyone can redistribute and change under these terms.++  To do so, attach the following notices to the program.  It is safest+to attach them to the start of each source file to most effectively+state the exclusion of warranty; and each file should have at least+the "copyright" line and a pointer to where the full notice is found.++    <one line to give the program's name and a brief idea of what it does.>+    Copyright (C) <year>  <name of author>++    This program is free software: you can redistribute it and/or modify+    it under the terms of the GNU General Public License as published by+    the Free Software Foundation, either version 3 of the License, or+    (at your option) any later version.++    This program is distributed in the hope that it will be useful,+    but WITHOUT ANY WARRANTY; without even the implied warranty of+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the+    GNU General Public License for more details.++    You should have received a copy of the GNU General Public License+    along with this program.  If not, see <https://www.gnu.org/licenses/>.++Also add information on how to contact you by electronic and paper mail.++  If the program does terminal interaction, make it output a short+notice like this when it starts in an interactive mode:++    <program>  Copyright (C) <year>  <name of author>+    This program comes with ABSOLUTELY NO WARRANTY; for details type `show w'.+    This is free software, and you are welcome to redistribute it+    under certain conditions; type `show c' for details.++The hypothetical commands `show w' and `show c' should show the appropriate+parts of the General Public License.  Of course, your program's commands+might be different; for a GUI interface, you would use an "about box".++  You should also get your employer (if you work as a programmer) or school,+if any, to sign a "copyright disclaimer" for the program, if necessary.+For more information on this, and how to apply and follow the GNU GPL, see+<https://www.gnu.org/licenses/>.++  The GNU General Public License does not permit incorporating your program+into proprietary programs.  If your program is a subroutine library, you+may consider it more useful to permit linking proprietary applications with+the library.  If this is what you want to do, use the GNU Lesser General+Public License instead of this License.  But first, please read+<https://www.gnu.org/licenses/why-not-lgpl.html>.

@@ -0,0 +1,173 @@+# dataframe-persistent++Persistent database integration for the Haskell DataFrame library.++## Overview++This package provides seamless integration between the `dataframe` library and the `persistent` database library, allowing you to:++- Load database entities directly into DataFrames+- Perform DataFrame operations on database data  +- Save DataFrame results back to the database+- Work with type-safe database entities++## Installation++Add to your `package.yaml`:++```yaml+dependencies:+- dataframe ^>= 0.3+- dataframe-persistent ^>= 0.1+- persistent >= 2.14+- persistent-sqlite >= 2.13  # or your preferred backend+```++Or to your `.cabal` file:++```cabal+build-depends:+  dataframe ^>= 0.3,+  dataframe-persistent ^>= 0.1,+  persistent >= 2.14,+  persistent-sqlite >= 2.13+```++## Quick Start++```haskell+{-# LANGUAGE DataKinds #-}+{-# LANGUAGE DerivingStrategies #-}+{-# LANGUAGE FlexibleInstances #-}+{-# LANGUAGE GADTs #-}+{-# LANGUAGE GeneralizedNewtypeDeriving #-}+{-# LANGUAGE MultiParamTypeClasses #-}+{-# LANGUAGE OverloadedStrings #-}+{-# LANGUAGE QuasiQuotes #-}+{-# LANGUAGE StandaloneDeriving #-}+{-# LANGUAGE TemplateHaskell #-}+{-# LANGUAGE TypeApplications #-}+{-# LANGUAGE TypeFamilies #-}+{-# LANGUAGE UndecidableInstances #-}++import Control.Monad.IO.Class (liftIO)+import Database.Persist+import Database.Persist.Sqlite+import Database.Persist.TH+import qualified DataFrame as DF+import qualified DataFrame.Functions as F+import DataFrame.IO.Persistent+import DataFrame.IO.Persistent.TH+import qualified Data.Vector as V++-- Define your entities+share [mkPersist sqlSettings, mkMigrate "migrateAll"] [persistLowerCase|+TestUser+    name Text+    age Int+    active Bool+    deriving Show Eq+|]++-- Derive DataFrame instances+$(derivePersistentDataFrame ''TestUser)++-- Example usage+main :: IO ()+main = runSqlite "example.db" $ do+    -- Run migrations+    runMigration migrateAll+    +    -- Insert some test data+    _ <- insert $ TestUser "Alice" 25 True+    _ <- insert $ TestUser "Bob" 30 False+    _ <- insert $ TestUser "Charlie" 35 True+    +    -- Load from database+    allUsersDF <- fromPersistent @TestUser []+    liftIO $ putStrLn $ "Loaded " ++ show (nRows allUsersDF) ++ " users"+    +    -- Load with filters+    activeUsersDF <- fromPersistent @TestUser [TestUserActive ==. True]+    liftIO $ putStrLn $ "Active users: " ++ show (nRows activeUsersDF)+    +    -- Process with DataFrame operations+    let youngUsers = DF.filter @Int "age" (< 30) allUsersDF+        ages = V.toList $ DF.columnAsVector @Int "age" youngUsers+    liftIO $ putStrLn $ "Young user ages: " ++ show ages+    +    -- Custom configuration+    let config = defaultPersistentConfig +                    { pcIdColumnName = "user_id"+                    , pcIncludeId = True+                    }+    customDF <- fromPersistentWith @TestUser config []+    liftIO $ putStrLn $ "Columns with custom config: " ++ show (DF.columnNames customDF)+```++## Features++- **Type-safe conversions** between Persistent entities and DataFrames+- **Template Haskell support** for automatic instance generation+- **Configurable loading** with batch size and column selection+- **Column name cleaning** - removes table prefixes automatically (e.g., `test_user_name` → `name`)+- **Type preservation** - maintains proper types for Text, Int, Bool, Day, etc.+- **Empty DataFrame support** - preserves column structure even with no data+- **Support for all Persistent backends** (SQLite, PostgreSQL, MySQL, etc.)++## Configuration Options++```haskell+data PersistentConfig = PersistentConfig+    { pcBatchSize :: Int        -- Number of records to fetch at once (default: 10000)+    , pcIncludeId :: Bool       -- Whether to include entity ID as column (default: True)+    , pcIdColumnName :: Text    -- Name for the ID column (default: "id")+    }+```++## Advanced Usage++### Custom Field Extraction++You can also extract fields from individual entities:++```haskell+let user = TestUser "Alice" 25 True+    columns = persistFieldsToColumns user+-- Result: [("name", SomeColumn ["Alice"]), ("age", SomeColumn [25]), ("active", SomeColumn [True])]+```++### Working with Vector Data++```haskell+-- Extract specific column data+let names = V.toList $ DF.columnAsVector @Text "name" df+    ages = V.toList $ DF.columnAsVector @Int "age" df+    activeFlags = V.toList $ DF.columnAsVector @Bool "active" df+```++## Examples++For comprehensive examples and test cases, see:+- [`tests/PersistentTests.hs`](tests/PersistentTests.hs) - Full test suite with examples+- [`../docs/persistent_integration.md`](../docs/persistent_integration.md) - Detailed integration guide++## Status++This package is **actively maintained** and tested. Current test coverage includes:+- ✅ Entity loading with and without filters+- ✅ Custom configuration options+- ✅ DataFrame operations on Persistent data+- ✅ Empty result set handling+- ✅ Field extraction utilities+- ✅ Multi-table relationships++## Documentation++For detailed documentation, see:+- [Main dataframe documentation](https://github.com/mchav/dataframe)+- [Persistent integration guide](../docs/persistent_integration.md)++## License++GPL-3.0-or-later (same as the main dataframe package)

@@ -0,0 +1,72 @@+cabal-version:      2.4+name:               dataframe-persistent+version:            0.1.0.0++synopsis: Persistent database integration for the dataframe library++description: This package provides integration between the dataframe library and the Persistent database library, allowing you to load database entities into DataFrames and save DataFrames back to the database.++bug-reports: https://github.com/mchav/dataframe/issues+license:            GPL-3.0-or-later+license-file:       ./LICENSE+author:             Michael Chavinda, Junji Hashimoto+maintainer:         mschavinda@gmail.com++copyright: (c) 2024-2025 Michael Chavinda+category: Data, Database+tested-with: GHC ==9.4.8 || ==9.6.7 || ==9.8.4 || ==9.10.3 || ==9.12.2+extra-doc-files: ./CHANGELOG.md ./README.md++source-repository head+  type:     git+  location: https://github.com/mchav/dataframe++common warnings+    ghc-options:+        -Wincomplete-patterns+        -Wincomplete-uni-patterns+        -Wunused-imports+        -Wunused-packages+        -Wunused-local-binds++library+    import: warnings+    default-extensions: Strict+    exposed-modules: DataFrame.IO.Persistent,+                    DataFrame.IO.Persistent.TH+    build-depends:    base >= 4 && <5,+                      bytestring >= 0.11 && < 0.13,+                      containers >= 0.6.7 && < 0.9,+                      dataframe ^>= 0.3,+                      persistent >= 2.14 && < 3,+                      template-haskell >= 2.0 && < 3,+                      text >= 2.0 && < 3,+                      time >= 1.12 && < 2,+                      transformers >= 0.5 && < 0.7,+                      vector ^>= 0.13+    hs-source-dirs:   src+    default-language: Haskell2010++test-suite dataframe-persistent-tests+    import: warnings+    type: exitcode-stdio-1.0+    main-is: Main.hs+    other-modules: PersistentTests+    build-depends:  base >= 4 && < 5,+                    dataframe ^>= 0.3,+                    dataframe-persistent,+                    -- directory >= 1.3.0.0 && < 2,+                    HUnit ^>= 1.6,+                    monad-logger >= 0.3 && < 0.4,+                    persistent >= 2.14 && < 3,+                    persistent-sqlite >= 2.13 && < 3,+                    -- persistent-template >= 2.12 && < 3,+                    resourcet >= 0.1 && < 2,+                    temporary >= 1.3 && < 2,+                    text >= 2.0 && < 3,+                    time >= 1.12 && < 2,+                    transformers >= 0.5 && < 0.7,+                    vector ^>= 0.13,+                    -- unliftio-core >= 0.2 && < 0.3+    hs-source-dirs: tests+    default-language: Haskell2010

@@ -0,0 +1,275 @@+{-# LANGUAGE AllowAmbiguousTypes #-}+{-# LANGUAGE BangPatterns #-}+{-# LANGUAGE ConstraintKinds #-}+{-# LANGUAGE DataKinds #-}+{-# LANGUAGE ExistentialQuantification #-}+{-# LANGUAGE FlexibleContexts #-}+{-# LANGUAGE FlexibleInstances #-}+{-# LANGUAGE GADTs #-}+{-# LANGUAGE MultiParamTypeClasses #-}+{-# LANGUAGE OverloadedStrings #-}+{-# LANGUAGE RankNTypes #-}+{-# LANGUAGE ScopedTypeVariables #-}+{-# LANGUAGE TypeApplications #-}+{-# LANGUAGE TypeFamilies #-}+{-# LANGUAGE TypeOperators #-}+{-# LANGUAGE UndecidableInstances #-}++module DataFrame.IO.Persistent (+    -- * Main functions+    fromPersistent,+    fromPersistentWith,+    toPersistent,++    -- * Configuration+    PersistentConfig (..),+    defaultPersistentConfig,++    -- * Type classes+    EntityToDataFrame (..),+    DataFrameToEntity (..),++    -- * Helper types+    SomeColumn (..),++    -- * Utilities+    entityToColumns,+    columnsToEntity,+    persistFieldsToColumns,+    nRows,+) where++import Control.Monad (forM)+import Control.Monad.IO.Class (MonadIO, liftIO)+import Control.Monad.Trans.Reader (ReaderT)+import Data.ByteString (ByteString)+import qualified Data.Map.Strict as M+import Data.Proxy (Proxy (..))+import Data.Text (Text)+import qualified Data.Text as T+import Data.Time (Day, TimeOfDay, UTCTime)+import qualified Data.Vector as V+import qualified DataFrame.Internal.Column as DFCol+import DataFrame.Internal.DataFrame (DataFrame (..))+import qualified DataFrame.Internal.DataFrame as DF+import Database.Persist+import Database.Persist.Sql hiding (Column)+import Database.Persist.Types (fieldHaskell, getEntityFields, unFieldNameHS)+import Unsafe.Coerce (unsafeCoerce)++-- | Get number of rows in a DataFrame+nRows :: DataFrame -> Int+nRows df = fst (DF.dataframeDimensions df)++-- | Configuration for Persistent DataFrame operations+data PersistentConfig = PersistentConfig+    { pcBatchSize :: Int+    -- ^ Number of records to fetch at once (default: 10000)+    , pcIncludeId :: Bool+    -- ^ Whether to include the entity ID as a column (default: True)+    , pcIdColumnName :: Text+    -- ^ Name for the ID column (default: "id")+    }++-- | Default configuration+defaultPersistentConfig :: PersistentConfig+defaultPersistentConfig =+    PersistentConfig+        { pcBatchSize = 10000+        , pcIncludeId = True+        , pcIdColumnName = "id"+        }++-- | Type class for converting Persistent entities to DataFrame columns+class (PersistEntity record) => EntityToDataFrame record where+    -- | Get column names for the entity+    entityColumnNames :: Proxy record -> [Text]++    -- | Convert entity fields to column data+    entityToColumnData :: Entity record -> [(Text, SomeColumn)]++-- | Type class for converting DataFrame rows back to Persistent entities+class (PersistEntity record) => DataFrameToEntity record where+    -- | Convert a row from DataFrame to entity+    rowToEntity :: Int -> DataFrame -> Either String (Entity record)++-- | Helper type for heterogeneous column data+data SomeColumn = forall a. (DFCol.Columnable a) => SomeColumn (V.Vector a)++-- | Read entities from database into a DataFrame+fromPersistent ::+    forall record m.+    ( MonadIO m+    , PersistEntity record+    , PersistEntityBackend record ~ SqlBackend+    , EntityToDataFrame record+    , Show record+    ) =>+    [Filter record] ->+    ReaderT SqlBackend m DataFrame+fromPersistent = fromPersistentWith @record defaultPersistentConfig++-- | Read entities from database into a DataFrame with custom config+fromPersistentWith ::+    forall record m.+    ( MonadIO m+    , PersistEntity record+    , PersistEntityBackend record ~ SqlBackend+    , EntityToDataFrame record+    , Show record+    ) =>+    PersistentConfig ->+    [Filter record] ->+    ReaderT SqlBackend m DataFrame+fromPersistentWith config filters = do+    entities <- selectList filters []+    liftIO $ entitiesToDataFrame @record config entities++-- | Convert entities to DataFrame+entitiesToDataFrame ::+    forall record.+    (PersistEntity record, EntityToDataFrame record, Show record) =>+    PersistentConfig ->+    [Entity record] ->+    IO DataFrame+entitiesToDataFrame config entities = do+    let proxy = Proxy @record+        baseColNames = entityColumnNames proxy+        colNames =+            if pcIncludeId config+                then pcIdColumnName config : baseColNames+                else baseColNames++    if null entities+        then do+            -- Create empty dataframe with proper column structure+            let indices = M.fromList $ zip colNames [0 ..]+                numCols = length colNames+                dimensions = (0, numCols)+                emptyColumns = replicate numCols (DFCol.fromList ([] :: [Text]))+            return $ DataFrame (V.fromList emptyColumns) indices dimensions+        else do+            -- Create columns from entity data+            columns <- createColumnsFromEntities @record config entities+            let indices = M.fromList $ zip colNames [0 ..]+                numRows = if null entities then 0 else length entities+                numCols = length colNames+                dimensions = (numRows, numCols)+            return $ DataFrame (V.fromList columns) indices dimensions++-- | Create columns from entities+createColumnsFromEntities ::+    forall record.+    (PersistEntity record, EntityToDataFrame record, Show record) =>+    PersistentConfig ->+    [Entity record] ->+    IO [DFCol.Column]+createColumnsFromEntities config entities = do+    -- Get column data for all entities+    let allColumnData = map entityToColumnData entities++    -- Determine column names (with or without ID)+    let proxy = Proxy @record+        baseColNames = entityColumnNames proxy+        allColNames =+            if pcIncludeId config+                then pcIdColumnName config : baseColNames+                else baseColNames++    -- For each column name, collect and combine data from all entities+    let columns = map (createColumnFromEntityData allColumnData) allColNames+    return columns++-- | Create a single column by extracting and combining data for a specific column name+createColumnFromEntityData :: [[(Text, SomeColumn)]] -> Text -> DFCol.Column+createColumnFromEntityData allEntityData colName =+    -- Find all matching columns for this name+    case [ someCol+         | entityData <- allEntityData+         , (name, someCol) <- entityData+         , name == colName+         ] of+        [] -> DFCol.fromList ([] :: [Text]) -- Empty column+        allSomeColumns ->+            -- Extract and concatenate vectors from SomeColumn wrappers+            concatSomeColumns allSomeColumns++-- | Helper to concatenate SomeColumn values into a single Column+concatSomeColumns :: [SomeColumn] -> DFCol.Column+concatSomeColumns [] = DFCol.fromList ([] :: [Text])+concatSomeColumns (SomeColumn (firstVec :: V.Vector a) : rest) =+    -- Since all columns for a given field should have the same type,+    -- we can safely extract and concatenate them+    let vectors = firstVec : map extractSameType rest+        extractSameType (SomeColumn v) = unsafeCoerce v :: V.Vector a+        combined = V.concat vectors+     in DFCol.fromVector combined++-- | Write DataFrame to database as entities+toPersistent ::+    ( MonadIO m+    , PersistEntity record+    , PersistEntityBackend record ~ SqlBackend+    , DataFrameToEntity record+    , SafeToInsert record+    ) =>+    DataFrame ->+    ReaderT SqlBackend m [Key record]+toPersistent df = do+    let rowCount = nRows df+    keys <- forM [0 .. rowCount - 1] $ \i -> do+        case rowToEntity i df of+            Left err -> error $ "Failed to convert row " <> show i <> ": " <> err+            Right entity -> insert (entityVal entity)+    return keys++-- | Convert entity fields to columns (helper for implementations)+entityToColumns ::+    (PersistEntity record, ToBackendKey SqlBackend record) =>+    Entity record ->+    [(Text, SomeColumn)]+entityToColumns (Entity key val) =+    [("id", SomeColumn (V.singleton $ fromSqlKey key))]++-- | Convert persistent fields to columns+persistFieldsToColumns ::+    (PersistEntity record) => record -> [(Text, SomeColumn)]+persistFieldsToColumns record =+    let persistValues = toPersistFields record+        -- Get entity definition using proxy - pass the record value to get the correct type+        fieldNames =+            map (unFieldNameHS . fieldHaskell) $ getEntityFields $ entityDef (Just record)+        fieldPairs = zip fieldNames persistValues+     in map persistValueToColumn fieldPairs+  where+    persistValueToColumn :: (Text, PersistValue) -> (Text, SomeColumn)+    persistValueToColumn (name, pval) = (name, persistValueToSomeColumn pval)++-- | Convert a PersistValue to SomeColumn+persistValueToSomeColumn :: PersistValue -> SomeColumn+persistValueToSomeColumn pval = case pval of+    PersistText t -> SomeColumn (V.singleton t)+    PersistByteString bs -> SomeColumn (V.singleton bs)+    PersistInt64 i -> SomeColumn (V.singleton (fromIntegral i :: Int))+    PersistDouble d -> SomeColumn (V.singleton d)+    PersistRational r -> SomeColumn (V.singleton (fromRational r :: Double))+    PersistBool b -> SomeColumn (V.singleton b)+    PersistDay d -> SomeColumn (V.singleton d)+    PersistTimeOfDay tod -> SomeColumn (V.singleton tod)+    PersistUTCTime utc -> SomeColumn (V.singleton utc)+    PersistNull -> SomeColumn (V.singleton ("" :: Text)) -- Handle nulls as empty text+    PersistList vals -> SomeColumn (V.singleton (T.pack $ show vals)) -- Convert list to string representation+    PersistMap m -> SomeColumn (V.singleton (T.pack $ show m)) -- Convert map to string representation+    PersistObjectId oid -> SomeColumn (V.singleton (T.pack $ show oid)) -- Convert ObjectId to string+    PersistArray vals -> SomeColumn (V.singleton (T.pack $ show vals)) -- Convert array to string representation+    PersistLiteral_ _ bs -> SomeColumn (V.singleton bs) -- Use the raw bytes++-- | Convert columns back to entity (helper for implementations)+columnsToEntity ::+    (PersistEntity record) =>+    Int ->+    DataFrame ->+    Either String (Entity record)+columnsToEntity rowIdx df =+    -- This would need to be implemented per entity type+    Left "Not implemented: entity-specific conversion required"

@@ -0,0 +1,182 @@+{-# LANGUAGE FlexibleInstances #-}+{-# LANGUAGE LambdaCase #-}+{-# LANGUAGE MultiParamTypeClasses #-}+{-# LANGUAGE OverloadedStrings #-}+{-# LANGUAGE RecordWildCards #-}+{-# LANGUAGE ScopedTypeVariables #-}+{-# LANGUAGE TemplateHaskell #-}+{-# LANGUAGE TypeApplications #-}++module DataFrame.IO.Persistent.TH (+    -- * Template Haskell derivation+    deriveEntityToDataFrame,+    deriveDataFrameToEntity,+    derivePersistentDataFrame,+) where++import Control.Monad (forM, when)+import Data.List (foldl')+import Data.Text (Text)+import qualified Data.Text as T+import qualified Data.Vector as V+import DataFrame.IO.Persistent+import qualified DataFrame.Internal.Column as DFCol+import Database.Persist+import Database.Persist.Sql (fromSqlKey)+import Database.Persist.TH+import Language.Haskell.TH+import Language.Haskell.TH.Syntax (Lift, lift)++-- | Derive EntityToDataFrame instance using Template Haskell+deriveEntityToDataFrame :: Name -> Q [Dec]+deriveEntityToDataFrame entityName = do+    info <- reify entityName+    case info of+        TyConI (DataD _ _ _ _ [RecC conName fields] _) -> do+            -- Extract field names and remove entity prefix+            let entityNameStr = nameBase entityName+                entityPrefix = camelToSnake entityNameStr ++ "_"+                fieldNames = [nameBase fname | (fname, _, _) <- fields]+                -- Remove the entity prefix from field names+                cleanFieldNames = map (removePrefix entityPrefix . camelToSnake) fieldNames+                textFieldNames = map T.pack cleanFieldNames++            -- Generate entityColumnNames implementation+            colNamesImpl <- [|$(lift textFieldNames)|]+            let colNamesMethod =+                    FunD+                        'entityColumnNames+                        [Clause [WildP] (NormalB colNamesImpl) []]++            -- Generate entityToColumnData implementation+            entityDataLambda <- generateEntityToColumnData conName fields cleanFieldNames+            let entityVar = mkName "entity"+                entityDataImpl = AppE entityDataLambda (VarE entityVar)+                entityDataMethod =+                    FunD+                        'entityToColumnData+                        [Clause [VarP entityVar] (NormalB entityDataImpl) []]++            -- Create instance+            let instanceDec =+                    InstanceD+                        Nothing+                        []+                        (AppT (ConT ''EntityToDataFrame) (ConT entityName))+                        [colNamesMethod, entityDataMethod]++            return [instanceDec]+        _ ->+            fail $+                "deriveEntityToDataFrame: " ++ show entityName ++ " must be a record type"++-- | Remove prefix from a string+removePrefix :: String -> String -> String+removePrefix prefix str+    | take (length prefix) str == prefix = drop (length prefix) str+    | otherwise = str++-- | Generate the entityToColumnData expression+generateEntityToColumnData :: Name -> [(Name, Bang, Type)] -> [String] -> Q Exp+generateEntityToColumnData conName fields cleanFieldNames = do+    entityVar <- newName "entity"+    keyVar <- newName "key"+    valVar <- newName "val"++    -- Pattern to destructure Entity+    let entityPat = ConP 'Entity [] [VarP keyVar, VarP valVar]++    -- Generate field extractors+    fieldExprs <-+        mapM (generateFieldExtractor valVar) (zip3 fields cleanFieldNames [0 ..])++    -- Build the final list expression with ID column if needed+    let idExpr =+            TupE+                [ Just (LitE (StringL "id"))+                , Just+                    ( AppE+                        (ConE 'SomeColumn)+                        ( AppE+                            (VarE 'V.singleton)+                            (VarE keyVar)+                        )+                    )+                ]+        allExprs = idExpr : fieldExprs++    -- Return lambda that pattern matches on Entity+    return $ LamE [entityPat] (ListE allExprs)++-- | Generate field extractor for a single field+generateFieldExtractor :: Name -> ((Name, Bang, Type), String, Int) -> Q Exp+generateFieldExtractor valVar ((fieldName, _, fieldType), cleanName, idx) = do+    let accessor = mkName (nameBase fieldName)+        value = AppE (VarE accessor) (VarE valVar)++    -- Wrap the value in SomeColumn after converting to vector+    return $+        TupE+            [ Just (LitE (StringL cleanName))+            , Just+                ( AppE+                    (ConE 'SomeColumn)+                    (AppE (VarE 'V.singleton) value)+                )+            ]++-- | Derive DataFrameToEntity instance+deriveDataFrameToEntity :: Name -> Q [Dec]+deriveDataFrameToEntity entityName = do+    info <- reify entityName+    case info of+        TyConI (DataD _ _ _ _ [RecC conName fields] _) -> do+            -- Generate rowToEntity implementation+            rowToEntityImpl <- generateRowToEntity conName fields+            let rowToEntityMethod =+                    FunD+                        'rowToEntity+                        [ Clause+                            [VarP (mkName "idx"), VarP (mkName "df")]+                            (NormalB rowToEntityImpl)+                            []+                        ]++            -- Create instance+            let instanceDec =+                    InstanceD+                        Nothing+                        []+                        (AppT (ConT ''DataFrameToEntity) (ConT entityName))+                        [rowToEntityMethod]++            return [instanceDec]+        _ ->+            fail $+                "deriveDataFrameToEntity: " ++ show entityName ++ " must be a record type"++-- | Generate the rowToEntity expression+generateRowToEntity :: Name -> [(Name, Bang, Type)] -> Q Exp+generateRowToEntity conName fields = do+    -- This is a simplified implementation+    -- In practice, you'd need to extract values from the DataFrame+    [|Left "Auto-generated rowToEntity not fully implemented"|]++-- | Derive both instances at once+derivePersistentDataFrame :: Name -> Q [Dec]+derivePersistentDataFrame name = do+    entityDecs <- deriveEntityToDataFrame name+    dfDecs <- deriveDataFrameToEntity name+    return (entityDecs ++ dfDecs)++-- | Convert camelCase to snake_case+camelToSnake :: String -> String+camelToSnake [] = []+camelToSnake (c : cs) = toLower c : go cs+  where+    go [] = []+    go (c : cs)+        | isUpper c = '_' : toLower c : go cs+        | otherwise = c : go cs+    isUpper c = c >= 'A' && c <= 'Z'+    toLower c = if isUpper c then toEnum (fromEnum c + 32) else c

@@ -0,0 +1,14 @@+module Main where++import qualified System.Exit as Exit++import PersistentTests++import Test.HUnit++main :: IO ()+main = do+    result <- runTestTT persistentTests+    if failures result > 0 || errors result > 0+        then Exit.exitFailure+        else Exit.exitSuccess

@@ -0,0 +1,291 @@+{-# LANGUAGE DataKinds #-}+{-# LANGUAGE DerivingStrategies #-}+{-# LANGUAGE EmptyDataDecls #-}+{-# LANGUAGE FlexibleContexts #-}+{-# LANGUAGE FlexibleInstances #-}+{-# LANGUAGE GADTs #-}+{-# LANGUAGE GeneralizedNewtypeDeriving #-}+{-# LANGUAGE MultiParamTypeClasses #-}+{-# LANGUAGE OverloadedStrings #-}+{-# LANGUAGE QuasiQuotes #-}+{-# LANGUAGE ScopedTypeVariables #-}+{-# LANGUAGE StandaloneDeriving #-}+{-# LANGUAGE TemplateHaskell #-}+{-# LANGUAGE TypeApplications #-}+{-# LANGUAGE TypeFamilies #-}+{-# LANGUAGE UndecidableInstances #-}++module PersistentTests where++import Control.Monad.IO.Class (liftIO)+import Control.Monad.Logger (NoLoggingT)+import Control.Monad.Trans.Reader (ReaderT)+import Data.Text (Text)+import qualified Data.Text as T+import Data.Time+import qualified Data.Vector as V+import qualified DataFrame as DF+import qualified DataFrame.Functions as F+import DataFrame.IO.Persistent+import DataFrame.IO.Persistent.TH+import Database.Persist+import Database.Persist.Sqlite+import Database.Persist.TH+import System.IO (hClose)+import System.IO.Temp (withSystemTempFile)+import Test.HUnit+import UnliftIO.Resource (ResourceT)++-- Define test entities+share+    [mkPersist sqlSettings, mkMigrate "migrateAll"]+    [persistLowerCase|+TestUser+    name Text+    age Int+    active Bool+    deriving Show Eq++TestOrder  +    userId TestUserId+    amount Double+    status Text+    orderDate Day+    deriving Show Eq+|]++share+    [mkPersist sqlSettings]+    [persistLowerCase|+Artist sql=artists+    Id sql=ArtistId Int64+    name Text sql=Name+    deriving Show Eq+|]++-- Derive DataFrame instances+$(derivePersistentDataFrame ''TestUser)+$(derivePersistentDataFrame ''TestOrder)+$(derivePersistentDataFrame ''Artist)++-- Test fixture data+testUsers :: [TestUser]+testUsers =+    [ TestUser "Alice" 25 True+    , TestUser "Bob" 30 False+    , TestUser "Charlie" 35 True+    , TestUser "Diana" 28 True+    ]++-- Helper to run tests with temp database+withTestDb :: ReaderT SqlBackend (NoLoggingT (ResourceT IO)) a -> IO a+withTestDb action = withSystemTempFile "test.db" $ \dbPath handle -> do+    -- Close the handle as we'll let sqlite manage it+    hClose handle+    runSqlite (T.pack dbPath) $ do+        runMigration migrateAll+        action++-- Test loading entities to DataFrame+testFromPersistent :: Test+testFromPersistent = TestCase $ withTestDb $ do+    -- Insert test data+    userIds <- mapM insert testUsers++    -- Load all users+    df <- fromPersistent @TestUser []+    liftIO $ do+        -- Check row count+        assertEqual "Row count" 4 (nRows df)++        -- Check columns exist+        let cols = DF.columnNames df+        print cols+        assertBool "Has id column" ("id" `elem` cols)+        assertBool "Has name column" ("name" `elem` cols)+        assertBool "Has age column" ("age" `elem` cols)+        assertBool "Has active column" ("active" `elem` cols)++        -- Check data values+        let names = V.toList (DF.columnAsVector @Text "name" df)++        assertEqual "Names match" ["Alice", "Bob", "Charlie", "Diana"] names++testChinookFromPersistent :: Test+testChinookFromPersistent = TestCase $ do+    let dbPath = "./data/chinook.db"+    runSqlite (T.pack dbPath) $ do+        -- No migration necessary since the table already exists.+        df <- fromPersistent @Artist []+        liftIO $ do+            assertEqual "Row count" 275 (nRows df)+            let cols = DF.columnNames df+            print cols+            assertBool "Has id column" ("id" `elem` cols)+            assertBool "Has name column" ("name" `elem` cols)+            let names = V.toList (DF.columnAsVector @Text "name" (DF.take 5 df))++            assertEqual+                "Names match"+                ["AC/DC", "Accept", "Aerosmith", "Alanis Morissette", "Alice In Chains"]+                names++-- Test loading with filters+testFromPersistentWithFilters :: Test+testFromPersistentWithFilters = TestCase $ withTestDb $ do+    -- Insert test data+    mapM_ insert testUsers++    -- Load active users only+    df <- fromPersistent @TestUser [TestUserActive ==. True]+    liftIO $ do+        assertEqual "Active users count" 3 (nRows df)++        -- Check all loaded users are active+        let activeFlags = V.toList $ DF.columnAsVector @Bool "active" df+        assertBool "All active" (and activeFlags)++-- Test custom configuration+testCustomConfig :: Test+testCustomConfig = TestCase $ withTestDb $ do+    -- Insert test data+    mapM_ insert testUsers++    -- Load with custom config+    let config =+            defaultPersistentConfig+                { pcIdColumnName = "user_id"+                , pcBatchSize = 2+                }+    df <- fromPersistentWith @TestUser config []+    liftIO $ do+        -- Check custom ID column name+        let cols = DF.columnNames df+        print cols+        assertBool "Has custom id column" ("user_id" `elem` cols)+        assertBool "No default id column" ("id" `notElem` cols)++-- Test without ID column+testWithoutIdColumn :: Test+testWithoutIdColumn = TestCase $ withTestDb $ do+    -- Insert test data+    mapM_ insert testUsers++    -- Load without ID column+    let config = defaultPersistentConfig{pcIncludeId = False}+    df <- fromPersistentWith @TestUser config []+    liftIO $ do+        -- Check no ID column+        let cols = DF.columnNames df+        assertBool "No id column" ("id" `notElem` cols)+        assertEqual "Column count" 3 (length cols)++-- Test DataFrame operations on Persistent data+testDataFrameOperations :: Test+testDataFrameOperations = TestCase $ withTestDb $ do+    -- Insert test data+    mapM_ insert testUsers++    -- Load and perform operations+    df <- fromPersistent @TestUser []+    liftIO $ do+        -- Filter operation+        let youngUsers = DF.filter @Int "age" (< 30) df+        assertEqual "Young users count" 2 (nRows youngUsers)++        -- Sort operation+        let sorted = DF.sortBy DF.Ascending ["age"] df+        let ages = V.toList $ DF.columnAsVector @Int "age" sorted+        assertEqual "Ages sorted" [25, 28, 30, 35] ages++        -- Derive column+        let withAgeGroup =+                DF.derive+                    "age_group"+                    ( F.ifThenElse+                        (F.col @Int "age" `F.lt` F.lit 30)+                        (F.lit @Text "young")+                        (F.lit @Text "adult")+                    )+                    df+        assertEqual "Has age_group column" 5 (length $ DF.columnNames withAgeGroup)++-- Test with relationships+testWithRelationships :: Test+testWithRelationships = TestCase $ withTestDb $ do+    -- Insert users and orders+    userId1 <- insert $ TestUser "Alice" 25 True+    userId2 <- insert $ TestUser "Bob" 30 False++    let today = fromGregorian 2024 3 20+    orderId1 <- insert $ TestOrder userId1 100.50 "completed" today+    orderId2 <- insert $ TestOrder userId1 50.25 "pending" (addDays 1 today)+    orderId3 <- insert $ TestOrder userId2 200.00 "completed" (addDays 2 today)++    -- Load orders+    ordersDF <- fromPersistent @TestOrder []+    liftIO $ assertEqual "Order count" 3 (nRows ordersDF)++    -- Load users+    usersDF <- fromPersistent @TestUser []++    -- TODO: Add join operations when available+    liftIO $ assertEqual "User count" 2 (nRows usersDF)++-- Test empty result set+testEmptyResultSet :: Test+testEmptyResultSet = TestCase $ withTestDb $ do+    -- Don't insert any data+    df <- fromPersistent @TestUser []+    liftIO $ do+        assertEqual "Empty DataFrame" 0 (nRows df)+        -- Should still have column names+        let cols = DF.columnNames df+        assertBool "Has columns" (length cols > 0)++-- Test persistFieldsToColumns function+testPersistFieldsToColumns :: Test+testPersistFieldsToColumns = TestCase $ do+    let testUser = TestUser "Alice" 30 True+        columns = persistFieldsToColumns testUser++    -- Check that we got the expected number of columns (3 fields)+    assertEqual "Column count" 3 (length columns)++    -- Check column names+    let columnNames = map fst columns+    assertBool "Has name column" ("name" `elem` columnNames)+    assertBool "Has age column" ("age" `elem` columnNames)+    assertBool "Has active column" ("active" `elem` columnNames)++    -- Check that each column has exactly one value (since we're testing a single record)+    let nameCol = lookup "name" columns+        ageCol = lookup "age" columns+        activeCol = lookup "active" columns++    case nameCol of+        Just (SomeColumn vec) -> assertEqual "Name vector length" 1 (V.length vec)+        Nothing -> assertFailure "Name column not found"++    case ageCol of+        Just (SomeColumn vec) -> assertEqual "Age vector length" 1 (V.length vec)+        Nothing -> assertFailure "Age column not found"++    case activeCol of+        Just (SomeColumn vec) -> assertEqual "Active vector length" 1 (V.length vec)+        Nothing -> assertFailure "Active column not found"++-- All tests+persistentTests :: Test+persistentTests =+    TestList+        [ TestLabel "Load entities to DataFrame" testFromPersistent+        , TestLabel "Load with filters" testFromPersistentWithFilters+        , TestLabel "Custom configuration" testCustomConfig+        , TestLabel "Without ID column" testWithoutIdColumn+        , TestLabel "DataFrame operations" testDataFrameOperations+        , TestLabel "With relationships" testWithRelationships+        , TestLabel "Empty result set" testEmptyResultSet+        , TestLabel "Test persistFieldsToColumns" testPersistFieldsToColumns+        , TestLabel "Chinook: Reads first 10 rows" testChinookFromPersistent+        ]