HDBC 2.2.7.0 → 2.4.0.5
raw patch · 20 files changed
Files
- CHANGELOG.md +20/−0
- COPYING +0/−510
- COPYRIGHT +0/−18
- Database/HDBC.hs +9/−65
- Database/HDBC/ColTypes.hs +6/−41
- Database/HDBC/DriverUtils.hs +1/−19
- Database/HDBC/Locale.hs +18/−1
- Database/HDBC/SqlValue.hs +55/−39
- Database/HDBC/Statement.hs +2/−6
- Database/HDBC/Types.hs +3/−20
- Database/HDBC/Utils.hs +5/−23
- HDBC.cabal +35/−31
- LICENSE +27/−0
- Makefile +0/−15
- Memory.txt +0/−24
- README.md +33/−0
- README.txt +0/−39
- testsrc/TestInfrastructure.hs +0/−17
- testsrc/TestSqlValue.hs +21/−12
- testsrc/runtests.hs +3/−8
+ CHANGELOG.md view
@@ -0,0 +1,20 @@+# Changelog++#### 2.4.0.4++* Zero-prefix years when parsing dates.++#### 2.4.0.3++* Compatibility with GHC 8.8/time 1.9++#### 2.4.0.2++* Compatibility with GHC 8.2/time 1.8++#### 2.4.0.1++* Compatibility with time 1.5.+* Minor documentation fixes.++
− COPYING
@@ -1,510 +0,0 @@-- GNU LESSER GENERAL PUBLIC LICENSE- Version 2.1, February 1999-- Copyright (C) 1991, 1999 Free Software Foundation, Inc.- 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA- Everyone is permitted to copy and distribute verbatim copies- of this license document, but changing it is not allowed.--[This is the first released version of the Lesser GPL. It also counts- as the successor of the GNU Library Public License, version 2, hence- the version number 2.1.]-- Preamble-- The licenses for most software are designed to take away your-freedom to share and change it. By contrast, the GNU General Public-Licenses are intended to guarantee your freedom to share and change-free software--to make sure the software is free for all its users.-- This license, the Lesser General Public License, applies to some-specially designated software packages--typically libraries--of the-Free Software Foundation and other authors who decide to use it. You-can use it too, but we suggest you first think carefully about whether-this license or the ordinary General Public License is the better-strategy to use in any particular case, based on the explanations-below.-- When we speak of free software, we are referring to freedom of use,-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 this service if you wish); that you receive source code or can get-it if you want it; that you can change the software and use pieces of-it in new free programs; and that you are informed that you can do-these things.-- To protect your rights, we need to make restrictions that forbid-distributors to deny you these rights or to ask you to surrender these-rights. These restrictions translate to certain responsibilities for-you if you distribute copies of the library or if you modify it.-- For example, if you distribute copies of the library, whether gratis-or for a fee, you must give the recipients all the rights that we gave-you. You must make sure that they, too, receive or can get the source-code. If you link other code with the library, you must provide-complete object files to the recipients, so that they can relink them-with the library after making changes to the library and recompiling-it. And you must show them these terms so they know their rights.-- We protect your rights with a two-step method: (1) we copyright the-library, and (2) we offer you this license, which gives you legal-permission to copy, distribute and/or modify the library.-- To protect each distributor, we want to make it very clear that-there is no warranty for the free library. Also, if the library is-modified by someone else and passed on, the recipients should know-that what they have is not the original version, so that the original-author's reputation will not be affected by problems that might be-introduced by others.-- Finally, software patents pose a constant threat to the existence of-any free program. We wish to make sure that a company cannot-effectively restrict the users of a free program by obtaining a-restrictive license from a patent holder. Therefore, we insist that-any patent license obtained for a version of the library must be-consistent with the full freedom of use specified in this license.-- Most GNU software, including some libraries, is covered by the-ordinary GNU General Public License. This license, the GNU Lesser-General Public License, applies to certain designated libraries, and-is quite different from the ordinary General Public License. We use-this license for certain libraries in order to permit linking those-libraries into non-free programs.-- When a program is linked with a library, whether statically or using-a shared library, the combination of the two is legally speaking a-combined work, a derivative of the original library. The ordinary-General Public License therefore permits such linking only if the-entire combination fits its criteria of freedom. The Lesser General-Public License permits more lax criteria for linking other code with-the library.-- We call this license the "Lesser" General Public License because it-does Less to protect the user's freedom than the ordinary General-Public License. It also provides other free software developers Less-of an advantage over competing non-free programs. These disadvantages-are the reason we use the ordinary General Public License for many-libraries. However, the Lesser license provides advantages in certain-special circumstances.-- For example, on rare occasions, there may be a special need to-encourage the widest possible use of a certain library, so that it-becomes a de-facto standard. To achieve this, non-free programs must-be allowed to use the library. A more frequent case is that a free-library does the same job as widely used non-free libraries. In this-case, there is little to gain by limiting the free library to free-software only, so we use the Lesser General Public License.-- In other cases, permission to use a particular library in non-free-programs enables a greater number of people to use a large body of-free software. For example, permission to use the GNU C Library in-non-free programs enables many more people to use the whole GNU-operating system, as well as its variant, the GNU/Linux operating-system.-- Although the Lesser General Public License is Less protective of the-users' freedom, it does ensure that the user of a program that is-linked with the Library has the freedom and the wherewithal to run-that program using a modified version of the Library.-- The precise terms and conditions for copying, distribution and-modification follow. Pay close attention to the difference between a-"work based on the library" and a "work that uses the library". The-former contains code derived from the library, whereas the latter must-be combined with the library in order to run.-- GNU LESSER GENERAL PUBLIC LICENSE- TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION-- 0. This License Agreement applies to any software library or other-program which contains a notice placed by the copyright holder or-other authorized party saying it may be distributed under the terms of-this Lesser General Public License (also called "this License").-Each licensee is addressed as "you".-- A "library" means a collection of software functions and/or data-prepared so as to be conveniently linked with application programs-(which use some of those functions and data) to form executables.-- The "Library", below, refers to any such software library or work-which has been distributed under these terms. A "work based on the-Library" means either the Library or any derivative work under-copyright law: that is to say, a work containing the Library or a-portion of it, either verbatim or with modifications and/or translated-straightforwardly into another language. (Hereinafter, translation is-included without limitation in the term "modification".)-- "Source code" for a work means the preferred form of the work for-making modifications to it. For a library, complete source code means-all the source code for all modules it contains, plus any associated-interface definition files, plus the scripts used to control-compilation and installation of the library.-- Activities other than copying, distribution and modification are not-covered by this License; they are outside its scope. The act of-running a program using the Library is not restricted, and output from-such a program is covered only if its contents constitute a work based-on the Library (independent of the use of the Library in a tool for-writing it). Whether that is true depends on what the Library does-and what the program that uses the Library does.-- 1. You may copy and distribute verbatim copies of the Library's-complete source code as you receive it, in any medium, provided that-you conspicuously and appropriately publish on each copy an-appropriate copyright notice and disclaimer of warranty; keep intact-all the notices that refer to this License and to the absence of any-warranty; and distribute a copy of this License along with the-Library.-- You may charge a fee for the physical act of transferring a copy,-and you may at your option offer warranty protection in exchange for a-fee.-- 2. You may modify your copy or copies of the Library or any portion-of it, thus forming a work based on the Library, and copy and-distribute such modifications or work under the terms of Section 1-above, provided that you also meet all of these conditions:-- a) The modified work must itself be a software library.-- b) You must cause the files modified to carry prominent notices- stating that you changed the files and the date of any change.-- c) You must cause the whole of the work to be licensed at no- charge to all third parties under the terms of this License.-- d) If a facility in the modified Library refers to a function or a- table of data to be supplied by an application program that uses- the facility, other than as an argument passed when the facility- is invoked, then you must make a good faith effort to ensure that,- in the event an application does not supply such function or- table, the facility still operates, and performs whatever part of- its purpose remains meaningful.-- (For example, a function in a library to compute square roots has- a purpose that is entirely well-defined independent of the- application. Therefore, Subsection 2d requires that any- application-supplied function or table used by this function must- be optional: if the application does not supply it, the square- root function must still compute square roots.)--These requirements apply to the modified work as a whole. If-identifiable sections of that work are not derived from the Library,-and can be reasonably considered independent and separate works in-themselves, then this License, and its terms, do not apply to those-sections when you distribute them as separate works. But when you-distribute the same sections as part of a whole which is a work based-on the Library, the distribution of the whole must be on the terms of-this License, whose permissions for other licensees extend to the-entire whole, and thus to each and every part regardless of who wrote-it.--Thus, it is not the intent of this section to claim rights or contest-your rights to work written entirely by you; rather, the intent is to-exercise the right to control the distribution of derivative or-collective works based on the Library.--In addition, mere aggregation of another work not based on the Library-with the Library (or with a work based on the Library) on a volume of-a storage or distribution medium does not bring the other work under-the scope of this License.-- 3. You may opt to apply the terms of the ordinary GNU General Public-License instead of this License to a given copy of the Library. To do-this, you must alter all the notices that refer to this License, so-that they refer to the ordinary GNU General Public License, version 2,-instead of to this License. (If a newer version than version 2 of the-ordinary GNU General Public License has appeared, then you can specify-that version instead if you wish.) Do not make any other change in-these notices.-- Once this change is made in a given copy, it is irreversible for-that copy, so the ordinary GNU General Public License applies to all-subsequent copies and derivative works made from that copy.-- This option is useful when you wish to copy part of the code of-the Library into a program that is not a library.-- 4. You may copy and distribute the Library (or a portion or-derivative of it, under Section 2) in object code or executable form-under the terms of Sections 1 and 2 above provided that you accompany-it with the complete corresponding machine-readable source code, which-must be distributed under the terms of Sections 1 and 2 above on a-medium customarily used for software interchange.-- If distribution of object code is made by offering access to copy-from a designated place, then offering equivalent access to copy the-source code from the same place satisfies the requirement to-distribute the source code, even though third parties are not-compelled to copy the source along with the object code.-- 5. A program that contains no derivative of any portion of the-Library, but is designed to work with the Library by being compiled or-linked with it, is called a "work that uses the Library". Such a-work, in isolation, is not a derivative work of the Library, and-therefore falls outside the scope of this License.-- However, linking a "work that uses the Library" with the Library-creates an executable that is a derivative of the Library (because it-contains portions of the Library), rather than a "work that uses the-library". The executable is therefore covered by this License.-Section 6 states terms for distribution of such executables.-- When a "work that uses the Library" uses material from a header file-that is part of the Library, the object code for the work may be a-derivative work of the Library even though the source code is not.-Whether this is true is especially significant if the work can be-linked without the Library, or if the work is itself a library. The-threshold for this to be true is not precisely defined by law.-- If such an object file uses only numerical parameters, data-structure layouts and accessors, and small macros and small inline-functions (ten lines or less in length), then the use of the object-file is unrestricted, regardless of whether it is legally a derivative-work. (Executables containing this object code plus portions of the-Library will still fall under Section 6.)-- Otherwise, if the work is a derivative of the Library, you may-distribute the object code for the work under the terms of Section 6.-Any executables containing that work also fall under Section 6,-whether or not they are linked directly with the Library itself.-- 6. As an exception to the Sections above, you may also combine or-link a "work that uses the Library" with the Library to produce a-work containing portions of the Library, and distribute that work-under terms of your choice, provided that the terms permit-modification of the work for the customer's own use and reverse-engineering for debugging such modifications.-- You must give prominent notice with each copy of the work that the-Library is used in it and that the Library and its use are covered by-this License. You must supply a copy of this License. If the work-during execution displays copyright notices, you must include the-copyright notice for the Library among them, as well as a reference-directing the user to the copy of this License. Also, you must do one-of these things:-- a) Accompany the work with the complete corresponding- machine-readable source code for the Library including whatever- changes were used in the work (which must be distributed under- Sections 1 and 2 above); and, if the work is an executable linked- with the Library, with the complete machine-readable "work that- uses the Library", as object code and/or source code, so that the- user can modify the Library and then relink to produce a modified- executable containing the modified Library. (It is understood- that the user who changes the contents of definitions files in the- Library will not necessarily be able to recompile the application- to use the modified definitions.)-- b) Use a suitable shared library mechanism for linking with the- Library. A suitable mechanism is one that (1) uses at run time a- copy of the library already present on the user's computer system,- rather than copying library functions into the executable, and (2)- will operate properly with a modified version of the library, if- the user installs one, as long as the modified version is- interface-compatible with the version that the work was made with.-- c) Accompany the work with a written offer, valid for at least- three years, to give the same user the materials specified in- Subsection 6a, above, for a charge no more than the cost of- performing this distribution.-- d) If distribution of the work is made by offering access to copy- from a designated place, offer equivalent access to copy the above- specified materials from the same place.-- e) Verify that the user has already received a copy of these- materials or that you have already sent this user a copy.-- For an executable, the required form of the "work that uses the-Library" must include any data and utility programs needed for-reproducing the executable from it. However, as a special exception,-the materials to be distributed need not include anything that is-normally distributed (in either source or binary form) with the major-components (compiler, kernel, and so on) of the operating system on-which the executable runs, unless that component itself accompanies-the executable.-- It may happen that this requirement contradicts the license-restrictions of other proprietary libraries that do not normally-accompany the operating system. Such a contradiction means you cannot-use both them and the Library together in an executable that you-distribute.-- 7. You may place library facilities that are a work based on the-Library side-by-side in a single library together with other library-facilities not covered by this License, and distribute such a combined-library, provided that the separate distribution of the work based on-the Library and of the other library facilities is otherwise-permitted, and provided that you do these two things:-- a) Accompany the combined library with a copy of the same work- based on the Library, uncombined with any other library- facilities. This must be distributed under the terms of the- Sections above.-- b) Give prominent notice with the combined library of the fact- that part of it is a work based on the Library, and explaining- where to find the accompanying uncombined form of the same work.-- 8. You may not copy, modify, sublicense, link with, or distribute-the Library except as expressly provided under this License. Any-attempt otherwise to copy, modify, sublicense, link with, or-distribute the Library is void, and will automatically terminate your-rights under this License. However, parties who have received copies,-or rights, from you under this License will not have their licenses-terminated so long as such parties remain in full compliance.-- 9. You are not required to accept this License, since you have not-signed it. However, nothing else grants you permission to modify or-distribute the Library or its derivative works. These actions are-prohibited by law if you do not accept this License. Therefore, by-modifying or distributing the Library (or any work based on the-Library), you indicate your acceptance of this License to do so, and-all its terms and conditions for copying, distributing or modifying-the Library or works based on it.-- 10. Each time you redistribute the Library (or any work based on the-Library), the recipient automatically receives a license from the-original licensor to copy, distribute, link with or modify the Library-subject to these terms and conditions. You may not impose any further-restrictions on the recipients' exercise of the rights granted herein.-You are not responsible for enforcing compliance by third parties with-this License.-- 11. If, as a consequence of a court judgment or allegation of patent-infringement or for any other reason (not limited to patent issues),-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-distribute so as to satisfy simultaneously your obligations under this-License and any other pertinent obligations, then as a consequence you-may not distribute the Library at all. For example, if a patent-license would not permit royalty-free redistribution of the Library by-all those who receive copies directly or indirectly through you, then-the only way you could satisfy both it and this License would be to-refrain entirely from distribution of the Library.--If any portion of this section is held invalid or unenforceable under-any particular circumstance, the balance of the section is intended to-apply, and the section as a whole is intended to apply in other-circumstances.--It is not the purpose of this section to induce you to infringe any-patents or other property right claims or to contest validity of any-such claims; this section has the sole purpose of protecting the-integrity of the free software distribution system which is-implemented by public license practices. Many people have made-generous contributions to the wide range of software distributed-through that system in reliance on consistent application of that-system; it is up to the author/donor to decide if he or she is willing-to distribute software through any other system and a licensee cannot-impose that choice.--This section is intended to make thoroughly clear what is believed to-be a consequence of the rest of this License.-- 12. If the distribution and/or use of the Library is restricted in-certain countries either by patents or by copyrighted interfaces, the-original copyright holder who places the Library under this License-may add an explicit geographical distribution limitation excluding those-countries, so that distribution is permitted only in or among-countries not thus excluded. In such case, this License incorporates-the limitation as if written in the body of this License.-- 13. The Free Software Foundation may publish revised and/or new-versions of the Lesser 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 Library-specifies a version number of this License which applies to it and-"any later version", you have the option of following the terms and-conditions either of that version or of any later version published by-the Free Software Foundation. If the Library does not specify a-license version number, you may choose any version ever published by-the Free Software Foundation.-- 14. If you wish to incorporate parts of the Library into other free-programs whose distribution conditions are incompatible with these,-write to the author to ask for permission. For software which is-copyrighted by the Free Software Foundation, write to the Free-Software Foundation; we sometimes make exceptions for this. Our-decision will be guided by the two goals of preserving the free status-of all derivatives of our free software and of promoting the sharing-and reuse of software generally.-- NO WARRANTY-- 15. BECAUSE THE LIBRARY IS LICENSED FREE OF CHARGE, THERE IS NO-WARRANTY FOR THE LIBRARY, TO THE EXTENT PERMITTED BY APPLICABLE LAW.-EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR-OTHER PARTIES PROVIDE THE LIBRARY "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-LIBRARY IS WITH YOU. SHOULD THE LIBRARY PROVE DEFECTIVE, YOU ASSUME-THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION.-- 16. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN-WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY-AND/OR REDISTRIBUTE THE LIBRARY 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-LIBRARY (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 LIBRARY TO OPERATE WITH ANY OTHER SOFTWARE), EVEN IF-SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH-DAMAGES.-- END OF TERMS AND CONDITIONS-- How to Apply These Terms to Your New Libraries-- If you develop a new library, and you want it to be of the greatest-possible use to the public, we recommend making it free software that-everyone can redistribute and change. You can do so by permitting-redistribution under these terms (or, alternatively, under the terms-of the ordinary General Public License).-- To apply these terms, attach the following notices to the library.-It is safest to attach them to the start of each source file to most-effectively convey 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 library's name and a brief idea of what it does.>- Copyright (C) <year> <name of author>-- This library is free software; you can redistribute it and/or- modify it under the terms of the GNU Lesser General Public- License as published by the Free Software Foundation; either- version 2.1 of the License, or (at your option) any later version.-- This library 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- Lesser General Public License for more details.-- You should have received a copy of the GNU Lesser General Public- License along with this library; if not, write to the Free Software- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA--Also add information on how to contact you by electronic and paper mail.--You should also get your employer (if you work as a programmer) or-your school, if any, to sign a "copyright disclaimer" for the library,-if necessary. Here is a sample; alter the names:-- Yoyodyne, Inc., hereby disclaims all copyright interest in the- library `Frob' (a library for tweaking knobs) written by James- Random Hacker.-- <signature of Ty Coon>, 1 April 1990- Ty Coon, President of Vice--That's all there is to it!--
− COPYRIGHT
@@ -1,18 +0,0 @@-Copyright (C) 2005-2009 John Goerzen <jgoerzen@complete.org>-- This library is free software; you can redistribute it and/or- modify it under the terms of the GNU Lesser General Public- License as published by the Free Software Foundation; either- version 2.1 of the License, or (at your option) any later version.-- This library 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- Lesser General Public License for more details.-- You should have received a copy of the GNU Lesser General Public- License along with this library; if not, write to the Free Software- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA--Please see COPYING for the license.-
Database/HDBC.hs view
@@ -1,26 +1,7 @@-{--Copyright (C) 2005-2006 John Goerzen <jgoerzen@complete.org>-- This library is free software; you can redistribute it and/or- modify it under the terms of the GNU Lesser General Public- License as published by the Free Software Foundation; either- version 2.1 of the License, or (at your option) any later version.-- This library 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- Lesser General Public License for more details.-- You should have received a copy of the GNU Lesser General Public- License along with this library; if not, write to the Free Software- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA---}- {- | Module : Database.HDBC- Copyright : Copyright (C) 2005-2009 John Goerzen- License : GNU LGPL, version 2.1 or above+ Copyright : Copyright (C) 2005-2011 John Goerzen+ License : BSD3 Maintainer : John Goerzen <jgoerzen@complete.org> Stability : provisional@@ -89,9 +70,6 @@ -- * Threading -- $threading-- -- * Copyright and License- -- $legal ) where@@ -150,28 +128,22 @@ * Support for querying database server properties * Add-on package (hdbc-missingh) to integrate with MissingH,- providing a database backend for AnyDBM.+ providing a database backend for AnyDBM - * Support for querying metadata such as column names.+ * Support for querying metadata such as column names * Support for querying additional metadata (column types, etc.) -} {- $drivers -Here is a list of known drivers as of January 26, 2009:+Here is a list of known drivers as of May 6, 2019: -[@Sqlite v3@] Available from <http://software.complete.org/hdbc-sqlite3>. Or, to-participate in development, use -@git clone <git://git.complete.org/hdbc-sqlite3>@+[@Sqlite v3@] Available from <https://github.com/hdbc/hdbc-sqlite3>. -[@PostgreSQL@] Available from <http://software.complete.org/hdbc-postgresql>. Or, to-participate in development, use-@git clone <git://git.complete.org/hdbc-postgresql>@+[@PostgreSQL@] Available from <https://github.com/hdbc/hdbc-postgresql>. -[@ODBC@] Available from <http://software.complete.org/hdbc-odbc>. Or, to-partitipace in development, use-@git clone <git://git.complete.org/hdbc-odbc>@+[@ODBC@] Available from <https://github.com/hdbc/hdbc-odbc>. [@MySQL@] MySQL users have two choices: the first is the ODBC driver, which works and has been tested against MySQL on both Linux\/Unix and Windows platforms. There is@@ -179,16 +151,8 @@ <http://hackage.haskell.org/cgi-bin/hackage-scripts/package/HDBC-mysql> with a homepage at <http://www.maubi.net/~waterson/hacks/hdbc-mysql.html>. -In addition, there is one integration package: /hdbc-anydbm/. This-integrates with the AnyDBM library <http://software.complete.org/anydbm>.-It lets any HDBC database act as a backend for the-AnyDBM interface. Available from <http://software.complete.org/hdbc-anydbm>. Or,-to participate in development, use-@darcs get --partial <http://darcs.complete.org/hdbc-anydbm>@- The latest version of HDBC itself is available from-<http://software.complete.org/hdbc>. Or, to participate in development, use-@git clone <git://git.complete.org/hdbc>@.+<https://github.com/hdbc/hdbc>. -} {- $transactions@@ -256,24 +220,4 @@ only get real multithreading when databases really support it. Details of thread support should be documented in the HDBC driver for each specific database.--}--{- $legal-Copyright (C) 2005-2009 John Goerzen <jgoerzen@complete.org>--This library is free software; you can redistribute it and\/or-modify it under the terms of the GNU Lesser General Public-License as published by the Free Software Foundation; either-version 2.1 of the License, or (at your option) any later version.--This library 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-Lesser General Public License for more details.--You should have received a copy of the GNU Lesser General Public-License along with this library; if not, write to the Free Software-Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA--Please see COPYING in the source distribution for the full license. -}
Database/HDBC/ColTypes.hs view
@@ -1,25 +1,7 @@-{--Copyright (C) 2006 John Goerzen <jgoerzen@complete.org>-- This library is free software; you can redistribute it and/or- modify it under the terms of the GNU Lesser General Public- License as published by the Free Software Foundation; either- version 2.1 of the License, or (at your option) any later version.-- This library 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- Lesser General Public License for more details.-- You should have received a copy of the GNU Lesser General Public- License along with this library; if not, write to the Free Software- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA--}- {- | Module : Database.HDBC.ColTypes- Copyright : Copyright (C) 2006 John Goerzen- License : GNU LGPL, version 2.1 or above+ Copyright : Copyright (C) 2006-2011 John Goerzen+ License : BSD3 Maintainer : John Goerzen <jgoerzen@complete.org> Stability : provisional@@ -30,6 +12,7 @@ Written by John Goerzen, jgoerzen\@complete.org -}+{-# LANGUAGE DeriveDataTypeable #-} module Database.HDBC.ColTypes (SqlColDesc(..), SqlTypeId(..),@@ -60,13 +43,7 @@ ,colDecDigits :: Maybe Int -- ^ Digits to the right of the period ,colNullable :: Maybe Bool -- ^ Whether NULL is acceptable }- deriving (Eq, Read, Show)--sqlColDescTc :: TyCon-sqlColDescTc = mkTyCon "Database.HDBC.SqlColDesc"--instance Typeable SqlColDesc where- typeOf _ = mkTyConApp sqlColDescTc []+ deriving (Eq, Read, Show, Typeable) {- | The type identifier for a given column. @@ -106,13 +83,7 @@ | SqlGUIDT -- ^ Global unique identifier | SqlUnknownT String -- ^ A type not represented here; implementation-specific information in the String - deriving (Eq, Show, Read)--sqlTypeIdTc :: TyCon-sqlTypeIdTc = mkTyCon "Database.HDBC.SqlTypeId"--instance Typeable SqlTypeId where- typeOf _ = mkTyConApp sqlTypeIdTc []+ deriving (Eq, Show, Read, Typeable) {- | The different types of intervals in SQL. -} data SqlInterval =@@ -129,10 +100,4 @@ | SqlIntervalHourToMinuteT -- ^ Difference in hours+minutes | SqlIntervalHourToSecondT -- ^ Difference in hours+seconds | SqlIntervalMinuteToSecondT -- ^ Difference in minutes+seconds- deriving (Eq, Show, Read)--sqlIntervalTc :: TyCon-sqlIntervalTc = mkTyCon "Database.HDBC.SqlInterval"--instance Typeable SqlInterval where- typeOf _ = mkTyConApp sqlIntervalTc []+ deriving (Eq, Show, Read, Typeable)
Database/HDBC/DriverUtils.hs view
@@ -1,25 +1,7 @@-{--Copyright (C) 2006 John Goerzen <jgoerzen@complete.org>-- This library is free software; you can redistribute it and/or- modify it under the terms of the GNU Lesser General Public- License as published by the Free Software Foundation; either- version 2.1 of the License, or (at your option) any later version.-- This library 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- Lesser General Public License for more details.-- You should have received a copy of the GNU Lesser General Public- License along with this library; if not, write to the Free Software- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA--}- {- | Module : Database.HDBC.DriverUtils Copyright : Copyright (C) 2006 John Goerzen- License : GNU LGPL, version 2.1 or above+ License : BSD3 Maintainer : John Goerzen <jgoerzen@complete.org> Stability : provisional
Database/HDBC/Locale.hs view
@@ -1,17 +1,34 @@+{-# LANGUAGE CPP #-} module Database.HDBC.Locale ( defaultTimeLocale,- iso8601DateFormat+ iso8601DateFormat,+ oldIso8601DateFormat ) where++#ifdef MIN_TIME_15+import Data.Time.Format (defaultTimeLocale)+#else import System.Locale (defaultTimeLocale)+#endif -- | As the semantic of System.Locale.iso8601DateFormat has changed with -- old-locale-1.0.0.2 in a non-compatible way, we now define our own -- (compatible) version of it. iso8601DateFormat :: Maybe String -> String iso8601DateFormat mTimeFmt =+ "%0Y-%m-%d" ++ case mTimeFmt of+ Nothing -> ""+ Just fmt -> ' ' : fmt++-- | HDBC would in versions up to and including 2.4.0.3 use this time format+-- string to serialize timestamps. To keep being able to deserialize timestamps+-- serialized on database engines that keep the representation intact (e.g.+-- SQLite) we keep this format string around, such that we can fall back to it.+oldIso8601DateFormat :: Maybe String -> String+oldIso8601DateFormat mTimeFmt = "%Y-%m-%d" ++ case mTimeFmt of Nothing -> "" Just fmt -> ' ' : fmt
Database/HDBC/SqlValue.hs view
@@ -1,3 +1,5 @@+{-# LANGUAGE DeriveDataTypeable #-}+{-# LANGUAGE StandaloneDeriving #-} module Database.HDBC.SqlValue ( -- * SQL value marshalling@@ -7,6 +9,7 @@ ) where+import Control.Applicative ((<|>)) import Data.Dynamic import qualified Data.ByteString.UTF8 as BUTF8 import qualified Data.ByteString as B@@ -15,9 +18,18 @@ import Data.Word import Data.Int import qualified System.Time as ST-import Data.Time+import Data.Time ( Day (ModifiedJulianDay), DiffTime, LocalTime, NominalDiffTime, ParseTime+ , TimeOfDay, TimeZone, UTCTime, ZonedTime, formatTime, localDay, localTimeOfDay+ , timeOfDayToTime, timeToTimeOfDay, toModifiedJulianDay, utc+ , utcToZonedTime, zonedTimeToLocalTime, zonedTimeToUTC, zonedTimeZone+#if MIN_TIME_15+ , parseTimeM+#else+ , parseTime+#endif+ ) import Data.Time.Clock.POSIX-import Database.HDBC.Locale (defaultTimeLocale, iso8601DateFormat)+import Database.HDBC.Locale (defaultTimeLocale, iso8601DateFormat, oldIso8601DateFormat) import Data.Ratio import Data.Convertible import Data.Fixed@@ -59,7 +71,7 @@ posixToSql :: POSIXTime -> SqlValue posixToSql x = SqlPOSIXTime x -{- | 'SqlValue' is he main type for expressing Haskell values to SQL databases.+{- | 'SqlValue' is the main type for expressing Haskell values to SQL databases. /INTRODUCTION TO SQLVALUE/ @@ -167,7 +179,7 @@ * Both represent the same type and the encapsulated values are considered equal by applying (==) to them - * The values of each, when converted to a string, are equal.+ * The values of each, when converted to a string, are equal /STRING VERSIONS OF TIMES/ @@ -198,21 +210,18 @@ | SqlBool Bool | SqlDouble Double | SqlRational Rational- | SqlLocalDate Day -- ^ Local YYYY-MM-DD (no timezone)- | SqlLocalTimeOfDay TimeOfDay -- ^ Local HH:MM:SS (no timezone)+ | SqlLocalDate Day -- ^ Local YYYY-MM-DD (no timezone).+ | SqlLocalTimeOfDay TimeOfDay -- ^ Local HH:MM:SS (no timezone). | SqlZonedLocalTimeOfDay TimeOfDay TimeZone -- ^ Local HH:MM:SS -HHMM. Converts to and from (TimeOfDay, TimeZone).- | SqlLocalTime LocalTime -- ^ Local YYYY-MM-DD HH:MM:SS (no timezone)+ | SqlLocalTime LocalTime -- ^ Local YYYY-MM-DD HH:MM:SS (no timezone). | SqlZonedTime ZonedTime -- ^ Local YYYY-MM-DD HH:MM:SS -HHMM. Considered equal if both convert to the same UTC time.- | SqlUTCTime UTCTime -- ^ UTC YYYY-MM-DD HH:MM:SS+ | SqlUTCTime UTCTime -- ^ UTC YYYY-MM-DD HH:MM:SS. | SqlDiffTime NominalDiffTime -- ^ Calendar diff between seconds. Rendered as Integer when converted to String, but greater precision may be preserved for other types or to underlying database. | SqlPOSIXTime POSIXTime -- ^ Time as seconds since midnight Jan 1 1970 UTC. Integer rendering as for 'SqlDiffTime'. | SqlEpochTime Integer -- ^ DEPRECATED Representation of ClockTime or CalendarTime. Use SqlPOSIXTime instead. | SqlTimeDiff Integer -- ^ DEPRECATED Representation of TimeDiff. Use SqlDiffTime instead.- | SqlNull -- ^ NULL in SQL or Nothing in Haskell- deriving (Show)--instance Typeable SqlValue where- typeOf _ = mkTypeName "SqlValue"+ | SqlNull -- ^ NULL in SQL or Nothing in Haskell.+ deriving (Show, Typeable) instance Eq SqlValue where SqlString a == SqlString b = a == b@@ -242,6 +251,12 @@ a == b = ((safeFromSql a)::ConvertResult String) == ((safeFromSql b)::ConvertResult String) +deriving instance Typeable ST.ClockTime+deriving instance Typeable ST.TimeDiff++instance Convertible SqlValue SqlValue where+ safeConvert = return+ instance Convertible String SqlValue where safeConvert = return . SqlString instance Convertible SqlValue String where@@ -503,7 +518,7 @@ safeConvert (SqlTimeDiff x) = numToBool x safeConvert y@(SqlNull) = quickError y -numToBool :: Num a => a -> ConvertResult Bool+numToBool :: (Eq a, Num a) => a -> ConvertResult Bool numToBool x = Right (x /= 0) instance Convertible Char SqlValue where@@ -511,7 +526,7 @@ instance Convertible SqlValue Char where safeConvert (SqlString [x]) = return x safeConvert y@(SqlString _) = convError "String length /= 1" y- safeConvert y@(SqlByteString x) = + safeConvert (SqlByteString x) = safeConvert . SqlString . BUTF8.toString $ x safeConvert y@(SqlInt32 _) = quickError y safeConvert y@(SqlInt64 _) = quickError y@@ -592,30 +607,10 @@ safeConvert (SqlTimeDiff x) = return . fromIntegral $ x safeConvert y@(SqlNull) = quickError y -#ifndef TIME_GT_113-instance Typeable Day where- typeOf _ = mkTypeName "Day"-instance Typeable TimeOfDay where- typeOf _ = mkTypeName "TimeOfDay"-instance Typeable LocalTime where- typeOf _ = mkTypeName "LocalTime"-instance Typeable ZonedTime where- typeOf _ = mkTypeName "ZonedTime"-instance Typeable DiffTime where- typeOf _ = mkTypeName "DiffTime"-instance Typeable TimeZone where- typeOf _ = mkTypeName "TimeZone"-#endif--instance Typeable ST.ClockTime where- typeOf _ = mkTypeName "ClockTime"-instance Typeable ST.TimeDiff where- typeOf _ = mkTypeName "TimeDiff"- instance Convertible Day SqlValue where safeConvert = return . SqlLocalDate instance Convertible SqlValue Day where- safeConvert (SqlString x) = parseTime' (iso8601DateFormat Nothing) x+ safeConvert (SqlString x) = parseTimeISO8601 Nothing x safeConvert (SqlByteString x) = safeConvert (SqlString (BUTF8.toString x)) safeConvert (SqlInt32 x) = return $ ModifiedJulianDay {toModifiedJulianDay = fromIntegral x}@@ -676,7 +671,11 @@ instance Convertible SqlValue (TimeOfDay, TimeZone) where safeConvert (SqlString x) = do tod <- parseTime' "%T%Q %z" x+#if MIN_TIME_15+ tz <- case parseTimeM True defaultTimeLocale "%T%Q %z" x of+#else tz <- case parseTime defaultTimeLocale "%T%Q %z" x of+#endif Nothing -> convError "Couldn't extract timezone in" (SqlString x) Just y -> Right y return (tod, tz)@@ -706,7 +705,7 @@ instance Convertible LocalTime SqlValue where safeConvert = return . SqlLocalTime instance Convertible SqlValue LocalTime where- safeConvert (SqlString x) = parseTime' (iso8601DateFormat (Just "%T%Q")) x+ safeConvert (SqlString x) = parseTimeISO8601 (Just "%T%Q") x safeConvert (SqlByteString x) = safeConvert (SqlString (BUTF8.toString x)) safeConvert y@(SqlInt32 _) = quickError y safeConvert y@(SqlInt64 _) = quickError y@@ -732,7 +731,7 @@ instance Convertible ZonedTime SqlValue where safeConvert = return . SqlZonedTime instance Convertible SqlValue ZonedTime where- safeConvert (SqlString x) = parseTime' (iso8601DateFormat (Just "%T%Q %z")) x+ safeConvert (SqlString x) = parseTimeISO8601 (Just "%T%Q %z") x safeConvert (SqlByteString x) = safeConvert (SqlString (BUTF8.toString x)) safeConvert (SqlInt32 x) = safeConvert (SqlInteger (fromIntegral x)) safeConvert (SqlInt64 x) = safeConvert (SqlInteger (fromIntegral x))@@ -758,7 +757,7 @@ instance Convertible UTCTime SqlValue where safeConvert = return . SqlUTCTime instance Convertible SqlValue UTCTime where- safeConvert (SqlString x) = parseTime' (iso8601DateFormat (Just "%T%Q")) x+ safeConvert (SqlString x) = parseTimeISO8601 (Just "%T%Q") x safeConvert (SqlByteString x) = safeConvert (SqlString (BUTF8.toString x)) safeConvert y@(SqlInt32 _) = safeConvert y >>= return . posixSecondsToUTCTime safeConvert y@(SqlInt64 _) = safeConvert y >>= return . posixSecondsToUTCTime@@ -950,8 +949,25 @@ #else parseTime' :: (Typeable t, Convertible SqlValue t, ParseTime t) => String -> String -> ConvertResult t parseTime' fmtstr inpstr = +#if MIN_TIME_15+ case parseTimeM True defaultTimeLocale fmtstr inpstr of+#else case parseTime defaultTimeLocale fmtstr inpstr of+#endif Nothing -> convError ("Cannot parse using default format string " ++ show fmtstr) (SqlString inpstr) Just x -> Right x+#endif++parseTimeISO8601 :: (Typeable t, Convertible SqlValue t, ParseTime t) => Maybe String -> String -> ConvertResult t+parseTimeISO8601 fmtstr inpstr =+ case tryParse iso8601DateFormat <|> tryParse oldIso8601DateFormat of+ Nothing -> convError "Cannot parse ISO8601 timestamp" (SqlString inpstr)+ Just x -> Right x+ where+ tryParse fmtFunction =+#if MIN_TIME_15+ parseTimeM True defaultTimeLocale (fmtFunction fmtstr) inpstr+#else+ parseTime defaultTimeLocale (fmtFunction fmtstr) inpstr #endif
Database/HDBC/Statement.hs view
@@ -1,3 +1,4 @@+{-# LANGUAGE DeriveDataTypeable #-} module Database.HDBC.Statement ( Statement(..),@@ -107,13 +108,8 @@ data SqlError = SqlError {seState :: String, seNativeError :: Int, seErrorMsg :: String}- deriving (Eq, Show, Read)--sqlErrorTc :: TyCon-sqlErrorTc = mkTyCon "Database.HDBC.SqlError"+ deriving (Eq, Show, Read, Typeable) -instance Typeable SqlError where- typeOf _ = mkTyConApp sqlErrorTc [] #if __GLASGOW_HASKELL__ >= 610 --data SqlException
Database/HDBC/Types.hs view
@@ -1,25 +1,7 @@-{--Copyright (C) 2005-2009 John Goerzen <jgoerzen@complete.org>-- This library is free software; you can redistribute it and/or- modify it under the terms of the GNU Lesser General Public- License as published by the Free Software Foundation; either- version 2.1 of the License, or (at your option) any later version.-- This library 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- Lesser General Public License for more details.-- You should have received a copy of the GNU Lesser General Public- License along with this library; if not, write to the Free Software- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA--}- {- | Module : Database.HDBC.Types- Copyright : Copyright (C) 2005-2009 John Goerzen- License : GNU LGPL, version 2.1 or above+ Copyright : Copyright (C) 2005-2011 John Goerzen+ License : BSD3 Maintainer : John Goerzen <jgoerzen@complete.org> Stability : provisional@@ -217,6 +199,7 @@ disconnect w = withWConn w disconnect commit w = withWConn w commit rollback w = withWConn w rollback+ runRaw w = withWConn w runRaw run w = withWConn w run prepare w = withWConn w prepare clone w = withWConn w (\dbh -> clone dbh >>= return . ConnWrapper)
Database/HDBC/Utils.hs view
@@ -1,27 +1,9 @@ {-# LANGUAGE CPP #-} -- #hide-{--Copyright (C) 2005-2009 John Goerzen <jgoerzen@complete.org>-- This library is free software; you can redistribute it and/or- modify it under the terms of the GNU Lesser General Public- License as published by the Free Software Foundation; either- version 2.1 of the License, or (at your option) any later version.-- This library 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- Lesser General Public License for more details.-- You should have received a copy of the GNU Lesser General Public- License along with this library; if not, write to the Free Software- Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA--}- {- | Module : Database.HDBC.Utils- Copyright : Copyright (C) 2005-2009 John Goerzen- License : GNU LGPL, version 2.1 or above+ Copyright : Copyright (C) 2005-2011 John Goerzen+ License : BSD3 Maintainer : John Goerzen <jgoerzen@complete.org> Stability : provisional@@ -233,7 +215,7 @@ Just r -> do names <- getColumnNames sth return $ Just $ zip names r -{- | Strict version of 'fetchRowAL' -}+{- | Strict version of 'fetchRowAL'. -} fetchRowAL' :: Statement -> IO (Maybe [(String, SqlValue)]) fetchRowAL' sth = do res <- fetchRowAL sth@@ -251,7 +233,7 @@ Nothing -> return Nothing Just x -> return $ Just $ Map.fromList x -{- | Strict version of 'fetchRowMap' -}+{- | Strict version of 'fetchRowMap'. -} fetchRowMap' :: Statement -> IO (Maybe (Map.Map String SqlValue)) fetchRowMap' sth = do res <- fetchRowMap sth@@ -290,7 +272,7 @@ return res {- | A quick way to do a query. Similar to preparing, executing, and-then calling 'fetchAllRows' on a statement. See also 'quickQuery'' -}+then calling 'fetchAllRows' on a statement. See also 'quickQuery''. -} quickQuery :: IConnection conn => conn -> String -> [SqlValue] -> IO [[SqlValue]] quickQuery conn qrystr args = do sth <- prepare conn qrystr
HDBC.cabal view
@@ -1,12 +1,12 @@ Name: HDBC-Version: 2.2.7.0-License: LGPL-Maintainer: John Goerzen <jgoerzen@complete.org>-Author: John Goerzen-Copyright: Copyright (c) 2005-2010 John Goerzen-license-file: COPYRIGHT-extra-source-files: COPYING, Makefile, Memory.txt, README.txt-homepage: http://software.complete.org/hdbc+Version: 2.4.0.5+License: BSD3+Maintainer: Nicolas Wu <nicolas.wu@gmail.com>, David Johnson <code@dmj.io>+Author: John Goerzen, Nicolas Wu+homepage: https://github.com/hdbc/hdbc+Copyright: Copyright (c) 2005-2011 John Goerzen+license-file: LICENSE+extra-source-files: LICENSE, Makefile, README.md, CHANGELOG.md Category: Database synopsis: Haskell Database Connectivity Description: HDBC provides an abstraction layer between Haskell programs and SQL@@ -16,28 +16,32 @@ Stability: Stable Build-Type: Simple -Cabal-Version: >=1.8+Cabal-Version: >=1.10 +source-repository head+ type: git+ location: https://github.com/hdbc/hdbc.git+ flag splitBase description: Choose the new smaller, split-up base package. flag buildtests description: Build the executable to run unit tests default: False--flag time_gte_113- description: time > 1.1.3 has defined some more instances so omit them here+flag minTime15+ description: Use time 1.5 or higher.+ default: True library if flag(splitBase)- Build-Depends: base>=3 && <5, old-time, time>=1.1.2.4 && <=1.2.0.3, bytestring, containers, old-locale- if flag(time_gte_113)- Build-Depends: time>=1.1.3- CPP-OPTIONS: -DTIME_GT_113+ Build-Depends: base>=3 && <5, old-time, bytestring, containers+ if flag(minTime15)+ Build-Depends: time >= 1.5 && < 1.17+ CPP-Options: -DMIN_TIME_15 else- Build-Depends: time<1.1.3+ Build-Depends: time >= 1.2 && < 1.5, old-locale else Build-Depends: base<3- Build-Depends: mtl, convertible >= 1.0.10.0, text, utf8-string+ Build-Depends: mtl, convertible >= 1.1.0.0, text, utf8-string -- Hack for cabal-install weirdness. cabal-install forces base 3, -- though it works fine for Setup.lhs manually. Fix.@@ -50,25 +54,26 @@ Database.HDBC.ColTypes, Database.HDBC.Statement, Database.HDBC.SqlValue, Database.HDBC.Locale Other-Modules: Database.HDBC.Utils- Extensions: ExistentialQuantification, CPP, MultiParamTypeClasses,+ Default-Extensions: ExistentialQuantification, CPP, MultiParamTypeClasses, FlexibleContexts, TypeSynonymInstances, TypeOperators, RankNTypes,- FlexibleInstances- + FlexibleInstances, DeriveDataTypeable+ Default-Language: Haskell2010+ Executable runtests if flag(buildtests) Buildable: True- Build-Depends: HUnit, QuickCheck (>= 2.0), testpack (>= 2.0)+ Build-Depends: HUnit, QuickCheck >= 2.0 if flag(splitBase)- Build-Depends: base>=3 && <5, old-time, time>=1.1.2.4 && <=1.1.4, bytestring, containers, old-locale- if flag(time_gte_113)- Build-Depends: time>=1.1.3- CPP-OPTIONS: -DTIME_GT_113+ Build-Depends: base>=3 && <5, old-time, bytestring, containers+ if flag(minTime15)+ Build-Depends: time >= 1.5 && < 1.17+ CPP-Options: -DMIN_TIME_15 else- Build-Depends: time<1.1.3+ Build-Depends: time >= 1.2 && < 1.5, old-locale else Build-Depends: base<3- Build-Depends: mtl, convertible >= 1.0.9.1, utf8-string+ Build-Depends: mtl, convertible >= 1.1.0.0, utf8-string, text -- Hack for cabal-install weirdness. cabal-install forces base 3, -- though it works fine for Setup.lhs manually. Fix.@@ -78,10 +83,9 @@ Buildable: False Main-Is: runtests.hs Other-Modules: TestSqlValue- TestInfrastructure Hs-Source-Dirs: ., testsrc GHC-Options: -O2- Extensions: ExistentialQuantification, CPP, MultiParamTypeClasses,+ Default-Extensions: ExistentialQuantification, CPP, MultiParamTypeClasses, FlexibleContexts, TypeSynonymInstances, TypeOperators, RankNTypes, FlexibleInstances- + Default-Language: Haskell2010
+ LICENSE view
@@ -0,0 +1,27 @@+Copyright (c) 2011, John Goerzen+All rights reserved.++Redistribution and use in source and binary forms, with or without+modification, are permitted provided that the following conditions are met:++* Redistributions of source code must retain the above copyright notice, this+ list of conditions and the following disclaimer.++* Redistributions in binary form must reproduce the above copyright notice, this+ list of conditions and the following disclaimer in the documentation and/or+ other materials provided with the distribution.++* Neither the name of John Goerzen nor the names of its+ contributors may be used to endorse or promote products derived from this+ software without specific prior written permission.++THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND+ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED+WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE+DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDER OR CONTRIBUTORS BE LIABLE+FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL+DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR+SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER+CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,+OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE+OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
Makefile view
@@ -1,18 +1,3 @@-# Copyright (C) 2004 - 2009 John Goerzen <jgoerzen@complete.org>-#-# This library is free software; you can redistribute it and/or-# modify it under the terms of the GNU Lesser General Public-# License as published by the Free Software Foundation; either-# version 2.1 of the License, or (at your option) any later version.-#-# This library 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-# Lesser General Public License for more details.-#-# You should have received a copy of the GNU Lesser General Public-# License along with this library; if not, write to the Free Software-# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA all: setup @echo "Please use Cabal to build this package; not make." ./setup configure
− Memory.txt
@@ -1,24 +0,0 @@-Notes on memory management-----------------------------ForeignPtrs are used wherever possible to make sure we don't have-memory leaks.--However, there is one potential problem with them. If a whole bunch-of database stuff goes out of scope all at once, then the Connection,-Statement, and everything else could become finalizable all at once.-And it is not guaranteed to be finalized in any particular order.--We don't want to have the Connection finalized before the Statements.-This could cause segfaults with some databases.--So we implement a simple reference counting system for the-Connection. Each use -- whether in a Connection or a Statement ---counts as one, and the whole thing is freed when the use count drops-to 0 (the last object using it has been finalized).--That solves almost every problem. We have one more: when somebody-calls disconnect on the parent, we really want to close all open-statements first. So a system of weak refs is used to handle that.-This makes sure that we free things in the proper order for explicit-disconnects as well.
+ README.md view
@@ -0,0 +1,33 @@+HDBC+====++Welcome to HDBC, Haskell Database Connectivity.++HDBC is modeled loosely on Perl's DBI interface, though it has also+been influenced by Python's DB-API v2, JDBC in Java, and HSQL in+Haskell.++Please see the HDBC [wiki](https://github.com/hdbc/hdbc/wiki) for an+introduction to HDBC and its various features.++Installation+------------++You'll need either GHC 6.4.1 or above, or Hugs 2005xx or above.++The steps to install are:++ ghc --make -o setup Setup.lhs+ ./setup configure+ ./setup build+ sudo ./setup install++If you're on Windows, you can omit the leading "./".++Usage+-----++To use with hugs, you'll want to use hugs -98.++To use with GHC, you'll want to use -package HDBC in your programs.+Or, with Cabal, use Build-Depends: HDBC.
− README.txt
@@ -1,39 +0,0 @@-Welcome to HDBC, Haskell Database Connectivity.--HDBC is modeled loosely on Perl's DBI interface, though it has also-been influenced by Python's DB-API v2, JDBC in Java, and HSQL in-Haskell.--Please see doc/Database-HDBC.html for an introduction to HDBC and its-various features.--INSTALLATION---------------You'll need either GHC 6.4.1 or above, or Hugs 2005xx or above.--The steps to install are:--1) ghc --make -o setup Setup.lhs--2) ./setup configure--3) ./setup build--4) ./setup install (as root)--If you're on Windows, you can omit the leading "./".--Documentation is in doc/ -- lots of information, including pointers to-drivers, is in doc/Database-HDBC.html.--USAGE--------To use with hugs, you'll want to use hugs -98.--To use with GHC, you'll want to use -package HDBC in your programs.-Or, with Cabal, use Build-Depends: HDBC.---- John Goerzen- December 2005
− testsrc/TestInfrastructure.hs
@@ -1,17 +0,0 @@-{--Copyright (C) 2009 John Goerzen <jgoerzen@complete.org>--All rights reserved.--For license and copyright information, see the file COPYRIGHT--}-module TestInfrastructure where-import qualified Test.QuickCheck as QC-import qualified Test.HUnit as HU-import Test.HUnit.Tools--q :: QC.Testable a => String -> a -> HU.Test-q = qc2hu 250--qverbose :: QC.Testable a => String -> a -> HU.Test-qverbose = qc2hu 250
testsrc/TestSqlValue.hs view
@@ -7,27 +7,25 @@ -} module TestSqlValue where-import TestInfrastructure import Test.QuickCheck hiding (Result) import Test.QuickCheck.Property (Result)-import Test.QuickCheck.Tools import qualified Test.HUnit as HU import Database.HDBC-import Data.Time.Format+import Data.Time.Format (parseTime) import Data.Time.LocalTime-import Database.HDBC.Locale (defaultTimeLocale, iso8601DateFormat)+import Database.HDBC.Locale (defaultTimeLocale, iso8601DateFormat, oldIso8601DateFormat) import Data.Maybe instance Eq ZonedTime where a == b = zonedTimeToUTC a == zonedTimeToUTC b && zonedTimeZone a == zonedTimeZone b -toSql_Int :: Int -> Result-toSql_Int x = toSql x @?= SqlInt64 (fromIntegral x)+toSql_Int :: Int -> Property+toSql_Int x = toSql x === SqlInt64 (fromIntegral x) -fromSql_Int :: Int -> Result+fromSql_Int :: Int -> Property fromSql_Int x = - Right x @=? safeFromSql (SqlInt64 (fromIntegral x))+ Right x === safeFromSql (SqlInt64 (fromIntegral x)) testZonedTimeStr = "1989-08-01 15:33:01 -0500" testZonedTime :: ZonedTime@@ -39,14 +37,25 @@ testZonedTimeFrac = fromJust $ parseTime defaultTimeLocale (iso8601DateFormat (Just "%T%Q %z")) testZonedTimeFracStr +testZonedTimeTwoDigitYearStr = "89-08-01 15:33:01 -0500"+testZonedTimeTwoDigitYear :: ZonedTime+testZonedTimeTwoDigitYear = fromJust $ parseTime defaultTimeLocale (oldIso8601DateFormat (Just "%T %z"))+ testZonedTimeTwoDigitYearStr+ ztparsenf = (HU.@=?) testZonedTime (fromSql (SqlString testZonedTimeStr)) ztparsef = (HU.@=?) testZonedTimeFrac (fromSql (SqlString testZonedTimeFracStr))+ztparseTwoDigitYear =+ (HU.@=?) testZonedTimeTwoDigitYear (fromSql (SqlString testZonedTimeTwoDigitYearStr)) hut msg = HU.TestLabel msg . HU.TestCase -allt = [q "toSql Int" toSql_Int,- q "safeFromSql Int" fromSql_Int,- hut "non-frac parse" ztparsenf,- hut "frac parse" ztparsef]+allHUnitTests = [hut "non-frac parse" ztparsenf,+ hut "frac parse" ztparsef,+ hut "old serialization of two digit year without leading zeros" ztparseTwoDigitYear+ ]++allQuickCheckTests = [toSql_Int,+ fromSql_Int+ ]
testsrc/runtests.hs view
@@ -1,14 +1,9 @@ module Main where import qualified Test.HUnit as HU-import Test.HUnit.Tools+import Test.QuickCheck (quickCheck) import qualified TestSqlValue -test1 = HU.TestCase ((HU.@=?) "x" "x")--alltests = [HU.TestLabel "test1" test1,- tl "TestSqlValue" TestSqlValue.allt- ]--main = do runVerboseTests (HU.TestList alltests)+main = do HU.runTestTT (HU.TestList $ TestSqlValue.allHUnitTests)+ traverse quickCheck TestSqlValue.allQuickCheckTests return ()