From 7a6efffc98fdda8e3b07829900b5b8926e791437 Mon Sep 17 00:00:00 2001 From: Joop Kiefte Date: Mon, 7 Jun 2021 19:54:15 +0100 Subject: Initial commit --- main.go | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 57 insertions(+) create mode 100644 main.go (limited to 'main.go') diff --git a/main.go b/main.go new file mode 100644 index 0000000..95024ab --- /dev/null +++ b/main.go @@ -0,0 +1,57 @@ +package main + +import ( + "database/sql" + _ "modernc.org/sqlite" + + "text/template" +) + +var opml = ` + + + Bahá'í Prayers + + + +{{range .}} + + + +{{end}} + + +` + +type Prayer struct{ + Phelps string + ID string + Language string + Author string + Text string +} + +func main() { + var prayers []Prayer + db := sql.Open("sqlite", "holywritings.db") + rows := db.Query("select id, phelps, author, language, text from writings;") + for rows.Next() { + var prayer Prayer + rows.Scan(&prayer.ID, &prayer.Phelps, &prayer.Author, &prayer.Language, &prayer.Text) + switch prayer.Author { + case "Báb": + prayer.Author = "bab" + case "`Abdu'l-Bahá": + prayer.Author = "abdulbaha" + case "Bahá'u'lláh": + prayer.Author = "bahaullah" + } + prayer.Text = template.HTMLEscapeString(prayer.Text) + prayers = append(prayers, prayer) + } + + tmpl, err := template.New("opml").Parse(opml) + if err != nil { panic(err) } + err = tmpl.Execute(os.Stdout, prayers) + if err != nil { panic(err) } +} -- cgit v1.2.3-70-g09d2