Commits

Sergio Oliveira committed e5452b9

Adding tz information to solr

  • Participants
  • Parent commits 94ed02e

Comments (0)

Files changed (1)

File solr-conf/data-config.xml

             transformer="TemplateTransformer,DateFormatTransformer"
             query="SELECT
                      name,
-                     TIMESTAMP 'epoch' + (max(time)/1000000) * INTERVAL '1s' AS modified,
+                     TIMESTAMP WITH TIME ZONE 'epoch' + (max(time)/1000000) * INTERVAL '1s' AS modified,
                      max(version) AS version
                    FROM wiki GROUP BY name"
             deltaQuery="
                 wiki
               WHERE
                 time > (EXTRACT(
-                  epoch FROM TIMESTAMP '${dataimporter.wiki.last_index_time}'
+                  epoch FROM TIMESTAMP WITH TIME ZONE '${dataimporter.wiki.last_index_time}'
                 ) * 1000000)"
             deltaImportQuery="
                    SELECT
               dataSource="trac"
               query="SELECT 
                        author AS Creator,
-                       TIMESTAMP 'epoch' + (time/1000000) * INTERVAL '1s' AS created
+                       TIMESTAMP WITH TIME ZONE 'epoch' + (time/1000000) * INTERVAL '1s' AS created
                      FROM 
                        wiki 
                      WHERE
               dataSource="trac"
               query="SELECT 
                        author AS last_author,
-                       TIMESTAMP 'epoch' + (time/1000000) * INTERVAL '1s' AS modified
+                       TIMESTAMP WITH TIME ZONE 'epoch' + (time/1000000) * INTERVAL '1s' AS modified
                      FROM 
                        wiki 
                      WHERE
                   ticket
               WHERE
                 time > (EXTRACT(
-                  epoch FROM TIMESTAMP '${dataimporter.ticket.last_index_time}'
+                  epoch FROM TIMESTAMP WITH TIME ZONE '${dataimporter.ticket.last_index_time}'
                 ) * 1000000)"
             query="SELECT
                      id, 
                      reporter,
                      owner,
                      status,
-                     TIMESTAMP 'epoch' + (time/1000000)* INTERVAL '1s' AS created,
-                     TIMESTAMP 'epoch' + (changetime/1000000) * INTERVAL '1s' AS modified
+                     TIMESTAMP WITH TIME ZONE 'epoch' + (time/1000000)* INTERVAL '1s' AS created,
+                     TIMESTAMP WITH TIME ZONE 'epoch' + (changetime/1000000) * INTERVAL '1s' AS modified
                    FROM
                      ticket">
 
               revision 
             WHERE
               time > (EXTRACT(
-                epoch FROM TIMESTAMP '${dataimporter.changeset.last_index_time}'
+                epoch FROM TIMESTAMP WITH TIME ZONE '${dataimporter.changeset.last_index_time}'
               ) * 1000000)"
 
             query="SELECT
                      author AS Creator,
                      author AS collaborator,
                      repos.value AS repos_name,
-                     TIMESTAMP 'epoch' + (time/1000000) * INTERVAL '1s' AS created,
-                     TIMESTAMP 'epoch' + (time/1000000) * INTERVAL '1s' AS modified,
+                     TIMESTAMP WITH TIME ZONE 'epoch' + (time/1000000) * INTERVAL '1s' AS created,
+                     TIMESTAMP WITH TIME ZONE 'epoch' + (time/1000000) * INTERVAL '1s' AS modified,
                      message                    
                    FROM
                      revision AS rev JOIN