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字段
|