Golang golang-sqlite (snippet)

Go programming example 'golang-sqlite'

golang-sqlite

Golang beginners example: golang-sqlite

package main

import (
    "database/sql"
    "fmt"
    "log"
    "os"
    "strconv"
    "time"

    _ "github.com/mattn/go-sqlite3"
)

type Table struct {
    Id   int
    Text string
    Time int64
}

func main() {
    db, err := sql.Open("sqlite3", "./sqlite.sqlite")
    if err != nil {
        log.Fatalf("Error: %v", err)
        return
    }
    defer db.Close()

    if len(os.Args) < 2 {
        log.Fatal("Error: no mode set")
        return
    }

    mode := os.Args[1]
    var qu Table
    if mode == "select" {
        q, err := db.Query("SELECT * FROM \"main\".\"test\" ORDER BY time DESC LIMIT 1;")
        if err != nil {
            log.Printf("Error: while getting data: %s\n", err)
        } else {
            q.Next()
            err = q.Scan(&qu.Id, &qu.Text, &qu.Time)
            if err != nil {
                log.Printf("Error: while getting row data: %s\n", err)
            }
            fmt.Println("Last inserted data is: " + qu.Text)
            t := time.Unix(qu.Time, 0)
            fmt.Println("Inserted on " + t.Format(time.RFC1123Z))
        }
    } else if mode == "insert" {
        if len(os.Args) > 2 {
            data := os.Args[2]
            now := strconv.FormatInt(time.Now().Unix(), 10)
            db.Exec("INSERT INTO \"main\".\"test\" (\"text\", \"time\") VALUES('" + data + "', '" + now + "')")
            fmt.Println(data + " inserted")
        } else {
            log.Fatal("Error: no data provided")
        }
    } else if mode == "csv" {
        q, err := db.Query("SELECT * FROM \"main\".\"test\" ORDER BY time DESC;")
        if err != nil {
            log.Printf("Error: while getting data: %s\n", err)
        } else {
            fmt.Println("Id,Text,Time")
            for q.Next() {
                err = q.Scan(&qu.Id, &qu.Text, &qu.Time)
                if err != nil {
                    log.Fatal(err)
                }
                fmt.Printf("%v,%v,%v\n", qu.Id, qu.Text, qu.Time)
            }
        }
    }
}

Useful links

• Learn Go: https://golangr.com
• Download Go: https://golang.org