How to create new user?

[rafaelrodrigosilveira]

How to create new user? I have the installation admin user. But I wanna to create the new user to others peoples. How ti create?

[Tarsenicum]

I suggest some workaround - simple script for adding users and sqlite3 cli for removing:

import db from "../src/db/db";
import { User } from "../src/db/types";
import { parseArgs } from "util";

const { values, positionals } = parseArgs({
  args: Bun.argv,
  options: {
    email: {
      type: 'string',
      short: 'e',
    },
    password: {
      type: 'string',
      short: 'p',
    },
  },
  strict: true,
  allowPositionals: true,
});

const existingUser = db.query("SELECT * FROM users WHERE email = ?").get(values.email);

if (existingUser) {
  console.log(`Email used`);
  process.exit(1);
}

const savedPassword = await Bun.password.hash(values.password);
db.query("INSERT INTO users (email, password) VALUES (?, ?)").run(values.email, savedPassword);

const user = db.query("SELECT * FROM users WHERE email = ?").as(User).get(values.email);

if (!user) {
  console.log("Failed to create user.");
  process.exit(2);
}

console.log("User created");

Put this script to data/add_user.tsx (for example) and execute like: docker compose exec -it convertx bun run "/app/data/add_user.tsx" --email [email protected] --password verySecurePasswordTrustMe

To remove user just use : sqlite3 data/mydb.sqlite 'delete from users where email="[email protected]"'

You can automate it as you like, I'm good with bash.