libsimple_flutter 0.0.1
libsimple_flutter: ^0.0.1 copied to clipboard
sqlite fts5 libsimple tokenizer plugin.libsimple version 20230628
example/lib/main.dart
import 'package:flutter/material.dart';
import 'dart:async';
import 'package:flutter/services.dart';
import 'package:libsimple_flutter/libsimple_flutter.dart';
import 'package:sqlite3/sqlite3.dart';
void testSqlite() async {
var db = sqlite3.openInMemory();
var re = db.select('select sqlite_version()');
print(re);
db.execute("CREATE VIRTUAL TABLE t1 USING fts5(x, tokenize = 'simple');");
db.execute('''insert into t1(x) values ('周杰伦 Jay Chou:最美的不是下雨天,是曾与你躲过雨的屋檐'),
('I love China! 我爱中国!'),
('@English &special _characters."''bacon-&and''-eggs%');''');
re = db.select("select * from t1 where x match simple_query('zhoujiel')");
print(re);
}
void main() {
runApp(const MyApp());
}
class MyApp extends StatefulWidget {
const MyApp({super.key});
@override
State<MyApp> createState() => _MyAppState();
}
class _MyAppState extends State<MyApp> {
String _platformVersion = 'Unknown';
final _libsimpleFlutterPlugin = LibsimpleFlutter();
@override
void initState() {
super.initState();
initPlatformState();
}
// Platform messages are asynchronous, so we initialize in an async method.
Future<void> initPlatformState() async {
String platformVersion;
// Platform messages may fail, so we use a try/catch PlatformException.
// We also handle the message potentially returning null.
try {
platformVersion = await _libsimpleFlutterPlugin.getPlatformVersion() ??
'Unknown platform version';
} on PlatformException {
platformVersion = 'Failed to get platform version.';
}
// If the widget was removed from the tree while the asynchronous platform
// message was in flight, we want to discard the reply rather than calling
// setState to update our non-existent appearance.
if (!mounted) return;
setState(() {
_platformVersion = platformVersion;
});
}
@override
Widget build(BuildContext context) {
testSqlite();
return MaterialApp(
home: Scaffold(
appBar: AppBar(
title: const Text('Plugin example app'),
),
body: Center(
child: Text('Running on: $_platformVersion\n'),
),
),
);
}
}