aboutsummaryrefslogtreecommitdiff
path: root/private/Model
diff options
context:
space:
mode:
Diffstat (limited to 'private/Model')
-rw-r--r--private/Model/Connection.php42
-rw-r--r--private/Model/Query.php71
-rw-r--r--private/Model/Result.php52
-rw-r--r--private/Model/creds.php10
-rw-r--r--private/Model/fresh.sql103
5 files changed, 0 insertions, 278 deletions
diff --git a/private/Model/Connection.php b/private/Model/Connection.php
deleted file mode 100644
index 4afa330..0000000
--- a/private/Model/Connection.php
+++ /dev/null
@@ -1,42 +0,0 @@
-<?php
-
-declare(strict_types=1);
-
-namespace AugustOffensive\Model;
-
-/**
- * Model connection class for connecting to database via PDO.
- */
-class Connection
-{
- /** @var \PDO $_conn PDO connection to database. */
- private $conn;
- /**
- * Initiates connection to PostGreSQL database.
- *
- * @return Connection
- */
- public function __construct ()
- {
- // Establish connection to db
- // breaks side-effect rule
- include 'creds.php';
-
- try {
- $conn = new \PDO(
- "pgsql: host=" . $cred->host .
- (($cred->port !== '') ? ";port=" . $cred->port : '') .
- ";dbname=" . $cred->dbName,
- $cred->login,
- $cred->password
- );
- // we destroy $cred as quickly as possible
- $cred = null;
- } catch (\PDOException $err) {
- // we destroy $cred as quickly as possible
- $cred = null;
- throw $err; // throw for Controller to catch
- }
- return $this;
- }
-}
diff --git a/private/Model/Query.php b/private/Model/Query.php
deleted file mode 100644
index 7eca836..0000000
--- a/private/Model/Query.php
+++ /dev/null
@@ -1,71 +0,0 @@
-<?php
-
-declare(strict_types=1);
-
-namespace AugustOffensive\Model;
-
-/**
- * Query object for storing relevant query information.
- */
-class Query
-{
- /** @var array $path array of request structure. */
- private $path;
-
- /** @var string $request type of request made to the server. */
- private $request;
-
- /** @var array $content structure of information sent to the server. */
- private $content;
-
- /**
- * Store query information.
- *
- * @param array $path The array that holds the original request structure.
- * @param string $request The request method made to the server.
- * @param array $content The content object sent by the request.
- *
- * @return Query
- */
- public function __construct (
- array $path,
- string $request,
- array $content
- ) {
- $this->path = $path;
- $this->request = $request;
- $this->content = $content;
-
- return $this;
- }
-
- /**
- * Returns the request path made by the client.
- *
- * @return array
- */
- public function getPath (): array
- {
- return $this->path;
- }
-
- /**
- * Returns the request type made by the client.
- *
- * @return string
- */
- public function getRequest (): string
- {
- return $this->request;
- }
-
- /**
- * Returns the information that is built from outside the request path.
- *
- * @return array
- */
- public function getContent (): array
- {
- return $this->content;
- }
-}
diff --git a/private/Model/Result.php b/private/Model/Result.php
deleted file mode 100644
index ac08821..0000000
--- a/private/Model/Result.php
+++ /dev/null
@@ -1,52 +0,0 @@
-<?php
-
-declare(strict_types=1);
-
-namespace AugustOffensive\Model;
-/**
- * Result object for storing information to send back to the client.
- */
-class Result
-{
- /** @var string $resultType the type of result to return to the client. */
- private $resultType;
-
- /** @var array $result */
- private $result;
-
- /**
- * Store result information.
- *
- * @param string $resultType The type of result to send back to the client.
- * @param array $result The result object to send back to the client.
- *
- * @return Result
- */
- public function __construct (string $resultType, array $result)
- {
- $this->resultType = $resultType;
- $this->result = $result;
-
- return $this;
- }
-
- /**
- * Returns the result type of the Result.
- *
- * @return string
- */
- public function getResultType (): string
- {
- return $this->resultType;
- }
-
- /**
- * Returns the result array of the Result.
- *
- * @return array
- */
- public function getResult (): array
- {
- return $this->result;
- }
-} \ No newline at end of file
diff --git a/private/Model/creds.php b/private/Model/creds.php
deleted file mode 100644
index 056d77b..0000000
--- a/private/Model/creds.php
+++ /dev/null
@@ -1,10 +0,0 @@
-<?php
-
-declare(strict_types=1);
-
-$cred = new \stdClass();
-$cred->host = "localhost";
-$cred->port = "5432";
-$cred->dbName = "";
-$cred->login = "";
-$cred->password = "";
diff --git a/private/Model/fresh.sql b/private/Model/fresh.sql
deleted file mode 100644
index f39b360..0000000
--- a/private/Model/fresh.sql
+++ /dev/null
@@ -1,103 +0,0 @@
- -- fresh.sql: SQL script that creates the tables used by AO
- -- please drop all tables in db before initiating unless told otherwise
-
- -- uncomment the following two lines to automatically drop all tables
---DROP SCHEMA "public" CASCADE;
---CREATE SCHEMA "public";
-
-CREATE OR REPLACE FUNCTION public.GETDATE() RETURNS TIMESTAMPTZ
- STABLE LANGUAGE SQL AS 'SELECT NOW()';
-
- -- base table for users
-CREATE TABLE users (
- userid SERIAL,
- email VARCHAR(40) UNIQUE NOT NULL,
- firstname VARCHAR(20) NOT NULL,
- lastname VARCHAR(20) NOT NULL,
- password VARCHAR(255) NOT NULL, -- intend to use bcrypt hash through PHP
- games INTEGER DEFAULT 0, -- simple tracking statistics
- wins INTEGER DEFAULT 0, -- "
- joindate DATE DEFAULT GETDATE(),
- activated BIT(1) DEFAULT B'0', -- see activation_keys table
- PRIMARY KEY (userid)
-);
-
- -- when activation is completed, key gets deleted and activated bit for user gets flipped to 1.
-CREATE TABLE activation_keys (
- code VARCHAR(128),
- userid SERIAL,
- PRIMARY KEY (code),
- CONSTRAINT activation_keys_userid
- FOREIGN KEY (userid) REFERENCES users(userid)
-);
-
- -- base table for games
-CREATE TABLE games (
- gameid SERIAL,
- title VARCHAR(140) NOT NULL,
- gametypeid SERIAL NOT NULL, -- future proofing: suppose different game types
- players SMALLINT NOT NULL, -- number of players in a game
- waitfor INTEGER NOT NULL, -- time in seconds to wait for player to complete a turn
- lastturn DATE DEFAULT GETDATE(),
- gamestate INTEGER DEFAULT 1,
- PRIMARY KEY (gameid)
-);
-
- -- associative table: many users, many games
-CREATE TABLE allegiances (
- gameid SERIAL,
- userid SERIAL,
- allegiance VARCHAR(140), -- important/unimportant role for user (depends on gametype)
- ordernum SMALLINT NOT NULL, -- user # spot in game
- playing SMALLINT DEFAULT 1, -- default is binary: 0 means player OOP
- PRIMARY KEY (gameid, userid),
- CONSTRAINT users_games_gameid
- FOREIGN KEY (gameid) REFERENCES games(gameid),
- CONSTRAINT users_games_userid
- FOREIGN KEY (userid) REFERENCES users(userid)
-);
-
- -- Regions are composed of nationstates
-CREATE TABLE regions (
- regionid SERIAL,
- name VARCHAR(64) NOT NULL,
- abbreviation CHAR(2),
- bonus INTEGER NOT NULL,
- PRIMARY KEY (regionid)
-);
-
- -- base table for nationstates
-CREATE TABLE nationstates (
- nationid SERIAL,
- regionid SERIAL,
- name VARCHAR(64) NOT NULL,
- abbreviation CHAR(4),
- PRIMARY KEY (nationid),
- CONSTRAINT nationstates_regionid
- FOREIGN KEY (regionid) REFERENCES regions(regionid)
-);
-
- -- nationstates border nationstates
-CREATE TABLE borders (
- nationid SERIAL,
- borderid SERIAL,
- PRIMARY KEY (nationid, borderid),
- CONSTRAINT borders_nationid
- FOREIGN KEY (nationid) REFERENCES nationstates(nationid),
- CONSTRAINT borders_borderid
- FOREIGN KEY (borderid) REFERENCES nationstates(nationid)
-);
-
- -- associative table: many games, many nationstates. Users control them.
-CREATE TABLE games_nationstates (
- gameid SERIAL,
- nationid SERIAL,
- userid SERIAL, -- owner of nationstate for particular game
- PRIMARY KEY (gameid, nationid),
- CONSTRAINT games_nationstates_gameid
- FOREIGN KEY (gameid) REFERENCES games(gameid),
- CONSTRAINT games_nationstates_nationid
- FOREIGN KEY (nationid) REFERENCES nationstates(nationid),
- CONSTRAINT games_nationstates_userid
- FOREIGN KEY (userid) REFERENCES users(userid)
-);
generated by cgit (git 2.34.1) at 2026-01-12 02:17:37 +0000