Struct cuppa::database::DataBase

pub struct DataBase {
    pub host: &'static str,
    pub port: u16,
    pub db: &'static str,
    pub user: &'static str,
    pub pass: &'static str,
    pub pool: Pool,
}

Fields

host: &'static str

port: u16

db: &'static str

user: &'static str

pass: &'static str

pool: Pool

Implementations

impl DataBase

pub fn new(
    host: &'static str,
    port: u16,
    db: &'static str,
    user: &'static str,
    pass: &'static str
) -> DataBase

EXAMPLE

let db = DataBase::new("localhost", 3306, "rust", "root", "");

pub fn add(
    &self,
    table: String,
    data: Map<String, Value>,
    condition: String,
    columns: String
) -> Result<Map<String, Value>, String>

Mix of Insert / Update: The method checks if a row already exists and update it; otherwise, insert a new record. Both cases return the affected row.

EXAMPLE

let mut data = Map::new();
    data.insert("name".to_string(), json!("Zulay"));
 
let row = db.add("users".to_string(), data, "id = 333".to_string(), "".to_string());
println!("{:?}", row);

pub fn insert(
    &self,
    table: String,
    data: Map<String, Value>,
    columns: String
) -> Result<Map<String, Value>, String>

Example

let mut data = Map::new();
    data.insert("name".to_string(), json!("Francisco"));
 
let row = db.insert("users".to_string(), data, "".to_string());
println!("{:?}", row);

pub fn update(
    &self,
    table: String,
    data: Map<String, Value>,
    condition: String,
    columns: String
) -> Result<Map<String, Value>, String>

Example

let mut data = Map::new();
    data.insert("name".to_string(), json!("Francisco"));

let row = db.update("users".to_string(), data, "id = 1".to_string(), "".to_string());
println!("{:?}", row);

pub fn get_list(
    &self,
    table: String,
    condition: String,
    limit: String,
    order_by: String,
    columns: String
) -> Result<Vec<Map<String, Value>>, String>

Example

let rows = db.get_list("users".to_string(), "".to_string(), "10".to_string(), "id ASC".to_string(), "id, name".to_string());
println!("{:?}", rows);

pub fn get_total_rows(&self, table: String, condition: String) -> i32

Example

let total_rows = db.get_total_rows("users".to_string(), "".to_string());
println!("{:?}", total_rows);

pub fn get_row(
    &self,
    table: String,
    condition: String,
    order_by: String,
    columns: String
) -> Result<Map<String, Value>, String>

Example

let row = db.get_row("users".to_string(), "id = 1".to_string(), "".to_string(), "".to_string());
println!("{:?}", row);

pub fn sql(&self, sql: String) -> Result<Vec<Map<String, Value>>, String>

Example

let rows = db.sql("SELECT * from users".to_string()).unwrap();
println!("{:?}", rows);

pub fn last_table_id(&self, table: String) -> i64

pub fn last_insert_id(&self) -> i64

Trait Implementations

impl Debug for DataBase

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

Formats the value using the given formatter.