sqlpage 0.43.0

Build data user interfaces entirely in SQL. A web server that takes .sql files and formats the query result using pre-made configurable professional-looking components.
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
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56

use crate::utils::static_filename;
use actix_web::{
    http::header::{
        CacheControl, CacheDirective, ContentEncoding, ETag, EntityTag, Header, IfNoneMatch,
    },
    web, HttpRequest, HttpResponse, Resource,
};

macro_rules! static_file_endpoint {
    ($filestem:literal, $extension:literal, $mime:literal) => {{
        const FILENAME_WITH_TAG: &str = static_filename!(concat!($filestem, ".", $extension));
        web::resource(FILENAME_WITH_TAG).to(|req: HttpRequest| async move {
            let file_etag = EntityTag::new_strong(FILENAME_WITH_TAG.to_string());
            if matches!(IfNoneMatch::parse(&req), Ok(IfNoneMatch::Items(etags)) if etags.iter().any(|etag| etag.weak_eq(&file_etag))) {
                return HttpResponse::NotModified().finish();
            }
            HttpResponse::Ok()
                .content_type(concat!($mime, ";charset=UTF-8"))
                .insert_header(CacheControl(vec![
                    CacheDirective::Public,
                    CacheDirective::MaxAge(3600 * 24 * 7),
                    CacheDirective::Extension("immutable".to_owned(), None),
                ]))
                .insert_header(ETag(file_etag))
                .insert_header(ContentEncoding::Gzip)
                .body(
                    &include_bytes!(concat!(env!("OUT_DIR"), "/", $filestem, ".", $extension))[..],
                )
        })
    }};
}

#[must_use]
pub fn js() -> Resource {
    static_file_endpoint!("sqlpage", "js", "application/javascript")
}

#[must_use]
pub fn apexcharts_js() -> Resource {
    static_file_endpoint!("apexcharts", "js", "application/javascript")
}

#[must_use]
pub fn tomselect_js() -> Resource {
    static_file_endpoint!("tomselect", "js", "application/javascript")
}

#[must_use]
pub fn css() -> Resource {
    static_file_endpoint!("sqlpage", "css", "text/css")
}

#[must_use]
pub fn favicon() -> Resource {
    static_file_endpoint!("favicon", "svg", "image/svg+xml")
}