MCPcopy Create free account
hub / github.com/PerpetualSoftware/pad / JSONFieldText

Method JSONFieldText

internal/store/dialect_fieldvalue.go:124–130  ·  view source on GitHub ↗

---------- PostgreSQL ----------

(column, key string)

Source from the content-addressed store, hash-verified

122// ---------- PostgreSQL ----------
123
124func (d *postgresDialect) JSONFieldText(column, key string) string {
125 return fmt.Sprintf("(CASE jsonb_typeof(%s->'%s')"+
126 " WHEN 'string' THEN %s->>'%s'"+
127 " WHEN 'boolean' THEN %s->>'%s'"+
128 " WHEN 'number' THEN trim_scale((%s->'%s')::numeric)::text"+
129 " END)", column, key, column, key, column, key, column, key)
130}
131
132func (d *postgresDialect) JSONFieldEquals(column, key, arg string) (string, []any) {
133 return joinFieldEquals(d.JSONFieldEqualsParts(column, key, arg))

Callers 1

JSONFieldOrderMethod · 0.95

Calls

no outgoing calls

Tested by

no test coverage detected