How to use the function that supports sqlite to set password?

[vootooguru]

你好，我看到代码中有给sqlite设置密码的功能，有点小bug会导致设置被覆盖，修改之后，经测试没有效果，请问下怎么才能给sqlite设置密码呢？

 if let Some(pragma_key_password) = self.pragmas.get("key") {
                write!(init, "PRAGMA key = {}; ", pragma_key_password).ok();
 }

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

Hello, I saw that there is a function to set a password for SQLite in the code. A small bug will cause the setting to be overwritten. After modification, it has no effect after testing. How can I set a password for SQLite?

 if let Some(pragma_key_password) = self.pragmas.get("key") {
                write!(init, "PRAGMA key = {}; ", pragma_key_password).ok();
 }

[zhuxiujia]

你好，我看到代码中有给sqlite设置密码的功能，有点小bug会导致设置被覆盖，修改之后，经测试没有效果，请问下怎么才能给sqlite设置密码呢？

 if let Some(pragma_key_password) = self.pragmas.get("key") {
                write!(init, "PRAGMA key = {}; ", pragma_key_password).ok();
 }

    use rbatis::{DefaultPool, RBatis};
    use rbdc_sqlite::{SqliteConnectOptions, SqliteDriver};

    let mut rb = RBatis::new();
    let mut opts = SqliteConnectOptions::default().pragma("key","password");
    opts.set_uri("sqlite://target/sqlite.db");
    rb.init_option::< SqliteDriver, SqliteConnectOptions, DefaultPool>(SqliteDriver{}, opts).unwrap();

[Issues-translate-bot]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

---

Hello, I saw that there is a function to set a password for SQLite in the code. A small bug will cause the setting to be overwritten. After modification, it has no effect after testing. How can I set a password for SQLite?

if let Some(pragma_key_password) = self.pragmas.get("key") {
write!(init, "PRAGMA key = {}; ", pragma_key_password).ok();
}

    use rbatis::{DefaultPool, RBatis};
    use rbdc_sqlite::{SqliteConnectOptions, SqliteDriver};

    let mut rb = RBatis::new();
    let mut opts = SqliteConnectOptions::default().pragma("key","password");
    opts.set_uri("sqlite://target/sqlite.db");
    rb.init_option::< SqliteDriver, SqliteConnectOptions, DefaultPool>(SqliteDriver{}, opts).unwrap();

[zhuxiujia]

run cargo update to up to rbatis = "v4.5.5"

[vootooguru]

run cargo update to up to rbatis = "v4.5.5"

OK，thx！

[vootooguru]

Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑‍🤝‍🧑👫🧑🏿‍🤝‍🧑🏻👩🏾‍🤝‍👨🏿👬🏿

Hello, I saw that there is a function to set a password for SQLite in the code. A small bug will cause the setting to be overwritten. After modification, it has no effect after testing. How can I set a password for SQLite?

if let Some(pragma_key_password) = self.pragmas.get("key") {
write!(init, "PRAGMA key = {}; ", pragma_key_password).ok();
}

    use rbatis::{DefaultPool, RBatis};
    use rbdc_sqlite::{SqliteConnectOptions, SqliteDriver};

    let mut rb = RBatis::new();
    let mut opts = SqliteConnectOptions::default().pragma("key","password");
    opts.set_uri("sqlite://target/sqlite.db");
    rb.init_option::< SqliteDriver, SqliteConnectOptions, DefaultPool>(SqliteDriver{}, opts).unwrap();

按这种方式修改后，option的pragmas应该在某个地方被替换成了默认的值，传入的key参数在实际执行的时候就没有了，我的代连接代码是这样的：

在rbatis连接的代码中加入了日志查看

连接的时候输出是这样的：

我暂时还没找到在哪里被替换成默认值的

[vootooguru]

我估计是这里被替换成默认值了，但在连接池中的创建关系还没理清楚