Tom Sherman Posts - Answer Overflow

Tom Sherman

Explore posts from servers

•Created by Tom Sherman on 7/22/2024 in #help

D1: `drizzle-kit push` says changes applied but database unchanged

Here are the logs:

~/c/u/p/pin (main)> drizzle-kit push
drizzle-kit: v0.23.0
drizzle-orm: v0.31.2

No config path provided, using default path
Reading config file '/home/tom/code/unravel/packages/pin/drizzle.config.ts'
[✓] Pulling schema from database...
[✓] Changes applied

~/c/u/p/pin (main)> drizzle-kit push
drizzle-kit: v0.23.0
drizzle-orm: v0.31.2

No config path provided, using default path
Reading config file '/home/tom/code/unravel/packages/pin/drizzle.config.ts'
[✓] Pulling schema from database...
[✓] Changes applied

here's my config:

import { defineConfig } from "drizzle-kit";
import { config } from "dotenv";

const projectDir = process.cwd();
config({
  path: `${projectDir}/.env`,
});

export default defineConfig({
  schema: "./src/schema.ts",
  out: "./migrations",
  dialect: "sqlite",
  driver: "d1-http",
  dbCredentials: {
    accountId: process.env.CLOUDFLARE_ACCOUNT_ID!,
    databaseId: process.env.CLOUDFLARE_DATABASE_ID!,
    token: process.env.CLOUDFLARE_D1_TOKEN!,
  },
});

import { defineConfig } from "drizzle-kit";
import { config } from "dotenv";

const projectDir = process.cwd();
config({
  path: `${projectDir}/.env`,
});

export default defineConfig({
  schema: "./src/schema.ts",
  out: "./migrations",
  dialect: "sqlite",
  driver: "d1-http",
  dbCredentials: {
    accountId: process.env.CLOUDFLARE_ACCOUNT_ID!,
    databaseId: process.env.CLOUDFLARE_DATABASE_ID!,
    token: process.env.CLOUDFLARE_D1_TOKEN!,
  },
});

The env vars are all set (when they're not set I get an auth error). it says changes applied, but the they're actually not. this is on a fresh and empty database

1 replies

DTDrizzle Team

•Created by Tom Sherman on 7/4/2024 in #help

Map/transform selected column

Is it possible to transform a column value when we define the select? This would be super useful for when sharing a subquery as I could cololcate the transform code with it instead of having a seperate transform function. Something like:

db.select(
  isDeleted: item.deletedAt.map(date => date !== null)
).from(item);

db.select(
  isDeleted: item.deletedAt.map(date => date !== null)
).from(item);

5 replies

Gaming

Programming