forked from RedHatOfficial/GoCourse
-
Notifications
You must be signed in to change notification settings - Fork 0
/
lesson10.slide
169 lines (109 loc) · 3.35 KB
/
lesson10.slide
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
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
Databases
Lesson 10
Tags: golang, go
Stanislav Zeman <[email protected]>
ModernTV s.r.o.
https://github.com/RedHatOfficial/GoCourse
@RedHat
* Sources
- [[https://github.com/RedHatOfficial/GoCourse]]
.image ./common/qr_address.png
* Standard library
- [[https://pkg.go.dev/database/sql][databases/sql]] package
- only provides generic interface around SQL databases
- needs to be used in conjunction with a database driver
- list of [[https://github.com/golang/go/wiki/SQLDrivers][supported drivers]]
- low-level
* Usage
.code lesson10/sql.go
* Types of queries
- *Exec*: when no rows are returned
.code lesson10/sql_exec.go
- *QueryRow*: when at most one row is expected
.code lesson10/sql_query_row.go
* Types of queries
- *Query*: multiple values are returned
.code lesson10/sql_query.go
* GORM
- full-featured ORM
- high-level
- [[https://gorm.io/index.html][GORM project page]]
* Showcase
.code lesson10/gorm_showcase.go
* Model
.code lesson10/gorm_model.go
* CRUD - Create
- creating single record
.code lesson10/gorm_create.go
- create multiple records
.code lesson10/gorm_create_multiple.go
- create with selected fields
.code lesson10/gorm_create_selected_fields.go
* CRUD - Read
- reading a single record
.code lesson10/gorm_read.go
* CRUD - Read
- reading using primary key
.code lesson10/gorm_read_pk.go
- read all records
.code lesson10/gorm_read_all.go
* CRUD - Read
- reading using conditions
.code lesson10/gorm_read_conditions.go
* CRUD - Update
- *Save* saves all fields
.code lesson10/gorm_save.go
- if *Save* value does not contain primary key, it will execute create instead
.code lesson10/gorm_save_create.go
* CRUD - Update
- update single column
.code lesson10/gorm_update_single.go
- update multiple columns
.code lesson10/gorm_update_multiple.go
- without specifying the user using the Model, GORM executes batch update
.code lesson10/gorm_update_batch.go
* CRUD - Delete
- deleting using primary key
.code lesson10/gorm_delete_pk.go
* CRUD - Delete
- batch delete using where
.code lesson10/gorm_batch_delete.go
.code lesson10/gorm_batch_delete_with_pk.go
* CRUD - Delete
- does soft delete when structure contains gorm.DeletedAt field
.code lesson10/gorm_soft_delete.go
* Associations - Has Many
- 1:N - declaration using slice and foreign key
.code lesson10/gorm_has_many_declare.go
- retrieving the data
.code lesson10/gorm_has_many_retrieve.go
* Associations - Many to Many
- N:M - automatically add a join table
- declaration using slices and tags
.code lesson10/gorm_many_to_many_declare.go
* Associations - Many to Many
- retrieving the data
.code lesson10/gorm_many_to_many_retrieve.go
* Conventions
- uses field *ID* as the table's primary key by default
.code lesson10/gorm_id.go
- can be overwritten with a tag
.code lesson10/gorm_overwritten_id.go
* Conventions
- uses struct names as table names
- converts all names to snake_case
.code lesson10/gorm_snake_case.go
- table names can be overwritten using Tabler interface
.code lesson10/gorm_tabler.go
* Conventions
- column names can be overwritten using tags
.code lesson10/gorm_column_tags.go
* Conventions
- *CreatedAt* and *UpdatedAt* are automatically tracked for you
.code lesson10/gorm_created_at.go
- can be disabled
.code lesson10/gorm_disabled_created_at.go
* Raw SQL
- also supports raw sql execution
.code lesson10/gorm_raw_sql.go
.code lesson10/gorm_raw_sql_exec.go