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>
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

:

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