columns

func Fragment ¶

func Fragment(ctx specifications.Context, spec *specifications.Specification, column *specifications.Column) (fragment string, err error)

func Link ¶

func Link(ctx specifications.Context, spec *specifications.Specification, column *specifications.Column) (fragment string, err error)

func Links ¶

func Links(ctx specifications.Context, spec *specifications.Specification, column *specifications.Column) (fragment string, err error)

Links (SELECT to_json(

ARRAY(
	SELECT row_to_json("{host}_{away}".*) FROM (
		SELECT ... FROM "schema"."away_table" WHERE "pk" = "{host}"."ref_column" ORDER BY ... OFFSET x LIMIT y
		) AS "{host}_{away}"
	)
)

) AS "{name}"

func Reference ¶

func Reference(ctx specifications.Context, spec *specifications.Specification, column *specifications.Column) (fragment string, err error)

Reference (

 SELECT row_to_json("{host}_{away}".*) FROM (
		SELECT ... FROM "schema"."away" WHERE "pk" = "host"."ref_column" OFFSET 0 LIMIT 1
 ) AS "{host}_{away}"

) AS {name}

func Virtual ¶

func Virtual(ctx specifications.Context, spec *specifications.Specification, column *specifications.Column) (fragment string, err error)

Virtual (

 {SELECT to_json(ARRAY(}
	{SELECT row_to_json("{name}_virtual".*) FROM (}
	{query}
	{) AS "{name}_virtual"}
 {))}

) AS {name}