Re: Python i MySQL BLOB

Article View: pl.comp.lang.python

Article #27151

Back to pl.comp.lang.python Previous Next

#27151

From: Bart Ogryczak
Date: Wed, 06 Jan 2010 08:54

18 lines
1808 bytes

On Jan 5, 4:24 pm, królewna <krole...@ee.pl> wrote:
> Witam,
>
> Chciałam sobie ostatnio zapisać obiekt w BLOBie w mysql. Więc wzięłam
> standardowo obiekt zpiklowałam i chciałam wrzucić do BLOBa przez
> następującą instrukcję:
>
> pick = cPickle.dumps("dsdasdas")
> cur.execute("INSERT INTO test VALUES(10, %s, 3);" % pick)


> gdzie tabela test ma kolumny:
> 1. ID - int, primary key, autoincrement, not null
> 2. dane - BLOB
> 3. liczba - INTEGER

cur.execute("INSERT INTO test (dane, liczba) VALUES (%s, %d)", (pick,
3))

Technical Details

Message-ID: <90d368fa-41f8-4425-a487-2a5a6843b26f@a15g2000yqm.googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.gazeta.pl!feed.news.interia.pl!news.nask.pl!news.nask.org.pl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!a15g2000yqm.googlegroups.com!not-for-mail

References: <hhvlil$cso$1@achot.icm.edu.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.gazeta.pl!feed.news.interia.pl!news.nask.pl!news.nask.org.pl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!a15g2000yqm.googlegroups.com!not-for-mail
From: Bart Ogryczak <b.ogryczak@gmail.com>
Newsgroups: pl.comp.lang.python
Subject: Re: Python i MySQL BLOB
Date: Wed, 6 Jan 2010 00:54:54 -0800 (PST)
Organization: http://groups.google.com
Lines: 21
Message-ID: <90d368fa-41f8-4425-a487-2a5a6843b26f@a15g2000yqm.googlegroups.com>
References: <hhvlil$cso$1@achot.icm.edu.pl>
NNTP-Posting-Host: 94.100.112.225
Mime-Version: 1.0
X-Trace: posting.google.com 1262768094 28853 127.0.0.1 (6 Jan 2010 08:54:54 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 6 Jan 2010 08:54:54 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: a15g2000yqm.googlegroups.com; posting-host=94.100.112.225;  posting-account=1kG_1AoAAADLEA3eucGvO2J-Uo4aPCW_
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US)  AppleWebKit/532.5 (KHTML, like Gecko) Chrome/4.0.249.43 Safari/532.5,gzip(gfe),gzip(gfe)
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message