Question: You will need the afilms.csv file from the course website. It contains 4 7 - ish fictitious records that you will use to populate your
You will need the afilms.csv file from the course website. It contains ish fictitious records that you will use to populate your table. You need to do things to make this program work. Create an sqlite database with the exact name of movies.db and create a table within that database with the exact name of afilms, and the exact same column names and datatypes, then take the afilms.csv CSV file given in the same folder as this document and import that data into the table. Write a program that reads the data from the table and inserts it into a wxListCtrl. The program also uses a dialog box to allow adding new records to the table. Please do not use an editable list control. It is more trouble than it is worth for this exercise. The regular list control will do The simpler, the better. For me to run and grade your program using my database, our two database names need to have the same name, including the file extension, and the table must have exact same column names, and the same column data types. So please follow the given instructions carefully. The table holds fake data for movies that have a title beginning with the letter A Database name: movies.db Table name: afilms Column names: filmid title, releaseyear, language, rentalrate, length, rating. The filmid should be an auto incrementing integer primary key. Here's what you need to create the table. Columns and data types filmid: autoincrementing primary key title: text releaseyear: integer language: integer rentalrate: double length: integer rating: text
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
