在我的应用程序迁移文件的创建过程中,我注意到Laravel不支持数据库触发器!我已经接受了这样一个事实:我需要执行一个查询语句来实现这一点,但这也给了我麻烦..这是我的应用程序的代码片段:
Schema::create('users', function ($table) {
$table->increments('id');
$table->string('uuid', 36);
$table->string('email', 255);
$table->string('password', 255);
});
DB::statement('CREATE TRIGGER users_trigger_uuid BEFORE INSERT ON users FOR EACH ROW SET NEW.uuid = UUID()');
当我运行artisan migrate时,它给出了以下错误:
[Exception]
SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet (SQL: CREATE TRIGGER users_trigger_uuid BEFORE INSERT ON users FOR EACH ROW SET NEW.uuid = UUID()) (Bindings: array (
))
除了创建自己的PDO对象和在Laravel之外执行查询之外,还有其他解决方案吗?这是MySQL异常还是Laravel异常?
编辑
从例外情况来看,很明显,准备好的陈述不支持触发器的创建……不确定为什么但是会喜欢一些见解.为了解决这个问题,我只运行了自己的PDO查询.
$default_driver = Config::get('database.default');
$connection_info = Config::get('database.connections.' . $default_driver);
$conn = new PDO('mysql:host=' . $connection_info['host'] . ';dbname=' . $connection_info['database'], $connection_info['username'], $connection_info['password']);
$conn->query('CREATE TRIGGER users_trigger_uuid BEFORE INSERT ON ' . $connection_info['prefix'] . 'users FOR EACH ROW SET NEW.uuid = UUID()');