Subject: Re: New user questions
To: Rich Shepard <rshepard@appl-ecosys.com>, psycopg@postgresql.org
References: <alpine.LNX.2.20.2107131228540.11509@salmo.appl-ecosys.com>
 <36d964b4-e04b-5fdf-9b21-d3bf80a3505d@aklaver.com>
 <alpine.LNX.2.20.2107131457030.11509@salmo.appl-ecosys.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <9b477722-71af-abbb-8db7-1390a9906b07@aklaver.com>
Date: Tue, 13 Jul 2021 15:23:11 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
 Thunderbird/78.11.0
MIME-Version: 1.0
In-Reply-To: <alpine.LNX.2.20.2107131457030.11509@salmo.appl-ecosys.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/9b477722-71af-abbb-8db7-1390a9906b07%40aklaver.com>
Precedence: bulk

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