src/Models/User.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88

<?php

namespace App\Models;

use App\Database;
use App\Support\ConnectsToDatabase;

class User implements ConnectsToDatabase
{
  public function __construct(private string $id)
  {}

  public static function fromDatabase(array $row): self
  {
    return new self(
      $row["id"],
    );
  }

  public static function fetch(string $id = ""): ?self
  {
    if (empty($id)) {
      throw new \InvalidArgumentException("missing user id");
    }

    return Database::getInstance()->query(
      <<<SQL
        select * from users where id=:id
      SQL,
      [
        "id" => $id,
      ]
    );
  }

  public static function fetchAll(): array
  {}

  public static function fetchWithPassword(string $id, string $password): ?self
  {
    $row = Database::getInstance()->query("select * from users where id=:id and password=:password", [
      "id" => $id,
      "password" => $password,
    ])->fetch();

    if (empty($row)) {
      return null;
    }

    return self::fromDatabase($row);
  }

  public function insert(): bool
  {
    return Database::getInstance()->query(
      <<<SQL
        insert into users (id)
        values (:id)
      SQL,
      [
        "id" => $this->id,
      ]
    );
  }

  public function update(): bool
  {}

  public function delete(): bool
  {}

  public function getId(): string
  {
    return $this->id;
  }

  public function fetchDevice(string $id): ?Device
  {
    return Device::fetch($id, $this->id);
  }
  /**
   * @return Device[]
   */
  public function fetchDevices(): array
  {
    return Device::fetchAll($this->id);
  }
}