FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
sqlmodel/docs_src/tutorial/delete/tutorial001.py at patch-1 · bubbletroubles/sqlmodel · GitHub
bubbletroubles
sqlmodel
Repository navigation
Code
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
sqlmodel
/
docs_src
/
tutorial
/
delete
/
tutorial001.py
Copy path
More file actions
More file actions
Latest commit
History
History
History
100 lines (71 loc) · 2.73 KB
Breadcrumbs
sqlmodel
/
docs_src
/
tutorial
/
delete
/
tutorial001.py
Copy path
File metadata and controls
100 lines (71 loc) · 2.73 KB
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
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
from
typing
import
Optional
from
sqlmodel
import
Field
,
Session
,
SQLModel
,
create_engine
,
select
class
Hero
(
SQLModel
,
table
=
True
):
id
:
Optional
[
int
]
=
Field
(
default
=
None
,
primary_key
=
True
)
name
:
str
=
Field
(
index
=
True
)
secret_name
:
str
age
:
Optional
[
int
]
=
Field
(
default
=
None
,
index
=
True
)
sqlite_file_name
=
"database.db"
sqlite_url
=
f"sqlite:///
{
sqlite_file_name
}
"
engine
=
create_engine
(
sqlite_url
,
echo
=
True
)
def
create_db_and_tables
():
SQLModel
.
metadata
.
create_all
(
engine
)
def
create_heroes
():
hero_1
=
Hero
(
name
=
"Deadpond"
,
secret_name
=
"Dive Wilson"
)
hero_2
=
Hero
(
name
=
"Spider-Boy"
,
secret_name
=
"Pedro Parqueador"
)
hero_3
=
Hero
(
name
=
"Rusty-Man"
,
secret_name
=
"Tommy Sharp"
,
age
=
48
)
hero_4
=
Hero
(
name
=
"Tarantula"
,
secret_name
=
"Natalia Roman-on"
,
age
=
32
)
hero_5
=
Hero
(
name
=
"Black Lion"
,
secret_name
=
"Trevor Challa"
,
age
=
35
)
hero_6
=
Hero
(
name
=
"Dr. Weird"
,
secret_name
=
"Steve Weird"
,
age
=
36
)
hero_7
=
Hero
(
name
=
"Captain North America"
,
secret_name
=
"Esteban Rogelios"
,
age
=
93
)
with
Session
(
engine
)
as
session
:
session
.
add
(
hero_1
)
session
.
add
(
hero_2
)
session
.
add
(
hero_3
)
session
.
add
(
hero_4
)
session
.
add
(
hero_5
)
session
.
add
(
hero_6
)
session
.
add
(
hero_7
)
session
.
commit
()
def
update_heroes
():
with
Session
(
engine
)
as
session
:
statement
=
select
(
Hero
).
where
(
Hero
.
name
==
"Spider-Boy"
)
results
=
session
.
exec
(
statement
)
hero_1
=
results
.
one
()
print
(
"Hero 1:"
,
hero_1
)
statement
=
select
(
Hero
).
where
(
Hero
.
name
==
"Captain North America"
)
results
=
session
.
exec
(
statement
)
hero_2
=
results
.
one
()
print
(
"Hero 2:"
,
hero_2
)
hero_1
.
age
=
16
hero_1
.
name
=
"Spider-Youngster"
session
.
add
(
hero_1
)
hero_2
.
name
=
"Captain North America Except Canada"
hero_2
.
age
=
110
session
.
add
(
hero_2
)
session
.
commit
()
session
.
refresh
(
hero_1
)
session
.
refresh
(
hero_2
)
print
(
"Updated hero 1:"
,
hero_1
)
print
(
"Updated hero 2:"
,
hero_2
)
def
delete_heroes
():
with
Session
(
engine
)
as
session
:
statement
=
select
(
Hero
).
where
(
Hero
.
name
==
"Spider-Youngster"
)
results
=
session
.
exec
(
statement
)
hero
=
results
.
one
()
print
(
"Hero: "
,
hero
)
session
.
delete
(
hero
)
session
.
commit
()
print
(
"Deleted hero:"
,
hero
)
statement
=
select
(
Hero
).
where
(
Hero
.
name
==
"Spider-Youngster"
)
results
=
session
.
exec
(
statement
)
hero
=
results
.
first
()
if
hero
is
None
:
print
(
"There's no hero named Spider-Youngster"
)
def
main
():
create_db_and_tables
()
create_heroes
()
update_heroes
()
delete_heroes
()
if
__name__
==
"__main__"
:
main
()
Back
|
FazBrowse Home
|
New Git URL