| | |
| | | */ |
| | | class rcube_db_pgsql extends rcube_db |
| | | { |
| | | public $db_provider = 'postgres'; |
| | | |
| | | /** |
| | | * Get last inserted record ID |
| | | * For Postgres databases, a table name is required |
| | | * |
| | | * @param string $table Table name (to find the incremented sequence) |
| | | * @param string $table Table name (to find the incremented sequence) |
| | | * |
| | | * @return mixed ID or false on failure |
| | | * @return mixed ID or false on failure |
| | | */ |
| | | public function insert_id($table = '') |
| | | public function insert_id($table = null) |
| | | { |
| | | if (!$this->db_connected || $this->db_mode == 'r') { |
| | | return false; |
| | |
| | | } |
| | | |
| | | /** |
| | | * Return correct name for a specific database sequence |
| | | * |
| | | * @param string $sequence Secuence name |
| | | * |
| | | * @return string Translated sequence name |
| | | */ |
| | | protected function sequence_name($sequence) |
| | | { |
| | | $rcube = rcube::get_instance(); |
| | | |
| | | // return sequence name if configured |
| | | $config_key = 'db_sequence_'.$sequence; |
| | | |
| | | if ($name = $rcube->config->get($config_key)) { |
| | | return $name; |
| | | } |
| | | |
| | | return $sequence; |
| | | } |
| | | |
| | | /** |
| | | * Return SQL statement to convert a field value into a unix timestamp |
| | | * |
| | | * This method is deprecated and should not be used anymore due to limitations |
| | | * of timestamp functions in Mysql (year 2038 problem) |
| | | * |
| | | * @param string $field Field name |
| | | * @param string $field Field name |
| | | * |
| | | * @return string SQL statement to use in query |
| | | * @return string SQL statement to use in query |
| | | * @deprecated |
| | | */ |
| | | public function unixtimestamp($field) |
| | |
| | | /** |
| | | * Return SQL statement for case insensitive LIKE |
| | | * |
| | | * @param string $column Field name |
| | | * @param string $value Search value |
| | | * @param string $column Field name |
| | | * @param string $value Search value |
| | | * |
| | | * @return string SQL statement to use in query |
| | | * @return string SQL statement to use in query |
| | | */ |
| | | public function ilike($column, $value) |
| | | { |
| | |
| | | /** |
| | | * Get database runtime variables |
| | | * |
| | | * @param string $varname Variable name |
| | | * @param mixed $default Default value if variable is not set |
| | | * @param string $varname Variable name |
| | | * @param mixed $default Default value if variable is not set |
| | | * |
| | | * @return mixed Variable value or default |
| | | */ |