Logo Search packages:      
Sourcecode: zope-cmfpgforum version File versions

tuple CMFpgForum::sql::SQLMethods::posting_verify_deletion_eligibility [static, inherited]

Initial value:

RoutableSqlMethod(
        'posting_verify_deletion_eligibility',
        '',
        '''
POSTING_ID=""
''',
        '''
select
  P.POSTING_ID,
  P.POSTING_SUBJECT,
  coalesce(P.THREAD_ID, P.POSTING_ID) as THREAD_ID
from
  POSTING P
where
  P.POSTING_ID = <dtml-var "_.int(POSTING_ID)">
  and P.POSTING_ID not in (select P2.PARENT_ID from POSTING P2
                   where P2.PARENT_ID = <dtml-var "_.int(POSTING_ID)">)
  and P.POSTING_ID not in (select P3.THREAD_ID from POSTING P3
                   where P3.THREAD_ID = <dtml-var "_.int(POSTING_ID)">)

''')

Definition at line 417 of file sql.py.


Generated by  Doxygen 1.6.0   Back to index