Article View: pl.comp.lang.python
Article #28474Re: psycopg2, bigint w tabeli
From: Jordan Szubert
Date: Tue, 20 Aug 2013 17:12
Date: Tue, 20 Aug 2013 17:12
13 lines
1308 bytes
1308 bytes
Dnia 20-08-2013 o 18:38:31 curious <grick207@gmail.com> napisał(a):
może zadziała to?
- "DELETE FROM tab WHERE obiekt NOT IN %s" %(tuple(zbior),)
+ "DELETE FROM tab WHERE obiekt NOT IN %s"
%(str(tuple(zbior)).replace('L',''),)
a w ogóle, to parametry przekazuj jako parametry, a nie generuj ręcznie
stringa, to kiepski pomysł
--
Jordan Szubert
Technical Details
Message-ID:
<op.w14kqrkghilul8@asus7h.home>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!news.cyf-kr.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.glorb.com!news-out.readnews.com!transit3.readnews.com!nx02.iad01.newshosting.com!newshosting.com!newsfeed.neostrada.pl!unt-exc-01.news.neostrada.pl!unt-spo-b-01.news.neostrada.pl!news.neostrada.pl.POSTED!not-for-mailReferences:
<e1ed7712-1f9a-4bb5-bd1c-ad272c34456e@googlegroups.com>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!agh.edu.pl!news.agh.edu.pl!news.cyf-kr.edu.pl!news.nask.pl!news.nask.org.pl!news.unit0.net!news.glorb.com!news-out.readnews.com!transit3.readnews.com!nx02.iad01.newshosting.com!newshosting.com!newsfeed.neostrada.pl!unt-exc-01.news.neostrada.pl!unt-spo-b-01.news.neostrada.pl!news.neostrada.pl.POSTED!not-for-mail Newsgroups: pl.comp.lang.python Subject: Re: psycopg2, bigint w tabeli References: <e1ed7712-1f9a-4bb5-bd1c-ad272c34456e@googlegroups.com> Date: Tue, 20 Aug 2013 19:12:16 +0200 MIME-Version: 1.0 From: "Jordan Szubert" <usenet@joru.us.to> Organization: HELL inc. Message-ID: <op.w14kqrkghilul8@asus7h.home> User-Agent: Opera Mail/12.16 (Win32) Lines: 17 NNTP-Posting-Host: 83.10.207.143 X-Trace: 1377018739 unt-rea-b-01.news.neostrada.pl 1219 83.10.207.143:56836 X-Complaints-To: abuse@news.neostrada.pl Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit