F9jAzwDf

1conn = sqlite3.connect('tmdb.db')
2c = conn.cursor()
3
4#Create a table for each entity (except genre since it is already created) in the E-R Diagram.
5
6c.execute("""CREATE TABLE IF NOT EXISTS movie(
7            id integer,
8            homepage str,
9            budget integer,
10            original_language str,
11            original_title str,
12            overview str,
13            popularity float,
14            release_date str,
15            revenue integer,
16            runtime float,
17            status str,
18            tagline str,
19            title str,
20            vote_average float,
21            vote_count float,
22            primary key(id)
23)""")
24
25c.execute("""CREATE TABLE IF NOT EXISTS keywords(
26            id integer,
27            name text,
28            primary key(id)
29)""")
30
31c.execute("""CREATE TABLE IF NOT EXISTS production_companies(
32            id integer,
33            name text,
34            primary key(id)
35)""")
36
37c.execute("""CREATE TABLE IF NOT EXISTS spoken_languages(
38            id integer,
39            name text,
40            primary key(id)
41)""")
42
43c.execute("""CREATE TABLE IF NOT EXISTS production_countries(
44            id integer,
45            name text,
46            primary key(id)
47)""")
48
49c.execute("""CREATE TABLE IF NOT EXISTS person(
50            id integer,
51            gender integer,
52            credit_id text,
53            name text,
54            primary key(id)
55)""")
56
57c.execute("""CREATE TABLE IF NOT EXISTS cast(
58            cid integer,
59            cast_id integer,
60            character text,
61            cast_order integer,
62            foreign key(cid)
63                references person(id)
64)""")
65
66c.execute("""CREATE TABLE IF NOT EXISTS crew(
67            cid integer,
68            department text,
69            job text,
70            foreign key (cid)
71               references person(id)
72)""")
73
74conn.commit()
75conn.close()