summaryrefslogtreecommitdiffstats
path: root/codebase/DataStorage/PostgreDBDataWrapper.php
diff options
context:
space:
mode:
authorEgor <egor.26.93@gmail.com>2015-06-11 16:01:20 +0300
committerEgor <egor.26.93@gmail.com>2015-06-11 16:01:20 +0300
commit5992398183bf84c87dd4315d1532d10022718e9b (patch)
treec192dec5f76a7875265659d42dc2a5be22fc319b /codebase/DataStorage/PostgreDBDataWrapper.php
parent388e84730286a153c12a77d9f19215f2b74c5c4f (diff)
downloadconnector-php-5992398183bf84c87dd4315d1532d10022718e9b.zip
connector-php-5992398183bf84c87dd4315d1532d10022718e9b.tar.gz
connector-php-5992398183bf84c87dd4315d1532d10022718e9b.tar.bz2
Changed psr-4 structure to psr-0. Added connectors for phpcake, codeigniter frameworks.
Diffstat (limited to 'codebase/DataStorage/PostgreDBDataWrapper.php')
-rw-r--r--codebase/DataStorage/PostgreDBDataWrapper.php70
1 files changed, 0 insertions, 70 deletions
diff --git a/codebase/DataStorage/PostgreDBDataWrapper.php b/codebase/DataStorage/PostgreDBDataWrapper.php
deleted file mode 100644
index 56eaa48..0000000
--- a/codebase/DataStorage/PostgreDBDataWrapper.php
+++ /dev/null
@@ -1,70 +0,0 @@
-<?php
-
-namespace DHTMLX\Connector\DataStorage;
-
-use DHTMLX\Connector\Tools\LogMaster;
-
-class PostgreDBDataWrapper extends DBDataWrapper{
- public function query($sql){
- LogMaster::log($sql);
-
- $res=pg_query($this->connection,$sql);
- if ($res===false) throw new \Exception("Postgre - sql execution failed\n".pg_last_error($this->connection));
-
- return $res;
- }
-
- protected function select_query($select,$from,$where,$sort,$start,$count){
- if (!$from)
- return $select;
-
- $sql="SELECT ".$select." FROM ".$from;
- if ($where) $sql.=" WHERE ".$where;
- if ($sort) $sql.=" ORDER BY ".$sort;
- if ($start || $count)
- $sql.=" OFFSET ".$start." LIMIT ".$count;
- return $sql;
- }
-
- public function get_next($res){
- return pg_fetch_assoc($res);
- }
-
- public function get_new_id(){
- $res = pg_query( $this->connection, "SELECT LASTVAL() AS seq");
- $data = pg_fetch_assoc($res);
- pg_free_result($res);
- return $data['seq'];
- }
-
- public function escape($data){
- //need to use oci_bind_by_name
- return pg_escape_string($this->connection,$data);
- }
-
- public function tables_list() {
- $sql = "SELECT table_name FROM information_schema.tables WHERE table_schema = 'public'";
- $res = pg_query($this->connection, $sql);
- $tables = array();
- while ($table = pg_fetch_assoc($res)) {
- $tables[] = $table['table_name'];
- }
- return $tables;
- }
-
- public function fields_list($table) {
- $sql = "SELECT * FROM information_schema.constraint_column_usage";
- $result = pg_query($this->connection, $sql);
- $field = pg_fetch_assoc($result);
- $id = $field['column_name'];
-
- $sql = "SELECT * FROM information_schema.columns WHERE table_name ='".$table."';";
- $result = pg_query($this->connection, $sql);
- $fields = array();
- $id = "";
- while ($field = pg_fetch_assoc($result)) {
- $fields[] = $field["column_name"];
- }
- return array('fields' => $fields, 'key' => $id );
- }
-} \ No newline at end of file