View GitHub Repository RobotsTxtParser

Schedule Inspection
Subscribe

Code Duplication    Length = 12-13 lines in 2 locations

src/Client/Cache/MySQL/Base.php 1 location

@@ 30-41 (lines=12) @@
27 
     *
28 
     * @return array
29 
     */
30 
    public function debug()
31 
    {
32 
        $query = $this->pdo->prepare(<<<SQL
33 
SELECT *
34 
FROM robotstxt__cache1
35 
WHERE base = :base;
36 
SQL
37 
        );
38 
        $query->bindValue('base', $this->base, \PDO::PARAM_STR);
39 
        $query->execute();
40 
        return $query->rowCount() > 0 ? $query->fetch(\PDO::FETCH_ASSOC) : [];
41 
    }
42 

                                

                                                            

                                    43
                                    
                                    
    /**

                                

                                                            

                                    44
                                    
                                    
     * Parser client

                                

                                                                        

                

                                                            

                    
src/Client/Delay/MySQL/Base.php 1 location

                

                

                    

                                                
                                                    

                                
                                
                                    @@ 133-145 (lines=13) @@
                                
                            


                                                            

                                    130
                                    
                                    
     *

                                

                                                            

                                    131
                                    
                                    
     * @return array

                                

                                                            

                                    132
                                    
                                    
     */

                                

                                                            

                                    133
                                    
                                    
    public function debug()

                                

                                                            

                                    134
                                    
                                    
    {

                                

                                                            

                                    135
                                    
                                    
        $query = $this->pdo->prepare(<<<SQL

                                

                                                            

                                    136
                                    
                                    
SELECT *

                                

                                                            

                                    137
                                    
                                    
FROM robotstxt__delay0

                                

                                                            

                                    138
                                    
                                    
WHERE base = :base AND userAgent = :userAgent;

                                

                                                            

                                    139
                                    
                                    
SQL

                                

                                                            

                                    140
                                    
                                    
        );

                                

                                                            

                                    141
                                    
                                    
        $query->bindValue('base', $this->base, \PDO::PARAM_STR);

                                

                                                            

                                    142
                                    
                                    
        $query->bindValue('userAgent', $this->userAgent, \PDO::PARAM_STR);

                                

                                                            

                                    143
                                    
                                    
        $query->execute();

                                

                                                            

                                    144
                                    
                                    
        return $query->rowCount() > 0 ? $query->fetch(\PDO::FETCH_ASSOC) : [];

                                

                                                            

                                    145
                                    
                                    
    }

                                

                                                            

                                    146
                                    
                                    
}

                                

                                                            

                                    147