Re: problem creating users via pythons script

Volkan YAZICI wrote:
> On Jul 19 10:40, Timothy Smith wrote:
>   
>> Volkan YAZICI wrote:
>>     
>>> On Jul 19 10:02, Timothy Smith wrote:
>>>  
>>>       
>>>> cur.execute("""CREATE USER %s WITH PASSWORD %s IN GROUP %s 
>>>> """,(StaffUserName,NewPassword,StaffGroup))
>>>>
>>>> produces this error
>>>>
>>>> ERROR:  syntax error at or near "'bob.smith'" at character 13
>>>>    
>>>>         
>>> IIRC, per Python DB-API PEP, the DB adapter you use try to escape and
>>> quote any parameter you specified. Please try to use python parameters,
>>> that are "% (param1, param2, ...)", only for values; not for any other
>>>       
>
> Edit: «% (param1, param2, ...)» part must be replaced with
>       «"query_str", param1, param2, ...»
>
>   
>>> place in the query string.
>>>
>>> To summarize, you can only use parameters for values, not keys.
>>>       
>> ...
>> ah ok so how do i do it :/
>>     
>
> Just don't pass username as parameter to Cursor.execute(), for instance:
>
> cur.execute("CREATE USER %s WITH PASSWORD %s IN GROUP %s"
>             % (StaffUserName, NewPassword, StaffGroup))
>
>
> Regards.
>
> P.S. Please don't forget to CC mailing list next time. Also, -interface
>      ml is more appropriate for these kind of questions.
>
>
>   
of course, i should have seen that to begin with, cheers.