データベース移行 (移行) を使用して Zend Framework でテスト データを生成する方法

{
  "require": {
    "zendframework/zend-db": "^2.12",
    "zf-fr/zf-migrations": "^1.2"
  }
}

composer install

namespace ApplicationMigrations;

use ZfMigrationsLibraryAbstractMigration;

class CreateTestData extends AbstractMigration
{
    public function up()
    {
        $data = [
            ['name' => 'John Doe', 'email' => 'john@example.com'],
            ['name' => 'Jane Doe', 'email' => 'jane@example.com'],
            // 添加更多的测试数据...
        ];

        foreach ($data as $row) {
            $this->insert('users', $row);
        }
    }

    public function down()
    {
        $this->delete('users');
    }
}

return [
    'db' => [
        'driver'   => 'Pdo_Mysql',
        'database' => 'your_database',
        'username' => 'your_username',
        'password' => 'your_password',
    ],
];

vendor/bin/migrations migrations:migrate

vendor/bin/migrations migrations:rollback

use ZendDbTableGatewayTableGateway;

class UserController extends AbstractActionController
{
    public function indexAction()
    {
        // 获取数据库适配器
        $adapter = $this->getServiceLocator()->get('ZendDbAdapterAdapter');

        // 实例化TableGateway
        $tableGateway = new TableGateway('users', $adapter);

        // 查询数据
        $resultSet = $tableGateway->select();

        // 将结果传递给视图
        return new ViewModel(['users' => $resultSet]);
    }
}

foreach ($users as $user) {
    echo $user['name'] . ' - ' . $user['email'];
}