Re: Improve reduce functions of SQLite3 request

2013-02-08 Thread Steffen Mutter
Dennis Lee Bieber wrote: > If you use separate tables you make it more difficult to generate > the SQL (as you have to create the SQL with the season specific table > name, instead of just using a "where " clause to restrict data), and > lose the potential to produce reports covering mul

Re: Improve reduce functions of SQLite3 request

2013-02-07 Thread Steffen Mutter
Dennis Lee Bieber wrote: > On Thu, 7 Feb 2013 11:33:00 + (UTC), Steffen Mutter > declaimed the following in > gmane.comp.python.general: >> CREATE TABLE "Runde20122013" ( > > Is that table name specifying a playing season? Yes. > What happens next

Re: Improve reduce functions of SQLite3 request

2013-02-07 Thread Steffen Mutter
Hi Dennis, I really appreciate your input :-) Dennis Lee Bieber wrote: > I'll confess that I've not looked at any such sites -- mainly > because I wouldn't understand enough about the sport to understand why > one would do something one way or another. You better do not. The first one I h

Re: Improve reduce functions of SQLite3 request

2013-02-06 Thread Steffen Mutter
Hi Dennis, Dennis Lee Bieber wrote: > If this is meant to be a web-based system, you probably should be > looking into using some sort of framework: Django, Zope/Plone, etc. I tried both frameworks but I always see, that these frameworks improve the progress to get things done but also lim

Re: Improve reduce functions of SQLite3 request

2013-02-06 Thread Steffen Mutter
Dennis Lee Bieber wrote: > Which does, to me, imply an unnormalized database. The > "team/category" should be a separate field. > club(*ID*, name) > > team(*ID*, /club/, category) > > {where *..* is primary key, /../ is a foreign key} You are right, but as I mentioned above I had to use so

Re: Improve reduce functions of SQLite3 request

2013-02-04 Thread Steffen Mutter
Dennis Lee Bieber wrote: > I suspect you have a poorly normalized database (what does that > trailing number identify? Heck, are the leading initials unique to the > subsequent name?). The trailing number should probably be something > stored as a separate field. If the initials are unique,

Re: Improve reduce functions of SQLite3 request

2013-02-04 Thread Steffen Mutter
Dennis Lee Bieber wrote: > Untested: > > SELECT DISTINCT * from > (select homenr as nr, home as club FROM Runde20122013 > WHERE place="karlsruhe" > UNION SELECT guestnr as nr, guest as club FROM 20122013 > WHERE place="karlsruhe") > l

Re: mySQLdb

2013-02-03 Thread Steffen Mutter
Hi Armin, Armin Karner wrote: > I am curious if there is an update of MySQLdb for python versions 3.3 or > higher. Because I really need this for a diploma thesis.  What feature do you need which is not provided? > I really hope you have a solution for me, because it is quite urgent and > imp

Improve reduce functions of SQLite3 request

2013-02-03 Thread Steffen Mutter
Hi, I am writing some code to manage handball leagues more easy. Problem: MISSON: Get single club ids glued together with the shortest teamname. EXAMPLE: SELECT homenr as nr, home as club FROM Runde20122013 WHERE place="karlsruhe" UNION SELECT guestnr as nr, guest as club FROM 20122013 WHERE pl

Re: SQLite and Python 2.4

2008-07-04 Thread Steffen Mutter
Hi Joe! Am Tue, 01 Jul 2008 17:51:35 -0700 schrieb Joe Goldthwaite: > I'm confused. (Not a new experience). Everyone looking for help in the usenet asking for help is sharing your disease. > I've got a web application > running under Zope. I use the Wing IDE for testing and debugging. Okay

Re: Problems with Tkinter

2006-01-01 Thread Steffen Mutter
Am Sun, 01 Jan 2006 18:36:56 +0100 schrieb Kevin: > Try: > > fenster.title("Demofenster") Exactly. I had a look in Michael Lauer's 'Python & GUI-Toolkits' meanwhile, so I found the clue. > "title" a class method, not a variable. Yep. Thank you: > Kevin. Steffen -- http://mail.python.org/ma

Problems with Tkinter

2006-01-01 Thread Steffen Mutter
Hi all and a happy new year! My first try fiddling around with GUIs ended disappointing, instead of showing the window title as expected 'Demofenster' ist still shows 'tk' instead. What did I do wrong? #!/usr/bin/env python from Tkinter import * fenster = Tk() fenster.title = 'Demofenster' fen