forked from typeorm/typeorm
-
Notifications
You must be signed in to change notification settings - Fork 0
/
results-templates.ts
157 lines (150 loc) · 6.55 KB
/
results-templates.ts
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
export const resultsTemplates: Record<string, any> = {
postgres: {
control: [
`CREATE TABLE "post" ("id" SERIAL NOT NULL, "title" character varying NOT NULL, "createdAt" TIMESTAMP NOT NULL DEFAULT now(), CONSTRAINT "PK_be5fda3aac270b134ff9c21cdee" PRIMARY KEY ("id"))`,
`CREATE TABLE "username" ("username" character varying NOT NULL, "email" character varying NOT NULL, "something" character varying NOT NULL, CONSTRAINT "PK_b39ad32e514b17e90c93988888a" PRIMARY KEY ("username"))`
],
pretty: [
`
CREATE TABLE "post" (
"id" SERIAL NOT NULL,
"title" character varying NOT NULL,
"createdAt" TIMESTAMP NOT NULL DEFAULT now(),
CONSTRAINT "PK_be5fda3aac270b134ff9c21cdee" PRIMARY KEY ("id")
)
`,
`
CREATE TABLE "username" (
"username" character varying NOT NULL,
"email" character varying NOT NULL,
"something" character varying NOT NULL,
CONSTRAINT "PK_b39ad32e514b17e90c93988888a" PRIMARY KEY ("username")
)
`
]
},
mssql: {
control: [
`CREATE TABLE "post" ("id" int NOT NULL IDENTITY(1,1), "title" nvarchar(255) NOT NULL, "createdAt" datetime2 NOT NULL CONSTRAINT "DF_fb91bea2d37140a877b775e6b2a" DEFAULT getdate(), CONSTRAINT "PK_be5fda3aac270b134ff9c21cdee" PRIMARY KEY ("id"))`,
`CREATE TABLE "username" ("username" nvarchar(255) NOT NULL, "email" nvarchar(255) NOT NULL, "something" nvarchar(255) NOT NULL, CONSTRAINT "PK_b39ad32e514b17e90c93988888a" PRIMARY KEY ("username"))`
],
pretty: [
`
CREATE TABLE "post" (
"id" int NOT NULL IDENTITY(1, 1),
"title" nvarchar(255) NOT NULL,
"createdAt" datetime2 NOT NULL CONSTRAINT "DF_fb91bea2d37140a877b775e6b2a" DEFAULT getdate(),
CONSTRAINT "PK_be5fda3aac270b134ff9c21cdee" PRIMARY KEY ("id")
)
`,
`
CREATE TABLE "username" (
"username" nvarchar(255) NOT NULL,
"email" nvarchar(255) NOT NULL,
"something" nvarchar(255) NOT NULL,
CONSTRAINT "PK_b39ad32e514b17e90c93988888a" PRIMARY KEY ("username")
)
`
]
},
sqlite: {
control: [
`CREATE TABLE "post" ("id" integer PRIMARY KEY AUTOINCREMENT NOT NULL, "title" varchar NOT NULL, "createdAt" datetime NOT NULL DEFAULT (datetime('now')))`,
`CREATE TABLE "username" ("username" varchar PRIMARY KEY NOT NULL, "email" varchar NOT NULL, "something" varchar NOT NULL)`,
],
pretty: [
`
CREATE TABLE "post" (
"id" integer PRIMARY KEY AUTOINCREMENT NOT NULL,
"title" varchar NOT NULL,
"createdAt" datetime NOT NULL DEFAULT (datetime('now'))
)
`,
`
CREATE TABLE "username" (
"username" varchar PRIMARY KEY NOT NULL,
"email" varchar NOT NULL,
"something" varchar NOT NULL
)
`
]
},
mysql: {
control: [
`CREATE TABLE \`post\` (\`id\` int NOT NULL AUTO_INCREMENT, \`title\` varchar(255) NOT NULL, \`createdAt\` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6), PRIMARY KEY (\`id\`)) ENGINE=InnoDB`,
`CREATE TABLE \`username\` (\`username\` varchar(255) NOT NULL, \`email\` varchar(255) NOT NULL, \`something\` varchar(255) NOT NULL, PRIMARY KEY (\`username\`)) ENGINE=InnoDB`
],
pretty: [
`
CREATE TABLE \`post\` (
\`id\` int NOT NULL AUTO_INCREMENT,
\`title\` varchar(255) NOT NULL,
\`createdAt\` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),
PRIMARY KEY (\`id\`)
) ENGINE = InnoDB
`,
`
CREATE TABLE \`username\` (
\`username\` varchar(255) NOT NULL,
\`email\` varchar(255) NOT NULL,
\`something\` varchar(255) NOT NULL,
PRIMARY KEY (\`username\`)
) ENGINE = InnoDB
`
]
},
oracle: {
control: [
`CREATE TABLE "post" ("id" number GENERATED BY DEFAULT AS IDENTITY, "title" varchar2(255) NOT NULL, "createdAt" timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL, CONSTRAINT "PK_be5fda3aac270b134ff9c21cdee" PRIMARY KEY ("id"))`,
`CREATE TABLE "username" ("username" varchar2(255) NOT NULL, "email" varchar2(255) NOT NULL, "something" varchar2(255) NOT NULL, CONSTRAINT "PK_b39ad32e514b17e90c93988888a" PRIMARY KEY ("username"))`
],
pretty: [
`
CREATE TABLE "post" (
"id" number GENERATED BY DEFAULT AS IDENTITY,
"title" varchar2(255) NOT NULL,
"createdAt" timestamp DEFAULT CURRENT_TIMESTAMP NOT NULL,
CONSTRAINT "PK_be5fda3aac270b134ff9c21cdee" PRIMARY KEY ("id")
)
`,
`
CREATE TABLE "username" (
"username" varchar2(255) NOT NULL,
"email" varchar2(255) NOT NULL,
"something" varchar2(255) NOT NULL,
CONSTRAINT "PK_b39ad32e514b17e90c93988888a" PRIMARY KEY ("username")
)
`
]
},
cockroachdb: {
control: [
`CREATE SEQUENCE "post_id_seq"`,
`CREATE TABLE "post" ("id" INT DEFAULT nextval('"post_id_seq"') NOT NULL, "title" varchar NOT NULL, "createdAt" timestamptz NOT NULL DEFAULT now(), CONSTRAINT "PK_be5fda3aac270b134ff9c21cdee" PRIMARY KEY ("id"))`,
`CREATE TABLE "username" ("username" varchar NOT NULL, "email" varchar NOT NULL, "something" varchar NOT NULL, CONSTRAINT "PK_b39ad32e514b17e90c93988888a" PRIMARY KEY ("username"))`
],
pretty: [
`
CREATE SEQUENCE "post_id_seq"
`,
`
CREATE TABLE "post" (
"id" INT DEFAULT nextval('"post_id_seq"') NOT NULL,
"title" varchar NOT NULL,
"createdAt" timestamptz NOT NULL DEFAULT now(),
CONSTRAINT "PK_be5fda3aac270b134ff9c21cdee" PRIMARY KEY ("id")
)
`,
`
CREATE TABLE "username" (
"username" varchar NOT NULL,
"email" varchar NOT NULL,
"something" varchar NOT NULL,
CONSTRAINT "PK_b39ad32e514b17e90c93988888a" PRIMARY KEY ("username")
)
`
]
},
get mariadb() { return this.mysql; },
get "better-sqlite3"() { return this.sqlite; },
};