MCPcopy Create free account
hub / github.com/araddon/qlbridge / TestLexSqlDrop

Function TestLexSqlDrop

lex/dialect_sql_test.go:240–299  ·  view source on GitHub ↗
(t *testing.T)

Source from the content-addressed store, hash-verified

238 })
239}
240func TestLexSqlDrop(t *testing.T) {
241 // DROP {DATABASE | SCHEMA | SOURCE | TABLE} [IF EXISTS] db_name
242 verifyTokens(t, `DROP SCHEMA IF EXISTS myschema;`,
243 []Token{
244 tv(TokenDrop, "DROP"),
245 tv(TokenSchema, "SCHEMA"),
246 tv(TokenIf, "IF"),
247 tv(TokenExists, "EXISTS"),
248 tv(TokenIdentity, "myschema"),
249 })
250 verifyTokens(t, `DROP TABLE IF EXISTS mytable;`,
251 []Token{
252 tv(TokenDrop, "DROP"),
253 tv(TokenTable, "TABLE"),
254 tv(TokenIf, "IF"),
255 tv(TokenExists, "EXISTS"),
256 tv(TokenIdentity, "mytable"),
257 })
258 verifyTokens(t, `DROP TEMPORARY TABLE mytable;`,
259 []Token{
260 tv(TokenDrop, "DROP"),
261 tv(TokenTemp, "TEMPORARY"),
262 tv(TokenTable, "TABLE"),
263 tv(TokenIdentity, "mytable"),
264 })
265 verifyTokens(t, `DROP SOURCE IF EXISTS mysource;`,
266 []Token{
267 tv(TokenDrop, "DROP"),
268 tv(TokenSource, "SOURCE"),
269 tv(TokenIf, "IF"),
270 tv(TokenExists, "EXISTS"),
271 tv(TokenIdentity, "mysource"),
272 })
273 verifyTokens(t, `DROP DATABASE IF EXISTS mydb;`,
274 []Token{
275 tv(TokenDrop, "DROP"),
276 tv(TokenDatabase, "DATABASE"),
277 tv(TokenIf, "IF"),
278 tv(TokenExists, "EXISTS"),
279 tv(TokenIdentity, "mydb"),
280 })
281 verifyTokens(t, `DROP DATABASE mydb;`,
282 []Token{
283 tv(TokenDrop, "DROP"),
284 tv(TokenDatabase, "DATABASE"),
285 tv(TokenIdentity, "mydb"),
286 })
287 verifyTokens(t, `DROP VIEW myv;`,
288 []Token{
289 tv(TokenDrop, "DROP"),
290 tv(TokenView, "VIEW"),
291 tv(TokenIdentity, "myv"),
292 })
293 verifyTokens(t, `DROP CONTINUOUSVIEW myv;`,
294 []Token{
295 tv(TokenDrop, "DROP"),
296 tv(TokenContinuousView, "CONTINUOUSVIEW"),
297 tv(TokenIdentity, "myv"),

Callers

nothing calls this directly

Calls 2

verifyTokensFunction · 0.70
tvFunction · 0.70

Tested by

no test coverage detected