Renaming a car?

[Kosta-Github]

Is there a way to easily rename a car? SQL statement would be fine, too; but I donˋt know the DB schema…

Background: I sold my old M3 and received my new MY and want to keep the history of the old one, but the new one should be the first one on all the dashboards now. Unfortunately the new one has a name alphabetically after the old one…

[DrMichael]

You might find #1224 helpful...

[leewillis77]

Also, please also vote on #1751 and/or if you're technical any comments on #1904 would be welcome.

[Kosta-Github]

Just for closing the loop here: the SQL commands for renaming a car would be:

1. list all cars in the DB:

   docker-compose exec -T database psql -U teslamate << .                            
       SELECT * FROM cars;
   .
   

2. renaming one car from old_car_name to new_car_name:

   docker-compose exec -T database psql -U teslamate << .                            
       UPDATE cars SET name='new_car_name' WHERE name='old_car_name';
   .
   

Note, that database refers to the name of the DB service in your docker-compose config file; if you renamed this service, e.g., to teslamate-db, you would also need to use the corresponding service name here: docker-compose exec -T teslamate-db ...

[horst789github]

dont work for me:

with root: service "teslamate-db" is not running container #1
with user: no configuration file provided: not found

[leewillis77]

I think you had old_car_name and new_car_name the wrong way around in your example, so should be...

docker-compose exec -T database psql -U teslamate << .                            
    UPDATE cars SET name='new_car_name' WHERE name='old_car_name';
.

[Kosta-Github]

Good catch, fixed it above as well…

[bbrendon]

I think car renaming is auto-magically handled now? My car was renamed any I don't see the old name in SELECT * FROM cars;