Trait luya\testsuite\traits\DatabaseTableTrait

All Classes | Methods

Available since version	1.0.21
Source Code	https://github.com/luyadev/luya-testsuite/blob/master/src/traits/DatabaseTableTrait.php

Base Trait for Database Actions.

Public Methods

Hide inherited methods

Method	Description	Defined By
createTableIfNotExists()	Create a table if not exists	luya\testsuite\traits\DatabaseTableTrait
deleteRow()	Delete row	luya\testsuite\traits\DatabaseTableTrait
dropTableIfExists()	Drop a table if not exists.	luya\testsuite\traits\DatabaseTableTrait
getDatabaseComponent()		luya\testsuite\traits\DatabaseTableTrait
insertRow()	Insert row	luya\testsuite\traits\DatabaseTableTrait

Method Details

Hide inherited methods

createTableIfNotExists() public method

Create a table if not exists

public void createTableIfNotExists ( $table, array $columns )
$table	string
$columns	array

Source code

                public function createTableIfNotExists($table, array $columns)
{
    if ($this->getDatabaseComponent()->getTableSchema($table, true) === null) {
        $this->getDatabaseComponent()->createCommand()->createTable($table, $columns)->execute();
    }
}

deleteRow() public method

Delete row

public integer deleteRow ( $table, array $condition )
$table	string
$condition	array
return	integer	Returns the number of rows deleted.

Source code

                public function deleteRow($table, array $condition)
{
    return $this->getDatabaseComponent()->createCommand()->delete($table, $condition)->execute();
}

dropTableIfExists() public method

Drop a table if not exists.

public void dropTableIfExists ( $table )
$table	string

Source code

                public function dropTableIfExists($table)
{
    if ($this->getDatabaseComponent()->getTableSchema($table, true) !== null) {
        $this->getDatabaseComponent()->createCommand()->dropTable($table)->execute();
    }
}

getDatabaseComponent() public method

public yii\db\Connection getDatabaseComponent ( )

Source code

                public function getDatabaseComponent()
{
    return $this->app->db;
}

insertRow() public method

Insert row

public integer insertRow ( $table, array $values )
$table	string
$values	array
return	integer	Returns the number of rows inserted.

Source code

                public function insertRow($table, array $values)
{
    return $this->getDatabaseComponent()->createCommand()->insert($table, $values)->execute();
}