Example #1
0
func ExampleLoadFromFile() {
	db, err := sql.Open("sqlite3", ":memory:")
	if err != nil {
		panic(err)
	}

	dot, err := dotsql.LoadFromFile("queries/users.sql")
	if err != nil {
		panic(err)
	}

	/* users.sql looks like:
	--name: create-user
	INSERT INTO users (email) VALUES(?)

	--name: find-user-by-email
	SELECT email FROM users WHERE email = ?
	*/

	if _, err := dot.Exec(db, "create-user", "*****@*****.**"); err != nil {
		panic(err)
	}

	rows, err := dot.Query(db, "find-user-by-email", "*****@*****.**")
	if err != nil {
		panic(err)
	}
	defer rows.Close()
}
func getDbQuery() *Database {
	db, err := sql.Open("postgres", *databaseConnectionString)
	if err != nil {
		panic(err)
	}

	// load up queries ( dotsql )
	dot, err := dotsql.LoadFromFile("./db/queries.sql")
	if err != nil {
		panic(err)
	}

	return &Database{
		dbq:  db,
		dbqr: db,
		dot:  dot,
	}
}
Example #3
0
func ExampleLoadFromFile() {
	db, err := sql.Open("sqlite3", ":memory:")
	if err != nil {
		panic(err)
	}

	dot, err := dotsql.LoadFromFile("queries.sql")
	if err != nil {
		panic(err)
	}

	/* queries.sql looks like:
	-- name: create-users-table
	CREATE TABLE users (
		id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
		name VARCHAR(255),
		email VARCHAR(255)
	);

	-- name: create-user
	INSERT INTO users (name, email) VALUES(?, ?)

	-- name: find-users-by-email
	SELECT id,name,email FROM users WHERE email = ?

	-- name: find-one-user-by-email
	SELECT id,name,email FROM users WHERE email = ? LIMIT 1

	--name: drop-users-table
	DROP TABLE users
	*/

	// Exec
	if _, err := dot.Exec(db, "create-users-table"); err != nil {
		panic(err)
	}

	if _, err := dot.Exec(db, "create-user", "*****@*****.**"); err != nil {
		panic(err)
	}

	// Query
	rows, err := dot.Query(db, "find-user-by-email", "*****@*****.**")
	if err != nil {
		panic(err)
	}
	defer rows.Close()

	for rows.Next() {
		var id int
		var name, email string

		err = rows.Scan(&id, &name, &email)

		if err != nil {
			panic(err)
		}

		log.Println(email)
	}

	// QueryRow
	row, err := dot.QueryRow(db, "find-one-user-by-email", "*****@*****.**")
	if err != nil {
		panic(err)
	}

	var id int
	var name, email string
	row.Scan(&id, &name, &email)

	log.Println(email)
}