123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209 |
- <?php
- declare(strict_types = 1);
- namespace Component\Bridge\Entity;
- use DateTimeInterface;
- class ForeignLink
- {
-
-
- private int $user_id;
- private int $foreign_id;
- private int $service;
- private ?string $credentials = null;
- private int $noticesync = 1;
- private int $friendsync = 2;
- private int $profilesync = 1;
- private ?DateTimeInterface $last_noticesync = null;
- private ?DateTimeInterface $last_friendsync = null;
- private DateTimeInterface $created;
- private DateTimeInterface $modified;
- public function setUserId(int $user_id): self
- {
- $this->user_id = $user_id;
- return $this;
- }
- public function getUserId(): int
- {
- return $this->user_id;
- }
- public function setForeignId(int $foreign_id): self
- {
- $this->foreign_id = $foreign_id;
- return $this;
- }
- public function getForeignId(): int
- {
- return $this->foreign_id;
- }
- public function setService(int $service): self
- {
- $this->service = $service;
- return $this;
- }
- public function getService(): int
- {
- return $this->service;
- }
- public function setCredentials(?string $credentials): self
- {
- $this->credentials = \is_null($credentials) ? null : mb_substr($credentials, 0, 191);
- return $this;
- }
- public function getCredentials(): ?string
- {
- return $this->credentials;
- }
- public function setNoticesync(int $noticesync): self
- {
- $this->noticesync = $noticesync;
- return $this;
- }
- public function getNoticesync(): int
- {
- return $this->noticesync;
- }
- public function setFriendsync(int $friendsync): self
- {
- $this->friendsync = $friendsync;
- return $this;
- }
- public function getFriendsync(): int
- {
- return $this->friendsync;
- }
- public function setProfilesync(int $profilesync): self
- {
- $this->profilesync = $profilesync;
- return $this;
- }
- public function getProfilesync(): int
- {
- return $this->profilesync;
- }
- public function setLastNoticesync(?DateTimeInterface $last_noticesync): self
- {
- $this->last_noticesync = $last_noticesync;
- return $this;
- }
- public function getLastNoticesync(): ?DateTimeInterface
- {
- return $this->last_noticesync;
- }
- public function setLastFriendsync(?DateTimeInterface $last_friendsync): self
- {
- $this->last_friendsync = $last_friendsync;
- return $this;
- }
- public function getLastFriendsync(): ?DateTimeInterface
- {
- return $this->last_friendsync;
- }
- public function setCreated(DateTimeInterface $created): self
- {
- $this->created = $created;
- return $this;
- }
- public function getCreated(): DateTimeInterface
- {
- return $this->created;
- }
- public function setModified(DateTimeInterface $modified): self
- {
- $this->modified = $modified;
- return $this;
- }
- public function getModified(): DateTimeInterface
- {
- return $this->modified;
- }
-
-
- public static function schemaDef(): array
- {
- return [
- 'name' => 'foreign_link',
- 'fields' => [
- 'user_id' => ['type' => 'int', 'not null' => true, 'description' => 'link to user on this system, if exists'],
- 'foreign_id' => ['type' => 'int', 'size' => 'big', 'not null' => true, 'description' => 'link to user on foreign service, if exists'],
- 'service' => ['type' => 'int', 'not null' => true, 'description' => 'foreign key to service'],
- 'credentials' => ['type' => 'varchar', 'length' => 191, 'description' => 'authc credentials, typically a password'],
- 'noticesync' => ['type' => 'int', 'size' => 'tiny', 'not null' => true, 'default' => 1, 'description' => 'notice synchronization, bit 1 = sync outgoing, bit 2 = sync incoming, bit 3 = filter local replies'],
- 'friendsync' => ['type' => 'int', 'size' => 'tiny', 'not null' => true, 'default' => 2, 'description' => 'friend synchronization, bit 1 = sync outgoing, bit 2 = sync incoming'],
- 'profilesync' => ['type' => 'int', 'size' => 'tiny', 'not null' => true, 'default' => 1, 'description' => 'profile synchronization, bit 1 = sync outgoing, bit 2 = sync incoming'],
- 'last_noticesync' => ['type' => 'datetime', 'description' => 'last time notices were imported'],
- 'last_friendsync' => ['type' => 'datetime', 'description' => 'last time friends were imported'],
- 'created' => ['type' => 'datetime', 'not null' => true, 'default' => 'CURRENT_TIMESTAMP', 'description' => 'date this record was created'],
- 'modified' => ['type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'],
- ],
- 'primary key' => ['user_id', 'foreign_id', 'service'],
- 'foreign keys' => [
- 'foreign_link_user_id_fkey' => ['user', ['user_id' => 'id']],
- 'foreign_link_foreign_id_fkey' => ['foreign_user', ['foreign_id' => 'id', 'service' => 'service']],
- 'foreign_link_service_fkey' => ['foreign_service', ['service' => 'id']],
- ],
- 'indexes' => [
- 'foreign_user_user_id_idx' => ['user_id'],
- ],
- ];
- }
- }
|