Пример #1
0
def parseMakeSql():
    from django.db import connection, transaction
    cursor = connection.cursor()
    cursor.execute("SELECT DISTINCT make FROM web_carclassified")
    makes = cursor.fetchall()
    
    for make in makes:
        _make = Make()
        _make.make = str(make[0])
        cursor.execute("SELECT count(*) FROM web_carclassified WHERE make = '" + str(make[0]) + "'")
        _make.count = int(cursor.fetchone()[0])
        _make.save()
Пример #2
0
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()