public static LinkedHashMap < String , String > getProjectMetadata ( IHMConnection connection ) throws Exception { LinkedHashMap < String , String > metadataMap = new LinkedHashMap <> ( ) ; try ( IHMStatement statement = connection . createStatement ( ) ) { statement . setQueryTimeout ( 30 ) ; // set timeout to 30 sec. String sql = "select " + MetadataTableFields . COLUMN_KEY . getFieldName ( ) + ", " + // MetadataTableFields . COLUMN_VALUE . getFieldName ( ) + " from " + TABLE_METADATA ; IHMResultSet rs = statement . executeQuery ( sql ) ; while ( rs . next ( ) ) { String key = rs . getString ( MetadataTableFields . COLUMN_KEY . getFieldName ( ) ) ; String value = rs . getString ( MetadataTableFields . COLUMN_VALUE . getFieldName ( ) ) ; if ( ! key . endsWith ( "ts" ) ) { metadataMap . put ( key , value ) ; } else { try { long ts = Long . parseLong ( value ) ; String dateTimeString = ETimeUtilities . INSTANCE . TIME_FORMATTER_LOCAL . format ( new Date ( ts ) ) ; metadataMap . put ( key , dateTimeString ) ; } catch ( Exception e ) { metadataMap . put ( key , value ) ; } } } } return metadataMap ; }
Get the map of metadata of the project .