Research
Security News
Quasar RAT Disguised as an npm Package for Detecting Vulnerabilities in Ethereum Smart Contracts
Socket researchers uncover a malicious npm package posing as a tool for detecting vulnerabilities in Etherium smart contracts.
adodbapi
A Python DB-API 2.0 (PEP-249) module that makes it easy to use Microsoft ADO for connecting with databases and other data sources using either CPython or IronPython.
Home page: http://sourceforge.net/projects/adodbapi
Features:
Prerequisites:
Installation:
NOTE: ........... If you do not like the new default operation of returning Numeric columns as decimal.Decimal, you can select other options by the user defined conversion feature. Try: adodbapi.apibase.variantConversions[adodbapi.ado_consts.adNumeric] = adodbapi.apibase.cvtString or: adodbapi.apibase.variantConversions[adodbapi.ado_consts.adNumeric] = adodbapi.apibase.cvtFloat or: adodbapi.apibase.variantConversions[adodbapi.ado_consts.adNumeric] = write_your_own_convertion_function ............ notes for 2.6.2: The definitive source has been moved to https://github.com/mhammond/pywin32/tree/master/adodbapi. Remote has proven too hard to configure and test with Pyro4. I am moving it to unsupported status until I can change to a different connection method. whats new in version 2.6 A cursor.prepare() method and support for prepared SQL statements. Lots of refactoring, especially of the Remote and Server modules (still to be treated as Beta code). The quick start document 'quick_reference.odt' will export as a nice-looking pdf. Added paramstyles 'pyformat' and 'dynamic'. If your 'paramstyle' is 'named' you must pass a dictionary of parameters to your .execute() method. If your 'paramstyle' is 'format' 'pyformat' or 'dynamic', you may pass a dictionary of parameters -- provided your SQL operation string is formatted correctly.
whats new in version 2.5 Remote module: (works on Linux!) allows a Windows computer to serve ADO databases via PyRO Server module: PyRO server for ADO. Run using a command like= C:>python -m adodbapi.server (server has simple connection string macros: is64bit, getuser, sql_provider, auto_security) Brief documentation included. See adodbapi/examples folder adodbapi.rtf New connection method conn.get_table_names() --> list of names of tables in database
Vastly refactored. Data conversion things have been moved to the new adodbapi.apibase module. Many former module-level attributes are now class attributes. (Should be more thread-safe) Connection objects are now context managers for transactions and will commit or rollback. Cursor objects are context managers and will automatically close themselves. Autocommit can be switched on and off. Keyword and positional arguments on the connect() method work as documented in PEP 249. Keyword arguments from the connect call can be formatted into the connection string. New keyword arguments defined, such as: autocommit, paramstyle, remote_proxy, remote_port. *** Breaking change: variantConversion lookups are simplified: the following will raise KeyError: oldconverter=adodbapi.variantConversions[adodbapi.adoStringTypes] Refactor as: oldconverter=adodbapi.variantConversions[adodbapi.adoStringTypes[0]]
LGPL, see http://www.opensource.org/licenses/lgpl-license.php
Look at adodbapi/quick_reference.md http://www.python.org/topics/database/DatabaseAPI-2.0.html read the examples in adodbapi/examples and look at the test cases in adodbapi/test directory.
The adodbapi mailing lists have been deactivated. Submit comments to the pywin32 or IronPython mailing lists. -- the bug tracker on sourceforge.net/projects/adodbapi may be checked, (infrequently). -- please use: https://github.com/mhammond/pywin32/issues
FAQs
A pure Python package implementing PEP 249 DB-API using Microsoft ADO.
We found that adodbapi demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 2 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Research
Security News
Socket researchers uncover a malicious npm package posing as a tool for detecting vulnerabilities in Etherium smart contracts.
Security News
Research
A supply chain attack on Rspack's npm packages injected cryptomining malware, potentially impacting thousands of developers.
Research
Security News
Socket researchers discovered a malware campaign on npm delivering the Skuld infostealer via typosquatted packages, exposing sensitive data.