Crate rusqlite_regex

rusqlite_regex

Description

A SQLite extension for regular expressions written in pure Rust. Based on rusqlite and regex.

Usage

Add this to your Cargo.toml:

[dependencies]
rusqlite_regex = "~0.5"

Example

fn main() -> Result<(), rusqlite::Error> {
    rusqlite_regex::enable_auto_extension()?;
    
    let conn = rusqlite::Connection::open_in_memory()?;
    conn.execute_batch("
        CREATE TABLE test (id INTEGER PRIMARY KEY, name TEXT);
        INSERT INTO test (name) VALUES ('I categorically deny having triskaidekaphobia.');
    ")?;
    assert_eq!(1,
       conn.query_row(
           "SELECT id FROM test WHERE name REGEXP '\\b\\w{13}\\b'",
           [], |row| row.get::<_, i64>(0)
       )?
    );
    Ok(())
}

Version map

This is the compatible version map between rusqlite_regex and rusqlite:

rusqlite_regex version	rusqlite version
=0.6.0	>=0.32,<1.0
=0.5.0	~0.35
=0.4.0	~0.34
=0.3.0	~0.33
=0.2.0	~0.32
=0.1.0	~0.32

License

This project is licensed under either of

Apache License, Version 2.0, (LICENSE-APACHE or https://www.apache.org/licenses/LICENSE-2.0) MIT license (LICENSE-MIT or https://opensource.org/licenses/MIT)

at your option.

Modules

cache

Compiled regex cache.

error

Handle rusqlite errors.

extension

Raw extension functions.

Functions

disable_auto_extension

Disable sqlite3_regex_init() as an auto extension.

enable_auto_extension

Enable sqlite3_regex_init() as an auto extension.