\Database
- Author: Michael Dombrowski
Synopsis
class Database
{
- // members
- private string $columns = "`ArticleURL`, `Headline`, `Subtitle`, `Author`, `Publisher`, `PublishDate`, `ArticleSources`, `TextSources`, `RetrievalDate`, `ArticleSection`, `GradeLevel`, `IsPrimarySource`, `HasUpdates`, `HasNotes`, `ArticleText`";
- private PDO $pdo;
- private Article $articles;
- private array $fragments = ;
- // methods
- public void __construct()
- public array|Article getArticles()
- public Article getArticleByURL()
- public array|Article getArticlesByPublisher()
- public array|Article getArticlesByAuthor()
- public array|Article getArticlesBySection()
- public array|Article getArticlesByDayOfWeek()
- public array|string listAllSections()
- public array|string listAllAuthors()
- public array|string listAllPublishers()
- public void readDatabase()
- private void getFragments()
- private void setClassificationData()
- private void setClassification()
- private void makeArticleFromDB()
Members
Methods
private
public
- __construct()
- getArticleByURL() — Returns \Article object with the given URL
- getArticles()
- getArticlesByAuthor() — Returns array of \Article objects that have the same author as the given $author
- getArticlesByDayOfWeek() — Returns array of \Article objects that were published on a given day of the week
- getArticlesByPublisher() — Returns array of \Article objects that have the same publisher as the given $publisher
- getArticlesBySection() — Returns array of \Article objects that have the same section as the given $section
- listAllAuthors() — Returns a list of all the authors any article in the database wrote
- listAllPublishers() — Returns a list of all the publishers in the database
- listAllSections() — Returns a list of all the sections any article in the database was published in
- readDatabase() — Reads database of given \PDO and creates \Article objects for each row