Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder2.hal-mli.net!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.006 X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'continuation': 0.07; 'hosts': 0.07; 'field)': 0.09; 'inserted': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'hits': 0.16; 'inserting': 0.16; 'operation.': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'threads': 0.16; 'visitors:': 0.16; 'wed,': 0.16; "shouldn't": 0.17; 'jan': 0.18; 'python?': 0.20; 'host': 0.24; '----': 0.27; 'header:X-Complaints-To:1': 0.28; 'record': 0.28; 'primary': 0.30; '-----': 0.32; 'url:home': 0.33; 'to:addr:python-list': 0.33; 'table': 0.35; 'received:org': 0.36; 'ability': 0.36; 'charset:us-ascii': 0.36; 'does': 0.37; 'subject:: ': 0.38; 'page': 0.38; 'to:addr:python.org': 0.39; 'called': 0.39; 'header:Received:5': 0.40; 'most': 0.61; '(that': 0.62; 'situation': 0.62; 'pin': 0.65; 'subject: & ': 0.67; "how's": 0.71; 'foreign': 0.72; '2013': 0.84; 'dennis': 0.91 X-Injected-Via-Gmane: http://gmane.org/ To: python-list@python.org From: Dennis Lee Bieber Subject: Re: Uniquely identifying each & every html template Date: Wed, 23 Jan 2013 16:01:05 -0500 Organization: > Bestiaria Support Staff < References: <187d77e0-e948-46bf-acc5-668c446cf3aa@googlegroups.com> <239abe33-fa5b-41a9-ae80-5260b9b1bd9c@googlegroups.com> <2391171e-e170-4647-8924-8e446ea1c6b1@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Gmane-NNTP-Posting-Host: adsl-76-253-100-66.dsl.klmzmi.sbcglobal.net X-Newsreader: Forte Agent 3.3/32.846 X-No-Archive: YES X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 33 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1358974876 news.xs4all.nl 6941 [2001:888:2000:d::a6]:44593 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:37502 On Wed, 23 Jan 2013 01:12:31 -0800 (PST), Ferrous Cranus declaimed the following in gmane.comp.python.general: I shouldn't succumb to the continuation of these threads as they are going past farcical to ludicrous. > > table counters: pin ---- page ----- hosts > > table visitors: pin ---- host ---- hits ---- useros ---- browser ---- date > > 1. Who is going to create the 'pin' ? the database automatically when i'am inserting a new record from python? YES -- It's called a "primary key" and most all databases have the ability to create one via an auto-incrementing field (that is, a new number is generated whenever a new record is inserted that DOES NOT SUPPLY the key field) > 2. How's the 'pin' going to be associated with 'page' ? The primary key is used as a foreign key reference in the other table > 3. if 'page' renames/moves then i have to manually edit the counter database table to find the specific 'page' record and upadate it by hand? > Well, you have that situation with ANY system in which you do not have control over move/rename operation. -- Wulfraed Dennis Lee Bieber AF6VN wlfraed@ix.netcom.com HTTP://wlfraed.home.netcom.com/