From: Date: March 25 2008 10:47am Subject: Insert Query List-Archive: http://lists.mysql.com/plusplus/7526 Message-Id: MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_Part_9519_31510688.1206438474478" ------=_Part_9519_31510688.1206438474478 Content-Type: multipart/alternative; boundary="----=_Part_9520_15185555.1206438474479" ------=_Part_9520_15185555.1206438474479 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi folks, I've written an insert query generator utility. Works as follows: { insert_query q("some_table"); q["name"] = "John"; q["location"] = "UK"; // ... q.execute(connection); } There may be several problems, which can be improved later, but how about the idea? Do you guys think it may be useful and can be included in the distribution? Thanks, Emre Turkay ------=_Part_9520_15185555.1206438474479 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi folks,

I've written an insert query generator utility. Works as follows:

{
     insert_query q("some_table");
     q["name"] = "John";
     q["location"] = "UK";
     // ...
     q.execute(connection);
}

There may be several problems, which can be improved later, but how about the idea? Do you guys think it may be useful and can be included in the distribution?

Thanks,

Emre Turkay
------=_Part_9520_15185555.1206438474479-- ------=_Part_9519_31510688.1206438474478 Content-Type: text/x-c++hdr; name=insert_query.hpp Content-Transfer-Encoding: base64 X-Attachment-Id: f_fe8a988p0 Content-Disposition: attachment; filename=insert_query.hpp I2lmbmRlZiBfSU5TRVJUX1FVRVJZX0hQUF8KI2RlZmluZSBfSU5TRVJUX1FVRVJZX0hQUF8KCiNp bmNsdWRlIDxteXNxbCsrL215c3FsKysuaD4KI2luY2x1ZGUgPHN0cmluZz4KCnN0cnVjdCBpbnNl cnRfcXVlcnkKewoJdHlwZWRlZiBzdGQ6Omxpc3Q8IHN0ZDo6cGFpcjxzdGQ6OnN0cmluZywgc3Rk OjpzdHJpbmc+ID4gdmFsdWVzX3R5cGU7CgoJc3RydWN0IGZpZWxkX2RlZgoJewoJCWZpZWxkX2Rl ZihpbnNlcnRfcXVlcnkmIHEsIGNvbnN0IHN0ZDo6c3RyaW5nJiBuYW1lKQoJCQk6IHF1ZXJ5Xyhx KSwgbmFtZV8obmFtZSkKCQl7CgkJfQoKCQl0ZW1wbGF0ZSA8dHlwZW5hbWUgVD4KCQlmaWVsZF9k ZWYmIG9wZXJhdG9yPShjb25zdCBUJiB2YWx1ZSkKCQl7CgkJCXF1ZXJ5Xy5zZXQobmFtZV8sIHZh bHVlKTsKCQkJcmV0dXJuICp0aGlzOwoJCX0KCglwcml2YXRlOgoJCWluc2VydF9xdWVyeSYgcXVl cnlfOwoJCXN0ZDo6c3RyaW5nIG5hbWVfOwoJfTsKCglpbnNlcnRfcXVlcnkoY29uc3Qgc3RkOjpz dHJpbmcmIHRhYmxlX25hbWUpCgkJOiB0YWJsZV8odGFibGVfbmFtZSkKCXsKCX0KCglmaWVsZF9k ZWYgb3BlcmF0b3JbXShjb25zdCBzdGQ6OnN0cmluZyYgbmFtZSkKCXsKCQlyZXR1cm4gZmllbGRf ZGVmKCp0aGlzLCBuYW1lKTsKCX0KCgl0ZW1wbGF0ZSA8dHlwZW5hbWUgVD4KCXZvaWQgc2V0KGNv bnN0IHN0ZDo6c3RyaW5nJiBuYW1lLCBjb25zdCBUJiB2YWx1ZSkKCXsKCQlzdGQ6Om9zdHJpbmdz dHJlYW0gb3M7CgkJb3MgPDwgbXlzcWxwcDo6cXVvdGUgPDwgdmFsdWU7CgkJc3RkOjpjZXJyIDw8 IG5hbWUgPDwgIjogIiA8PCBvcy5zdHIoKTsKCQl2YWx1ZXNfLnB1c2hfYmFjayhzdGQ6Om1ha2Vf cGFpcihuYW1lLCBvcy5zdHIoKSkpOwoJfQoKCXN0ZDo6c3RyaW5nIHF1ZXJ5KCkgY29uc3QKCXsK CQl2YWx1ZXNfdHlwZTo6Y29uc3RfaXRlcmF0b3IgaTsKCQlzdGQ6Om9zdHJpbmdzdHJlYW0gb3M7 CgkJb3MgPDwgIklOU0VSVCBJTlRPICIgPDwgdGFibGVfCgkJICAgPDwgIigiOwoJCWkgPSB2YWx1 ZXNfLmJlZ2luKCk7CgkJaWYgKGkgIT0gdmFsdWVzXy5lbmQoKSkKCQkJb3MgPDwgaS0+Zmlyc3Q7 CgkJKytpOwoJCXdoaWxlIChpICE9IHZhbHVlc18uZW5kKCkpCgkJewoJCQlvcyA8PCAiLCAiIDw8 IGktPmZpcnN0OwoJCQkrK2k7CgkJfQoJCW9zIDw8ICIpICIKCQkgICA8PCAiVkFMVUVTICgiOwoJ CWkgPSB2YWx1ZXNfLmJlZ2luKCk7CgkJaWYgKGkgIT0gdmFsdWVzXy5lbmQoKSkKCQkJb3MgPDwg aS0+c2Vjb25kOwoJCSsraTsKCQl3aGlsZSAoaSAhPSB2YWx1ZXNfLmVuZCgpKQoJCXsKCQkJb3Mg PDwgIiwgIiA8PCBpLT5zZWNvbmQ7CgkJCSsraTsKCQl9CgkJb3MgPDwgIikiOwoKCQlyZXR1cm4g b3Muc3RyKCk7Cgl9CgoJdW5zaWduZWQgaW50IGV4ZWN1dGUobXlzcWxwcDo6Q29ubmVjdGlvbiYg Y29ubikKCXsKCQlteXNxbHBwOjpRdWVyeSBxID0gY29ubi5xdWVyeSgpOwoJCXEgPDwgcXVlcnko KTsKCQlxLmV4ZWN1dGUoKTsKCQlyZXR1cm4gcS5pbnNlcnRfaWQoKTsKCX0KCnByaXZhdGU6Cglz dGQ6OnN0cmluZyB0YWJsZV87Cgl2YWx1ZXNfdHlwZSB2YWx1ZXNfOwp9OwoKI2VuZGlmIC8vIF9J TlNFUlRfUVVFUllfSFBQXwo= ------=_Part_9519_31510688.1206438474478--