FilesExpand file tree

 master

/

updating_rows.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

50 lines (31 loc) · 1.23 KB

 master

/

updating_rows.py

Copy path

Top

File metadata and controls

• Code
• Blame

50 lines (31 loc) · 1.23 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

# Sebastian Raschka, 2014

# Updating rows in an existing SQLite database

import sqlite3

sqlite_file = ''

table_name = ''

column_name_1 = ''

column_name_2 = ''

column_name_3 = ''

value_1 = 'hello world'

value_2 = 12345

conn = sqlite3.connect(sqlite_file)

c = conn.cursor()

# A.1) Updating all rows for a single column

c.execute('UPDATE {dn} SET {cn1}={v1}'.\

format(dn=table_name, cn1=column_name_1, v1=value1)

# A.2) Updating all rows for 2 columns (same for multiple columns)

c.execute('UPDATE {dn} SET {cn1}={v1}, {cn2}={v2}'.\

format(dn=table_name, cn1=column_name_1, cn2=column_name_2,

v1=value1, v2=value2)

# B.1) Updating specific rows that meet a certain criterion

# here: update column_1 with value_1 if row has value_2 in column_2

c.execute('UPDATE {dn} SET {cn1}={v1} WHERE {cn2}={v2}'.\

format(dn=table_name, cn1=column_name_1, v1=value1)

# B.2) Updating specific rows that meet multiple criteria

# here: update column_1 with value_1

# if row has value_2 in column_2

# and if row has value = 1 in column_3

c.execute('UPDATE {dn} SET {cn1}={v1} WHERE {cn2}={v2} AND {cn3}=1'.\

format(dn=table_name, cn1=column_name_1, v1=value1, cn3=column_name_3)

conn.commit()

conn.close()