package main

import (
	"zombiezen.com/go/sqlite"
	"zombiezen.com/go/sqlite/sqlitex"
)

func createDB() (*sqlite.Conn, error) {
	// Open an in-memory database.
	conn, err := sqlite.OpenConn(":memory:", sqlite.OpenReadWrite)
	if err != nil {
		return nil, err
	}
	// Create tables
	sqlitex.ExecScript(conn, `
		CREATE TABLE stations (id text primary key, name text, lat real, lon real);
	`)
	// Return connection
	return conn, nil
}