˛∫æ���2Û
�è	�
	�
	�
 
�
!	�
"
#$	�
%&
�	'
�(
�

�
)
�
*
�
+
�
,
�
-
�
.
�
/	012
�3
�4
�56
�7
89
�
:;
<=	�
>�ñ
<?	�
@�ó	�
A�ò	�
B�ô	�
CD�õ	�
E�ú	�
F�ù	�
G�û�æH
IJ
KL�º
KMNOP
�;Q
RSTU
8V
�?QW
�CX
YZ[
�CQ\]^
�IX
�I_`
�Lab
�Na
�;a	�
c
#def
#gh
#ij
#kl
�mno
#pq
#rs
�ptuv
�cX
Kwx
�NQyz{
�k|
�p}
~
ÄÅÇÉ
�qÑ
�sÖ
�qÜá
�và
�qâä
�yãå
�{ç
�qéè
�qêë
#íìîïîñóòô
�;Xî]öõú
�åX	�
ùûü�CONFIG_NAME�Ljava/lang/String;�
ConstantValue�options�Ljava/util/ResourceBundle;�dbDriver�dbURL�dbUser�
dbPassword�databaseAdapterName�documentURL�
entityName�	packageID�qualityReporting�Ljava/lang/Boolean;�dataManager�,Lorg/ecoinformatics/datamanager/DataManager;�metadataInputStream�Ljava/io/InputStream;�dataPackage�3Lorg/ecoinformatics/datamanager/parser/DataPackage;�dsi�>Lorg/ecoinformatics/datamanager/download/DataStorageInterface;�eepi�BLorg/ecoinformatics/datamanager/download/EcogridEndPointInterface;�<init>�()V�Code�LineNumberTable�LocalVariableTable�this�8Lorg/ecoinformatics/datamanager/sample/SampleCallingApp;�main�([Ljava/lang/String;)V�args�[Ljava/lang/String;�success�Z�dmm�
StackMapTable(�
Exceptions�loadOptions�emlDereferencerXSLT�qualityReportingStr�qualityReportTemplate�e�Ljava/lang/Exception;†O�getDBAdapterName�()Ljava/lang/String;�
getConnection�()Ljava/sql/Connection;�"Ljava/lang/ClassNotFoundException;�Ljava/sql/SQLException;�
connection�Ljava/sql/Connection;°TW¢�returnConnection�(Ljava/sql/Connection;)Z�conn�setUp�url�Ljava/net/URL;� Ljava/net/MalformedURLException;�Ljava/io/IOException;`b�tearDown�testDownloadData�()Z�dataStorageList�?[Lorg/ecoinformatics/datamanager/download/DataStorageInterface;�›�testEnumerationMethods�i�I�	tableName�
fieldNames�¥�testLoadDataToDB�testParseMetadata�testQualityReport�qualityReportFile�Ljava/io/File;�
qualityReport�6Lorg/ecoinformatics/datamanager/quality/QualityReport;£u�testSelectData�count�
entityList�/[Lorg/ecoinformatics/datamanager/parser/Entity;�
attributes�2[Lorg/ecoinformatics/datamanager/parser/Attribute;�dataPackages�4[Lorg/ecoinformatics/datamanager/parser/DataPackage;�query�/Lorg/ecoinformatics/datamanager/database/Query;�
selectionItem�7Lorg/ecoinformatics/datamanager/database/SelectionItem;�	tableItem�3Lorg/ecoinformatics/datamanager/database/TableItem;�	condition�3Lorg/ecoinformatics/datamanager/database/Condition;�whereClause�5Lorg/ecoinformatics/datamanager/database/WhereClause;�
attributeList�5Lorg/ecoinformatics/datamanager/parser/AttributeList;�	attribute�1Lorg/ecoinformatics/datamanager/parser/Attribute;�entity�.Lorg/ecoinformatics/datamanager/parser/Entity;�operator�intValue�value�Ljava/lang/Integer;�	resultSet�Ljava/sql/ResultSet;§•¶{ß�Ò�Û�ıÉÑáäå®�<clinit>�
SourceFile�SampleCallingApp.java�™�´�¢�£�¶�ß�®�©�ª�´�ö�í©™´�†�°�7org/ecoinformatics/datamanager/sample/SampleDataStorage�5org/ecoinformatics/datamanager/sample/EcogridEndPoint�6org/ecoinformatics/datamanager/sample/SampleCallingApp�“�´�Ê�€�⁄�€�Â�€�Ó�€�fl�€�Á�€¨≠Æ�java/lang/StringBuilder�Finished all tests, success = Ø∞ر�
≤�ƒ≥¥µ�Ÿ�´�datamanager∂∑∏�î�ïπ∫�ñ�í�ó�í�ò�í�ô�í�	dbAdapter�õ�í�ú�í�ù�í�true†ªº£Ωæøµ�false�java/lang/Exception�Error in loading options: ¿�ƒ¡¬√� java/lang/ClassNotFoundException�ClassNotFoundException: ƒµ�java/sql/SQLException�™µ≈�≈∆�SQLException: °«�´�java/net/URL»…�java/net/MalformedURLException �´�java/io/IOException�§�•ÀÃ�Finished dropping tables.
�<org/ecoinformatics/datamanager/download/DataStorageInterfaceÕŒ�'Finished testDownloadData(), success = œ–�tableName: —“�
  fieldNames[Ø”�]: �-Finished testEnumerationMethods(), success = ‘’�'Finished testLoadDataToDB(), success = ÷◊�(Finished testParseMetadata(), success = ÿŸ�java/io/File�/tmp/quality_report.xml⁄€�#Error storing quality report file: �(Finished testQualityReport(), success = �>�java/lang/Integer�™‹›fi¶fl‡§·‚�1org/ecoinformatics/datamanager/parser/DataPackage�-org/ecoinformatics/datamanager/database/Query�5org/ecoinformatics/datamanager/database/SelectionItem�™„‰Â�1org/ecoinformatics/datamanager/database/TableItem�™ÊÁË�1org/ecoinformatics/datamanager/database/Condition�™È�3org/ecoinformatics/datamanager/database/WhereClause�™ÍÎÏ�
Query SQL = 'Ì�ƒ�'ÓÔ�5Printing all records with 'count' value greater than ß�€ÒÚ�
resultSet[�], count =  �resultSet is null�%Exception in DataManager.selectData()�%Finished testSelectData(), success = �java/lang/Boolean�û�ü�java/lang/Object�Gorg/ecoinformatics/datamanager/database/DatabaseConnectionPoolInterface�java/lang/String�java/sql/Connection�Gorg/ecoinformatics/datamanager/database/ConnectionNotAvailableException�4org/ecoinformatics/datamanager/quality/QualityReport�3org/ecoinformatics/datamanager/parser/AttributeList�/org/ecoinformatics/datamanager/parser/Attribute�,org/ecoinformatics/datamanager/parser/Entity�java/sql/ResultSet�java/lang/Throwable�*org/ecoinformatics/datamanager/DataManager�getInstance�â(Lorg/ecoinformatics/datamanager/database/DatabaseConnectionPoolInterface;Ljava/lang/String;)Lorg/ecoinformatics/datamanager/DataManager;�java/lang/System�err�Ljava/io/PrintStream;�append�-(Ljava/lang/String;)Ljava/lang/StringBuilder;�(Z)Ljava/lang/StringBuilder;�toString�java/io/PrintStream�println�(Ljava/lang/String;)V�java/util/ResourceBundle�	getBundle�.(Ljava/lang/String;)Ljava/util/ResourceBundle;�	getString�&(Ljava/lang/String;)Ljava/lang/String;�equalsIgnoreCase�(Ljava/lang/String;)Z�setQualityReporting�(ZLjava/lang/String;)V�setEmlDereferencerXSLTPath�
getMessage�java/lang/Class�forName�%(Ljava/lang/String;)Ljava/lang/Class;�print�java/sql/DriverManager�M(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)Ljava/sql/Connection;�close�
openStream�()Ljava/io/InputStream;�printStackTrace�
dropTables�6(Lorg/ecoinformatics/datamanager/parser/DataPackage;)Z�downloadData�∑(Lorg/ecoinformatics/datamanager/parser/DataPackage;Lorg/ecoinformatics/datamanager/download/EcogridEndPointInterface;[Lorg/ecoinformatics/datamanager/download/DataStorageInterface;)Z�getDBTableName�8(Ljava/lang/String;Ljava/lang/String;)Ljava/lang/String;�getDBFieldNames�9(Ljava/lang/String;Ljava/lang/String;)[Ljava/lang/String;�(I)Ljava/lang/StringBuilder;�loadDataToDB�x(Lorg/ecoinformatics/datamanager/parser/DataPackage;Lorg/ecoinformatics/datamanager/download/EcogridEndPointInterface;)Z�
parseMetadata�J(Ljava/io/InputStream;)Lorg/ecoinformatics/datamanager/parser/DataPackage;�getQualityReport�8()Lorg/ecoinformatics/datamanager/quality/QualityReport;�storeQualityReport�(Ljava/io/File;)Z�(I)V�
getEntityList�1()[Lorg/ecoinformatics/datamanager/parser/Entity;�getAttributeList�7()Lorg/ecoinformatics/datamanager/parser/AttributeList;�
getAttributes�4()[Lorg/ecoinformatics/datamanager/parser/Attribute;�b(Lorg/ecoinformatics/datamanager/parser/Entity;Lorg/ecoinformatics/datamanager/parser/Attribute;)V�addSelectionItem�:(Lorg/ecoinformatics/datamanager/database/SelectionItem;)V�1(Lorg/ecoinformatics/datamanager/parser/Entity;)V�addTableItem�6(Lorg/ecoinformatics/datamanager/database/TableItem;)V�Ü(Lorg/ecoinformatics/datamanager/parser/Entity;Lorg/ecoinformatics/datamanager/parser/Attribute;Ljava/lang/String;Ljava/lang/Object;)V�?(Lorg/ecoinformatics/datamanager/database/ConditionInterface;)V�setWhereClause�8(Lorg/ecoinformatics/datamanager/database/WhereClause;)V�toSQLString�
selectData�y(Lorg/ecoinformatics/datamanager/database/Query;[Lorg/ecoinformatics/datamanager/parser/DataPackage;)Ljava/sql/ResultSet;�next�getInt�(I)I�!�
�è��ê���ë�í��ì���� �
�î�ï���
�ñ�í���
�ó�í���
�ò�í���
�ô�í���
�ö�í���
�õ�í���
�ú�í���
�ù�í���
�û�ü����†�°����¢�£����§�•����¶�ß����®�©�����™�´��¨���Ç�����8*∑�*µ�*µ�*µ�∏�**≤�∏�µ�*ª�	Y∑�
µ�*ª�Y∑�µ�±����≠���&�	���r��V�	�`��e��s��t�!�u�,�v�7�w�Æ�������8�Ø�∞���	�±�≤��¨��!�����ó<ª�
Y∑�M,∑�ô�,∂�ô�ß�<ô�,∂�ô�ß�<ô�,∂�ô�ß�<ô�,∂�ô�ß�<ô�,∂�ô�ß�<ô�,∑�ô�ß�<≤�ª�Y∑�∂�∂�∂�∂�∂�,∑�±����≠���2����Ü��à�
�â��ä��ã�0�å�A�ç�R�é�c�è�t�ê�í�ë�ñ�í�Æ��� ����ó�≥�¥����ï�µ�∂��
�ç�∑�∞��∏����˝��π@@@@@@�∫�����L�N�;�
�ª�´��¨��Ñ�����√ ∏�!≥�"≤�"#∂�$≥�%≤�"&∂�$≥�'≤�"(∂�$≥�)≤�"*∂�$≥�+≤�",∂�$≥�≤�"-∂�$≥�.≤�"/∂�$≥�0≤�"1∂�$≥�2≤�"3∂�$K≤�"4∂�$L*∆�/*5∂�6ô�+∏�7≤�"8∂�$M,∏�9ß�*:∂�6ô�∏�7ß� K≤�ª�Y∑�<∂�*∂�=∂�∂�∂�±����¢�•�;��≠���^����ú��ù��û��ü�)�†�4�°�?�§�J�•�U�¶�`�≠�i�Æ�r�Ø�v�∞��±�Ñ�≤�ç�≥�ë�¥�î�µ�ù�∂�¢�º�•�∫�¶�ª�¬�Ω�Æ���*��ç��º�í��i�9�Ω�í���r�0�æ�í��¶��ø�¿���∏����˝�î�¡�¡˘�
B�¬��√�ƒ��¨���.�����≤�∞����≠�������À�Æ��������Ø�∞����≈�∆��¨�������\L≤�%∏�>Wß�"M≤�@∂�A≤�,∂�B∂�ª�CY,∂�B∑�Dø≤�'≤�)≤�+∏�ELß�"M≤�ª�Y∑�F∂�,∂�G∂�∂�∂�,ø+∞���	��?�+�8�;�C��≠���6�
���⁄��›�	�„��fl�
�‡��·��‚�+�Ê�8�Î�;�Ë�<�È�X�Í�Z�Ì�Æ���*��
��ø�«��<��ø�»����\�Ø�∞����Z�…� ��∏����ˇ���π�À��ÃO�Õ�∫�����C�Œ��œ�–��¨���î�����=+π�H�=ß�N=¨���
�
�;��≠�������˝����
�
���Æ���*����ø�¿�����Ø�∞������—� ����µ�∂��∏����ˇ�
��π�À��¬��“�´��¨���€�����,ª�IY≤�.∑�JL*+∂�Kµ�ß�L+∂�M+øL+∂�O+øL+∂�P+ø±������L�����N����$�;��≠���6�
����#������"�$ �%!�)"�+$�Æ���4����”�‘����ø�’����ø�÷��%��ø�¿����,�Ø�∞���∏����V�◊F�ÿF�¬�∫�����L�N�;��Ÿ�´��¨���[�����*¥�Q∆�*¥�*¥�Q∂�RW≤�S∂�±����≠������1�2�3�5�Æ��������Ø�∞���∏�����∫�����?�C�;��⁄�€��¨���´�����F<Ω�TM,*¥�S*¥�Q∆�*¥�*¥�Q*¥�,∂�U<≤�ª�Y∑�V∂�∂�∂�∂�∂�¨����≠������?�D�F�I�J�&M�DO�Æ��� ����F�Ø�∞����D�µ�∂���?�‹�›��∏���	�˝�&�fi��fl�€��¨��1�����ó<≤�2≤�0∏�WM≤�ª�Y∑�X∂�,∂�∂�∂�≤�2≤�0∏�YN-∆�96-æ¢�/≤�ª�Y∑�Z∂�∂�[\∂�-2∂�∂�∂�Ñߡ–,∆�-∆�ß�<≤�ª�Y∑�]∂�∂�∂�∂�∂�¨����≠���.���a�d�e�%i�/l�3m�=n�cm�is�wt�ïw�Æ���4��6�3�‡�·����ó�Ø�∞����ï�µ�∂���ã�‚�í��/�h�„�¥��∏����ˇ�6��π�¡�‰��˙�2@�∫�����L�N�;��Â�€��¨���â�����9<*¥�Q∆�*¥�*¥�Q*¥�∂�^<≤�ª�Y∑�_∂�∂�∂�∂�∂�¨����≠������Ü�ä�	ã�é�7ê�Æ�������9�Ø�∞����7�µ�∂��∏����¸��∫�����L�N�;��Ê�€��¨���∆�����M<*¥�∆�'**¥�*¥�∂�`µ�Q*¥�Q∆�ß�<ß�M,∂�P≤�ª�Y∑�a∂�∂�∂�∂�∂�¨��	�%�(�;��≠���&�	��ö�ú�	ü�°�%•�(£�)§�-®�K™�Æ��� ��)��ø�¿����M�Ø�∞����K�µ�∂��∏���
�¸�#@C�¬��Á�€��¨�������g<*¥�Q∆�A*¥�Q∂�bM,∆�5ª�cYd∑�eN,-∂�f<ß�":≤�ª�Y∑�g∂�∂�h∂�∂�∂�≤�ª�Y∑�i∂�∂�∂�∂�∂�¨���%�(�N��≠���.���¥�∏�	π�∫�ª�Ω�%¡�(ø�*¿�G≈�e«�Æ���4��*��ø�÷���(�Ë�È���6�Í�Î����g�Ø�∞����e�µ�∂��∏����ˇ�(��π�Ï�Ì��ÿ˘���Ó�€��¨��ª����ùNj:66ª�kY∑�l::*¥�Q∆]*¥�Q∂�m:		2N-∂�nL+∂�o:

2MΩ�p:*¥�QSª�qY∑�r:ª�sY-,∑�t:

∂�uª�vY-∑�w:∂�xª�yY-,∑�z:ª�{Y∑�|:∂�}≤�ª�Y∑�~∂�∂�∂�Ä∂�∂�∂�*¥�∂�Å:∆�d66≤�ª�Y∑�Ç∂�∂�[∂�∂�π�É�ô�7π�Ñ�6≤�ª�Y∑�Ö∂�∂�[Ü∂�∂�[∂�∂�Ñߡ≈ß�
ª�;Yá∑�àø∆�@π�â�ß�6:≤�ª�Y∑�ä∂�∂�=∂�∂�∂�ø:∆�
π�â�ø≤�ª�Y∑�ã∂�∂�∂�∂�∂�¨��º9H�;�º9j��Hlj����≠���∂�-��ÿ�Ÿ�⁄�	€�‹�›�·�!‚�*„�/‰�4Â�:Ê�?Ï�EÌ�MÓ�V�aÒ�hÛ�rÙ�yˆ�à˜�ì¯�ö˚�ºˇ�…�Œ�—�‘�Ó
�¯&
),/9HJ[dgjx{ö!�Æ��� ��'�Ô�·��‘�X�‡�·�J� �ø�¿��*Q��Ò�	�:A�Ú�Û�
�E6�Ù�ı��V%�ˆ�˜��a�¯�˘�
�r	�˙�˚��à�Û�¸�˝��ì�Ë�˛�ˇ��4G���?<���ù�Ø�∞���õ��ó�í��	î�µ�∂��ë�·��Ü	��É
��∏���h�ˇ�Ó��π
�¡��˙�=	N�¬a˛�
��ˇ��	�π���¡���∫�����;��´��¨���m������1≥�"≥�%≥�'≥�)≥�+≥�≥�.≥�0≥�2ª�åY:∑�ç≥�é±����≠���*�
���@��A��B��C��D��E��F��G� �H�$�I����