private function _getInfosSequence($table) { $sql = "SELECT sequence_name" . PHP_EOL . " FROM information_schema.sequences" . PHP_EOL . "WHERE sequence_catalog = :p_schema" . PHP_EOL . " AND sequence_name LIKE '" . $table . "%'"; $params = array(':p_schema' => $this->_schemacible); $this->_oVue->setRequete($sql, $params); $sequence = $this->_oVue->fetchOne(); return $sequence; }
public function getViewTables($viewName) { $sql = "SELECT " . " view_definition " . "FROM " . $this->_metaschema . ".VIEWS " . "WHERE table_schema = :p_table_schema " . " AND table_name = :p_view_name"; $params = array(':p_table_schema' => $this->_schemacible, ':p_view_name' => $viewName); $this->_oVue->setRequete($sql, $params); $definition = $this->_oVue->fetchOne(); if (is_null($this->_oSelectTablesName)) { $this->_oSelectTablesName = new selectTablesNames(); } $this->_oSelectTablesName->setNewQuery($definition); $aTables = $this->_oSelectTablesName->getTables(true); return $aTables; }