I am a math tutor currently helping middle and high school students master common math concepts, and getting them prepared for the SAT and ACT tests.
I am also a computer programming enthusiast, especially interested in data analytics using Python, SQL and R.
I previously worked in international marketing and product development for Stanley Black & Decker, for more than 25 years.
đź‘‹ Contact me at mario@mariosanchez.org.
My implementation of Commerce, CS50W Project 2
Made with: Python
This app was my implementation of CS50W’s Project 2, which involves Django, SQL, Models and Migrations.
Here are the specs:
Models: Your application should have at least three models in addition to the User model: one for auction listings, one for bids, and one for comments made on auction listings. It’s up to you to decide what fields each model should have, and what the types of those fields should be. You may have additional models if you would like.
Create Listing: Users should be able to visit a page to create a new listing. They should be able to specify a title for the listing, a text-based description, and what the starting bid should be. Users should also optionally be able to provide a URL for an image for the listing and/or a category (e.g. Fashion, Toys, Electronics, Home, etc.).
Active Listings Page: The default route of your web application should let users view all of the currently active auction listings. For each active listing, this page should display (at minimum) the title, description, current price, and photo (if one exists for the listing).
Listing Page: Clicking on a listing should take users to a page specific to that listing. On that page, users should be able to view all details about the listing, including the current price for the listing.
Watchlist: Users who are signed in should be able to visit a Watchlist page, which should display all of the listings that a user has added to their watchlist. Clicking on any of those listings should take the user to that listing’s page.
Categories: Users should be able to visit a page that displays a list of all listing categories. Clicking on the name of any category should take the user to a page that displays all of the active listings in that category.
Django Admin Interface: Via the Django admin interface, a site administrator should be able to view, add, edit, and delete any listings, comments, and bids made on the site.
I’m very proud of the way the project ended up working and looking. This was by far the hardest project I’ve attempted and I’m glad it is now working as expected.
If you want to learn more about this project here are some links:
© 2025 Mario Sanchez Carrion