Homework 1

Due: Thursday Jan 22, 23:59pm.

This homework consists in building a for-sale listing site in web2py. This is a little bit more complex than the bulletin board we have been building as a class example, but not all that much. A good approach consists in using the bulletin board code as a starting point, and add to it / modify it as necessary.

What it must do

The for-sale site must allow (logged in) users to add listings. These listings should contain at least the following information:

• Seller name and contact info (email / phone / ...)
• A date posted
• A title for the listing
• A body for the listing
• If they wish, an image.
• A category, one of: Car, Bike, Books, Music, Outdoors, For the house, Misc.
• A price.
• Whether the item is sold or still available.

Users should be able to:

• Add an item while logged in.
• View all items.

The default view should return all items. The SQLFORM.grid will let users sort them according to date posted, price, select for category, etc.

Advice / Resources

Storing data

Uploading images. Allowing users to upload images is very easy to do; read this example.

Whether an item is sold: Use a 'boolean' field type, with default False.

Price: Use a 'double' field type. Use db.forsale.price.requires = IS_FLOAT_IN_RANGE(0, 100000.0, error_message='The price should be in the range 0..100000') validator.

Contact information: This must include an email, and a phone number. Please use the validators for email and phone numbers, as described here. For email, there is a validator IS_EMAIL ready for use. For phone numbers, you can use the IS_MATCH validator defining an appropriate regular expression.

Category: Use a validator like db.forsale.category.requires = IS_IN_SET("Car", "Bike", ...) as described here.

Display / data access

Displaying the list of items, and adding items can be added using SQLFORM.grid, which is described here.

SQLFORM.grid can also be used to let users add items for sale.

Submission instructions

1. Make sure that your main controller is located at default/index .
2. Go to the main web2py screen, where you manage all applications, and select Pack All for your application.
3. Save the resulting file, which has a .w2p extension.
4. Go to this CrowdGrader assignment. Note: You will need to be logged in with your @ucsc.edu account to be able to log in.
5. Click on the Submit link at the top left.
6. Attach the .web2py you saved in step 3.
7. Add any comments, if you wish, by clicking on Edit Content. Be sure to specify any information that a user should be aware of.
8. That's it.

If you cannot login, it is most likely because you are trying to access CrowdGrader using some other account (e.g. a @gmail.com account). Select login with another account.

Review instructions

As part of this assignment, I am asking you to review 4 other submissions by next Wednesday. A detailed grading rubric is available on CrowdGrader. Go to the assignment URL to do the reviews.