insert() public method

Create a insert statement
public insert ( array $columns = null ) : Insert
$columns array
return Pop\Db\Sql\Insert
Esempio n. 1
0
 /**
  * Write to the log
  *
  * @param  array $logEntry
  * @return Db
  */
 public function writeLog(array $logEntry)
 {
     $columns = [];
     $params = [];
     $i = 1;
     foreach ($logEntry as $column => $value) {
         $placeholder = $this->sql->getPlaceholder();
         if ($placeholder == ':') {
             $placeholder .= $column;
         } else {
             if ($placeholder == '$') {
                 $placeholder .= $i;
             }
         }
         $columns[$column] = $placeholder;
         $params[$column] = $value;
         $i++;
     }
     $this->sql->insert($columns);
     $this->sql->db()->prepare((string) $this->sql)->bindParams($params)->execute();
     return $this;
 }
Esempio n. 2
0
 /**
  * Method to save a value to cache.
  *
  * @param  string $id
  * @param  mixed  $value
  * @param  string $time
  * @return void
  */
 public function save($id, $value, $time)
 {
     $time = time() + (int) $time;
     // Determine if the value already exists.
     $this->sqlite->select()->where()->equalTo('id', ':id');
     $this->sqlite->adapter()->prepare($this->sqlite->render(true))->bindParams(array('id' => sha1($id)))->execute();
     $rows = array();
     while (($row = $this->sqlite->adapter()->fetchResult()) != false) {
         $rows[] = $row;
     }
     // If the value exists, update it.
     if (count($rows) > 0) {
         $this->sqlite->update(array('value' => ':value', 'time' => ':time'))->where()->equalTo('id', ':id');
         $params = array('value' => serialize($value), 'time' => $time, 'id' => sha1($id));
         // Else, save the new value.
     } else {
         $this->sqlite->insert(array('id' => ':id', 'value' => ':value', 'time' => ':time'));
         $params = array('id' => sha1($id), 'value' => serialize($value), 'time' => $time);
     }
     $this->sqlite->adapter()->prepare($this->sqlite->render(true))->bindParams($params)->execute();
 }
Esempio n. 3
0
 /**
  * Write to a custom log
  *
  * @param  string $content
  * @return Db
  */
 public function writeCustomLog($content)
 {
     $fields = ['timestamp' => date('Y-m-d H:i:s'), 'level' => -1, 'name' => 'CUSTOM', 'message' => $content, 'context' => ''];
     $columns = [];
     $params = [];
     $i = 1;
     foreach ($fields as $column => $value) {
         $placeholder = $this->sql->getPlaceholder();
         if ($placeholder == ':') {
             $placeholder .= $column;
         } else {
             if ($placeholder == '$') {
                 $placeholder .= $i;
             }
         }
         $columns[$column] = $placeholder;
         $params[$column] = $value;
         $i++;
     }
     $this->sql->insert($columns);
     $this->sql->db()->prepare((string) $this->sql)->bindParams($params)->execute();
     return $this;
 }
Esempio n. 4
0
 public function testInsertException()
 {
     $this->setExpectedException('Pop\\Db\\Exception');
     $s = new Sql(Db::factory('Sqlite', array('database' => __DIR__ . '/../tmp/test.sqlite')), 'users');
     $s->insert();
 }