use BadMethodCallException;
use Friendica\Database\DBA;
use Friendica\Database\DBStructure;
+use Friendica\DI;
class QuestionOption
{
throw new BadMethodCallException('Empty URI_id');
}
- $fields = DBStructure::getFieldsForTable('post-question-option', $data);
+ $fields = DI::dbaDefinition()->truncateFieldsForTable('post-question-option', $data);
// Remove the key fields
unset($fields['uri-id']);
return DBA::update('post-question-option', $fields, ['uri-id' => $uri_id, 'id' => $id], $insert_if_missing ? true : []);
}
+
+ /**
+ * Retrieves the question options associated with the provided item ID.
+ *
+ * @param int $uri_id
+ * @return array
+ * @throws \Exception
+ */
+ public static function getByURIId(int $uri_id)
+ {
+ $condition = ['uri-id' => $uri_id];
+
+ return DBA::selectToArray('post-question-option', [], $condition, ['order' => ['id']]);
+ }
}