代码拉取完成，页面将自动刷新
Add SQLite persistence to your Tauri applications and access any SQLite database on the computer.
Tauri plugins with an API require 2 steps
In the file src-tauri/Cargo.toml, add the dependency to the list
This page in French[dependencies]
tauri-plugin-sqlite-store = { git = "https://github.com/Sylvaner/tauri-plugin-sqlite-store", branch = "main" }
It will be compiled automatically when compiling the application.
Access to features is with an API that makes it easier to use. Depending on your package manager:
pnpm add https://github.com/Sylvaner/tauri-plugin-sqlite-store
# ou
npm add https://github.com/Sylvaner/tauri-plugin-sqlite-store
# ou
yarn add https://github.com/Sylvaner/tauri-plugin-sqlite-store
In the main function in file src-tauri/src/main.rs, register the plugin :
fn main() {
tauri::Builder::default()
.plugin(tauri_plugin_sqlite_store::init()) // Add this line
.run(tauri::generate_context!())
.expect("error while running tauri application");
}
The plugin creates a file store.sqlite in the APP_DATA directory. To allow this file to be written, you must modify the file tauri.conf.json to add permissions to this directory:
"tauri": {
"allowlist": {
"all": false,
"fs": { // Début
"readFile": true, //
"writeFile": true, //
"createDir": true, //
"scope": ["$APPDATA/*"] //
}, // Fin
"shell": {
"all": false,
"open": true
}
},
Access to a database in a specific location
In this case, you must add the access permissions to the directory or to all the files on the computer (not recommended). In the file tauri.conf.json:
"tauri": {
"allowlist": {
"all": false,
"fs": { // Début
"readFile": true, //
"writeFile": true, //
"createDir": true, //
"scope": ["**"] //
}, // Fin
"shell": {
"all": false,
"open": true
}
},
Import the class SQLite into your code so you can use it directly
import { SqliteStore } from 'tauri-plugin-sqlite-store';
async function initDb() {
const db = await SQliteStore.load();
await db.execute(`CREATE DATABASE test (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL
)`);
await db.execute(`INSERT INTO test VALUES (NULL, ?1)`, ['John']);
await db.execute(`INSERT INTO test VALUES (NULL, ?1)`, ['Bill']);
const rows = await db.select<{id, name}>('SELECT * FROM test');
for (row of rows) {
console.log(`${row.name} - Id: ${row.id}`);
}
}
The method of opening a database is the only thing that changes:
const db = await SQliteStore.open('/path/to/the/db');
All features are accessible from SQLiteStore:
load - Load local storeopen - Open a specific databaseselect - Read a datasetselectFirst - Read the first result of a datasetexecute - Run a querybatch - Run a list of queriessetPragma - Run a PRAGMA queryHelp is provided for creating tables with a générateur de requêtes.
import { SqliteStore } from 'tauri-plugin-sqlite-store';
async function initDb() {
const db = await SQliteStore.load();
// `CREATE DATABASE test (
// id INTEGER PRIMARY KEY AUTOINCREMENT,
// name TEXT NOT NULL
//)`
const gen = db.getTableGenerator('test');
gen.addColumn('id', 'INTEGER', {primaryKey: true, autoIncrement: true});
gen.addColumn('name', 'TEXT', {notNull: true});
await db.execute(gen.getCreateTableQuery());
// `CREATE DATABASE same_test (
// id INTEGER PRIMARY KEY AUTOINCREMENT,
// name TEXT NOT NULL
//)`
await db.create({
name: 'same_test',
columns: [
{
name: 'id',
type: 'INTEGER',
options: {
primaryKey: true,
autoIncrement: true
}
},
{
name: 'name',
type: 'TEXT',
options: {
notNull: true
}
}
]
});
}
The API documentation is accessible directly from GitHub: Documentation
Dans le répertoire example se trouve une application fonctionnelle avec le plugin installé. Pour le lancer :
cd example
yarn install
yarn tauri dev
The important files are:
src/App.svelte : API Usagesrc-tauri/src/main.rs : API registrationsrc-tauri/tauri.conf.json : Configuration permissionsyarn install
yarn build
Files are generated in the folder webview-dist.
MIT or MIT/Apache 2.0 where applicable.
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。