codeceptjs-postgresqlhelper

const { setHeadlessWhen, setWindowSize } = require('@codeceptjs/configure'); setHeadlessWhen(process.env.CI); setWindowSize(1200, 800); exports.config = { tests: './*_test.js', output: './output', helpers: { PostgresqlDBHelper: { require: 'codeceptjs-postgresqlhelper', host: process.env.DB_HOST ?? '127.0.0.1', port: parseInt(process.env.DB_PORT ?? '5432'), user: process.env.DB_USER ?? 'postgres', password: process.env.DB_PASSWORD ?? 'postgres', database: process.env.DB_DATABASE ?? 'testdb', }, // Include another helper if browser interaction is needed, e.g., Playwright // Playwright: { // url: 'http://localhost', // show: true, // browser: 'chromium' // } }, include: {}, bootstrap: async () => { // Optional: run initial setup like creating the database if it doesn't exist // (requires a separate connection for initial DB creation) }, teardown: null, mocha: {}, name: 'codeceptjs-postgresqlhelper-quickstart', plugins: { retryFailedStep: { enabled: true }, screenshotOnFail: { enabled: true } } }; // --- my_db_test.js --- Feature('Database Operations'); Scenario('should create a table, insert data, and verify', async ({ I }) => { const tableName = 'test_users_' + Date.now(); const username = 'john_doe_' + Date.now(); const email = username + '@example.com'; // 1. Create a table await I.runQuery(`CREATE TABLE IF NOT EXISTS ${tableName} (id SERIAL PRIMARY KEY, username VARCHAR(255) UNIQUE, email VARCHAR(255));`); console.log(`Table ${tableName} created or already exists.`); // 2. Insert data await I.runQuery(`INSERT INTO ${tableName} (username, email) VALUES ('${username}', '${email}');`); console.log(`Inserted user ${username}.`); // 3. Verify data insertion const selectResult = await I.runQuery(`SELECT * FROM ${tableName} WHERE username = '${username}';`); I.assert(selectResult.rows.length).equals(1); I.assert(selectResult.rows[0].email).equals(email); console.log(`Verified user ${username} in table.`); // 4. Clean up (optional, but good practice for isolated tests) await I.runQuery(`DROP TABLE ${tableName};`); console.log(`Table ${tableName} dropped.`); });