Python delete_rows Examples

Example #1

File: delete_historical_enrollment_data.py Project: mohit741/edx-platform

 def handle(self, *args, **options):
     """
     Deletes rows, chunking the deletes to avoid long table/row locks.
     """
     chunk_size, sleep_between = super(Command,
                                       self).handle(*args, **options)
     delete_rows(CourseEnrollment.objects,
                 'student_historicalcourseenrollment', 'history_id',
                 chunk_size, sleep_between)

Example #2

File: delete_historical_verify_student_data.py Project: InsightLab/edx-platform-insight

 def handle(self, *args, **options):
     """
     Deletes rows, chunking the deletes to avoid long table/row locks.
     """
     chunk_size, sleep_between = super(Command,
                                       self).handle(*args, **options)
     delete_rows(VerificationDeadline.objects,
                 'verify_student_historicalverificationdeadline',
                 'history_id', chunk_size, sleep_between)

Example #3

File: delete_historical_api_admin_data.py Project: DoTamKma/debug-edx-platform

 def handle(self, *args, **options):
     """
     Deletes rows, chunking the deletes to avoid long table/row locks.
     """
     chunk_size, sleep_between = super(Command,
                                       self).handle(*args, **options)
     delete_rows(ApiAccessRequest.objects,
                 'api_admin_historicalapiaccessrequest', 'history_id',
                 chunk_size, sleep_between)

Example #4

File: delete_historical_api_admin_data.py Project: digitalsatori/edx-platform

 def handle(self, *args, **options):
     """
     Deletes rows, chunking the deletes to avoid long table/row locks.
     """
     chunk_size, sleep_between = super(Command, self).handle(*args, **options)
     delete_rows(
         ApiAccessRequest.objects,
         'api_admin_historicalapiaccessrequest',
         'history_id',
         chunk_size, sleep_between
     )

Example #5

File: delete_historical_credit_data.py Project: tehreem-sadat/edx-platform

 def handle(self, *args, **options):
     """
     Deletes rows, chunking the deletes to avoid long table/row locks.
     """
     chunk_size, sleep_between = super(Command,
                                       self).handle(*args, **options)
     delete_rows(CreditRequest.objects, 'credit_historicalcreditrequest',
                 'history_id', chunk_size, sleep_between)
     delete_rows(CreditRequirementStatus.objects,
                 'credit_historicalcreditrequirementstatus', 'history_id',
                 chunk_size, sleep_between)

Example #6

File: delete_historical_verify_student_data.py Project: edx/edx-platform

 def handle(self, *args, **options):
     """
     Deletes rows, chunking the deletes to avoid long table/row locks.
     """
     chunk_size, sleep_between = super(Command, self).handle(*args, **options)
     delete_rows(
         VerificationDeadline.objects,
         'verify_student_historicalverificationdeadline',
         'history_id',
         chunk_size, sleep_between
     )

Example #7

File: delete_historical_enrollment_data.py Project: AlexxNica/edx-platform

 def handle(self, *args, **options):
     """
     Deletes rows, chunking the deletes to avoid long table/row locks.
     """
     chunk_size, sleep_between = super(Command, self).handle(*args, **options)
     delete_rows(
         CourseEnrollment.objects,
         'student_historicalcourseenrollment',
         'history_id',
         chunk_size, sleep_between
     )

Example #8

 def handle(self, *args, **options):
     """
     Deletes rows, chunking the deletes to avoid long table/row locks.
     """
     chunk_size, sleep_between = super(Command,
                                       self).handle(*args, **options)
     delete_rows(
         MicrositeOrganizationMapping.objects,
         'microsite_configuration_historicalmicrositeorganizationmapping',
         'history_id', chunk_size, sleep_between)
     delete_rows(MicrositeTemplate.objects,
                 'microsite_configuration_historicalmicrositetemplate',
                 'history_id', chunk_size, sleep_between)

Example #9

File: delete_historical_microsite_data.py Project: AlexxNica/edx-platform

 def handle(self, *args, **options):
     """
     Deletes rows, chunking the deletes to avoid long table/row locks.
     """
     chunk_size, sleep_between = super(Command, self).handle(*args, **options)
     delete_rows(
         MicrositeOrganizationMapping.objects,
         'microsite_configuration_historicalmicrositeorganizationmapping',
         'history_id',
         chunk_size, sleep_between
     )
     delete_rows(
         MicrositeTemplate.objects,
         'microsite_configuration_historicalmicrositetemplate',
         'history_id',
         chunk_size, sleep_between
     )

Example #10

File: delete_historical_credit_data.py Project: TeachAtTUM/edx-platform

 def handle(self, *args, **options):
     """
     Deletes rows, chunking the deletes to avoid long table/row locks.
     """
     chunk_size, sleep_between = super(Command, self).handle(*args, **options)
     delete_rows(
         CreditRequest.objects,
         'credit_historicalcreditrequest',
         'history_id',
         chunk_size, sleep_between
     )
     delete_rows(
         CreditRequirementStatus.objects,
         'credit_historicalcreditrequirementstatus',
         'history_id',
         chunk_size, sleep_between
     )