On March 10, 2025 2:26:48 PM GMT-04:00, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote: > > >On 3/10/25 11:09 AM, H wrote: >> I am developing a complex multi-tenant application in postgresql 16 >in Linux. During the development I would like to be able to enter test >data into various related tables at any given time for testing >purposes. >> >> While this can certainly be accomplished by predefined CTE INSERT >statements in an SQL file, I would prefer something more flexible. I am >thinking of using a markdown file as a source for these CTE INSERT >statements. Specifically, having a certain structure in the markdown >file where a given markdown heading level, bullet level etc. would >correspond to specific tables and columns. > >Why CTE INSERTs? > >> >> 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. Howevever, it gets complex >since I need to handle 1:N relationships between tables in the markdown >file... >> >> I hope the above outline is understandable and am interested in >comments and thoughts on my above approach. >> >> Thanks. >> >> There are tables referencing each other using randomly generated IDs, ie. those IDs are not known until after the parent table row is inserted.
