import Npm from "@mdx/Npm.astro"; import AnchorCards from "@mdx/AnchorCards.astro"; import Callout from "@mdx/Callout.astro"; import CodeTabs from "@mdx/CodeTabs.astro"; import CodeTab from "@mdx/CodeTab.astro"; import IsSupportedChipGroup from "@mdx/IsSupportedChipGroup.astro"; import Section from "@mdx/Section.astro"; import Tabs from "@mdx/Tabs.astro"; import Tab from "@mdx/Tab.astro"; import SimpleLinkCards from "@mdx/SimpleLinkCards.astro"; import Steps from "@mdx/Steps.astro"; import YoutubeCards from "@mdx/YoutubeCards.astro"; ## Npm drizzle-orm drizzle-orm -D drizzle-kit ## AnchorCards ## Callout Callout example Callout example Callout example Callout example Callout example ## CodeTabs with CodeTab ```typescript copy /schema/3 import * as schema from './schema'; import { drizzle } from 'drizzle-orm/...'; const db = drizzle(client, { schema }); const result = await db.query.users.findMany({ with: { posts: true }, }); ``` ```ts [{ id: 10, name: "Dan", posts: [ { id: 1, content: "SQL is awesome", authorId: 10, }, { id: 2, content: "But check relational queries", authorId: 10, } ] }] ``` ```typescript copy import { integer, serial, text, pgTable } from 'drizzle-orm/pg-core'; import { relations } from 'drizzle-orm'; export const users = pgTable('users', { id: serial('id').primaryKey(), name: text('name').notNull(), }); export const usersRelations = relations(users, ({ many }) => ({ posts: many(posts), })); export const posts = pgTable('posts', { id: serial('id').primaryKey(), content: text('content').notNull(), authorId: integer('author_id').notNull(), }); export const postsRelations = relations(posts, ({ one }) => ({ author: one(users, { fields: [posts.authorId], references: [users.id] }), })); ``` ## IsSupportedChipGroup ## Section For codeblocks connection

```typescript import { sql } from "drizzle-orm"; import { integer, sqliteTable } from "drizzle-orm/sqlite-core"; const table = sqliteTable('table', { int1: integer('int1').default(42), int2: integer('int2').default(sql`(abs(42))`) }); ``` ```sql CREATE TABLE `table` ( `int1` integer DEFAULT 42, `int2` integer DEFAULT (abs(42)) ); ```

## Tabs with Tab and Section

```typescript import { sql } from "drizzle-orm"; import { integer, uuid, pgTable } from "drizzle-orm/pg-core"; const table = pgTable('table', { integer1: integer('integer1').default(42), integer2: integer('integer2').default(sql`'42'::integer`), uuid1: uuid('uuid1').defaultRandom(), uuid2: uuid('uuid2').default(sql`gen_random_uuid()`), }); ``` ```sql CREATE TABLE IF NOT EXISTS "table" ( "integer1" integer DEFAULT 42, "integer2" integer DEFAULT '42'::integer, "uuid1" uuid DEFAULT gen_random_uuid(), "uuid2" uuid DEFAULT gen_random_uuid() ); ```

```typescript import { sql } from "drizzle-orm"; import { int, time, mysqlTable } from "drizzle-orm/mysql-core"; const table = mysqlTable("table", { int: int("int").default(42), time: time("time").default(sql`cast("14:06:10" AS TIME)`), }); ``` ```sql CREATE TABLE `table` ( `int` int DEFAULT 42, `time` time DEFAULT cast("14:06:10" AS TIME) ); ```

## SimpleLinkCards ## Steps With h4 headers #### Install babel plugin It's necessary to bundle SQL migration files as string directly to your bundle. ```shell npm install babel-plugin-inline-import ``` #### Update config files. You will need to update `babel.config.js`, `metro.config.js` and `drizzle.config.ts` files ```js filename='babel.config.js' module.exports = function (api) { api.cache(true); return { presets: ["babel-preset-expo"], plugins: [["inline-import", { extensions: [".sql"] }]], // <-- add this }; }; ``` ## YoutubeCards ## Collapsable code block ```prisma copy filename="prisma/schema.prisma" collapsable generator client { provider = "prisma-client-js" } datasource db { provider = "postgresql" url = env("DATABASE_URL") } model Product { id Int @id @default(autoincrement()) name String supplierId Int unitPrice Decimal @db.Decimal(10, 4) unitsInStock Int supplier Supplier? @relation(fields: [supplierId], references: [id]) orderDetails OrderDetail[] @@map("products") } model Supplier { id Int @id @default(autoincrement()) companyName String city String country String products Product[] @@map("suppliers") } model OrderDetail { orderId Int productId Int quantity Int order Order @relation(fields: [orderId], references: [id]) product Product @relation(fields: [productId], references: [id]) @@id([orderId, productId]) @@map("order_details") } model Order { id Int @id @default(autoincrement()) orderDate DateTime @db.Date shippedDate DateTime? @db.Date shipAddress String shipPostalCode String? shipCountry String orderDetails OrderDetail[] @@map("orders") } ```

components