Function TestFuncReplacement

pgserver/in_place_handler_test.go:20–192

(t *testing.T)

}

func TestFuncReplacement(t *testing.T) {
	tests := []struct {
		name       string
		executions []FuncReplacementExecution
	}{
		// Get Postgresql Configuration
		{
			name: "Test Metabase query on Postgresql Configuration 1",
			executions: []FuncReplacementExecution{
				{
					// The testing target is 'PG_CATALOG.PG_GET_INDEXDEF' and 'INFORMATION_SCHEMA._PG_EXPANDARRAY'
					SQL: `SELECT
    "tmp"."table-schema", "tmp"."table-name",
    TRIM(BOTH '"' FROM PG_CATALOG.PG_GET_INDEXDEF("tmp"."ci_oid", "tmp"."pos", FALSE)) AS "field-name"
FROM (SELECT
          "n"."nspname" AS "table-schema",
          "ct"."relname" AS "table-name",
          "ci"."oid" AS "ci_oid",
          (INFORMATION_SCHEMA._PG_EXPANDARRAY("i"."indkey"))."n" AS "pos"
      FROM "pg_catalog"."pg_class" AS "ct"
           INNER JOIN "pg_catalog"."pg_namespace" AS "n" ON "ct"."relnamespace" = "n"."oid"
           INNER JOIN "pg_catalog"."pg_index" AS "i" ON "ct"."oid" = "i"."indrelid"
           INNER JOIN "pg_catalog"."pg_class" AS "ci" ON "ci"."oid" = "i"."indexrelid"
      WHERE (PG_CATALOG.PG_GET_EXPR("i"."indpred", "i"."indrelid") IS NULL)
            AND n.nspname !~ '^information_schema|catalog_history|pg_') AS "tmp"
WHERE "tmp"."pos" = 1`,
					// TODO(sean): There's no data currently, we just check the query is executed without error
					Expected: [][]string{},
					WantErr:  false,
				},
			},
		},
		{
			name: "Test Metabase query on Postgresql Configuration 2",
			executions: []FuncReplacementExecution{
				{
					// The testing target is 'pg_class'::RegClass
					SQL: `SELECT
    n.nspname AS schema,
    c.relname AS name,
    CASE c.relkind
        WHEN 'r' THEN 'TABLE'
        WHEN 'p' THEN 'PARTITIONED TABLE'
        WHEN 'v' THEN 'VIEW'
        WHEN 'f' THEN 'FOREIGN TABLE'
        WHEN 'm' THEN 'MATERIALIZED VIEW'
        ELSE NULL
    END AS type,
    d.description AS description,
    stat.n_live_tup AS estimated_row_count
FROM pg_catalog.pg_class AS c
     INNER JOIN pg_catalog.pg_namespace AS n ON c.relnamespace = n.oid
     LEFT JOIN pg_catalog.pg_description AS d ON ((c.oid = d.objoid)
                                                 AND (d.objsubid = 1))
                                                 AND (d.classoid = 'pg_class'::RegClass)
     LEFT JOIN pg_stat_user_tables AS stat ON (n.nspname = stat.schemaname)
                                              AND (c.relname = stat.relname)
WHERE ((((c.relnamespace = n.oid) AND (n.nspname !~ 'information_schema'))