/
githubmirror
/
sqlc
Обзор
Документация
Войти
/
githubmirror
/
sqlc
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
internal/endtoend/testdata/quoted_names_complex/sqlite/schema.sql
22 строки
980 B
Kyle Gray
feat(sqlite): Add database analyzer using ncruces/go-sqlite3 (#4199)
30 ноя 2025, 01:19
Не верифицирован
30 ноя 2025, 01:19
b83465a
Код
Авторство
О чём код?
-- Test complex quoted table and column names with special characters -- Covers spaces, hyphens, uppercase, and mixed operations CREATE TABLE "user profiles" (id integer primary key, data text); CREATE TABLE "ORDERS" (id integer primary key, data text); CREATE TABLE products (id integer primary key, data text); CREATE TABLE "item-categories" (id integer primary key, data text); -- Test ALTER statements with complex identifiers ALTER TABLE "user profiles" RENAME COLUMN data TO "profile data"; ALTER TABLE "ORDERS" RENAME TO "customer_orders"; ALTER TABLE products ADD COLUMN "Price Info" text; -- Test mixed case operations across different statement types INSERT INTO "user profiles" ("profile data") VALUES ('test data'); UPDATE "customer_orders" SET data = 'updated' WHERE id = 1; DELETE FROM products WHERE id = 1; -- Test DROP with various identifier formats DROP TABLE "user profiles"; DROP TABLE "customer_orders"; DROP TABLE "item-categories"; DROP TABLE products;