33 lines
974 B
PHP
33 lines
974 B
PHP
#!/usr/bin/env php
|
||
<?php
|
||
declare(strict_types=1);
|
||
|
||
/**
|
||
|
||
title=测试 upgradeModel->addAdminInviteField();
|
||
cid=19495
|
||
|
||
- 修改后，im_chart表中存在adminInvite字段 @adminInvite
|
||
|
||
**/
|
||
|
||
include dirname(__FILE__, 5) . '/test/lib/init.php';
|
||
include dirname(__FILE__, 2) . '/lib/model.class.php';
|
||
|
||
$upgrade = new upgradeModelTest();
|
||
|
||
$checkExistSql = "show columns from `%s` like '%s'";
|
||
$dropSql = "Alter table `%s` drop column `%s`";
|
||
|
||
global $config, $tester;
|
||
$table = $config->db->prefix . 'im_chat';
|
||
$column = 'adminInvite';
|
||
|
||
$result = $tester->dbh->query(sprintf($checkExistSql, $table, $column))->fetch();
|
||
if($result) $deleteAction = $tester->dbh->exec(sprintf($dropSql, $table, $column)); //检测到adminInvite字段存在，删除该字段
|
||
|
||
$upgrade->addAdminInviteField();
|
||
$result2 = $tester->dbh->query(sprintf($checkExistSql, $table, $column))->fetch();
|
||
|
||
r($result2) && p('Field') && e('adminInvite'); //修改后，im_chart表中存在adminInvite字段
|