[MacPorts] #49317: python34 @3.4.3 Allow loading SQLite extensions

[MacPorts]

#49317: python34 @3.4.3 Allow loading SQLite extensions
--------------------------+----------------------
  Reporter:  m3drano@…    |      Owner:  jwa@…
      Type:  enhancement  |     Status:  new
  Priority:  Normal       |  Milestone:
 Component:  ports        |    Version:  2.3.4
Resolution:               |   Keywords:  haspatch
      Port:  python34     |
--------------------------+----------------------

Comment (by m3drano@…):

 I agree it should be on by default. I have tested this with the SQLite
 version provided by MacPorts (3.8.11.2) and the system default in El
 Capitan (3.8.10.2). It works perfectly with the port, both with the
 sqlite3 tool and the python library. The default sqlite3 install has
 extension loading disabled (both on the sqlite3 tool and the Python 3
 version provided).

 {{{
 $ /usr/bin/sqlite3
 SQLite version 3.8.10.2 2015-05-20 18:17:19
 Enter ".help" for usage hints.
 Connected to a transient in-memory database.
 Use ".open FILENAME" to reopen on a persistent database.
 sqlite> .load liblibsqlitefunctions.so;
 Error: unknown command or invalid arguments:  "load". Enter ".help" for
 help

 $ sqlite3
 SQLite version 3.8.11.1 2015-07-29 20:00:57
 Enter ".help" for usage hints.
 Connected to a transient in-memory database.
 Use ".open FILENAME" to reopen on a persistent database.
 sqlite> .load liblibsqlitefunctions.so

 $ /usr/bin/python
 Python 2.7.10 (default, Aug 22 2015, 20:33:39)
 [GCC 4.2.1 Compatible Apple LLVM 7.0.0 (clang-700.0.59.1)] on darwin
 Type "help", "copyright", "credits" or "license" for more information.
 >>> import sqlite3
 >>> conn = sqlite3.connect('test.db')
 >>> conn.enable_load_extensions(True)
 Traceback (most recent call last):
   File "<stdin>", line 1, in <module>
 AttributeError: 'sqlite3.Connection' object has no attribute
 'enable_load_extensions'
 >>>

 $ python
 Python 3.4.3 (default, Oct 16 2015, 19:24:20)
 [GCC 4.2.1 Compatible Apple LLVM 7.0.0 (clang-700.0.72)] on darwin
 Type "help", "copyright", "credits" or "license" for more information.
 >>> import sqlite3
 >>> conn = sqlite3.connect('tmp.db')
 >>> conn.enable_load_extension(True)
 >>> conn.load_extension('liblibsqlitefunctions.so')
 >>>
 }}}

-- 
Ticket URL: <https://trac.macports.org/ticket/49317#comment:3>
MacPorts <https://www.macports.org/>
Ports system for OS X