codegen.js

import { Sequelize, DataTypes, Model } from 'sequelize';
import { Community } from "./database/tables.js";

const sequelize = new Sequelize('database', 'username', 'password', {
  dialect: 'sqlite',
  storage: 'database/db.sqlite',
  logging: false
});

class Code extends Model {}
Code.init({
  value: {
    type: DataTypes.STRING,
    allowNull: false,
    unique: true
  },
  expires_at: DataTypes.DATE
}, {
  sequelize,
  modelName: 'code'
});

async function gen() {
  try {
    await sequelize.sync({ alter: true });
  } catch (syncErr) {
    console.error('Failed to sync DB schema:', syncErr);
  }
  const code = `MLNK-${Math.random().toString(36).slice(2, 10).toUpperCase()}-${Math.random().toString(36).slice(2, 10).toUpperCase()}`;
  try {
    await Code.create({ value: code, expires_at: new Date(Date.now() + 1000 * 60 * 60 * 24 * 7) });
    console.log('Created code:', code);
  } catch (e) {
    if (e.name === 'SequelizeUniqueConstraintError') {
      console.log('Code collision, try again');
    } else {
      console.error('Failed to create code:', e);
      Deno.exit(1);
    }
  }
  const all = await Code.findAll({ order: [['createdAt', 'DESC']] });
  console.log('All codes:\n', all.map(c => ({ id: c.id, value: c.value, expires_at: c.expires_at })).slice(0, 50));
}

if (import.meta.main) {
  // when run as a standalone script, run gen() and then close the DB connection
  (async () => {
    await gen();
    try { await sequelize.close(); } catch (e) { console.error('Error closing sequelize:', e); }
  })();
}

export { gen };