Skip to content

Issue in the query and Table creation #9

@prajwalpkp2106

Description

@prajwalpkp2106

There is a missing closing bracket ) in the MovieData() function while creating the table. Below is the corrected query:

cur.execute("CREATE TABLE IF NOT EXISTS book (id INTEGER PRIMARY KEY, Movie_ID text, Movie_Name text, Release_Date text, Director text, Cast text, Budget text, Duration text, Rating text)")

Additionally, please add the following line to MiniProject_Frontend.py to ensure the table is created when the project runs for the first time:

# Ensure the table is created
MiniProject_Backend.MovieData()

This ensures the table is properly created and initialized.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions