MariaDB Module

MariaDB is one of the most popular open source relational databases. It’s made by the original developers of MySQL and guaranteed to stay open source. It is part of most cloud offerings and the default in most Linux distributions.

Install

npm install @testcontainers/mariadb --save-dev

Examples

Connect and execute query:

it("should connect and execute query", async () => {
  const container = await new MariaDbContainer().start();

  const client = await mariadb.createConnection({
    host: container.getHost(),
    port: container.getPort(),
    database: container.getDatabase(),
    user: container.getUsername(),
    password: container.getUserPassword(),
  });

  const rows = await client.query("SELECT 1 as res");
  expect(rows).toEqual([{ res: 1 }]);

  await client.end();
  await container.stop();
});

Connect and execute query using URI:

it("should work with database URI", async () => {
  const username = "testUser";
  const password = "testPassword";
  const database = "testDB";

  // Test non-root user
  const container = await new MariaDbContainer()
    .withUsername(username)
    .withUserPassword(password)
    .withDatabase(database)
    .start();
  expect(container.getConnectionUri()).toEqual(
    `mariadb://${username}:${password}@${container.getHost()}:${container.getPort()}/${database}`
  );
  await container.stop();

  // Test root user
  const rootContainer = await new MariaDbContainer().withRootPassword(password).withDatabase(database).start();
  expect(rootContainer.getConnectionUri(true)).toEqual(
    `mariadb://root:${password}@${rootContainer.getHost()}:${rootContainer.getPort()}/${database}`
  );
  await rootContainer.stop();
});

Set username:

it("should set username", async () => {
  const container = await new MariaDbContainer().withUsername("customUsername").start();

  const client = await mariadb.createConnection({
    host: container.getHost(),
    port: container.getPort(),
    database: container.getDatabase(),
    user: container.getUsername(),
    password: container.getUserPassword(),
  });

  const rows = await client.query("SELECT CURRENT_USER() as res");
  expect(rows).toEqual([{ res: "customUsername@%" }]);

  await client.end();
  await container.stop();
});

Insert & fetch data:

it("should create a table, insert a row, and fetch that row", async () => {
  const container = await new MariaDbContainer().start();

  const client = await mariadb.createConnection({
    host: container.getHost(),
    port: container.getPort(),
    database: container.getDatabase(),
    user: container.getUsername(),
    password: container.getUserPassword(),
  });

  // Create table
  await client.query(`
      CREATE TABLE users (
        id INT AUTO_INCREMENT PRIMARY KEY,
        name VARCHAR(255) NOT NULL,
        email VARCHAR(255) NOT NULL UNIQUE
      );
    `);

  // Insert a row
  const name = "John Doe";
  const email = "[email protected]";
  const insertResult = await client.query("INSERT INTO users (name, email) VALUES (?, ?)", [name, email]);
  expect(insertResult.affectedRows).toBe(1);

  // Fetch the row
  const [user] = await client.query("SELECT id, name, email FROM users WHERE email = ?", [email]);
  expect(user).toEqual({ id: expect.any(Number), name, email });

  await client.end();
  await container.stop();
});