NoEgo Framework

Page 2 of 2

None

Seeding Data

Proper also supports database seeding for test data or initial configuration. Add seed configuration to your proper.json:

proper.json

{
  "database": "sqlite",
  "sqlite": {
    "database": "./data/app.sqlite"
  },
  "migration_folder": "migrations",
  "migration_table": "proper_migrations",
  "seed": {
    "folder": "seeds",
    "table": "proper_seeds"
  }
}

Seed Files

Seed files follow the same up/down pattern as migrations:

seeds/001_sample_users.up.sql

-- seeds/001_sample_users.up.sql
INSERT INTO users (email, password_hash) VALUES
  ('admin@example.com', '$2b$10$...'),
  ('user@example.com', '$2b$10$...');

seeds/001_sample_users.down.sql

-- seeds/001_sample_users.down.sql
DELETE FROM users WHERE email IN ('admin@example.com', 'user@example.com');

Apply Seeds

terminal

npx proper seed up

Rollback Seeds

terminal

npx proper seed down

Command Reference

Command	Description
npx proper create <name>	Create a new migration with the given name
npx proper up	Apply all pending migrations
npx proper down	Rollback the last applied migration
npx proper reset	Rollback all migrations and reapply them
npx proper status	Show migration status and pending migrations
npx proper seed up	Run all pending seed files
npx proper seed down	Rollback the last applied seed

Typical Workflow

Create a migration

npx proper create add_posts_table

Write the up and down SQL

Edit the generated .up.sql and .down.sql files

Apply the migration

npx proper up

Verify with status

npx proper status

Commit the migration files

Add migration files to version control

Page 2 of 2

Migrations

None

Back to Documentation Hub