GSoC: Add support for importing tables from LibreOffice Base to Kexi [was: The results of your email commands]

[Jayesh Hathila]

Hi,
I am  planning to submit the  proposal once  and then I will keep on
updating as my research moves on, is it good or do I need to submit at one
go ?



On Tue, Feb 25, 2014 at 9:19 PM, Jaroslaw Staniek <staniek at kde.org> wrote:

> Hi, please prepare year GSOC proposal. That means research and plans only.
>
>
> On Saturday, 22 February 2014, Jayesh Hathila <sharma.jayesh52 at 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 <staniek at kde.org>
> wrote:
> >>
> >> On 20 February 2014 21:29, Jayesh Hathila <sharma.jayesh52 at 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 at kde.org
> >> 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
> calligra-devel at kde.org
> https://mail.kde.org/mailman/listinfo/calligra-devel
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/calligra-devel/attachments/20140310/b1f02497/attachment.htm>