MibDatabase::update_oid() - Code Metrics - Inspection of "DBMib in trait" - patrickpr/trapdirector - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( 7048d4...c63076 )

by Patrick

created 2020-02-14 14:54 UTC

MibDatabase::update_oid() A

↳ Parent: MibDatabase

Complexity

Conditions	2
Paths	2

Size

Total Lines	12
Code Lines	5

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	2
eloc	5
c	1
b	0
f	0
nc	2
nop	0
dl	0
loc	12
rs	10

<?php



trait MibDatabase
{
    /** @return \Trapdirector\Logging */
    abstract public function getLogging();
    
    /** @return \Trapdirector\Database */
    abstract public function getTrapsDB();

    
    /**
     * Update or add an OID to database uses $this->dbOidIndex for mem cache
     * and $this->oidDesc doe data
     * @return number : 0=unchanged, 1 = changed, 2=created
     */
    public function update_oid()
    {
        $db_conn=$this->getTrapsDB()->db_connect_trap();
        // Quote description.
        $this->oidDesc['description']=$db_conn->quote($this->oidDesc['description']);

        
        if (isset($this->dbOidIndex[$this->oidDesc['oid']]))
        { // oid exists in db, so update
            return $this->update_oid_update();
        }
        // create new OID.
        return $this->update_oid_create();
        
    }
    
    /**
     * Update object in DB with object in dbOidIndex if name/mib/type has changed.
     * @return number : 0=unchanged, 1 = changed, 2=created
     */
    private function update_oid_update()
    {
        
        $db_conn=$this->getTrapsDB()->db_connect_trap();
        
        if ($this->dbOidIndex[$this->oidDesc['oid']]['key'] == -1)
        { // newly created.
            return 0;
        }
        $oidIndex=$this->dbOidIndex[$this->oidDesc['oid']]['key']; // Get index in dbOidAll
        $dbOid=$this->dbOidAll[$oidIndex]; // Get array of element
        if ( $this->oidDesc['name'] != $dbOid['name'] ||
            $this->oidDesc['mib'] != $dbOid['mib'] ||
            $this->oidDesc['type'] !=$dbOid['type']
            )
        { // Do update
            $sql='UPDATE '.$this->getTrapsDB()->dbPrefix.'mib_cache SET '.
                'name = :name , type = :type , mib = :mib , textual_convention = :tc , display_hint = :display_hint'.
                ', syntax = :syntax, type_enum = :type_enum, description = :description '.
                ' WHERE id= :id';
            $sqlQuery=$db_conn->prepare($sql);
            
            $sqlParam=array(
                ':name' => $this->oidDesc['name'],
                ':type' => $this->oidDesc['type'],
                ':mib' => $this->oidDesc['mib'],
                ':tc' =>  $this->oidDesc['textconv']??'null',
                ':display_hint' => $this->oidDesc['dispHint']??'null' ,
                ':syntax' => $this->oidDesc['syntax']==null??'null',
                ':type_enum' => $this->oidDesc['type_enum']??'null',
                ':description' => $this->oidDesc['description']??'null',
                ':id' => $this->dbOidAll[$this->dbOidIndex[$this->oidDesc['oid']]['id']]
            );
            
            if ($sqlQuery->execute($sqlParam) === false) {
                $this->getLogging()->log('Error in query : ' . $sql,ERROR,'');
            }
            $this->getLogging()->log('Trap updated : '.$this->oidDesc['name'] . ' / OID : '.$this->oidDesc['oid'],DEBUG );
            return 1;
        }
        else
        {
            $this->getLogging()->log('Trap unchanged : '.$this->oidDesc['name'] . ' / OID : '.$this->oidDesc['oid'],DEBUG );
            return 0;
        }
    }

    /**
     * Create object in DB with object in dbOidIndex
     * @return number : 0=unchanged, 1 = changed, 2=created
     */
    private function update_oid_create()
    {
        // Insert data
        
        $db_conn=$this->getTrapsDB()->db_connect_trap();
        $sql='INSERT INTO '.$this->getTrapsDB()->dbPrefix.'mib_cache '.
            '(oid, name, type , mib, textual_convention, display_hint '.
            ', syntax, type_enum , description ) ' .
            'values (:oid, :name , :type ,:mib ,:tc , :display_hint'.
            ', :syntax, :type_enum, :description )';
        
        if ($this->getTrapsDB()->trapDBType == 'pgsql') $sql .= 'RETURNING id';
        
        $sqlQuery=$db_conn->prepare($sql);
        
        $sqlParam=array(
            ':oid' => $this->oidDesc['oid'],
            ':name' => $this->oidDesc['name'],
            ':type' => $this->oidDesc['type'],
            ':mib' => $this->oidDesc['mib'],
            ':tc' =>  $this->oidDesc['textconv']??'null',
            ':display_hint' => $this->oidDesc['dispHint']??'null',
            ':syntax' => $this->oidDesc['syntax']??'null',
            ':type_enum' => $this->oidDesc['type_enum']??'null',
            ':description' => $this->oidDesc['description']??'null'
        );
        
        if ($sqlQuery->execute($sqlParam) === false) {
            $this->getLogging()->log('Error in query : ' . $sql,1,'');
        }
        
        switch ($this->getTrapsDB()->trapDBType)
        {
            case 'pgsql':
                // Get last id to insert oid/values in secondary table
                if (($inserted_id_ret=$sqlQuery->fetch(PDO::FETCH_ASSOC)) === false) {
                    $this->getLogging()->log('Error getting id - pgsql - ',1,'');
                }
                if (! isset($inserted_id_ret['id'])) {
                    $this->getLogging()->log('Error getting id - pgsql - empty.',ERROR);
                    return 0;
                }
                $this->dbOidIndex[$this->oidDesc['oid']]['id']=$inserted_id_ret['id'];

                break;
            case 'mysql':
                // Get last id to insert oid/values in secondary table
                $sql='SELECT LAST_INSERT_ID();';
                if (($ret_code=$db_conn->query($sql)) === false) {
                    $this->getLogging()->log('Erreur getting id - mysql - ',ERROR);
                    return 0;
                }
                
                $inserted_id=$ret_code->fetch(PDO::FETCH_ASSOC)['LAST_INSERT_ID()'];
                if ($inserted_id==false) throw new Exception("Weird SQL error : last_insert_id returned false : open issue");
                $this->dbOidIndex[$this->oidDesc['oid']]['id']=$inserted_id;
                break;
            default:
                $this->getLogging()->log('Error SQL type Unknown : '.$this->getTrapsDB()->trapDBType,ERROR);
                return 0;
        }
        
        // Set as newly created.
        $this->dbOidIndex[$this->oidDesc['oid']]['key']=-1;
        return 2;
    }

    /**
     * get all objects for a trap.
     * @param integer $trapId
     * @return array : array of cached objects
     */
    private function cache_db_objects($trapId)
    {
        $dbObjects=array(); // cache of objects for trap in db
        $db_conn=$this->getTrapsDB()->db_connect_trap();
        // Get all objects
        $sql='SELECT * FROM '.$this->getTrapsDB()->dbPrefix.'mib_cache_trap_object where trap_id='.$trapId.';';
        $this->getLogging()->log('SQL query get all traps: '.$sql,DEBUG );
        if (($ret_code=$db_conn->query($sql)) === false) {
            $this->getLogging()->log('No result in query : ' . $sql,1,'');
        }
        $dbObjectsRaw=$ret_code->fetchAll();
        
        foreach ($dbObjectsRaw as $val)
        {
            $dbObjects[$val['object_id']]=1;
        }
        return $dbObjects;
    }
    

}

1			<?php
2
3
4
5			trait MibDatabase
6			{
7			/** @return \Trapdirector\Logging */
8			abstract public function getLogging();
9
10			/** @return \Trapdirector\Database */
11			abstract public function getTrapsDB();
12
13
14			/**
15			* Update or add an OID to database uses $this->dbOidIndex for mem cache
16			* and $this->oidDesc doe data
17			* @return number : 0=unchanged, 1 = changed, 2=created
18			*/
19			public function update_oid()
20			{
21			$db_conn=$this->getTrapsDB()->db_connect_trap();
22			// Quote description.
23			$this->oidDesc['description']=$db_conn->quote($this->oidDesc['description']);
			1 ignored issue – show Bug Best Practice introduced 2020-02-14 14:56 UTC by Report Bug Copy Issue Report The property `oidDesc` does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly. Loading history...
24
25			if (isset($this->dbOidIndex[$this->oidDesc['oid']]))
26			{ // oid exists in db, so update
27			return $this->update_oid_update();
28			}
29			// create new OID.
30			return $this->update_oid_create();
31
32			}
33
34			/**
35			* Update object in DB with object in dbOidIndex if name/mib/type has changed.
36			* @return number : 0=unchanged, 1 = changed, 2=created
37			*/
38			private function update_oid_update()
39			{
40
41			$db_conn=$this->getTrapsDB()->db_connect_trap();
42
43			if ($this->dbOidIndex[$this->oidDesc['oid']]['key'] == -1)
44			{ // newly created.
45			return 0;
46			}
47			$oidIndex=$this->dbOidIndex[$this->oidDesc['oid']]['key']; // Get index in dbOidAll
48			$dbOid=$this->dbOidAll[$oidIndex]; // Get array of element
49			if ( $this->oidDesc['name'] != $dbOid['name'] \|\|
50			$this->oidDesc['mib'] != $dbOid['mib'] \|\|
51			$this->oidDesc['type'] !=$dbOid['type']
52			)
53			{ // Do update
54			$sql='UPDATE '.$this->getTrapsDB()->dbPrefix.'mib_cache SET '.
55			'name = :name , type = :type , mib = :mib , textual_convention = :tc , display_hint = :display_hint'.
56			', syntax = :syntax, type_enum = :type_enum, description = :description '.
57			' WHERE id= :id';
58			$sqlQuery=$db_conn->prepare($sql);
59
60			$sqlParam=array(
61			':name' => $this->oidDesc['name'],
62			':type' => $this->oidDesc['type'],
63			':mib' => $this->oidDesc['mib'],
64			':tc' => $this->oidDesc['textconv']??'null',
65			':display_hint' => $this->oidDesc['dispHint']??'null' ,
66			':syntax' => $this->oidDesc['syntax']==null??'null',
67			':type_enum' => $this->oidDesc['type_enum']??'null',
68			':description' => $this->oidDesc['description']??'null',
69			':id' => $this->dbOidAll[$this->dbOidIndex[$this->oidDesc['oid']]['id']]
70			);
71
72			if ($sqlQuery->execute($sqlParam) === false) {
73			$this->getLogging()->log('Error in query : ' . $sql,ERROR,'');
74			}
75			$this->getLogging()->log('Trap updated : '.$this->oidDesc['name'] . ' / OID : '.$this->oidDesc['oid'],DEBUG );
76			return 1;
77			}
78			else
79			{
80			$this->getLogging()->log('Trap unchanged : '.$this->oidDesc['name'] . ' / OID : '.$this->oidDesc['oid'],DEBUG );
81			return 0;
82			}
83			}
84
85			/**
86			* Create object in DB with object in dbOidIndex
87			* @return number : 0=unchanged, 1 = changed, 2=created
88			*/
89			private function update_oid_create()
90			{
91			// Insert data
92
93			$db_conn=$this->getTrapsDB()->db_connect_trap();
94			$sql='INSERT INTO '.$this->getTrapsDB()->dbPrefix.'mib_cache '.
95			'(oid, name, type , mib, textual_convention, display_hint '.
96			', syntax, type_enum , description ) ' .
97			'values (:oid, :name , :type ,:mib ,:tc , :display_hint'.
98			', :syntax, :type_enum, :description )';
99
100			if ($this->getTrapsDB()->trapDBType == 'pgsql') $sql .= 'RETURNING id';
101
102			$sqlQuery=$db_conn->prepare($sql);
103
104			$sqlParam=array(
105			':oid' => $this->oidDesc['oid'],
106			':name' => $this->oidDesc['name'],
107			':type' => $this->oidDesc['type'],
108			':mib' => $this->oidDesc['mib'],
109			':tc' => $this->oidDesc['textconv']??'null',
110			':display_hint' => $this->oidDesc['dispHint']??'null',
111			':syntax' => $this->oidDesc['syntax']??'null',
112			':type_enum' => $this->oidDesc['type_enum']??'null',
113			':description' => $this->oidDesc['description']??'null'
114			);
115
116			if ($sqlQuery->execute($sqlParam) === false) {
117			$this->getLogging()->log('Error in query : ' . $sql,1,'');
118			}
119
120			switch ($this->getTrapsDB()->trapDBType)
121			{
122			case 'pgsql':
123			// Get last id to insert oid/values in secondary table
124			if (($inserted_id_ret=$sqlQuery->fetch(PDO::FETCH_ASSOC)) === false) {
125			$this->getLogging()->log('Error getting id - pgsql - ',1,'');
126			}
127			if (! isset($inserted_id_ret['id'])) {
128			$this->getLogging()->log('Error getting id - pgsql - empty.',ERROR);
129			return 0;
130			}
131			$this->dbOidIndex[$this->oidDesc['oid']]['id']=$inserted_id_ret['id'];
			1 ignored issue – show Bug Best Practice introduced 2020-02-14 14:56 UTC by Report Bug Copy Issue Report The property `dbOidIndex` does not exist. Although not strictly required by PHP, it is generally a best practice to declare properties explicitly. Loading history...
132			break;
133			case 'mysql':
134			// Get last id to insert oid/values in secondary table
135			$sql='SELECT LAST_INSERT_ID();';
136			if (($ret_code=$db_conn->query($sql)) === false) {
137			$this->getLogging()->log('Erreur getting id - mysql - ',ERROR);
138			return 0;
139			}
140
141			$inserted_id=$ret_code->fetch(PDO::FETCH_ASSOC)['LAST_INSERT_ID()'];
142			if ($inserted_id==false) throw new Exception("Weird SQL error : last_insert_id returned false : open issue");
143			$this->dbOidIndex[$this->oidDesc['oid']]['id']=$inserted_id;
144			break;
145			default:
146			$this->getLogging()->log('Error SQL type Unknown : '.$this->getTrapsDB()->trapDBType,ERROR);
147			return 0;
148			}
149
150			// Set as newly created.
151			$this->dbOidIndex[$this->oidDesc['oid']]['key']=-1;
152			return 2;
153			}
154
155			/**
156			* get all objects for a trap.
157			* @param integer $trapId
158			* @return array : array of cached objects
159			*/
160			private function cache_db_objects($trapId)
161			{
162			$dbObjects=array(); // cache of objects for trap in db
163			$db_conn=$this->getTrapsDB()->db_connect_trap();
164			// Get all objects
165			$sql='SELECT * FROM '.$this->getTrapsDB()->dbPrefix.'mib_cache_trap_object where trap_id='.$trapId.';';
166			$this->getLogging()->log('SQL query get all traps: '.$sql,DEBUG );
167			if (($ret_code=$db_conn->query($sql)) === false) {
168			$this->getLogging()->log('No result in query : ' . $sql,1,'');
169			}
170			$dbObjectsRaw=$ret_code->fetchAll();
171
172			foreach ($dbObjectsRaw as $val)
173			{
174			$dbObjects[$val['object_id']]=1;
175			}
176			return $dbObjects;
177			}
178
179
180			}

patrickpr / trapdirector

Push — master ( 7048d4...c63076 )

MibDatabase::update_oid() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like