packages feed

HDBC-odbc (empty) → 1.0.1.0

raw patch · 32 files changed

+3137/−0 lines, 32 filesdep +HDBCdep +basedep +mtlbuild-type:Customsetup-changed

Dependencies added: HDBC, base, mtl, parsec

Files

+ COPYING view
@@ -0,0 +1,510 @@++                  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!++
@@ -0,0 +1,18 @@+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++Please see COPYING for the license.+
+ Database/HDBC/ODBC.hs view
@@ -0,0 +1,41 @@+{-+Copyright (C) 2005 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.ODBC+   Copyright  : Copyright (C) 2005 John Goerzen+   License    : GNU LGPL, version 2.1 or above++   Maintainer : John Goerzen <jgoerzen@complete.org>+   Stability  : provisional+   Portability: portable++HDBC driver interface for ODBC 3.x++Written by John Goerzen, jgoerzen\@complete.org+-}++module Database.HDBC.ODBC+    (+     connectODBC+    )++where++import Database.HDBC.ODBC.Connection(connectODBC)+
+ Database/HDBC/ODBC/Connection.hsc view
@@ -0,0 +1,228 @@+-- -*- mode: haskell; -*-+{-# CFILES hdbc-odbc-helper.c #-}+-- Above line for hugs+{-+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.ODBC.Connection (connectODBC) where++import Database.HDBC.Types+import Database.HDBC+import Database.HDBC.DriverUtils+import Database.HDBC.ODBC.Types+import Database.HDBC.ODBC.Statement+import Foreign.C.Types+import Foreign.C.String+import Foreign.Marshal+import Foreign.Storable+import Database.HDBC.ODBC.Utils+import Foreign.ForeignPtr+import Foreign.Ptr+import Data.Word+import Data.Int+import Control.Concurrent.MVar+import Control.Monad (when)++#ifdef mingw32_HOST_OS+#include <windows.h>+#endif+#include <sql.h>+#include <sqlext.h>++{- | Connect to an ODBC server.++For information on the meaning of the passed string, please see:++<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqldrivers.asp>++An example string is:++>"DSN=hdbctest1"++Important note for MySQL users:++Unless you are going to use InnoDB tables, you are strongly encouraged to set++>Option = 262144++in your odbc.ini (for Unix users), or to disable transaction support in your+DSN setup for Windows users.++If you fail to do this, the MySQL ODBC driver will incorrectly state that it+supports transactions.  dbTransactionSupport will incorrectly return True.+commit and rollback will then silently fail.  This is certainly /NOT/ what you+want.  It is a bug (or misfeature) in the MySQL driver, not in HDBC.++You should ignore this advice if you are using InnoDB tables.++-}+connectODBC :: String -> IO Connection+connectODBC args = withCStringLen args $ \(cs, cslen) -> +                   alloca $ \(penvptr::Ptr (Ptr CEnv)) ->+                   alloca $ \(pdbcptr::Ptr (Ptr CConn)) ->+         do -- Create the Environment Handle+            rc1 <- sqlAllocHandle #{const SQL_HANDLE_ENV}+                                  nullPtr -- #{const SQL_NULL_HANDLE}+                                   (castPtr penvptr)+            envptr <- peek penvptr ++            checkError "connectODBC/alloc env" (EnvHandle envptr) rc1+            sqlSetEnvAttr envptr #{const SQL_ATTR_ODBC_VERSION}+                             (getSqlOvOdbc3) 0++            -- Create the DBC handle.+            sqlAllocHandle #{const SQL_HANDLE_DBC} (castPtr envptr) +                               (castPtr pdbcptr)+                          >>= checkError "connectODBC/alloc dbc"+                                  (EnvHandle envptr)+            dbcptr <- peek pdbcptr+            wrappeddbcptr <- wrapconn dbcptr envptr nullPtr+            fdbcptr <- newForeignPtr sqlFreeHandleDbc_ptr wrappeddbcptr++            -- Now connect.+            sqlDriverConnect dbcptr nullPtr cs (fromIntegral cslen)+                             nullPtr 0 nullPtr+                             #{const SQL_DRIVER_COMPLETE}+                              >>= checkError "connectODBC/sqlDriverConnect" +                                  (DbcHandle dbcptr)+            mkConn args fdbcptr++-- FIXME: environment vars may have changed, should use pgsql enquiries+-- for clone.+mkConn :: String -> Conn -> IO Connection+mkConn args iconn = withConn iconn $ \cconn -> +                    alloca $ \plen ->+                    alloca $ \psqlusmallint ->+                    allocaBytes 128 $ \pbuf -> +    do +       children <- newMVar []+       sqlGetInfo cconn #{const SQL_DBMS_VER} (castPtr pbuf) 127 plen+         >>= checkError "sqlGetInfo SQL_DBMS_VER" (DbcHandle cconn)+       len <- peek plen+       serverver <- peekCStringLen (pbuf, fromIntegral len)++       sqlGetInfo cconn #{const SQL_DRIVER_VER} (castPtr pbuf) 127 plen+         >>= checkError "sqlGetInfo SQL_DRIVER_VER" (DbcHandle cconn)+       len <- peek plen+       proxiedclientver <- peekCStringLen (pbuf, fromIntegral len)++       sqlGetInfo cconn #{const SQL_ODBC_VER} (castPtr pbuf) 127 plen+         >>= checkError "sqlGetInfo SQL_ODBC_VER" (DbcHandle cconn)+       len <- peek plen+       clientver <- peekCStringLen (pbuf, fromIntegral len)++       sqlGetInfo cconn #{const SQL_DBMS_NAME} (castPtr pbuf) 127 plen+         >>= checkError "sqlGetInfo SQL_DBMS_NAME" (DbcHandle cconn)+       len <- peek plen+       clientname <- peekCStringLen (pbuf, fromIntegral len)++       sqlGetInfo cconn #{const SQL_TXN_CAPABLE} (castPtr psqlusmallint)+                      0 nullPtr+         >>= checkError "sqlGetInfo SQL_TXN_CAPABLE" (DbcHandle cconn)+       txninfo <- ((peek psqlusmallint)::IO (#{type SQLUSMALLINT}))+       let txnsupport = txninfo /= #{const SQL_TC_NONE}++       when txnsupport+         (disableAutoCommit cconn+          >>= checkError "sqlSetConnectAttr" (DbcHandle cconn)+         )+       return $ Connection {+                            disconnect = fdisconnect iconn children,+                            commit = fcommit iconn,+                            rollback = frollback iconn,+                            run = frun iconn children,+                            prepare = newSth iconn children,+                            clone = connectODBC args,+                            -- FIXME: add clone+                            hdbcDriverName = "odbc",+                            hdbcClientVer = clientver,+                            proxiedClientName = clientname,+                            proxiedClientVer = proxiedclientver,+                            dbServerVer = serverver,+                            dbTransactionSupport = txnsupport,+                            getTables = fgettables iconn,+                            describeTable = fdescribetable iconn+                           }++--------------------------------------------------+-- Guts here+--------------------------------------------------++frun conn children query args =+    do sth <- newSth conn children query+       res <- execute sth args+       finish sth+       return res++fcommit iconn = withConn iconn $ \cconn ->+    sqlEndTran #{const SQL_HANDLE_DBC} cconn #{const SQL_COMMIT}+    >>= checkError "sqlEndTran commit" (DbcHandle cconn)++frollback iconn = withConn iconn $ \cconn ->+    sqlEndTran #{const SQL_HANDLE_DBC} cconn #{const SQL_ROLLBACK}+    >>= checkError "sqlEndTran rollback" (DbcHandle cconn)++fdisconnect iconn mchildren  = withRawConn iconn $ \rawconn -> +                               withConn iconn $ \llconn ->+    do closeAllChildren mchildren+       res <- sqlFreeHandleDbc_app rawconn+       -- FIXME: will this checkError segfault?+       checkError "disconnect" (DbcHandle $ llconn) res++foreign import ccall unsafe "sql.h SQLAllocHandle"+  sqlAllocHandle :: #{type SQLSMALLINT} -> Ptr () -> +                    Ptr () -> IO (#{type SQLRETURN})++foreign import ccall unsafe "hdbc-odbc-helper.h wrapobjodbc_extra"+  wrapconn :: Ptr CConn -> Ptr CEnv -> Ptr WrappedCConn -> IO (Ptr WrappedCConn)++foreign import ccall unsafe "hdbc-odbc-helper.h &sqlFreeHandleDbc_finalizer"+  sqlFreeHandleDbc_ptr :: FunPtr (Ptr WrappedCConn -> IO ())++foreign import ccall unsafe "hdbc-odbc-helper.h sqlFreeHandleDbc_app"+  sqlFreeHandleDbc_app :: Ptr WrappedCConn -> IO (#{type SQLRETURN})++foreign import ccall unsafe "sql.h SQLSetEnvAttr"+  sqlSetEnvAttr :: Ptr CEnv -> #{type SQLINTEGER} -> +                   Ptr () -> #{type SQLINTEGER} -> IO #{type SQLRETURN}++foreign import ccall unsafe "sql.h SQLDriverConnect"+  sqlDriverConnect :: Ptr CConn -> Ptr () -> CString -> #{type SQLSMALLINT}+                   -> CString -> #{type SQLSMALLINT}+                   -> Ptr #{type SQLSMALLINT} -> #{type SQLUSMALLINT}+                   -> IO #{type SQLRETURN}++foreign import ccall unsafe "hdbc-odbc-helper.h getSqlOvOdbc3"+  getSqlOvOdbc3 :: Ptr ()++foreign import ccall unsafe "hdbc-odbc-helper.h SQLSetConnectAttr"+  sqlSetConnectAttr :: Ptr CConn -> #{type SQLINTEGER} +                    -> Ptr #{type SQLUINTEGER} -> #{type SQLINTEGER}+                    -> IO #{type SQLRETURN}++foreign import ccall unsafe "sql.h SQLEndTran"+  sqlEndTran :: #{type SQLSMALLINT} -> Ptr CConn -> #{type SQLSMALLINT}+             -> IO #{type SQLRETURN}++foreign import ccall unsafe "hdbc-odbc-helper.h disableAutoCommit"+  disableAutoCommit :: Ptr CConn -> IO #{type SQLRETURN}++foreign import ccall unsafe "sql.h SQLGetInfo"+  sqlGetInfo :: Ptr CConn -> #{type SQLUSMALLINT} -> Ptr () ->+                #{type SQLSMALLINT} -> Ptr #{type SQLSMALLINT} ->+                IO #{type SQLRETURN}
+ Database/HDBC/ODBC/Statement.hsc view
@@ -0,0 +1,392 @@+-- -*- mode: haskell; -*-+{-# CFILES hdbc-odbc-helper.c #-}+-- Above line for hugs+{-+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.ODBC.Statement where+import Database.HDBC.Types+import Database.HDBC+import Database.HDBC.DriverUtils+import Database.HDBC.ODBC.Types+import Database.HDBC.ODBC.Utils+import Database.HDBC.ODBC.TypeConv+import Foreign.C.Types+import Foreign.ForeignPtr+import Foreign.Ptr+import Control.Concurrent.MVar+import Foreign.C.String+import Foreign.Marshal+import Foreign.Storable+import Control.Monad+import Data.List+import Data.Word+import Data.Int+import Control.Exception+import System.IO+import Data.Maybe++l _ = return ()+--l m = hPutStrLn stderr ("\n" ++ m)++#ifdef mingw32_HOST_OS+#include <windows.h>+#endif+#include <sql.h>+#include <sqlext.h>++data SState = +    SState { stomv :: MVar (Maybe Stmt),+             dbo :: Conn,+             squery :: String,+             colinfomv :: MVar [(String, SqlColDesc)]}++-- FIXME: we currently do no prepare optimization whatsoever.++newSState :: Conn -> String -> IO SState+newSState indbo query =+    do newstomv <- newMVar Nothing+       newcolinfomv <- newMVar []+       return SState {stomv = newstomv, +                      dbo = indbo, squery = query,+                      colinfomv = newcolinfomv}++wrapStmt :: SState -> Statement+wrapStmt sstate =+    Statement {execute = fexecute sstate,+                           executeMany = fexecutemany sstate,+                           finish = public_ffinish sstate,+                           fetchRow = ffetchrow sstate,+                           originalQuery = (squery sstate),+                           getColumnNames = readMVar (colinfomv sstate)+                                            >>= (return . map fst),+                           describeResult = readMVar (colinfomv sstate)}++newSth :: Conn -> ChildList -> String -> IO Statement               +newSth indbo mchildren query = +    do l "in newSth"+       sstate <- newSState indbo query+       let retval = wrapStmt sstate+       addChild mchildren retval+       return retval++makesth iconn name = alloca $ \(psthptr::Ptr (Ptr CStmt)) ->+                     withConn iconn $ \cconn -> +                     withCString "" $ \emptycs ->+    do rc1 <- sqlAllocStmtHandle #{const SQL_HANDLE_STMT} cconn psthptr+       sthptr <- peek psthptr+       wrappedsthptr <- withRawConn iconn+                        (\rawconn -> wrapstmt sthptr rawconn)+       fsthptr <- newForeignPtr sqlFreeHandleSth_ptr wrappedsthptr+       checkError (name ++ " allocHandle") (DbcHandle cconn) rc1+       return fsthptr++wrapTheStmt iconn fsthptr =+    do sstate <- newSState iconn ""+       sstate <- newSState iconn ""+       swapMVar (stomv sstate) (Just fsthptr)+       let sth = wrapStmt sstate+       return sth++fgettables iconn =+    do fsthptr <- makesth iconn "fgettables"+       withStmt fsthptr (\sthptr ->+                             simpleSqlTables sthptr >>=+                                checkError "gettables simpleSqlTables" +                                               (StmtHandle sthptr)+                        )+       sth <- wrapTheStmt iconn fsthptr+       results <- fetchAllRows sth+       l (show results)+       return $ map (\x -> fromSql (x !! 2)) results++fdescribetable iconn tablename = withCStringLen tablename $ \(cs, csl) ->+    do fsthptr <- makesth iconn "fdescribetable"+       withStmt fsthptr (\sthptr ->+                             simpleSqlColumns sthptr cs (fromIntegral csl) >>=+                               checkError "fdescribetable simpleSqlColumns"+                                          (StmtHandle sthptr)+                        )+       sth <- wrapTheStmt iconn fsthptr+       results <- fetchAllRows sth+       l (show results)+       return $ map fromOTypeCol results++{- For now, we try to just  handle things as simply as possible.+FIXME lots of room for improvement here (types, etc). -}+fexecute sstate args = withConn (dbo sstate) $ \cconn ->+                       withCStringLen (squery sstate) $ \(cquery, cqlen) ->+                       alloca $ \(psthptr::Ptr (Ptr CStmt)) ->+    do l "in fexecute"+       public_ffinish sstate  +       rc1 <- sqlAllocStmtHandle #{const SQL_HANDLE_STMT} cconn psthptr+       sthptr <- peek psthptr+       wrappedsthptr <- withRawConn (dbo sstate)+                        (\rawconn -> wrapstmt sthptr rawconn)+       fsthptr <- newForeignPtr sqlFreeHandleSth_ptr wrappedsthptr+       checkError "execute allocHandle" (DbcHandle cconn) rc1++       sqlPrepare sthptr cquery (fromIntegral cqlen) >>= +            checkError "execute prepare" (StmtHandle sthptr)++       argsToFree <- zipWithM (bindCol sthptr) args [1..]++       r <- sqlExecute sthptr+            +       -- Our bound columns must be valid through this point,+       -- but we don't care after here.+       mapM (\(x, y) -> touchForeignPtr x >> touchForeignPtr y)+                (concat argsToFree) ++       case r of+         #{const SQL_NO_DATA} -> return () -- Update that did nothing+         x -> checkError "execute execute" (StmtHandle sthptr) x++       rc <- getNumResultCols sthptr+       +       case rc of+         0 -> do rowcount <- getSqlRowCount sthptr+                 ffinish fsthptr+                 swapMVar (colinfomv sstate) []+                 touchForeignPtr fsthptr+                 return (fromIntegral rowcount)+         colcount -> do fgetcolinfo sthptr >>= swapMVar (colinfomv sstate)+                        swapMVar (stomv sstate) (Just fsthptr)+                        touchForeignPtr fsthptr+                        return 0++getNumResultCols sthptr = alloca $ \pcount ->+    do sqlNumResultCols sthptr pcount >>= checkError "SQLNumResultCols" +                                          (StmtHandle sthptr)+       peek pcount+    +-- Bind a parameter column before execution.++bindCol sthptr arg icol =  alloca $ \pdtype ->+                           alloca $ \pcolsize ->+                           alloca $ \pdecdigits ->+{- We have to start by getting the SQL type of the column so we can+   send the correct type back to the server.  Sigh.  If the ODBC+   backend won't tell us the type, we fake it.++   We've got an annoying situation with error handling.  Must make+   sure that all data is freed, but if there's an error, we have to raise+   it and the caller never gets to freed the allocated data to-date.+   So, make sure we either free of have foreignized everything before+   control passes out of this function. -}++    do rc1 <- sqlDescribeParam sthptr icol pdtype pcolsize pdecdigits+                      nullPtr+       when (not (isOK rc1)) $ -- Some drivers don't support that call+          do poke pdtype #{const SQL_CHAR}+             poke pcolsize 0+             poke pdecdigits 0+       coltype <- peek pdtype+       colsize <- peek pcolsize+       decdigits <- peek pdecdigits+       case arg of+         SqlNull -> -- NULL parameter, bind it as such.+                    do rc2 <- sqlBindParameter sthptr (fromIntegral icol)+                              #{const SQL_PARAM_INPUT}+                              #{const SQL_CHAR} coltype colsize decdigits+                              nullPtr 0 nullData+                       checkError ("bindparameter " ++ show icol)+                                      (StmtHandle sthptr) rc2+                       return []+         x -> do -- Otherwise, we have to allocate RAM, make sure it's+                 -- not freed now, and pass it along...+                  (csptr, cslen) <- newCStringLen (fromSql x)+                  do pcslen <- malloc +                     poke pcslen (fromIntegral cslen)+                     rc2 <- sqlBindParameter sthptr (fromIntegral icol)+                       #{const SQL_PARAM_INPUT}+                       #{const SQL_CHAR} coltype colsize decdigits+                       csptr (fromIntegral cslen + 1) pcslen+                     if isOK rc2+                        then do -- We bound it.  Make foreignPtrs and return.+                                fp1 <- newForeignPtr finalizerFree pcslen+                                fp2 <- newForeignPtr finalizerFree csptr+                                return [(fp1, fp2)]+                        else do -- Binding failed.  Free the data and raise+                                -- error.+                                free pcslen+                                free csptr+                                checkError ("bindparameter " ++ show icol) +                                               (StmtHandle sthptr) rc2+                                return [] -- will never get hit+       +getSqlRowCount cstmt = alloca $ \prows ->+     do sqlRowCount cstmt prows >>= checkError "SQLRowCount" (StmtHandle cstmt)+        peek prows++{- General algorithm: find out how many columns we have, check the type+of each to see if it's NULL.  If it's not, fetch it as text and return that.+-}++ffetchrow :: SState -> IO (Maybe [SqlValue])+ffetchrow sstate = modifyMVar (stomv sstate) $ \stmt -> +             case stmt of+               Nothing -> l "ffr nos" >> return (stmt, Nothing)+               Just cmstmt -> withStmt cmstmt $ \cstmt ->+                 do rc <- sqlFetch cstmt+                    if rc == #{const SQL_NO_DATA}+                       then do l "no more rows"+                               -- Don't use public_ffinish here+                               ffinish cmstmt+                               return (Nothing, Nothing)+                       else do l "getting stuff"+                               checkError "sqlFetch" (StmtHandle cstmt) rc+                               ncols <- getNumResultCols cstmt+                               res <- mapM (getCol cstmt ) +                                      [1..ncols]+                               return (stmt, Just res)+    where getCol cstmt icol = alloca $ \psize ->+             do sqlDescribeCol cstmt icol nullPtr 0 nullPtr nullPtr+                               psize nullPtr nullPtr+                               >>= checkError "sqlDescribeCol" +                                       (StmtHandle cstmt)+                size <- peek psize+                l $ "colsize: " ++ show size+                let bufsize = size + 127 -- Try to give extra space+                alloca $ \plen -> +                 allocaBytes (fromIntegral bufsize + 1) $ \cs ->+                   do sqlGetData cstmt (fromIntegral icol) #{const SQL_CHAR} +                                 cs (fromIntegral bufsize) plen+                      reslen <- peek plen+                      case reslen of+                        #{const SQL_NULL_DATA} -> return SqlNull+                        #{const SQL_NO_TOTAL} -> fail $ "Unexpected SQL_NO_TOTAL"+                        len -> do s <- peekCStringLen (cs, fromIntegral len)+                                  l $ "col is: " ++ s+                                  return (SqlString s)+++fgetcolinfo cstmt =+    do ncols <- getNumResultCols cstmt+       mapM getname [1..ncols]+    where getname icol = alloca $ \colnamelp ->+                         allocaBytes 128 $ \cscolname ->+                         alloca $ \datatypeptr ->+                         alloca $ \colsizeptr ->+                         alloca $ \nullableptr ->+              do sqlDescribeCol cstmt icol cscolname 127 colnamelp +                                datatypeptr colsizeptr nullPtr nullableptr+                 colnamelen <- peek colnamelp+                 colname <- peekCStringLen (cscolname, fromIntegral colnamelen)+                 datatype <- peek datatypeptr+                 colsize <- peek colsizeptr+                 nullable <- peek nullableptr+                 return $ fromOTypeInfo colname datatype colsize nullable++-- FIXME: needs a faster algorithm.+fexecutemany :: SState -> [[SqlValue]] -> IO ()+fexecutemany sstate arglist =+    mapM_ (fexecute sstate) arglist >> return ()++-- Finish and change state+public_ffinish sstate = +    do l "public_ffinish"+       modifyMVar_ (stomv sstate) worker+    where worker Nothing = return Nothing+          worker (Just sth) = ffinish sth >> return Nothing++ffinish :: Stmt -> IO ()+ffinish p = withRawStmt p $ sqlFreeHandleSth_app +++foreign import ccall unsafe "hdbc-odbc-helper.h wrapobjodbc"+  wrapstmt :: Ptr CStmt -> Ptr WrappedCConn -> IO (Ptr WrappedCStmt)++foreign import ccall unsafe "sql.h SQLDescribeCol"+  sqlDescribeCol :: Ptr CStmt   +                 -> #{type SQLSMALLINT} -- ^ Column number+                 -> CString     -- ^ Column name+                 -> #{type SQLSMALLINT} -- ^ Buffer length+                 -> Ptr (#{type SQLSMALLINT}) -- ^ name length ptr+                 -> Ptr (#{type SQLSMALLINT}) -- ^ data type ptr+                 -> Ptr (#{type SQLUINTEGER}) -- ^ column size ptr+                 -> Ptr (#{type SQLSMALLINT}) -- ^ decimal digits ptr+                 -> Ptr (#{type SQLSMALLINT}) -- ^ nullable ptr+                 -> IO #{type SQLRETURN}++foreign import ccall unsafe "sql.h SQLGetData"+  sqlGetData :: Ptr CStmt       -- ^ statement handle+             -> #{type SQLUSMALLINT} -- ^ Column number+             -> #{type SQLSMALLINT} -- ^ target type+             -> CString -- ^ target value pointer (void * in C)+             -> #{type SQLINTEGER} -- ^ buffer len+             -> Ptr (#{type SQLINTEGER})+             -> IO #{type SQLRETURN}++foreign import ccall unsafe "hdbc-odbc-helper.h sqlFreeHandleSth_app"+  sqlFreeHandleSth_app :: Ptr WrappedCStmt -> IO ()++foreign import ccall unsafe "hdbc-odbc-helper.h &sqlFreeHandleSth_finalizer"+  sqlFreeHandleSth_ptr :: FunPtr (Ptr WrappedCStmt -> IO ())++foreign import ccall unsafe "sql.h SQLPrepare"+  sqlPrepare :: Ptr CStmt -> CString -> #{type SQLINTEGER} +             -> IO #{type SQLRETURN}++foreign import ccall unsafe "sql.h SQLExecute"+  sqlExecute :: Ptr CStmt -> IO #{type SQLRETURN}++foreign import ccall unsafe "sql.h SQLAllocHandle"+  sqlAllocStmtHandle :: #{type SQLSMALLINT} -> Ptr CConn ->+                        Ptr (Ptr CStmt) -> IO #{type SQLRETURN}++foreign import ccall unsafe "sql.h SQLNumResultCols"+  sqlNumResultCols :: Ptr CStmt -> Ptr #{type SQLSMALLINT} +                   -> IO #{type SQLRETURN}++foreign import ccall unsafe "sql.h SQLRowCount"+  sqlRowCount :: Ptr CStmt -> Ptr #{type SQLINTEGER} -> IO #{type SQLRETURN}++foreign import ccall unsafe "sql.h SQLBindParameter"+  sqlBindParameter :: Ptr CStmt -- ^ Statement handle+                   -> #{type SQLUSMALLINT} -- ^ Parameter Number+                   -> #{type SQLSMALLINT} -- ^ Input or output+                   -> #{type SQLSMALLINT} -- ^ Value type+                   -> #{type SQLSMALLINT} -- ^ Parameter type+                   -> #{type SQLUINTEGER} -- ^ column size+                   -> #{type SQLSMALLINT} -- ^ decimal digits+                   -> CString   -- ^ Parameter value pointer+                   -> #{type SQLINTEGER} -- ^ buffer length+                   -> Ptr #{type SQLINTEGER} -- ^ strlen_or_indptr+                   -> IO #{type SQLRETURN}++foreign import ccall unsafe "hdbc-odbc-helper.h &nullData"+  nullData :: Ptr #{type SQLINTEGER}++foreign import ccall unsafe "sql.h SQLDescribeParam"+  sqlDescribeParam :: Ptr CStmt +                   -> #{type SQLUSMALLINT} -- ^ parameter number+                   -> Ptr #{type SQLSMALLINT} -- ^ data type ptr+                   -> Ptr #{type SQLUINTEGER} -- ^ parameter size ptr+                   -> Ptr #{type SQLSMALLINT} -- ^ dec digits ptr+                   -> Ptr #{type SQLSMALLINT} -- ^ nullable ptr+                   -> IO #{type SQLRETURN}++foreign import ccall unsafe "sql.h SQLFetch"+  sqlFetch :: Ptr CStmt -> IO #{type SQLRETURN}++foreign import ccall unsafe "hdbc-odbc-helper.h simpleSqlTables"+  simpleSqlTables :: Ptr CStmt -> IO #{type SQLRETURN}++foreign import ccall unsafe "hdbc-odbc-helper.h simpleSqlColumns"+  simpleSqlColumns :: Ptr CStmt -> Ptr CChar -> +                      #{type SQLSMALLINT} -> IO #{type SQLRETURN}
+ Database/HDBC/ODBC/TypeConv.hsc view
@@ -0,0 +1,119 @@+-- -*- mode: haskell; -*-+{-# CFILES hdbc-odbc-helper.c #-}+-- Above line for hugs+{-+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.ODBC.TypeConv(fromOTypeInfo, fromOTypeCol) where+import Database.HDBC.Types+import Database.HDBC+import Database.HDBC.DriverUtils+import Database.HDBC.ODBC.Types+import Database.HDBC.ODBC.Utils+import Foreign.C.Types+import Foreign.ForeignPtr+import Foreign.Ptr+import Control.Concurrent.MVar+import Foreign.C.String+import Foreign.Marshal+import Foreign.Storable+import Control.Monad+import Data.List+import Data.Word+import Data.Int+import Control.Exception+import System.IO+import Data.Maybe++l _ = return ()+--l m = hPutStrLn stderr ("\n" ++ m)++#ifdef mingw32_HOST_OS+#include <windows.h>+#endif+#include <sql.h>+#include <sqlext.h>+#include <sqlucode.h>++fromOTypeInfo :: String         -- ^ Column name+              -> #{type SQLSMALLINT} -- ^ Data type+              -> #{type SQLUINTEGER} -- ^ Column size+              -> #{type SQLSMALLINT} -- ^ Is it nullable+              -> (String, SqlColDesc)+fromOTypeInfo colname datatype colsize nullable =+    (colname,+     SqlColDesc {colType = convdatatype datatype,+                 colOctetLength = Nothing,+                 colDecDigits = Nothing,+                 colSize = Just (fromIntegral colsize),+                 colNullable = case nullable of+                                 #{const SQL_NO_NULLS} -> Just False+                                 #{const SQL_NULLABLE} -> Just True+                                 _ -> Nothing+                }+    )++fromOTypeCol (_:_:_:colname:datatype:_:colsize:buflen:decdig:precrad:nullable:_:_:_:subtype:octetlen:_) =+    fromOTypeInfo (fromSql colname)+                  (fromIntegral ((fromSql datatype)::Int))+                  (fromSql colsize)+                  (fromIntegral ((fromSql nullable)::Int))+fromOTypeCol x = error $ "fromOTypeCol: unexpected result set: " ++ show x++convdatatype :: #{type SQLSMALLINT} -> SqlTypeId+convdatatype intype =+    case intype of+      #{const SQL_CHAR} -> SqlCharT+      #{const SQL_VARCHAR} -> SqlVarCharT+      #{const SQL_LONGVARCHAR} -> SqlLongVarCharT+      #{const SQL_WCHAR} -> SqlWCharT+      #{const SQL_WVARCHAR} -> SqlWVarCharT+      #{const SQL_WLONGVARCHAR} -> SqlWLongVarCharT+      #{const SQL_DECIMAL} -> SqlDecimalT+      #{const SQL_NUMERIC} -> SqlNumericT+      #{const SQL_SMALLINT} -> SqlSmallIntT+      #{const SQL_INTEGER} -> SqlIntegerT+      #{const SQL_REAL} -> SqlRealT+      #{const SQL_FLOAT} -> SqlFloatT+      #{const SQL_DOUBLE} -> SqlDoubleT+      #{const SQL_BIT} -> SqlBitT+      #{const SQL_TINYINT} -> SqlTinyIntT+      #{const SQL_BIGINT} -> SqlBigIntT+      #{const SQL_BINARY} -> SqlBinaryT+      #{const SQL_VARBINARY} -> SqlVarBinaryT+      #{const SQL_LONGVARBINARY} -> SqlLongVarBinaryT+      #{const SQL_TYPE_DATE} -> SqlDateT+      #{const SQL_TYPE_TIME} -> SqlTimeT+      #{const SQL_TYPE_TIMESTAMP} -> SqlTimestampT+      -- ODBC libraries don't seem to define the UTC items+      -- #{const SQL_TYPE_UTCDATETIME} -> SqlUTCDateTimeT+      -- #{const SQL_TYPE_UTCTIME} -> SqlUTCTimeT+      #{const SQL_INTERVAL_MONTH} -> SqlIntervalT SqlIntervalMonthT+      #{const SQL_INTERVAL_YEAR} -> SqlIntervalT SqlIntervalYearT+      #{const SQL_INTERVAL_YEAR_TO_MONTH} -> SqlIntervalT SqlIntervalYearToMonthT+      #{const SQL_INTERVAL_DAY} -> SqlIntervalT SqlIntervalDayT+      #{const SQL_INTERVAL_HOUR} -> SqlIntervalT SqlIntervalHourT+      #{const SQL_INTERVAL_MINUTE} -> SqlIntervalT SqlIntervalMinuteT+      #{const SQL_INTERVAL_SECOND} -> SqlIntervalT SqlIntervalSecondT+      #{const SQL_INTERVAL_DAY_TO_HOUR} -> SqlIntervalT SqlIntervalDayToHourT+      #{const SQL_INTERVAL_DAY_TO_MINUTE} -> SqlIntervalT SqlIntervalDayToMinuteT+      #{const SQL_INTERVAL_DAY_TO_SECOND} -> SqlIntervalT SqlIntervalDayToSecondT+      #{const SQL_INTERVAL_HOUR_TO_MINUTE} -> SqlIntervalT SqlIntervalHourToMinuteT+      #{const SQL_INTERVAL_HOUR_TO_SECOND} -> SqlIntervalT SqlIntervalHourToSecondT+      #{const SQL_INTERVAL_MINUTE_TO_SECOND} -> SqlIntervalT SqlIntervalMinuteToSecondT+      #{const SQL_GUID} -> SqlGUIDT+      x -> SqlUnknownT (show x)
+ Database/HDBC/ODBC/Types.hs view
@@ -0,0 +1,24 @@+module Database.HDBC.ODBC.Types+where++import Foreign.ForeignPtr+import Foreign++-- This may be wrong -- is SqlHandle always a pointer to something?+-- but it works with hsql so I'm going to use it here until I hear of it+-- breaking.+--newtype SqlHandle = Ptr ()++data CEnv = CEnv+type WrappedCEnv = Ptr CEnv+type Env = ForeignPtr WrappedCEnv++data CConn = CConn+type WrappedCConn = Ptr CConn+type Conn = ForeignPtr WrappedCConn++data CStmt = CStmt+type WrappedCStmt = Ptr CStmt+type Stmt = ForeignPtr WrappedCStmt++
+ Database/HDBC/ODBC/Utils.hsc view
@@ -0,0 +1,141 @@+{- -*- mode: haskell; -*- +Copyright (C) 2005 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.ODBC.Utils where+import Foreign.C.String+import Foreign.ForeignPtr+import Foreign.Ptr+import Data.Int+import Database.HDBC.Types+import Database.HDBC.ODBC.Types+import Foreign.C.Types+import Control.Exception+import Foreign.Storable+import Foreign.Marshal.Array+import Foreign.Marshal.Alloc+import Data.Word++#ifdef mingw32_HOST_OS+#include <windows.h>+#endif+#include "hdbc-odbc-helper.h"++data SqlHandleT = EnvHandle (Ptr CEnv)+               | DbcHandle (Ptr CConn)+               | StmtHandle (Ptr CStmt)++checkError :: String -> SqlHandleT -> #{type SQLRETURN} -> IO ()+checkError msg o res =+        do let rc = sqlSucceeded res+           if rc == 0+               then raiseError msg res o+               else return ()++raiseError :: String -> #{type SQLRETURN} -> SqlHandleT -> IO a+raiseError msg code cconn =+    do info <- getdiag ht hp 1 +       throwDyn $ SqlError {seState = show (map fst info),+                            seNativeError = fromIntegral code,+                            seErrorMsg = msg ++ ": " ++  +                                         show (map snd info)}+       where (ht, hp::(Ptr ())) = case cconn of+                          EnvHandle c -> (#{const SQL_HANDLE_ENV}, castPtr c)+                          DbcHandle c -> (#{const SQL_HANDLE_DBC}, castPtr c)+                          StmtHandle c -> (#{const SQL_HANDLE_STMT}, castPtr c)+             getdiag ht hp irow = allocaBytes 6 $ \csstate ->+                                  alloca $ \pnaterr ->+                                  allocaBytes 1025 $ \csmsg ->+                                  alloca $ \pmsglen ->+                 do ret <- sqlGetDiagRec ht hp irow csstate pnaterr+                           csmsg 1024 pmsglen+                    if sqlSucceeded ret == 0+                       then return []+                       else do state <- peekCStringLen (csstate, 5)+                               nat <- peek pnaterr+                               msglen <- peek pmsglen+                               msg <- peekCStringLen (csmsg, +                                                      fromIntegral msglen)+                               next <- getdiag ht hp (irow + 1)+                               return $ (state, +                                         (show nat) ++ ": " ++ msg) : next++{- This is a little hairy.++We have a Conn object that is actually a finalizeonce wrapper around+the real object.  We use withConn to dereference the foreign pointer,+and then extract the pointer to the real object from the finalizeonce struct.++But, when we close the connection, we need the finalizeonce struct, so that's+done by withRawConn.++Ditto for statements. -}++withConn :: Conn -> (Ptr CConn -> IO b) -> IO b+withConn = genericUnwrap++withRawConn :: Conn -> (Ptr WrappedCConn -> IO b) -> IO b+withRawConn = withForeignPtr++withStmt :: Stmt -> (Ptr CStmt -> IO b) -> IO b+withStmt = genericUnwrap++withRawStmt :: Stmt -> (Ptr WrappedCStmt -> IO b) -> IO b+withRawStmt = withForeignPtr++withEnv :: Env -> (Ptr CEnv -> IO b) -> IO b+withEnv = genericUnwrap++withRawEnv :: Env -> (Ptr WrappedCEnv -> IO b) -> IO b+withRawEnv = withForeignPtr++withCStringArr0 :: [SqlValue] -> (Ptr CString -> IO a) -> IO a+withCStringArr0 inp action = withAnyArr0 convfunc freefunc inp action+    where convfunc SqlNull = return nullPtr+          convfunc x = newCString (fromSql x)+          freefunc x =+              if x == nullPtr+                 then return ()+                 else free x++withAnyArr0 :: (a -> IO (Ptr b)) -- ^ Function that transforms input data into pointer+            -> (Ptr b -> IO ())  -- ^ Function that frees generated data+            -> [a]               -- ^ List of input data+            -> (Ptr (Ptr b) -> IO c) -- ^ Action to run with the C array+            -> IO c             -- ^ Return value+withAnyArr0 input2ptract freeact inp action =+    bracket (mapM input2ptract inp)+            (\clist -> mapM_ freeact clist)+            (\clist -> withArray0 nullPtr clist action)+++genericUnwrap :: ForeignPtr (Ptr a) -> (Ptr a -> IO b) -> IO b+genericUnwrap fptr action = withForeignPtr fptr (\structptr ->+    do objptr <- #{peek finalizeonce, encapobj} structptr+       action objptr+                                                )+isOK :: #{type SQLRETURN} -> Bool+isOK r = sqlSucceeded r /= 0++foreign import ccall unsafe "sqlSucceeded"+  sqlSucceeded :: #{type SQLRETURN} -> CInt++foreign import ccall unsafe "sql.h SQLGetDiagRec"+  sqlGetDiagRec :: #{type SQLSMALLINT} -> Ptr () -> +                   #{type SQLSMALLINT} -> CString -> Ptr (#{type SQLINTEGER})+                   -> CString -> #{type SQLSMALLINT} +                   -> Ptr (#{type SQLSMALLINT}) -> IO #{type SQLRETURN}
+ HDBC-odbc.cabal view
@@ -0,0 +1,21 @@+-- Extra-Libraries: odbc     -- handled via Setup.hs in its buildinfo file+include-dirs: .+-- extra-lib-dirs: +Name: HDBC-odbc+Version: 1.0.1.0+License: LGPL+Maintainer: John Goerzen <jgoerzen@complete.org>+Stability: Alpha+Copyright: Copyright (c) 2005-2006 John Goerzen+Exposed-Modules: Database.HDBC.ODBC+Other-Modules: Database.HDBC.ODBC.Connection,+ Database.HDBC.ODBC.Statement,+ Database.HDBC.ODBC.Types,+ Database.HDBC.ODBC.Utils,+ Database.HDBC.ODBC.TypeConv+--Extensions: ExistentialQuantification, AllowOverlappingInstances,+--    AllowUndecidableInstances, CPP+Extensions: ExistentialQuantification+Build-Depends: base, mtl, HDBC>=1.0.0, parsec+GHC-Options: -O2+C-Sources: hdbc-odbc-helper.c
+ Makefile view
@@ -0,0 +1,56 @@+# Copyright (C) 2004 - 2005 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++GHCPARMS := -fglasgow-exts++.PHONY: all hugsbuild+all: setup			# GHC build+	./setup configure --user+	./setup build++hugsbuild: setup+	./setup configure --hugs+	./setup build++setup: Setup.hs HDBC-odbc.cabal+	ghc -package Cabal Setup.hs -o setup++clean:+	-./setup clean+	-rm -rf html `find . -name "*.o"` `find . -name "*.hi"` \+		`find . -name "*~"` *.a setup dist testsrc/runtests \+		local-pkg doctmp *.buildinfo+	-rm -rf testtmp/* testtmp*++testsrc/runtests: all $(wildcard testsrc/*.hs) $(wildcard testsrc/*/*.hs) $(wildcard testsrc/*/*/*.hs)+	cd testsrc && ghc --make -package mtl -package HUnit -package MissingH -package HDBC -lodbc $(GHCPARMS) -o runtests  -i../dist/build:.. ../dist/build/hdbc-odbc-helper.o runtests.hs++test-ghc6: testsrc/runtests+	testsrc/runtests++test-hugs: hugsbuild+	runhugs -98 +o -P$(PWD)/dist/build:$(PWD)/testsrc: testsrc/runtests.hs++interact-hugs:+	hugs -98 +o -P$(PWD)/dist/build:++interact-ghci: all+	ghci -idist/build -Ldist/build $(GHCPARMS)++interact: interact-hugs++test: test-ghc6 test-hugs+
+ README.txt view
@@ -0,0 +1,97 @@+Welcome to HDBC, Haskell Database Connectivity.++This package provides a database backend driver for ODBC.  You should+be able to use any ODBC front-end with it.++Please see HDBC itself for documentation on use.  If you don't already+have it, you can browse this documentation at+http://darcs.complete.org/hdbc/doc/index.html.++This package provides one function in module Database.HDBC.ODBC:++{- | Connect to an ODBC server.++For information on the meaning of the passed string, please see:++<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqldrivers.asp>++An example string is:++>"DSN=hdbctest1"++-}+connectODBC :: String -> IO Connection++DIFFERENCES FROM HDBC STANDARD+------------------------------++None known at this time.++MYSQL NOTE+----------++Important note for MySQL users:++Unless you are going to use InnoDB tables, you are strongly encouraged to set++Option = 262144++in your odbc.ini (for Unix users), or to disable transaction support in your+DSN setup for Windows users.++If you fail to do this, the MySQL ODBC driver will incorrectly state that it+supports transactions.  dbTransactionSupport will incorrectly return True.+commit and rollback will then silently fail.  This is certainly /NOT/ what you+want.  It is a bug (or misfeature) in the MySQL driver, not in HDBC.++You should ignore this advice if you are using InnoDB tables.++PREREQUISITES+-------------++Before installing this package, you'll need to have HDBC 0.99.2 or+above installed.  You can download HDBC from+http://quux.org/devel/hdbc.++You'll need either GHC 6.4.1 or above, or Hugs 2005xx or above.  If+you're using Hugs, you'll also need cpphs (see+http://www.cs.york.ac.uk/fp/cpphs/ if you don't already have it).++INSTALLATION+------------++The steps to install are:++1) Examine HDBC-odbc.cabal and edit the include-dirs+   line to point to your local ODBC installation.  If necessary,+   uncomment and edit the extra-lib-dirs line to point to your+   local ODBC installation.++2) ghc --make -o setup Setup.lhs++3) ./setup configure++4) ./setup build++5) ./setup install   (as root)++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 -package HDBC-odbc++Or, with Cabal, use:++  Build-Depends: HDBC>=0.99.2, HDBC-odbc++This package has been tested with unixODBC.++-- John Goerzen+   January 2006+
+ Setup.hs view
@@ -0,0 +1,20 @@+import Distribution.Simple+import qualified System.Info+import Data.List+import Distribution.Simple.Utils+import Distribution.PackageDescription+import System.Exit++main = defaultMainWithHooks defaultUserHooks{preConf = conf, postConf = ok}+       where ok _ _ _ _ = return ExitSuccess++conf args flags =+    do config <- if isWindows+                 then do putStrLn "On Windows -- using odbc32"+                         return (emptyBuildInfo {extraLibs = ["odbc32"]})+                 else do putStrLn "Not on Windows -- using odbc"+                         return (emptyBuildInfo {extraLibs = ["odbc"]})+       writeHookedBuildInfo "HDBC-odbc.buildinfo" (Just config, [])+       return (Just config, [])++    where isWindows = isPrefixOf "mingw" System.Info.os
+ TODO view
@@ -0,0 +1,2 @@+optimize multiple executions and executeMany+
+ debian/changelog view
@@ -0,0 +1,38 @@+hdbc-odbc (1.0.1.0) unstable; urgency=low++  * Rebuild against HDBC 1.0.1.++ -- John Goerzen <jgoerzen@complete.org>  Sat, 22 Jul 2006 07:23:51 -0500++hdbc-odbc (1.0.0.1) unstable; urgency=low++  * Updated to now build on Windows.++ -- John Goerzen <jgoerzen@complete.org>  Tue, 18 Jul 2006 03:21:57 -0500++hdbc-odbc (1.0.0.0) unstable; urgency=low++  * Blessing as 1.0.0.0+  * Rebuilding with GHC 6.4.2 for Debian++ -- John Goerzen <jgoerzen@complete.org>  Thu, 29 Jun 2006 19:03:05 -0500++hdbc-odbc (0.99.2.1) unstable; urgency=low++  * Give wrapobj a unique name so ODBC and PostgreSQL can coexist+    in a single binary.++ -- John Goerzen <jgoerzen@complete.org>  Tue, 28 Mar 2006 22:21:47 -0600++hdbc-odbc (0.99.2.0) unstable; urgency=low++  * Updated to 0.99.2: implemented new memory management system,+    optional transaction support, and metadata inquiry features.++ -- John Goerzen <jgoerzen@complete.org>  Tue, 28 Mar 2006 05:40:07 -0600++hdbc-odbc (0.99.0.0) unstable; urgency=low++  * Initial Release.++ -- John Goerzen <jgoerzen@complete.org>  Mon, 09 Jan 2006 05:31:21 -0600
+ debian/compat view
@@ -0,0 +1,1 @@+4
+ debian/control view
@@ -0,0 +1,30 @@+Source: hdbc-odbc+Priority: optional+Maintainer: John Goerzen <jgoerzen@complete.org>+Build-Depends: debhelper (>= 4.0.0), ghc6 (>= 6.4.2), ghc6 (<< 6.4.2-999), haskell-devscripts (>= 0.5.6), cpphs, haddock, hugs (>= 98.200503.08), libghc6-hdbc-dev (>= 1.0.1), libhugs-hdbc (>= 1.0.1), unixodbc-dev (>= 2.2.11)+Standards-Version: 3.6.2+Section: libs++Package: libghc6-hdbc-odbc-dev+Section: libdevel+Architecture: any+Depends: libghc6-hdbc-dev (>= 1.0.1), ${haskell:Depends}, ${shlibs:Depends}, ${misc:Depends}, unixodbc-dev (>= 2.2.11)+Description: unixODBC HDBC (Haskell Database Connectivity) Driver for GHC+ HDBC provides an abstraction layer between Haskell programs and SQL+ relational databases. This lets you write database code once, in+ Haskell, and have it work with any number of backend SQL databases+ (MySQL, Oracle, PostgreSQL, ODBC-compliant databases, etc.)+ .+ This package provides the ODBC database driver for HDBC under GHC.++Package: libhugs-hdbc-odbc+Section: libs+Architecture: any+Depends: libhugs-hdbc (>= 1.0.1), ${haskell:Depends}, ${shlibs:Depends}, ${misc:Depends}+Description: unixODBC HDBC (Haskell Database Connectivity) Driver for Hugs+ HDBC provides an abstraction layer between Haskell programs and SQL+ relational databases. This lets you write database code once, in+ Haskell, and have it work with any number of backend SQL databases+ (MySQL, Oracle, PostgreSQL, ODBC-compliant databases, etc.)+ .+ This package provides the ODBC database driver for HDBC under Hugs.
+ debian/copyright view
@@ -0,0 +1,28 @@+This is hdbc-postgresql, written and maintained by+ John Goerzen <jgoerzen@complete.org>+on Tue, 27 Dec 2005 16:57:21 -0600.++The original source can always be found at:+	ftp://ftp.debian.org/dists/unstable/main/source/++The Darcs repository for this program can be accessed with:+   darcs get --partial http://darcs.complete.org/hdbc-postgresql++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++On Debian systems, the complete text of the GNU Lesser General+Public License can be found in `/usr/share/common-licenses/LGPL'.
+ debian/dirs view
@@ -0,0 +1,2 @@+usr/bin+usr/sbin
+ debian/docs view
@@ -0,0 +1,3 @@+README.txt+README.txt+TODO
+ debian/rules view
@@ -0,0 +1,111 @@+#!/usr/bin/make -f+# -*- makefile -*-+# Sample debian/rules that uses debhelper.+# This file was originally written by Joey Hess and Craig Small.+# As a special exception, when this file is copied by dh-make into a+# dh-make output file, you may use that output file without restriction.+# This special exception was added by Craig Small in version 0.37 of dh-make.++# Uncomment this to turn on verbose mode.+#export DH_VERBOSE=1+++++CFLAGS = -Wall -g++ifneq (,$(findstring noopt,$(DEB_BUILD_OPTIONS)))+	CFLAGS += -O0+else+	CFLAGS += -O2+endif++# shared library versions, option 1+version=2.0.5+major=2+# option 2, assuming the library is created as src/.libs/libfoo.so.2.0.5 or so+#version=`ls src/.libs/lib*.so.* | \+# awk '{if (match($$0,/[0-9]+\.[0-9]+\.[0-9]+$$/)) print substr($$0,RSTART)}'`+#major=`ls src/.libs/lib*.so.* | \+# awk '{if (match($$0,/\.so\.[0-9]+$$/)) print substr($$0,RSTART+4)}'`++configure: configure-stamp+configure-stamp:+	dh_testdir+	# Add here commands to configure the package.++	touch configure-stamp+++build: build-stamp+build-stamp: configure-stamp +	dh_testdir++	# Add here commands to compile the package.+	#$(MAKE)++	touch build-stamp++clean:+	dh_testdir+	dh_testroot+	rm -f build-stamp configure-stamp++	# Add here commands to clean up after the build process.+	-$(MAKE) clean+	-./setup clean+	-rm -rf setup Setup.hi Setup.ho Setup.o .*config* dist++	dh_clean ++install: build+	dh_testdir+	dh_testroot+	dh_clean -k +	dh_installdirs++	# Add here commands to install the package into debian/tmp+	#$(MAKE) install DESTDIR=$(CURDIR)/debian/tmp+	dh_haskell -a+#	$(MAKE) clean+# We can't test PostgreSQL because the server may not be available for+# the build user.+#$(MAKE) test++# Build architecture-independent files here.+binary-indep: build install+# Nothing to do by default.++# Build architecture-dependent files here.+binary-arch: build install+	dh_testdir+	dh_testroot+	dh_installchangelogs -a+	dh_installdocs -a README.txt+	dh_installexamples -a+#	dh_install+#	dh_installmenu+#	dh_installdebconf	+#	dh_installlogrotate+#	dh_installemacsen+#	dh_installpam+#	dh_installmime+#	dh_installinit+#	dh_installcron+#	dh_installinfo+	dh_installman -a+	dh_link -a+	dh_strip -a+	dh_compress -a+	dh_fixperms -a+#	dh_perl+#	dh_python+#	dh_makeshlibs+	dh_installdeb -a+	dh_shlibdeps -a+	dh_gencontrol -a+	dh_md5sums -a+	dh_builddeb -a++binary: binary-indep binary-arch+.PHONY: build clean binary-indep binary-arch binary install configure
+ hdbc-odbc-helper.c view
@@ -0,0 +1,137 @@+#include <HsBase.h>+#ifdef mingw32_HOST_OS+#include <windows.h>+#endif+#include <sql.h>+#include <sqlext.h>+#include <stdio.h>+#include <stdlib.h>+#include "hdbc-odbc-helper.h"++SQLINTEGER nullData = SQL_NULL_DATA;++int sqlSucceeded(SQLRETURN ret) {+  return SQL_SUCCEEDED(ret);+}++/* Things can't finalize more than once.  +We'd like to let people call them from the app.+Yet we'd also like to be able to have a ForeignPtr finalize them.++So, here's a little wrapper for things. */++void dbc_conditional_finalizer(finalizeonce *conn);++finalizeonce *wrapobjodbc(void *obj, finalizeonce *parentobj) {+  finalizeonce *newobj;+  newobj = malloc(sizeof(finalizeonce));+  if (newobj == NULL) {+    fprintf(stderr, "\nHDBC: could not allocate wrapper!\n");+    return NULL;+  }+  newobj->isfinalized = 0;+  newobj -> refcount = 1;+  newobj->encapobj = obj;+  newobj->extrainfo = NULL;+  newobj->parent = parentobj;+  if (parentobj != NULL)+    (parentobj->refcount)++;+#ifdef HDBC_DEBUG+  fprintf(stderr, "\nWrapped %p at %p\n", obj, newobj);+#endif+  return newobj;+}++finalizeonce *wrapobjodbc_extra(void *obj, void *extra, finalizeonce *parentobj) {+  finalizeonce *newobj = wrapobjodbc(obj, parentobj);+  if (newobj != NULL)+    newobj->extrainfo = extra;+  return newobj;+}+  +void sqlFreeHandleSth_app(finalizeonce *res) {+#ifdef HDBC_DEBUG+  fprintf(stderr, "\nApp cleanup of sth %p requested: %d\n", +          res->encapobj, res->isfinalized);+#endif+  if (res->isfinalized)+    return;+  SQLCloseCursor((SQLHSTMT) (res->encapobj));+  SQLFreeHandle(SQL_HANDLE_STMT, (SQLHANDLE) (res->encapobj));+  res->isfinalized = 1;+  res->encapobj = NULL;+}++void sqlFreeHandleSth_finalizer(finalizeonce *res) {+#ifdef HDBC_DEBUG+  fprintf(stderr, "\nFinalizer cleanup of sth %p requested: %d\n", +          res->encapobj, res->isfinalized);+#endif+  sqlFreeHandleSth_app(res);+  (res->refcount)--;            /* Not really important since this is never a +                                   parent */+  (res->parent->refcount)--;+  dbc_conditional_finalizer(res->parent);+  free(res);+}++SQLRETURN sqlFreeHandleDbc_app(finalizeonce *res) {+  SQLRETURN retval;+#ifdef HDBC_DEBUG+  fprintf(stderr, "\nApp cleanup of dbc %p requested: %d\n", +          res->encapobj, res->isfinalized);+#endif+  if (res->isfinalized)+    return 0;+  retval = SQLDisconnect((SQLHDBC) (res->encapobj));+  if (SQL_SUCCEEDED(retval)) {+    SQLFreeHandle(SQL_HANDLE_DBC, (SQLHANDLE) (res->encapobj));+    SQLFreeHandle(SQL_HANDLE_ENV, (SQLHANDLE) (res->extrainfo));+    res->isfinalized = 1;+    res->encapobj = NULL;+  }+  return retval;+}++void sqlFreeHandleDbc_finalizer(finalizeonce *res) {+#ifdef HDBC_DEBUG+  fprintf(stderr, "\nFinalizer cleanup of dbc %p requested: %d\n", +          res->encapobj, res->isfinalized);+#endif+  (res->refcount)--;+  dbc_conditional_finalizer(res);+}++void dbc_conditional_finalizer(finalizeonce *res) {+  if (res->refcount < 1) {+  /* Don't use sqlFreeHandleDbc_app here, because we want to clear it out+     regardless of the success or failues of SQLDisconnect. */+    if (! (res->isfinalized)) {+      SQLDisconnect((SQLHDBC) (res->encapobj));+      SQLFreeHandle(SQL_HANDLE_DBC, (SQLHANDLE) (res->encapobj));+      SQLFreeHandle(SQL_HANDLE_ENV, (SQLHANDLE) (res->extrainfo));+      res->encapobj = NULL;+      res->isfinalized = 1;+    }+    free(res);+  }+}++void *getSqlOvOdbc3(void) {+  return (void *)SQL_OV_ODBC3;+}++SQLRETURN disableAutoCommit(SQLHDBC conn) {+  return SQLSetConnectAttr(conn, SQL_ATTR_AUTOCOMMIT, +                           (SQLPOINTER) SQL_AUTOCOMMIT_OFF,+                           SQL_IS_UINTEGER);+}++SQLRETURN simpleSqlTables(SQLHSTMT stmt) {+  return SQLTables(stmt, NULL, 0, NULL, 0, "%", 1, "TABLE", 5);+}++SQLRETURN simpleSqlColumns(SQLHSTMT stmt, SQLCHAR *tablename, +                           SQLSMALLINT tnlen) {+  return SQLColumns(stmt, NULL, 0, NULL, 0, tablename, tnlen, "%", 1);+}
+ hdbc-odbc-helper.h view
@@ -0,0 +1,34 @@+#ifdef mingw32_HOST_OS+#include <windows.h>+#endif+#include <sql.h>++extern int sqlSucceeded(SQLRETURN ret);+extern SQLRETURN sqlFreeHandleEnv(SQLHANDLE hdl);++typedef struct TAG_finalizeonce {+  void *encapobj;+  int refcount;+  int isfinalized;+  void *extrainfo;+  struct TAG_finalizeonce *parent;+} finalizeonce;++extern finalizeonce *wrapobjodbc(void *obj, finalizeonce *parentobj);+extern finalizeonce *wrapobjodbc_extra(void *obj, void *extra,+                                       finalizeonce *parentobj);++extern SQLRETURN sqlFreeHandleDbc_app(finalizeonce *res);+extern void sqlFreeHandleDbc_finalizer(finalizeonce *res);++extern void sqlFreeHandleSth_app(finalizeonce *res);+extern void sqlFreeHandleSth_finalizer(finalizeonce *res);++extern SQLINTEGER nullData;+extern void *getSqlOvOdbc3(void);++extern SQLRETURN disableAutoCommit(SQLHDBC conn);+extern SQLRETURN simpleSqlTables(SQLHSTMT stmt);+extern SQLRETURN simpleSqlColumns(SQLHSTMT stmt, SQLCHAR *tablename, +                                  SQLSMALLINT tnlen);+
+ testsrc/COPYING view
@@ -0,0 +1,510 @@++                  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!++
+ testsrc/COPYRIGHT view
@@ -0,0 +1,4 @@+Copyright (c) 2005 John Goerzen++Please see COPYING for the license.+
+ testsrc/SpecificDB.hs view
@@ -0,0 +1,7 @@+module SpecificDB where+import Database.HDBC+import Database.HDBC.ODBC+import Test.HUnit++connectDB = +    handleSqlError (connectODBC "DSN=hdbctest")
+ testsrc/SpecificDBTests.hs view
@@ -0,0 +1,5 @@+module SpecificDBTests where+import Database.HDBC+import Test.HUnit++tests = TestList []
+ testsrc/TestMisc.hs view
@@ -0,0 +1,170 @@+module TestMisc(tests, setup) where+import Test.HUnit+import Database.HDBC+import TestUtils+import System.IO+import Control.Exception+import Data.Char+import Control.Monad+import qualified Data.Map as Map++rowdata = +    [[SqlInt32 0, toSql "Testing", SqlNull],+     [SqlInt32 1, toSql "Foo", SqlInt32 5],+     [SqlInt32 2, toSql "Bar", SqlInt32 9]]++colnames = ["testid", "teststring", "testint"]+alrows :: [[(String, SqlValue)]]+alrows = map (zip colnames) rowdata++setup f = dbTestCase $ \dbh ->+   do run dbh "CREATE TABLE hdbctest2 (testid INTEGER PRIMARY KEY NOT NULL, teststring TEXT, testint INTEGER)" []+      sth <- prepare dbh "INSERT INTO hdbctest2 VALUES (?, ?, ?)"+      executeMany sth rowdata+      commit dbh+      finally (f dbh)+              (do run dbh "DROP TABLE hdbctest2" []+                  commit dbh+              )++cloneTest dbh a =+    do dbh2 <- clone dbh+       finally (handleSqlError (a dbh2))+               (handleSqlError (disconnect dbh2))++testgetColumnNames = setup $ \dbh ->+   do sth <- prepare dbh "SELECT * from hdbctest2"+      execute sth []+      cols <- getColumnNames sth+      finish sth+      ["testid", "teststring", "testint"] @=? map (map toLower) cols++testdescribeResult = setup $ \dbh -> when (not ((hdbcDriverName dbh) `elem`+                                               ["sqlite3"])) $+   do sth <- prepare dbh "SELECT * from hdbctest2"+      execute sth []+      cols <- describeResult sth+      ["testid", "teststring", "testint"] @=? map (map toLower . fst) cols+      let coldata = map snd cols+      assertBool "r0 type" (colType (coldata !! 0) `elem`+                            [SqlBigIntT, SqlIntegerT])+      assertBool "r1 type" (colType (coldata !! 1) `elem`+                            [SqlVarCharT, SqlLongVarCharT])+      assertBool "r2 type" (colType (coldata !! 2) `elem`+                            [SqlBigIntT, SqlIntegerT])+      finish sth++testdescribeTable = setup $ \dbh -> when (not ((hdbcDriverName dbh) `elem`+                                               ["sqlite3"])) $+   do cols <- describeTable dbh "hdbctest2"+      ["testid", "teststring", "testint"] @=? map (map toLower . fst) cols+      let coldata = map snd cols+      assertBool "r0 type" (colType (coldata !! 0) `elem`+                            [SqlBigIntT, SqlIntegerT])+      assertEqual "r0 nullable" (Just False) (colNullable (coldata !! 0))+      assertBool "r1 type" (colType (coldata !! 1) `elem`+                            [SqlVarCharT, SqlLongVarCharT])+      assertEqual "r1 nullable" (Just True) (colNullable (coldata !! 1))+      assertBool "r2 type" (colType (coldata !! 2) `elem`+                           [SqlBigIntT, SqlIntegerT])+      assertEqual "r2 nullable" (Just True) (colNullable (coldata !! 2))++testquickQuery = setup $ \dbh ->+    do results <- quickQuery dbh "SELECT * from hdbctest2 ORDER BY testid" []+       rowdata @=? results++testfetchRowAL = setup $ \dbh ->+    do sth <- prepare dbh "SELECT * from hdbctest2 ORDER BY testid" +       execute sth []+       fetchRowAL sth >>= (Just (head alrows) @=?)+       fetchRowAL sth >>= (Just (alrows !! 1) @=?)+       fetchRowAL sth >>= (Just (alrows !! 2) @=?)+       fetchRowAL sth >>= (Nothing @=?)+       finish sth++testfetchRowMap = setup $ \dbh ->+    do sth <- prepare dbh "SELECT * from hdbctest2 ORDER BY testid" +       execute sth []+       fetchRowMap sth >>= (Just (Map.fromList $ head alrows) @=?)+       fetchRowMap sth >>= (Just (Map.fromList $ alrows !! 1) @=?)+       fetchRowMap sth >>= (Just (Map.fromList $ alrows !! 2) @=?)+       fetchRowMap sth >>= (Nothing @=?)+       finish sth++testfetchAllRowsAL = setup $ \dbh ->+    do sth <- prepare dbh "SELECT * from hdbctest2 ORDER BY testid"+       execute sth []+       fetchAllRowsAL sth >>= (alrows @=?)++testfetchAllRowsMap = setup $ \dbh ->+    do sth <- prepare dbh "SELECT * from hdbctest2 ORDER BY testid"+       execute sth []+       fetchAllRowsMap sth >>= (map (Map.fromList) alrows @=?)++testexception = setup $ \dbh ->+    catchSql (do sth <- prepare dbh "SELECT invalidcol FROM hdbctest2"+                 execute sth []+                 assertFailure "No exception was raised"+             )+             (\e -> commit dbh)++testrowcount = setup $ \dbh ->+    do r <- run dbh "UPDATE hdbctest2 SET testint = 25 WHERE testid = 20" []+       assertEqual "UPDATE with no change" 0 r+       r <- run dbh "UPDATE hdbctest2 SET testint = 26 WHERE testid = 0" []+       assertEqual "UPDATE with 1 change" 1 r+       r <- run dbh "UPDATE hdbctest2 SET testint = 27 WHERE testid <> 0" []+       assertEqual "UPDATE with 2 changes" 2 r+       commit dbh+       res <- quickQuery dbh "SELECT * from hdbctest2 ORDER BY testid" []+       assertEqual "final results"+         [[SqlInt32 0, toSql "Testing", SqlInt32 26],+          [SqlInt32 1, toSql "Foo", SqlInt32 27],+          [SqlInt32 2, toSql "Bar", SqlInt32 27]] res+                       +{- Since we might be running against a live DB, we can't look at a specific+list here (though a SpecificDB test case may be able to).  We can ensure+that our test table is, or is not, present, as appropriate. -}+                                      +testgetTables1 = setup $ \dbh ->+    do r <- getTables dbh+       True @=? "hdbctest2" `elem` r++testgetTables2 = dbTestCase $ \dbh ->+    do r <- getTables dbh+       False @=? "hdbctest2" `elem` r++testclone = setup $ \dbho -> cloneTest dbho $ \dbh ->+    do results <- quickQuery dbh "SELECT * from hdbctest2 ORDER BY testid" []+       rowdata @=? results++testnulls = setup $ \dbh ->+    do let dn = hdbcDriverName dbh+       when (not (dn `elem` ["postgresql", "odbc"])) (+          do sth <- prepare dbh "INSERT INTO hdbctest2 VALUES (?, ?, ?)"+             executeMany sth rows+             finish sth+             res <- quickQuery dbh "SELECT * from hdbctest2 WHERE testid > 99 ORDER BY testid" []+             seq (length res) rows @=? res+                                             )+    where rows = [[SqlInt32 100, SqlString "foo\NULbar", SqlNull],+                  [SqlInt32 101, SqlString "bar\NUL", SqlNull],+                  [SqlInt32 102, SqlString "\NUL", SqlNull],+                  [SqlInt32 103, SqlString "\xFF", SqlNull],+                  [SqlInt32 104, SqlString "regular", SqlNull]]+       ++tests = TestList [TestLabel "getColumnNames" testgetColumnNames,+                  TestLabel "describeResult" testdescribeResult,+                  TestLabel "describeTable" testdescribeTable,+                  TestLabel "quickQuery" testquickQuery,+                  TestLabel "fetchRowAL" testfetchRowAL,+                  TestLabel "fetchRowMap" testfetchRowMap,+                  TestLabel "fetchAllRowsAL" testfetchAllRowsAL,+                  TestLabel "fetchAllRowsMap" testfetchAllRowsMap,+                  TestLabel "sql exception" testexception,+                  TestLabel "clone" testclone,+                  TestLabel "update rowcount" testrowcount,+                  TestLabel "get tables1" testgetTables1,+                  TestLabel "get tables2" testgetTables2,+                  TestLabel "nulls" testnulls]
+ testsrc/TestSbasics.hs view
@@ -0,0 +1,149 @@+module TestSbasics(tests) where+import Test.HUnit+import Database.HDBC+import TestUtils+import System.IO+import Control.Exception++openClosedb = sqlTestCase $ +    do dbh <- connectDB+       disconnect dbh++multiFinish = dbTestCase (\dbh ->+    do sth <- prepare dbh "SELECT 1 + 1"+       sExecute sth []+       finish sth+       finish sth+       finish sth+                          )++basicQueries = dbTestCase (\dbh ->+    do sth <- prepare dbh "SELECT 1 + 1"+       sExecute sth []+       sFetchRow sth >>= (assertEqual "row 1" (Just [Just "2"]))+       sFetchRow sth >>= (assertEqual "last row" Nothing)+                          )+    +createTable = dbTestCase (\dbh ->+    do sRun dbh "CREATE TABLE hdbctest1 (testname VARCHAR(20), testid INTEGER, testint INTEGER, testtext TEXT)" []+       commit dbh+                         )++dropTable = dbTestCase (\dbh ->+    do sRun dbh "DROP TABLE hdbctest1" []+       commit dbh+                       )++runReplace = dbTestCase (\dbh ->+    do sRun dbh "INSERT INTO hdbctest1 VALUES (?, ?, ?, ?)" r1+       sRun dbh "INSERT INTO hdbctest1 VALUES (?, ?, 2, ?)" r2+       commit dbh+       sth <- prepare dbh "SELECT * FROM hdbctest1 WHERE testname = 'runReplace' ORDER BY testid"+       sExecute sth []+       sFetchRow sth >>= (assertEqual "r1" (Just r1))+       sFetchRow sth >>= (assertEqual "r2" (Just [Just "runReplace", Just "2",+                                                 Just "2", Nothing]))+       sFetchRow sth >>= (assertEqual "lastrow" Nothing)+                       )+    where r1 = [Just "runReplace", Just "1", Just "1234", Just "testdata"]+          r2 = [Just "runReplace", Just "2", Nothing]++executeReplace = dbTestCase (\dbh ->+    do sth <- prepare dbh "INSERT INTO hdbctest1 VALUES ('executeReplace',?,?,?)"+       sExecute sth [Just "1", Just "1234", Just "Foo"]+       sExecute sth [Just "2", Nothing, Just "Bar"]+       commit dbh+       sth <- prepare dbh "SELECT * FROM hdbctest1 WHERE testname = ? ORDER BY testid"+       sExecute sth [Just "executeReplace"]+       sFetchRow sth >>= (assertEqual "r1" +                         (Just $ map Just ["executeReplace", "1", "1234", +                                           "Foo"]))+       sFetchRow sth >>= (assertEqual "r2"+                         (Just [Just "executeReplace", Just "2", Nothing,+                                Just "Bar"]))+       sFetchRow sth >>= (assertEqual "lastrow" Nothing)+                            )++testExecuteMany = dbTestCase (\dbh ->+    do sth <- prepare dbh "INSERT INTO hdbctest1 VALUES ('multi',?,?,?)"+       sExecuteMany sth rows+       commit dbh+       sth <- prepare dbh "SELECT testid, testint, testtext FROM hdbctest1 WHERE testname = 'multi'"+       sExecute sth []+       mapM_ (\r -> sFetchRow sth >>= (assertEqual "" (Just r))) rows+       sFetchRow sth >>= (assertEqual "lastrow" Nothing)+                          )+    where rows = [map Just ["1", "1234", "foo"],+                  map Just ["2", "1341", "bar"],+                  [Just "3", Nothing, Nothing]]++testsFetchAllRows = dbTestCase (\dbh ->+    do sth <- prepare dbh "INSERT INTO hdbctest1 VALUES ('sFetchAllRows', ?, NULL, NULL)"+       sExecuteMany sth rows+       commit dbh+       sth <- prepare dbh "SELECT testid FROM hdbctest1 WHERE testname = 'sFetchAllRows' ORDER BY testid"+       sExecute sth []+       results <- sFetchAllRows sth+       assertEqual "" rows results+                               )+    where rows = map (\x -> [Just . show $ x]) [1..9]++basicTransactions = dbTestCase (\dbh ->+    do assertBool "Connected database does not support transactions; skipping transaction test" (dbTransactionSupport dbh)+       sth <- prepare dbh "INSERT INTO hdbctest1 VALUES ('basicTransactions', ?, NULL, NULL)"+       sExecute sth [Just "0"]+       commit dbh+       qrysth <- prepare dbh "SELECT testid FROM hdbctest1 WHERE testname = 'basicTransactions' ORDER BY testid"+       sExecute qrysth []+       sFetchAllRows qrysth >>= (assertEqual "initial commit" [[Just "0"]])++       -- Now try a rollback+       sExecuteMany sth rows+       rollback dbh+       sExecute qrysth []+       sFetchAllRows qrysth >>= (assertEqual "rollback" [[Just "0"]])++       -- Now try another commit+       sExecuteMany sth rows+       commit dbh+       sExecute qrysth []+       sFetchAllRows qrysth >>= (assertEqual "final commit" ([Just "0"]:rows))+                               )+    where rows = map (\x -> [Just . show $ x]) [1..9]++testWithTransaction = dbTestCase (\dbh ->+    do assertBool "Connected database does not support transactions; skipping transaction test" (dbTransactionSupport dbh)+       sth <- prepare dbh "INSERT INTO hdbctest1 VALUES ('withTransaction', ?, NULL, NULL)"+       sExecute sth [Just "0"]+       commit dbh+       qrysth <- prepare dbh "SELECT testid FROM hdbctest1 WHERE testname = 'withTransaction' ORDER BY testid"+       sExecute qrysth []+       sFetchAllRows qrysth >>= (assertEqual "initial commit" [[Just "0"]])+       +       -- Let's try a rollback.+       try $ withTransaction dbh (\_ -> do sExecuteMany sth rows+                                           fail "Foo")+       sExecute qrysth []+       sFetchAllRows qrysth >>= (assertEqual "rollback" [[Just "0"]])++       -- And now a commit.+       withTransaction dbh (\_ -> sExecuteMany sth rows)+       sExecute qrysth []+       sFetchAllRows qrysth >>= (assertEqual "final commit" ([Just "0"]:rows))+                               )+    where rows = map (\x -> [Just . show $ x]) [1..9]+       +tests = TestList+        [+         TestLabel "openClosedb" openClosedb,+         TestLabel "multiFinish" multiFinish,+         TestLabel "basicQueries" basicQueries,+         TestLabel "createTable" createTable,+         TestLabel "runReplace" runReplace,+         TestLabel "executeReplace" executeReplace,+         TestLabel "executeMany" testExecuteMany,+         TestLabel "sFetchAllRows" testsFetchAllRows,+         TestLabel "basicTransactions" basicTransactions,+         TestLabel "withTransaction" testWithTransaction,+         TestLabel "dropTable" dropTable+         ]
+ testsrc/TestUtils.hs view
@@ -0,0 +1,25 @@+module TestUtils(connectDB, sqlTestCase, dbTestCase, printDBInfo) where+import Database.HDBC+import Test.HUnit+import Control.Exception+import SpecificDB(connectDB)++sqlTestCase a = +    TestCase (handleSqlError a)++dbTestCase a =+    TestCase (do dbh <- connectDB+                 finally (handleSqlError (a dbh))+                         (handleSqlError (disconnect dbh))+             )++printDBInfo = handleSqlError $+    do dbh <- connectDB+       putStrLn "+-------------------------------------------------------------------------"+       putStrLn $ "| Testing HDBC database module: " ++ hdbcDriverName dbh +++                ", bound to client: " ++ hdbcClientVer dbh+       putStrLn $ "| Proxied driver: " ++ proxiedClientName dbh +++                ", bound to version: " ++ proxiedClientVer dbh+       putStrLn $ "| Connected to server version: " ++ dbServerVer dbh+       putStrLn "+-------------------------------------------------------------------------\n"+       disconnect dbh
+ testsrc/Testbasics.hs view
@@ -0,0 +1,155 @@+module Testbasics(tests) where+import Test.HUnit+import Database.HDBC+import TestUtils+import System.IO+import Control.Exception++openClosedb = sqlTestCase $ +    do dbh <- connectDB+       disconnect dbh++multiFinish = dbTestCase (\dbh ->+    do sth <- prepare dbh "SELECT 1 + 1"+       r <- execute sth []+       assertEqual "basic count" 0 r+       finish sth+       finish sth+       finish sth+                          )++basicQueries = dbTestCase (\dbh ->+    do sth <- prepare dbh "SELECT 1 + 1"+       execute sth [] >>= (0 @=?)+       r <- fetchAllRows sth+       assertEqual "converted from" [["2"]] (map (map fromSql) r)+       assertEqual "int32 compare" [[SqlInt32 2]] r+       assertEqual "iToSql compare" [[iToSql 2]] r+       assertEqual "num compare" [[toSql (2::Int)]] r+       assertEqual "nToSql compare" [[nToSql (2::Int)]] r+       assertEqual "string compare" [[SqlString "2"]] r+                          )+    +createTable = dbTestCase (\dbh ->+    do run dbh "CREATE TABLE hdbctest1 (testname VARCHAR(20), testid INTEGER, testint INTEGER, testtext TEXT)" []+       commit dbh+                         )++dropTable = dbTestCase (\dbh ->+    do run dbh "DROP TABLE hdbctest1" []+       commit dbh+                       )++runReplace = dbTestCase (\dbh ->+    do r <- run dbh "INSERT INTO hdbctest1 VALUES (?, ?, ?, ?)" r1+       assertEqual "insert retval" 1 r+       run dbh "INSERT INTO hdbctest1 VALUES (?, ?, ?, ?)" r2+       commit dbh+       sth <- prepare dbh "SELECT * FROM hdbctest1 WHERE testname = 'runReplace' ORDER BY testid"+       rv2 <- execute sth []+       assertEqual "select retval" 0 rv2+       r <- fetchAllRows sth+       assertEqual "" [r1, r2] r+                       )+    where r1 = [toSql "runReplace", iToSql 1, iToSql 1234, SqlString "testdata"] +          r2 = [toSql "runReplace", iToSql 2, iToSql 2, SqlNull]++executeReplace = dbTestCase (\dbh ->+    do sth <- prepare dbh "INSERT INTO hdbctest1 VALUES ('executeReplace',?,?,?)"+       execute sth [iToSql 1, iToSql 1234, toSql "Foo"]+       execute sth [SqlInt32 2, SqlNull, toSql "Bar"]+       commit dbh+       sth <- prepare dbh "SELECT * FROM hdbctest1 WHERE testname = ? ORDER BY testid"+       execute sth [SqlString "executeReplace"]+       r <- fetchAllRows sth+       assertEqual "result"+                   [[toSql "executeReplace", iToSql 1, toSql "1234",+                     toSql "Foo"],+                    [toSql "executeReplace", iToSql 2, SqlNull,+                     toSql "Bar"]]+                   r+                            )++testExecuteMany = dbTestCase (\dbh ->+    do sth <- prepare dbh "INSERT INTO hdbctest1 VALUES ('multi',?,?,?)"+       executeMany sth rows+       commit dbh+       sth <- prepare dbh "SELECT testid, testint, testtext FROM hdbctest1 WHERE testname = 'multi'"+       execute sth []+       r <- fetchAllRows sth+       assertEqual "" rows r+                          )+    where rows = [map toSql ["1", "1234", "foo"],+                  map toSql ["2", "1341", "bar"],+                  [toSql "3", SqlNull, SqlNull]]++testFetchAllRows = dbTestCase (\dbh ->+    do sth <- prepare dbh "INSERT INTO hdbctest1 VALUES ('sFetchAllRows', ?, NULL, NULL)"+       executeMany sth rows+       commit dbh+       sth <- prepare dbh "SELECT testid FROM hdbctest1 WHERE testname = 'sFetchAllRows' ORDER BY testid"+       execute sth []+       results <- fetchAllRows sth+       assertEqual "" rows results+                               )+    where rows = map (\x -> [iToSql x]) [1..9]++basicTransactions = dbTestCase (\dbh ->+    do assertBool "Connected database does not support transactions; skipping transaction test" (dbTransactionSupport dbh)+       sth <- prepare dbh "INSERT INTO hdbctest1 VALUES ('basicTransactions', ?, NULL, NULL)"+       execute sth [iToSql 0]+       commit dbh+       qrysth <- prepare dbh "SELECT testid FROM hdbctest1 WHERE testname = 'basicTransactions' ORDER BY testid"+       execute qrysth []+       fetchAllRows qrysth >>= (assertEqual "initial commit" [[toSql "0"]])++       -- Now try a rollback+       executeMany sth rows+       rollback dbh+       execute qrysth []+       fetchAllRows qrysth >>= (assertEqual "rollback" [[toSql "0"]])++       -- Now try another commit+       executeMany sth rows+       commit dbh+       execute qrysth []+       fetchAllRows qrysth >>= (assertEqual "final commit" ([SqlString "0"]:rows))+                               )+    where rows = map (\x -> [iToSql $ x]) [1..9]++testWithTransaction = dbTestCase (\dbh ->+    do assertBool "Connected database does not support transactions; skipping transaction test" (dbTransactionSupport dbh)+       sth <- prepare dbh "INSERT INTO hdbctest1 VALUES ('withTransaction', ?, NULL, NULL)"+       execute sth [toSql "0"]+       commit dbh+       qrysth <- prepare dbh "SELECT testid FROM hdbctest1 WHERE testname = 'withTransaction' ORDER BY testid"+       execute qrysth []+       fetchAllRows qrysth >>= (assertEqual "initial commit" [[toSql "0"]])+       +       -- Let's try a rollback.+       try $ withTransaction dbh (\_ -> do executeMany sth rows+                                           fail "Foo")+       execute qrysth []+       fetchAllRows qrysth >>= (assertEqual "rollback" [[SqlString "0"]])++       -- And now a commit.+       withTransaction dbh (\_ -> executeMany sth rows)+       execute qrysth []+       fetchAllRows qrysth >>= (assertEqual "final commit" ([iToSql 0]:rows))+                               )+    where rows = map (\x -> [iToSql x]) [1..9]+       +tests = TestList+        [+         TestLabel "openClosedb" openClosedb,+         TestLabel "multiFinish" multiFinish,+         TestLabel "basicQueries" basicQueries,+         TestLabel "createTable" createTable,+         TestLabel "runReplace" runReplace,+         TestLabel "executeReplace" executeReplace,+         TestLabel "executeMany" testExecuteMany,+         TestLabel "sFetchAllRows" testFetchAllRows,+         TestLabel "basicTransactions" basicTransactions,+         TestLabel "withTransaction" testWithTransaction,+         TestLabel "dropTable" dropTable+         ]
+ testsrc/Tests.hs view
@@ -0,0 +1,32 @@+{- arch-tag: Tests main file+Copyright (C) 2004-2005 John Goerzen <jgoerzen@complete.org>++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 2 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, write to the Free Software+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA+-}++module Tests(tests) where+import Test.HUnit+import qualified Testbasics+import qualified TestSbasics+import qualified SpecificDBTests+import qualified TestMisc++test1 = TestCase ("x" @=? "x")++tests = TestList [TestLabel "test1" test1,+                  TestLabel "String basics" TestSbasics.tests,+                  TestLabel "SqlValue basics" Testbasics.tests,+                  TestLabel "SpecificDB" SpecificDBTests.tests,+                  TestLabel "Misc tests" TestMisc.tests]
+ testsrc/runtests.hs view
@@ -0,0 +1,27 @@+{- arch-tag: Test runner+Copyright (C) 2004 John Goerzen <jgoerzen@complete.org>++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 2 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, write to the Free Software+Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA+-}++module Main where ++import Test.HUnit+import Tests+import TestUtils++main = do printDBInfo+          runTestTT tests+