Re: Store GNU Gama Result in SQLite

Aleš Čepek <[email protected]> Wed, 2 Aug 2017 15:07:50 +0200
Newsgroups gmane.comp.gnu.gama.announce
Message-ID <CAGN9seTBg8swPVVdUuLXeOcHWn7NbN70yy8isDdwZB7H59-WrQ@mail.gmail.com>
--===============5274048943213034093==
Content-Type: multipart/alternative; boundary="001a114f1d2e8aa0420555c4f3a5"

--001a114f1d2e8aa0420555c4f3a5
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

Hi J=C3=BCrgen, gama-local command line program can only read data from a g=
iven
sqlite flat database but is not designed to write back to the database.
Nevertheless, a part of the GNU gama project is a conversion tool
gama-local-xml2sql that converts XML adjustment results of gama-local to
SQL, so you can easily populate your database.

The more, there is a gama-q2 project which can write data directly to the
database (an alpha version of Qt based GUI -- it is not limited to sqlite
-- see a note at https://www.gnu.org/software/gama/).

I am really interested in your project, so please feel free to contact me.
Ales


On 1 August 2017 at 21:52, J=C3=BCrgen Friedrich <[email protected]> wro=
te:

> Hej!
>
> I found that awesome program of yours, gnu gama and I just wondered if it=
's
> possible to store the adjustment result within the sqlite-db.
>
> when i try:
>
> gama-local --sqlitedb example_net.db --configuration example_net
>
> I just get the xml output and the the tables gnu_gama_local_adj_* remain
> empty!
>
> How can I store the adjusted observations, points within sqlite3 without
> parsing it from the generated xml!
>
> --
> Beste Gr=C3=BC=C3=9Fe,
> J=C3=BCrgen Friedrich
>
> _______________________________________________
> Info-gama mailing list
> [email protected]
> https://lists.gnu.org/mailman/listinfo/info-gama
>

--001a114f1d2e8aa0420555c4f3a5
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div><div><div><div>Hi J=C3=BCrgen, gama-local command lin=
e program can only read data from a given sqlite flat database but is not d=
esigned to write back to the database. Nevertheless, a part of the GNU gama=
 project is a conversion tool gama-local-xml2sql that converts XML adjustme=
nt results of gama-local to SQL, so you can easily populate your database.<=
br><br></div><div>The more, there is a gama-q2 project which can write data=
 directly to the database (an alpha version of Qt based GUI -- it is not li=
mited to sqlite -- see a note at <a href=3D"https://www.gnu.org/software/ga=
ma/">https://www.gnu.org/software/gama/</a>).<br></div></div><br></div>I am=
 really interested in your project, so please feel free to contact me.<br><=
/div>Ales<br><br></div><div class=3D"gmail_extra"><br><div class=3D"gmail_q=
uote">On 1 August 2017 at 21:52, J=C3=BCrgen Friedrich <span dir=3D"ltr">&l=
t;<a href=3D"mailto:[email protected]" target=3D"_blank">contact@messfuc=
hs.at</a>&gt;</span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"m=
argin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hej!<br>
<br>
I found that awesome program of yours, gnu gama and I just wondered if it&#=
39;s<br>
possible to store the adjustment result within the sqlite-db.<br>
<br>
when i try:<br>
<br>
gama-local --sqlitedb example_net.db --configuration example_net<br>
<br>
I just get the xml output and the the tables gnu_gama_local_adj_* remain<br=
>
empty!<br>
<br>
How can I store the adjusted observations, points within sqlite3 without<br=
>
parsing it from the generated xml!<br>
<span class=3D"HOEnZb"><font color=3D"#888888"><br>
--<br>
Beste Gr=C3=BC=C3=9Fe,<br>
J=C3=BCrgen Friedrich<br>
<br>
______________________________<wbr>_________________<br>
Info-gama mailing list<br>
<a href=3D"mailto:[email protected]">[email protected]</a><br>
<a href=3D"https://lists.gnu.org/mailman/listinfo/info-gama" rel=3D"norefer=
rer" target=3D"_blank">https://lists.gnu.org/mailman/<wbr>listinfo/info-gam=
a</a><br>
</font></span></blockquote></div><br></div>

--001a114f1d2e8aa0420555c4f3a5--


--===============5274048943213034093==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Info-gama mailing list
[email protected]
https://lists.gnu.org/mailman/listinfo/info-gama

--===============5274048943213034093==--