Skip to content

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

it("should connect and execute query", async () => {
  await using container = await new MariaDbContainer(IMAGE).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();
});
it("should work with database URI", async () => {
  const username = "testUser";
  const password = "testPassword";
  const database = "testDB";

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

  // Test root user
  await using rootContainer = await new MariaDbContainer(IMAGE)
    .withRootPassword(password)
    .withDatabase(database)
    .start();
  expect(rootContainer.getConnectionUri(true)).toEqual(
    `mariadb://root:${password}@${rootContainer.getHost()}:${rootContainer.getPort()}/${database}`
  );
});
it("should set username", async () => {
  await using container = await new MariaDbContainer(IMAGE).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();
});
it("should create a table, insert a row, and fetch that row", async () => {
  await using container = await new MariaDbContainer(IMAGE).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();
});