v/vlib/orm/orm_result_test.v at master · initdc/v · GitHub

8000 v/vlib/orm/orm_result_test.v at master · initdc/v · GitHub

Repository navigation

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

// vtest retry: 3

import db.sqlite

struct Account {

id int @[primary; sql: serial]

name string

}

struct Note {

id int @[primary; sql: serial]

content string

}

fn test_catch_table_is_not_created() {

mut db := sqlite.connect(':memory:')!

mut is_inserted := true

account := Account{}

sql db {

insert account into Account

} or { is_inserted = false }

assert !is_inserted

}

fn test_catch_one_of_queries() {

mut db := sqlite.connect(':memory:')!

sql db {

create table Account

}!

account := Account{}

sql db {

insert account into Account

}!

mut are_updated := true

sql db {

update Account set name = 'test' where id == 1

update Note set content = 'test' where id == 1

} or { are_updated = false }

assert !are_updated

}

fn test_print_results() {

mut db := sqlite.connect(':memory:')!

sql db {

create table Account

}!

account := Account{}

sql db {

insert account into Account

}!

i := sql db {

insert account into Account

}!

println(i)

count := sql db {

select count from Account

}!

println(count)

user := sql db {

select from Account

}!.first()

println(user)

users := sql db {

select from Account

}!

println(users)

assert true

}

0