Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!nntp-feed.chiark.greenend.org.uk!ewrotcd!news.nosignal.org!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Newsgroups: comp.lang.python
Date: Tue, 22 Jan 2013 06:55:04 -0800 (PST)
In-Reply-To: <mailman.790.1358865192.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: <adcfb222-a038-4700-8959-38e452c04b85@googlegroups.com> <50fe787e$0$30003$c3e8da3$5496439d@news.astraweb.com> <f4298c6f-81a2-45c7-903b-015e9f17d5a7@googlegroups.com> <mailman.784.1358857784.2939.python-list@python.org> <mailman.785.1358858844.2939.python-list@python.org> <50fe8e69$0$30003$c3e8da3$5496439d@news.astraweb.com> <0459659d-4ec2-4c7d-bee3-b4e363c916dd@googlegroups.com> <mailman.790.1358865192.2939.python-list@python.org>
User-Agent: G2/1.0
MIME-Version: 1.0
Subject: Re: Using filepath method to identify an .html page
From: Ferrous Cranus <nikos.gr33k@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.798.1358868801.2939.python-list@python.org>
Lines: 118
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:37286

=CE=A4=CE=B7 =CE=A4=CF=81=CE=AF=CF=84=CE=B7, 22 =CE=99=CE=B1=CE=BD=CE=BF=CF=
=85=CE=B1=CF=81=CE=AF=CE=BF=CF=85 2013 4:33:03 =CE=BC.=CE=BC. UTC+2, =CE=BF=
 =CF=87=CF=81=CE=AE=CF=83=CF=84=CE=B7=CF=82 Chris Angelico =CE=AD=CE=B3=CF=
=81=CE=B1=CF=88=CE=B5:
> On Wed, Jan 23, 2013 at 12:57 AM, Ferrous Cranus <nikos.gr33k@gmail.com> =
wrote:
>=20
> > =CE=A4=CE=B7 =CE=A4=CF=81=CE=AF=CF=84=CE=B7, 22 =CE=99=CE=B1=CE=BD=CE=
=BF=CF=85=CE=B1=CF=81=CE=AF=CE=BF=CF=85 2013 3:04:41 =CE=BC.=CE=BC. UTC+2, =
=CE=BF =CF=87=CF=81=CE=AE=CF=83=CF=84=CE=B7=CF=82 Steven D'Aprano =CE=AD=CE=
=B3=CF=81=CE=B1=CF=88=CE=B5:
>=20
> >
>=20
> >> What do you expect int("my-web-page.html") to return? Should it return=
 23
>=20
> >> or 794 or 109432985462940911485 or 42?
>=20
> >
>=20
> > I expected a unique number from the given string to be produced so i co=
uld have a (number <=3D> string) relation. What does int( somestring ) is r=
eturning really? i don;t have IDLE to test.
>=20
>=20
>=20
> Just run python without any args, and you'll get interactive mode. You
>=20
> can try things out there.
>=20
>=20
>=20
> > This counter.py will work on a shared hosting enviroment, so absolutes =
paths are BIG and expected like this:
>=20
> >
>=20
> > /home/nikos/public_html/varsa.gr/articles/html/files/index.html
>=20
>=20
>=20
> That's not big. Trust me, modern databases work just fine with unique
>=20
> indexes like that. The most common way to organize the index is with a
>=20
> binary tree, so the database has to look through log(N) entries.
>=20
> That's like figuring out if the two numbers 142857 and 857142 are the
>=20
> same; you don't need to look through 1,000,000 possibilities, you just
>=20
> need to look through the six digits each number has.
>=20
>=20
>=20
> > 'pin' has to be a number because if i used the column 'page' instead, j=
ust imagine the database's capacity withholding detailed information for ea=
ch and every .html requested by visitors!!!
>=20
>=20
>=20
> Not that bad actually. I've happily used keys easily that long, and
>=20
> expected the database to ensure uniqueness without costing
>=20
> performance.
>=20
>=20
>=20
> > So i really - really need to associate a (4-digit integer <=3D> htmlpag=
e's absolute path)
>=20
>=20
>=20
> Is there any chance that you'll have more than 10,000 pages? If so, a
>=20
> four-digit number is *guaranteed* to have duplicates. And if you
>=20
> research the Birthday Paradox, you'll find that any sort of hashing
>=20
> algorithm is likely to produce collisions a lot sooner than that.
>=20
>=20
>=20
> > Maybe it can be done by creating a MySQL association between the two co=
lumns, but i dont know how such a thing can be done(if it can).
>=20
> >
>=20
> > So, that why i need to get a "unique" number out of a string. please he=
lp.
>=20
>=20
>=20
> Ultimately, that unique number would end up being a foreign key into a
>=20
> table of URLs and IDs. So just skip that table and use the URLs
>=20
> directly - much easier. In this instance, there's no value in
>=20
> normalizing.
>=20
>=20
>=20
> ChrisA

I insist, perhaps compeleld, to use a key to associate a number to a filena=
me.
Would you help please?

I dont know this is supposed to be written. i just know i need this:

number =3D function_that_returns_a_number_out_of_a_string( absolute_path_of=
_a_html_file)

Would someone help me write that in python coding? We are talkign 1 line of=
 code here....