Date: Mon, 10 Mar 2025 17:13:33 -0400
User-Agent: K-9 Mail for Android
In-Reply-To: <1CB9D882-99B8-4E26-8683-E5A4A0F735C6@meddatainc.com>
References: <84A5765B-1D3C-485B-B852-99D63D53963E@meddatainc.com> <CA+bJJbyfE3NgyxBDb+Fp8ReZYQOZdit8jZF64PnE7ZVzzi=u0A@mail.gmail.com> <1CB9D882-99B8-4E26-8683-E5A4A0F735C6@meddatainc.com>
MIME-Version: 1.0
Content-Type: text/plain;
 charset=utf-8
Content-Transfer-Encoding: quoted-printable
Subject: Re: Creating files with testdata
To: pgsql-general@lists.postgresql.org
From: H <agents@meddatainc.com>
Message-ID: <BA6A1F07-A278-4A70-A8DF-3231C2416BBF@meddatainc.com>
UI-OutboundReport: notjunk:1;M01:P0:bAZyAFGJ3e0=;AZ4/ciSiFHSJCQmEigzhqRERUY8
 RHtns1lYNWOuTRYZRzxNiRt+yV82SwQkDuqzo3sd7Yfwc07CWuC5NB7dW3LJ7QnTlPbEHj3ba
 LzsX5R1zdPnSvRvX0tnWNnvwtx2IAKauahYb5KXDK1lQiEWH6klbwCym/9PJ333nN4X0df/tB
 isjTVhyzcWGcMx/Zmz4dkQwL59RhwehPe9UCjiOg5RwK+0nvz5ZtLfQqXAh6kDTroOL7o8d6U
 xAm4/VabzDsQsN/97KZfmR9RSStUiXH3vLuN/OIoo17HD6U4PY4levMr/QswNcsQwunS/7WvU
 dPKNfJCQWiOneU9arhNo+JvErPQr0RSSSpbOmdL+92ycTGpO8NUSBjjY7HjjMth7R+/v4l5tS
 XVVVz3SIAMhSmfAskoapA9HphK5N2Pvx1n6uy3DtDtAV4wNWsengmtZixwXyEWtLxhTAzHR/f
 dZNmfk+wLVs+IZpwEQWL96DuUIZlSIzVIYyLZl609GnemGJuR0GFL45eZf2SJx9Ib2ALTWkYP
 4NxnD47v7rImcDyjVm7H/9piFiYp7nMKkRCO60A+VEv+5JDgO1wxu2ahketaTi7Gz6+TCrjP3
 E73mIhZGkueC6U9ioOWjAoQ/VHhpyIkQ+3VWrWMUxL9tCawsXUhEyWCbI8MadF7OIQDlxeQ+Q
 aYTqT5HCxpNhETf8m2cFE5mStmQp8d9zL7q8et2e3Ofczi6aMbSu8PpS13N4FW8Y5xIxRcjLS
 ELqMYcaRRaG6Yp3pbryel5vUYh2/KZX6jA3ELVQb7vmPJ+MClaWlAxyqSkrNl7e8rm7vKHAjh
 kzvODvgSdEc1wOhwBzV6i9P712eAFLcXhYXarmwDZY4M9sxSXJWLnj+0/kHWtCRAHUc1lqVg+
 Ok/DBcDdI+Foh/HTp6/kA6flJXQwxQGZkLFk7KZNC68mBYaA4FXRSxDvNMMmX6FKNYH1Bt7nK
 kfIH/vmQ/E497a6ITXShmPJrIFig5OPpMJzBcHt1XKI2ovISZBlaugyW+wgJSdASBOhGUWz3k
 5nRETZaP9rg6MPsxzjQI8pfuFQnzMNukRz6gcq66L7AjDjjOEIOLFLGfWQdsCioiQofaw0zP3
 dyxGwrYu/Vpv+Vcn2G9xTx8nvoCtFOssoW8o3mXMOKdiXRblVqVWEHSm2Gb9UAE5kjF71g2R0
 kncXT4u6g21iBqFPU4HfXprRalp83aKM8xARwejuLOW2ChOtKDE/QiRQpABbcUn2bypWDPfsI
 cjt5TbViV6/EtC3Fd0PJhSLw158w1e1bVlqgnOuVUjNhtvuR3Gmm267uymcXTE8ayrsPFUerb
 6/o4fMoB51EB9QJxUh5v1WipUnl5JsCYPHe0DVYLyEx9OWj0RKwkQW0G2W1FwbQYn6O
Archived-At: <https://www.postgresql.org/message-id/BA6A1F07-A278-4A70-A8DF-3231C2416BBF%40meddatainc.com>
Precedence: bulk

On March 10, 2025 5:09:46 PM GMT-04:00, H <agents@meddatainc=2Ecom> wrote:
>On March 10, 2025 3:22:41 PM GMT-04:00, Francisco Olarte
><folarte@peoplecall=2Ecom> wrote:
>>On Mon, 10 Mar 2025 at 19:17, H <agents@meddatainc=2Ecom> wrote:
>>=2E=2E=2E
>>> After entering my test data into the markdown file for the given
>test
>>scenario, I would then run an awk script or similar to create a SQL
>>file with the various CTE INSERT statements=2E Howevever, it gets
>complex
>>since I need to handle 1:N relationships between tables in the
>markdown
>>file=2E=2E=2E
>>> I hope the above outline is understandable and am interested in
>>comments and thoughts on my above approach=2E
>>
>>I do not think MD would be a good source format=2E Being a developer I
>>would recommend taking your favorite scripting language ( perl /
>>python / lua / js , whatever ), build a big object ( which can be
>>easily helped by some mini-functions to build a little DSL ) and then
>>spit sql from it ( for developemewnt it is normally better then using
>>whatever db connection your language has, as it leaves an
>>understandable sql script )=2E
>>
>>I have done this with perl for some projects, built a driver which
>>defined several helper functions, then dofile("xx=2Edat") which returned
>>a big hash and then a series of loops on the result to write the SQL
>>in whatever order was neccessary=2E
>>
>>Francisco Olarte=2E
>
>The plan is to use the same format for later adding information into
>the finished application=2E By the way, all information is text, either
>paragraphs, sentences or single words=2E

I am also contemplating using Pandoc to process the markdown file=2E Pando=
c builds an AST which can then be processed as desired=2E Awk processes a f=
ile line-by-line which is not ideal=2E