rubymotion-community / motion-sqlite3 Goto Github PK

Hey matt,

Love the gem!

There seem to be a conflict with Apple's ServiceManagement framework. After adding motion-sqlite3 gem to my project, the SMLoginItemSetEnabled function is no longer accessible:

app_delegate.rb:3:in `applicationDidFinishLaunching:': undefined method `SMLoginItemSetEnabled' for #<AppDelegate:0x7ffc7072fea0> (NoMethodError)

Any ideas why this could be? I'm about to release an awesome app that uses motion-sqlite3 👍

Cheers Jonas

There's a link error on Big Sur, where /usr/lib/libsqlite3.dylib does not exist.

Reference: https://motioneers.slack.com/archives/C055RDLS0/p1605792055265800

Getting this error:

<Error>: *** Terminating app due to uncaught exception 'SQLite3::SQLite3Error', reason: 'unable to open database file (SQLite3::SQLite3Error)

This error only appears on the device and not on the simulator. All of the DB access is done via the main thread only from a single instance of the Database class.

Database path: File.join(App.resources_path, "offline_store.sqlite3")

Is there any way to do this effectively without using SELECT MAX(id)?

At the moment the project is missing a license file (though the gemspec specifies MIT)…

Hi,

I've just started with RubyMotion and your sqlite3 driver was working great. But after upgrading RubyMotion to 2.22 (from 2.18),

     Build ./build/iPhoneSimulator-7.0-Development
   Compile /Users/jviney/Work/rm/nzf-1/vendor/bundle/ruby/2.0.0/gems/motion-sqlite3-0.5.0/lib/motion-sqlite3/version.rb
   Compile /Users/jviney/Work/rm/nzf-1/vendor/bundle/ruby/2.0.0/gems/motion-sqlite3-0.5.0/lib/motion-sqlite3/result_set.rb
   Compile /Users/jviney/Work/rm/nzf-1/vendor/bundle/ruby/2.0.0/gems/motion-sqlite3-0.5.0/lib/motion-sqlite3/error.rb
   Compile /Users/jviney/Work/rm/nzf-1/vendor/bundle/ruby/2.0.0/gems/motion-sqlite3-0.5.0/lib/motion-sqlite3/statement.rb
2014-02-06 18:46:15.936 ruby[43808:d0f] can't open BridgeSupport full file at path `build/sqlite3.bridgesupport': Error Domain=NSXMLParserErrorDomain Code=4 "zero length data" UserInfo=0x62c1af0 {NSLocalizedDescription=zero length data}
2014-02-06 18:46:15.941 ruby[43807:d0f] can't open BridgeSupport full file at path `build/sqlite3.bridgesupport': Error Domain=NSXMLParserErrorDomain Code=4 "zero length data" UserInfo=0x5d0aed0 {NSLocalizedDescription=zero length data}
r

The bizarre thing is that if I create a new RubyMotion project and copy the application code in, it works fine.

Any idea what's causing this error?

P.S. Thanks for writing this library!

any idea how to make it work on android or some alternative?

Hi again,

I've run into a problem with SQLite FTS. It is not returning all the column data from the search result. Failing test case here: https://github.com/jviney/motion-sqlite3/commit/8eb7e214d7db6de43ed2ecbbca7029ef091f51a3

Running iOS 7 which has SQLite 3.7.13. This code works as expected with Ruby 2.0, SQLite 3.7.13, and sqlite3 gem version 1.3.8.

Any idea why the value for col_2 is not returned in the second row?

Cheers.