badboy/counter.rs

## counter.rs
#!/usr/bin/env -S cargo +nightly -q -Zscript
```cargo
[dependencies]
cgi2 = "0.7"
rusqlite = { version = "0.30.0", features = ["bundled"] }
axohtml = { git = "https://github.com/badboy/axohtml", branch = "nightly-fixes" }
```

use axohtml::{dom::DOMTree, html, text, types::Metadata};
use rusqlite::Connection;

#[cgi::main]
fn main(_request: cgi::Request) -> cgi::Response {
    let conn = Connection::open("/tmp/cgi-counter.db").expect("cannot open db");

    conn.execute(
        "CREATE TABLE IF NOT EXISTS counter (
            visits INTEGER
        )",
        (),
    )
    .unwrap();
    conn.execute(
        "INSERT INTO counter(visits) SELECT 0 WHERE NOT EXISTS (SELECT * FROM counter)",
        (),
    )
    .unwrap();

    let counter = conn
        .query_row(
            "UPDATE counter SET visits = visits + 1 RETURNING visits",
            [],
            |row| row.get(0),
        )
        .unwrap_or(0);

    let doc: DOMTree<String> = html!(
        <html>
            <head>
                <title>"Hello from Rust"</title>
                <meta name=Metadata::Author content="cargo"/>
            </head>
            <body>
                <h1>"Hello from Rust"</h1>
                <p class="official">
                    "Rust can do CGI."
                </p>
                <p>
                { text!("This site has been loaded {} times.", counter) }
                </p>
            </body>
        </html>
    );

    let doc_str = doc.to_string();
    cgi::html_response(200, &doc_str)
}
	#!/usr/bin/env -S cargo +nightly -q -Zscript
	```cargo
	[dependencies]
	cgi2 = "0.7"
	rusqlite = { version = "0.30.0", features = ["bundled"] }
	axohtml = { git = "https://github.com/badboy/axohtml", branch = "nightly-fixes" }
	```

	use axohtml::{dom::DOMTree, html, text, types::Metadata};
	use rusqlite::Connection;

	#[cgi::main]
	fn main(_request: cgi::Request) -> cgi::Response {
	let conn = Connection::open("/tmp/cgi-counter.db").expect("cannot open db");

	conn.execute(
	"CREATE TABLE IF NOT EXISTS counter (
	visits INTEGER
	)",
	(),
	)
	.unwrap();
	conn.execute(
	"INSERT INTO counter(visits) SELECT 0 WHERE NOT EXISTS (SELECT * FROM counter)",
	(),
	)
	.unwrap();

	let counter = conn
	.query_row(
	"UPDATE counter SET visits = visits + 1 RETURNING visits",
	[],
	\|row\| row.get(0),
	)
	.unwrap_or(0);

	let doc: DOMTree<String> = html!(
	<html>
	<head>
	<title>"Hello from Rust"</title>
	<meta name=Metadata::Author content="cargo"/>
	</head>
	<body>
	<h1>"Hello from Rust"</h1>
	<p class="official">
	"Rust can do CGI."
	</p>
	<p>
	{ text!("This site has been loaded {} times.", counter) }
	</p>
	</body>
	</html>
	);

	let doc_str = doc.to_string();
	cgi::html_response(200, &doc_str)
	}