psycopg2 SyntaxError while running `./build-docker.sh --purgeall`

[thisistheplace]

Hi,

Received an error while attempting to purge existing data. Note that the previous attempt to run ./build-docker.sh had failed (see other Issues raised).

Command:
./build-docker.sh --purgeall

Console output:

2025-04-16 15:14:31 [INFO] Starting Open Wind Energy data pipeline...
2025-04-16 15:14:31 [INFO] Attempting connection to PostGIS...
2025-04-16 15:14:31 [INFO] Connection to PostGIS successful
2025-04-16 15:14:31 [INFO] --purgeall argument passed: Clearing database and all build files
Traceback (most recent call last):
  File "/usr/src/openwind/openwind.py", line 2998, in <module>
    purgeAll()
  File "/usr/src/openwind/openwind.py", line 1931, in purgeAll
    postgisDropAllTables()
  File "/usr/src/openwind/openwind.py", line 483, in postgisDropAllTables
    postgisDropTable(table_name)
  File "/usr/src/openwind/openwind.py", line 472, in postgisDropTable
    postgisExec("DROP TABLE IF EXISTS %s", (AsIs(table_name), ))
  File "/usr/src/openwind/openwind.py", line 349, in postgisExec
    cur.execute(sql_text, sql_parameters)
psycopg2.errors.SyntaxError: syntax error at or near "/"
LINE 1: DROP TABLE IF EXISTS build_docker/osm_boundaries

[open-wind]

This is related to a bug in the --custom option which utilises osm_boundaries table.

Apologies, the '--custom' option was released before we properly finished and tested it. Planning to finish this testing in the next two weeks.

[open-wind]

As a temporary workaround to 'hard reset' a Docker build, simply shutdown Docker, delete the 'build-docker' folder within openwindenergy and rerun; the 'build-docker' holds PostGIS data as well as all downloads.