??

Drizzle ORM? TypeScript? ???? ??? ORM???. ???? ?? ???? ??? ???????. MySQL ??????? ?? ????? ?????? ?? ????????? ????? ?? ??? ? ????.

????

Drizzle ORM? PostgreSQL, MySQL, SQLite? ?????. ? ???? MySQL? ??? ??? ??? ?? ???????? ?????.
Drizzle ORM?? ??? ??? ??? ? ????

??

Drizzle ORM? ????? npm?? ???? ???? ???.

npm i drizzle-orm pg dotenv
npm i -D drizzle-kit tsx @types/pg

npm i drizzle-orm pg dotenv - ? ??? Drizzle ORM ???, pg ??? ? dotenv ???? ?????. pg ???? PostgreSQL ??? ????? MySQL ?? SQLite?? ???? ????.

npm i -D drizzle-kit tsx @types/pg - ? ??? Drizzle Kit ???, tsx ??? ? @types/pg ???? ?????. Drizzle ORM? TypeScript? ????? Drizzle Kit ???? ?????.

??

Drizzle ORM? ????? ???? ??? .env ??? ???? ???. ? ???? ?? ??? ????? ???.

DATABASE_URL=your-database-url

your-database-url? ??????? URL? ????. ?? ??, MySQL? ???? ?? URL? ??? ??? ???.

DATABASE_URL=mysql://username:password@localhost:3306/database

drizzle.config.ts ???? drizzle ??? ?????.

import 'dotenv/config';
import { defineConfig } from 'drizzle-kit';

export default defineConfig({
  out: './drizzle',
  schema: './src/db/schema.ts',
  dialect: 'postgresql',
  dbCredentials: {
    url: process.env.DATABASE_URL!,
  },
});

???? ???

??????? ???? ????? Schema.ts?? ??? ???? ???? ???. ? ???? ?? ??? ????? ???.

import { pgTable, unique, integer, varchar } from 'drizzle-orm/pg-core';
import { sql } from 'drizzle-orm';

export const users = pgTable(
  'users',
  {
    id: integer().primaryKey().generatedAlwaysAsIdentity({
      name: 'users_id_seq',
      startWith: 1,
      increment: 1,
      minValue: 1,
      maxValue: 2147483647,
      cache: 1,
    }),
    name: varchar({ length: 255 }).notNull(),
    age: integer().notNull(),
    email: varchar({ length: 255 }).notNull(),
  },
  (table) => {
    return {
      usersEmailUnique: unique('users_email_unique').on(table.email),
    };
  }
);

id, name, age, email? 4? ?? users?? ???? ?????. id ?? ?? ???? ?? ???, ??, ??, ??? ?? ?????.

???????? ??

src/db ????? index.ts ??? ???? ?????? ??? ??????.

import 'dotenv/config';
import { drizzle } from 'drizzle-orm/node-postgres';

const db = drizzle(process.env.DATABASE_URL!);

??? ?? .env ??? DATABASE_URL? ??????. ??????? ???? ?? Drizzle ??? ???? ????.

???? ??

users ???? ???? ????? db ??? insert ???? ???? ???.

import { users } from './schema';

const user = await db.insert(users).values({
  name: 'John Doe',
  age: 30,
  email: '
});

users ???? ??? ???? ???? ?? db ??? insert ???? ???? ????. ??, ??, ??? ??? ??? ??? ? ???? ?????.

???? ??

??? ????? ???? ????? db ???? select ???? ??? ? ????.

npm i drizzle-orm pg dotenv
npm i -D drizzle-kit tsx @types/pg

users ????? ???? ???? ?? db ??? select ???? ???? ????. ??? id ?? ???? ??? ????? ?? where ???? ???? ????.

???? ????

users ???? ???? ??????? db ??? update ???? ???? ???.

DATABASE_URL=your-database-url

users ???? ???? ?????? ?? db ??? ???? ???? ???? ????. age ?? 31? ???? ?? set ???? ????, id ?? ???? ??? ????? ?? where ???? ???? ????.

???? ??

??? ????? ???? ????? db ???? ?? ???? ??? ? ????.

DATABASE_URL=mysql://username:password@localhost:3306/database

users ????? ???? ???? ?? db ??? delete ???? ???? ????. ??? id ?? ???? ??? ????? ?? where ???? ???? ????.

??

Drizzle ORM? ???? ??? TypeScript? ORM???. ???? ?? ???? ??? ???????. ?? MySQL ??????? ?? ????? ?????? ?? ????????? ????? ?? ??? ? ????. Drizzle ORM?? ??? ??? ??? ? ????

?????

? ???? ????? ?????. ??? ???? ????. ???? ??? ???? ???? ??? ??? ???. ???? ??? ?? ????.

? ??? Drizzle ORM ??? ??? ?? ?????. ??? ??? PHP ??? ????? ?? ?? ??? ?????!