Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #56216

Re: Database statements via python but database left intact

Path csiph.com!usenet.pasdenom.info!news.franciliens.net!gegeweb.org!newsfeed.kamp.net!newsfeed.kamp.net!feeder1.cambriumusenet.nl!feed.tweaknews.nl!194.109.133.81.MISMATCH!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!news.tele.dk!news.tele.dk!small.news.tele.dk!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path <z@etiol.net>
X-Original-To python-list@python.org
Delivered-To python-list@mail.python.org
X-Spam-Status OK 0.165
X-Spam-Level *
X-Spam-Evidence '*H*': 0.72; '*S*': 0.05; 'explicit': 0.07; 'committing': 0.09; 'runs': 0.10; 'changes': 0.15; '(either': 0.16; 'received:209.85.213.176': 0.16; 'subject:python': 0.16; 'sat,': 0.16; 'wrote:': 0.18; 'code,': 0.22; 'header:User- Agent:1': 0.23; 'error': 0.23; 'asking': 0.27; 'header:In-Reply- To:1': 0.27; 'code': 0.31; 'subject:Database': 0.31; 'received:209.85': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'url:org': 0.36; 'received:209': 0.37; 'to:addr:python-list': 0.38; 'sure': 0.39; 'to:addr:python.org': 0.39; 'today,': 0.61; "you're": 0.61; 'content-disposition:inline': 0.62; 'yes': 0.68; 'received:190': 0.69; '8bit%:100': 0.72; '05,': 0.84; 'database:': 0.84; 'instantly': 0.84; 'received:190.163': 0.84; 'subject:via': 0.84; '2013': 0.98
X-Google-DKIM-Signature v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:date:from:to:subject:message-id:references :mime-version:content-type:content-disposition :content-transfer-encoding:in-reply-to:user-agent; bh=FBulv/oQ8W0Y5zcqDxQT2HajZIkIHJ4mkE+wJeGpGdk=; b=gIlyaAr2D6Qhwp9pImhg0UhXPfI7KVkrGZs7f78zzXgnFv1wqy+l8hbWRecBjaGysq kxre68WWDY02SZ66zK5RoCD1gacG1ILw1hRsCvDP7KADqWO8HTM0iw+veXjNB4g+vDbO rlHxocLSzRRixd8FbU3jnNBroi7AHAjDmTRbHa8juIUnyQD2Rp6r3YtvtBysrd6pLA3B S25405NGC0tmuHv3UPyuH+I5ofLlw4pXTr0QG4v2/JPOrootl1BvZhj5INunpNRiHEt7 wsPmL30CYwMR8QJkhxe9/kGbMoEU12W+Cr2eo+UJM4AP7/DCuv+upsnJIKsAAIuHQkpz Sk4g==
X-Gm-Message-State ALoCoQn9goF6YPQRsmtnAhPKeuftf7FHZkL8SsSev8/71tHaE3TWQxGuzpfzmjfijm5+DBOevhS1
X-Received by 10.236.122.239 with SMTP id t75mr16434075yhh.57.1381001406720; Sat, 05 Oct 2013 12:30:06 -0700 (PDT)
Date Sat, 5 Oct 2013 16:29:55 -0300
From Zero Piraeus <z@etiol.net>
To python-list@python.org
Subject Re: Database statements via python but database left intact
References <l2pois$359$1@dont-email.me>
MIME-Version 1.0
Content-Type text/plain; charset=utf-8
Content-Disposition inline
Content-Transfer-Encoding 8bit
In-Reply-To <l2pois$359$1@dont-email.me>
X-PGP-Key http://etiol.net/pubkey.asc
User-Agent Mutt/1.5.21 (2010-09-15)
X-BeenThere python-list@python.org
X-Mailman-Version 2.1.15
Precedence list
List-Id General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive <http://mail.python.org/pipermail/python-list/>
List-Post <mailto:python-list@python.org>
List-Help <mailto:python-list-request@python.org?subject=help>
List-Subscribe <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups comp.lang.python
Message-ID <mailman.757.1381001416.18130.python-list@python.org> (permalink)
Lines 21
NNTP-Posting-Host 2001:888:2000:d::a6
X-Trace 1381001416 news.xs4all.nl 15994 [2001:888:2000:d::a6]:32918
X-Complaints-To abuse@xs4all.nl
Xref csiph.com comp.lang.python:56216

Show key headers only | View raw

:

On Sat, Oct 05, 2013 at 10:16:46PM +0300, Νίκος Αλεξόπουλος wrote:
> Excuse me for asking again today, but i see no error in the
> following code, yes no isertion or update happens into the database:
> 
> [...]
> 
> When this code runs i check instantly my database via PHPMyAdmin and
> i see that it was left intact.

Are you sure that you're committing your changes (either by having
autocommit set or using an explicit con.commit() call)?

http://geert.vanderkelen.org/dont-forget-the-commit-in-mysql/

 -[]z.

-- 
Zero Piraeus: inter caetera
http://etiol.net/pubkey.asc

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Database statements via python but database left intact Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 22:16 +0300
  Re: Database statements via python but database left intact Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 22:27 +0300
  Re: Database statements via python but database left intact Zero Piraeus <z@etiol.net> - 2013-10-05 16:29 -0300
    Re: Database statements via python but database left intact Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-05 22:36 +0300
      Re: Database statements via python but database left intact Ian Kelly <ian.g.kelly@gmail.com> - 2013-10-05 14:31 -0600
        Re: Database statements via python but database left intact Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-06 00:02 +0300
          Re: Database statements via python but database left intact Ned Batchelder <ned@nedbatchelder.com> - 2013-10-05 17:39 -0400
          Re: Database statements via python but database left intact Chris Angelico <rosuav@gmail.com> - 2013-10-06 09:51 +1100
          Database engine bindings for Python (was: Database statements via python but database left intact) Ben Finney <ben+python@benfinney.id.au> - 2013-10-06 12:05 +1100
          Re: Database engine bindings for Python (was: Database statements via python but database left intact) Chris Angelico <rosuav@gmail.com> - 2013-10-06 12:19 +1100
          Re: Database engine bindings for Python (was: Database statements via python but database left intact) Dan Sommers <dan@tombstonezero.net> - 2013-10-06 06:22 +0000
            Re: Database engine bindings for Python (was: Database statements via python but database left intact) Chris “Kwpolska” Warrick <kwpolska@gmail.com> - 2013-10-06 11:10 +0200
            Re: Database engine bindings for Python (was: Database statements via python but database left intact) Chris Angelico <rosuav@gmail.com> - 2013-10-07 00:37 +1100
              Re: Database engine bindings for Python (was: Database statements via python but database left intact) Roy Smith <roy@panix.com> - 2013-10-06 10:05 -0400
          Re: Database statements via python but database left intact Chris “Kwpolska” Warrick <kwpolska@gmail.com> - 2013-10-06 11:05 +0200
            Re: Database statements via python but database left intact rusi <rustompmody@gmail.com> - 2013-10-06 04:36 -0700
              Re: Database statements via python but database left intact Chris “Kwpolska” Warrick <kwpolska@gmail.com> - 2013-10-06 14:01 +0200
          Re: Database statements via python but database left intact Zero Piraeus <z@etiol.net> - 2013-10-05 18:45 -0300
            Re: Database statements via python but database left intact Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-06 18:57 +0300
              Re: Database statements via python but database left intact Piet van Oostrum <piet@vanoostrum.org> - 2013-10-06 17:40 -0400
          Re: Database statements via python but database left intact Adam Tauno Williams <awilliam@whitemice.org> - 2013-10-06 11:55 -0400
      Re: Database statements via python but database left intact Adam Tauno Williams <awilliam@whitemice.org> - 2013-10-06 11:52 -0400
        Re: Database statements via python but database left intact Νίκος Αλεξόπουλος <nikos.gr33k@gmail.com> - 2013-10-06 19:49 +0300

csiph-web