[peewee subquery in from clause]

subquery_in_from.py

#!/usr/bin/python
# coding:utf-8

from peewee import SQL
from peewee import QueryCompiler
from models import Blog


compiler = QueryCompiler('"', '?', {}, {})


def from_subquery():
  inner = (Blog
           .select(fn.COUNT(Blog.id).alias('blog_ct'))
           .group_by(Blog.user))
  blog_ct = SQL('blog_ct')
  outer = (Blog
           .select(blog_ct, fn.COUNT(blog_ct).alias('blog_ct_n'))
           .from_(inner)
           .group_by(blog_ct))
  sql, params = compiler.generate_select(outer)
  print sql
  for q in outer:
    print q.blog_ct, q.blog_ct_n