Function createDatabaseAndConfigure

scripts/setup.ts:104–184

()

// Function to create database and update wrangler.toml
async function createDatabaseAndConfigure() {
    intro(`Let's set up your database...`);
    const defaultDBName = `${path.basename(process.cwd())}-db`;
    dbName = await prompt("Enter the name of your database", defaultDBName);

    let databaseID: string;

    const wranglerTomlPath = path.join(__dirname, "..", "wrangler.toml");
    let wranglerToml: toml.JsonMap;

    try {
        const wranglerTomlContent = fs.readFileSync(wranglerTomlPath, "utf-8");
        wranglerToml = toml.parse(wranglerTomlContent);
    } catch (error) {
        console.error("\x1b[31mError reading wrangler.toml:", error, "\x1b[0m");
        cancel("Operation cancelled.");
    }

    // Run command to create a new database
    const creationOutput = executeCommand(`bunx wrangler d1 create ${dbName}`);

    if (creationOutput === undefined || typeof creationOutput !== "string") {
        console.log(
            "\x1b[33mDatabase creation failed, maybe you have already created a database with that name. I'll try to find the database ID for you.\x1b[0m",
        );
        const dbInfoOutput = executeCommand(`bunx wrangler d1 info ${dbName}`);
        const getInfo = (dbInfoOutput as string).match(
            /│ [0-9a-f]{8}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{4}-[0-9a-f]{12} │/i,
        );
        if (getInfo && getInfo.length === 1) {
            console.log(
                "\x1b[33mFound it! The database ID is: ",
                getInfo[0],
                "\x1b[0m",
            );
            databaseID = getInfo[0].replace("│ ", "").replace(" │", "");
        } else {
            console.error(
                "\x1b[31mSomething went wrong when initialising the database. Please try again.\x1b[0m",
            );
            cancel("Operation cancelled.");
        }
    } else {
        // Extract database ID from the output
        const matchResult = (creationOutput as string).match(
            /database_id = "(.*)"/,
        );
        if (matchResult && matchResult.length === 2 && matchResult !== undefined) {
            databaseID = matchResult[1]!;
        } else {
            console.error("Failed to extract database ID from the output.");
            cancel("Operation cancelled.");
        }
    }

    // Update wrangler.toml with database configuration
    wranglerToml = {
        ...wranglerToml!,