database

Database

Removes the need for building queries!

Usage

setup.sql

DROP DATABASE IF EXISTS test;

CREATE DATABASE test;
USE test;

CREATE TABLE people (
	name varchar(256) not null,
	age smallint not null,
	created_at TIMESTAMP not null,
	updated_at TIMESTAMP null,
	primary key (name)
);

main.go

package main

import (
	"database/sql"
	"fmt"
	"time"

	"github.com/dtucker2/database"
	_ "github.com/go-sql-driver/mysql"
)

type Person struct {
	Name      string     `name:"name" key:"true"`
	Age       int        `name:"age"`
	CreatedAt *time.Time `name:"created_at" type:"created_at"`
	UpdatedAt *time.Time `name:"updated_at" type:"updated_at"`
}

func (person *Person) GetTableName() string {
	return "people"
}

func main() {

	sqlDB, _ := sql.Open("mysql", "user:password@/test?parseTime=true")
	db := database.NewDatabase(sqlDB)

	person := Person{Name: "Frank", Age: 32}

	db.Insert(&person)
	/* Result:
	+-------+-----+---------------------+------------+
	| name  | age | created_at          | updated_at |
	+-------+-----+---------------------+------------+
	| Frank |  32 | 2019-01-28 23:20:00 | NULL       |
	+-------+-----+---------------------+------------+
	*/

	person.Age = 33
	db.Update(&person)
	/* Result:
	+-------+-----+---------------------+---------------------+
	| name  | age | created_at          | updated_at          |
	+-------+-----+---------------------+---------------------+
	| Frank |  33 | 2019-01-28 23:20:00 | 2019-01-28 23:20:00 |
	+-------+-----+---------------------+---------------------+
	*/

	person = Person{Name: "Frank"} // Note the lack of any age.
	db.Select(&person)
	fmt.Printf("%+v\n", person)
	/* Output:
	{Name:Frank Age:33 CreatedAt:2019-01-28 23:20:00 +0000 UTC UpdatedAt:2019-01-28 23:20:01 +0000 UTC}
	*/

	db.Delete(&person)
	/* Result:
	Empty set (0.00 sec)
	*/

}