Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder.erje.net!eu.feeder.erje.net!xlned.com!feeder1.xlned.com!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Newsgroups: comp.lang.python
Date: Wed, 6 Mar 2013 08:09:23 -0800 (PST)
In-Reply-To: <mailman.2947.1362578676.2939.python-list@python.org>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=94.68.127.128; posting-account=hGu1uQoAAACZy7LiR653nG0NwqDrTyoS
References: <390f0dc5-5750-4849-9433-a19d90cc8566@googlegroups.com> <kh7ajh$jlc$1@ger.gmane.org> <mailman.2947.1362578676.2939.python-list@python.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Subject: Re: sync databse table based on current directory data without losign previous values
From: nagia.retsina@gmail.com
To: comp.lang.python@googlegroups.com
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Cc: python-list@python.org
Precedence: list
Message-ID: <mailman.2954.1362592425.2939.python-list@python.org>
Lines: 102
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:40653

=CE=A4=CE=B7 =CE=A4=CE=B5=CF=84=CE=AC=CF=81=CF=84=CE=B7, 6 =CE=9C=CE=B1=CF=
=81=CF=84=CE=AF=CE=BF=CF=85 2013 4:04:26 =CE=BC.=CE=BC. UTC+2, =CE=BF =CF=
=87=CF=81=CE=AE=CF=83=CF=84=CE=B7=CF=82 Michael Ross =CE=AD=CE=B3=CF=81=CE=
=B1=CF=88=CE=B5:
> On Wed, 06 Mar 2013 12:52:00 +0100, Mark Lawrence =20
>=20
> <breamoreboy@yahoo.co.uk> wrote:
>=20
>=20
>=20
> > On 06/03/2013 07:45, =CE=9D=CE=AF=CE=BA=CE=BF=CF=82 =CE=93=CE=BA=CF=813=
3=CE=BA wrote:
>=20
> >> I'am using this snipper to read a current directory and insert all =20
>=20
> >> filenames into a databse and then display them.
>=20
> >>
>=20
> >> But what happens when files are get removed form the directory?
>=20
> >> The inserted records into databse remain.
>=20
> >> How can i update  the databse to only contain the existing filenames =
=20
>=20
> >> without losing the previous stored data?
>=20
> >>
>=20
> >> Here is what i ahve so far:
>=20
> >>
>=20
> >> =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
>=20
> >> path =3D "/home/nikos/public_html/data/files/"
>=20
> >>
>=20
> >> #read the containing folder and insert new filenames
>=20
> >> for result in os.walk(path):
>=20
> >
>=20
> > You were told yesterday at least twice that os.walk returns a tuple but=
 =20
>=20
> > you still insist on refusing to take any notice of our replies when it =
=20
>=20
> > suits you, preferring instead to waste everbody's time with these =20
>=20
> > questions.  Or are you trying to get into the Guinness Book of World =
=20
>=20
> > Records for the laziest bastard on the planet?
>=20
>=20
>=20
> Hold on a sec ...
>=20
>=20
>=20
> He has
>=20
>=20
>=20
> for result in os.walk(path):
>=20
> 	for filename in result[2]:
>=20
>=20
>=20
> So he *did* take notice of that.
>=20
>=20
>=20
>=20
>=20
> Nikos:
>=20
> Expectation is to iterate through a tuple like this:
>=20
>=20
>=20
> for dirpath, dirnames, filenames in os.walk(path):
>=20
> 	...

Thank you Michael, yes i ahve understood that myself yesterday after one of=
 the guys here have shown the output of os.walk(path) in IDLE.=20
So, yes in fact i was in need for the 3rd item in the tuple, so to get hold=
 on to the files.

Thank you for supporting me, some ppl here think i'am a troll and don't try=
 thinks or ignore evrything but 'some_ppl's_opinion !=3D True'

I'am just sometimes persistant on having thing my way that why i was callin=
g my self Ferrous cRanus, which i changes it since it was annoying....