Musical Theatre

**What You'll Build** A fully working Employee Management REST API with: * **CRUD endpoints** (POST, GET, PATCH, DELETE /employees) * **Pagination**, sorting, and filtering on the list endpoint * **Strong runtime validation** via *zod* * A typed, schema-first database layer via *Drizzle ORM* * **Environment-aware configuration** (development / production) * A multi-database PostgreSQL setup orchestrated via *Docker Compose* * A seed script to populate sample data * A **REST Client** app.http file to exercise every endpoint **What You'll Learn** By the end of this workshop you'll be able to: * Scaffold a NestJS application from scratch with `@nestjs/cli`. * Containerize a Node.js API using a multi-stage Dockerfile and *Docker Compose*. * Run PostgreSQL in Docker with auto-created databases via init scripts. * Load environment variables dynamically from `.env.${NODE_ENV}` files. * Wire up *Drizzle ORM* as a global NestJS module with proper lifecycle hooks. * Define a database schema in TypeScript and generate SQL migrations. * Validate request bodies and query params with *zod* using custom decorators (no class-validator). * Implement pagination, sorting, and filtering the right way. * Translate database errors (e.g. unique_violation) into proper HTTP responses (**409 Conflict**). * Write a seed script that works across environments. * Test the API end-to-end using the **VS Code REST Client**. **Prerequisites** Please install before the event: * Node.js : ≥ 22 [Download here](https://nodejs.org) * pnpm: ≥ 9 * `corepack enable && corepack prepare pnpm@latest --activate` * Docker Engine: ≥ 20.10 (With the Compose v2 plugin, `docker compose`, not `docker-compose`) * Git: latest [Download here](https://git-scm.com) * VS Code: latest [Download here](https://code.visualstudio.com) * VS Code extensions: * REST Client, ESLint, Prettier A working internet connection is required to download Docker images and npm packages.

**What You'll Build** A fully working Employee Management REST API with: * **CRUD endpoints** (POST, GET, PATCH, DELETE /employees) * **Pagination**, sorting, and filtering on the list endpoint * **Strong runtime validation** via *zod* * A typed, schema-first database layer via *Drizzle ORM* * **Environment-aware configuration** (development / production) * A multi-database PostgreSQL setup orchestrated via *Docker Compose* * A seed script to populate sample data * A **REST Client** app.http file to exercise every endpoint **What You'll Learn** By the end of this workshop you'll be able to: * Scaffold a NestJS application from scratch with `@nestjs/cli`. * Containerize a Node.js API using a multi-stage Dockerfile and *Docker Compose*. * Run PostgreSQL in Docker with auto-created databases via init scripts. * Load environment variables dynamically from `.env.${NODE_ENV}` files. * Wire up *Drizzle ORM* as a global NestJS module with proper lifecycle hooks. * Define a database schema in TypeScript and generate SQL migrations. * Validate request bodies and query params with *zod* using custom decorators (no class-validator). * Implement pagination, sorting, and filtering the right way. * Translate database errors (e.g. unique_violation) into proper HTTP responses (**409 Conflict**). * Write a seed script that works across environments. * Test the API end-to-end using the **VS Code REST Client**. **Prerequisites** Please install before the event: * Node.js : ≥ 22 [Download here](https://nodejs.org) * pnpm: ≥ 9 * `corepack enable && corepack prepare pnpm@latest --activate` * Docker Engine: ≥ 20.10 (With the Compose v2 plugin, `docker compose`, not `docker-compose`) * Git: latest [Download here](https://git-scm.com) * VS Code: latest [Download here](https://code.visualstudio.com) * VS Code extensions: * REST Client, ESLint, Prettier A working internet connection is required to download Docker images and npm packages.

**Tickets are on Sale now $22.00 curtainplayers.org** **please list your seat number in comments . Purchase in E .We also will meet for lunch if interested which is posted separately 😊**

Join us as we get together to see Paul Rudd in the latest comedy-drama-musical from John Carney, POWER BALLAD! The film follows a washed-up wedding singer, a fading boy band singer and a stolen hit song. Here’s a description, trailer and plan for this event: DESCRIPTION: Rick, a washed-up wedding singer, and Danny, a fading boy band star, bond over music and a late-night jam session. When Danny turns Rick's song into a hit, Rick sets out to reclaim the recognition he believes he deserves. Power Ballad is written/directed by John Carney, the master of the modern musical and creative mind behind Once, Begin Again and Sing Street! It stars Paul Rudd, Nick Jonas, Peter McDonald, Marcella Plunkett, Havana Rose Liu and Jack Reynor. BUZZ & ACCLAIM: The film premiered to rave reviews at this year’s Dublin International Film Festival where critics call it “a sure-fired crowd-pleaser” that “just might be the feel-good hit of the year!” Others say, “Paul Rudd delivers a career-best performance in this charmer” that’s both “hilarious and deeply moving!” SUMMER OF ICE CREAM, VOL 2: SHAKE NO. 8! Ranked the #1 Ice Cream Shop in Columbus in 2024, this is the perfect place to kick off our Summer of Ice Cream and grab a sweet treat after the show! Their menu features an array of traditional, specialty and vegan shakes, hot cocoa, and more! You can check out their full menu here: [https://www.shakeno8.com/menu.php](https://www.shakeno8.com/menu.php) PLAN: We’ll plan for a 7pm-ish showing and will meet in the lobby area about 20 minutes before the show. Once showtime is announced, advance ticket purchase is advised! Once you have yours, please list your seat number in the Comments section of this event. We'll head to nearby Shake No. 8 immediately following the show! Should be a fun one, Dan