/**
* Sets up test rows.
*/
protected function setUpTestRows()
{
$connection = $this->getConnection();
$customers = [];
for ($i = 1; $i <= 5; $i++) {
$customers[] = ['id' => $i, 'name' => 'name' . $i, 'email' => 'email' . $i, 'address' => 'address' . $i, 'status' => $i];
}
$connection->createCommand()->batchInsert(Customer::tableName(), ['id', 'name', 'email', 'address', 'status'], $customers)->execute();
$items = [];
for ($i = 1; $i <= 10; $i++) {
$items[] = ['id' => $i, 'name' => 'name' . $i, 'price' => $i];
}
$connection->createCommand()->batchInsert(Item::tableName(), ['id', 'name', 'price'], $items)->execute();
$customerOrders = [];
foreach ($customers as $i => $customer) {
$customerOrders[] = ['customer_id' => $customer['id'], 'number' => $customer['status'], 'item_ids' => $items[$i]['id']];
$customerOrders[] = ['customer_id' => $customer['id'], 'number' => $customer['status'] + 100, 'item_ids' => $items[$i]['id']];
}
$connection->createCommand()->batchInsert(CustomerOrder::tableName(), ['customer_id', 'number', 'item_ids'], $customerOrders)->execute();
}
public function testNot()
{
$connection = $this->getConnection();
$query = new Query();
$rows = $query->from(Customer::tableName())->where(['not', 'status', ['>=' => 10]])->all($connection);
$this->assertEquals(9, count($rows));
$query = new Query();
$rows = $query->from(Customer::tableName())->where(['not', 'name', 'name1'])->all($connection);
$this->assertEquals(9, count($rows));
}
protected function tearDown()
{
$connection = $this->getConnection();
$connection->createCommand()->truncateTable(Customer::tableName())->execute();
parent::tearDown();
}
