/**
* Insert new record.
*
* @param EntityInterface $data
* @return mixed Returns either `FALSE` or {@see \odTimeTracker\Model\ProjectEntity}.
*/
public function insert(EntityInterface $entity)
{
$sql = <<<EOT
INSERT INTO `{$this->tableName}` (`Name`, `Description`, `Created`)
VALUES ( :name , :description , :created )
EOT;
$stmt = $this->pdo->prepare($sql);
$stmt->bindParam(':name', $entity->getName(), \PDO::PARAM_STR);
$stmt->bindParam(':description', $entity->getDescription(), \PDO::PARAM_STR);
$stmt->bindParam(':created', $entity->getCreatedRfc3339(), \PDO::PARAM_STR);
$res = $stmt->execute();
if ($res === false || $stmt->rowCount() !== 1) {
return false;
}
$entity->setProjectId($this->pdo->lastInsertId());
return $entity;
}
