Скрипт, подключающийся к БД и скачивающий таблицу в CSV-файл

package main
 
import (
    "os"
    "log"
    "encoding/csv"
)
 
var data = [][]string{{"Line1", "Hello Readers of:"}, {"Line2", "golangcode.com"}}
 
func main() {
    file, err := os.Create("result.csv")
    checkError("Cannot create file", err)
    defer file.Close()
 
    writer := csv.NewWriter(file)
 
    for _, value := range data {
        err := writer.Write(value)
        checkError("Cannot write to file", err)
    }
 
    defer writer.Flush()
}
 
func checkError(message string, err error) {
    if err != nil {
        log.Fatal(message, err)
    }
}

package main
 
import (
"github.com/revel/revel"
"os"
"encoding/csv"
"database/sql"
"fmt"
"log"
"strconv"
_ "github.com/lib/pq"
)
 
type App struct {
*revel.Controller
}
 
func (c App) Index() revel.Result {
 
//DB CONN
db, err := sql.Open("postgres", "user=app password=***** dbname=***** host=***** port=*****")
if err != nil {
panic(err.Error())
}
//QUERY
rows, err := db.Query(`SELECT * FROM table`)
if err != nil {
log.Fatal(err)
}
defer rows.Close()
defer db.Close()
 
// CREATE A CSV FILE
f, err := os.Create("./data.csv") // Define filename
if err != nil {
fmt.Println(err)
}
defer f.Close()
 
//TABLE VARS
var (
id int
name string
email string
score int
city string
)
 
cont := 0 // COUNTER TO DEFINE HEADERS ROW
w := csv.NewWriter(f)
for rows.Next() {
err := rows.Scan(&id, &name, &email, &score, &city)
if err != nil {
log.Fatal(err)
}
 
// Write Table data data to CSV file
if cont == 0 { // Set table headers
var record []string
record = append(record, "#")
record = append(record, "Name")
record = append(record, "Email")
record = append(record, "Score")
record = append(record, "City")
w.Write(record)
cont++
 
}
 
var record []string
record = append(record, strconv.Itoa(cont))
record = append(record, name)
record = append(record, email)
record = append(record, strconv.Itoa(score))
record = append(record, city)
w.Write(record)
cont++;
}
w.Flush()
 
}

package main
 
import (
 
    "os"
    "encoding/csv"
    "database/sql"
    "fmt"
    "log"
    "strconv"
    
    _ "github.com/denisenkom/go-mssqldb"
    "github.com/revel/revel"
)
 
type App struct {
*revel.Controller
}
 
func (c App) Index() revel.Result {
 
//DB CONN
 
db, err := sql.Open("mssql", "server=127.0.0.1;user id=*****;password=*****;port=*****;database=*****")
 
 
if err != nil {
panic(err.Error())
}
//QUERY
rows, err := db.Query(`SELECT * FROM table`)
if err != nil {
log.Fatal(err)
}
defer rows.Close()
defer db.Close()
 
// CREATE A CSV FILE
f, err := os.Create("./data.csv") // Define filename
if err != nil {
fmt.Println(err)
}
defer f.Close()
 
//TABLE VARS
var (
id int
name string
email string
score int
city string
)
 
cont := 0 // COUNTER TO DEFINE HEADERS ROW
w := csv.NewWriter(f)
for rows.Next() {
err := rows.Scan(&id, &name, &email, &score, &city)
if err != nil {
log.Fatal(err)
}
 
// Write Table data data to CSV file
if cont == 0 { // Set table headers
var record []string
record = append(record, "#")
record = append(record, "Name")
record = append(record, "Email")
record = append(record, "Score")
record = append(record, "City")
w.Write(record)
cont++
 
}
 
var record []string
record = append(record, strconv.Itoa(cont))
record = append(record, name)
record = append(record, email)
record = append(record, strconv.Itoa(score))
record = append(record, city)
w.Write(record)
cont++;
}
w.Flush()
 
}