@@ 75-84 (lines=10) @@ | ||
72 | /** |
|
73 | * @return array |
|
74 | */ |
|
75 | public function fetchAllItems() |
|
76 | { |
|
77 | $connection = $this->_em->getConnection(); |
|
78 | $statement = $connection->prepare('SELECT * FROM nv_request_limit_items'); |
|
79 | $statement->execute(); |
|
80 | $result = $statement->fetchAll(); |
|
81 | $connection->close(); |
|
82 | ||
83 | return $result; |
|
84 | } |
|
85 | ||
86 | /** |
|
87 | * @return int |
|
@@ 89-98 (lines=10) @@ | ||
86 | /** |
|
87 | * @return int |
|
88 | */ |
|
89 | public function getItemsCount() |
|
90 | { |
|
91 | $connection = $this->_em->getConnection(); |
|
92 | $statement = $connection->prepare('SELECT COUNT(*) FROM nv_request_limit_items'); |
|
93 | $statement->execute(); |
|
94 | $result = $statement->fetchColumn(0); |
|
95 | $connection->close(); |
|
96 | ||
97 | return $result; |
|
98 | } |
|
99 | } |
|
100 |