#![allow(unused)] // silence unused warnings while exploring (to comment out)

use sqlx::postgres::{PgPoolOptions, PgRow};
use sqlx::{FromRow, Row};


#[derive(Debug, FromRow)]
struct Page {
    page_id: i32,
    slug: String,
    title: String,
    content: String,
}

#[tokio::main]
async fn main() -> Result<(), sqlx::Error> {
    // 1) Create a connection pool
    let pool = PgPoolOptions::new().max_connections(5).connect("postgres://cms:gfhSyu65D3rewfth@localhost/cms").await?;

    // 6) Select query_as (using derive FromRow)
    let select_query = sqlx::query_as::<_, Page>("SELECT * FROM pages");
    let pages: Vec<Page> = select_query.fetch_all(&pool).await?;
    println!("\n=== select pages with query.map...: \n{:?}", pages);

    Ok(())
}