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 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 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 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 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 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 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()
def test_car_str(self):
manufacturer = Manufacturer(id=1, make="Ford")
car = Car(manufacturer=manufacturer, model="Mustang")
self.assertEqual(car.__str__(), "Ford Mustang")
def test_car_model_field(self):
car = Car(model="Mustang")
self.assertEqual(car.model, "Mustang")
def test_car_manufacturer_id_field(self):
car = Car(manufacturer_id=1)
self.assertEqual(car.manufacturer_id, 1)
def setUp(self):
self.car = Car(id=1, model="Mustang")
self.rate = Rate()
