File: drop_all.test.lua

package info (click to toggle)
tarantool 2.6.0-1
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 85,364 kB
  • sloc: ansic: 513,760; cpp: 69,489; sh: 25,650; python: 19,190; perl: 14,973; makefile: 4,173; yacc: 1,329; sql: 1,074; pascal: 620; ruby: 190; awk: 18; lisp: 7
file content (39 lines) | stat: -rwxr-xr-x 657 bytes parent folder | download | duplicates (3)
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
#!/usr/bin/env tarantool
test = require("sqltester")
test:plan(3)
local prefix = "drop_all-"


local N = 10
test:do_test(
    prefix.."1.0",
    function()
        for i = 1, N do
            test:execsql(string.format("create table table%s(a INT primary key)", i))
        end

        for i = 1, N do
            test:execsql(string.format("create view view%s as select * from table%s", i, i))
        end
    end,
    nil)


test:do_test(
    prefix.."-1.1",
    function()
        return test:drop_all_views()
    end,
    N
)

test:do_test(
    prefix.."-1.1",
    function()
        return test:drop_all_tables()
    end,
    N
)

test:finish_test()