[FEATURE]postgres provider: add support for timestamp types

jef-n · jef-n · commit f6e4e75cd625 · 2015-11-18T19:23:03.000+01:00
diff --git a/src/gui/editorwidgets/qgsdatetimeedit.cpp b/src/gui/editorwidgets/qgsdatetimeedit.cpp
@@ -136,7 +136,3 @@ void QgsDateTimeEdit::resizeEvent( QResizeEvent * event )
   mNullLabel->setMinimumSize( rect().adjusted( 0, 0, -spinButtonWidth(), 0 ).size() );
   mNullLabel->setMaximumSize( rect().adjusted( 0, 0, -spinButtonWidth(), 0 ).size() );
 }
-
-
-
-
diff --git a/src/gui/editorwidgets/qgsdatetimeeditwrapper.cpp b/src/gui/editorwidgets/qgsdatetimeeditwrapper.cpp
@@ -106,6 +106,18 @@ QVariant QgsDateTimeEditWrapper::value()
   if ( !mQDateTimeEdit )
     return QVariant( field().type() );
 
+  if ( field().type() == QVariant::DateTime )
+  {
+    if ( mQgsDateTimeEdit )
+    {
+      return mQgsDateTimeEdit->dateTime();
+    }
+    else
+    {
+      return mQDateTimeEdit->dateTime();
+    }
+  }
+
   const QString fieldFormat = config( "field_format", QGSDATETIMEEDIT_DATEFORMAT ).toString();
 
   if ( mQgsDateTimeEdit )
@@ -124,7 +136,7 @@ void QgsDateTimeEditWrapper::setValue( const QVariant &value )
     return;
 
   const QString fieldFormat = config( "field_format", QGSDATETIMEEDIT_DATEFORMAT ).toString();
-  const QDateTime date = QDateTime::fromString( value.toString(), fieldFormat );
+  const QDateTime date = field().type() == QVariant::DateTime ? value.toDateTime() : QDateTime::fromString( value.toString(), fieldFormat );
 
   if ( mQgsDateTimeEdit )
   {
diff --git a/src/providers/postgres/qgspostgresprovider.cpp b/src/providers/postgres/qgspostgresprovider.cpp
@@ -878,6 +878,11 @@ bool QgsPostgresProvider::loadFields()
         fieldType = QVariant::Date;
         fieldSize = -1;
       }
+      else if ( fieldTypeName == "timestamp" )
+      {
+        fieldType = QVariant::DateTime;
+        fieldSize = -1;
+      }
       else if ( fieldTypeName == "text" ||
                 fieldTypeName == "bool" ||
                 fieldTypeName == "geometry" ||

Original file line number	Diff line number	Diff line change
`@@ -136,7 +136,3 @@ void QgsDateTimeEdit::resizeEvent( QResizeEvent * event )`
`136`	`136`	`mNullLabel->setMinimumSize( rect().adjusted( 0, 0, -spinButtonWidth(), 0 ).size() );`
`137`	`137`	`mNullLabel->setMaximumSize( rect().adjusted( 0, 0, -spinButtonWidth(), 0 ).size() );`
`138`	`138`	`}`
`139`		`-`
`140`		`-`
`141`		`-`
`142`		`-`