Deleting a record from database using Python

36,385

QuerySet.delete()

EmployeeDetails.objects.filter(...).delete()
Share:
36,385
rv_k
Author by

rv_k

Software Developer

Updated on May 11, 2020

Comments

  • rv_k
    rv_k about 4 years

    I have created a Django app and tested the application's performance by populating some 10,0000 records. Now i want to delete it using a python script. Can somebody help me in doing this. This is the script i created to populate data into sql db.

    def dumpdata():
        for i in range(2,10):
            userName = "Bryan"    
            designation = 'Technician '
            employeeID = 2312         
            dateOfJoin = '2009-10-10'    
            EmployeeDetails(userName= "Bryan",designation= 'Technician',employeeID= 2312,dateOfJoin= '2009-10-10').save()
    
    dumpdata()