pnpm db:seed is giving me a duplicate key value error of users_email_unique.

[TommyJackson85]

pnpm db:seed is giving me a duplicate key value error of users_email_unique. Any suggestions on what to change in the functions?

Seed process failed: PostgresError: duplicate key value violates unique constraint "users_email_unique" at ErrorResponse (/Users/thomasjackson/Desktop/venginez-templates/next-saas-starter/node_modules/.pnpm/[email protected]/node_modules/postgres/cjs/src/connection.js:788:26) at handle (/Users/thomasjackson/Desktop/venginez-templates/next-saas-starter/node_modules/.pnpm/[email protected]/node_modules/postgres/cjs/src/connection.js:474:6) at TLSSocket.data (/Users/thomasjackson/Desktop/venginez-templates/next-saas-starter/node_modules/.pnpm/[email protected]/node_modules/postgres/cjs/src/connection.js:315:9) at TLSSocket.emit (node:events:518:28) at addChunk (node:internal/streams/readable:559:12) at readableAddChunkPushByteMode (node:internal/streams/readable:510:3) at Readable.push (node:internal/streams/readable:390:5) at TLSWrap.onStreamRead (node:internal/stream_base_commons:190:23) { severity_local: 'ERROR', severity: 'ERROR', code: '23505', detail: 'Key (email)=([email protected]) already exists.', schema_name: 'public', table_name: 'users', constraint_name: 'users_email_unique', file: 'nbtinsert.c', line: '666', routine: '_bt_check_unique'

[leerob]

Have you already ran the script? You could use db:studio to view the contents and then delete that user.

[TommyJackson85]

ill try db studio

[TommyJackson85]

I just checked and theres one user of [email protected] email. so I don't see why there's an issue with it. i am afraid to delete it because I want to use that user for testing in general.
In an attempt to delete it too I am getting this error
'update or delete on table "users" violates foreign key constraint "activity_logs_user_id_users_id_fk" on table "activity_logs"'
and its asking me to report it drizzle studios github.

[TommyJackson85]

is it possible theres a cookies related issues with this? can I check my database by the terminal to get more accurate info? any help would be great

[sanjomathew09]

const postgres = require('postgres'); // Ensure this is your Postgres library

const sql = postgres(process.env.DATABASE_URL);

async function seedUsers() {
try {
const email = '[email protected]';

// Check if the user already exists
const existingUser = await sql`
  SELECT * FROM users WHERE email = ${email};
`;

if (existingUser.length === 0) {
  // Insert user only if it doesn't exist
  await sql`
    INSERT INTO users (email, name, password) 
    VALUES (${email}, 'Test User', 'hashedpassword');
  `;
  console.log('User seeded successfully');
} else {
  console.log(`User with email ${email} already exists. Skipping...`);
}

} catch (error) {
console.error('Error seeding users:', error);
} finally {
sql.end(); // Close the connection
}
}

seedUsers();