sqljointype

package

v0.0.3 Latest Latest Go to latest Published: Jan 24, 2022 License: MIT Imports: 5 Imported by: 0

Details

Valid go.mod file
Redistributable license
Tagged version
Stable version
Learn more about best practices

Repository

gitlab.com/evatix-go/enum

Links

Open Source Insights

Documentation ¶

Index ¶

Constants
Variables
func Compile(clause JoinerClause) string
func RangesInvalidErr() error
type JoinerClause
type TableWithColumn
- func (it TableWithColumn) Clone() TableWithColumn
- func (it TableWithColumn) TableWithField() string
type Variant

Constants ¶

View Source

const (
	// JoinTwoTableSyntaxFormat
	//
	// References:
	//  - JOINSyntax        : refers to the enum sql-syntax
	//  - Join Sample       : https://www.w3schools.com/sql/sql_join.asp
	//  - Inner Join Sample : https://www.w3schools.com/sql/sql_join_inner.asp
	//  - Joins Diagrams    : https://prnt.sc/26guaad
	//  - Code Samples      : https://prnt.sc/26gub4k
	JoinTwoTableSyntaxFormat = "%s %s ON %s = %s" // JOINSyntax, LeftTable, LeftTableWithField, RightTableWithField

)

Variables ¶

View Source

var (
	Ranges = [...]string{
		Default:   "Default",
		Invalid:   "Invalid",
		Join:      "Join",
		Inner:     "Inner",
		Left:      "Left",
		Right:     "Right",
		FullOuter: "FullOuter",
		Cross:     "Cross",
	}

	InnerJoinMap = map[Variant]bool{
		Default: true,
		Join:    true,
		Inner:   true,
	}

	OuterJoinMap = map[Variant]bool{
		Left:      true,
		Right:     true,
		FullOuter: true,
	}

	SqlSyntax = [...]string{
		Default:   "JOIN",
		Invalid:   "",
		Join:      "JOIN",
		Inner:     "INNER JOIN",
		Left:      "LEFT JOIN",
		Right:     "RIGHT JOIN",
		FullOuter: "FULL OUTER JOIN",
		Cross:     "CROSS JOIN",
	}

	RangesMap = map[string]Variant{
		"Default":   Default,
		"Invalid":   Invalid,
		"":          Invalid,
		"Join":      Join,
		"Inner":     Inner,
		"Left":      Left,
		"Right":     Right,
		"FullOuter": FullOuter,
		"Cross":     Cross,
	}

	BasicEnumImpl = enumimpl.NewBasicByteUsingIndexedSlice(
		coredynamic.TypeName(Left),
		Ranges[:])
)

Functions ¶

func Compile ¶ added in v0.0.2

func Compile(clause JoinerClause) string

func RangesInvalidErr ¶

func RangesInvalidErr() error

Types ¶

type JoinerClause ¶ added in v0.0.2

type JoinerClause struct {
	JoinType Variant
	Left     TableWithColumn
	Right    TableWithColumn
}

JoinerClause

Compile using JoinTwoTableSyntaxFormat

References:

Join Sample : https://www.w3schools.com/sql/sql_join.asp
Inner Join Sample : https://www.w3schools.com/sql/sql_join_inner.asp
Joins Diagrams : https://prnt.sc/26guaad
Code Samples : https://prnt.sc/26gub4k

func (JoinerClause) Clone ¶ added in v0.0.2

func (it JoinerClause) Clone() JoinerClause

func (JoinerClause) Compile ¶ added in v0.0.2

func (it JoinerClause) Compile() string

Compile

generate to string using JoinTwoTableSyntaxFormat

References:

Join Sample : https://www.w3schools.com/sql/sql_join.asp
Inner Join Sample : https://www.w3schools.com/sql/sql_join_inner.asp
Joins Diagrams : https://prnt.sc/26guaad
Code Samples : https://prnt.sc/26gub4k

func (JoinerClause) SetLeftClone ¶ added in v0.0.2

func (it JoinerClause) SetLeftClone(
	left TableWithColumn,
) JoinerClause

func (JoinerClause) SetRightClone ¶ added in v0.0.2

func (it JoinerClause) SetRightClone(
	right TableWithColumn,
) JoinerClause

func (JoinerClause) String ¶ added in v0.0.2

func (it JoinerClause) String() string

String

generate to string using JoinTwoTableSyntaxFormat

References:

Join Sample : https://www.w3schools.com/sql/sql_join.asp
Inner Join Sample : https://www.w3schools.com/sql/sql_join_inner.asp
Joins Diagrams : https://prnt.sc/26guaad
Code Samples : https://prnt.sc/26gub4k

type TableWithColumn ¶ added in v0.0.2

type TableWithColumn struct {
	TableName, ColumnName string
}

func (TableWithColumn) Clone ¶ added in v0.0.2

func (it TableWithColumn) Clone() TableWithColumn

func (TableWithColumn) TableWithField ¶ added in v0.0.2

func (it TableWithColumn) TableWithField() string

TableWithField

Table.FieldName

type Variant ¶

type Variant byte

const (
	Default Variant = iota
	Invalid
	Join
	Inner
	Left
	Right
	FullOuter // Reference : https://www.w3schools.com/sql/sql_join_full.asp
	Cross
)

func (*Variant) AsBasicByteEnumContractsBinder ¶

func (it *Variant) AsBasicByteEnumContractsBinder() coreinterface.BasicByteEnumContractsBinder

func (*Variant) AsBasicEnumContractsBinder ¶

func (it *Variant) AsBasicEnumContractsBinder() coreinterface.BasicEnumContractsBinder

func (*Variant) AsJsonContractsBinder ¶

func (it *Variant) AsJsonContractsBinder() corejson.JsonContractsBinder

func (*Variant) AsJsonMarshaller ¶

func (it *Variant) AsJsonMarshaller() corejson.JsonMarshaller

func (*Variant) AsJsoner ¶

func (it *Variant) AsJsoner() corejson.Jsoner

func (Variant) Compile ¶ added in v0.0.2

func (it Variant) Compile(left, right TableWithColumn) string

Compile

References:

Join Sample : https://www.w3schools.com/sql/sql_join.asp
Inner Join Sample : https://www.w3schools.com/sql/sql_join_inner.asp
Joins Diagrams : https://prnt.sc/26guaad
Code Samples : https://prnt.sc/26gub4k

func (Variant) IsAnyOf ¶

func (it Variant) IsAnyOf(anyOfItems ...Variant) bool

func (Variant) IsCross ¶

func (it Variant) IsCross() bool

func (Variant) IsFullOuter ¶

func (it Variant) IsFullOuter() bool

func (Variant) IsInnerJoinLogically ¶

func (it Variant) IsInnerJoinLogically() bool

func (Variant) IsInvalid ¶

func (it Variant) IsInvalid() bool

func (Variant) IsJoin ¶

func (it Variant) IsJoin() bool

func (Variant) IsLeft ¶

func (it Variant) IsLeft() bool

func (Variant) IsLeftOuter ¶

func (it Variant) IsLeftOuter() bool

func (Variant) IsOuterJoinLogically ¶

func (it Variant) IsOuterJoinLogically() bool

func (Variant) IsRight ¶

func (it Variant) IsRight() bool

func (Variant) IsRightOuter ¶

func (it Variant) IsRightOuter() bool

func (Variant) IsValidLogically ¶

func (it Variant) IsValidLogically() bool

func (Variant) JoinClause ¶ added in v0.0.2

func (it Variant) JoinClause(left, right TableWithColumn) JoinerClause

func (Variant) Json ¶

func (it Variant) Json() corejson.Result

func (*Variant) JsonParseSelfInject ¶

func (it *Variant) JsonParseSelfInject(jsonResult *corejson.Result) error

func (Variant) JsonPtr ¶

func (it Variant) JsonPtr() *corejson.Result

func (Variant) MarshalJSON ¶

func (it Variant) MarshalJSON() ([]byte, error)

func (Variant) MaxByte ¶

func (it Variant) MaxByte() byte

func (Variant) MinByte ¶

func (it Variant) MinByte() byte

func (Variant) Name ¶

func (it Variant) Name() string

func (Variant) NameValue ¶

func (it Variant) NameValue() string

func (Variant) RangeNamesCsv ¶

func (it Variant) RangeNamesCsv() string

func (Variant) RangesByte ¶

func (it Variant) RangesByte() []byte

func (Variant) String ¶

func (it Variant) String() string

func (Variant) ToNumberString ¶

func (it Variant) ToNumberString() string

func (Variant) ToPtr ¶

func (it Variant) ToPtr() *Variant

func (*Variant) ToSimple ¶

func (it *Variant) ToSimple() Variant

func (Variant) ToSqlName ¶

func (it Variant) ToSqlName() string

func (Variant) TypeName ¶

func (it Variant) TypeName() string

func (*Variant) UnmarshalJSON ¶

func (it *Variant) UnmarshalJSON(data []byte) error

func (Variant) UnmarshallEnumToValue ¶

func (it Variant) UnmarshallEnumToValue(
	jsonUnmarshallingValue []byte,
) (byte, error)

func (Variant) Value ¶

func (it Variant) Value() byte

func (Variant) ValueByte ¶

func (it Variant) ValueByte() byte

func (Variant) ValueInt ¶

func (it Variant) ValueInt() int

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL