# Tauri Plugin Rusqlite

This plugin enables access to an SQLite database within Tauri applications. It is inspired by the [tauri-plugin-sqlite](https://github.com/lzdyes/tauri-plugin-sqlite) plugin but is based on [rusqlite](https://github.com/rusqlite/rusqlite).

## Example

- Full example at: <https://github.com/kessdev/tauri-plugin-rusqlite/tree/main/examples/rusqlite-demo>
- Execute the following command in your terminal:

``` bash
npm run tauri dev
```

## Installation

### Rust

- Enter the `src-tauri` directory in your project's structure.

- Execute the following command to add tauri-plugin-rusqlite to your project's dependencies:

``` bash
cargo add tauri-plugin-rusqlite
```

- Open the `main.rs` file located in the `src-tauri/src` directory of your project. Modify the `main` function to include the plugin initialization code.

``` rust
fn main() {
    tauri::Builder::default()
        .plugin(tauri_plugin_rusqlite::init()) // add this
        .run(tauri::generate_context!())
        .expect("error while running tauri application");
}
```

### Webview

- Navigate to the root directory of your source code.

- Execute the following command in your terminal:

``` bash
npm i tauri-plugin-rusqlite-api
```

## Usage

### Import plugin

``` ts
import Rusqlite from 'tauri-plugin-rusqlite-api'
```

### Open database

``` ts
const database = await Rusqlite.openInMemory("test.db");
```
or
``` ts
const database = await Rusqlite.openInPath("./folder/test.db");
```

### Init database

``` ts
let scripts = [{
    name: "create_table", 
    sql: "CREATE TABLE test (id INTEGER PRIMARY KEY, integer_value INTEGER, real_value REAL, text_value TEXT, blob_value BLOB); CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT NOT NULL);"
}];
await database.migration(scripts);
```
or
``` ts
await database.batch(
    "CREATE TABLE test (id INTEGER PRIMARY KEY, integer_value INTEGER, real_value REAL, text_value TEXT, blob_value BLOB); CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT NOT NULL);");
```

### Drop table
``` ts
await database.batch("DROP TABLE test;");
```

### Insert or Update

``` ts
await database.update("INSERT INTO test (integer_value, real_value, text_value, blob_value) VALUES (:integer_value, :real_value, :text_value, :blob_value)", 
new Map([
    [":integer_value", parseInt(target.integer_value.value)], 
    [":real_value", parseFloat(target.real_value.value)], 
    [":text_value", target.text_value.value],
    [":blob_value", target.blob_value.value]
]));
```

### Select

``` ts
let result = await database.select("SELECT * FROM test", new Map());
...
result.map((item) => {
    return {
        id: item.id,
        ...
    };
});
```

### Close database

``` ts
await database.close();
```

## License

[MIT](LICENSE)