<?xml version="1.0" encoding="UTF-8"?>
<config xmlns="http://www.knime.org/2008/09/XMLConfig" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.knime.org/2008/09/XMLConfig http://www.knime.org/XMLConfig_2008_09.xsd" key="DBSession">
    <config key="Session Info">
        <entry key="sessionID" type="xstring" value="b8a83963-b0d7-4092-812d-712a36c37ae5"/>
        <entry key="dbTypeId" type="xstring" value="default"/>
        <entry key="dialectId" type="xstring" value="mysql"/>
    </config>
    <config key="Driver Definition">
        <entry key="driverId" type="xstring" value="Mariadb"/>
        <entry key="driverName" type="xstring" value="MariaDBonLocal"/>
        <entry key="driverVersion" type="xstring" value="3.4.0"/>
        <entry key="driverClass" type="xstring" value="org.mariadb.jdbc.Driver"/>
        <entry key="driverDescription" type="xstring" value=""/>
        <entry key="driverOrigin" type="xstring" value="USER"/>
        <entry key="deprecated" type="xboolean" value="false"/>
    </config>
    <config key="Attributes">
        <config key="org.knime.database.util.DerivableProperties">
            <config key="knime.db.connection.jdbc.properties">
                <config key="values">
                    <entry key="allowLoadLocalInfile" type="xstring" value="true"/>
                </config>
                <config key="types">
                    <entry key="allowLoadLocalInfile" type="xstring" value="LITERAL"/>
                </config>
            </config>
        </config>
    </config>
    <config key="DBData">
        <entry key="sqlQuery" type="xstring" value="SELECT * FROM `weatherdata`.`test_table`"/>
        <config key="knimeSpec">
            <entry key="spec_name" type="xstring" value="database"/>
            <entry key="number_columns" type="xint" value="7"/>
            <config key="column_spec_0">
                <entry key="column_name" type="xstring" value="RecDate"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.time.localdatetime.LocalDateTimeCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
            <config key="column_spec_1">
                <entry key="column_name" type="xstring" value="WindDir"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.def.DoubleCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
            <config key="column_spec_2">
                <entry key="column_name" type="xstring" value="SLPressure"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.def.DoubleCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
            <config key="column_spec_3">
                <entry key="column_name" type="xstring" value="Date_part"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.time.localdate.LocalDateCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
            <config key="column_spec_4">
                <entry key="column_name" type="xstring" value="Comments"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.def.StringCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
            <config key="column_spec_5">
                <entry key="column_name" type="xstring" value="Imputed"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.def.StringCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
            <config key="column_spec_6">
                <entry key="column_name" type="xstring" value="Method"/>
                <config key="element_names">
                    <entry key="array-size" type="xint" value="0"/>
                </config>
                <config key="column_type">
                    <entry key="cell_class" type="xstring" value="org.knime.core.data.def.StringCell"/>
                </config>
                <config key="column_domain"/>
                <config key="column_properties"/>
                <config key="meta_data"/>
            </config>
        </config>
        <config key="dbSpec">
            <config key="dbCol_0">
                <entry key="colName" type="xstring" value="RecDate"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="DATETIME"/>
                <entry key="colType" type="xstring" value="TIMESTAMP"/>
            </config>
            <config key="dbCol_1">
                <entry key="colName" type="xstring" value="WindDir"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="DECIMAL"/>
                <entry key="colType" type="xstring" value="DECIMAL"/>
            </config>
            <config key="dbCol_2">
                <entry key="colName" type="xstring" value="SLPressure"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="DECIMAL"/>
                <entry key="colType" type="xstring" value="DECIMAL"/>
            </config>
            <config key="dbCol_3">
                <entry key="colName" type="xstring" value="Date_part"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="DATE"/>
                <entry key="colType" type="xstring" value="DATE"/>
            </config>
            <config key="dbCol_4">
                <entry key="colName" type="xstring" value="Comments"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="VARCHAR"/>
                <entry key="colType" type="xstring" value="VARCHAR"/>
            </config>
            <config key="dbCol_5">
                <entry key="colName" type="xstring" value="Imputed"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="VARCHAR"/>
                <entry key="colType" type="xstring" value="VARCHAR"/>
            </config>
            <config key="dbCol_6">
                <entry key="colName" type="xstring" value="Method"/>
                <entry key="colAlias" type="xstring" isnull="true" value=""/>
                <entry key="colTypeName" type="xstring" value="VARCHAR"/>
                <entry key="colType" type="xstring" value="VARCHAR"/>
            </config>
        </config>
    </config>
</config>
