FilesExpand file tree

 master

/

add_new_column.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

28 lines (22 loc) · 1.06 KB

 master

/

add_new_column.py

Copy path

Top

File metadata and controls

• Code
• Blame

28 lines (22 loc) · 1.06 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

# Sebastian Raschka, 2014

# Adding a new column to an existing SQLite database

import sqlite3

sqlite_file = 'my_first_db.sqlite' # name of the sqlite database file

table_name = 'my_table_2' # name of the table to be created

id_column = 'my_1st_column' # name of the PRIMARY KEY column

new_column1 = 'my_2nd_column' # name of the new column

new_column2 = 'my_3rd_column' # name of the new column

column_type = 'TEXT' # E.g., INTEGER, TEXT, NULL, REAL, BLOB

default_val = 'Hello World' # a default value for the new column rows

# Connecting to the database file

conn = sqlite3.connect(sqlite_file)

c = conn.cursor()

# A) Adding a new column without a row value

c.execute("ALTER TABLE {tn} ADD COLUMN '{cn}' {ct}"\

.format(tn=table_name, cn=new_column1, ct=column_type))

# B) Adding a new column with a default row value

c.execute("ALTER TABLE {tn} ADD COLUMN '{cn}' {ct} DEFAULT '{df}'"\

.format(tn=table_name, cn=new_column2, ct=column_type, df=default_val))

# Committing changes and closing the connection to the database file

conn.commit()

conn.close()