Re: Encountered an error

Поиск
Список
Период
Сортировка
От Shaan Repswal
Тема Re: Encountered an error
Дата
Msg-id CALa+hEQxRRVGJfmebPPpFvKjEDesNv9SJu4-8dMc=PkHao+GQA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Encountered an error  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Ответы Re: Encountered an error
Re: Encountered an error
Список psycopg
Дерево обсуждения
I am new to databases and am a novice to programming in general. But I have a problem and this is the only way it seems to me it will work. I plan on learning the rest later. After I've created this program. To give you guys an idea of how naive I am. Please know that a lot of this just went over my head.

@Daniele if I can't use %s what can I use? The "%l" that Adrian suggested?
@Daniele What do you mean escaping values into identifier names?

@Adrian - I am Python string formatting? Whatt kind of string formatting. Which query should I format? The "Add a new column" query or the "add a value to the column of the currently entered record" query located right after it.
@Adrian - I don't think I understand what you mean by the example of the format() function. Am I supposed to use it in psql? But my program is in Python... Is there some manual where I could get more info on this and where I could see a few examples of this function?

@Karsten - I know, I got the feeling that the design felt awry as well. The database will be on the local machine. And the client side will have the code to error check the column names being added and also if there already is a column by this name or not.



On Thu, Mar 10, 2016 at 8:02 PM, Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
On Thu, Mar 10, 2016 at 03:30:14PM +0100, Karsten Hilbert wrote:

> While this is a nice solution to OPs problem I cannot resist
> the urge to point out that to me the whole approach of adding
> a column from within client code (outside a database
> management application) does have at least a whiff of design
> smell to it.

Like, what happens if the user enters something to be used as
a column name which isn't suitable for an identifier ?

And then what if two different unsuitable user input values
get normalized into the same column-name-suitable version ?

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346


--
Sent via psycopg mailing list (psycopg@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/psycopg

В списке psycopg по дате отправления: