summaryrefslogtreecommitdiff
path: root/cmd/dbgen/main.go
blob: 0bcc3e93c660be9d66639511da8d8e7de61f0ce9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
// Copyright (C) 2019-2023 Algorand, Inc.
// This file is part of go-algorand
//
// go-algorand is free software: you can redistribute it and/or modify
// it under the terms of the GNU Affero General Public License as
// published by the Free Software Foundation, either version 3 of the
// License, or (at your option) any later version.
//
// go-algorand is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
// GNU Affero General Public License for more details.
//
// You should have received a copy of the GNU Affero General Public License
// along with go-algorand.  If not, see <https://www.gnu.org/licenses/>.

// dbgen -i <inputfile> -o <outputfile> -p <pkgname> -n <funcname> generates an installation function
// for a sqlite3 database schema installation.
package main

import (
	"flag"
	"fmt"
	"os"
	"strings"
	"time"
)

var inputfilename = flag.String("i", "", "Name of the file specifying the database schema.")
var outputfilename = flag.String("o", "", "Name of the file to write out the resulting output. Default is stdout.")
var fnname = flag.String("n", "", "Name of the desired installation function; signature is \"func <name>InstallDatabase(*sql.Tx) error\"")
var pkgname = flag.String("p", "", "Name of the package to place installation function in")
var headerfilename = flag.String("h", "", "Name of the header file to use")

var template = `%s// generated by dbgen; DO NOT EDIT

package %s

import "database/sql"

func ` + "%s" + `InstallDatabase(tx *sql.Tx) error {
	statement := ` + "`%s`" + `
	_, err := tx.Exec(statement)
	if err != nil {
		return err
	}

	return nil
}
`

func main() {
	flag.Parse()

	if *pkgname == "" {
		panic("error: No package name specified")
	}

	if *inputfilename == "" {
		panic("error: No database schema file specified")
	}
	input, err := os.ReadFile(*inputfilename)
	if err != nil {
		panic(err)
	}
	header := ""
	if *headerfilename != "" {
		headerBytes, err := os.ReadFile(*headerfilename)
		if err != nil {
			panic(err)
		}
		header = string(headerBytes) + "\n"
		header = strings.Replace(header, "{DATE_Y}", fmt.Sprintf("%d", time.Now().Year()), 1)
	}

	payload := fmt.Sprintf(template, header, *pkgname, *fnname, string(input))

	if *outputfilename == "" {
		fmt.Println(payload)
	} else {
		err := os.WriteFile(*outputfilename, []byte(payload), 0666)
		if err != nil {
			panic(err)
		}
	}
}