CIS 530 Data Transformation Project
- Subject Code :
CIS-530
- Country :
United States America
- Write a Python script finddbtableandcolumnnames.py to get the database tables and column names from the database cma-artworks.db. You can hard-coded the file name cma-artworks.db in your script
- Write another Python script extractdata_xxxxxxx.py where xxxxxxx is your CSU ID number to extract the data from the database cma-artworks.db and writes the results in JSON format into a text file artworks.txt. In you script extractdata_xxxxxxx.py, you can hard-coded the table names and column names that you get from your script finddbtableandcolumnnames.py.
- Please run your scripts on the spirit machine