private function createTable()
 {
     $this->connection->query("CREATE DATABASE IF NOT EXISTS test");
     $this->connection->query("CREATE TABLE IF NOT EXISTS {$this->tableName} (`name` varchar(255),`value` integer(8)) ENGINE=InnoDB DEFAULT CHARSET=utf8");
     $this->connection->query("TRUNCATE TABLE {$this->tableName}");
 }
Example #2
0
 /**
  * Run a truncate statement on the table.
  *
  * @return void
  */
 public function truncate()
 {
     foreach ($this->grammar->compileTruncate($this) as $sql => $bindings) {
         $this->connection->query($sql, $bindings);
     }
 }