Code Duplication - parsingphase/takeAticket - Measure and Improve Code Quality continuously with Scrutinizer

takeAticket

Code Duplication Length = 7-8 lines in 2 locations

src/Phase/TakeATicket/DataSource/AbstractSql.php 1 location


     *
     * @return array
     */
    public function fetchTicketById($id)
    {
        $conn = $this->getDbConn();
        $song = $conn->fetchAssoc('SELECT * FROM ' . self::TICKETS_TABLE . ' WHERE id = :id', ['id' => $id]);

        return $song;
    }

    /**
     * Get current value of a named setting, NULL if missing

src/Phase/TakeATicket/DataSource/Sqlite.php 1 location


     * @param  $key
     * @return mixed|null
     */
    public function fetchSetting($key)
    {
        $conn = $this->getDbConn();
        $row = $conn->fetchAssoc('SELECT settingValue FROM settings WHERE settingKey=:key', ['key' => $key]);

        return $row ? $row['settingValue'] : null;
        // rowCount seems to not work on sqlite: http://php.net/manual/en/pdostatement.rowcount.php
    }
}


		@@ 599-605 (lines=7) @@
596		*
597		* @return array
598		*/
599		public function fetchTicketById($id)
600		{
601		$conn = $this->getDbConn();
602		$song = $conn->fetchAssoc('SELECT * FROM ' . self::TICKETS_TABLE . ' WHERE id = :id', ['id' => $id]);
603
604		return $song;
605		}
606
607		/**
608		* Get current value of a named setting, NULL if missing

		@@ 29-36 (lines=8) @@
26		* @param $key
27		* @return mixed\|null
28		*/
29		public function fetchSetting($key)
30		{
31		$conn = $this->getDbConn();
32		$row = $conn->fetchAssoc('SELECT settingValue FROM settings WHERE settingKey=:key', ['key' => $key]);
33
34		return $row ? $row['settingValue'] : null;
35		// rowCount seems to not work on sqlite: http://php.net/manual/en/pdostatement.rowcount.php
36		}
37		}
38

parsingphase / takeAticket

GitHub Access Token became invalid

Code Duplication Length = 7-8 lines in 2 locations

src/Phase/TakeATicket/DataSource/AbstractSql.php 1 location

src/Phase/TakeATicket/DataSource/Sqlite.php 1 location