Hi, I am mailing again as I didn't get any reply for my previous mail. I also tried on irc channel but that too did not help much.If possible can you please reply to my queries in previous mail. Regards Jayesh Hathila
On Sat, Feb 22, 2014 at 2:14 PM, Jayesh Hathila <sharma.jayes...@gmail.com>wrote: > Hi, > 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 ). > Regards Jayesh Hathila > > > On Fri, Feb 21, 2014 at 2:43 AM, Jaroslaw Staniek <stan...@kde.org> wrote: > >> On 20 February 2014 21:29, Jayesh Hathila <sharma.jayes...@gmail.com> >> wrote: >> > Hi , >> > >> > As you said : >> > >> > "If you look at content.xml file, it contains table/column definitions. >> > The database/script file you're mentioning contains HSQLDB or other >> > backend-specific SQL (yes, there's no respected standard). I am >> > guessing the xml is easier to parse than the specific SQL. " >> > >> > I tried to parse content.xml but the problem which I faced is that >> > content.xml does not contain every information.For e.g the samples >> > downloaded from source provided by you ( >> > >> http://www.floppybunny.org/robin/web/virtualclassroom/chap8/libreoffice_base.html >> > ) had a file under name "cons2.odb" in which by simply analyzing (after >> > unziping .odb file) content.xml file , we don't gets necessary >> information >> > regarding- Primary key and other constraints, and also for some tables >> it >> > doesn't states any column at all which are originally present there in >> > database.And regarding tuples (i.e instances or values or data) its >> present >> > in "file_name/database/data" file but under some encoded scheme (till >> now I >> > couldn't found out the scheme,as I haven't thought of it much).So >> > considering above issues I think I will have to parse script file only >> > (though a little more information can be gathered from setting.xml but >> that >> > will not sufficient) . >> > If possible , I would like to have your views about my approach and >> > suggestions towards it. >> > >> >> >> Hi Jayesh, >> Thanks for the analysis. >> >> As I found no C/C++ API for HSQL, JDBC is needed to connect [1]. >> Then, there's information_schema support in HSQL [2]. >> >> Then, part of the research is to connect the code that reads the db >> with C/C++, without intermediate files, and ideally without extra >> processes. >> >> [1] http://hsqldb.org/doc/2.0/guide/running-chapt.html#rgc_connecting_db >> [2] >> http://stackoverflow.com/questions/7070449/how-can-i-see-table-structure-in-hsqldb >> >> -- >> regards / pozdrawiam, Jaroslaw Staniek >> Kexi & Calligra & KDE | http://calligra.org/kexi | http://kde.org >> Qt for Tizen | http://qt-project.org/wiki/Tizen >> Qt Certified Specialist | http://www.linkedin.com/in/jstaniek >> _______________________________________________ >> calligra-devel mailing list >> calligra-devel@kde.org >> https://mail.kde.org/mailman/listinfo/calligra-devel >> > >
_______________________________________________ calligra-devel mailing list calligra-devel@kde.org https://mail.kde.org/mailman/listinfo/calligra-devel
