sqlite3_simple 1.0.3 sqlite3_simple: ^1.0.3 copied to clipboard
基于 Simple (支持中文和拼音的 SQLite fts5 全文搜索扩展) 和 sqlite3.dart 的 Flutter 库,用于 SQLite 中文和拼音全文搜索。
import 'dart:async';
import 'package:extended_text/extended_text.dart';
import 'package:flutter/material.dart';
import 'package:flutter_localizations/flutter_localizations.dart';
import 'package:path/path.dart';
import 'package:path_provider/path_provider.dart';
import 'package:sqlite3/sqlite3.dart' hide Row;
import 'package:sqlite3_simple_example/util/custom_text.dart';
import 'package:sqlite3_simple_example/util/zero_width_text.dart';
import 'dao.dart';
void main() {
runApp(const MyApp());
}
class MyApp extends StatefulWidget {
const MyApp({super.key});
@override
State<MyApp> createState() => _MyAppState();
}
class _MyAppState extends State<MyApp> {
@override
void initState() {
super.initState();
initPlatformState();
}
late final Dao dao;
List<MainTableRow>? results;
Future<void> initPlatformState() async {
final docDir = await getApplicationDocumentsDirectory();
final jiebaDictPath = join(docDir.path, "cpp_jieba");
dao = Dao(() => sqlite3.openInMemory());
await dao.init(jiebaDictPath);
setState(() {
dao.insertRandomData(30);
results = dao.selectAll();
});
}
@override
Widget build(BuildContext context) {
final colorScheme = Theme.of(context).colorScheme;
return MaterialApp(
debugShowCheckedModeBanner: false,
localizationsDelegates: const [
GlobalMaterialLocalizations.delegate,
GlobalWidgetsLocalizations.delegate,
GlobalCupertinoLocalizations.delegate,
],
supportedLocales: const [
Locale('zh', 'CN'), // 通过国际化设置中文环境以让 Flutter 使用正确的中文字体
],
home: Scaffold(
appBar: AppBar(
title: const Text('测试'),
backgroundColor: colorScheme.primary,
foregroundColor: colorScheme.onPrimary,
),
body: SafeArea(
child: Container(
padding: const EdgeInsets.all(16),
child: Column(
mainAxisSize: MainAxisSize.max,
children: [
buildSearchBar(),
buildSearchFilter(),
const SizedBox(height: 8),
Expanded(
child: AnimatedSwitcher(
duration: kThemeChangeDuration,
child: results != null
? buildListView()
: const CircularProgressIndicator(),
),
),
],
),
),
),
),
);
}
static const tokenizerMap = {"jieba": "结巴", "simple": "Simple"};
String tokenizer = tokenizerMap.keys.first;
void onSearchChanged(String value) {
value = value.trim();
setState(() {
showClearButton = value.isNotEmpty;
if (!showClearButton) {
results = dao.selectAll();
return;
}
results = dao.search(value, tokenizer);
});
}
Future<void> onUpdatePressed() async {
setState(() {
results = null;
});
dao.updateAll();
onSearchChanged(searchController.text);
}
final searchController = SearchController();
var showClearButton = false;
Widget buildSearchBar() {
return Row(
mainAxisSize: MainAxisSize.max,
children: [
Expanded(
child: TapRegion(
onTapOutside: (_) => FocusManager.instance.primaryFocus?.unfocus(),
child: SearchBar(
controller: searchController,
leading: const Padding(
padding: EdgeInsets.symmetric(horizontal: 4),
child: Icon(Icons.search),
),
trailing: [
if (showClearButton)
IconButton(
onPressed: () {
searchController.text = "";
onSearchChanged("");
},
icon: const Icon(Icons.clear))
],
elevation: const WidgetStatePropertyAll(0),
shape: WidgetStatePropertyAll(RoundedRectangleBorder(
borderRadius: BorderRadius.circular(8))),
onChanged: onSearchChanged,
),
),
),
],
);
}
bool isHighlight = true;
Widget buildSearchFilter() {
return Row(
mainAxisAlignment: MainAxisAlignment.spaceBetween,
children: [
Row(
mainAxisSize: MainAxisSize.max,
children: [
const Text(
"分词器:",
style: TextStyle(fontSize: 16),
),
DropdownButton<String>(
value: tokenizer,
items: tokenizerMap.entries
.map((e) => DropdownMenuItem(
value: e.key,
child: Text(e.value),
))
.toList(),
onChanged: (value) {
setState(() {
tokenizer = value!;
onSearchChanged(searchController.text);
});
},
),
],
),
const SizedBox(width: 8),
InkWell(
splashColor: Colors.transparent,
highlightColor: Colors.transparent,
onTap: () {
setState(() {
isHighlight = !isHighlight;
onSearchChanged(searchController.text);
});
},
child: Row(
children: [
IgnorePointer(
child: Checkbox(value: isHighlight, onChanged: (_) {}),
),
const Text("是否高亮", style: TextStyle(fontSize: 16))
],
),
),
const SizedBox(width: 8),
const Expanded(child: SizedBox()),
IconButton(
style: ButtonStyle(
tapTargetSize: MaterialTapTargetSize.shrinkWrap,
shape: WidgetStatePropertyAll(RoundedRectangleBorder(
borderRadius: BorderRadius.circular(8)))),
onPressed: onUpdatePressed,
icon: const Icon(Icons.refresh),
)
],
);
}
Widget buildListView() {
final highlightTextBuilder = isHighlight
? CustomTextBuilder([
ZeroWidthText(
const TextStyle(color: Colors.red),
)
])
: null;
return ListView.builder(
itemCount: results!.length,
itemBuilder: (context, index) {
final r = results![index];
return Row(
mainAxisAlignment: MainAxisAlignment.start,
children: [
Text(
"${r.id}".padLeft("${dao.selectCount()}".length, "0"),
style: const TextStyle(
fontSize: 36,
fontWeight: FontWeight.bold,
fontFeatures: [FontFeature.tabularFigures()]),
),
const SizedBox(width: 8),
Expanded(
child: Column(
crossAxisAlignment: CrossAxisAlignment.start,
children: [
SingleChildScrollView(
scrollDirection: Axis.horizontal,
child: Column(
crossAxisAlignment: CrossAxisAlignment.start,
children: [
Row(
children: [
ExtendedText(
r.title,
style: const TextStyle(fontSize: 20),
specialTextSpanBuilder: highlightTextBuilder,
),
],
),
ExtendedText(
r.content,
specialTextSpanBuilder: highlightTextBuilder,
),
],
),
),
Row(
mainAxisAlignment: MainAxisAlignment.end,
children: [
Text(
r.insertDate.toString(),
textAlign: TextAlign.end,
style:
const TextStyle(fontSize: 12, color: Colors.grey),
),
],
)
],
),
),
],
);
},
);
}
}