Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Newsgroups: comp.lang.python
Date: Mon, 28 Jan 2013 01:44:43 -0800 (PST)
In-Reply-To: <mailman.1121.1359319842.2939.python-list@python.org>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=94.68.70.179; posting-account=DYJQ-woAAACEPH85Au2BhUVfFTfSfVa4
References: <6ad78df4-0ec0-4760-8f5a-5ecf129c5e65@googlegroups.com> <mailman.1086.1359223462.2939.python-list@python.org> <d543dccf-af7a-4efd-adc5-13d9ef080c1e@googlegroups.com> <mailman.1090.1359239220.2939.python-list@python.org> <a8690843-35b0-423e-a79d-f2b6c1991be6@googlegroups.com> <63edba3c-55af-4c4c-a311-4188891bfdf0@googlegroups.com> <f0e08aad-3c69-4ba0-82d0-91652997c7d4@googlegroups.com> <mailman.1116.1359311811.2939.python-list@python.org> <mailman.1118.1359312305.2939.python-list@python.org> <d88b7c4c-5576-4477-ae29-c9226ec0e1e4@googlegroups.com> <30d46f31-c056-45cf-8902-213536dc11fc@googlegroups.com> <mailman.1121.1359319842.2939.python-list@python.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Subject: Re: Formatting a column's value output
From: =?ISO-8859-7?B?yv7z9OHyINDh8OHk/PDv9evv8g==?= <nikos.gr33k@gmail.com>
To: comp.lang.python@googlegroups.com
Content-Type: text/plain; charset=ISO-8859-7
Content-Transfer-Encoding: quoted-printable
Cc: python-list@python.org
Precedence: list
Message-ID: <mailman.1127.1359366844.2939.python-list@python.org>
Lines: 142
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:37801

=D4=E7 =CA=F5=F1=E9=E1=EA=DE, 27 =C9=E1=ED=EF=F5=E1=F1=DF=EF=F5 2013 10:50:=
33 =EC.=EC. UTC+2, =EF =F7=F1=DE=F3=F4=E7=F2 Mitya Sirenef =DD=E3=F1=E1=F8=
=E5:
> On 01/27/2013 03:24 PM, =EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=
=BF=BD =EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=
=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD wrote:
>=20
> > =EF=BF=BD=EF=BF=BD =EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=
=BD=EF=BF=BD, 27 =EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=
=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD 2013  9:12:16 =EF=BF=BD.=EF=BF=BD. UTC+2,=
 =EF=BF=BD =EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD =
ru...@yahoo.com =EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD=EF=BF=BD:
>=20
>  >> <python code>
>=20
>  >
>=20
>  > Yes indeed, there is no need to use a loop since i know the exact=20
>=20
> number of items i'am expecting. Thanks you very much for clarifying this=
=20
>=20
> to me:
>=20
>  > One last thing i want to ask you:
>=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=3D=3D=3D=3D=3D=3D
>=20
>  > try:
>=20
>  > cur.execute( '''SELECT host, userOS, browser, hits, lastvisit FROM=20
>=20
> visitors
>=20
>  > WHERE counterID =3D (SELECT ID FROM counters WHERE URL =3D %s) ORDER B=
Y=20
>=20
> lastvisit DESC''', (htmlpage,) )
>=20
>  > except MySQLdb.Error, e:
>=20
>  > print ( "Query Error: ", sys.exc_info()[1].excepinfo()[2] )
>=20
>  > else:
>=20
>  > data =3D cur.fetchall()
>=20
>  >
>=20
>  > for host, useros, browser, hits, lastvisit in data:
>=20
>  > print ( "<tr>" )
>=20
>  >
>=20
>  > for item in host, useros, browser, hits, lastvisit.strftime('%A %e=20
>=20
> %b, %H:%M').decode('cp1253').encode('utf8'):
>=20
>  > print ( "<td><center><b><font color=3Dwhite> %s </td>" % item )
>=20
>  >
>=20
>  > sys.exit(0)
>=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=3D=3D=3D=3D=3D
>=20
>  >
>=20
>  > That would be also written as:
>=20
>  >
>=20
>  > for row in data:
>=20
>  > print ("tr>")
>=20
>  > for item in row:
>=20
>  > print( "blah blah blah" )
>=20
>  >
>=20
>  > And that would make the code easier to read and more clear, but its=20
>=20
> that 'lastvisit' column's value than needs formating,hence it makes me=20
>=20
> use the above syntax.
>=20
>  >
>=20
>  > Is there any simpler way to write the above working code without the=
=20
>=20
> need to specify all of the columns' names into the loop?
>=20
>=20
>=20
>=20
>=20
> You can write:
>=20
>=20
>=20
>   for row in data:
>=20
>       print ("tr>")
>=20
>       row =3D list(row)
>=20
>       row[-1] =3D row[-1].strftime(...)
>=20
>       for item in row:
>=20
>           print( "blah blah blah" )
>=20
>=20
>=20
>=20
>=20
>   - mitya
>=20
>=20
>=20
>=20
>=20
> --=20
>=20
> Lark's Tongue Guide to Python: http://lightbird.net/larks/
>=20
>=20
>=20
> The existence of any evil anywhere at any time absolutely ruins a total
>=20
> optimism.  George Santayana


Thank you very much, your solution makes the code looks so much clearer!