package main

import (
	"database/sql"
	"fmt"
	"net/http"
	"sync"

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

var mutex sync.Mutex

func rootHandler(w http.ResponseWriter, r *http.Request) {
	mutex.Lock()
	defer mutex.Unlock()

	db, err := sql.Open("adodb", "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=./db.accdb;")

	if err != nil {
		fmt.Println(err)
		return
	}
	defer db.Close()

	rows, err := db.Query("select id, descr from tbl")
	if err != nil {
		fmt.Println(err)
		return
	}
	defer rows.Close()

	for rows.Next() {
		var id string
		var descr string
		rows.Scan(&id, &descr)
		fmt.Println(id, descr)
	}

}

func main() {

	http.HandleFunc("/", rootHandler)

	fmt.Println("About to listen on 8081")
	err := http.ListenAndServe(":8081", nil)
	if err != nil {
		fmt.Println("ListenAndServe: ", err)
		return
	}

}