Supporting JSON1 extension in iOS app

[thachnb85]

Hi, I am going to use some json1 support queries in the app, my web app works OK, but my iOS app it has error:

[VERBOSE-2:ui_dart_state.cc(186)] Unhandled Exception: SqliteException(1): no such function: json_extract, SQL logic error (code 1)
#0      throwException (package:sqlite3/src/impl/exception.dart:31:3)
#1      DatabaseImpl.prepare (package:sqlite3/src/impl/database.dart:185:7)
#2      _VmDelegate.runSelect (package:moor/src/ffi/vm_database.dart:220:22)
#3      _ExecutorWithQueryDelegate.runSelect.<anonymous closure> (package:moor/src/runtime/executor/helpers/engines.dart:41:19)
#4      Lock.synchronized.callBlockAndComplete (package:moor/src/utils/synchronized.dart:18:27)
#5      Lock.synchronized.callBlockAndComplete (package:moor/src/utils/synchronized.dart:16:35)
#6      Lock.synchronized.<anonymous closure> (package:moor/src/utils/synchronized.dart:24:53)
#7      _rootRunUnary (dart:async/zone.dart:1362:47)
#8      _CustomZone.runUnary (dart:async/zone.dart:1265:19)
<asynchronous suspension>
#9      _ExecutorWithQueryDelegate._synchronized (package:moor/src/runtime/executor/helpers/engines.dart:2<…>

Hi, I've read the document and adding build.yaml, same level with pubspec.yaml

targets:
  $default:
    builders:
      moor_generator:
        options:
          sqlite_modules:
            - json1
            - moor_ffi

And also in my code I imported moor_ffi already

import 'package:moor/ffi.dart';

Is there anything that I am missing to add?
Thank you!

[simolus3]

Are you using the latest version of sqlite3_flutter_libs? The generator options only configure static analysis, that doesn't have any impact on what's available at runtime.

[thachnb85]

Thank you, I've checked and switched to sqlite3_flutter_libs latest version!! It's working now. Have a great weekend @simolus3