예제 #1
0
/**
 * Warning: Generated code! do not change!
 * Generated by: go/EntityDB.ftl
 */
package tables

import (
	"github.com/quintans/goSQL/db"
	"github.com/quintans/taskboard/go/entity"
	. "github.com/quintans/toolkit/ext"
)

var (
	LANE           = db.TABLE("LANE")
	LANE_C_ID      = LANE.KEY("ID")
	LANE_C_VERSION = LANE.VERSION("VERSION")
	// Audit
	LANE_C_CREATION          = LANE.COLUMN("CREATION")
	LANE_C_MODIFICATION      = LANE.COLUMN("MODIFICATION")
	LANE_C_USER_CREATION     = LANE.COLUMN("USER_CREATION").As("UserCreationId")
	LANE_C_USER_MODIFICATION = LANE.COLUMN("USER_MODIFICATION").As("UserModificationId")
	// Atributos
	LANE_C_NAME     = LANE.COLUMN("NAME")
	LANE_C_POSITION = LANE.COLUMN("POSITION")
	LANE_C_BOARD_ID = LANE.COLUMN("BOARD").As("BoardId")
	//FK's
	LANE_A_BOARD = LANE.
			ASSOCIATE(LANE_C_BOARD_ID).TO(BOARD_C_ID).
			As("Board")
	LANE_A_TASKS = LANE.
			ASSOCIATE(LANE_C_ID).TO(TASK_C_LANE_ID).
예제 #2
0
/**
 * Warning: Generated code! do not change!
 * Generated by: go/EntityDB.ftl
 */
package tables

import (
	"github.com/quintans/goSQL/db"
	"github.com/quintans/taskboard/go/entity"
	. "github.com/quintans/toolkit/ext"
)

var (
	ROLE           = db.TABLE("ROLE")
	ROLE_C_ID      = ROLE.KEY("ID")
	ROLE_C_VERSION = ROLE.VERSION("VERSION")
	// Audit
	ROLE_C_CREATION          = ROLE.COLUMN("CREATION")
	ROLE_C_MODIFICATION      = ROLE.COLUMN("MODIFICATION")
	ROLE_C_USER_CREATION     = ROLE.COLUMN("USER_CREATION").As("UserCreationId")
	ROLE_C_USER_MODIFICATION = ROLE.COLUMN("USER_MODIFICATION").As("UserModificationId")
	// Atributos
	ROLE_C_KIND    = ROLE.COLUMN("KIND")
	ROLE_C_USER_ID = ROLE.COLUMN("USER").As("UserId")
	//FK's
	ROLE_A_USER = ROLE.
			ASSOCIATE(ROLE_C_USER_ID).TO(USER_C_ID).
			As("User")
	ROLE_A_USER_CREATION     = ROLE.ASSOCIATE(ROLE_C_USER_CREATION).TO(USER_C_ID).As("UserCreation")
	ROLE_A_USER_MODIFICATION = ROLE.ASSOCIATE(ROLE_C_USER_MODIFICATION).TO(USER_C_ID).As("UserModification")
)
예제 #3
0
/**
 * Warning: Generated code! do not change!
 * Generated by: go/EntityDB.ftl
 */
package tables

import (
	"github.com/quintans/goSQL/db"
	"github.com/quintans/taskboard/go/entity"
	. "github.com/quintans/toolkit/ext"
)

var (
	TASK           = db.TABLE("TASK")
	TASK_C_ID      = TASK.KEY("ID")
	TASK_C_VERSION = TASK.VERSION("VERSION")
	// Audit
	TASK_C_CREATION          = TASK.COLUMN("CREATION")
	TASK_C_MODIFICATION      = TASK.COLUMN("MODIFICATION")
	TASK_C_USER_CREATION     = TASK.COLUMN("USER_CREATION").As("UserCreationId")
	TASK_C_USER_MODIFICATION = TASK.COLUMN("USER_MODIFICATION").As("UserModificationId")
	// Atributos
	TASK_C_TITLE      = TASK.COLUMN("TITLE")
	TASK_C_DETAIL     = TASK.COLUMN("DETAIL")
	TASK_C_HEAD_COLOR = TASK.COLUMN("HEAD_COLOR")
	TASK_C_BODY_COLOR = TASK.COLUMN("BODY_COLOR")
	TASK_C_POSITION   = TASK.COLUMN("POSITION")
	TASK_C_REFERENCE  = TASK.COLUMN("REFERENCE")
	TASK_C_SPENT      = TASK.COLUMN("SPENT")
	TASK_C_REMAINING  = TASK.COLUMN("REMAINING")
	// who is with this task
예제 #4
0
/**
 * Warning: Generated code! do not change!
 * Generated by: go/EntityDB.ftl
 */
package tables

import (
	"github.com/quintans/goSQL/db"
	"github.com/quintans/taskboard/go/entity"
	. "github.com/quintans/toolkit/ext"
)

var (
	USER           = db.TABLE("USER")
	USER_C_ID      = USER.KEY("ID")
	USER_C_VERSION = USER.VERSION("VERSION")
	// Audit
	USER_C_CREATION          = USER.COLUMN("CREATION")
	USER_C_MODIFICATION      = USER.COLUMN("MODIFICATION")
	USER_C_USER_CREATION     = USER.COLUMN("USER_CREATION").As("UserCreationId")
	USER_C_USER_MODIFICATION = USER.COLUMN("USER_MODIFICATION").As("UserModificationId")
	// Atributos
	USER_C_NAME     = USER.COLUMN("NAME")
	USER_C_USERNAME = USER.COLUMN("USERNAME")
	USER_C_PASSWORD = USER.COLUMN("PASSWORD")
	//FK's
	// many to many
	USER_A_BOARDS = db.NewM2MAssociation(
		"boards",
		db.ASSOCIATE(USER_C_ID).WITH(BOARD_USER_C_USERS_ID),
		db.ASSOCIATE(BOARD_USER_C_BOARDS_ID).WITH(BOARD_C_ID),
예제 #5
0
/**
 * Warning: Generated code! do not change!
 * Generated by: go/EntityDB.ftl
 */
package tables

import (
	"github.com/quintans/goSQL/db"
	"github.com/quintans/taskboard/go/entity"
	. "github.com/quintans/toolkit/ext"
)

var (
	BOARD           = db.TABLE("BOARD")
	BOARD_C_ID      = BOARD.KEY("ID")
	BOARD_C_VERSION = BOARD.VERSION("VERSION")
	// Audit
	BOARD_C_CREATION          = BOARD.COLUMN("CREATION")
	BOARD_C_MODIFICATION      = BOARD.COLUMN("MODIFICATION")
	BOARD_C_USER_CREATION     = BOARD.COLUMN("USER_CREATION").As("UserCreationId")
	BOARD_C_USER_MODIFICATION = BOARD.COLUMN("USER_MODIFICATION").As("UserModificationId")
	// Atributos
	BOARD_C_NAME        = BOARD.COLUMN("NAME")
	BOARD_C_DESCRIPTION = BOARD.COLUMN("DESCRIPTION")
	//FK's
	BOARD_A_LANES = BOARD.
			ASSOCIATE(BOARD_C_ID).TO(LANE_C_BOARD_ID).
			As("Lanes")

	// intermediary table
	BOARD_USER             = db.TABLE("USERS").As("Users")
예제 #6
0
/**
 * Warning: Generated code! do not change!
 * Generated by: go/EntityDB.ftl
 */
package tables

import (
	"github.com/quintans/goSQL/db"
	"github.com/quintans/taskboard/go/entity"
	. "github.com/quintans/toolkit/ext"
)

var (
	NOTIFICATION           = db.TABLE("NOTIFICATION")
	NOTIFICATION_C_ID      = NOTIFICATION.KEY("ID")
	NOTIFICATION_C_VERSION = NOTIFICATION.VERSION("VERSION")
	// Audit
	NOTIFICATION_C_CREATION          = NOTIFICATION.COLUMN("CREATION")
	NOTIFICATION_C_MODIFICATION      = NOTIFICATION.COLUMN("MODIFICATION")
	NOTIFICATION_C_USER_CREATION     = NOTIFICATION.COLUMN("USER_CREATION").As("UserCreationId")
	NOTIFICATION_C_USER_MODIFICATION = NOTIFICATION.COLUMN("USER_MODIFICATION").As("UserModificationId")
	// Atributos
	NOTIFICATION_C_EMAIL   = NOTIFICATION.COLUMN("EMAIL")
	NOTIFICATION_C_TASK_ID = NOTIFICATION.COLUMN("TASK").As("TaskId")
	NOTIFICATION_C_LANE_ID = NOTIFICATION.COLUMN("LANE").As("LaneId")
	//FK's
	NOTIFICATION_A_TASK = NOTIFICATION.
				ASSOCIATE(NOTIFICATION_C_TASK_ID).TO(TASK_C_ID).
				As("Task")
	NOTIFICATION_A_LANE = NOTIFICATION.
				ASSOCIATE(NOTIFICATION_C_LANE_ID).TO(LANE_C_ID).