public static function addDataset($dataset)
{
$query = "INSERT INTO Datasets (user_id, dataset_name, description) VALUES \r\n\t\t\t\t(:user_id, :dataset_name, :description)";
try {
if (is_null($dataset) || $dataset->getErrorCount() > 0) {
return $dataset;
}
$db = Database::getDB();
$statement = $db->prepare($query);
$statement->bindValue(':user_id', $dataset->getUserId());
$statement->bindValue(':dataset_name', $dataset->getDatasetName());
$statement->bindValue(':description', $dataset->getDescription());
$statement->execute();
$statement->closeCursor();
$newDatasetId = $db->lastInsertId('dataset_id');
$dataset->setDatasetId($newDatasetId);
$dateCreatedArray = DatasetsDB::getDatasetsValuesBy('dataset_id', $newDatasetId, 'date_created');
$dataset->setDateCreated($dateCreatedArray[0]);
} catch (Exception $e) {
$dataset->setError('dataset_id', 'DATASET_INVALID');
}
return $dataset;
}
