Date: Mon, 10 Mar 2025 17:09:46 -0400
User-Agent: K-9 Mail for Android
In-Reply-To: <CA+bJJbyfE3NgyxBDb+Fp8ReZYQOZdit8jZF64PnE7ZVzzi=u0A@mail.gmail.com>
References: <84A5765B-1D3C-485B-B852-99D63D53963E@meddatainc.com> <CA+bJJbyfE3NgyxBDb+Fp8ReZYQOZdit8jZF64PnE7ZVzzi=u0A@mail.gmail.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: <1CB9D882-99B8-4E26-8683-E5A4A0F735C6@meddatainc.com>
UI-OutboundReport: notjunk:1;M01:P0:54YxdM1uIYg=;UPyTdseok2Q285Q/NBQeJeGSQzz
 bDbzmw6maIqjadMiqmr6vOrOkJEnoGNpYuyWlg5sP0cqRuZF49N+8zlZNZ4X7pOGWbjYOJtIn
 6pqaVMCs9McMH+CEr8NH6c6+wy+pjsSqg6H4lfH01OKW8eQ/0an+v1ukh0k1hBwyeeG8ypq6a
 BZnzMu/a3gUT92u3IejjKC3o4VC7Lt+HvXfcv6Z80WEpLaud9ZbA9s5UIr3eCWF8ILrIoDwJn
 QZNJ41q9/JR8nhzsE3li9qwVS7wm3BGrLVHBGvbasnTOfQY9kGdWMESYISFNCf5J4Z4Z608bf
 rCnLbSZmCTlbUda+BXY6jNaIVaEWByMJd2/nEstxQ+Swi1BReLaDOYrOl1mi+A8nJrVi3HTAA
 IkSQUL7Bx4vK4lLMjwcGuru3UvUEGEcnbKKXIT7SSxqOU3d11ZO3oNNuA11Zc5PISmwGq7+T1
 8mSx8O0H64BWnmROOURqWqMtJtKIFHJiTXHMB532FjU/dXyCKptEvpJNrBcIVvZYAe6y3lPnn
 We20OWWRl+mk2mURVxXlu/g0lcUFQuHL9mXHbyRTUi1AgyrnUBUbsq+6amd1vBWRE79B1hoWY
 5t9mAD3AUcZkJ3O1cDUc3t4ZfNB1JVnaJp3M4vZAbe36U/bjvSTHe6iKIK6KWslGeXa845Dhm
 lYH17SwhpogCqB4qnKgN5KXTMYOFfC+eMvxUa0sWX6Bq3XkwGUdwdM2dDESfdLYUdC0AbkbeV
 Lspofzb6/zO9JZUuHFXa7hIg7k0FK61EPMZa1w4cBbLhC6n9ssLVh81eJzFUpVuqYfq2YYv/i
 UHWNcTJ5Pn9C4JHgr7RlVYAk1KgeYJ/4qGi+Uukxox1Uy3dUzt8DyFHnuLhvrUfbkHKH56FHn
 y2u5C6oILYh0WPijFGfztz3e4IhuxYdDLG0RdBV6ZhPOEEGRRy9v1BaWz4BlCFZAHli0qdKa6
 6zy8CRnRTrsMQDEnGPxl7MW0/9EbFmSq7pHFdt38gc87dBdRbVW9O7SYU4E4fJtyH6eUaUXnQ
 54I9BsLbjWFYeTcHyA6PR+A7/rbaubCc0txxWpl6s5uIFZxx1Uav7jXbJavpSw5KwcHtD4VrX
 47LHXTPvPqlIp2a6YYanmCZDysxEfzn6bmKaORyzqHD85bUsiUNkX6whOdOuq7Ff25Znj4Btb
 i5ObZ/6pPgIHHSMcDesafEUcNHLkw6bDikLykDodE4ObfGIhYZYt6Wu3BMpEHwl5PxgrTUH1c
 eexkU3yr0nuyGuBz14xANtooieZdV4G31jP3QUZ5LQFNhLEj8r3+7JgbBNoJHfY/njKrP0l7m
 VaHT/R2L40Yoz4AyBelj0qyZ8/3u9OyLv7RVh6A1TVl4CUI2rVYXHCGYimtTUtUoykGSsIaI9
 sjCMTM+oVVGdnW/g==
Archived-At: <https://www.postgresql.org/message-id/1CB9D882-99B8-4E26-8683-E5A4A0F735C6%40meddatainc.com>
Precedence: bulk

On March 10, 2025 3:22:41 PM GMT-04:00, Francisco Olarte <folarte@peoplecal=
l=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 f=
inished application=2E By the way, all information is text, either paragrap=
hs, sentences or single words=2E