<div dir="ltr">Hi,<div>I am going through the code base (related to mdb) for last two days , but I wanted to know keeping GSOC in mind do I need to focus on research part more (and to go through most of the code base after proposal submission ) or do I need to get in touch with the code (keeping research part after submission ).</div>
<div>Regards Jayesh Hathila</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Feb 21, 2014 at 2:43 AM, Jaroslaw Staniek <span dir="ltr"><<a href="mailto:staniek@kde.org" target="_blank">staniek@kde.org</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="">On 20 February 2014 21:29, Jayesh Hathila <<a href="mailto:sharma.jayesh52@gmail.com">sharma.jayesh52@gmail.com</a>> wrote:<br>
> Hi ,<br>
><br>
> As you said :<br>
><br>
> "If you look at content.xml file, it contains table/column definitions.<br>
> The database/script file you're mentioning contains HSQLDB or other<br>
> backend-specific SQL (yes, there's no respected standard). I am<br>
> guessing the xml is easier to parse than the specific SQL. "<br>
><br>
> I tried to parse content.xml but the problem which I faced is that<br>
> content.xml does not contain every information.For e.g the samples<br>
> downloaded from source provided by you (<br>
> <a href="http://www.floppybunny.org/robin/web/virtualclassroom/chap8/libreoffice_base.html" target="_blank">http://www.floppybunny.org/robin/web/virtualclassroom/chap8/libreoffice_base.html</a><br>
> ) had a file under name "cons2.odb" in which by simply analyzing (after<br>
> unziping .odb file) content.xml file , we don't gets necessary information<br>
> regarding- Primary key and other constraints, and also for some tables it<br>
> doesn't states any column at all which are originally present there in<br>
> database.And regarding tuples (i.e instances or values or data) its present<br>
> in "file_name/database/data" file but under some encoded scheme (till now I<br>
> couldn't found out the scheme,as I haven't thought of it much).So<br>
> considering above issues I think I will have to parse script file only<br>
> (though a little more information can be gathered from setting.xml but that<br>
> will not sufficient) .<br>
> If possible , I would like to have your views about my approach and<br>
> suggestions towards it.<br>
><br>
<br>
<br>
</div>Hi Jayesh,<br>
Thanks for the analysis.<br>
<br>
As I found no C/C++ API for HSQL, JDBC is needed to connect [1].<br>
Then, there's information_schema support in HSQL [2].<br>
<br>
Then, part of the research is to connect the code that reads the db<br>
with C/C++, without intermediate files, and ideally without extra<br>
processes.<br>
<br>
[1] <a href="http://hsqldb.org/doc/2.0/guide/running-chapt.html#rgc_connecting_db" target="_blank">http://hsqldb.org/doc/2.0/guide/running-chapt.html#rgc_connecting_db</a><br>
[2] <a href="http://stackoverflow.com/questions/7070449/how-can-i-see-table-structure-in-hsqldb" target="_blank">http://stackoverflow.com/questions/7070449/how-can-i-see-table-structure-in-hsqldb</a><br>
<div class="HOEnZb"><div class="h5"><br>
--<br>
regards / pozdrawiam, Jaroslaw Staniek<br>
Kexi & Calligra & KDE | <a href="http://calligra.org/kexi" target="_blank">http://calligra.org/kexi</a> | <a href="http://kde.org" target="_blank">http://kde.org</a><br>
Qt for Tizen | <a href="http://qt-project.org/wiki/Tizen" target="_blank">http://qt-project.org/wiki/Tizen</a><br>
Qt Certified Specialist | <a href="http://www.linkedin.com/in/jstaniek" target="_blank">http://www.linkedin.com/in/jstaniek</a><br>
_______________________________________________<br>
calligra-devel mailing list<br>
<a href="mailto:calligra-devel@kde.org">calligra-devel@kde.org</a><br>
<a href="https://mail.kde.org/mailman/listinfo/calligra-devel" target="_blank">https://mail.kde.org/mailman/listinfo/calligra-devel</a><br>
</div></div></blockquote></div><br></div>