Home > mailing lists

Question on Multi-Table Inserts - Mailing list psycopg

From	Don Parris
Subject	Question on Multi-Table Inserts
Date	April 16, 2013 09:59:14
Msg-id	CAJ-7yokqa4Aynm85LRDR1yofU-yFXLLqYJvk8Dp57RNxz97hpQ@mail.gmail.com Whole thread Raw
Responses	Re: Question on Multi-Table Inserts Re: Question on Multi-Table Inserts
List	psycopg

Hi all,

This is more of a strategic question. If I want to enter a particular financial transaction in my DB, I need to use the following process:

Insert a new or select an existing payee

Insert a new transaction record (using the payee_id from the payee table)

Insert at least one, but usually more line items (using the transrec_id from the transrec table)

Insert a new or select an existing category for the transaction line item (using the cat_id) from the category table.

Is it as simple as running a series of insert statements in succession, passing on the PK of the first table to the next table in the process? I.e.,

BEGIN

INSERT into table payee(values...)

INSERT into table transrec(values...) # pass in payee_id variable

SELECT *from category (to get cat_id)
INSERT into table transdetails(values...) #pass in transrec_id and cat_id variables

COMMIT

Or is it more complicated than that?

Thanks!

Don

--
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate

GPG Key ID: F5E179BE

psycopg by date:

From: David Gilman
Date: 11 April 2013, 20:52:38
Subject: Building psycopg2 under cygwin

From: Joe Abbate
Date: 16 April 2013, 11:02:33
Subject: Re: Question on Multi-Table Inserts