#include #include #include #include #include #include #define BASE "https://jtvjan.nl/microblog/" /* CREATE TABLE posts ( content text NOT NULL, media text, caption text, creation integer DEFAULT (strftime('%s', datetime('now'))), topic TEXT CHECK ((media IS NULL AND caption IS NULL) OR (media IS NOT NULL AND caption IS NOT NULL)) ); */ enum { HTML, RSS } mode; void htmlprint(const char str[]); void htmlescape(const char str[]); void htmlescape_cats(const char str[]); void attrprint(const char str[]); const char *determinemime(const char file[]); int main(int argc, char *argv[]) { time_t timenum; char timestr[32]; sqlite3 *db; sqlite3_stmt *get_posts; mode = argc >= 2 && strcmp(argv[1], "-f") == 0 ? RSS : HTML; if (sqlite3_open_v2("database.sqlite3", &db, SQLITE_OPEN_READONLY, NULL) != SQLITE_OK) { printf("Failed to connect: %s\n", sqlite3_errmsg(db)); return 2; } if (sqlite3_prepare_v2(db, "SELECT content, media, caption, creation, topic FROM posts ORDER BY creation DESC", -1, &get_posts, NULL) != SQLITE_OK) { printf("Failed to prepare statement: %s\n", sqlite3_errmsg(db)); return 2; } if (mode == RSS) fputs( "" "" "" "My Microblog" "Like a regular blog, but with no effort." ""BASE"gen.c" ""BASE"", stdout ); else if (mode == HTML) fputs( "" "" "" "" "" "" "My Microblog" "" "" "" "" " $\"RSS$ " "

Microblog

", stdout ); while (sqlite3_step(get_posts) == SQLITE_ROW) { timenum = sqlite3_column_int64(get_posts, 3); if (mode == RSS) { strftime(timestr, 32, "%a, %d %b %Y %H:%M:%S", gmtime(&timenum)); fputs("", stdout); htmlescape(sqlite3_column_text(get_posts, 0)); printf("%s GMT", timestr); if (sqlite3_column_type(get_posts, 1) != SQLITE_NULL) printf("", sqlite3_column_text(get_posts, 1), determinemime(sqlite3_column_text(get_posts, 1))); /* todo: length argument (size in bytes) */ if (sqlite3_column_type(get_posts, 4) != SQLITE_NULL) htmlescape_cats(sqlite3_column_text(get_posts, 4)); printf("%s#p%ld", BASE, timenum); } else if (mode == HTML) { strftime(timestr, 32, "%Y-%m-%dT%H:%M:%SZ", gmtime(&timenum)); printf("

", timenum); fputs(sqlite3_column_text(get_posts, 0), stdout); if (sqlite3_column_type(get_posts, 1) != SQLITE_NULL) { printf(" $\"",$ ", sqlite3_column_text(get_posts, 1)); } printf("%s", timenum, timestr); if (sqlite3_column_type(get_posts, 4) != SQLITE_NULL) printf("%s", sqlite3_column_text(get_posts, 4)); fputs("

", stdout); } } sqlite3_finalize(get_posts); sqlite3_close(db); if (mode == RSS) fputs( "" "", stdout ); else if (mode == HTML) fputs( "" "", stdout ); return 0; } void htmlprint(const char str[]) { for (; *str != '\0'; ++str) putchar(*str); } void htmlescape(const char str[]) { for (; *str != '\0'; ++str) if (*str == '<') fputs("<", stdout); else if (*str == '>') fputs(">", stdout); else if (*str == '&') fputs("&", stdout); else putchar(*str); } void htmlescape_cats(const char str[]) { fputs("", stdout); for (; *str != '\0'; ++str) if (*str == '<') fputs("<", stdout); else if (*str == '>') fputs(">", stdout); else if (*str == '&') fputs("&", stdout); else if (*str == ' ') fputs("", stdout); else putchar(*str); fputs("", stdout); } void attrprint(const char str[]) { for (; *str != '\0'; ++str) if (*str == '"') fputs(""", stdout); else putchar(*str); } const char *determinemime(const char file[]) { const char *extensions[] = { "png", "jpeg", "gif", "webp" }; if (strcmp(strrchr(file, '.'), ".png") == 0) return extensions[0]; else if (strcmp(strrchr(file, '.'), ".jpg") == 0) return extensions[1]; else if (strcmp(strrchr(file, '.'), ".jpeg") == 0) return extensions[1]; else if (strcmp(strrchr(file, '.'), ".gif") == 0) return extensions[2]; else if (strcmp(strrchr(file, '.'), ".webp") == 0) return extensions[3]; else return NULL; }