Date: Mon, 10 Mar 2025 15:15:10 -0400
User-Agent: K-9 Mail for Android
In-Reply-To: <4835994a-aecf-4fef-bb75-9a4c5f6e0ffd@aklaver.com>
References: <84A5765B-1D3C-485B-B852-99D63D53963E@meddatainc.com> <4835994a-aecf-4fef-bb75-9a4c5f6e0ffd@aklaver.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: <EEE7D9EB-CDFE-420F-9A84-A51E80EC644B@meddatainc.com>
UI-OutboundReport: notjunk:1;M01:P0:UI/BHxTibRE=;7yZVbyAcza6yhSbtSKnZPsu5sxE
 Fp4OYYgJRXBV1mObgIXKt708H0wvV0VO/sONpvfmPrg5auF9EzMITowhHE1dP7us5o6YnpTpp
 tAz//JRO8tHmgLkeeuWgxZ3X5xWAh6vILlhgxwDzmk9lOlvbDFwafGOutzKHUNkqxO/ltpMRQ
 mBIA9/zKduZnpv2ydcu+i9zwzPQ5yPCpwU/T9piRFP5N49mk2rgPXZI+w/1hIlG86exZir9OB
 TPiK3IYnOD0VuqytgTtUYMKIfF5IlV9+vvwB6vUAxOS4BHw2VGH7KoatppmPiemzyPOTwa/87
 xogMcflDxq0/dFP90qAAgcZZxp/gC0TzLsk47ZdQKlYYIDopt72cZ6H9MbUVBH8XjLPxlNtky
 RQbvJEKW2poDdcoseBqleDltDTyqDK+WsxeIDzg39lMOYeUrEWwR06zu4zM+aMa2NW1dDmHO7
 MBP7r+WnZi4wbh/rudl4hu+TFmGYcf+q6POb8o+PmChs6BZ/rXMBSEqtkwT3b1bF6e58LwQ9L
 E1HYyaXuWwbixG8Sget0niSc6Wk3vDIsSfKIhAXNLI6oH6s642xe1TbNeWzkYF74okcitIqGq
 raRPLzDdT24oDm/cpDmgdvtjvtICcWcEV4bdiM8IZE0/nHfxfhZsYY2hzOzStyMIoBAHK1QEP
 Ede2qef8vqN8VArKykVI0BnzfULP7zo8eOAQnS352bW4r9vItebN7LT0QooZVIOql2e04uB6h
 sX6B/Zx9SqMsduO8o9QV9JjV3/gtp/4KeQ5278ykoH/SqznIn912zfwaLkS0KXfe0iYCw0RhA
 bwFkMvo9rzJL3eHhMrMK2VHKhm6KymPNDhhIwXS8JhQquS0+tR4f+7nblk4jUQ406YybPOtIf
 l87+wmouHkcit8HzkWyiT2Gc9QPWJRu2Fs+b9ZYZDxG8wGJqQ/+nyC8restt7XbW9ywXKSoJZ
 kbXoP/HDxz60BxV9WML++2xFdosM/vMuSZYiX5JZljXtuJ52dFhfHqXEMVMB1nnrcttkBxDYS
 hfz2vVczPhjVa4+nkmQ3plqL29MgGJlMPy3Z2IOxof8dHcsc99tSMWErdbRdMdOcvF7CGCmmk
 pjXxukVvsMRzkiaB3IhRRF0vPq+9YJKsyc+bnt/EsZD16bs+IqqzDU5Xae5/5uVxpzOGFpmq2
 IylNv9NtMalOXS367e4eZHP0EF+u0gM09hSPUy5d9pXhv1H+pcXJTP/8ZumP7o2auUita4/Qu
 V4tUmuEhvJBrdXKJsT7Zaz8zRdq5QgQMvhGamP67VMlfprH0G35BtscNyXH62h7xvtBaH02Ru
 g5NboLb2sfUU4vT09mR1cKd3NRrlVkmNKrt5UHai3ytqPK3CAvbYWhT/8VxT27yYJZQ
Archived-At: <https://www.postgresql.org/message-id/EEE7D9EB-CDFE-420F-9A84-A51E80EC644B%40meddatainc.com>
Precedence: bulk

On March 10, 2025 2:26:48 PM GMT-04:00, Adrian Klaver <adrian=2Eklaver@akla=
ver=2Ecom> wrote:
>
>
>On 3/10/25 11:09 AM, H wrote:
>> I am developing a complex multi-tenant application in postgresql 16
>in Linux=2E During the development I would like to be able to enter test
>data into various related tables at any given time for testing
>purposes=2E
>>=20
>> While this can certainly be accomplished by predefined CTE INSERT
>statements in an SQL file, I would prefer something more flexible=2E I am
>thinking of using a markdown file as a source for these CTE INSERT
>statements=2E Specifically, having a certain structure in the markdown
>file where a given markdown heading level, bullet level etc=2E would
>correspond to specific tables and columns=2E
>
>Why CTE INSERTs?
>
>>=20
>> 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
>>=20
>> I hope the above outline is understandable and am interested in
>comments and thoughts on my above approach=2E
>>=20
>> Thanks=2E
>>=20
>>=20

There are tables referencing each other using randomly generated IDs, ie=
=2E those IDs are not known until after the parent table row is inserted=2E