1. ernestorx
  2. pygame


Lenard Lindstrom  committed 5f7317f

Populate msi

  • Participants
  • Parent commits 4c9dc15
  • Branches msi

Comments (0)

Files changed (3)


View file
+		       Version 2.1, February 1999
+ Copyright (C) 1991, 1999 Free Software Foundation, Inc.
+     59 Temple Place, Suite 330, Boston, MA  02111-1307  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
+  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.
+  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
+  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
+  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
+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
+  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.
+           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
+    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., 59 Temple Place, Suite 330, Boston, MA  02111-1307  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!


View file
+So what does Microsoft's Windows Installer have to do with Pygame.
+Well, Pygame is destributed on Windows in a .msi file. And the
+msidb.py module was originally written to help create a Windows
+installer for the Pygame documents and examples. It is just too
+useful to not have a home somewhere.
+msidb.py is a Database 2.0 module for reading and changing Windows
+Installer, .msi, files. It is moduled somewhat on the SQLite module
+that is part of the Python standard library. It has enought features
+to be useful but needs a proper until test and to be polished up
+a little.
+For now I will place it under the LGPL (copied from Pygame).
+Lenard Lindstrom

File msidb.py

View file
+# -*- coding: UTF-8 -*-
+# Module msidb.py
+# Copyright: Lenard Lindstrom, 2008
+# <len-l@telus.net>
+# This module is licensed under the GNU LESSER GENERAL PUBLIC LICENSE,
+# Version 2.1, February 1999. Keep with the associated license LGPL.
+"""A partial DB-API 2.0 interface for msi databases"""
+from ctypes import (c_char, c_int, c_uint, c_ulong,
+                    c_char_p, c_wchar_p, c_void_p, POINTER,
+                    byref, windll, create_string_buffer, cast)
+import itertools
+import re
+import weakref
+if TCHAR_TYPE == 'A':
+    TStr = str
+    Tchar_p = c_char_p
+elif TCHAR_TYPE == 'W':
+    TStr = unicode
+    Tchar_p = c_wchar_p
+    raise AssertionError("Unsupported character type '%s'" % TCHAR_TYPE)
+NULL_TSTR = cast(0, Tchar_p)
+P_ulong = POINTER(c_ulong)
+Handle = c_void_p
+PHandle = POINTER(Handle)
+MSI_NULL_INTEGER = -0x80000000  # integer value reserved for null
+ERROR_SUCCESS = 0  # The operation completed successfully.
+ERROR_INVALID_HANDLE = 6  # The handle is invalid.
+ERROR_INVALID_PARAMETER = 87  # The parameter is incorrect.
+ERROR_MORE_DATA = 234  # More data is available.
+ERROR_NO_MORE_ITEMS = 259  #  No more data is available.
+ERROR_OPEN_FAILED = 110  # The system cannot open the device or file specified.
+ERROR_BAD_QUERY_SYNTAX = 1615  # SQL query syntax invalid or unsupported.
+ERROR_FUNCTION_FAILED = 1627  # Function failed during execution.
+ERROR_CREATE_FAILED = 1631  # Data of this type is not supported.
+def ff(lib, name, restype, *args):
+    f = getattr(lib, name)
+    if args:
+        f.restype = restype
+        if len(args) > 1:
+            f.argtypes = list(args)
+    else:
+        f.restype = None
+    return f
+char_types = {'A':'A', 'W':'W', 'T':TCHAR_TYPE, '':''}
+def add_foriegn_functions(lib, declarations, globals_):
+    for declaration in declarations:
+        name, char_type, restype = declaration[0:3]
+        argtypes = declaration[3:]
+        char_type = char_types[char_type]
+        globals_[name] = ff(lib, name+char_type, restype, *argtypes)
+msi_functions = [
+    ('MsiOpenDatabase', 'T', c_uint, Tchar_p, Tchar_p, PHandle),
+    ('MsiDatabaseOpenView', 'T', c_uint, Handle, Tchar_p, PHandle),
+    ('MsiDatabaseCommit', '', c_uint, Handle),
+    ('MsiViewClose', '', c_uint, Handle),
+    ('MsiViewExecute', '', c_uint, Handle, Handle),
+    ('MsiViewFetch', '', c_uint, Handle, PHandle),
+    ('MsiViewGetColumnInfo', '', c_uint, Handle, MSICOLINFO, PHandle),
+    ('MsiRecordDataSize', '', c_uint, Handle, c_uint),
+    ('MsiRecordGetFieldCount', '', c_uint, Handle),
+    ('MsiRecordGetInteger', '', c_int, Handle, c_uint),
+    ('MsiRecordGetString', 'T', c_uint, Handle, c_uint, Tchar_p, P_ulong),
+    ('MsiCreateRecord', '', Handle, c_uint),
+    ('MsiRecordSetString', 'T', c_uint, Handle, c_uint, Tchar_p),
+    ('MsiRecordSetStream', 'T', c_uint, Handle, c_uint, Tchar_p),
+    ('MsiRecordReadStream', '', c_uint, Handle, c_uint,
+                                POINTER(c_char), POINTER(c_ulong)),
+    ('MsiRecordSetInteger', '', c_uint, Handle, c_uint, c_int),
+    ('MsiCloseHandle', '', c_uint, Handle),
+    ]
+add_foriegn_functions(windll.Msi, msi_functions, globals())
+class Record(object):
+    class NullRecord(object):
+        handle = 0
+        def close(self):
+            pass
+    null_record = NullRecord()
+    def __new__(cls, fields):
+        if fields is None:
+            return cls.null_record
+        handle = MsiCreateRecord(len(fields))
+        if handle == 0:
+            raise InternalError("Unable to create a new record")
+        try:
+            for i, p in enumerate(fields):
+                field = i + 1
+                if isinstance(p, TStr):
+                    rc = MsiRecordSetString(handle, field, p)
+                elif isinstance(p, (int, long)):
+                    rc = MsiRecordSetInteger(handle, field, p)
+                elif isinstance(p, Stream):
+                    rc = MsiRecordSetStream(handle, field, Stream.file_path)
+                elif p is None:
+                    rc = MsiRecordSetString(handle, field, NULL_TSTR)
+                else:
+                    raise ValueError("Unsupported parameter type %s"
+                                     "for paramter %d" %
+                                     (type(p), i))
+                if rc != ERROR_SUCCESS:
+                    raise error(rc)
+            obj = object.__new__(cls)
+            obj._handle = handle
+            return obj
+        except:
+            MsiCloseHandle(handle)
+            raise
+    def close(self):
+        if self._handle != None:
+            MsiCloseHandle(self._handle)
+            self._handle = None
+    handle = property(lambda self: self._handle)
+    def __del__(self):
+        self.close()
+def get_field_string(handle, field):
+    size = MsiRecordDataSize(handle, field)
+    if size == 0:
+        return None
+    buf = create_string_buffer(size+1)
+    csize = c_ulong(len(buf))
+    rc = MsiRecordGetString(handle, field, buf, byref(csize))
+    if rc != ERROR_SUCCESS:
+        raise error(rc)
+    return buf[0:size]
+def get_field_number(rec, field):
+    value = MsiRecordGetInteger(rec, field)
+    if value == MSI_NULL_INTEGER:
+        return None
+    return value
+def get_field_stream(rec, field):
+    size = MsiRecordDataSize(rec, field)
+    buf = create_string_buffer(size)
+    csize = c_ulong(size)
+    rc = MsiRecordReadStream(rec, field, buf, byref(csize))
+    if rc != ERROR_SUCCESS:
+        raise error(rc)
+    return buf
+def column_info(view_handle, info_type):
+    record_handle = Handle()
+    rc = MsiViewGetColumnInfo(view_handle,
+                              info_type,
+                              byref(record_handle))
+    if rc != ERROR_SUCCESS:
+        raise error(rc)
+    try:
+        field_count = MsiRecordGetFieldCount(record_handle)
+        return [get_field_string(record_handle, field)
+                  for field in range(1, field_count+1)]
+    finally:
+        MsiCloseHandle(record_handle)
+class Cursor(object):
+    _select_pattern = re.compile(r"\s*select\s", flags=re.IGNORECASE)
+    def __new__(cls, connection, key):
+        obj = object.__new__(cls)
+        obj._connection = connection
+        obj._key = key
+        obj._view = None
+        obj._description = None
+        obj._have_items = False
+        obj._next_record = None
+        return obj
+    def execute(self, operation, parameters=None):
+        if not self:
+            raise OperationalError("Operation on a closed cursor")
+        self._close_view()
+        self._description = None
+        self._have_items = False
+        self._next_record = None
+        chandle = Handle()
+        rc = MsiDatabaseOpenView(self._connection._handle,
+                                 operation,
+                                 byref(chandle))
+        if rc != ERROR_SUCCESS:
+            raise error(rc)
+        self._view = chandle.value
+        try:
+            record = Record(parameters)
+            try:
+                rc = MsiViewExecute(self._view, record.handle)
+                if rc != ERROR_SUCCESS:
+                    raise error(rc)
+            finally:
+                record.close()
+            if self._select_pattern.match(operation) is None:
+                self._close_view()
+            else:
+                definitions = column_info(self._view, MSICOLINFO_TYPES)
+                if definitions:
+                    names = column_info(self._view, MSICOLINFO_NAMES)
+                    self._description = [
+                        (nm,) + field_type(defn)
+                           for nm, defn in itertools.izip(names,
+                                                          definitions)]
+                    self._get_next_record()
+        except Exception:
+            self._close_view()
+            raise
+    description = property(lambda self: self._description)
+    def executemany(self, operation, seq_of_parameters):
+        if not self:
+            raise OperationalError("Operation on a closed cursor")
+        self._close_view()
+        self._description = None
+        self._have_items = False
+        self._next_record = None
+        chandle = Handle()
+        rc = MsiDatabaseOpenView(self._connection._handle,
+                                 operation,
+                                 byref(chandle))
+        if rc != ERROR_SUCCESS:
+            raise error(rc)
+        self._view = chandle.value
+        try:
+            for parameters in seq_of_parameters:
+                record = Record(parameters)
+                try:
+                    rc = MsiViewExecute(self._view, record.handle)
+                    if rc != ERROR_SUCCESS:
+                        raise error(rc)
+                finally:
+                    record.close()
+                if (self._select_pattern.match(operation) is not None and
+                    column_info(self._view, MSICOLINFO_TYPES)):
+                    self._description = []
+                    try:
+                        self._get_next_record()
+                    finally:
+                        self._description = None
+                    if self._have_items:
+                        self._have_items = False
+                        self._next_record = None
+                        raise DatabaseError("Unexpected result set created by"
+                                            " the operation")
+        finally:
+            self._close_view()
+    def get_rowcount(self):
+        if self._next_record is not None:
+            return None
+        if self._have_items:
+            return 0
+        return -1
+    rowcount = property(get_rowcount)
+    def fetchone(self):
+        if not self._have_items:
+            raise ProgrammingError("No records to fetch")
+        record = self._next_record
+        if record is not None:
+            self._get_next_record()
+        return record
+    def fetchall(self):
+        return [record for record in self]
+    def close(self):
+        if self:
+            self._close_view()
+            self._description = None
+            self._next_record = None
+            self._have_items = False
+            self._connection._remove_cursor(self._key)
+            self._connection = None
+            self._status = 0
+    def __nonzero__(self):
+        return self._connection is not None
+    def __del__(self):
+        self.close()
+    def _close_view(self):
+        if self._view is not None:
+            MsiViewClose(self._view)
+            MsiCloseHandle(self._view)
+            self._view = None
+    def _get_next_record(self):
+        self._next_record = None
+        c_handle = Handle()
+        rc = MsiViewFetch(self._view, byref(c_handle))
+        if rc == ERROR_NO_MORE_ITEMS:
+            self._close_view()
+            return
+        if rc != ERROR_SUCCESS:
+            raise error(rc)
+        self._have_items = True
+        try:
+            record = []
+            for i, format in enumerate(self.description):
+                typ = format[1]
+                fld = i + 1
+                if typ is OBJECT:
+                    record.append(None)
+                elif typ is STRING:
+                    record.append(get_field_string(c_handle.value, fld))
+                elif typ is NUMBER:
+                    record.append(get_field_number(c_handle.value, fld))
+                else:
+                    record.append(get_field_stream(c_handle.value, fld))
+            self._next_record = record
+        finally:
+            MsiCloseHandle(c_handle.value)
+    def __iter__(self):
+        return self
+    def next(self):
+        nxt = self.fetchone()
+        if nxt is None:
+            raise StopIteration()
+        return nxt
+class Connection(object):
+    def __new__(cls, handle, commit_on_close):
+        self = object.__new__(cls)
+        self._handle = handle
+        self._cursors = {}
+        self._rollback = False
+        self._commit_on_close = commit_on_close
+        self._next_cursor_key = 0
+        return self
+    def close(self):
+        if self:
+            for cursor_weakref in self._cursors.values():
+                cursor = cursor_weakref()
+                if cursor is not None:
+                    cursor.close()
+            self._cursors = None
+            if self._commit_on_close or not self._rollback:
+                try:
+                    self.commit()
+                except StandardError:
+                    pass
+            MsiCloseHandle(self._handle)
+            self._handle = None
+    def __del__(self):
+        self.close()
+    def cursor(self):
+        key = self._next_cursor_key
+        cursor = Cursor(self, key)
+        self._next_cursor_key += 1
+        self._cursors[key] = weakref.ref(cursor)
+        return cursor
+    def commit(self):
+        if not self:
+            raise OperationalError("Commit not supported on a closed database")
+        rc = MsiDatabaseCommit(self._handle)
+        if rc != ERROR_SUCCESS:
+            raise error(rc)
+    def rollback(self):
+        self._rollback = True
+    def __nonzero__(self):
+        return self._handle is not None
+    def _remove_cursor(self, key):
+        del self._cursors[key]
+#   Public api
+# database open read-only, no persistent changes
+OPEN_READONLY = cast(0, Tchar_p)
+# database read/write in transaction mode
+OPEN_TRANSACT = cast(1, Tchar_p)
+# database direct read/write without transaction
+OPEN_DIRECT = cast(2, Tchar_p)
+# create new database, direct mode read/write
+OPEN_CREATE = cast(3, Tchar_p)
+apilevel = '2.0'
+threadsafety = 1
+paramstyle = 'qmark'
+class Error(StandardError):
+    pass
+class Warning(StandardError):
+    pass
+class InterfaceError(Error):
+    pass
+class DatabaseError(Error):
+    pass
+class InternalError(DatabaseError):
+    pass
+class OperationalError(DatabaseError):
+    pass
+class ProgrammingError(DatabaseError):
+    pass
+class IntegrityError(DatabaseError):
+    pass
+class DataError(DatabaseError):
+    pass
+class NotSupportedError(DatabaseError):
+    pass
+class Stream(object):
+    def __init__(self, file_path):
+        if not isinstance(file_path, TStr):
+            raise TypeError("The file path is not of type %s" % TStr)
+        self.file_path = file_path
+def connect(dsn, persist=None):
+    if persist is None:
+        persist = OPEN_READONLY
+    handle = Handle()
+    rc = MsiOpenDatabase(dsn, persist, byref(handle))
+    if rc != ERROR_SUCCESS:
+        raise error(rc)
+    try:
+        return Connection(handle.value, persist is OPEN_DIRECT)
+    except Exception:
+        MsiCloseHandle(handle.value)
+#   Api dependent stuff
+msi_errors = {
+      (InternalError, "The handle is invalid"),
+      (ProgrammingError, "SQL query syntax invalid or unsupported"),
+      (InternalError, "Function failed during execution"),
+      (ProgrammingError, "Data of this type is not supported"),
+      (ProgrammingError, "The parameter is incorrect"),
+      (OperationalError, "The system cannot open the device or file specified")
+    }
+def error(rc):
+    try:
+        typ, msg = msi_errors[rc]
+    except IndexError:
+        msg = "Unexpected MSI error %d" % rc
+        typ = InternalError
+    return typ(msg)
+column_formats = {
+    's': (STRING, False),
+    'S': (STRING, True),
+    'l': (STRING, False),
+    'L': (STRING, True),
+    'i': (NUMBER, False),
+    'I': (NUMBER, True),
+    'v': (BINARY, False),
+    'V': (BINARY, True),
+    'g': (STRING, False),
+    'G': (STRING, True),
+    'j': (NUMBER, False),
+    'J': (NUMBER, True),
+    'o': (OBJECT, True),
+    'O': (OBJECT, True)
+    }
+number_specs = {
+    0: (None, None, None),
+    1: (4, 1, 3),
+    2: (6, 2, 5),
+    4: (11, 4, 10)
+    }
+def field_type(code):
+    if code is None:
+        return (None,) * 6
+    data_type, null_ok = column_formats[code[0]]
+    width = int(code[1:])
+    if data_type is OBJECT:
+        display_size = 0
+        internal_size = None
+        precision = None
+    elif data_type is NUMBER:
+        display_size, internal_size, precision = number_specs[width]
+    elif width == 0:
+        display_size = None
+        internal_size = None
+        precision = None
+    else:
+        display_size = width
+        internal_size = width
+        precision = None
+    return (data_type, display_size, internal_size, precision, None, null_ok)
+           'STRING', 'NUMBER', 'BINARY', 'apilevel', 'threadsafety',
+           'paramstyle','Error', 'Warning', 'InterfaceError', 'DatabaseError',
+           'InternalError', 'OperationalError', 'ProgrammingError',
+           'IntegrityError', 'DataError', 'NotSupportedError', 'Stream',
+           'connect']