Drizzle ORM - Empty array as a default value

相关文章推荐

帅气的灭火器 · Database re-creation ...· 1 月前 ·

儒雅的甘蔗 · SQLite error no such ...· 1 月前 ·

发财的移动电源 · Urbackup Server ...· 1 月前 ·

聪明伶俐的馒头 · Urbackup Server ...· 1 月前 ·

强悍的毛豆 · Python SQLite - ...· 4 周前 ·

沉稳的生菜 · 健康数据科学_北京大学医学部|医学技术研究院· 10 月前 ·

唠叨的鸵鸟 · 短期衝刺和敏捷開發框架 (Scrum) ...· 11 月前 ·

打篮球的拐杖 · 在Spring ...· 1 年前 ·

稳重的芹菜 · 一键制作 macOS Sequoia U盘 ...· 1 年前 ·

月球上的南瓜 · c#远程调整屏幕亮度 - CSDN文库· 1 年前 ·

System

meet drizzle

Get started Sustainability Why Drizzle? Guides

Tutorials Latest releases Gotchas

Upgrade to v1.0 RC

How to upgrade? Relational Queries v1 to v2

Fundamentals

Schema Relations Database connection Query Data Migrations

Connect

PostgreSQL Gel MySQL SQLite MSSQL CockroachDB SingleStore

PlanetScale Postgres Neon Vercel Postgres Prisma Postgres Supabase Xata PGLite Nile Bun SQL Effect Postgres Netlify Database

PlanetScale MySQL TiDB

Turso Cloud Turso Database SQLite Cloud Cloudflare D1 Bun SQLite Node SQLite Cloudflare Durable Objects

Expo SQLite OP SQLite React Native SQLite

AWS Data API Postgres AWS Data API MySQL

Drizzle Proxy

Manage schema

Data types Indexes & Constraints Sequences Views Schemas Drizzle Relations Row-Level Security (RLS) Extensions

[OLD] Drizzle Relations

Migrations

Overview


                  generate


                  migrate


                  push


                  pull


                  export


                  check

up


                  studio

Custom migrations Migrations for teams Web and mobile drizzle.config.ts

Seeding

Overview Generators Versioning

Access your data

Query Select Insert Update Delete Filters Utils Joins Magic sql`` operator

[OLD] Query V1

Performance

Queries Serverless

Advanced

Set Operations Generated Columns Transactions Batch Cache Dynamic query building Read Replicas Custom types Goodies

Validations

zod valibot typebox arktype typebox-legacy effect-schema

Extensions

Prisma ESLint Plugin drizzle-graphql

Our goodies!

Product by Drizzle Team

One Dollar Stats $1 per mo web analytics

christmas Drizzle | Empty array as a default value

This guide assumes familiarity with:

Get started with PostgreSQL , MySQL and SQLite

Learn about column data types for PostgreSQL , MySQL and SQLite

sql operator

PostgreSQL

To set an empty array as a default value in PostgreSQL, you can use sql operator with '{}' or ARRAY[] syntax:

import { sql } from 'drizzle-orm';
import { pgTable, serial, text } from 'drizzle-orm/pg-core';
export const users = pgTable('users', {
  id: serial('id').primaryKey(),
  name: text('name').notNull(),
  tags1: text('tags1')
    .array()
    .notNull()
    .default(sql`'{}'::text[]`),
  tags2: text('tags2')
    .array()
    .notNull()
    .default(sql`ARRAY[]::text[]`),
});

CREATE TABLE IF NOT EXISTS "users" (
	"id" serial PRIMARY KEY NOT NULL,
	"name" text NOT NULL,
	"tags1" text[] DEFAULT '{}'::text[] NOT NULL,
	"tags2" text[] DEFAULT ARRAY[]::text[] NOT NULL
MySQL
MySQL doesn’t have an array data type, but you can use json data type for the same purpose. To set an empty array as a default value in MySQL, you can use JSON_ARRAY() function or sql operator with ('[]') syntax:
 import { sql } from 'drizzle-orm';
import { json, mysqlTable, serial, varchar } from 'drizzle-orm/mysql-core'




    
;
export const users = mysqlTable('users', {
  id: serial('id').primaryKey(),
  name: varchar('name', { length: 255 }).notNull(),
  tags1: json('tags1').$type<string[]>().notNull().default([]),
  tags2: json('tags2')
    .$type<string[]>()
    .notNull()
    .default(sql`('[]')`), // the same as default([])
  tags3: json('tags3')
    .$type<string[]>()
    .notNull()
    .default(sql`(JSON_ARRAY())`),
});
CREATE TABLE `users` (
	`id` serial AUTO_INCREMENT NOT NULL,
	`name` varchar(255) NOT NULL,
	`tags1` json NOT NULL DEFAULT ('[]'),
	`tags2` json NOT NULL DEFAULT ('[]'),
	`tags3` json NOT NULL DEFAULT (JSON_ARRAY()),
	CONSTRAINT `users_id` PRIMARY KEY(`id`)
The mode option defines how values are handled in the application. With json mode, values are treated as JSON object literal.
You can specify .$type<..>() for json object inference, it will not check runtime values. It provides compile time protection for default values, insert and select schemas.
SQLite
SQLite doesn’t have an array data type, but you can use text data type for the same purpose. To set an empty array as a default value in SQLite, you can use json_array() function or sql operator with '[]' syntax:
 import { sql } from 'drizzle-orm';
import { integer, sqliteTable, text } from 'drizzle-orm/sqlite-core';
export const users = sqliteTable('users', {
  id: integer('id').primaryKey(),
  tags1: text('tags1', { mode: 'json' })
    .notNull()
    .$type<string[]>()
    .default(sql`(json_array())`),
  tags2: text('tags2', { mode: 'json' })
    .notNull()
    .$type<string[]>()
    .default(sql`'[]'`),
});
CREATE TABLE `users` (