Ejemplo n.º 1
0
 /**
  * Obtiene el detalle de las foreign keys del esquema
  * @return Array
  */
 public function checkTableForeignKeys()
 {
     $sql = "select uc.constraint_name, uc.table_name, ucc.column_name, uc.r_constraint_name, destino.table_name as r_table_name, " . "destino.column_name as r_column_name, uc.status " . "from user_constraints uc " . "inner join user_cons_columns destino on uc.r_constraint_name = destino.constraint_name " . "inner join user_cons_columns ucc on uc.constraint_name = ucc.constraint_name " . "where uc.constraint_type = 'R' " . "and uc.owner = upper(:v_owner) " . "and uc.table_name = upper(:v_table) " . "order by uc.table_name, uc.r_constraint_name, destino.table_name, destino.column_name";
     $stmt = oci_parse($this->getConnection(), $sql);
     oci_bind_by_name($stmt, ":v_table", $this->objectName);
     oci_bind_by_name($stmt, ":v_owner", $this->owner);
     if (!@oci_execute($stmt)) {
         $e = oci_error();
         $this->setMensaje("Error al obtener el detalle de las claves foráneas de la tabla o vista '{$this->objectName}' - {$e['message']}");
         $this->setEstado(false);
     }
     while ($row = oci_fetch_array($stmt, OCI_ASSOC | OCI_RETURN_NULLS)) {
         $foreignKey = new ForeignKey();
         $foreignKey->setConstraintName($row['CONSTRAINT_NAME']);
         $foreignKey->setTableName($row['TABLE_NAME']);
         $foreignKey->setColumnName($row['COLUMN_NAME']);
         $foreignKey->setReferenceConstraintName($row['R_CONSTRAINT_NAME']);
         $foreignKey->setReferenceTableName($row['R_TABLE_NAME']);
         $foreignKey->setReferenceColumnName($row['R_COLUMN_NAME']);
         $foreignKey->setStatus($row['STATUS']);
         $this->aForeignKeys[] = $foreignKey;
     }
     return $this->aForeignKeys;
 }