/**
  * 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();
 }
Example #2
0
 public function getItems()
 {
     return $this->hasMany(Item::className(), ['id' => 'item_ids']);
 }