def guardar(request):
#Coloca los datos en la base de datos
us = request.POST.get("user_id")
ciudad = request.POST.get("ciudad")
locacion = request.POST.get("locacion")
km = request.POST.get("km")
color = request.POST.get("color")
precio = request.POST.get("precio")
car_infid = request.POST.get("car_infid")
marca = request.POST.get("marca")
modelo = request.POST.get("modelo")
anio = request.POST.get("anio")
print( request )
sys.stdout.flush()
try:
ci = carinf_type = Car_info.objects.get( model = modelo )
ui = User.objects.get( id = us )
except Exception as e:
return HttpResponse("Indice incorrecto")
if request.method == "POST":
BDG = Car(user_id = ui ,status = "Disponible",city = ciudad ,location = locacion ,km = km , color = color , price = precio, carinfo_id = ci, year_purch = anio)
BDG.save()
return HttpResponse("guardado en BD")
def import_process(file_name):
cars = {}
departments = {}
department_names = []
registration_numbers = []
errors = []
file = default_storage.open(file_name)
decoded_file = file.read().decode("utf-8").splitlines()
reader = csv.DictReader(decoded_file)
for row in reader:
car = Car(
registration_no=row["registration_no"],
brand=row["brand"],
model=row["model"],
weight=row["weight"],
production_date=row["production_date"],
passengers_no=row["passengers_no"],
)
car.department_name = row["department"]
department_names.append(row["department"])
registration_numbers.append(row["registration_no"])
cars[row["registration_no"]] = car
departments[row["registration_no"]] = row["department"]
if departments_errors := check_departments(department_names):
errors.append(departments_errors)
def handle(self, dataset, **options):
"""Command handler."""
print(dataset)
with open(dataset, newline='\n') as csvfile:
car_reader = csv.reader(csvfile, delimiter=',')
for year, make, model in car_reader:
manufacturer = _get_or_create_manufacturer(make)
car = Car(name=model, year=year, manufacturer=manufacturer)
car.save()
print('Created {0} {1} {2}'.format(year, model, make))
def add_new_car(cls, brand=None, model=None, year=None, vin=None):
"""Add new car to database\n
return car id
"""
logger.info("add_new_car / {}".format(locals()))
car = Car(brand=brand, model=model, year=year, vin=vin)
car.save()
return car.id
def add_car(request):
car = Car()
if request.method == 'POST':
form = NewCarForm(request.POST, instance=car)
if form.is_valid():
car.save()
request.user.get_profile().cars.add(car)
return HttpResponseRedirect('/users/edit_cars/')
else:
form = NewCarForm(instance=car)
return render_to_response('users/add_car.html', {'form': form},
context_instance=RequestContext(request))
def guardar(request):
#Coloca los datos en la base de datos
us = request.POST.get("user_id")
ciudad = request.POST.get("ciudad")
locacion = request.POST.get("locacion")
km = request.POST.get("km")
color = request.POST.get("color")
precio = request.POST.get("precio")
car_infid = request.POST.get("car_infid")
marca = request.POST.get("marca")
modelo = request.POST.get("modelo")
anio = request.POST.get("anio")
trans = request.POST.get("trans")
tipo = request.POST.get("type")
traccion = request.POST.get("traccion")
hpower = request.POST.get("hpower")
Motor = request.POST.get("Motor")
fuel = request.POST.get("fuel")
print( "request" )
sys.stdout.flush()
carros = Car_info.objects.all()
try:
ci = 0
ui = 0
ui = User.objects.get( id = us )
for x in carros:
if x.brand == marca and x.model == modelo:
if x.transmission == trans:
ci = carinf_type = x
if ci == 0:
BDCI = Car_info(transmission = str(trans), type = str(tipo), traction = str(traccion), hpower = str(hpower), motor = str(Motor) ,model = str(modelo),brand = str(marca), fuel = str(fuel), year = anio)
BDCI.save()
for x in carros:
if x.brand == marca and x.model == modelo:
if x.transmission == trans:
ci = carinf_type = x
except Exception as e:
print(e)
return HttpResponse("Indice incorrecto")
if request.method == "POST":
BDG = Car(user_id = ui ,status = "Disponible",city = ciudad ,location = locacion ,km = km , color = color , price = precio, carinfo_id = ci, year_purch = anio)
BDG.save()
return HttpResponse("guardado en BD")
def get_query_params(
self, need_to_get
): #словарь параметров для запроса или словарь примененных фильтров при выводе результата
names, have_choices = Car.get_fields_names(
) #тут баловство с choices integer. можно было его сделать строковым.
query_dict = {}
if need_to_get == 'name':
query_dict = {
name: self.request.GET.get(name)
for name in names.keys() if self.request.GET.get(name)
}
elif need_to_get == 'verbose_name':
for name, verbose_name in names.items():
value = self.request.GET.get(name)
if value:
if name in have_choices:
query_dict[verbose_name] = [
y for x, y in have_choices[name] if str(x) == value
][0]
else:
query_dict[verbose_name] = value
else:
raise Exception('Непредусмотренное значение параметра')
logger.debug('query_dict ({}): {}'.format(need_to_get, query_dict))
return query_dict
def get_queryset(self):
queryset = super().get_queryset()
self.form = CarForm(self.request.GET)
if self.form.is_valid():
filters = Car.get_filter(self.request.GET)
return queryset.filter(filters)
else:
return queryset
def make(request):
colors = ["Red", "Blue", "Pink", "Magenta"]
descriptions = ["Great car", "Awful car", "Ran over a hobo with it"]
owner_names = ["Ali", "Tommy", "Dan", "Catherine", "Alex"]
car_type = [1,2,4][randint(a=0, b=2)]
car_color = colors[randint(a=0, b=len(colors)-1)]
car_desc = descriptions[randint(a=0, b=len(descriptions)-1)]
owner_name = owner_names[randint(a=0, b = len(owner_names)-1)]
car = Car(
owner_name= owner_name,
color=car_color,
type=car_type,
description=car_desc,
created = timezone.now()
)
car.save()
return redirect(to='index')
def signup_user(request):
if request.method == 'GET':
context = {
'form': UserRegisterForm(),
}
return render(request, 'accounts/signup.html', context)
else:
form = UserRegisterForm(request.POST)
if form.is_valid():
car = Car()
user = form.save()
user_model = User.objects.get(id=user.id)
car.fk_user_id = user_model
car.car = ''
car.save()
login(request, user)
return redirect('user profile')
context = {
'form': form,
}
return render(request, 'accounts/signup.html', context)
def test_car(self):
"""Test the Car model."""
car = Car()
car.make = 'Make'
car.model = 'Model'
car.year = 1999
car.save()
def create_cars(self):
"""
Create all for cars.
"""
# Car brands
car_brands = []
car_models = []
for car_brand_slug, car_brand_name in CAR_BRANDS:
try:
car_brand = CarBrand.objects.get(
slug=car_brand_slug)
except CarBrand.DoesNotExist:
car_brand = CarBrand.objects.create(
slug=car_brand_slug,
name=car_brand_name)
car_brands.append(car_brand)
for affix in ('I', 'II', 'III', 'IV', 'V'):
car_model_name = ' ' . join(
map(lambda x: x.strip(), (car_brand.name, affix)))
try:
car_model = CarModel.objects.get(name=car_model_name)
except CarModel.DoesNotExist:
car_model = CarModel.objects.create(
mark=car_brand,
name=car_model_name)
car_models.append(car_model)
for i in xrange(0, DEFAULT_TOTAL_CARS):
new_car = Car()
new_car.driver = random.choice(self._drivers)
new_car.model = random.choice(car_models)
new_car.car_no = u'%s-RT-%s' % (
RandomItemSupplier.get_random_chars(string.digits, 2),
RandomItemSupplier.get_random_chars(string.digits, 3))
new_car.release_year = random.choice(range(1999, 2015))
new_car.color = random.choice(
('red', 'green', 'yellow', 'brown', 'black'))
new_car.vin = u'VIN-%s' % \
RandomItemSupplier.get_random_chars(string.digits, 7)
new_car.save()
self._cars.append(new_car)
def create_car(name, colour, price):
car = Car()
car.name = name
car.price = price
car.colour = colour
return car
def test_car_manufacturer_id_field(self):
car = Car(manufacturer_id=1)
self.assertEqual(car.manufacturer_id, 1)
def test_car_model_field(self):
car = Car(model="Mustang")
self.assertEqual(car.model, "Mustang")
def test_car_str(self):
manufacturer = Manufacturer(id=1, make="Ford")
car = Car(manufacturer=manufacturer, model="Mustang")
self.assertEqual(car.__str__(), "Ford Mustang")
def setUp(self):
self.car = Car()
def create_car(request):
car = Car()
return persist_car(request, car, 'add')
def process_item(self, item, spider):
from cars.models import Car, Price
# Creating model instances and saving them to DB
print(
"Entering process_item method, and attempting to create a car object"
)
if item['Finn_kode'] in spider.codes:
print('This is a crappy car.')
car = Car.objects.filter(Finn_kode=item['Finn_kode']).get()
temp_age = timezone.now() - car.created_at
print('Age: {}'.format(temp_age))
car.last_updated = timezone.now()
if car.age < temp_age.days:
print('New age {}'.format(temp_age))
car.age = temp_age.days
if car.solgt != item['solgt']:
print("Marking car as sold")
car.solgt = item['solgt']
if car.removed != item['removed']:
print('Marking car as removed')
car.removed = item['removed']
car.save()
else:
print("{} is not in the DB".format(item['Finn_kode']))
# Consider: https://stackoverflow.com/questions/8372703/how-can-i-use-different-pipelines-for-different-spiders-in-a-single-scrapy-proje
car = Car()
# Finn
car.Finn_kode = item['Finn_kode']
# General info
car.Antalldører = item['Antalldører']
car.Antalleiere = item['Antalleiere']
car.Antallseter = item['Antallseter']
car.Årsavgift = item['Årsavgift']
car.Årsmodell = item['Årsmodell']
car.Avgiftsklasse = item['Avgiftsklasse']
car.Bilenståri = item['Bilenståri']
car.ChassisnrVIN = item['ChassisnrVIN']
car.CO2utslipp = item['CO2utslipp']
car.Drivstoff = item['Drivstoff']
car.Effekt = item['Effekt']
car.Farge = item['Farge']
car.Fargebeskrivelse = item['Fargebeskrivelse']
car.foorstegangregistrert = item['foorstegangregistrert']
car.Girkasse = item['Girkasse']
car.header = item['header']
car.Hjuldrift = item['Hjuldrift']
car.Karosseri = item['Karosseri']
car.Kmstand = item['Kmstand']
car.last_updated = timezone.now()
car.name = item['name']
car.Omregistrering = item['Omregistrering']
car.Priseksomreg = item['Priseksomreg']
car.Regnr = item['Regnr']
car.Salgsform = item['Salgsform']
car.Sylindervolum = item['Sylindervolum']
car.totalpris = item['totalpris']
car.Vekt = item['Vekt']
car.solgt = item['solgt']
car.RekkeviddeWLTP = item['RekkeviddeWLTP']
car.Batterikapasitet = item['Batterikapasitet']
# Farger
car.Interiørfarge = item['Interiørfarge']
print(car)
car.save()
price = Price()
price.date = date.today()
price.price = item['totalpris']
price.car = car
price.save()
return item
'stock': 50
},
]
},
{
'domain': 'bmw',
'cars': [
{
'model': 'BMW Serie 1',
'year': '2019',
'color': 'Blue',
'stock': 5
},
{
'model': 'BMW X6',
'year': '2019',
'color': 'Green',
'stock': 2
},
]
}
]
for company_cars_info in cars_by_company_info:
with schema_context(company_cars_info['domain']):
for car_info in company_cars_info['cars']:
car = Car(model=car_info['model'], year=car_info['year'], color=car_info['color'], stock=car_info['stock'])
car.save()
def test_str(self):
test_car_description = Car(year=2020, brand='Ferrari', model='Spider')
self.assertEqual(str(test_car_description), '2020 Ferrari Spider')
def setUp(self):
self.car = Car(id=1, model="Mustang")
self.rate = Rate()
