ETHIOCODE · LESSON 22 · PRISMA ORM

DATABASE ORM · TYPE-SAFE · NEXT-GEN

Prisma ORM 🗄️ Database Magic! Type-Safe · Auto-Complete · Schema-First · Multi-Database

Database ን ቀላሉን አስተዳድር! TypeScript-safe queries, auto-migrations! 🔥
The modern database toolkit — auto-complete queries, type safety, and beautiful schema DSL!

🐉 Mouse ን ዘዋወር dragon ን ምራ · Click ለ fire!

Created by @AppMinds_ET

01🗄️

Prisma ምንድን ነው?// Next-Gen ORM

Prisma = TypeScript-safe Database ORM! Mongoose ን ያሻላቸዋል — MySQL, PostgreSQL, SQLite, MongoDB ሁሉ ይሰራሉ! Auto-complete, validation, migrations ሁሉ built-in!
Prisma is a next-gen ORM for Node.js and TypeScript — auto-complete, type safety, and a beautiful schema language!

🍃 Mongoose (ክፍል 16)

// No TypeScript!
const schema = new Schema({ name: String });
await User.find({});

❌ TypeScript safety የለም
❌ MongoDB only

✨ Prisma (ክፍል 22)

// Full TypeScript!
model User { id Int @id; name String }
await prisma.user.findMany();

✅ Full TypeScript!
✅ MySQL/PostgreSQL/SQLite/MongoDB

02📐

Prisma Schema// schema.prisma file

schema.prisma = ዋናው file! Models, fields, relations, types ሁሉ ይፃፋሉ! npx prisma migrate dev → Database tables ይፈጥራሃል!
Define your data model once — Prisma generates TypeScript types and SQL migrations automatically!

schema.prisma

model User {
  id        Int      @id @default(autoincrement())
  name      String
  email     String   @unique
  role      Role     @default(USER)
  posts     Post[]
  createdAt DateTime @default(now())
}

model Post {
  id       Int     @id @default(autoincrement())
  title    String
  content  String?          // ? = optional
  author   User    @relation(fields:[authorId], references:[id])
  authorId Int
}

enum Role { USER; ADMIN }

03⚡

CRUD Operations// prisma.model.method()

Prisma ሙሉ CRUD — Auto-complete ጋር!

CRUD	METHOD	ምሳሌ	ትርጉም
CREATE	prisma.user.create()	{ data:{name,email} }	አዲስ user
READ	prisma.user.findMany()	{ where:{role:"ADMIN"} }	ሁሉም users
READ 1	prisma.user.findUnique()	{ where:{id:1} }	አንዱን user
UPDATE	prisma.user.update()	{ where:{id}, data:{name} }	ቀይር
DELETE	prisma.user.delete()	{ where:{id:1} }	ሰርዝ

prisma-crud.ts

const prisma = new PrismaClient();

// CREATE
await prisma.user.create({ data: { name: 'Abel', email: 'abel@x.com' } });

// READ + filter + sort + limit
await prisma.user.findMany({
  where:   { role: 'ADMIN' },
  orderBy: { createdAt: 'desc' },
  take: 10,
});

// READ with relation (include posts!)
await prisma.user.findUnique({
  where:   { id: 1 },
  include: { posts: true },
});

// UPDATE
await prisma.user.update({ where: { id: 1 }, data: { name: 'Abel T.' } });

// DELETE
await prisma.user.delete({ where: { id: 1 } });

04🎮

Live Prisma Demo!// Query Simulator

Prisma Query Simulator! Users ፍጠር፣ query ሞክር፣ relations ይመልከት! Dragon ን አዝዝ background ላይ! 🐉
Simulate Prisma queries — create users, run queries, view relations!

prisma.user

3 records

👥 Users DB

⚡ Queries

🔗 Relations

Quick queries:

← Query ምረጥ

User → Posts Relations
include:{posts:true} → User ን Posts ጋር አብሮ አምጣ!

05📌

ዋና ዋና ነጥቦች// Key Takeaways

🗄️ Prisma = Next-Gen TypeScript ORM

Mongoose ን ያሻላቸዋል — TypeScript-safe, auto-complete, MySQL/PostgreSQL/SQLite ሁሉ!
Works with multiple databases and provides full type safety.

📐 schema.prisma — Single Source of Truth

model User { id Int @id name String email String @unique }
Define once — Prisma generates TypeScript types and SQL migrations!

⚡ Type-Safe CRUD Queries

prisma.user.findMany({ where:{role:'ADMIN'} }) — auto-complete!
IntelliSense and type errors for wrong queries at compile time!

🔗 Relations — include ቀላሉ!

prisma.user.findUnique({ include:{posts:true} }) — User + Posts!
Relations handled automatically — no manual JOINs needed!

🖥️ Prisma Studio — GUI!

npx prisma studio → localhost:5555 → Browser DB viewer! ምንም code አያስፈልግም!
Visual database browser — view and edit records without writing queries!

06🎯

Quiz

❓ Prisma ውስጥ User model ን Post model ጋር ለማያያዝ ምን ትጠቀማለህ?

How do you fetch a user WITH their posts in one Prisma query?

AUser.populate('posts')

Bprisma.user.findUnique({ include: { posts: true } }) ✅

CJOIN User ON Post.userId

Dprisma.user.with('posts')

🗄️ ክፍል 22 — Prisma!

Excellent! Prisma Database ORM ተማርን! 🎉🐉

ቀጣይ: GraphQL API 🔮

🌐 ethiocodesoftselect.netlify.app

✈ @EthioCodeSoftSelect

ቻናሉን ክፈቱ → Join 🚀

✍️ Created by@AppMinds_ET