Date: Wed, 26 Sep 2001 10:50:43 +0300 From: "Dimitar Peikov" <mitko@rila.bg> To: binup@freebsd.org Subject: Perl code for XMLing database creation Message-ID: <200109260750.f8Q7oha64072@earth.rila.bg>
next in thread | raw e-mail | index | archive | help
This is a multipart MIME message. --==_Exmh_8243409690 Content-Type: text/plain; charset=us-ascii There is a slight modification where target SQL code is generated in dependency of command switches. More than one target SQL servers can be supported. --==_Exmh_8243409690 Content-Type: text/plain ; name="config.xml"; charset=us-ascii Content-Description: config.xml Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="config.xml" PD94bWwgdmVyc2lvbj0iMS4wIj8+Cjx1cGRhdGVkPgogIDxzcWwgdHlwZT0ibXlzcWwiPgog ICAgPGRhdGF0eXBlIG5hbWU9InNlcXVlbmNlIiB2YWx1ZT0iaW50IGF1dG9faW5jcmVtZW50 Ii8+CiAgPC9zcWw+CiAgPHNxbCB0eXBlPSJwZ3NxbCI+CiAgICA8ZGF0YXR5cGUgbmFtZT0i c2VxdWVuY2UiIHZhbHVlPSJzZXJpYWwiLz4KICA8L3NxbD4KICA8ZGF0YWJhc2U+CiAgICA8 dGFibGUgbmFtZT0iYWN0aW9ucyI+CiAgICAgIDxjb2x1bW4gbmFtZT0icmVsdGFnIiB0eXBl PSJpbnQiLz4KICAgICAgPGNvbHVtbiBuYW1lPSJjb21wb25lbnQiIHR5cGU9ImludCIvPgog ICAgICA8Y29sdW1uIG5hbWU9ImRpc3RyaWJ1dGlvbiIgdHlwZT0idmFyY2hhcigyNTUpIi8+ CiAgICAgIDxjb2x1bW4gbmFtZT0iYWN0aW9uIiB0eXBlPSJ2YXJjaGFyKDI1NSkiLz4KICAg ICAgPGNvbHVtbiBuYW1lPSJ1bmRvIiB0eXBlPSJ2YXJjaGFyKDI1NSkiLz4KICAgIDwvdGFi bGU+CiAgICA8dGFibGUgbmFtZT0iZGlzdHMiPgogICAgICA8Y29sdW1uIG5hbWU9InJlbHRh ZyIgdHlwZT0iaW50Ii8+CiAgICAgIDxjb2x1bW4gbmFtZT0idGltZXN0YW1wIiB0eXBlPSJk YXRldGltZSIvPgogICAgICA8Y29sdW1uIG5hbWU9ImRpc3RyaWJ1dGlvbiIgdHlwZT0idmFy Y2hhcigxMjgpIi8+CiAgICA8L3RhYmxlPgogICAgPHRhYmxlIG5hbWU9ImRpcnMiPgogICAg ICA8Y29sdW1uIG5hbWU9InJlbHRhZyIgdHlwZT0iaW50Ii8+CiAgICAgIDxjb2x1bW4gbmFt ZT0iY29tcG9uZW50IiB0eXBlPSJpbnQiLz4KICAgICAgPGNvbHVtbiBuYW1lPSJ0aW1lc3Rh bXAiIHR5cGU9ImRhdGV0aW1lIi8+CiAgICAgIDxjb2x1bW4gbmFtZT0ibXRyZWUiIHR5cGU9 InZhcmNoYXIoMjU1KSIvPgogICAgPC90YWJsZT4KICAgIDx0YWJsZSBuYW1lPSJmaWxlcyI+ CiAgICAgIDxjb2x1bW4gbmFtZT0icmVsdGFnIiB0eXBlPSJpbnQiLz4KICAgICAgPGNvbHVt biBuYW1lPSJ0aW1lc3RhbXAiIHR5cGU9ImRhdGV0aW1lIi8+CiAgICAgIDxjb2x1bW4gbmFt ZT0iZGlzdHJpYnV0aW9uIiB0eXBlPSJ2YXJjaGFyKDEyOCkiLz4KICAgICAgPGNvbHVtbiBu YW1lPSJmaWxlbmFtZSIgdHlwZT0idmFyY2hhcigyNTUpIi8+CiAgICAgIDxjb2x1bW4gbmFt ZT0ibG9jYXRpb24iIHR5cGU9InZhcmNoYXIoMjU1KSIvPgogICAgICA8Y29sdW1uIG5hbWU9 Im1vZGUiIHR5cGU9ImludCIvPgogICAgICA8Y29sdW1uIG5hbWU9InVpZCIgdHlwZT0iaW50 Ii8+CiAgICAgIDxjb2x1bW4gbmFtZT0iZ2lkIiB0eXBlPSJpbnQiLz4KICAgIDwvdGFibGU+ CiAgICA8dGFibGUgbmFtZT0icHJvZmlsZSI+CiAgICAgIDxjb2x1bW4gbmFtZT0ibmFtZSIg dHlwZT0idmFyY2hhcigxMjgpIi8+CiAgICAgIDxjb2x1bW4gbmFtZT0icmVsdGFnIiB0eXBl PSJpbnQiLz4KICAgICAgPGNvbHVtbiBuYW1lPSJkZXNjcmlwdGlvbiIgdHlwZT0idmFyY2hh cigyNTUpIi8+CiAgICA8L3RhYmxlPgogICAgPHRhYmxlIG5hbWU9InJlbGVhc2VzIj4KICAg ICAgPGNvbHVtbiBuYW1lPSJyZWx0YWciIHR5cGU9InNlcXVlbmNlIiBQSz0ieWVzIi8+CiAg ICAgIDxjb2x1bW4gbmFtZT0ibmFtZSIgdHlwZT0idmFyY2hhcigxMjgpIi8+CiAgICAgIDxj b2x1bW4gbmFtZT0iZmxvYXRpbmciIHR5cGU9ImludCIvPgogICAgPC90YWJsZT4KICA8L2Rh dGFiYXNlPgo8L3VwZGF0ZWQ+ --==_Exmh_8243409690 Content-Type: text/plain ; name="config.pl"; charset=us-ascii Content-Description: config.pl Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="config.pl" IyEvdXNyL2Jpbi9wZXJsIC1zCiMKIyBEaW1pdGFyIFBlaWtvdiwgMjAwMS0wOS0yNQojCiMg VXNhZ2UgOgojICAgLi9jb25maWcucGwgLW15c3FsIGNvbmZpZy54bWwgfCBteXNxbCAtdSB1 c2VybmFtZSAtcCBkYXRhYmFzZQojIG9yCiMgICAuL2NvbmZpZy5wbCAtcGdzcWwgY29uZmln LnhtbCB8IHBzcWwgLVUgdXNlcm5hbWUKIwojCiMgVGhpcyBwcm9ncmFtIGNyZWF0ZXMgU1FM IHN0YXRlbWVudHMgZm9yIGRhdGFiYXNlIGNyZWF0aW9uIGZyb20KIyBYTUwgY29uZmd1cmF0 aW9uIGZpbGUuCiMKIyBSdW4gd2l0aCAtREVCVUcgdG8gdmlldyB0aGUgZGVidWcgaW5mb3Jt YXRpb24gb24gU1RERVJSCiMKIyBDb2RlIHByZWZpeGVkIHdpdGggIyMjIGlzIGluIGNhc2Ug dGhhdCB0aGlzIHNjcmlwdCB0YWtlcyBjYXJlIG9mIAojIGluaXRpYWwgZGF0YWJhc2UgaW5p dGlhbGl6YXRpb24uIFRoaXMgY29kZSBtYWtlcyB0aHJlZSBvZiB0YWJsZXMKIyBuZWVkZWQg d2hlbiBJTlNFUlQgc3RhdGVtZW50cyBuZWVkcyB0byBiZSBnZW5lcmF0ZWQuCgp1c2UgWE1M OjpQYXJzZXI7CgpteSAkYXJnID0gc2hpZnQ7CnVubGVzcyAoZGVmaW5lZCAkYXJnKSB7IAog ICAgcHJpbnQgU1RERVJSICJYTUwgZmlsZSBuZWVkZWQuXG4iOyAKICAgIGV4aXQoKTsKfTsK CiMgSGFzaCBjb2xsZWN0aW5nIFNRTCBzZXJ2ZXIgdHlwZXMKbXkgJHNxbF90eXBlcyA9IHt9 OwojIEhhc2ggY29sbGVjdGluZyBzcGVjaWZpYyBTUUwgZGF0YXR5cGUgZGVmaW5pdGlvbgpt eSAkc3FsX2VsZW1lbnQgPSB7fTsKIyBUZW1wb3JhcnkgU1FMIHNlcnZlciBuYW1lIHZhcmlh YmxlIG5lZWRlZCBmb3IgCiMgY29sbGVjdGluZyBzcGVjaWZpYyBTUUwgZGF0YXR5cGUgZGVm aW5pdGlvbnMKbXkgJHNxbF9lbGVtZW50X25hbWUgPSAiIjsKIyMjIyBIYXNoIG9mIHRhYmxl cyBpbiBkYXRhYmFzZQojIyNteSAkc3FsX3RhYmxlcyA9IHt9OwojIyMjIFRlbXBvcmFyeSB0 YWJsZSBuYW1lCiMjI215ICRzcWxfdGFibGVfbmFtZSA9ICIiOwoKIyBUYXJnZXQgU1FMIHNl cnZlciBuYW1lCm15ICRzcWxfc2VydmVyID0gIiI7CiMgVGFyZ2V0IFNRTCBjb2RlCm15ICRz cWxfY29kZSA9ICIiOwojIFRlbXBvcmFyeSB0YWJsZSBjcmVhdGlvbiBTUUwgdmFyaWFibGUK bXkgJHRhYmxlX3NxbCA9ICIiOwojIFRlbXBvcmFyeSBjb2x1bW4gSUQgdmFyaWFibGUKbXkg JGNvbHVtbl9pZCA9IDA7CgojIFhNTDo6UGFyc2VyIG9iamVjdApteSAkcGFyc2VyID0gbmV3 IFhNTDo6UGFyc2VyKFN0eWxlPT4nU3VicycpOwojIEtub3duIFNRTCBzZXJ2ZXIgbGlzdCAK bXkgJHNxbF9lcnJvciA9ICIiOwoKIyBQYXJzaW5nIHRoZSBYTUwgZmlsZQokcGFyc2VyLT5w YXJzZWZpbGUoJGFyZyk7CgojIENoZWNrIGZvciB0YXJnZXQgU1FMIHNlcnZlcgp1bmxlc3Mg KCRzcWxfc2VydmVyKSB7IAogICAgcHJpbnQgU1RERVJSICJFeHBlY3RlZCAiIC4gJHNxbF9l cnJvciAuICIuXG4iOyAKICAgIGV4aXQoKTsKfTsKCiMgUHJpbnQgU1FMIGNvZGUKcHJpbnQg JHNxbF9jb2RlOwoKCiMgU3Vicm91dGluZXMgaGFuZGxlZCBYTUwgdGFncyBwYXJzaW5nCgpz dWIgdXBkYXRlZCB7CiAgICBteSAkZXhwYXQgPSBzaGlmdDsKICAgIG15ICRlbGVtZW50ID0g c2hpZnQ7CiAgICBteSBAYXR0cmlidXRlcyA9IEBfOwoKICAgIGlmIChkZWZpbmVkICRERUJV RykgewoJcHJpbnQgU1RERVJSICJFbnRlciB1cGRhdGVkIEBhdHRyaWJ1dGVzXG4iOwogICAg fQp9CgpzdWIgdXBkYXRlZF8gewogICAgbXkgJGV4cGF0ID0gc2hpZnQ7CiAgICBteSAkZWxl bWVudCA9IHNoaWZ0OwoKICAgIGlmIChkZWZpbmVkICRERUJVRykgewoJcHJpbnQgU1RERVJS ICJFeGl0IHVwZGF0ZWRcbiI7CiAgICB9Cn0KCnN1YiBzcWwgewogICAgbXkgJGV4cGF0ID0g c2hpZnQ7CiAgICBteSAkZWxlbWVudCA9IHNoaWZ0OwogICAgbXkgQGF0dHJpYnV0ZXMgPSBA XzsKICAgIG15ICVhdHRyID0gQGF0dHJpYnV0ZXM7CgogICAgJHNxbF9lbGVtZW50X25hbWUg PSAkYXR0cnt0eXBlfTsKICAgICRzcWxfZWxlbWVudCA9IHt9OwoKICAgICMgRmlsbCB0aGUg bGlzdCBvZiBrbm93biBTUUwgc2VydmVycwogICAgJHNxbF9lcnJvciAuPSAiIG9yIiBpZiAo bGVuZ3RoKCRzcWxfZXJyb3IpKTsKICAgICRzcWxfZXJyb3IgLj0gIiAtIiAuICRhdHRye3R5 cGV9OwoKICAgIGlmIChkZWZpbmVkICRERUJVRykgewoJcHJpbnQgU1RERVJSICJFbnRlciBz cWwgQGF0dHJpYnV0ZXNcbiI7CiAgICB9Cn0KCnN1YiBzcWxfIHsKICAgIG15ICRleHBhdCA9 IHNoaWZ0OwogICAgbXkgJGVsZW1lbnQgPSBzaGlmdDsKCiAgICAkc3FsX3R5cGVzLT57JHNx bF9lbGVtZW50X25hbWV9ID0gJHNxbF9lbGVtZW50OwoKICAgIGlmIChkZWZpbmVkICRERUJV RykgewoJcHJpbnQgU1RERVJSICJFeGl0IHNxbCAkc3FsX2VsZW1lbnRfbmFtZVxuIjsKICAg IH0KfQoKc3ViIGRhdGF0eXBlIHsKICAgIG15ICRleHBhdCA9IHNoaWZ0OwogICAgbXkgJGVs ZW1lbnQgPSBzaGlmdDsKICAgIG15IEBhdHRyaWJ1dGVzID0gQF87CiAgICBteSAlYXR0ciA9 IEBhdHRyaWJ1dGVzOwoKICAgICRzcWxfZWxlbWVudC0+eyRhdHRye25hbWV9fSA9ICRhdHRy e3ZhbHVlfTsKCiAgICBpZiAoZGVmaW5lZCAkREVCVUcpIHsKCXByaW50IFNUREVSUiAiRW50 ZXIgZGF0YXR5cGUgQGF0dHJpYnV0ZXNcbiI7CiAgICB9Cn0KCnN1YiBkYXRhdHlwZV8gewog ICAgbXkgJGV4cGF0ID0gc2hpZnQ7CiAgICBteSAkZWxlbWVudCA9IHNoaWZ0OwoKICAgIGlm IChkZWZpbmVkICRERUJVRykgewoJcHJpbnQgU1RERVJSICJFeGl0IGRhdGF0eXBlXG4iOwog ICAgfQp9CgpzdWIgZGF0YWJhc2UgewogICAgbXkgJGV4cGF0ID0gc2hpZnQ7CiAgICBteSAk ZWxlbWVudCA9IHNoaWZ0OwogICAgbXkgQGF0dHJpYnV0ZXMgPSBAXzsKICAgIG15ICVhdHRy ID0gQGF0dHJpYnV0ZXM7CgogICAgIyBEZXRlY3RpbmcgdGFyZ2V0IFNRTAogICAgbXkgJGk7 CiAgICBmb3JlYWNoICRpIChrZXlzICUkc3FsX3R5cGVzKSB7CglpZiAoZGVmaW5lZCBldmFs KCJcJCIgLiAkaSkpIHsKCSAgICAjIFNldCBtYXRjaGVkIFNRTAoJICAgICRzcWxfc2VydmVy ID0gJGk7CgoJICAgIGlmIChkZWZpbmVkICRERUJVRykgewoJCXByaW50IFNUREVSUiAiTWF0 Y2hlZCBkYXRhYmFzZSAkaVxuIjsKCSAgICB9Cgl9CiAgICB9CgogICAgaWYgKGRlZmluZWQg JERFQlVHKSB7CglwcmludCBTVERFUlIgIkVudGVyIGRhdGFiYXNlIEBhdHRyaWJ1dGVzXG4i OwogICAgfQp9CgpzdWIgZGF0YWJhc2VfIHsKICAgIG15ICRleHBhdCA9IHNoaWZ0OwogICAg bXkgJGVsZW1lbnQgPSBzaGlmdDsKCiAgICBpZiAoZGVmaW5lZCAkREVCVUcpIHsKCXByaW50 IFNUREVSUiAiRXhpdCBkYXRhYmFzZVxuIjsKICAgIH0KfQoKc3ViIHRhYmxlIHsKICAgIG15 ICRleHBhdCA9IHNoaWZ0OwogICAgbXkgJGVsZW1lbnQgPSBzaGlmdDsKICAgIG15IEBhdHRy aWJ1dGVzID0gQF87CiAgICBteSAlYXR0ciA9IEBhdHRyaWJ1dGVzOwoKICAgICR0YWJsZV9z cWwgPSAiY3JlYXRlIHRhYmxlICIgLiAkYXR0cntuYW1lfSAuICIgKCI7CiAgICAkY29sdW1u X2lkID0gMDsKIyMjICAgICRzcWxfdGFibGVfbmFtZSA9ICRhdHRye25hbWV9OwojIyMgICAg JHNxbF90YWJsZXMtPnskc3FsX3RhYmxlX25hbWV9ID0gKCk7CgogICAgaWYgKGRlZmluZWQg JERFQlVHKSB7CglwcmludCBTVERFUlIgIkVudGVyIHRhYmxlIEBhdHRyaWJ1dGVzXG4iOwog ICAgfQp9CgpzdWIgdGFibGVfIHsKICAgIG15ICRleHBhdCA9IHNoaWZ0OwogICAgbXkgJGVs ZW1lbnQgPSBzaGlmdDsKCiAgICAkdGFibGVfc3FsIC49ICIpO1xuIjsKICAgICRzcWxfY29k ZSAuPSAkdGFibGVfc3FsOwoKICAgIGlmIChkZWZpbmVkICRERUJVRykgewoJcHJpbnQgU1RE RVJSICJFeGl0IHRhYmxlXG4iOwogICAgfQp9CgpzdWIgY29sdW1uIHsKICAgIG15ICRleHBh dCA9IHNoaWZ0OwogICAgbXkgJGVsZW1lbnQgPSBzaGlmdDsKICAgIG15IEBhdHRyaWJ1dGVz ID0gQF87CiAgICBteSAlYXR0ciA9IEBhdHRyaWJ1dGVzOwoKICAgICR0YWJsZV9zcWwgLj0g IiwgIiBpZiAoJGNvbHVtbl9pZCA+IDApOwogICAgJGNvbHVtbl9pZCArKzsKICAgICR0YWJs ZV9zcWwgLj0gJGF0dHJ7bmFtZX0gLiAiICI7CgogICAgaWYgKGRlZmluZWQgJHNxbF90eXBl cy0+eyRzcWxfc2VydmVyfS0+eyRhdHRye3R5cGV9fSkgewoJJGF0dHJ7dHlwZX0gPSAkc3Fs X3R5cGVzLT57JHNxbF9zZXJ2ZXJ9LT57JGF0dHJ7dHlwZX19OwogICAgfQogICAgJHRhYmxl X3NxbCAuPSAkYXR0cnt0eXBlfTsKICAgICR0YWJsZV9zcWwgLj0gIiBwcmltYXJ5IGtleSIg aWYgKGRlZmluZWQgJGF0dHJ7UEt9ICYmIHVjICRhdHRye1BLfSA9PSAiWUVTIik7CiAgICAk dGFibGVfc3FsIC49ICIgIiAuICRhdHRye2V4dHJhfSBpZiAoZGVmaW5lZCAkYXR0cntleHRy YX0pOwojIyMgICAgcHVzaCBAeyRzcWxfdGFibGVzLT57JHNxbF90YWJsZV9uYW1lfX0sIFwl YXR0cjsKCiAgICBpZiAoZGVmaW5lZCAkREVCVUcpIHsKCXByaW50IFNUREVSUiAiRW50ZXIg Y29sdW1uIEBhdHRyaWJ1dGVzXG4iOwogICAgfQp9CgpzdWIgY29sdW1uXyB7CiAgICBteSAk ZXhwYXQgPSBzaGlmdDsKICAgIG15ICRlbGVtZW50ID0gc2hpZnQ7CgogICAgaWYgKGRlZmlu ZWQgJERFQlVHKSB7CglwcmludCBTVERFUlIgIkV4aXQgY29sdW1uXG4iOwogICAgfQp9Cg== --==_Exmh_8243409690 Content-Type: text/plain; charset=us-ascii Dimitar Peikov Programmer Analyst Globalization Group "We Build e-Business" RILA Solutions 27 Building, Acad.G.Bonchev Str. 1113 Sofia, Bulgaria phone: (+359 2) 9797320 phone: (+359 2) 9797300 fax: (+359 2) 9733355 http://www.rila.com --==_Exmh_8243409690-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-binup" in the body of the message
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200109260750.f8Q7oha64072>