By this way we get just 3 records at all. But I need to get ALL
sections, and by 3 thread per section.
So, I need a query to make this structure:
section1
thread1
thread4
section2
thread5
section3
thread7
thread8
thread9
It can be done by many queries like:
sections = db(db.sections.id>0).select()
for section in sections:
threads =
db(db.threads.section_id==section.id).select(orbderby='<random>',limitby=(0,3))
But there are too many queries. Is there a way to get it at one or two
queries?
On 16 ноя, 19:35, Massimo Di Pierro <[email protected]>
wrote:
> select(...,orbderby='<random>',limitby=(0,3))
>
> On Nov 16, 2:27 am, LightOfMooN <[email protected]> wrote:
>
>
>
>
>
>
>
> > For example, I have this database structure:
>
> > db.define_table('sections',
> > Field('title', 'string')
> > )
> > db.define_table('threads',
> > Field('title', 'string'),
> > Field('section_id', db.sections),
> > )
>
> > How can I get all sections and by 1 random thread per each section?
>
> > This works:
> > rows = db(db.sections.id>0).select(db.sections.id, db.threads.id,
> > left=db.threads.on(db.threads.section_id==db.sections.id),
> > distinct=db.sections.id)
> > but it gets not random threads.
>
> > How to get random?
> > And how to get 2 or 3 threads per each section?
