On 7/13/21 3:02 PM, Rich Shepard wrote:
On Tue, 13 Jul 2021, Adrian Klaver wrote:
Triple quoting is used when the statement extends across more then one
line. Pair of double quotes is used for single line statement, especially
when there are single quoted values in the statement.
Adrian,
That makes sense: the statements are treated as comments. I hadn't thought
of them that way.
To be clear triple quoting is just one of the ways you can quote things
in Python. When it is done in a specific location in a function, class
or class method then it becomes a docstring(comment). It does not turn
other things into a comment.
There are several ways to read the above.
Send some examples of what you want to do.
Here's a template:
update contacts
set where
;
The contacts table has these attributes:
person_nbr | integer
act_date | date
act_type | character varying(12)
notes | text
next_contact | date
Could be a changed next_contact date, or notes, or both.
Other tables need updating; for example, a new job title for a person or a
new web site for a company.
Then you want to take a look at this:
https://www.psycopg.org/docs/sql.html
For an UPDATE example see my answer to this Stack Overflow question:
https://stackoverflow.com/questions/68321746/how-to-create-a-dynamic-update-query-in-sql-using-python/68323019#comment120800261_68323019
Thanks,
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
