Improve reduce functions of SQLite3 request

From	Steffen Mutter <steffen@webanimations.de>
Newsgroups	comp.lang.python
Subject	Improve reduce functions of SQLite3 request
Date	2013-02-03 09:46 +0000
Organization	GNUher.de
Message-ID	<kelbl0$1jv$1@nerdhammel.gnuher.de> (permalink)

Show all headers | View raw

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 place="karlsruhe" GROUP BY nr LIMIT 10

ACTUAL RESULT:
359|TV Calmbach
21101|SG Heidel/Helm
21236|JSG Neuth/Büch
23108|TG Eggenstein
23108|TG Eggenstein 2
23109|TV Ettlingenw
23109|TV Ettlingenw 2
23112|TSV Jöhlingen
23112|TSV Jöhlingen 2
23112|TSV Jöhlingen 3

NEEDED RESULT:
359|TV Calmbach
21101|SG Heidel/Helm
21236|JSG Neuth/Büch
23108|TG Eggenstein
23109|TV Ettlingenw
23112|TSV Jöhlingen

the nr needs to be unique together with the shortest clubname returned
by the where clause.

Any hints how to get this done either with SQLite3 tecneeqs or python
functions.

Kind regards.
SMut

Back to comp.lang.python | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-03 09:46 +0000
  Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-03 13:11 -0500
    Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-04 14:30 +0000
      Re: Improve reduce functions of SQLite3 request Dave Angel <davea@davea.name> - 2013-02-04 10:30 -0500
      Re: Improve reduce functions of SQLite3 request Peter Otten <__peter__@web.de> - 2013-02-04 17:29 +0100
      Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-04 15:45 -0500
        Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-04 22:05 +0000
          Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-04 18:47 -0500
            Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-06 09:18 +0000
              Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-06 12:26 -0500
                Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-06 23:33 +0000
                Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-07 00:40 -0500
                Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-07 11:33 +0000
                Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-07 13:03 -0500
                Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-07 22:54 +0000
                Re: Improve reduce functions of SQLite3 request Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2013-02-08 12:17 -0500
                Re: Improve reduce functions of SQLite3 request Steffen Mutter <steffen@webanimations.de> - 2013-02-08 19:59 +0000

csiph-web