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--