Struct LocalInfileHandler

pub struct LocalInfileHandler(/* private fields */);

Callback to handle requests for local files. Consult Mysql documentation for the format of local infile data.

Support

Note that older versions of Mysql server may not support this functionality.

use mysql::*;
use mysql::prelude::*;

use std::io::Write;

let pool = Pool::new(get_opts())?;
let mut conn = pool.get_conn().unwrap();

conn.query_drop("CREATE TEMPORARY TABLE mysql.tbl(a TEXT)").unwrap();
conn.set_local_infile_handler(Some(
    LocalInfileHandler::new(|file_name, writer| {
        writer.write_all(b"row1: file name is ")?;
        writer.write_all(file_name)?;
        writer.write_all(b"\n")?;

        writer.write_all(b"row2: foobar\n")
    })
));

match conn.query_drop("LOAD DATA LOCAL INFILE 'file_name' INTO TABLE mysql.tbl") {
    Ok(_) => (),
    Err(Error::MySqlError(ref e)) if e.code == 1148 => {
        // functionality is not supported by the server
        return Ok(());
    }
    err => {
        err.unwrap();
    }
}

let mut row_num = 0;
let result: Vec<String> = conn.query("SELECT * FROM mysql.tbl").unwrap();
assert_eq!(
    result,
    vec!["row1: file name is file_name".to_string(), "row2: foobar".to_string()],
);

Implementations

impl LocalInfileHandler

pub fn new<F>(f: F) -> Self

where F: for<'a> FnMut(&'a [u8], &'a mut LocalInfile<'_>) -> Result<()> + Send + 'static,

Trait Implementations

impl Clone for LocalInfileHandler

fn clone(&self) -> LocalInfileHandler

Returns a copy of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for LocalInfileHandler

fn fmt(&self, f: &mut Formatter<'_>) -> Result<(), Error>

Formats the value using the given formatter.

impl PartialEq for LocalInfileHandler

fn eq(&self, other: &LocalInfileHandler) -> bool

Tests for self and other values to be equal, and is used by ==.

fn ne(&self, other: &Rhs) -> bool

Tests for !=. The default implementation is almost always sufficient, and should not be overridden without very good reason.

impl Eq for LocalInfileHandler