filter

var MemoFilterCELAttributes = []cel.EnvOption{
	cel.Variable("content", cel.StringType),
	cel.Variable("creator_id", cel.IntType),
	cel.Variable("created_ts", cel.IntType),
	cel.Variable("updated_ts", cel.IntType),
	cel.Variable("pinned", cel.BoolType),
	cel.Variable("tag", cel.StringType),
	cel.Variable("tags", cel.ListType(cel.StringType)),
	cel.Variable("visibility", cel.StringType),
	cel.Variable("has_task_list", cel.BoolType),

	cel.Function("now",
		cel.Overload("now",
			[]*cel.Type{},
			cel.IntType,
			cel.FunctionBinding(func(_ ...ref.Val) ref.Val {
				return types.Int(time.Now().Unix())
			}),
		),
	),
}

var SQLTemplates = map[string]SQLTemplate{
	"json_extract": {
		SQLite:     "JSON_EXTRACT(`memo`.`payload`, '%s')",
		MySQL:      "JSON_EXTRACT(`memo`.`payload`, '%s')",
		PostgreSQL: "memo.payload%s",
	},
	"json_array_length": {
		SQLite:     "JSON_ARRAY_LENGTH(COALESCE(JSON_EXTRACT(`memo`.`payload`, '$.tags'), JSON_ARRAY()))",
		MySQL:      "JSON_LENGTH(COALESCE(JSON_EXTRACT(`memo`.`payload`, '$.tags'), JSON_ARRAY()))",
		PostgreSQL: "jsonb_array_length(COALESCE(memo.payload->'tags', '[]'::jsonb))",
	},
	"json_contains_element": {
		SQLite:     "JSON_EXTRACT(`memo`.`payload`, '$.tags') LIKE ?",
		MySQL:      "JSON_CONTAINS(JSON_EXTRACT(`memo`.`payload`, '$.tags'), ?)",
		PostgreSQL: "memo.payload->'tags' @> jsonb_build_array(?)",
	},
	"json_contains_tag": {
		SQLite:     "JSON_EXTRACT(`memo`.`payload`, '$.tags') LIKE ?",
		MySQL:      "JSON_CONTAINS(JSON_EXTRACT(`memo`.`payload`, '$.tags'), ?)",
		PostgreSQL: "memo.payload->'tags' @> jsonb_build_array(?)",
	},
	"boolean_true": {
		SQLite:     "JSON_EXTRACT(`memo`.`payload`, '$.property.hasTaskList') = 1",
		MySQL:      "JSON_EXTRACT(`memo`.`payload`, '$.property.hasTaskList') = CAST('true' AS JSON)",
		PostgreSQL: "(memo.payload->'property'->>'hasTaskList')::boolean = true",
	},
	"boolean_false": {
		SQLite:     "JSON_EXTRACT(`memo`.`payload`, '$.property.hasTaskList') = 0",
		MySQL:      "JSON_EXTRACT(`memo`.`payload`, '$.property.hasTaskList') = CAST('false' AS JSON)",
		PostgreSQL: "(memo.payload->'property'->>'hasTaskList')::boolean = false",
	},
	"boolean_not_true": {
		SQLite:     "JSON_EXTRACT(`memo`.`payload`, '$.property.hasTaskList') != 1",
		MySQL:      "JSON_EXTRACT(`memo`.`payload`, '$.property.hasTaskList') != CAST('true' AS JSON)",
		PostgreSQL: "(memo.payload->'property'->>'hasTaskList')::boolean != true",
	},
	"boolean_not_false": {
		SQLite:     "JSON_EXTRACT(`memo`.`payload`, '$.property.hasTaskList') != 0",
		MySQL:      "JSON_EXTRACT(`memo`.`payload`, '$.property.hasTaskList') != CAST('false' AS JSON)",
		PostgreSQL: "(memo.payload->'property'->>'hasTaskList')::boolean != false",
	},
	"boolean_compare": {
		SQLite:     "JSON_EXTRACT(`memo`.`payload`, '$.property.hasTaskList') %s ?",
		MySQL:      "JSON_EXTRACT(`memo`.`payload`, '$.property.hasTaskList') %s CAST(? AS JSON)",
		PostgreSQL: "(memo.payload->'property'->>'hasTaskList')::boolean %s ?",
	},
	"boolean_check": {
		SQLite:     "JSON_EXTRACT(`memo`.`payload`, '$.property.hasTaskList') IS TRUE",
		MySQL:      "JSON_EXTRACT(`memo`.`payload`, '$.property.hasTaskList') = CAST('true' AS JSON)",
		PostgreSQL: "(memo.payload->'property'->>'hasTaskList')::boolean IS TRUE",
	},
	"table_prefix": {
		SQLite:     "`memo`",
		MySQL:      "`memo`",
		PostgreSQL: "memo",
	},
	"timestamp_field": {
		SQLite:     "`memo`.`%s`",
		MySQL:      "UNIX_TIMESTAMP(`memo`.`%s`)",
		PostgreSQL: "EXTRACT(EPOCH FROM memo.%s)",
	},
	"content_like": {
		SQLite:     "`memo`.`content` LIKE ?",
		MySQL:      "`memo`.`content` LIKE ?",
		PostgreSQL: "memo.content ILIKE ?",
	},
	"visibility_in": {
		SQLite:     "`memo`.`visibility` IN (%s)",
		MySQL:      "`memo`.`visibility` IN (%s)",
		PostgreSQL: "memo.visibility IN (%s)",
	},
}