Function sqlite_loadable::api::result_text

source · 
pub fn result_text<S: AsRef<str>>(
    context: *mut sqlite3_context,
    text: S
) -> Result<()>
Expand description

Calls sqlite3_result_text to represent that a function returns a string with the given value. Fails if the string length is larger than i32 maximum value.

Examples found in repository?
examples/scalar.rs (line 9)
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

fn yo(context: *mut sqlite3_context, _values: &[*mut sqlite3_value]) -> Result<()> {
    api::result_text(context, "yo")?;
    Ok(())
}

// surround_rs(name)
fn surround(context: *mut sqlite3_context, values: &[*mut sqlite3_value]) -> Result<()> {
    let value = api::value_text(values.get(0).expect("1st argument as name"))?;
    api::result_text(context, format!("x{}x", value))?;
    Ok(())
}

// add_rs(a, b)
fn add(context: *mut sqlite3_context, values: &[*mut sqlite3_value]) -> Result<()> {
    let a = api::value_int(values.get(0).expect("1st argument"));
    let b = api::value_int(values.get(1).expect("2nd argument"));
    api::result_int(context, a + b);
    Ok(())
}

// connect(seperator, string1, ...)
fn connect(context: *mut sqlite3_context, values: &[*mut sqlite3_value]) -> Result<()> {
    let seperator = api::value_text(values.get(0).expect("1st argument"))?;
    let strings: Vec<&str> = values
        .get(1..)
        .expect("more than 1 argument to be given")
        .iter()
        .filter_map(|v| api::value_text(v).ok())
        .collect();
    api::result_text(context, strings.join(seperator))?;
    Ok(())
}
More examples
Hide additional examples
examples/hello.rs (line 13)
10
11
12
13
14
15

pub fn hello(context: *mut sqlite3_context, values: &[*mut sqlite3_value]) -> Result<()> {
    let name = api::value_text(values.get(0).expect("1st argument as name"))?;

    api::result_text(context, format!("hello, {}!", name))?;
    Ok(())
}
examples/characters.rs (lines 129-138)
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146

    fn column(&self, context: *mut sqlite3_context, i: i32) -> Result<()> {
        match column(i) {
            Some(Columns::Value) => {
                api::result_text(
                    context,
                    self.characters
                        .as_ref()
                        .unwrap()
                        .get(self.idx)
                        .unwrap()
                        .to_string()
                        .as_str(),
                )?;
            }
            Some(Columns::Input) => {
                api::result_text(context, self.input.as_ref().unwrap())?;
            }
            _ => (),
        }
        Ok(())
    }