DB Relations

Many to Many

Let’s create connection between Account and Group. An account could be inside more than one group and a group can have more than one account. Enterprise will create a connection table with integer id and both table’s primary keys.

models.ManyToMany(GroupName, "account_id", "group_id", "id", AccountGroupName)

models.ManyToMany(AccountName, "group_id", "account_id", "id", AccountGroupName)

1. first variable is name of the other table we want to connect.

2. second variable is our first table’s foreign key column name.

3. third variable is our second table’s foreign key column name.

4. fourth variable is primary key of second table which is group.

5. And the last variable is connection table’s name which connect account and group.

account your/project/db_models/account.go

package db_models

import (
        "github.com/MrSametBurgazoglu/enterprise/models"
        "github.com/google/uuid"
)

func Account() *models.Table {
    idField := models.UUIDField("ID").DefaultFunc(uuid.New)

    tb := &models.Table{
        Fields: []models.FieldI{
            idField,
            models.StringField("Name"),
            models.StringField("Surname"),
            models.UUIDField("DenemeID").SetNillable(),
            models.UintField("Serial").AddSerial(),
        },
        Relations: []*models.Relation{
            models.ManyToMany(GroupName, "account_id", "group_id", "id", AccountGroupName),
        },
    }

    tb.SetTableName(AccountName)
    tb.SetIDField(idField)

    return tb
}

group your/project/db_models/group.go

package db_models

import (
    "github.com/MrSametBurgazoglu/enterprise/models"
    "github.com/google/uuid"
)

func Group() *models.Table {
    idField := models.UUIDField("ID").DefaultFunc(uuid.New)

    tb := &models.Table{
        Fields: []models.FieldI{
            idField,
            models.StringField("Name"),
            models.StringField("Surname"),
        },
        Relations: []*models.Relation{
           models.ManyToMany(AccountName, "group_id", "account_id", "id", AccountGroupName),
        },
    }

    tb.SetTableName(GroupName)
    tb.SetIDField(idField)

    return tb
}

You can use the following functions for many-to-many relations.

func (t *Account) AddIntoGroup(relationship *Group) error
func (t *Account) RemoveFromGroup(relationship *Group) error
func (t *Account) IsInGroup(relationship *Group) (bool, error
func (t *Group) AddIntoAccount(relationship *Account) error
func (t *Group) RemoveFromAccount(relationship *Account) error
func (t *Group) IsInAccount(relationship *Account) (bool, error

Many to One

Let’s create connection between Account and Test. An account can have one test. But a test can have more than one account.

models.ManyToOne(TestName, idField.DBName, "test_id")

models.OneToMany(AccountName, idField.DBName, "test_id")

1. first variable is name of the other table we want to connect.

2. second variable is other table’s primary key column name.

3. third variable is our current table’s foreign key column name.

account your/project/db_models/account.go

package db_models

import (
        "github.com/MrSametBurgazoglu/enterprise/models"
        "github.com/google/uuid"
)

func Account() *models.Table {
    idField := models.UUIDField("ID").DefaultFunc(uuid.New)

    tb := &models.Table{
        Fields: []models.FieldI{
            idField,
            models.StringField("Name"),
            models.StringField("Surname"),
            models.UUIDField("DenemeID").SetNillable(),
            models.UintField("Serial").AddSerial(),
        },
        Relations: []*models.Relation{
            models.ManyToOne(TestName, idField.DBName, "test_id"),
        },
    }

    tb.SetTableName(AccountName)
    tb.SetIDField(idField)

    return tb
}

test your/project/db_models/test.go

package db_models

import (
    "github.com/MrSametBurgazoglu/enterprise/models"
    "github.com/google/uuid"
)

func Test() *models.Table {
    idField := models.UUIDField("ID").DefaultFunc(uuid.New)
    denemeTypeEnumValues := []string{"Test", "Deneme"}
    testRelationField := models.UUIDField("TestID").SetNillable()

    tb := &models.Table{
        Fields: []models.FieldI{
            idField,
            testRelationField,
            models.IntField("Count"),
            models.BoolField("IsActive").Default(true),
            models.EnumField("DenemeType", denemeTypeEnumValues),
        },
        Relations: []*models.Relation{
            models.OneToMany(AccountName, idField.DBName, "test_id"),
        },
    }

    tb.SetTableName(DenemeName)
    tb.SetIDField(idField)
    return tb
}

You can use the following functions for many-to-many relations.

func (t *Account) WithTest(opts ...func(*Test))
func (t *Test) WithAccountList(opts ...func(*AccountList))