From a1e0a280b9859d9aeadf84b5ce0e78bab5238834 Mon Sep 17 00:00:00 2001
From: Andrea Zagli <azagli@libero.it>
Date: Sun, 25 Dec 2011 10:29:45 +0100
Subject: [PATCH] Added functions
 GdaEx::data_model_columns_to_hashtable_from_sql

and GdaEx::data_model_row_to_hashtable_from_sql (closes #278)."
---
 .anjuta/session/anjuta.session  |   2 +-
 .anjuta/session/dock-layout.xml |   2 +-
 .anjuta_sym_db.db               | Bin 283648 -> 286720 bytes
 src/gdaex.c                     |  46 ++++++++++++++++++++++++++++++++
 src/gdaex.h                     |   3 +++
 5 files changed, 51 insertions(+), 2 deletions(-)

diff --git a/.anjuta/session/anjuta.session b/.anjuta/session/anjuta.session
index 1282bd7..08753d5 100644
--- a/.anjuta/session/anjuta.session
+++ b/.anjuta/session/anjuta.session
@@ -8,7 +8,7 @@ Shortcut=libgdaex//libgdaex//src//libgdaex.la%%%libgdaex//libgdaex//tests//fill_
 Expand=libgdaex.la%%%libgdaex
 
 [File Loader]
-Files=file:///home/andreaz/files/c/libgdaex/src/queryeditor.c#1710
+Files=file:///home/andreaz/files/c/libgdaex/src/queryeditor.c#1259
 
 [Document Manager]
 bookmarks=<?xml version="1.0" encoding="UTF-8"?>\n<bookmarks/>\n
diff --git a/.anjuta/session/dock-layout.xml b/.anjuta/session/dock-layout.xml
index c70c788..e55f84a 100644
--- a/.anjuta/session/dock-layout.xml
+++ b/.anjuta/session/dock-layout.xml
@@ -1,2 +1,2 @@
 <?xml version="1.0"?>
-<dock-layout><layout name="__default__"><dock name="__dock_1" floating="no" width="-1" height="-1" floatx="0" floaty="0"><paned orientation="horizontal" locked="no" position="1019"><notebook orientation="vertical" locked="no" page="0"><item name="AnjutaDocumentManager" orientation="vertical" locked="no"/><item name="AnjutaDevhelpDisplay" orientation="vertical" locked="yes"/><item name="AnjutaTerminal" orientation="vertical" locked="yes"/></notebook><paned orientation="vertical" locked="no" position="289"><notebook orientation="vertical" locked="no" page="1"><item name="AnjutaFileManager" orientation="vertical" locked="no"/><item name="AnjutaProjectManager" orientation="vertical" locked="no"/></notebook><notebook orientation="vertical" locked="no" page="0"><item name="AnjutaSymbolDB" orientation="vertical" locked="no"/><item name="AnjutaDevhelpIndex" orientation="vertical" locked="no"/></notebook></paned></paned></dock></layout></dock-layout>
+<dock-layout><layout name="__default__"><dock name="__dock_1" floating="no" width="-1" height="-1" floatx="0" floaty="0"><paned orientation="horizontal" locked="no" position="1019"><notebook orientation="vertical" locked="no" page="0"><item name="AnjutaDocumentManager" orientation="vertical" locked="no"/><item name="AnjutaDevhelpDisplay" orientation="vertical" locked="yes"/><item name="AnjutaTerminal" orientation="vertical" locked="yes"/></notebook><paned orientation="vertical" locked="no" position="286"><notebook orientation="vertical" locked="no" page="1"><item name="AnjutaFileManager" orientation="vertical" locked="no"/><item name="AnjutaProjectManager" orientation="vertical" locked="no"/></notebook><notebook orientation="vertical" locked="no" page="0"><item name="AnjutaSymbolDB" orientation="vertical" locked="no"/><item name="AnjutaDevhelpIndex" orientation="vertical" locked="no"/></notebook></paned></paned></dock></layout></dock-layout>
diff --git a/.anjuta_sym_db.db b/.anjuta_sym_db.db
index b8cbbc5185e421d170b25f77ff19b2fbe861c866..fe2c1265fb2423370be0a59b34ab8820554b58ac 100644
GIT binary patch
delta 10422
zcmb_C30zfG`se%3y^qIZSC$9z*f$XbR8T|#MMZN|)Lc^m1r<SMO-(14jG8h9Z*o#g
zvDKz>P?DEvijA3DDr#D8qm^S#uA_}h8UOFx2S^k3o8SEBy~p|P{m!}Pe&;*ieps~8
zZBe~jMF*$7jDeXoeJUfm!`{tV2`-SP371$HTf5I?k%Lp0=q~XAaj`w);(Nw-*G6?%
z_Yl*)XSc3fd=+=&MEIH}0kh^9yH&jo-@(_ldt)uoj&NS(eW~><PodVmyjSfHac&8o
znVg2#@KB6}Ot9icJi*8FQ?<U+(?Fq~UfRX${sy{uBbJN6n><?Enm5(M9K)x;w4ChR
zxtTfHrP-M{hXwj-JM#UtVKWkxKLzssV)*CaE^597d+p5`GiVuZ`Ca_^4(8RB=eK@x
z=IoqYntf0=o{wU47qs|f&dDpCo;fqGq$F?Fw9Khxv!=jk8ZkeFiw#EZA!=SnM*{>B
zs)JUa?`2096GHe95f=>YMe0m&*-`+GE_@_Y(4YFik*`AkTGzQQXrkM!A%;O<86-BW
z1b=P)yeO^oiLdPX_BJGff1=3Nz+784|2ZR+Z&|v^2qjw8vQ3aB&J}^5Hf_0=*p&t*
zZRrcq5G@85Ly(TU;Rgoo<_l49sMc@!G84FJ@4Qrr&?q*SgGFSHM^(#OT>#g$&sNWX
z3)FVjrmpD@N40fpieS6ux^@=)sdnMoY=Bhl;>$Z|){8HvXuHk?h>SC|jVYH@&1YRI
zC}Q~2&`(>x?g_Xg+{$5qmbHE?RLi%-)_%ACS$Fu79!%D1-d_YCYH?dXhPBkDY2E9d
zgave!qAmI|yy{2v*OILLVN&g4>seRWuWjBRqrI?iA*`aSSh4U$+OM-~owcKv9Ykz6
zx@#r-d&4a1tA=zrLNi_>y5hkkGF||qPTaNwi4dUoy>-b?WOWC3ZPdY3xT~WE{yjh}
zDg)2jpALSfz#T2)pFS%aHoz%)QMH<$%UbWP#eU+UW$bm-JdY*9oAg+Ww(wX9<mgwC
zH$z3m8t~L=wyN6X<J}=bNAEwL6w!|TnX${jAqFxa51xSy@EQ9vGEBrGlH<Q|A3l~>
z@<UqGi6_-wiX{)VhU4C1(J^p$$eda{duC=yQ2|e_y?o+L4w{WLvsVAbGTL{YPP4Y~
z%T@5G?Z#WHw+4v|PjP?kPp1b$d^0xSl|WHAhvcK*nRFskf6%*j*O?G|ND<Xm=%l$^
zDgkeK8KS*)X#w1_T@L*FLO9<1o|^YVw2Z?(T93<vp|%-W|Akuh4%lg(iRgL*_-GgQ
z*by6)E#DfHaT6Jv$mX-v>?3vwTp$ic!CZI=K8DNiBYI&FCgFH2!)I|NZooZw953Tf
z+>^)g0elRf$)Dw~@xSs*d@KKif6gtuH>UUN(|>HHg^P;`=%F3CQlu@v5?Pyi)d<ce
z?uF?ihK<UAK4#ukY(Va=WnP;e9K_QxJtw>W+yQw71%JpZDIHllyEu1<O>+lG#T})6
zdaY3*bAaOJN$!h~s1;s!7g-;pitK}xH*%p;RPTb$+V=OowTv6?+U^_uVK^}$L_2y@
z(PC~c0K)5c3t=Z+y$jFl>=O&?nk2R2pFUb)f=Qcjt1sl*So_yoeS92P0i)k3=mIO?
zE9{Q1aD|WJ8~Jg~@AlBz<l6_qF4vF^mTWRRJ0VazddI9?_}oFuYIJQS9euQh!)A#S
zSDqwNQh(3~xIGk~qzuClunf@x6N0p3pL=VCKf7q-{`KybyV(l9!o)%&>GRV+MZ#>Y
z=BJU+o7!-3_-|;?;vPhziE9%dOoV!=#DUt`2g$Hp4$%7koJ{Jr_~$iniCPb_awkdF
zkw$MKWGK|v{-tq*(vfVL8=KDPw~}PwA}Ejy^I!{H!4RB?tMD*4@pN9!_iAp&Ff(x0
z6Cc{$NOcGxk^vXj^T12gl!2>3eKU^GA}&JO?J{sNs_a?zVX&GaQ69p-gxeVbPvT=i
z5>>+8g<lDG6d4NiP#;a`sm_$+ETT{WPgP|vvR&d@Bm{_>IpARjhWPkIHQzRZFrErg
zy;G#Bkbs`u#6<%n%9|*0^i8lQ=7<XhGO=`HBr0BFyOY!+aWj%;uP}g{)B^<!wTU97
zh(~ERE<1`C1E@S%oud!ZV!!M_Z!GDaLI_EdL=Z_;tX@(ZC2sr?ObV!Xx>gxs0XoKO
z7ncW%?$^L9wizJ`u8B2AAYDY;!)SE)MjYG^VO9HKYLx?RWyW{*qL+!Nb~r6NmJxCU
z91$ZOU_5NIZgPOZ936*=-9sTv+}OuM#RV5~2uIf_Vp)4Iipeg}2_5^${^7DKq`y7e
z&)9wlf_2ydr(!J+<}dR7JctkCOZjdd$g}t=evt3trx~-kF1c;wcc&HS<z&t_<b$Qj
zakg*6aSAsR1a&4e_v=31cdTI~_>XLwZYrs8W&!DNi8kTRIJ^0VIbfNidt@KE=--;W
zQ-?NYPFp}v`~Uvas%WT&sJ5O?e#DRtmUPgg0qx5>;iBP57-IJyE!FQgmRd-B^8al<
z>BIzE+J3lqH$xm);zWay;)~g?FtW}a6vyH2teCO)$p84lNO+1A?*ckuPt3>lco-Xb
zM?Q=%<gfEOR?N@iU-3NN<xadaVT-xoR(_hccP-yRm~2wZ7;ZB|7NsX|#W$~CGZ)4r
z@;Rc?4#LHax4^|ZKM0=&PC=Enm^@{`Q`~_kbmm&o;UKO4Ym>MT085nS*#n(h>=ryq
zArl#`Kv5nD6YD|%lz82u%wlX7`Bk~B5l{}>;TrjpNAVflhF3@`$MKc?5PeT{Q?mh^
zm0nA2@FYcD&UQ2_Dq$R@PbW1y)kW%QZ*egcy`+;P)ji%*Y>t5G_<V|3T*Skq{T72e
zLV}u`+*Qq#IvcEI9<di&Izqgf(z}Z~(S}=e!Csgnp&Pl=A(1d$9p0B75yK-XDEQky
z?8JAG&`aH!Dh&<c!gX#CS#PubUDa%98iFNHIM{hx8#@7-7vg#LIJg37Uj%ffX?sE{
z41hn-%E!Va$blJ92#>=8SOU+&a(EHeKsCGx@6u*}06Sq19Dt*663)U`@GV?}+i;(P
z4+A=4J2ayo+2Kfx#RTkyeQ_WTB`%J~EYk4;EXKL`Brc7>=dc2+@MV0J;+0MKK7NSx
zxEBxMG5mt)@&sR!oqymBF*Jnt5Ebuowf8=LgrDT!@bB?!{!f07e=l2=%P&Bqvw;IP
z;z%9n7?a*Q>aCNo^oK7DDrX3fRP_f-`{DZa2)!Mtw~q?P0g#GtRisilGZ{lA7Q^&5
zTyG=vwxixI)7$lWTdlVn^!8P~eNDE!gWme;twnGBNYd0s8>yqj%>j^LqZ^*oaj-~y
zm<~arDjhm3gi0H3r477j1FLOdjSZ~T0iq3X8&GUOwE=?-_}YNQ2K;Owzy^YBAego0
zWQ2{C_^7ROsSP}Bf_hd45sc&}1`?n*^b@Y%fQMTJRKd&eDr|)JVH50y4@L4o*dBkM
zxBAlJ<ww4SIa5p52Ii`_E_&;%w@zZrAPBNl+1}W+#FuS%ujqh#3;#h7EUE@UM}MO}
zpPk-1z#*Da-+5-QPv&SnHVC@4OVqV{5&7PY>|=I}U1oQ|M4H~2<bE_fMY6pcF2GON
z5hsyQp5ku&5&jgfSNvy+$`>eK3b49bizdJg5Q|oT|G!7lDb{SMG<8{k#)QojoqWRR
z_ajAM*-!~P;9Iod2wZ?~;Z8isImMzy{7e1?-^(gl8IdX7b;EQBi*Cc}IUrB#pvFOS
z3^R3h@yzVf%$c)iiN%rRYwMo`M<W<+C6PgZhbRgIbd+vBY=cy`p6%(Zj<MN;qqhwP
zV`W+l-RoAT<{zri@}RSNsedPRn8dlu=#Qd@T6S0(D=&H5%8uH{@jh+fRaVE7WN;Os
zrVnTdt72z>8+;%Nr-PTdexR2cZVST5o9E8Wol;hstFn(o(F}-^amRXshKuaWX127I
z7(2M}wB~-xui2)ulRTL?8-X@&s)ED8VN4vJ0U>D)r-#XW*q1dh`hCmp5NXknPIhk|
zRKQ!XkF44Q$|Rz22+qPvtfSEH9{1;Id@4ni8!3A@CsGTbQYIBP-*_(&28hK05NAyZ
zB0-`^X0S}ky+nNm*uzXQEEs%N)uU0YD1fzfh2U&7vuD^R-~^AspW!lD%S^1nbL0|*
z2%8Hzc43K>mU|^?!{0TFZ{~xqtVcv^MKvA7>iHDL#mtAH;=&U!OuY64^cGo9K$__E
z1jLKe^C-G{ZyrUE6XeycxsWHGn+sF@k#}MyHWq1~Y&MqFl7)SS#C<1Dp-{Py3%44K
zaZYZDi)dIM;TTV*=x7Ssi(!8xztfWYS~o8sKR_%@9!+tSWu(qwJyz0U?nH~MC!x^d
zn`%e`|D@)KEw?n2Vz()?XOSAR{^Da-2$f4ZCW02ivbseSRT$jZV8#Xu<1z>oot8m>
z(o6B5rYqmd^=4#mi;SOScs>a_Xt9S?>yBkGu>CMMHjL441#19D@?Q(V3fHj{&cN64
z0{5VdZxOHIpW#2anGfV8yqY)g^ZYCR9FI}_hhSmx?9$n#$qL0sg~cgNx=z!7;-Lr1
zR<8!~{Ys+ZpDpR=AmzVRf|MkV9>-Yi+|w3us2aM~y$;XVLy36yJu-_~V%K|=l^ha3
zzXv^y(H?$kcK{R@{V1InwFyEz|73PogIjdEs4Ta59$>X~#U?oD1iL8}@)q{bgNt}-
z2N{uFlq*@p@g2|?KGG8=(fuQ`TiYKFtNsX5-~-B-dRWan;hNfRK9!Bg)Lka=3x<I(
z8#H0A28(GMKSMl-RQ%J#<~@|7Tv!RJcxMlZYGXA-E0P!DXf=d*{YFG6qBg*@O0eP|
zFDf_CVyY>WRYDc2AknS6SYHH=)-N_d1Xe8tgD~ua<8ZM#k2nBl<>dv~C*C~(6JW2P
ztf9L|JqSs#M=Ur9!{FnVC0Qv=eS^bgnUPF0;6CQf-Vk<2A=<>F*c&{TzEeeN2zHiz
ziHKtMF$isKoxFLf%&xq2Tm7&@Wm|cQIDZr>DF+or4d5HKiydpd8IyCT<;?>7<>?-B
zhngf<N2+YQ*wz38{dzy*sfM=nO_@D&W?revcC+JQ>L36SdyP1oaty)^j`1U!46eJR
z!&9yA*JN<@dv|-4ZDF7B&sdIVI8F|&ViJ(|j%ss3K5Z`u?DdXN43|$+cE=}$h&9Kd
zt5mSAR+`q}=5UYVrKYd=>Ko`7!Kiq+o(2$DX9KU;z*-wvZ38b^yIz6@gR>nBVPvJ|
z;&B)P+pW%5Xv^$o8uEZjOFHM9iU|JgTH<V;I*a=KoBH)4f=HbN{;f19#Tt1H&QTeQ
zueO?QKpKaW;^J){tesv<nIk2)GV@NiYiwjJXX$uX2Jr|Tg8}^Gfj%l(6qyZ5+ftf8
zxh$_BC%2d#ViD=GFcT1|cXv!L&F`ysi9k1{z1USv@?O{uOx6dtz%EMh2J#A?1<=LX
z<u3OCQBeS%qUJ-ex6YagD>1@^+n5XG;dp|*#EpC%&!;yul7`QOx8Ndr;$U3Dleket
zgkUd)26wY<WJW32+W}7vmhm^049voH9#sR>iR|4jGR~KntdGG>+@<FzSlZkR<Hd|n
zOi~wwCdz^W4WOW-gE$w8-Bl&9n>t0utz7S@+a{47hKW=TT^xoz6yCr($k%#t`L@br
z)ZgaG>GdL`BdLHarxG<mK{4t$y<bjqAq?&C%Lv<unh^9+*M>FICi}C_&=SV8cSsUq
z^w~uXf*V&>Mb|~3Vr<tAq8Mx<sThkT<hNgkLaS>mdV-p!$o!e|?@sQ&cFa6Y#KrUW
z!ruh$zHJ+szC9GGP05O-w79MhC8|%5Vu?pl{R8*48oS^<`*6HMyK|m#Pj;U72Pa-a
zaycDV!C&DvhEdY796utXZxIo_@EL^$w_1pS79w?%IPE7=Icbi%fYpi4CFF&p)R8v4
zEcJ?<-Wa1s#6(M^ED@0-Y$ta1#%`DstL;vR5y8nAukP>MwAFrE#c@T?z{GRO7^enA
zHorz&|EbBSmatmdut=SyTJ?T|cH^MESe}f5Iu&+6bVaM9<Tm+<j8$N-fHEse{3QiD
zsp*|!)yMQ6dWfPvepeR5S}jW79m-*R<spFsMVIt>K;SrpQ%d&+dHhMZljJyy@2u?O
zDSAx6aWWKI+UgWQE1MrIhEBi&QISe@?j`rzixn1dvJRh!_W-^Xz3sV=sL#Yyk(G&k
z>#{Jy5uw@|SwK?Y){ZGosuw9|PVVHgY4lR-rkR)n3LSqqTRmsvwOH=UDui7%Mmw?!
zp3j$%N^R%os8W~FDN^Z>j-~Sob8~X1>N@;e#Z}%*+<X;%wMADPtzTDTV0dx}8_(!B
zhpNK6*g19|%+Qr`*=ZEyyhRDgr<AMSf}hcua?`Fj2y<`|C7&B{7oNd8q=~8fNM&;G
zBJJ%#v{S)_>b6z;(YtB@D&og|__c7o1r7+Q;`&|eZ8aXiu7CktEbfOE19X<vU~%Il
zx7a~Xd7UX>Kbqyk)(Ho3qau_&RHpuv7WoI|m#)`Ju6Go#JAqE-_J4$zaR+wgJ-G^(
zXon8)w`<*u3qh>Eii^E+nY#>#nqn4W(zG1fxMESiSB7RW;2<iT(d5ftW#)e$C#@un
z9V;kFiP5cxL7pG5JW+j>mVANY0&^RRD#PbRqWU$G_<*0mN!&;QX9El*>{e^?b=<2s
zdb86AX%xfG;B~_JHg>Wm-NwnBs@*7t4?xd|a5bI0<nQjK$_~?Zp1*@(QSR(6qatJ~
zOo93EJQW-^!wE{$e#XvJ)_tBrvF~{R&mfU`kDn5;cX6N6l{dMUhfW2?TBGja7ltr5
zHiNOl;6>%h%``_Rwv`GHYw;|Fg?;!0HiIvw8dU@BN$Ox(b|caIeLDX$!Q8r)4+%DQ
zVg2AKhHs02Zy;2}gz&-cR1<j>UC@X?@u?MSIF&O*MF<~fy&S@QV1UeP8IHGsaW*hk
z2k^iKezqY;+rVR3#5@>|B4Ed;z@meZ<Q8}*Ucur-Ss0JDvke_1-VWoJ!}&SZgW+ht
zPChV(?jjkE<sZtsaW*hs0;@Hg5Aroiv*1i=vT$|<U(xFZ?;uk8@r~BYuHen<26970
zzyc$UX+$$zC51Xmg|c+M9Jawys`Po%0$FWXH&3wd$*?C&mX#^Wa4j9%H2Glqp7%wh
zf%1>B3Tft~VU}jjK`o>piLvLT^OAm1Iw#j~N=vR5@ekT@&Kz7-Ji<c!Y0zUNa{7ym
z^dgm=WnYN1#XP({|CF_->OBSF)0)q2#UG1!FQsqmN}i)$$)jn?n*FU<bRDR`mqqnX
z#u8<^8y|*nhB-lq17W`BC-`Q*1YU#5aFsjIVbe=E8A9mL#f>EEfVff0uTWTbu8a>b
z^Zv};hZ1>cI*cfxz=aNJ+lz)xq{2HQxXEZR<7YJMDRKBQ-r4%%<9t>ed?hI5OobcP
zejE8ZbmP~VGeBwf<bvFi%vm&_wqb<_hjeGF!#n(5swvcF35(hD!gz)EGtzR2_mq1a
z8LW8v%^qx4JGKO_#j^_vCTCB{SE(d&LQd5X=ivtlcCE_|l1j>x3UiA~=Yg!>U*UAV
z*Jue<`x7&@fYrXjbd`7S>gs1!sj}F-w$kF<k}27RxnSBh#9MYW@x7$ELuGrdrC0e%
zgZl{JDYz7(aWn=%J&b4Xvk}C+9*&cij-!|_MvwW##M`7L2j~phSJV_jd-JriJSyDh
zq6`inUpkfs(&qNDfY^1Lj^OQ{C!wW78l&j=10PT48cToRli@3Q1a0;B7rzbx7RrO^
zx0Zd*Zh|ueL3gSHJr08Eo2TGk*iN|L<-K{c*tT6D2h)Atw|R(9o06@vqf`L4<b#jh
zwc)<9j3X*t!M!VK*6H?YU<<>h7UvSLUipK&#5M6s;#9VWeJ-;{s$&#6fQJI6BSXbs
zin+ypA3GJGCQ*mBVyc%3;HZzhr9Giras3_-2)~A7{M7iC`F<HGtLzYt@1VvIMT^@(
z`vB8dI9k7Ldb>W_#$=Tpz;UAUeeMU_#gO}al+kh6qq>lYhW6l&a6#1H=Y5RVeVe4>
z=4xMS=#TtwJ<KL_Vsxle#i#KEuHXsWOl7b>=tQ0^62yRb<x@l4lChk8k<8y*T4KE(
zOU7_EM;?Ueg@rc!Q<o*9Im_3NN|Ju<y#khu;w=4lEqe5lM>)&Zk3b)$hcQb=awcv@
z@o16IT{$TK{UeFiZr4Ncb6Zc!eF~4_eyR#hqk8r@5z<2$XnnGWat8GBD&uLo#pQi%
zppOltin5+cuwLk8yq67^B;F*PhwUcC29j-{xAi=AIVpT2YbVr!N+f)1jUA}W<uaig
zE8OOxhi)y>o2*4#v(h!IGnkU7l){+#*Bx1dov1^l|8JpF)3>NHe}}(Hx;EMbgGht2
z5ynvL_dFfAQ{WxivKg%Imq}Grz_cmTvx@^FN#w<fosedA8mim^$Hn30N&lZ|rnkIN
zs`X>#y=by@q%tv(d)8CF-`!Alm^HHh#7!&K2g4Mugi2m;wu!M#@PLn{vt;>M98#V_
z@6AK#BU8;hQMr*)Liw)~tr)WPcNnr}Cq&5c?cA0OF7NHeARpl=FAth4U)1aa|F%mj
z?5M1bJRKDk@VjdaX#L+o0ybl$jNjblPW)O4Bo~*ADNiOE<}}kVN74|{Mq<WJHrHt~
z|2rZqVQo|JKVztSmtV+-zI%`@#ny;h@J-w91(&Bj+&xR4c5&aoZ=Su+Z*QKqyD`bT
z<t<cskY^Mx+hjT^SQ~mt*9@<g5%y6m;+MMM-SpoIu3;^MWC3HzBjtT{QCR#xCXg)-
zEAL|?a7+t<4<*$;?za~!Rkwv)zqZM>Nv<VdWYBSX8&YGs|6hphW|PuUF8~C!DYlYd
ya&v+96g9VRR@DX=jp(*yba`4UNw&<9H2KRT`ZnltaQiQ%xtTVL=dYz%683-D+E>E>

delta 7915
zcmZ`;30zgx*57Nbb1s()2q+*jBlCPg1rY}v5PYVgKFcWq6$!-w#pjTPluf24o?@kz
zLzWGu4@J3UzSPp3ayGNH!S^y>gN85r(#rhSIT!if`+nbd#l6m6XP<r6UVH7e{%f5@
zd;J%^?!O|`=VhfJP$_j<{zH9Y4!pdrG}{+?80_nW5lx4D7kT+)re$SEWoGus>e3^#
zt1&WkZ5yXcW)G)xdzcnr9|J#|GXxmk&Ye0GPAV&C`p_8;?Pt}@?*fU1_fD8nKCvb$
zdB%h(O+RP)X9qp1$?!&squrPSE_@x&Qhz$%6!u_$;IY4Av>k(Gz^hK;=<Aeb?5vy|
z+#!P|LdB%A@_8kb%4*6=<bKaE%0tdSiX9PrjeDl#YU84*fQNky0o?dc@H93}nF0$9
z|EXCXGWzK*G}WlP9>-CSkym84a8$=Unvd=|tLK!@nqN{r$z(qiOT58Of!z2CdLu*|
z&MA>Fh$Ck}?Di_~_LU(TR!a-s^gNAd@|)+2{AFi|G`{^P#_;>b&!}E-*`u_VEf*ql
zxy*pzra2ESvBSvii=VecjnS}lE0po))evD+EbqvB`h&w*yetjUdGIXgZ1Gwmz-C-u
zmI}w3B9<?8fWNW%g?dEA+n#`ME*XQmQM#%MT8v|>robg>(~ZfibKsP*c6BxEHvHC1
zhb2w5Ysvun8kb(&4KdR8G4@=DVrK~i8+|V8M#$QH(0SP7Fu+*1b^(0D{!hR_qjcRU
z*kHcJ+4SwYrvl(Jd9b(9xMLB#Yh><xA6}HUzme1Y2s|uTeT+q)CN%tpkw%`Y07{zb
zTo?V|h_UT(hOz8WEi}lLlWU)ot+=?RopJJt7Z-N}2j`Qlc=q95Fhd5chaz*BVZR*3
z>lZ?MOSpHA<ci)+_G_0TxHLyhYvj><xMi`5zKP;Rb0Dbc_oLrxaMLLMSIEj!8{oWo
z(Xa}lWD%VV=Yc?@_(N|a=yWc;CXZzpwWnu8xpkE+R<L3<1R0Gxbz{Pr97wX*htK3C
z`l~BST>*j&D27US5;njwRG5p^Vx?bF2#un8`iR~)QqMkOJajIWPi_Lc@x?j+rYmPR
z5j^J>CfL|}eyQxVC0Vdh`|0yA(%tD~>~(eKuO6dF<LS?eAp0&i>ZNF2p^HTfxKIck
zTe(epF2s65KCgE{is5^CHiVd$v7(cOaKn9B^i3_Cz5AZV9kE97@erf?mBFy%E_3gB
zy<szW80lv^ap|iNVtlpVLl&-W|EEoxQl`|~>YTa(!D>0=!vuH&-hjjK69!|dD#Icy
z!$r6Tx8mD)5YORvc!xSsR~kfPXeK>Fn^YBjNSA0Q9iWdXoO)s5fW8HzN`{Rr81A5s
zSUCLNk;TwgP9^g7a}=gSZW4{;=o}0&8ZUZj&^?^^QZ@z}f8A{}7W^=^$@i)qD44qN
z2BZKZ_u7NT{%d!5{Y?zu()UrfskbAj4|3)w*a_99l`ZA4lGpEnbmQF}os8m^0ApWE
z0SuS5#~LTEYevTPg|cFIuNL;m)myOC(j3<|x0>aOe}xz`vmM5`pZdXMw^l#+sc(q4
z>aFDO4bY$rcAzJY!7X^6bQ)(w+!)HGbHvb!Px$iQ!RX!e@r?<f7u$x&;jD|1Go13v
z$F}=yBOrVPN4JMiqxf4-u73p5Y@>u3Il?HL>gN6A2N@jN9tLl}S*Bs7;##{r{rK<6
zkY_ahK0=&8<L?Q4{7bYMnYWYC^CRPd+Yi9g<^hd1F5d19W##~*-ygkYnRS1xhHs<|
z<o)+(LB@$Yos7~uLt$UjU+)ap5-3FZs$yLg%U&&|;gFA)@C}@aUEvpa8|JBHK<c1c
zV))w=DOaDyr)-eKP941MBeS8mYGXBCLx%?X%`QAW5qjYHEbgsCDw}MFu9mCa6q2J?
zx*spLf!zaa9lQ3?=W<_NCTw{PeC@hwP<wj|OWu)YI9*;crY5JSUTuvrTCRBOx>~K?
z=i@f$q3_7;F7sJWn}<!FenIVPeMP#Xq^t&P&vkDbBCqr@qf2)#vq2)aN)XmHSD)&h
zqqqhf9%`j}ue)%pMGD7L16y`Cb0v8Vc36mBZyJ}D$8gRy2<CU}kO~ud^$95CG*7rs
z9N3Y=kkD`#CO3G=Zkc=A(*fD&_>hkthNZ$B4r_RX7mR_&U0c0iFrn9e-ZvEDx#bYW
z@mId!XPjKE@zO%F^8{Z=L9b@>{xI`atixa3r{wP$QGk5_g=Ntm`b?=Iwm}d+s5M+w
z%&MGJl56V*;oa_X%4<q0YNmFzWkPr+pRz*--qHa^@ZegAb6puA$F?~DH1FhaRj1T;
zbqU%-PdV>T!YbGY|A1e`z+>dr8tfy6UX4%T8|;jNK>Js;nAXs4;&q)No71L2rg_!K
zwJ}h~r>bC_Yy32sp*a>nlXxvQwhd^4+9pmkR9xs|;DT>442NPJy6_q$i1R#3^XUyb
z+f^^)>q!!t<nYO+zN!vo=_Tflg!9R0@bv(X(Y?C}M|M7#y6F?$#^F3}<Dp5AtuO8K
z?-Ovd@Z|VjO@eYgzgL$2fP3ymUwQIl$<S2~>D$Kh`@7CxC(H7Ob94&KfIVEF0(l^w
zC=SK-9uKjD?Q9RRp>C!Pg&8g1``N)Gq^Ig45}Wdw91@P}P6}Xft$?4|5UxQu#6Xe+
zj&3qpUnqnjFakzH36#TBsD`=luxR6Hcov?AH4;`{gDubm@4y~707u~zd;*`#K70#5
z(hd5R(#6a6py3j3#?vH0A??K@M_?=_qZ6~SC-%b%%BO*J4^62RSNs=Rh||PfAHy@U
zl?rV*632@3K8T;<mv|Y!$LshD-X@K_sJ+-i6g^5$(=OUahv)>YAf~nSDsIQUbPgNv
zB^*jk^cKE?oADj`9B1PKF^D>RmcFL%>6ZL6>A&cfF78l)-Y`)1taAaJ??_3?;vsI3
zJBTk^?M8MEg#21uY9qiqu*PIksMUs9ZMfOORkOt;YY>LJNranpc9SSKiLnT*a+B3=
zrsgKPn_2Jf+1$OA=FIIV!g|3vt6k521rVSC+-b+(4TS6z`j_mu4(3g`$7+XI?NF=z
z#cFR_?JW)-2w?#jXZA4OY7?wBk)sL)d=?i%s3($J1myHW=se*$cQ4FMM!3nJ<&Eb1
z{$#a-9U{Rzh*Z!I2FcmEAI6LARKZg)8|q+zSWYCwLmG4y`)Ys};bnLow!#kB1$*H`
z_=vj~!Mncyq-&-D$xPOdrw@XTTrmh@0^P4%>?V)9$rGG72s($aara(wlNa5j!6MX&
zmkffW4jwuID7)2qTCJDs^dRWkK3kA*wR%iFuQsa#>SOht`VD+U(oE<t)^Fm8{qPUC
zgQ;SUFXB1!r6PKq4)DGb=;oR}4qAZgu3?55Y8<YQ$3u$M&ucCPv^#562MJ3+bQp5s
zL3jZ^fFC9D4-n&?jqC9^{w$~?m+qq}^d@~N_{e#a0x4M^VmgZeW9A>exw>jnCxY|@
zz}EDkd|vs)IW^_rxv;3C$!>L^t!!NY(Wz8@1Yld__5??5ahl1x8@GLRbx3_0uNRt=
zcGJt<Ucv91_7cc$<fZHPyBT|rOZ@&$lx1JZrIj#7|E3^Czt=5V=^a0DdQIwhk_anK
z#S+#7JVOTlFX?ywKhi(_e@nmX|B(LTe@ZW5`gp7K<{BgIjt}omFxMi>i;$Z~)%j38
zQxsrE5dyD?+;WpbgHEf@I_S}DYMeZ)yc`^r9DR#Ac<z&pS1JX8tGysF2pr3YT79=}
zRfL`+&sq08z_Dg%wy4Z>{T6r%)zvz+-?aTGHBHIi3e_kX=~eK6WVT0P78g|s<auod
zjOP035X3F-Ks%VgE2`wWaTj>HrbpvSY@P}2?7{RtEud8VT#VxZOcba3CX7}s>Pe2D
z2a|a9LlPp=AA&0WYJo)CrUj736U?i$1<;MZn-BeY%Y5j?<LAS@>^C2V3OuQ94CSxq
z3Bp-25Aq^W#B`|prB#cCY==NG@!zl%k5L4TCiZWnB;O%LwgLz*XtlQr*QkZyjlAy>
znC8*@9$O(q7MhyoCG8=}genDGQwvK?1(dmiJa1Sj$>h5ENzIESWNUuvDaDSZ5DmvT
zSqQ&&6?<{<?`E1iUcjaExbE7$6pA_o1gR&L`bgaoz%o>h%QES1=HUGho_w0Vpuf`+
z%FrT*;LKSwYG%~TpIKfZ`E;}vnQ3vNHS3Zuoq$mGH~>C8;{X)!v5nA0OVuI^`P4=M
zC$p=o)cOA$_@EZ2NunG5p$N3D8oXWS4?rR|zXDHsLJdE)MFMjf@7V&qMgBjwKo5I*
zplJ|dV3#5wkVkHX*q|lB0eVcEZCTkk;0D*TTj8h=yeA;H6MH@bzWms3$dUy2f!pDH
zX1DmsT^1DPoWDu-^7j7>TmLuc13Lu^cXtK92iJ7Aox}{sJ9L3gQL+}<pSPVvNg`)R
z2E6$sMri-Za|v%GH5`IZ;kXIu;sxs+furW-S8#yeIs)V10~TbLBh?3S#`}2TQMgyq
zi@RdFZXAVI2~L}!vBD-B8>+rwkCTw*z(W#+vuH9M<NR2RHKOc)%A(cE4{&m2dDW!Z
zo^dcl`u=zOnVuOi?B5w#o=(9nUz~(`$p*Ok6ojSjR;T}6c@xSjDyM^ISz(~5(N^zf
zF~zs>JEx#1!uF>iJ+AHE#2M43Ro3Y0J#{8t9|XY8YY@eKPD6st>&@Y<-YkF@orWOX
zH-O73C89_tKtTF-b<9Lf38we<vQbHFSHWo;5-`?s=N@{g+G2vH`ra74a-BDuNZSLb
zZ;Z*bhM8!b9#C)b>NC)VOaRz6R&oc|?`PnGAAhnCBl*9+7F(Hi84_JxF2gBXI~|ji
zz@d3~h6Hyu`P+lhm3&P=6e)Va<!FKa1fNLtB7}dxL0+u|2yafG10KO1ckZb2#bf*w
zbVEprL5S=I^3yqU8U#eB!z!^*YFP84lFb7$FR8F*YQH&^Rg=nR32NkhN5sx&3?wht
z?VrFSHOLeDDZyh4aU1?qQrAM7Lod?_5hxKQG|lDfIwV+mkL#N#cpMTPG*?jaM~c>2
zM>QL!!E0~{gK#iDitpgJ0?&%*G@a(eSnMeV5*X{NcaqccKL+Bbhqm=i1Ca^4aJ6iM
zN4c2}(FT4g0TZp#1pgL`x%#^a*?NVga5K5$$~f$)KOASKbk-)ANg010hdH_)-L`>d
zLdS*im@B2Bx_InP8M^pi_eM4#2(tPt(PWu3hzqh&mD<M3dt)@8?1|pcz@PU-r|I4j
z`P3OHX{<l&)3(2o%Y(m_y3vdAY5GWW-Uu#!-ps?a8L7>QsM)=J;flGzqa@P5;tFzN
z5QsAN>76ynd3gQL6y~yL;VsVu+NgXXPtjlHBt9tM`UALu@sh+W$G_nZ0uP4LJi165
zIk6``X``+Gp$ZSZLN%Ita4*cE$z*AF<+X9~GBbbGhNK7};7dJC8HK}>dSQm1lp&D7
zisfcet3AKh3%g>u)7Y1t!7;tDn|>tSv~u$)W5pTGDm(I$-k6Ee$^1o6j5gLCbZGi)
z)x_)j$b7ewocdVz@Rp<A9{NnR-Gl~~W}aOoxD@o)xL$))v;OD}t>@Yl%&k1Ps6{C;
zdLL7&K+Do~z)x^&b3Q^?G!;tZ+9eOG+iI6Y&|$C?{(%MfD*h-2TT1oyeS^6BI2_G0
zM}RlSJ%HgncpMJ2x-RMV#-L84Z6hIkWb4cC7ESrR670vNB{;sh6cfFX+Pjjga5nhw
zR_zfdJ~*{x`ivS+bpc;;ZJmabK=aW%f-7hSUUO2YdY3)cW154eN=~wt-lfl_1o1GB
zUxZ=Yas$0x|5%UF34>zPT%|6k+md7T6<oX!7@E~w$(+82o9Klhm?LL!I8MO1xJ*iQ
z`|&f`e4<EMF;kvoQ447mZKe0f$Xwh(45_0QNqv#wCkU}YerGB~ZaGJi#r23Ht{Wiv
z2c%ndE2%Gs^9zUY@BHjOIrFa`#^K<~JBo+3taj>Cr9OpDFjnyRNy(u5;(XkRHza$T
zLhI-xmWfwbBYE%Fa;E=G%juvjZ6oh3k?1b<Nwa3+<yyWT-bP-u5uD9u(I>b=IlPFQ
z@StRWI$V}*IYMuUFR2AycNObAZmEGiwa5ytUj~upDGK&gjVR2%vaO@q?yOuFY*TLt
zYbQ5ul+;wNDtYf|?8L>_FxbaCnqF2tbF@g|FXHtF#h*p}A@RPY541xm$JRZb<eK;+
zZqOXT>N6A^KNhC2-wmnNuXXjfffGppIA5O+ogC^dctj={AhG=V5DeBlb1|O3_yyxr
zJ3y)u7?KYY;URbi*26Y93x8m`z_Mq=%Y82?Xt8Yg7WxGJ1hwNKo_Satj;Ui79Y?xS
zZ{c}cte@Jc)N$x2wUll0c#7JIlSQQ$1?Bgpaa2dI&?!;svYk6=NQ@mslE;*kE~37M
zIL?Tr!2x%ZTY8I{WG5QUgqK&u(rDL}SPFrG7^?ym+!ErU#F8xXi<$W-xa}r?NUc9c
zVUiFJg^6yG;3n~I5+{z5QfQY{o#w<-nulD;Y>W7fc)F5c&4Ty2$^C9J%1uVQ$rzKk
zTnRKNEJU=~`U78VqC|QQrno6*wMg-(&j5Oze@~})UeTXM+GT7__zbMzbSFi#-%zsg
zqCV7)-%F#;?rwf4`SMyPRr1mYsUNRsk&JHdFwMa&*TKhCFkHJAnv2Mm7?lSy*&Pgq
zt2hZS;*(ei&6G?eZuMc@OsXlqYap0kQu?)3>ZHK#qpPLrT@w}$zFUvs{MpnV=J47C
z%;uJA+UbWUl+90<F=HdmOaQG+puH~n;wLmt`B>=|RM0rSIExZYYhA&YG>9=@w!{n%
zZr3Z}!AqZS8iabKtsH4qC_RhJ&pC8ZCGoQdsIz?|{2_gn+g8v?2HU|N2p5zO#Cpq}
z@98XUqeo$*RKTv17oNcva00|)4El>P9pRQ5`ayDm&*#uUkw!{s&-_54v5E>*q*Re`
zfpVtk!z2V-@Sp_iRgR(o<|{wp<6|k^_1s@*dM4avdY$s&@2&x_(^_#aZ&GMG`cbt*
zteH^dsm?*Y%WE^;%GWxpO^Vz7Km$A_`nsp(`YP&XzvG#Wlg&EiuyX>p+)3GrA1J`8
z7ydx8o~Xj(^a6Rrh*}lKj;oZ@#Xllgm$FoA@-e$+R{89SWiusJdwfVI^G2)CZ8voF
zfve^!t+WLUQ&L)A3~6{DMoCFwjAW<7L>)QaC5uN3RLZcR5|6(j$L64XatcAnv%pZt
ziaC{&E33*;P}SVUqhx3w`R){sy!VC_{w1C2yF@aIv^n6($v@L*!R(8FrU|gs{A}e4
z{4e?u`~u-G3jPA8#T_%Yhh~nwNxhn)>~Ua=((`0B#<P<<dIFpZiO{==vvE#?zyw_#
z#xbFKM%$Vy%o?a$7F`|0(dMI~8hMm=+@dJ^F1+6w&UFK+gXY+Z_i_5K6al+=$ggsi
zy!QXOHSaAH6~iUo`z!Uew}iE7`1-0aSKM#(W%qVEX^IY0165EqY2ux`0uSt_9ps~$
z7GfSQfAr4eVNXcS0|s)mLz6;!mgePe!cO_UB^nxyFgFl+W(>*at(D}5Uf**4W=zmC
z9vwl7ucuNPXXj`~ZTN!9!a3~GU5ntH?ph&#)LnDfp^M}jMPgcybk{CG7;X`NLssQX
zQ3uPZP=K2R@|+%8OglWR+9^sDA_Eh6lkfsXlt4u(LWGy>CP}U@<d#)I4`jVaONJ9J
zXOT9K_|#VD#Jdy85o!y@V;%LRHXEBYqpE5`*~F>f$m8lCsAGpc>a34UN9d!_M_lgx
zY6trb&|VQHzATF`M;L1^-h)Cpe-(OjV;cFO*H5h~yN9cXXo(in?p7Jx<XxK9OOU8r
kse|1kR-7Pj-_{YuGH+ev6J7ZsUCVRzAENDmO~sn_-yHtp2mk;8

diff --git a/src/gdaex.c b/src/gdaex.c
index b7ee9d0..a977d21 100644
--- a/src/gdaex.c
+++ b/src/gdaex.c
@@ -2318,6 +2318,52 @@ GHashTable
 	return ret;
 }
 
+/**
+ * gdaex_data_model_columns_to_hashtable_from_sql:
+ * @gdaex: a #GdaEx object.
+ * @sql: an SQL statement.
+ *
+ * Returns: a #GHashTable with keys as the columns names from @sql,
+ * and values as columns numbers.
+ */
+GHashTable
+*gdaex_data_model_columns_to_hashtable_from_sql (GdaEx *gdaex, gchar *sql)
+{
+	GHashTable *ret;
+	GdaDataModel *dm;
+
+	g_return_val_if_fail (IS_GDAEX (gdaex), NULL);
+
+	dm = gdaex_query (gdaex, sql);
+	ret = gdaex_data_model_columns_to_hashtable (dm);
+
+	return ret;
+}
+
+/**
+ * gdaex_data_modelrow_to_hashtable_from_sql:
+ * @gdaex: a #GdaEx object.
+ * @sql: an SQL statement.
+ * @row: row number.
+ *
+ * Returns: a #GHashTable with keys as the columns names from @sql,
+ * and values as #GValue.
+ */
+GHashTable
+*gdaex_data_model_row_to_hashtable_from_sql (GdaEx *gdaex, gchar *sql, guint row)
+{
+	GHashTable *ret;
+	GdaDataModel *dm;
+
+	g_return_val_if_fail (IS_GDAEX (gdaex), NULL);
+	g_return_val_if_fail (sql != NULL, NULL);
+
+	dm = gdaex_query (gdaex, sql);
+	ret = gdaex_data_model_row_to_hashtable (dm, row);
+
+	return ret;
+}
+
 /**
  * gdaex_data_model_to_gtkliststore:
  * @dm: a #GdaDataModel object.
diff --git a/src/gdaex.h b/src/gdaex.h
index 8740a05..d2bd54b 100644
--- a/src/gdaex.h
+++ b/src/gdaex.h
@@ -178,6 +178,9 @@ struct tm *gdaex_data_model_iter_get_value_tm_at (GdaDataModelIter *iter,
 GHashTable *gdaex_data_model_columns_to_hashtable (GdaDataModel *dm);
 GHashTable *gdaex_data_model_row_to_hashtable (GdaDataModel *dm, guint row);
 
+GHashTable *gdaex_data_model_columns_to_hashtable_from_sql (GdaEx *gdaex, gchar *sql);
+GHashTable *gdaex_data_model_row_to_hashtable_from_sql (GdaEx *gdaex, gchar *sql, guint row);
+
 GtkListStore *gdaex_data_model_to_gtkliststore (GdaDataModel *dm,
                                                 gboolean only_schema);
 
-- 
2.49.0