evolution-cms / evolution

     * @license New BSD License

     * @link http://ezcomponents.org/docs/api/trunk/DatabaseSchema/ezcDbSchemaOracleReader.html

     */

    public function getListTableIndexesSQL($table, $currentDatabase = null)

    {

        $table = $this->normalizeIdentifier($table);

        $table = $this->quoteStringLiteral($table->getName());

        return "SELECT uind_col.index_name AS name,

                       (

                           SELECT uind.index_type

                           FROM   user_indexes uind

                           WHERE  uind.index_name = uind_col.index_name

                       ) AS type,

                       decode(

                           (

                               SELECT uind.uniqueness

                               FROM   user_indexes uind

                               WHERE  uind.index_name = uind_col.index_name

                           ),

                           'NONUNIQUE',

                           0,

                           'UNIQUE',

                           1

                       ) AS is_unique,

                       uind_col.column_name AS column_name,

                       uind_col.column_position AS column_pos,

                       (

                           SELECT ucon.constraint_type

                           FROM   user_constraints ucon

                           WHERE  ucon.index_name = uind_col.index_name

                       ) AS is_primary

             FROM      user_ind_columns uind_col

             WHERE     uind_col.table_name = " . $table . "

             ORDER BY  uind_col.column_position ASC";

    }

    /**

     * {@inheritDoc}

    /**

     * {@inheritDoc}

     */

    public function getListTableForeignKeysSQL($table)

    {

        $table = $this->normalizeIdentifier($table);

        $table = $this->quoteStringLiteral($table->getName());

        return "SELECT alc.constraint_name,

          alc.DELETE_RULE,

          cols.column_name \"local_column\",

          cols.position,

          (

              SELECT r_cols.table_name

              FROM   user_cons_columns r_cols

              WHERE  alc.r_constraint_name = r_cols.constraint_name

              AND    r_cols.position = cols.position

          ) AS \"references_table\",

          (

              SELECT r_cols.column_name

              FROM   user_cons_columns r_cols

              WHERE  alc.r_constraint_name = r_cols.constraint_name

              AND    r_cols.position = cols.position

          ) AS \"foreign_column\"

     FROM user_cons_columns cols

     JOIN user_constraints alc

       ON alc.constraint_name = cols.constraint_name

      AND alc.constraint_type = 'R'

      AND alc.table_name = " . $table . "

    ORDER BY cols.constraint_name ASC, cols.position ASC";

    }

    /**

     * {@inheritDoc}