← All projects

Data Layer

Model categories and products with migrations and seeds.

Goal

This snapshot advances Stonequay Market by teaching you to model categories and products with migrations and seeds.

Every numbered folder is a complete app. Run this stage independently, then compare it with the previous folder.

Prerequisites

Use PHP 8.2+, Composer, Node.js 20+, and Docker for MySQL stages.

Port 8005 must be free. Copy .env.example before database stages.

  • PHP and Composer
  • Node.js and npm
  • Docker from part 4 onward

Concepts

Each snapshot uses an isolated stone_NN database so stages stay independent.

Twig escapes output by default; Tailwind styles the storefront; Doctrine owns persistence and voters enforce ownership.

Walkthrough

Migrate Category and Product tables, relate them, and seed Ada, Grace, and a starter catalog.

Read the example, then open the matching snapshot. The repository includes validation, CSRF, and the surrounding structure.

#[ORM\Entity]
class Product {
    #[ORM\ManyToOne] private User $owner;
    #[ORM\Column] private string $slug;
    #[ORM\Column] private int $priceCents;
}

Run and verify

Enter 04-Data-Layer, composer install, copy .env, migrate, seed, build assets, and serve on port 8005.

Open http://127.0.0.1:8005. From data lessons onward, Ada and Grace use password123.

docker compose up -d
git clone https://github.com/michaeldunga1/fcc-symfony-ecommerce.git
cd fcc-symfony-ecommerce/04-Data-Layer
composer install
npm install
cp .env.example .env
php bin/console doctrine:migrations:migrate -n
php bin/console app:seed
npm run build
symfony server:start --port=8005 --no-tls
# or: php -S 0.0.0.0:8005 -t public

Troubleshooting

Connection refused usually means Docker is down or the database name does not match this folder's index.

For database failures, confirm Docker and the stone_NN name. Never commit .env, vendor, or node_modules.

  • Read the first exception first
  • Rebuild assets after Tailwind class changes
  • Never commit secrets

Try this

Add a nullable sku column through a new migration.

Test a happy path and one invalid or unauthorized request.

  • Make one small change
  • Test it in the browser
  • Compare with the next snapshot only after it works

Related tutorials