dbrmodels

Create projects for MySql database and generate table models structs for github.com/gocraft/dbr

Getting started

Lets create MySql table

CREATE TABLE Persons
(
    PersonID    int(11) unsigned NOT NULL AUTO_INCREMENT,
    LastName    varchar(255),
    FirstName   varchar(255),
    Address     varchar(255) DEFAULT NULL,
    City        varchar(255) DEFAULT NULL,
    BirthDay 	date NOT NULL,
    PRIMARY KEY (`PersonID`)
);

and generate gocraft/dbr model

package awesomeProject

import "github.com/gocraft/dbr"

var fieldsNamesPersons = []string{"PersonID", "LastName", "FirstName", "Address", "City"}
var autoIncrementFieldPersons string = "PersonID"

type DBPersons struct {
	PersonID  int64          `db:"PersonID"`
	LastName  string         `db:"LastName"`
	FirstName string         `db:"FirstName"`
	Address   dbr.NullString `db:"Address"`
	City      dbr.NullString `db:"City"`
	BirthDay  dbr.NullTime   `db:"BirthDay"`
}

func NewDBPersons() *Persons {
	return new(DBPersons)
}

func NewSliceDBPersons() []*Persons {
	return make([]*DBPersons, 0)
}

// return fields names
func FieldsNamesPersons() []string {
	return fieldsNamesPersons
}

// return fields names without auto_increment field for insert
func FieldsNamesWithOutAIPersons() []string {
	var slice []string
	for _, iterator := range fieldsNamesPersons {
		if iterator == autoIncrementFieldPersons {
			continue
		}
		slice = append(slice, iterator)
	}
	return slice
}

MySql types

MySql	GO	NULL
tinyint(1)	bool	dbr.NullBool
int	int64	dbr.NullInt64
float	float64	dbr.NullFloat64
date, datetime, timestamp	dbr.NullTime	dbr.NullTime
*	string	dbr.NullString

Install

go get github.com/finalist736/dbrmodels

gocraft/dbr example

// Get a record
var persons awesomeProject.DBPersons
err := dbrSess.Select("*").From("Persons").Where("PersonID = ?", 1).Load(&persons)

// insert record
result, err := dbrSess.InsertInto("Persons").Columns(awesomeProject.FieldsNamesWithOutAIPersons()...).Record(&persons).Exec()
newAIID := result.LastInsertID()

// update record
_, err = dbrSess.Update("Persons").Set("Address", "far far away").Where("`PersonID`=?", newAIID).Exec()

Projects

dbrmodels works with projects(databases) including next data:

Project name
DB Host
DB Port
DB User
DB Password
DB Name
Path where to .go files located

Example

{
        "Name": "test",
        "DBHost": "localhost",
        "DBPort": "3306",
        "DBUser": "root",
        "DBPass": "",
        "DBName": "test",
        "Path": "/home/finalist/go/src/github.com/finalist736/persons_dates_project/dbrmodels"
}

Directory structure

SHOW TABLES;
- Persons
- TestDatesTable

converts into files:

- /home/finalist/go/src/github.com/finalist736/persons_dates_project/
---- db_persons.go
---- db_TestDatesTable.go

Using

start generate project

dbrmodels project_name

list projects

dbrmodels ls

create project

dbrmodels create

edit project

dbrmodels edit project_name

remove project

dbrmodels remove project_name

view projects data

dbrmodels view project_name