Date: Tue, 25 Sep 2001 10:37:39 +0300 From: "Dimitar Peikov" <mitko@rila.bg> To: binup@freebsd.org Subject: Perl code for XMLing database creation Message-ID: <200109250737.f8P7bda53417@earth.rila.bg>
next in thread | raw e-mail | index | archive | help
This is a multipart MIME message. --==_Exmh_-5651807190 Content-Type: text/plain; charset=us-ascii Hi, This script uses XML::Parser to parse and generate SQL code from XML as the project requires to move configuration from hardcoded SQL statements to XML configuration. Attached is a simple XML file that is needed to generate the current MySQL data schema with database creation. --==_Exmh_-5651807190 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+Cjx1cGRhdGVkPgogIDxkYXRhYmFzZSB0eXBlPSJteXNx bCIgdXNlcm5hbWU9InVzZXIiIHBhc3N3b3JkPSJwYXNzIiBkYj0idXBkYXRlcyI+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 ICAgPGNvbHVtbiBuYW1lPSJyZWx0YWciIHR5cGU9ImludCIgUEs9InllcyIgZXh0cmE9ImF1 dG9faW5jcmVtZW50Ii8+CiAgICAgIDxjb2x1bW4gbmFtZT0ibmFtZSIgdHlwZT0idmFyY2hh cigxMjgpIi8+CiAgICAgIDxjb2x1bW4gbmFtZT0iZmxvYXRpbmciIHR5cGU9ImludCIvPgog ICAgPC90YWJsZT4KICA8L2RhdGFiYXNlPgo8L3VwZGF0ZWQ+ --==_Exmh_-5651807190 Content-Type: text/plain ; name="config.pl"; charset=us-ascii Content-Description: config.pl Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="config.pl" IyEvdXNyL2Jpbi9wZXJsCgp1c2UgWE1MOjpQYXJzZXI7CgpteSAkYXJnID0gc2hpZnQ7CnVu bGVzcyAoZGVmaW5lZCAkYXJnKSB7IAogICAgcHJpbnQgIlhNTCBmaWxlIG5lZWRlZC5cbiI7 IAogICAgZXhpdCgpOwp9OwoKbXkgJHNxbF9jb2RlID0gIiI7Cm15ICRkYXRhYmFzZSA9ICIi OwpteSAkdGFibGVfc3FsID0gIiI7Cm15ICRjb2x1bW5faWQgPSAwOwoKbXkgJHBhcnNlciA9 IG5ldyBYTUw6OlBhcnNlcihTdHlsZT0+J1N1YnMnKTsKCiRwYXJzZXItPnBhcnNlZmlsZSgk YXJnKTsKCnByaW50ICRzcWxfY29kZTsKCnN1YiB1cGRhdGVkIHsKICAgIG15ICRleHBhdCA9 IHNoaWZ0OwogICAgbXkgJGVsZW1lbnQgPSBzaGlmdDsKICAgIG15IEBhdHRyaWJ1dGVzID0g QF87CgogICAgaWYgKGRlZmluZWQgJERFQlVHKSB7CglwcmludCAiRW50ZXIgdXBkYXRlZCBA YXR0cmlidXRlc1xuIjsKICAgIH0KfQoKc3ViIHVwZGF0ZWRfIHsKICAgIG15ICRleHBhdCA9 IHNoaWZ0OwogICAgbXkgJGVsZW1lbnQgPSBzaGlmdDsKCiAgICBpZiAoZGVmaW5lZCAkREVC VUcpIHsKCXByaW50ICJFeGl0IHVwZGF0ZWRcbiI7CiAgICB9Cn0KCnN1YiBkYXRhYmFzZSB7 CiAgICBteSAkZXhwYXQgPSBzaGlmdDsKICAgIG15ICRlbGVtZW50ID0gc2hpZnQ7CiAgICBt eSBAYXR0cmlidXRlcyA9IEBfOwogICAgbXkgJWF0dHIgPSBAYXR0cmlidXRlczsKCiAgICAj IE15U1FMCiAgICAkc3FsX2NvZGUgLj0gImNyZWF0ZSBkYXRhYmFzZSAiIC4gJGF0dHJ7ZGJ9 IC4gIjtcbiI7CgogICAgaWYgKGRlZmluZWQgJERFQlVHKSB7CglwcmludCAiRW50ZXIgZGF0 YWJhc2UgQGF0dHJpYnV0ZXNcbiI7CiAgICB9Cn0KCnN1YiBkYXRhYmFzZV8gewogICAgbXkg JGV4cGF0ID0gc2hpZnQ7CiAgICBteSAkZWxlbWVudCA9IHNoaWZ0OwoKICAgIGlmIChkZWZp bmVkICRERUJVRykgewoJcHJpbnQgIkV4aXQgZGF0YWJhc2VcbiI7CiAgICB9Cn0KCnN1YiB0 YWJsZSB7CiAgICBteSAkZXhwYXQgPSBzaGlmdDsKICAgIG15ICRlbGVtZW50ID0gc2hpZnQ7 CiAgICBteSBAYXR0cmlidXRlcyA9IEBfOwogICAgbXkgJWF0dHIgPSBAYXR0cmlidXRlczsK CiAgICAkdGFibGVfc3FsID0gImNyZWF0ZSB0YWJsZSAiIC4gJGF0dHJ7bmFtZX0gLiAiICgi OwogICAgJGNvbHVtbl9pZCA9IDA7CgogICAgaWYgKGRlZmluZWQgJERFQlVHKSB7Cglwcmlu dCAiRW50ZXIgdGFibGUgQGF0dHJpYnV0ZXNcbiI7CiAgICB9Cn0KCnN1YiB0YWJsZV8gewog ICAgbXkgJGV4cGF0ID0gc2hpZnQ7CiAgICBteSAkZWxlbWVudCA9IHNoaWZ0OwoKICAgICR0 YWJsZV9zcWwgLj0gIik7XG4iOwogICAgJHNxbF9jb2RlIC49ICR0YWJsZV9zcWw7CgogICAg aWYgKGRlZmluZWQgJERFQlVHKSB7CglwcmludCAiRXhpdCB0YWJsZVxuIjsKICAgIH0KfQoK c3ViIGNvbHVtbiB7CiAgICBteSAkZXhwYXQgPSBzaGlmdDsKICAgIG15ICRlbGVtZW50ID0g c2hpZnQ7CiAgICBteSBAYXR0cmlidXRlcyA9IEBfOwogICAgbXkgJWF0dHIgPSBAYXR0cmli dXRlczsKCiAgICAkdGFibGVfc3FsIC49ICIsICIgaWYgKCRjb2x1bW5faWQgPiAwKTsKICAg ICRjb2x1bW5faWQgKys7CiAgICAkdGFibGVfc3FsIC49ICRhdHRye25hbWV9IC4gIiAiIC4g JGF0dHJ7dHlwZX07CiAgICAkdGFibGVfc3FsIC49ICIgcHJpbWFyeSBrZXkiIGlmIChkZWZp bmVkICRhdHRye1BLfSAmJiB1YyAkYXR0cntQS30gPT0gIllFUyIpOwogICAgJHRhYmxlX3Nx bCAuPSAiICIgLiAkYXR0cntleHRyYX0gaWYgKGRlZmluZWQgJGF0dHJ7ZXh0cmF9KTsKCiAg ICBpZiAoZGVmaW5lZCAkREVCVUcpIHsKCXByaW50ICJFbnRlciBjb2x1bW4gQGF0dHJpYnV0 ZXNcbiI7CiAgICB9Cn0KCnN1YiBjb2x1bW5fIHsKICAgIG15ICRleHBhdCA9IHNoaWZ0Owog ICAgbXkgJGVsZW1lbnQgPSBzaGlmdDsKCiAgICBpZiAoZGVmaW5lZCAkREVCVUcpIHsKCXBy aW50ICJFeGl0IGNvbHVtblxuIjsKICAgIH0KfQo= --==_Exmh_-5651807190 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_-5651807190-- 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?200109250737.f8P7bda53417>