Deleting a record from database using Python


Question

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() 
1
24
3/10/2011 10:25:54 AM

Accepted Answer

QuerySet.delete()

EmployeeDetails.objects.filter(...).delete()
56
3/10/2011 10:27:15 AM

Licensed under: CC-BY-SA with attribution
Not affiliated with: Stack Overflow
Icon