#[get("/")]
fn getRequest() -> JsonValue {
    let mut data = fetch();

    data
}

fn fetch() -> JsonValue {
    let pool =
        Pool::new("mysql://username:password@host:3306/database_name")
            .unwrap();

    let mut conn = pool.get_conn().unwrap();
    let selected_payments = conn
        .query_map(
            "SELECT sid, name, email, age from student",
            |(sid, name, email, age)| Student {
                sid,
                name,
                email,
                age,
            },
        )
        .unwrap();

    json!(selected_payments)
}

#[post("/add", data = "<user_input>")]
fn helloPost(user_input: Json<Student>, map: State<'_, MessageMap>) -> JsonValue {

    let res: Student = user_input.into_inner();
    let result = insert(res);

    result
}

fn insert(student: Student) -> JsonValue {
    let pool =
        Pool::new("mysql://username:password@host:3306/database_name")
            .unwrap();

    let mut conn = pool.get_conn().unwrap();
    let students = vec![student];

    let b = conn
        .exec_batch(
            r"INSERT INTO student (name, email, age)
          VALUES (:name, :email, :age)",
            students.iter().map(|p| {
                params! {
                    "name" => &p.name,
                    "email" => &p.email,
                    "age"=>&p.age
                }
            }),
        )
        .unwrap();

    let c = conn.last_insert_id();    // gives the last inserted data id
    println!("c value is : {:?}", c);
    json!({ "id": c })
}

#[put("/update", data = "<user_input>")]
fn edit(user_input: Json<Student>, map: State<'_, MessageMap>) -> JsonValue {
    let res: Student = user_input.into_inner();
    update(res);
    json!({"status":"okay"})
}


fn update(student: Student) {
    let pool =
        Pool::new("mysql://username:password@host:3306/database_name")
            .unwrap();
    let mut conn = pool.get_conn().unwrap();

    let students = vec![student];

    conn.exec_batch(
        r"UPDATE student
        set
        name=:name,
        email=:email,
        age=:age
        where sid=:sid",
        students.iter().map(|p| {
            params! {
                "sid" => p.sid,
                "name" => &p.name,
                "email" => &p.email,
                "age"=>&p.age
            }
        }),
    )
    .unwrap();

    println!("updated successfully");
}

#[delete("/delete/<id>")]
fn deleted(id: i32) {
    delete(id);
}

fn delete(id1: i32) {
    let pool =
        Pool::new("mysql://username:password@host:3306/database_name")
            .unwrap();

    let mut conn = pool.get_conn().unwrap();

    conn.exec_drop(
        r"delete from student
        where sid=:sid",
        params! {
            "sid"=> id1,
        },
    )
    .unwrap();
    println!("deleted successfully {:?}", id1);
}