[Nhibernate-commit] nhibernate/src/NHibernate/Dialect PostgreSQLDialect.cs,1.6,1.7

[Michael D. <mik...@us...>]

Update of /cvsroot/nhibernate/nhibernate/src/NHibernate/Dialect
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv32110/Dialect

Modified Files:
	PostgreSQLDialect.cs 
Log Message:
Added PostgreSQL driver from NH-114

Index: PostgreSQLDialect.cs
===================================================================
RCS file: /cvsroot/nhibernate/nhibernate/src/NHibernate/Dialect/PostgreSQLDialect.cs,v
retrieving revision 1.6
retrieving revision 1.7
diff -C2 -d -r1.6 -r1.7
*** PostgreSQLDialect.cs	11 Jul 2004 21:04:13 -0000	1.6
--- PostgreSQLDialect.cs	19 Sep 2004 15:32:34 -0000	1.7
***************
*** 2,60 ****
  using System.Data;
  
! namespace NHibernate.Dialect {
  
  	/// <summary>
  	///  An SQL dialect for PostgreSQL.
  	/// </summary>
! 	public class PostgreSQLDialect : Dialect {
! 
! 		public PostgreSQLDialect()	{
  
- 			/* Java mapping was:
- 			Types.BIT, "BOOL" );
- 			Types.BIGINT, "INT8" );
- 			Types.SMALLINT, "INT2" );
- 			Types.TINYINT, "INT2" );
- 			Types.INTEGER, "INT4" );
- 			Types.CHAR, "CHAR(1)" );
- 			Types.VARCHAR, "VARCHAR($l)"
- 			Types.FLOAT, "FLOAT4" );
- 			Types.DOUBLE, "FLOAT8" );
- 			Types.DATE, "DATE" );
- 			Types.TIME, "TIME" );
- 			Types.TIMESTAMP, "TIMESTAMP"
- 			Types.VARBINARY, "BYTEA" );
- 			Types.CLOB, "TEXT" );
- 			Types.BLOB, "BYTEA" );
- 			Types.NUMERIC, "NUMERIC" );
- 			*/
  			DefaultProperties[Cfg.Environment.OuterJoin] = "true";
! 			DefaultProperties[Cfg.Environment.StatementBatchSize] = DefaultBatchSize;
! 			
  		}
  
! 		public override string AddColumnString {
  			get { return "add column"; }
  		}
! 		public override bool DropConstraints {
  			get { return false; }
  		}
! 		public override string GetSequenceNextValString(string sequenceName) {
  			return string.Concat( "select nextval ('", sequenceName, "')" );
  		}
! 		public override string GetCreateSequenceString(string sequenceName) {
  			return "create sequence " + sequenceName;
  		}
! 		public override string GetDropSequenceString(string sequenceName) {
  			return "drop sequence " + sequenceName;
  		}
! 	
! 		public override string CascadeConstraintsString {
! 			get { return " cascade"; }
  		}
! 	
! 		public override bool SupportsSequences {
  			get { return true; }
  		}
  	}
! }
\ No newline at end of file
--- 2,116 ----
  using System.Data;
  
! using NHibernate.SqlCommand;
! using NHibernate.SqlTypes;
  
+ namespace NHibernate.Dialect 
+ {
  	/// <summary>
  	///  An SQL dialect for PostgreSQL.
  	/// </summary>
! 	public class PostgreSQLDialect : Dialect 
! 	{
! 		public PostgreSQLDialect()	
! 		{
! 			Register( DbType.AnsiStringFixedLength, "char(255)");
! 			Register( DbType.AnsiStringFixedLength, 8000, "char($1)" );
! 			Register( DbType.AnsiString, "varchar(255)" );
! 			Register( DbType.AnsiString, 8000, "varchar($1)" );
! 			Register( DbType.AnsiString, 2147483647, "text");
! 			Register( DbType.Binary, 2147483647, "bytea" );
! 			Register( DbType.Boolean, "boolean" ); 
! 			Register( DbType.Byte, "int2" );
! 			Register( DbType.Currency, "decimal(16,4)");
! 			Register( DbType.Date, "date");
! 			Register( DbType.DateTime, "timestamp" );
! 			Register( DbType.Decimal, "decimal(18,0)" ); // NUMERIC(18,0) is equivalent to DECIMAL(18,0)
! 			Register( DbType.Decimal, 18, "decimal(18, $1)");
! 			Register( DbType.Double, "float8" ); 
! 			Register( DbType.Int16, "int2" );
! 			Register( DbType.Int32, "int4" );
! 			Register( DbType.Int64, "int8" );
! 			Register( DbType.Single, "float4" ); 
! 			Register( DbType.StringFixedLength, "char(255)");
! 			Register( DbType.StringFixedLength, 4000, "char($1)");
! 			Register( DbType.String, "varchar(255)" );
! 			Register( DbType.String, 4000, "varchar($1)" );
! 			Register( DbType.String, 1073741823, "text" );//
! 			Register( DbType.Time, "time" );
  
  			DefaultProperties[Cfg.Environment.OuterJoin] = "true";
! 			DefaultProperties[Cfg.Environment.StatementBatchSize] = NoBatch;
  		}
  
! 		public override string AddColumnString 
! 		{
  			get { return "add column"; }
  		}
! 
! 		public override bool DropConstraints 
! 		{
  			get { return false; }
  		}
! 
! 		public override string CascadeConstraintsString
! 		{
! 			get { return " cascade"; }
! 		}
! 
! 		public override string GetSequenceNextValString(string sequenceName) 
! 		{
  			return string.Concat( "select nextval ('", sequenceName, "')" );
  		}
! 
! 		public override string GetCreateSequenceString(string sequenceName) 
! 		{
  			return "create sequence " + sequenceName;
  		}
! 
! 		public override string GetDropSequenceString(string sequenceName) 
! 		{
  			return "drop sequence " + sequenceName;
  		}
! 		
! 		public override bool SupportsSequences 
! 		{
! 			get { return true; }
  		}
! 
! 		public override bool SupportsLimit
! 		{
! 			get	{ return true; }
! 		}
! 
! 		public override string GetLimitString(String querySelect)
! 		{
! 			return querySelect + " limit ? offset ? ";
! 		}
! 		
! 		public override SqlString GetLimitString(SqlString querySqlString)
! 		{
! 			Parameter p1 = new Parameter();
! 			Parameter p2 = new Parameter();
! 
! 			p1.Name = "p1";
! 			p1.SqlType = new Int16SqlType();
! 
! 			p2.Name = "p2";
! 			p2.SqlType = new Int16SqlType();
! 
! 			SqlStringBuilder pagingBuilder = new SqlStringBuilder();
! 			pagingBuilder.Add(querySqlString);
! 			pagingBuilder.Add(" limit ");
! 			pagingBuilder.Add(p1);
! 			pagingBuilder.Add(" offset ");
! 			pagingBuilder.Add(p2);
! 
! 			return pagingBuilder.ToSqlString();
! 		}
! 
! 		public override bool SupportsForUpdateOf
! 		{
  			get { return true; }
  		}
  	}
! }