Readme getting starting / usage section about trackmyairtag HOT 7 CLOSED

It might be as simple as docker compose up...

from trackmyairtag.

hey. thank you for your interest! I think it is. I used to run the docker stack on a remote server, and then ran locally on the macbook:

TMA_DATABASE_DSN=postgres://...:5432/trackmyairtag adev runserver app.py

from trackmyairtag.

Thanks @katlol. Nice design that you can easily run the docker stack on a server.

Am figuring things out locally now on a mac with FindMy running. After changing the user in:

https://github.com/katlol/trackmyairtag/blob/533d603eff3c46842c3ba12000a40ad46e0cfb09/docker-compose.yaml#L8

docker compose up launches properly.

However, I'm hitting:

web_1       |   File "asyncpg/protocol/protocol.pyx", line 168, in prepare
web_1       | asyncpg.exceptions.UndefinedTableError: relation "log" does not exist
postgres_1  | 2023-05-10 14:07:01.165 UTC [30] ERROR:  relation "log" does not exist at character 368
postgres_1  | 2023-05-10 14:07:01.165 UTC [30] STATEMENT:  
postgres_1  | 	                SELECT
postgres_1  | 	                    id,
postgres_1  | 	                    name,
postgres_1  | 	                    address,
postgres_1  | 	                    timestamp,
postgres_1  | 	                    latitude,
postgres_1  | 	                    longitude,
postgres_1  | 	                    altitude,
postgres_1  | 	                    raw->'location'->'horizontalAccuracy' as accuracy,
postgres_1  | 	                    raw->'role'->'emoji' as emoji
postgres_1  | 	                FROM log
postgres_1  | 	                WHERE
postgres_1  | 	                    log.timestamp IN (SELECT max(timestamp) FROM log AS b WHERE log.id = b.id)

Perhaps _initdb hasn't run yet. Should that happen automatically or does the user need to trigger it?

from trackmyairtag.

yeah, you are right. that does not seem to be called anywhere.

perhaps we want to wrap it in a try/except on connection (in case it runs for the second time?) or make it idempotent (it might already be?)

from trackmyairtag.

make it idempotent (it might already be?)

Okay included as part of #3. I believe _initdb works fine when called on an existing database due to CREATE TABLE IF NOT EXISTS.

from trackmyairtag.

@dhimmel see #4 maybe related?

from trackmyairtag.

@dhimmel please reopen if this is still an issue.

from trackmyairtag.