mysql module ...

Wild Karl-Heinz <[email protected]> Wed, 5 Jul 2006 17:57:40 +0200
Newsgroups gmane.comp.gnu.octave.sources
Organization Wicom.Li
Message-ID <[email protected]>
------------4217720731D21DCB
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi.

A few words to introduce myself.
A bit a programmer, a bit interested in math
and most interested in good projects.

That's the reason I was searching in the the last
days for some solution around reading data out
of a database into octave.

I found a postgres-module but the queries I
am using are a bit to slow. So I've rewritten
the module to work with mysql.

It's that you will find in the attachment.

Someone will find it maybe interesting.
Be free to change and or use it.

If there are some changes it'll be great
do get some infos. Maybe it'll be usefull
for me too.

Thanks.
Kind regards

Karl-Heinz



------------4217720731D21DCB
Content-Type: application/octet-stream; name="mysqlnumdata.cc"
Content-transfer-encoding: base64
Content-Disposition: attachment; filename="mysqlnumdata.cc"

LyogbXludW1kYXRhIC0tICBPY3RhdmUgZnVuY3Rpb24gdG8gcmV0cmlldmUgbnVtZXJpY2Fs
IGRhdGEgZnJvbSBNeVNRTAogKgogKiBDb3B5cmlnaHQgKEMpIDIwMDYgV2lsZCBLYXJsLUhl
aW56IDxraC53aWxkQHdpY29tLmxpPgogKgogKiBSZWRpc3RyaWJ1dGlvbiBhbmQgdXNlIGlu
IHNvdXJjZSBhbmQgYmluYXJ5IGZvcm1zLCB3aXRoIG9yIHdpdGhvdXQKICogbW9kaWZpY2F0
aW9uLCBhcmUgcGVybWl0dGVkIHByb3ZpZGVkIHRoYXQgdGhlIGZvbGxvd2luZyBjb25kaXRp
b25zCiAqIGFyZSBtZXQ6CiAqIDEuIFJlZGlzdHJpYnV0aW9ucyBvZiBzb3VyY2UgY29kZSBt
dXN0IHJldGFpbiB0aGUgYWJvdmUgY29weXJpZ2h0CiAqICAgIG5vdGljZSwgdGhpcyBsaXN0
IG9mIGNvbmRpdGlvbnMgYW5kIHRoZSBmb2xsb3dpbmcgZGlzY2xhaW1lci4KICogMi4gUmVk
aXN0cmlidXRpb25zIGluIGJpbmFyeSBmb3JtIG11c3QgcmVwcm9kdWNlIHRoZSBhYm92ZSBj
b3B5cmlnaHQKICogICAgbm90aWNlLCB0aGlzIGxpc3Qgb2YgY29uZGl0aW9ucyBhbmQgdGhl
IGZvbGxvd2luZyBkaXNjbGFpbWVyIGluIHRoZQogKiAgICBkb2N1bWVudGF0aW9uIGFuZC9v
ciBvdGhlciBtYXRlcmlhbHMgcHJvdmlkZWQgd2l0aCB0aGUgZGlzdHJpYnV0aW9uLgogKiAz
LiBBbGwgYWR2ZXJ0aXNpbmcgbWF0ZXJpYWxzIG1lbnRpb25pbmcgZmVhdHVyZXMgb3IgdXNl
IG9mIHRoaXMgc29mdHdhcmUKICogICAgbXVzdCBkaXNwbGF5IHRoZSBmb2xsb3dpbmcgYWNr
bm93bGVkZ2VtZW50OgogKiAgICAgIFRoaXMgcHJvZHVjdCBpbmNsdWRlcyBzb2Z0d2FyZSBk
ZXZlbG9wZWQgYnkgdGhlIFVuaXZlcnNpdHkgb2YKICogICAgICBDYWxpZm9ybmlhLCBCZXJr
ZWxleSBhbmQgaXRzIGNvbnRyaWJ1dG9ycy4KICogNC4gTmVpdGhlciB0aGUgbmFtZSBvZiB0
aGUgVW5pdmVyc2l0eSBub3IgdGhlIG5hbWVzIG9mIGl0cyBjb250cmlidXRvcnMKICogICAg
bWF5IGJlIHVzZWQgdG8gZW5kb3JzZSBvciBwcm9tb3RlIHByb2R1Y3RzIGRlcml2ZWQgZnJv
bSB0aGlzIHNvZnR3YXJlCiAqICAgIHdpdGhvdXQgc3BlY2lmaWMgcHJpb3Igd3JpdHRlbiBw
ZXJtaXNzaW9uLgogKgogKiBUSElTIFNPRlRXQVJFIElTIFBST1ZJREVEIEJZIFRIRSBSRUdF
TlRTIEFORCBDT05UUklCVVRPUlMgYEFTIElTJycgQU5ECiAqIEFOWSBFWFBSRVNTIE9SIElN
UExJRUQgV0FSUkFOVElFUywgSU5DTFVESU5HLCBCVVQgTk9UIExJTUlURUQgVE8sIFRIRQog
KiBJTVBMSUVEIFdBUlJBTlRJRVMgT0YgTUVSQ0hBTlRBQklMSVRZIEFORCBGSVRORVNTIEZP
UiBBIFBBUlRJQ1VMQVIgUFVSUE9TRQogKiBBUkUgRElTQ0xBSU1FRC4gIElOIE5PIEVWRU5U
IFNIQUxMIFRIRSBSRUdFTlRTIE9SIENPTlRSSUJVVE9SUyBCRSBMSUFCTEUKICogRk9SIEFO
WSBESVJFQ1QsIElORElSRUNULCBJTkNJREVOVEFMLCBTUEVDSUFMLCBFWEVNUExBUlksIE9S
IENPTlNFUVVFTlRJQUwKICogREFNQUdFUyAoSU5DTFVESU5HLCBCVVQgTk9UIExJTUlURUQg
VE8sIFBST0NVUkVNRU5UIE9GIFNVQlNUSVRVVEUgR09PRFMKICogT1IgU0VSVklDRVM7IExP
U1MgT0YgVVNFLCBEQVRBLCBPUiBQUk9GSVRTOyBPUiBCVVNJTkVTUyBJTlRFUlJVUFRJT04p
CiAqIEhPV0VWRVIgQ0FVU0VEIEFORCBPTiBBTlkgVEhFT1JZIE9GIExJQUJJTElUWSwgV0hF
VEhFUiBJTiBDT05UUkFDVCwgU1RSSUNUCiAqIExJQUJJTElUWSwgT1IgVE9SVCAoSU5DTFVE
SU5HIE5FR0xJR0VOQ0UgT1IgT1RIRVJXSVNFKSBBUklTSU5HIElOIEFOWSBXQVkKICogT1VU
IE9GIFRIRSBVU0UgT0YgVEhJUyBTT0ZUV0FSRSwgRVZFTiBJRiBBRFZJU0VEIE9GIFRIRSBQ
T1NTSUJJTElUWSBPRgogKiBTVUNIIERBTUFHRS4KICovCiAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAKLy8gJElkJAoKdXNpbmcgbmFtZXNwYWNlIHN0ZDsKCiNpbmNsdWRlIDxv
Y3RhdmUvb2N0Lmg+CiNpbmNsdWRlIDxvY3RhdmUvQ2VsbC5oPgojaW5jbHVkZSA8b2N0YXZl
L3F1aXQuaD4KCiNpbmNsdWRlIDxteXNxbCsrLmg+CQkKCkRFRlVOX0RMRCAobXlzcWxudW1k
YXRhLCBhcmdzLCBuYXJnb3V0LCAKIlggPSBteXNxbG51bWRhdGEoIGRiLCBzZWxlY3RfY29t
bWFuZClcblxuXApSZXRyaWV2ZSBudW1lcmljYWwgZGF0YSBmcm9tIGBkYicgdXNpbmcgYHNl
bGVjdF9jb21tYW5kJ1xuXG5cClRoZSBjb2x1bW5zIHRoYXQgYXJlIHRvIGJlIHJldHJpZXZl
ZCBfbXVzdF8gYmUgbnVtZXJpY2FsIGFzIHRoZSBkYXRhIGlzXG5cCnJldHVybmVkIGFzIGFu
IE9jdGF2ZSBtYXRyaXguXG5cblwKICBYID0gbXlzcWxudW1kYXRhKFwiYml6XCIsIFwic2Vs
ZWN0IGRhdGUydGV4dChkYXRlKSwgcHJpY2UgZnJvbSBzYWxlcyBvcmRlciBieSBkYXRlXCIp
O1xuIikKewoKCW9jdGF2ZV92YWx1ZV9saXN0IHJldHZhbDsJLy8gbGlzdCBvZiByZXR1cm4g
dmFsdWVzCgoJaW50IG5hcmdzID0gYXJncy5sZW5ndGggKCk7CS8vIG51bWJlciBvZiBhcmd1
bWVudHMgc3VwcGxpZWQKCglpZiAobmFyZ3MgIT0gMikgewkJLy8gaWYgbm90IGVub3VnaCBh
cmd1bWVudHMsIHNob3cgbWVzc2FnZQoJCXVzYWdlKCJUcnkgJ2hlbHAgbXlzcWxudW1kYXRh
JyBmb3IgaW5mbyIpOwoJCXJldHVybiByZXR2YWw7CQkvLyBhbmQgcmV0dXJuIGVtcHR5Cgl9
CgoJbXlzcWxwcDo6Q29ubmVjdGlvbiBjb24oZmFsc2UpOwogIAoJc3RyaW5nIGRiICAgICA9
IGFyZ3MoMCkuc3RyaW5nX3ZhbHVlKCk7IC8vIGdldCBuYW1lIG9mIGRhdGFiYXNlCglzdHJp
bmcgc3FsY21kID0gYXJncygxKS5zdHJpbmdfdmFsdWUoKTsgLy8gZ2V0IFNRTCBjb21tYW5k
CgoJY29uLmNvbm5lY3QoIGRiLmNfc3RyKCkgKTsgCglpZiAoICEgY29uICkgCgl7CgkJZXJy
b3IoIkNvbm5lY3Rpb24gdG8gZGF0YWJhc2UgZmFpbGVkLlxuIik7CgkJcmV0dXJuIHJldHZh
bDsJCgl9CgoJbXlzcWxwcDo6UXVlcnkgcXVlcnkgPSBjb24ucXVlcnkoKTsKCXF1ZXJ5IDw8
IHNxbGNtZDsKCW15c3FscHA6OlJlc3VsdCByZXMgPSBxdWVyeS5zdG9yZSgpOwoJaWYgKCAh
IHJlcyApIAoJewoJCWVycm9yKCJRdWVyeSBmYWlsZWQiKTsKCQlyZXR1cm4gcmV0dmFsOwoJ
fQoKCWxvbmcgayA9IHJlcy5uYW1lcygpLnNpemUoKTsKCWxvbmcgbiA9IHJlcy5zaXplKCk7
CQkKCglteXNxbHBwOjpSb3cgcm93OwoKCWlmIChuID09IDApIAoJewoJCWVycm9yKCJRdWVy
eSByZXR1cm5lZCBubyBkYXRhIik7CgkJcmV0dXJuIHJldHZhbDsKCX0KCglNYXRyaXggWCgg
biwgayApOwkKCglmb3IgKGxvbmcgaT0wOyBpPG47IGkrKykKCXsKCQlyb3cgPSByZXMuYXQo
IGkgKTsKCQlmb3IgKGxvbmcgaj0wOyBqPGs7IGorKykgCgkJewoJCQlzc2NhbmYoIHJvd1tq
XSwgIiVsZiIsICZYKGksIGopKTsKCQl9Cgl9CglyZXR2YWwoMCkgPSBYOwkJLy8gc2V0IHRo
ZSByZXR1cm4gdmVjdG9yIGFuZAoJcmV0dXJuIHJldHZhbDsJCS8vIGdpdmUgaXQgYmFjayB0
byB0aGUgY2FsbGVyCn0KCi8vIExvY2FsIFZhcmlhYmxlczogCi8vIG1vZGU6IEMrKyAKLy8g
Y29tcGlsZS1jb21tYW5kOiAibWtvY3RmaWxlIG15c3FsbnVtZGF0YS5jYyAtSS91c3IvbG9j
YWwvaW5jbHVkZS9teXNxbCAtSS91c3IvbG9jYWwvaW5jbHVkZS9teXNxbCsrIC1sbXlzcWxw
cCIgCi8vIEVuZDogCg==
------------4217720731D21DCB
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Octave-sources mailing list
[email protected]
https://www.cae.wisc.edu/mailman/listinfo/octave-sources

------------4217720731D21DCB--