def parseModelSql(): from django.db import connection, transaction cursor = connection.cursor() makes = list(Make.objects.all()) for make in makes: cursor.execute("SELECT DISTINCT model FROM web_carclassified WHERE make = '" + str(make.make) + "'") models = cursor.fetchall() for model in models: modelname = str(model[0]).replace("'", "''") #Escape apostrophe, Kia Cee'd :) _model = Model() _model.make = make _model.model = modelname cursor.execute("SELECT count(*) FROM web_carclassified WHERE model = '" + modelname + "' AND make = '" + make.make + "'") _model.count = int(cursor.fetchone()[0]) _model.save()
def parseMakeModel(): makes = CarClassified.objects.all() makes = uniquify(makes) for _make in makes: make = Make() make.make = _make.make make.count = len(CarClassified.objects.all().filter(make=_make.make)) make.save() models = CarClassified.objects.all().filter(make=_make.make) models = uniquify(models) for _model in models: model = Model() model.model = _model.model model.make = make model.count = len(CarClassified.objects.all().filter(model=model.model)) model.save()