use super::native::{text, NativeLookup};
use super::{params, Catalog, OptionalExtension, Result};
use crate::mvcc::native::NativeRecordFamily as Family;
impl Catalog {
pub fn save_model(&self, name: &str, json: &str) -> Result<()> {
if self
.put_native_named(Family::Models, &[text(name), text(json)])?
.is_some()
{
return Ok(());
}
self.conn.with(|c| {
c.execute(
"INSERT OR REPLACE INTO _models (name, body) VALUES (?1, ?2)",
params![name, json],
)?;
Ok(())
})
}
pub fn load_models(&self) -> Result<Vec<(String, String)>> {
if let Some(models) = self.load_native_named(Family::Models, 1, false)? {
return Ok(models);
}
self.conn.with(|c| {
let mut stmt = c.prepare("SELECT name, body FROM _models ORDER BY name")?;
let rows =
stmt.query_map([], |r| Ok((r.get::<_, String>(0)?, r.get::<_, String>(1)?)))?;
let mut out = Vec::new();
for row in rows {
out.push(row?);
}
Ok(out)
})
}
pub fn load_model(&self, name: &str) -> Result<Option<String>> {
if let NativeLookup::Value(model) = self.get_native_named(Family::Models, name, 1)? {
return Ok(model);
}
self.conn.with(|c| {
Ok(c.query_row(
"SELECT body FROM _models WHERE name = ?1",
params![name],
|r| r.get::<_, String>(0),
)
.optional()?)
})
}
pub fn drop_model(&self, name: &str) -> Result<()> {
if self.drop_native_named(Family::Models, name)?.is_some() {
return Ok(());
}
self.conn.with(|c| {
c.execute("DELETE FROM _models WHERE name = ?1", params![name])?;
Ok(())
})
}
pub fn save_scoring_params(&self, name: &str, params_json: &str) -> Result<()> {
if self
.put_native_named(Family::ScoringParams, &[text(name), text(params_json)])?
.is_some()
{
return Ok(());
}
self.conn.with(|c| {
c.execute(
"INSERT OR REPLACE INTO _scoring_params (name, params) VALUES (?1, ?2)",
params![name, params_json],
)?;
Ok(())
})
}
pub fn load_scoring_params(&self, name: &str) -> Result<Option<String>> {
if let NativeLookup::Value(params) =
self.get_native_named(Family::ScoringParams, name, 1)?
{
return Ok(params);
}
self.conn.with(|c| {
Ok(c.query_row(
"SELECT params FROM _scoring_params WHERE name = ?1",
params![name],
|r| r.get::<_, String>(0),
)
.optional()?)
})
}
pub fn load_all_scoring_params(&self) -> Result<Vec<(String, String)>> {
if let Some(params) = self.load_native_named(Family::ScoringParams, 1, false)? {
return Ok(params);
}
self.conn.with(|c| {
let mut stmt = c.prepare("SELECT name, params FROM _scoring_params ORDER BY name")?;
let rows =
stmt.query_map([], |r| Ok((r.get::<_, String>(0)?, r.get::<_, String>(1)?)))?;
let mut out = Vec::new();
for row in rows {
out.push(row?);
}
Ok(out)
})
}
pub fn drop_scoring_params(&self, name: &str) -> Result<()> {
if self
.drop_native_named(Family::ScoringParams, name)?
.is_some()
{
return Ok(());
}
self.conn.with(|c| {
c.execute("DELETE FROM _scoring_params WHERE name = ?1", params![name])?;
Ok(())
})
}
}