mirror of
https://github.com/Icinga/icingadb-web.git
synced 2026-05-28 04:36:06 -04:00
3c8ed68cc6
This was easy because only README.md and doc/01-About.md were redacted manually, everything else via: git ls-files -z |xargs -0 perl -pi -e 's/Icinga GmbH \| GPLv2/Icinga GmbH | GPLv2+/' This is legal because we have only merged PRs with label:cla/signed or made by Icinga staff: https://github.com/Icinga/icingadb-web/pulls?page=1&q=is%3Apr+is%3Aclosed+-label%3Acla%2Fsigned+-author%3Anilmerg This has no risk for us in people distributing their own version under GPLv3 only. After all, we won't take their patches anyway, unless they sign our CLA. This is the cleanest solution for having e.g. these in one address space: * Icinga Web, GPLv2+ * K8s Web, AGPLv3 * Thirdparty, some LGPLv3 and Apache-2.0 Apropos, K8s Web is even v3-licensed on purpose, to have a stronger protection against cloud ops.
125 lines
3.6 KiB
PHP
125 lines
3.6 KiB
PHP
<?php
|
|
|
|
/* Icinga DB Web | (c) 2020 Icinga GmbH | GPLv2+ */
|
|
|
|
namespace Icinga\Module\Icingadb\Model;
|
|
|
|
use DateTime;
|
|
use ipl\Orm\Behavior\BoolCast;
|
|
use ipl\Orm\Behavior\Binary;
|
|
use ipl\Orm\Behavior\MillisecondTimestamp;
|
|
use ipl\Orm\Behaviors;
|
|
use Icinga\Module\Icingadb\Common\Model;
|
|
use ipl\Orm\Relations;
|
|
|
|
/**
|
|
* Model for table `comment_history`
|
|
*
|
|
* Please note that using this model will fetch history entries for decommissioned services. To avoid this,
|
|
* the query needs a `comment_history.service_id IS NULL OR comment_history_service.id IS NOT NULL` where.
|
|
*
|
|
* @property string $comment_id
|
|
* @property string $environment_id
|
|
* @property ?string $endpoint_id
|
|
* @property string $object_type
|
|
* @property string $host_id
|
|
* @property ?string $service_id
|
|
* @property DateTime $entry_time
|
|
* @property string $author
|
|
* @property ?string $removed_by
|
|
* @property string $comment
|
|
* @property string $entry_type
|
|
* @property bool $is_persistent
|
|
* @property bool $is_sticky
|
|
* @property ?DateTime $expire_time
|
|
* @property ?DateTime $remove_time
|
|
* @property bool $has_been_removed
|
|
*/
|
|
class CommentHistory extends Model
|
|
{
|
|
public function getTableName()
|
|
{
|
|
return 'comment_history';
|
|
}
|
|
|
|
public function getKeyName()
|
|
{
|
|
return 'comment_id';
|
|
}
|
|
|
|
public function getColumns()
|
|
{
|
|
return [
|
|
'environment_id',
|
|
'endpoint_id',
|
|
'object_type',
|
|
'host_id',
|
|
'service_id',
|
|
'entry_time',
|
|
'author',
|
|
'removed_by',
|
|
'comment',
|
|
'entry_type',
|
|
'is_persistent',
|
|
'is_sticky',
|
|
'expire_time',
|
|
'remove_time',
|
|
'has_been_removed'
|
|
];
|
|
}
|
|
|
|
public function getColumnDefinitions()
|
|
{
|
|
return [
|
|
'environment_id' => t('Environment Id'),
|
|
'endpoint_id' => t('Endpoint Id'),
|
|
'object_type' => t('Object Type'),
|
|
'host_id' => t('Host Id'),
|
|
'service_id' => t('Service Id'),
|
|
'entry_time' => t('Comment Entry Time'),
|
|
'author' => t('Comment Author'),
|
|
'removed_by' => t('Comment Removed By'),
|
|
'comment' => t('Comment Text'),
|
|
'entry_type' => t('Comment Entry Type'),
|
|
'is_persistent' => t('Comment Is Persistent'),
|
|
'is_sticky' => t('Comment Is Sticky'),
|
|
'expire_time' => t('Comment Expire Time'),
|
|
'remove_time' => t('Comment Remove Time'),
|
|
'has_been_removed' => t('Comment Has Been Removed')
|
|
];
|
|
}
|
|
|
|
public function createBehaviors(Behaviors $behaviors)
|
|
{
|
|
$behaviors->add(new BoolCast([
|
|
'is_persistent',
|
|
'is_sticky',
|
|
'has_been_removed'
|
|
]));
|
|
|
|
$behaviors->add(new MillisecondTimestamp([
|
|
'entry_time',
|
|
'expire_time',
|
|
'remove_time'
|
|
]));
|
|
|
|
$behaviors->add(new Binary([
|
|
'comment_id',
|
|
'environment_id',
|
|
'endpoint_id',
|
|
'host_id',
|
|
'service_id'
|
|
]));
|
|
}
|
|
|
|
public function createRelations(Relations $relations)
|
|
{
|
|
$relations->belongsTo('endpoint', Endpoint::class);
|
|
$relations->belongsTo('environment', Environment::class);
|
|
$relations->belongsTo('history', History::class)
|
|
->setCandidateKey('comment_id')
|
|
->setForeignKey('comment_history_id');
|
|
$relations->belongsTo('host', Host::class);
|
|
$relations->belongsTo('service', Service::class)->setJoinType('LEFT');
|
|
}
|
|
}
|