todo / src /main.rs
arami21's picture
Update src/main.rs
7fd582a verified
Raw History Blame Contribute Delete
3.46 kB
use actix_web::{
App, HttpResponse, HttpServer, Responder, delete, get, post, put,
web::{self, Data, Json},
};
use serde::{Deserialize, Serialize};
use sqlx::{PgPool, prelude::FromRow};
#[actix_web::main]
async fn main() -> std::io::Result<()> {
println!("START APP");
dotenvy::dotenv().ok();
println!("LOAD ENV");
let pool = db().await;
println!("DATABASE CONNECTED");
println!("START SERVER");
HttpServer::new(move || {
App::new()
.app_data(Data::new(pool.clone()))
.service(todo_list)
.service(add_todo)
.service(get_single_todo)
.service(delete_todo)
.service(update_todo)
})
.bind(("0.0.0.0", 7860))?
.run()
.await
}
#[get("/todo_list")]
async fn todo_list(pool: web::Data<PgPool>) -> impl Responder {
let todos: Vec<TodoSql> = sqlx::query_as("Select * FROM todos")
.persistent(false)
.fetch_all(pool.get_ref())
.await
.unwrap();
let todos_json = serde_json::to_string_pretty(&todos).unwrap();
HttpResponse::Ok().body(todos_json)
}
#[post("/add_todo")]
async fn add_todo(pool: web::Data<PgPool>, todo_req: Json<TodoReq>) -> impl Responder {
sqlx::query("INSERT INTO todos (content) VALUES ($1)")
.persistent(false)
.bind(&todo_req.content)
.execute(pool.get_ref())
.await
.unwrap();
HttpResponse::Ok().body("Add new Todo")
}
#[get("/todo/{id}")]
async fn get_single_todo(pool: web::Data<PgPool>, path: web::Path<i32>) -> impl Responder {
let id = path.into_inner();
let rows: Vec<TodoSql> = sqlx::query_as("SELECT * FROM todos WHERE id = $1")
.persistent(false)
.bind(&id)
.fetch_all(pool.get_ref())
.await
.unwrap();
if rows.len() == 0 {
let msg = format!("NO todo : id : {} found!", id);
HttpResponse::NotFound().body(msg)
} else {
let todo_json = serde_json::to_string_pretty(&rows[0]).unwrap();
HttpResponse::Ok().body(todo_json)
}
}
#[delete("/delete/{id}")]
async fn delete_todo(pool: web::Data<PgPool>, path: web::Path<i32>) -> impl Responder {
let id = path.into_inner();
match sqlx::query("DELETE FROM todos WHERE id = $1")
.persistent(false)
.bind(&id)
.execute(pool.get_ref())
.await
{
Ok(_) => HttpResponse::Ok().body("Remove Todo!"),
Err(err) => HttpResponse::InternalServerError().body(format!("Database Error: {}", err)),
}
}
#[put("/update/{id}")]
async fn update_todo(
pool: web::Data<PgPool>,
path: web::Path<i32>,
todo_req: Json<TodoReq>,
) -> impl Responder {
let id = path.into_inner();
match sqlx::query("UPDATE todos SET content = $1 WHERE id = $2")
.persistent(false)
.bind(&todo_req.content)
.bind(&id)
.execute(pool.get_ref())
.await
{
Ok(_) => HttpResponse::Ok().body("Update Todo!"),
Err(err) => HttpResponse::InternalServerError().body(format!("Database Error: {}", err)),
}
}
async fn db() -> PgPool {
let database_url = std::env::var("DATABASE_URL").expect("DATABASE_URL not found");
let pool = sqlx::postgres::PgPool::connect(&database_url)
.await
.unwrap();
pool
}
#[derive(FromRow, Serialize)]
struct TodoSql {
id: i32,
content: String,
}
#[derive(Deserialize)]
struct TodoReq {
content: String,
}