v / vlib / orm / orm_insert_reserved_name_test.v
34 lines · 28 sloc · 459 bytes · 99be39cbd15d4bbb5ab14d2f870199908c00bc8d
Raw
1// vtest retry: 3
2import db.sqlite
3
4@[table: 'bad_table']
5struct Bad {
6 id int @[primary; sql: serial]
7 link string
8}
9
10fn test_insert_with_reserved_name() {
11 db := sqlite.connect(':memory:') or { panic(err) }
12
13 bad := Bad{
14 link: 'test'
15 }
16 sql db {
17 create table Bad
18 }!
19 sql db {
20 insert bad into Bad
21 }!
22
23 sql db {
24 insert bad into Bad
25 insert bad into Bad
26 insert bad into Bad
27 }!
28
29 rows := sql db {
30 select from Bad
31 }!
32
33 assert rows.len == 4
34}
35