Re: New user questions

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.klaver@aklaver.com