<?php
class LtDbSqlAdapterPgsql implements LtDbSqlAdapter
{
	public function setCharset($charset)
	{
		return "SET client_encoding TO '$charset'";
	}
	public function setSchema($schema)
	{
		return "SET search_path TO $schema";
	}

	public function beginTransaction()
	{
		return "";
	}
	public function commit()
	{
		return "";
	}
	public function rollBack()
	{
		return "";
	}

	public function showSchemas($database)
	{

	}
	public function showTables($schema)
	{
		return "SELECT case when n.nspname='public' then c.relname else n.nspname||'.'||c.relname end as relname 
				FROM pg_class c join pg_namespace n on (c.relnamespace=n.oid)
				WHERE c.relkind = 'r'
					AND n.nspname NOT IN ('information_schema','pg_catalog')
					AND n.nspname NOT LIKE 'pg_temp%'
					AND n.nspname NOT LIKE 'pg_toast%'
				ORDER BY relname";
	}
	public function showFields($table)
	{
		return "SELECT a.attnum, a.attname AS field, t.typname AS type, 
				format_type(a.atttypid, a.atttypmod) AS complete_type, 
				a.attnotnull AS isnotnull, 
				( SELECT 't' FROM pg_index 
				WHERE c.oid = pg_index.indrelid 
				AND pg_index.indkey[0] = a.attnum 
				AND pg_index.indisprimary = 't') AS pri, 
				(SELECT pg_attrdef.adsrc FROM pg_attrdef 
				WHERE c.oid = pg_attrdef.adrelid 
				AND pg_attrdef.adnum=a.attnum) AS default 
				FROM pg_attribute a, pg_class c, pg_type t 
				WHERE c.relname = '$table' 
				AND a.attnum > 0 
				AND a.attrelid = c.oid 
				AND a.atttypid = t.oid 
				ORDER BY a.attnum";
	}

	public function limit($limit, $offset)
	{
		return " LIMIT $limit OFFSET $offset";
	}

	public function getSchemas($queryResult)
	{
		
	}
	public function getTables($queryResult)
	{
		
	}
	public function getFields($queryResult)
	{
		
	}
	public function detectQueryType($sql)
	{
		
	}
}