Пример #1
0
 def prune_orphans():
     '''Prune oprhaned rows... no good way to use the ORM'''
     cursor = connection.cursor()
     cursor.execute(
         'delete from reports_performance where not exists (select ri.id from reports_performance_interaction ri where ri.performance_id = reports_performance.id)'
     )
     transaction.set_dirty()
Пример #2
0
 def prune_orphans():
     '''Prune oprhaned rows... no good way to use the ORM'''
     cursor = connection.cursor()
     cursor.execute(
         'delete from reports_entries where not exists (select rei.id from reports_entries_interactions rei where rei.entry_id = reports_entries.id)'
     )
     transaction.set_dirty()
Пример #3
0
 def prune_orphans():
     '''Prune oprhaned rows... no good way to use the ORM'''
     cursor = connection.cursor()
     cursor.execute('delete from reports_performance where not exists (select ri.id from reports_performance_interaction ri where ri.performance_id = reports_performance.id)')
     transaction.set_dirty()
Пример #4
0
 def prune_orphans():
     '''Prune oprhaned rows... no good way to use the ORM'''
     cursor = connection.cursor()
     cursor.execute('delete from reports_entries where not exists (select rei.id from reports_entries_interactions rei where rei.entry_id = reports_entries.id)')
     transaction.set_dirty()