DBD-TreeData

 view release on metacpan or  search on metacpan

README.html  view on Meta::CPAN

    ],</pre>

<p>Would create the following tables:</p>

<pre>    &#60;main_table&#62;
       address_component_groups
          address_components
             type_groups
                types</pre>

<p>In this case, <code>address_components</code> has most of the columns and data, but it also has a tie to an ID of <code>address_component_groups</code>.</p>

<p>Since <code>types</code> points to an array, it will have its own dedicated table. That table would have data like:</p>

<pre>    type_id &#9474; type
    &#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9578;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;&#9552;
          1 &#9474; street_number
          2 &#9474; establishment
          3 &#9474; route
          4 &#9474; locality
          5 &#9474; political
        ... &#9474; ...</pre>

<p>Most of the <code>type_groups</code> table would be a 1:1 match. However, the last component entry has more than one value in the <code>types</code> array, so the <code>type_group_id</code> associated to that component would have multiple entries ...

<h1><a class='u'
name="CAVEATS"
>CAVEATS</a></h1>

<h2><a class='u'
name="DBI_/_DBD::AnyData_Conflict"
>DBI / DBD::AnyData Conflict</a></h2>

<p>As of the time of this writing, the latest version of <a href="http://search.cpan.org/perldoc?DBI" class="podlinkpod"
>DBI</a> (1.623) and the latest version of <a href="http://search.cpan.org/perldoc?DBD%3A%3AAnyData" class="podlinkpod"
>DBD::AnyData</a> (0.110) do not work together. Since TreeData relies on <a href="http://search.cpan.org/perldoc?DBD%3A%3AAnyData" class="podlinkpod"
>DBD::AnyData</a> for table creation, you will need to downgrade to <a href="http://search.cpan.org/perldoc?DBI" class="podlinkpod"
>DBI</a> 1.622 to use this driver, until a new version of <a href="http://search.cpan.org/perldoc?DBD%3A%3AAnyData" class="podlinkpod"
>DBD::AnyData</a> comes out.</p>

<h1><a class='u'
name="AVAILABILITY"
>AVAILABILITY</a></h1>

<p>The project homepage is <a href="https://github.com/SineSwiper/DBD-TreeData/wiki" class="podlinkurl"
>https://github.com/SineSwiper/DBD-TreeData/wiki</a>.</p>

<p>The latest version of this module is available from the Comprehensive Perl Archive Network (CPAN). Visit <a href="http://www.perl.com/CPAN/" class="podlinkurl"
>http://www.perl.com/CPAN/</a> to find a CPAN site near you, or see <a href="https://metacpan.org/module/DBD::TreeData/" class="podlinkurl"
>https://metacpan.org/module/DBD::TreeData/</a>.</p>

<h1><a class='u'
name="SUPPORT"
>SUPPORT</a></h1>

<h2><a class='u'
name="Internet_Relay_Chat"
>Internet Relay Chat</a></h2>

<p>You can get live help by using IRC ( Internet Relay Chat ). If you don&#39;t know what IRC is, please read this excellent guide: <a href="http://en.wikipedia.org/wiki/Internet_Relay_Chat" class="podlinkurl"
>http://en.wikipedia.org/wiki/Internet_Relay_Chat</a>. Please be courteous and patient when talking to us, as we might be busy or sleeping! You can join those networks/channels and get help:</p>

<ul>
<li>irc.perl.org
<p>You can connect to the server at &#39;irc.perl.org&#39; and join this channel: #dbi then talk to this person for help: SineSwiper.</p>
</li>
</ul>

<h2><a class='u'
name="Bugs_/_Feature_Requests"
>Bugs / Feature Requests</a></h2>

<p>Please report any bugs or feature requests via <a href="http://search.cpan.org/perldoc?GitHub" class="podlinkpod"
><a href="https://github.com/SineSwiper/DBD-TreeData/issues" class="podlinkurl"
>https://github.com/SineSwiper/DBD-TreeData/issues</a></a>.</p>

<h1><a class='u'
name="AUTHOR"
>AUTHOR</a></h1>

<p>Brendan Byrd &#60;BBYRD@CPAN.org&#62;</p>

<h1><a class='u'
name="COPYRIGHT_AND_LICENSE"
>COPYRIGHT AND LICENSE</a></h1>

<p>This software is Copyright (c) 2013 by Brendan Byrd.</p>

<p>This is free software, licensed under:</p>

<pre>  The Artistic License 2.0 (GPL Compatible)</pre>

<!-- end doc -->

</body></html>



( run in 1.155 second using v1.01-cache-2.11-cpan-39bf76dae61 )