use CodeIgniter\CLI\BaseCommand;
use CodeIgniter\CLI\CLI;
use CodeIgniter\Database\RawSql;
class TestIntForge extends BaseCommand
{
protected $group = 'Test';
protected $name = 'test:forgeint';
protected $description = '';
protected $usage = 'test:forgeint';
public function run(array $params)
{
$forge = \Config\Database::forge('test_');
for ($i=3;$i>-5;--$i) {
CLI::write("Testing ".$i.': ');
$forge->addField([
'id' => ['type' => 'BIGINT', 'constraint' => '20' , 'unsigned' => true , 'auto_increment' => true , 'null' => false ],
'test_int' => ['type' => 'INT', 'constraint' => '11' , 'unsigned' => true , 'null' => false, 'default' => new RawSql($i) ],
]);
$forge->addKey('id', true);
if ($forge->createTable('test_'.$i, true)) {
$forge->dropTable('test_'.$i);
CLI::write(CLI::color('PASS', 'green'));
}
else {
CLI::write(CLI::color('FAILED', 'red'));
}
}
}
}