Data Layer

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