GeezerVison is showing github.com — sqlobject/sqlobject/tests/test_NoneValuedResultItem.py at master · sqlobject/sqlobject

Expand file tree

test_NoneValuedResultItem.py

Copy path

More file actions

33 lines (23 loc) · 930 Bytes

Copy path

33 lines (23 loc) · 930 Bytes

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

# Test that selectResults handle NULL values from, for example, outer joins.

from sqlobject import ForeignKey, SQLObject, StringCol, sqlbuilder

from sqlobject.tests.dbtest import setupClass

class SOTestComposer(SQLObject):

name = StringCol()

class SOTestWork(SQLObject):

class sqlmeta:

idName = "work_id"

composer = ForeignKey('SOTestComposer')

title = StringCol()

def test1():

setupClass([SOTestComposer,

SOTestWork])

c = SOTestComposer(name='Mahler, Gustav')

w = SOTestWork(composer=c, title='Symphony No. 9')

SOTestComposer(name='Bruckner, Anton')

# but don't add any works for Bruckner

# do a left join, a common use case that often involves NULL results

s = SOTestWork.select(

join=sqlbuilder.LEFTJOINOn(

SOTestComposer, SOTestWork,

SOTestComposer.q.id == SOTestWork.q.composerID))

assert tuple(s) == (w, None)