Re: [SQLObject] Select Single Random Record
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Pʀoмᴇтнᴇυs 0. <pro...@gm...> - 2012-04-18 19:15:27
|
I'll see about adding a recipe to the SQLObject Community Doc site for this. ( https://sites.google.com/site/sqlobject/ ) On Wed, Apr 18, 2012 at 12:46 PM, Petr Jakeš <pet...@tp...> wrote: > > To give context to the issue, I am building my own icecast2 broadcaster. I >> want >> to have an Auto DJ feature which will pick a random song from the >> database which >> hasn't recently been played plus some other criteria. It really doesn't >> matter >> which record i get back from the database, I just need one at random. >> > > *Get the list of valid IDs from the remote database using the raw SQL > command > something like:* > > con = connectionForURI("firebird://yourUserName:yourPassword@serverAddress > :3050/pat/to/database/database.file") > > validIDs= "SELECT ID FROM SONGS_TABLE where ......" > > returnedIDs = con.queryAll(validIDs) > > # you get the list of valid IDs, something like this: [(1,), (2,), (3,), > (4,), (5,), (6,), (7,), (8,), (9,), (11,)] > > *than:* > > import random > randomID = random.choice(returnedIDs)[0] > randomSong = SongsTable.get(randomID) > > HTH > > Regards > > Petr > > > ------------------------------------------------------------------------------ > Better than sec? Nothing is better than sec when it comes to > monitoring Big Data applications. Try Boundary one-second > resolution app monitoring today. Free. > http://p.sf.net/sfu/Boundary-dev2dev > _______________________________________________ > sqlobject-discuss mailing list > sql...@li... > https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss > > |