Python distinct示例

示例#1

文件： tests.py 项目： bopo/skylark

    def test_distinct(self):
        assert User.create(name='jack', email='*****@*****.**')
        assert User.create(name='jack', email='*****@*****.**')
        assert User.create(name='wangchao', email='*****@*****.**')
        assert User.create(name='hit9', email='*****@*****.**')
        query = User.select(fn.count(distinct(User.name)))
        result = query.execute()
        count = result.tuples()[0][0]
        assert count == 3

        query = User.orderby(User.id).select(distinct(User.email))
        result = query.execute()
        assert result.tuples() == (
            ('*****@*****.**',), ('*****@*****.**',), ('*****@*****.**', )
        )

        emails = [user.email for user in result.all()]
        assert len(emails) == len(set(emails))

        query = User.orderby(User.id).select(distinct(User.name, User.email))
        try:
            result = query.execute()
        except Exception:  # should raise an error
            pass
        else:
            raise Exception

        query = User.orderby(User.id).select(distinct(User.name), User.email)
        result = query.execute()
        assert result.count == 4

示例#2

    def test_distinct(self):
        assert User.create(name='jack', email='*****@*****.**')
        assert User.create(name='jack', email='*****@*****.**')
        assert User.create(name='wangchao', email='*****@*****.**')
        assert User.create(name='hit9', email='*****@*****.**')
        query = User.select(fn.count(distinct(User.name)))
        result = query.execute()
        count = result.tuples()[0][0]
        assert count == 3

        query = User.orderby(User.id).select(distinct(User.email))
        result = query.execute()
        assert result.tuples() == (
            ('*****@*****.**',), ('*****@*****.**',), ('*****@*****.**', )
        )

        emails = [user.email for user in result.all()]
        assert len(emails) == len(set(emails))

        query = User.orderby(User.id).select(distinct(User.name, User.email))
        try:
            result = query.execute()
        except Exception:  # should raise an error
            pass
        else:
            raise Exception

        query = User.orderby(User.id).select(distinct(User.name), User.email)
        result = query.execute()
        assert result.count == 4

示例#3

文件： tests.py 项目： bopo/skylark

    def test_distinct_nodes(self):
        assert User.create(name='jack', email='*****@*****.**')
        assert User.create(name='amy', email='*****@*****.**')
        assert User.create(name='amy', email='*****@*****.**')
        assert User.create(name='tom', email='*****@*****.**')

        query = User.select(distinct(User.name))
        result = query.execute()
        users = result.all()
        assert [user.name for user in users] == ['jack', 'amy', 'tom']

示例#4

    def test_distinct_nodes(self):
        assert User.create(name='jack', email='*****@*****.**')
        assert User.create(name='amy', email='*****@*****.**')
        assert User.create(name='amy', email='*****@*****.**')
        assert User.create(name='tom', email='*****@*****.**')

        query = User.select(distinct(User.name))
        result = query.execute()
        users = result.all()
        assert [user.name for user in users] == ['jack', 'amy', 'tom']

示例#5

文件： tests.py 项目： zhangjinglei/skylark

    def test_distinct(self):
        assert User.create(name='jack', email='*****@*****.**')
        assert User.create(name='jack', email='*****@*****.**')
        assert User.create(name='wangchao', email='*****@*****.**')
        assert User.create(name='hit9', email='*****@*****.**')
        query = User.select(fn.count(distinct(User.name)))
        results = query.execute()
        func = results.one()
        assert func.count == 3

        query = User.orderby(User.id).select(distinct(User.email))
        results = query.execute()
        assert tuple(results.tuples()) == (
            ('*****@*****.**', ), ('*****@*****.**', ), ('*****@*****.**', )
        )

        query = User.orderby(User.id).select(distinct(User.name), User.id)
        results = query.execute()
        assert tuple(results.dicts()) == (
            {'name': 'jack', 'id': 1},
            {'name': 'jack', 'id': 2},
            {'name': 'wangchao', 'id': 3},
            {'name': 'hit9', 'id': 4},
        )

示例#6

文件： tests.py 项目： zhangjinglei/skylark

 def test_examples(self):
     User.create(name='jack', email='*****@*****.**')
     User.create(name='jack', email='*****@*****.**')
     User.create(name='amy', email='*****@*****.**')
     # distinct
     query = User.select(distinct(User.name))
     results = query.execute()
     assert results.one().name == 'jack'
     assert results.one().name == 'amy'
     # groupby & orderby
     query = User.groupby(User.name).orderby(sql('count')).select(
         User.name, fn.count(User.id).alias('count'))
     results = query.execute()
     user, func = results.one()
     assert user.name == 'amy' and func.count == 1
     user, func = results.one()
     assert user.name == 'jack' and func.count == 2

示例#7

文件： tests.py 项目： zhangjinglei/skylark

 def test_distinct(self):
     query = self.models.select(distinct(User.name))
     result = query.execute()
     assert result.count == 4

示例#8

文件： count_distinct_field.py 项目： YechengZhou/skylark

from skylark import fn, distinct
from models import User

# select count(distinct(user.name)) from user
query = User.select(fn.count(distinct(User.name)))
result = query.execute()
func = result.one()
return func.count

示例#9

 def test_distinct(self):
     query = self.models.select(distinct(User.name))
     result = query.execute()
     assert result.count == 4

示例#10

文件： count_distinct_field.py 项目： zhoutingji/skylark

from skylark import fn, distinct
from models import User

# select count(distinct(user.name)) from user
query = User.select(fn.count(distinct(User.name)))
result = query.execute()
return result.tuples()[0][0]