rustyroad 1.8.4

Rusty Road is a framework written in Rust that is based on Ruby on Rails. It is designed to provide the familiar conventions and ease of use of Ruby on Rails, while also taking advantage of the performance and efficiency of Rust.
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
34
35
36

//! MySQL enum column reader.

use super::model::DatabaseEnum;
use super::parser::parse_mysql_enum_values;
use crate::database::migrations::CustomMigrationError;
use sqlx::Row;

/// MySQL enum columns, since MySQL keeps enum value lists on the columns.
pub(crate) async fn mysql_enums(
    conn: &sqlx::MySqlPool,
) -> Result<Vec<DatabaseEnum>, CustomMigrationError> {
    let rows = sqlx::query(
        "SELECT table_name, column_name, column_type \
         FROM information_schema.columns \
         WHERE table_schema = DATABASE() AND data_type = 'enum' \
         ORDER BY table_name, ordinal_position",
    )
    .fetch_all(conn)
    .await
    .map_err(|e| CustomMigrationError::SendError(Box::new(e)))?;

    Ok(rows
        .into_iter()
        .map(|row| {
            let table: String = row.get("table_name");
            let column: String = row.get("column_name");
            let column_type: String = row.get("column_type");
            DatabaseEnum {
                values: parse_mysql_enum_values(&column_type),
                name: column_type,
                table: Some(table),
                column: Some(column),
            }
        })
        .collect())
}