Hi, please prepare year GSOC proposal. That means research and plans only. On Saturday, 22 February 2014, Jayesh Hathila <[email protected]> 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 <[email protected]> wrote: >> >> On 20 February 2014 21:29, Jayesh Hathila <[email protected]> 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 >> [email protected] >> https://mail.kde.org/mailman/listinfo/calligra-devel > >
-- 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 [email protected] https://mail.kde.org/mailman/listinfo/calligra-devel
