event tables

1 files changed, 16 insertions, 1 deletions

diff --git a/src/Model/Event/BaseEvent.php b/src/Model/Event/BaseEvent.php
index d3cc3fb..0c1795b 100644
--- a/src/Model/Event/BaseEvent.php
+++ b/src/Model/Event/BaseEvent.php
@@ -2,6 +2,9 @@
 
 namespace App\Model\Event;
 
+use App\DB;
+use App\Model\Event;
+
 abstract class BaseEvent
 {
   public int $id;
@@ -10,5 +13,17 @@ abstract class BaseEvent
   public \DateTime $createdAt;
   public \DateTime $updatedAt;
 
-  abstract function sqlInsert(): void;
+  public Event $event;
+
+  abstract function dbInsert(): void;
+  abstract function dbDelete(): void;
+
+  public function getEvent(): Event
+  {
+    if (! isset($this->event)) {
+      $this->event = DB::fetch(Event::class, 'select * from events where id=:id', ['id' => $this->eventId])[0];
+    }
+
+    return $this->event;
+  }
 }