Rust: Replace String Substitution

TODO: collapasable, copyable, download, etc

What is the rust code to replace ${START_INTERVAL} in a string with "- INTERVAL 1 day"? Say we have let sql = "SELECT foo FROM bar WHERE startTime > ${START_INTERVAL} ORDER BY startTime;In Rust, you can use the replace function from the String standard library to replace parts of a string. Here's how you can replace ${START_INTERVAL} with - INTERVAL 1 day in your SQL string:

fn main() {
    let mut sql = String::from("SELECT foo FROM bar WHERE startTime > ${START_INTERVAL} ORDER BY startTime;");
    sql = sql.replace("${START_INTERVAL}", "- INTERVAL '1 day'");
    println!("{}", sql);
}

When you run this program, it will print:

SELECT foo FROM bar WHERE startTime > - INTERVAL '1 day' ORDER BY startTime;

Just be careful that this kind of string substitution can make your program vulnerable to SQL Injection attacks. If the replacement string comes from an untrusted source, it's better to use parameterized queries or prepared statements to prevent this kind of security issue.

Rust: Replace String Substitution created at Tue Jan 20 1970 12:45:54 GMT+0000 (Coordinated Universal Time)