welds 0.4.23

An async ORM for (postgres, mssql, mysql, sqlite)
Documentation 
1
2
3
4
5
6
7
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

use crate::writers::{ColumnWriter, TableWriter};
use welds_connections::Syntax;

use crate::detect::TableDef;

/// writes the SQL to Renames a column on a table
pub fn write(
    syntax: Syntax,
    table: &TableDef,
    col: impl Into<String>,
    ty: impl Into<String>,
    nullable: bool,
) -> String {
    let tablename: String = TableWriter::new(syntax).write(&table.ident());
    let col: String = sanitize_column(col.into());
    let col = ColumnWriter::new(syntax).excape(&col);
    let ty: String = ty.into();
    let null = if nullable { "NULL" } else { "NOT NULL" };
    let coldef = format!("{ty} {null}");

    match syntax {
        Syntax::Mssql => format!("ALTER TABLE {tablename} ADD {col} {coldef}"),
        _ => format!("ALTER TABLE {tablename} ADD COLUMN {col} {coldef}"),
    }
}

/// Make sure this string is a valid column name
fn sanitize_column(input: String) -> String {
    input
        .chars()
        .filter(|c| c.is_alphanumeric() || *c == '_')
        .collect::<String>()
}