Hello @piac and all,
I wanted to report a bug that we found in GHPython for Mac but I first wanted to take the opportunity to say how incredibly awesome it is to have the updated version of IronPython inside GHPython on Rhino 6. We have been able to assemble a much better set of Ladybug Tools plugins (that we are close to releasing on Food4Rhino) thanks in large part to all of the new modules/capabilities that didn’t exist in the Rhino 5 version (
sqlite3, updated web encryption that can be used to securely download files).
Along these lines, we have found that the
sqlite3 module in GHPython for Mac is currently unusable. Whenever it gets to the point where we execute an SQLite query, we get the following error:
Runtime error (EntryPointNotFoundException): LockFileEx assembly:<unknown assembly> type:<unknown type> member:(null)
Creating the connection, pointing the cursor, and everything else succeeds. It’s just the execution of the query that fails. So the following code should reproduce the error with the sqlite file I attached in the .zip file:
import sqlite3 file_path = './eplusout_monthly.sql' conn = sqlite3.connect(file_path) c = conn.cursor() c.execute('SELECT * FROM ReportDataDictionary WHERE Name=?', ('Zone Lights Electric Energy',))
eplusout_monthly.zip (191.9 KB)
The error should be on that last line there and note that the error only happens on Mac (it’s perfectly fine on Windows).
From what I can tell from my quick research, this error seems to be specifically the result of using IronPython on Mac and I verified that the sqlite3 queries work perfectly fine with a standalone installation of Python 3.7 on Mac.
Any insights you can share would be appreciated and I am happy to run more tests on my end if it’s helpful.