-
Notifications
You must be signed in to change notification settings - Fork 1
/
PullNews.php
118 lines (102 loc) · 3.17 KB
/
PullNews.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
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
<?php
namespace NewsToChat\Command;
use Cilex\Command\Command;
use Doctrine\ORM\EntityManager;
use NewsToChat\Entity\Article;
use NewsToChat\NewsGrabber;
use NewsToChat\Service\Database;
use Pimple;
use Symfony\Component\Console\Input\InputInterface;
use Symfony\Component\Console\Output\OutputInterface;
class PullNews extends Command
{
/**
* @var string
*/
private $commandName;
/**
* @var EntityManager
*/
private $entityManager;
/**
* @var string
*/
private $runtime;
/**
* @var array
*/
private $sources;
/**
* @param EntityManager $entityManager
* @param string $runtime
* @param array $sources
*/
public function __construct(EntityManager $entityManager, $runtime, array $sources)
{
parent::__construct();
$this->entityManager = $entityManager;
$this->runtime = $runtime;
$this->sources = $sources;
$this->commandName = $this->getName();
}
/**
* setup the configuration options for the command
* @return null
*/
protected function configure()
{
$this
->setName('pullnews')
->setDescription('Pull the news')
->setHelp('e.g. ./newstochat.php pullnews');
}
/**
* kick off the execution of the command
* @param InputInterface $input [description]
* @param OutputInterface $output [description]
* @return null
*/
protected function execute(InputInterface $input, OutputInterface $output)
{
$output->writeln("Running $this->commandName on $this->runtime...");
$newsGrabber = new NewsGrabber;
$news = $newsGrabber($this->sources);
$this->unbundleNewsSourceAndAppendToDatabase($news, $output);
}
/**
* Unbundle the news source, check to make sure the article isn't in the database, and append
* @param array $news
* @param OutputInterface $output
* @return null
*/
private function unbundleNewsSourceAndAppendToDatabase(array $news, OutputInterface $output)
{
for ($i = 0; $i < count($news); $i++) {
$url = $news[$i]['url'];
$container = new Pimple();
$container['entityManager'] = $this->entityManager;
$container['data'] = new Article(
$news[$i]['dateTime'],
$url,
$news[$i]['description'],
false
);
$container['database'] = $container->share(function ($c) {
return new Database(
$c['entityManager'],
$c['data']
);
});
$query = 'SELECT news FROM NewsToChat\Entity\Article news WHERE news.url=\'' . $url . '\'';
$result = $container['database']->query($query);
if (!$result) {
try {
$id = $container['database']->insert();
$output->writeln('Record inserted into the database as ID: ' . $id);
} catch (Exception $e) {
$output->writeln('An error occurred: ' . $e);
}
}
}
}
}