(t *testing.T)
| 238 | }) |
| 239 | } |
| 240 | func 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"), |
nothing calls this directly
no test coverage detected