feat(endtoend/testdata): added two sqlite CAST tests and rearranged…

… postgres tests for same Related to discussion in #2473 (comment)
sqlc-dev · kyleconroy · Jul 31, 2023 · Jul 31, 2023 · Jul 31, 2023 · a6f2d7d0cb5e1d9049f2ab05e2570e011aad0115
commit a6f2d7d0cb5e1d9049f2ab05e2570e011aad0115
diff --git a/...d/testdata/func_call_cast/pgx/v4/go/db.go → ...func_call_cast/postgresql/pgx/v4/go/db.go b/...d/testdata/func_call_cast/pgx/v4/go/db.go → ...func_call_cast/postgresql/pgx/v4/go/db.go
diff --git a/...stdata/func_call_cast/pgx/v4/go/models.go → ..._call_cast/postgresql/pgx/v4/go/models.go b/...stdata/func_call_cast/pgx/v4/go/models.go → ..._call_cast/postgresql/pgx/v4/go/models.go
diff --git a/...ata/func_call_cast/pgx/v4/go/query.sql.go → ...ll_cast/postgresql/pgx/v4/go/query.sql.go b/...ata/func_call_cast/pgx/v4/go/query.sql.go → ...ll_cast/postgresql/pgx/v4/go/query.sql.go
diff --git a/.../testdata/func_call_cast/pgx/v4/query.sql → ...unc_call_cast/postgresql/pgx/v4/query.sql b/.../testdata/func_call_cast/pgx/v4/query.sql → ...unc_call_cast/postgresql/pgx/v4/query.sql
diff --git a/.../testdata/func_call_cast/pgx/v4/sqlc.json → ...unc_call_cast/postgresql/pgx/v4/sqlc.json b/.../testdata/func_call_cast/pgx/v4/sqlc.json → ...unc_call_cast/postgresql/pgx/v4/sqlc.json
diff --git a/...d/testdata/func_call_cast/pgx/v5/go/db.go → ...func_call_cast/postgresql/pgx/v5/go/db.go b/...d/testdata/func_call_cast/pgx/v5/go/db.go → ...func_call_cast/postgresql/pgx/v5/go/db.go
diff --git a/...stdata/func_call_cast/pgx/v5/go/models.go → ..._call_cast/postgresql/pgx/v5/go/models.go b/...stdata/func_call_cast/pgx/v5/go/models.go → ..._call_cast/postgresql/pgx/v5/go/models.go
diff --git a/...ata/func_call_cast/pgx/v5/go/query.sql.go → ...ll_cast/postgresql/pgx/v5/go/query.sql.go b/...ata/func_call_cast/pgx/v5/go/query.sql.go → ...ll_cast/postgresql/pgx/v5/go/query.sql.go
diff --git a/.../testdata/func_call_cast/pgx/v5/query.sql → ...unc_call_cast/postgresql/pgx/v5/query.sql b/.../testdata/func_call_cast/pgx/v5/query.sql → ...unc_call_cast/postgresql/pgx/v5/query.sql
diff --git a/.../testdata/func_call_cast/pgx/v5/sqlc.json → ...unc_call_cast/postgresql/pgx/v5/sqlc.json b/.../testdata/func_call_cast/pgx/v5/sqlc.json → ...unc_call_cast/postgresql/pgx/v5/sqlc.json
diff --git a/...d/testdata/func_call_cast/stdlib/go/db.go → ...func_call_cast/postgresql/stdlib/go/db.go b/...d/testdata/func_call_cast/stdlib/go/db.go → ...func_call_cast/postgresql/stdlib/go/db.go
diff --git a/...stdata/func_call_cast/stdlib/go/models.go → ..._call_cast/postgresql/stdlib/go/models.go b/...stdata/func_call_cast/stdlib/go/models.go → ..._call_cast/postgresql/stdlib/go/models.go
diff --git a/...ata/func_call_cast/stdlib/go/query.sql.go → ...ll_cast/postgresql/stdlib/go/query.sql.go b/...ata/func_call_cast/stdlib/go/query.sql.go → ...ll_cast/postgresql/stdlib/go/query.sql.go
diff --git a/.../testdata/func_call_cast/stdlib/query.sql → ...unc_call_cast/postgresql/stdlib/query.sql b/.../testdata/func_call_cast/stdlib/query.sql → ...unc_call_cast/postgresql/stdlib/query.sql
diff --git a/.../testdata/func_call_cast/stdlib/sqlc.json → ...unc_call_cast/postgresql/stdlib/sqlc.json b/.../testdata/func_call_cast/stdlib/sqlc.json → ...unc_call_cast/postgresql/stdlib/sqlc.json
diff --git a/...stdata/select_column_cast/stdlib/go/db.go → ...d/testdata/func_call_cast/sqlite/go/db.go b/...stdata/select_column_cast/stdlib/go/db.go → ...d/testdata/func_call_cast/sqlite/go/db.go
diff --git a/internal/endtoend/testdata/func_call_cast/sqlite/go/models.go b/internal/endtoend/testdata/func_call_cast/sqlite/go/models.go
diff --git a/internal/endtoend/testdata/func_call_cast/sqlite/go/query.sql.go b/internal/endtoend/testdata/func_call_cast/sqlite/go/query.sql.go
diff --git a/internal/endtoend/testdata/func_call_cast/sqlite/query.sql b/internal/endtoend/testdata/func_call_cast/sqlite/query.sql
@@ -0,0 +1,2 @@
+-- name: Demo :one
+SELECT CAST(CHAR(1,2,3,4,5) AS BLOB) AS col1
diff --git a/internal/endtoend/testdata/func_call_cast/sqlite/sqlc.json b/internal/endtoend/testdata/func_call_cast/sqlite/sqlc.json
@@ -0,0 +1,12 @@
+{
+	"version": "1",
+	"packages": [
+		{
+			"path": "go",
+			"engine": "sqlite",
+			"name": "querytest",
+			"schema": "query.sql",
+			"queries": "query.sql"
+		}
+	]
+}
diff --git a/...stdata/select_column_cast/pgx/v4/go/db.go → ...ct_column_cast/postgresql/pgx/v4/go/db.go b/...stdata/select_column_cast/pgx/v4/go/db.go → ...ct_column_cast/postgresql/pgx/v4/go/db.go
diff --git a/...ta/select_column_cast/pgx/v4/go/models.go → ...olumn_cast/postgresql/pgx/v4/go/models.go b/...ta/select_column_cast/pgx/v4/go/models.go → ...olumn_cast/postgresql/pgx/v4/go/models.go
diff --git a/...select_column_cast/pgx/v4/go/query.sql.go → ...mn_cast/postgresql/pgx/v4/go/query.sql.go b/...select_column_cast/pgx/v4/go/query.sql.go → ...mn_cast/postgresql/pgx/v4/go/query.sql.go
diff --git a/...tdata/select_column_cast/pgx/v4/query.sql → ...t_column_cast/postgresql/pgx/v4/query.sql b/...tdata/select_column_cast/pgx/v4/query.sql → ...t_column_cast/postgresql/pgx/v4/query.sql
diff --git a/...tdata/select_column_cast/pgx/v4/sqlc.json → ...t_column_cast/postgresql/pgx/v4/sqlc.json b/...tdata/select_column_cast/pgx/v4/sqlc.json → ...t_column_cast/postgresql/pgx/v4/sqlc.json
diff --git a/...stdata/select_column_cast/pgx/v5/go/db.go → ...ct_column_cast/postgresql/pgx/v5/go/db.go b/...stdata/select_column_cast/pgx/v5/go/db.go → ...ct_column_cast/postgresql/pgx/v5/go/db.go
diff --git a/...ta/select_column_cast/pgx/v5/go/models.go → ...olumn_cast/postgresql/pgx/v5/go/models.go b/...ta/select_column_cast/pgx/v5/go/models.go → ...olumn_cast/postgresql/pgx/v5/go/models.go
diff --git a/...select_column_cast/pgx/v5/go/query.sql.go → ...mn_cast/postgresql/pgx/v5/go/query.sql.go b/...select_column_cast/pgx/v5/go/query.sql.go → ...mn_cast/postgresql/pgx/v5/go/query.sql.go
diff --git a/...tdata/select_column_cast/pgx/v5/query.sql → ...t_column_cast/postgresql/pgx/v5/query.sql b/...tdata/select_column_cast/pgx/v5/query.sql → ...t_column_cast/postgresql/pgx/v5/query.sql
diff --git a/...tdata/select_column_cast/pgx/v5/sqlc.json → ...t_column_cast/postgresql/pgx/v5/sqlc.json b/...tdata/select_column_cast/pgx/v5/sqlc.json → ...t_column_cast/postgresql/pgx/v5/sqlc.json
diff --git a/internal/endtoend/testdata/select_column_cast/postgresql/stdlib/go/db.go b/internal/endtoend/testdata/select_column_cast/postgresql/stdlib/go/db.go
diff --git a/...ta/select_column_cast/stdlib/go/models.go → ...olumn_cast/postgresql/stdlib/go/models.go b/...ta/select_column_cast/stdlib/go/models.go → ...olumn_cast/postgresql/stdlib/go/models.go
diff --git a/...select_column_cast/stdlib/go/query.sql.go → ...mn_cast/postgresql/stdlib/go/query.sql.go b/...select_column_cast/stdlib/go/query.sql.go → ...mn_cast/postgresql/stdlib/go/query.sql.go
diff --git a/...tdata/select_column_cast/stdlib/query.sql → ...t_column_cast/postgresql/stdlib/query.sql b/...tdata/select_column_cast/stdlib/query.sql → ...t_column_cast/postgresql/stdlib/query.sql
diff --git a/...tdata/select_column_cast/stdlib/sqlc.json → ...t_column_cast/postgresql/stdlib/sqlc.json b/...tdata/select_column_cast/stdlib/sqlc.json → ...t_column_cast/postgresql/stdlib/sqlc.json
diff --git a/internal/endtoend/testdata/select_column_cast/sqlite/go/db.go b/internal/endtoend/testdata/select_column_cast/sqlite/go/db.go
diff --git a/internal/endtoend/testdata/select_column_cast/sqlite/go/models.go b/internal/endtoend/testdata/select_column_cast/sqlite/go/models.go
diff --git a/internal/endtoend/testdata/select_column_cast/sqlite/go/query.sql.go b/internal/endtoend/testdata/select_column_cast/sqlite/go/query.sql.go
diff --git a/internal/endtoend/testdata/select_column_cast/sqlite/query.sql b/internal/endtoend/testdata/select_column_cast/sqlite/query.sql
@@ -0,0 +1,4 @@
+CREATE TABLE foo (bar TEXT NOT NULL);
+
+-- name: SelectColumnCast :many
+SELECT CAST(bar AS BLOB) FROM foo;
diff --git a/internal/endtoend/testdata/select_column_cast/sqlite/sqlc.json b/internal/endtoend/testdata/select_column_cast/sqlite/sqlc.json
@@ -0,0 +1,12 @@
+{
+	"version": "1",
+	"packages": [
+		{
+			"path": "go",
+			"engine": "sqlite",
+			"name": "querytest",
+			"schema": "query.sql",
+			"queries": "query.sql"
+		}
+	]
+}
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		-- name: Demo :one
		SELECT CAST(CHAR(1,2,3,4,5) AS BLOB) AS col1