在Cypress中连接到SQLite数据库的示例数据库

npm init -y
npm install cypress sqlite3

CREATE TABLE users (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  name TEXT,
  email TEXT
);

INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com');
INSERT INTO users (name, email) VALUES ('Jane Smith', 'jane@example.com');

const sqlite3 = require('sqlite3').verbose();

describe('SQLite Database Test', () => {
  let db;

  before(() => {
    // 连接到SQLite数据库
    db = new sqlite3.Database('example.db', sqlite3.OPEN_READONLY);
  });

  it('should retrieve data from the database', (done) => {
    // 执行查询并验证结果
    db.all('SELECT * FROM users', (err, rows) => {
      expect(rows).to.have.lengthOf(2);
      expect(rows[0].name).to.equal('John Doe');
      expect(rows[0].email).to.equal('john@example.com');
      expect(rows[1].name).to.equal('Jane Smith');
      expect(rows[1].email).to.equal('jane@example.com');
      done();
    });
  });

  after(() => {
    // 关闭数据库连接
    db.close();
  });
});

npx cypress run --spec database.spec.js