Generators

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  posts: {  columns: {  content: funcs.default({  // value you want to generate  defaultValue: "post content",   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  posts: {  columns: {  title: funcs.valuesFromArray({  // Array of values you want to generate (can be an array of weighted values)  values: ["Title1", "Title2", "Title3", "Title4", "Title5"],   // Property that controls whether the generated values will be unique or not  isUnique: true,    // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  posts: {  columns: {  id: funcs.intPrimaryKey(),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  products: {  columns: {  unitPrice: funcs.number({  // lower border of range.  minValue: 10,   // upper border of range.  maxValue: 120,    // precision of generated number:  // precision equals 10 means that values will be accurate to one tenth (1.2, 34.6);  // precision equals 100 means that values will be accurate to one hundredth (1.23, 34.67).  precision: 100,   // property that controls if generated values gonna be unique or not.  isUnique: false,   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  products: {  columns: {  unitsInStock: funcs.int({  // lower border of range.  minValue: 0,   // lower border of range.  maxValue: 100,   // property that controls if generated values gonna be unique or not.  isUnique: false,   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  isAvailable: funcs.boolean({  // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  birthDate: funcs.date({  // lower border of range.  minDate: "1990-01-01",   // upper border of range.  maxDate: "2010-12-31",   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  birthTime: funcs.time({  // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  orders: {  columns: {  shippedDate: funcs.timestamp({  // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  orders: {  columns: {  shippedDate: funcs.datetime({  // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  birthYear: funcs.year({  // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

{ email, name, isGraduated, hasJob, salary, startedWorking, visitedCountries}  // or  { email, name, isGraduated, hasJob, visitedCountries }

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  metadata: funcs.json({  // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  timeSpentOnWebsite: funcs.interval({  // `isUnique` - property that controls whether the generated values will be unique or not  isUnique: true,   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  hashedPassword: funcs.string({  // `isUnique` - property that controls whether the generated values will be unique or not  isUnique: false,    // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed"; await seed(db, schema, { count: 1000 }).refine((funcs) => ({  products: {  columns: {  id: funcs.uuid({  // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, }));

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  firstName: funcs.firstName({  // `isUnique` - property that controls whether the generated values will be unique or not  isUnique: true,   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  lastName: funcs.lastName({  // `isUnique` - property that controls whether the generated values will be unique or not  isUnique: false,    // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  fullName: funcs.fullName({  // `isUnique` - property that controls whether the generated values will be unique or not  isUnique: true,   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  email: funcs.email({  // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  //generate phone number using template property await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  phoneNumber: funcs.phoneNumber({   // `template` - phone number template, where all '#' symbols will be substituted with generated digits.  template: "+(380) ###-####",   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  //generate phone number using prefixes and generatedDigitsNumbers properties await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  phoneNumber: funcs.phoneNumber({  // `prefixes` - array of any string you want to be your phone number prefixes.(not compatible with `template` property)  prefixes: ["+380 99", "+380 67"],   // `generatedDigitsNumbers` - number of digits that will be added at the end of prefixes.(not compatible with `template` property)  generatedDigitsNumbers: 7,   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  // generate phone number using prefixes and generatedDigitsNumbers properties but with different generatedDigitsNumbers for prefixes await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  phoneNumber: funcs.phoneNumber({  // `prefixes` - array of any string you want to be your phone number prefixes.(not compatible with `template` property)  prefixes: ["+380 99", "+380 67", "+1"],   // `generatedDigitsNumbers` - number of digits that will be added at the end of prefixes.(not compatible with `template` property)  generatedDigitsNumbers: [7, 7, 10],   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  country: funcs.country({  // `isUnique` - property that controls whether the generated values will be unique or not  isUnique: false,    // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  city: funcs.city({  // `isUnique` - property that controls whether the generated values will be unique or not  isUnique: false,   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  streetAddress: funcs.streetAddress({  // `isUnique` - property that controls whether the generated values will be unique or not  isUnique: false,    // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3   }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  jobTitle: funcs.jobTitle({  // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  postcode: funcs.postcode({  // `isUnique` - property that controls whether the generated values will be unique or not  isUnique: true,   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  state: funcs.state({  // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  users: {  columns: {  company: funcs.companyName({   // `isUnique` - property that controls whether the generated values will be unique or not  isUnique: true,   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  posts: {  columns: {  content: funcs.loremIpsum({  // `sentencesCount` - number of sentences you want to generate as one generated value(string).  sentencesCount: 2,   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  triangles: {  columns: {  pointCoords: funcs.point({  // `isUnique` - property that controls if generated values gonna be unique or not.  isUnique: true,   // `minXValue` - lower bound of range for x coordinate.  minXValue: -5,   // `maxXValue` - upper bound of range for x coordinate.  maxXValue: 20,   // `minYValue` - lower bound of range for y coordinate.  minYValue: 0,   // `maxYValue` - upper bound of range for y coordinate.  maxYValue: 30,   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, })); 

import { seed } from "drizzle-seed";  await seed(db, schema, { count: 1000 }).refine((funcs) => ({  lines: {  columns: {  lineParams: funcs.point({  // `isUnique` - property that controls if generated values gonna be unique or not.  isUnique: true,   // `minAValue` - lower bound of range for a parameter.  minAValue: -5,   // `maxAValue` - upper bound of range for x parameter.  maxAValue: 20,   // `minBValue` - lower bound of range for y parameter.  minBValue: 0,   // `maxBValue` - upper bound of range for y parameter.  maxBValue: 30,   // `minCValue` - lower bound of range for y parameter.  minCValue: 0,   // `maxCValue` - upper bound of range for y parameter.  maxCValue: 10,   // number of elements in each one-dimensional array.   // (If specified, arrays will be generated.)  arraySize: 3  }),  },  }, }));