pg_normalized_batch failing test cases about cmc-csci143 HOT 1 CLOSED

The important line of the error message is

psycopg2.errors.UndefinedColumn: column "url" of relation "users" does not exist
LINE 1: ...NSERT INTO users (id_users,created_at,screen_name,url,listed...

Here, we can see that your python code is inserting into a url column of the users table, but the sql schema I provided you does not contain a url column. I believe when I completed the twitter_postgres assignment I renamed the column to urls (with an s) instead of url. (In retrospect, I'm not sure why. url is a better name for the column than urls because there is only one url being stored in the column. But software projects have a way of building up lots of small inconsistencies like this, and part of being a good engineer is learning how to live with these minor bugs.)

To fix your problem, you could either:

1. Modify your python code to use the urls column to be compatible with the schema, or
2. Modify the schema to use the url column to be compatible with the python.

It won't matter which method you pick.

from cmc-csci143.