Build Wanderlog Pro

KINDAreplaces $5.99/mosaves $71.88/yrback to the verdict

0%0 of 19 items done

Saved on this device only. Tick prerequisites first, then work the phases in order · do not start one until the checks above it pass.

Build a local trip itinerary with timezone-aware scheduling and an offline bundle.

estimated effort multi-daythe files for this build are in the project pack

RuntimePython 3.12+ and FlaskStorageSQLite through Python sqlite3InterfaceJinja HTML templates, CSS and vanilla JavaScriptVerificationPython unittest and browser acceptance fixtures

Before step 1

Everything below is assumed from the first step. Tick each one when you actually have it, not when you plan to.

  1. installPython is free; this local prototype requires no hosting subscription.

    Why The local backend, tests and storage use Python.

    Get it Install Python from python.org. Open a terminal in a new empty project folder. On Windows, use py -3 where this guide says python if python is not on PATH; on macOS/Linux use python3 if needed. Create .venv and activate it before installing packages. open ↗

    Verify python --version reports 3.12+ and python -c "import sqlite3" succeeds.

  2. installNo paid service required for this local step.

    Why You need to view the local interface and edit generated project files.

    Get it Use an installed Chrome, Firefox or Edge browser. Open the empty project folder in your editor; open the terminal there, not in this catalog repository.

    Verify You can create a text file in the project folder and open browser developer tools.

  3. have readyNo paid service required for this local step.

    Why This fixture makes the first end-to-end check reproducible.

    Get it Create synthetic sample data before implementation: A two-day trip with stops in London and Paris, manually entered coordinates and an overlapping reservation. Save it under fixtures/ with the expected results in fixtures/README.md; use no real credentials or customer records.

    Verify The fixture files and expected outcomes exist and can be inspected without a vendor account.

  4. decideNo paid service required for this local step.

    Why The full commercial product is larger than this guide.

    Get it The deliverable is a local trip itinerary with timezone-aware scheduling and an offline bundle. Read every exclusion below. Indie mode runs locally; any public or shared use requires the product access and deployment gates first.

    Verify You can name the primary workflow and the vendor features this version deliberately leaves out.

Data model

Create these before the first phase that stores anything. Changing a table later is the expensive kind of change.

- trips(id,title,start_date,end_date)
- stops(id,trip_id,day,position,name,lat,lon,timezone,start_local,duration_minutes)
- reservations(id,trip_id,reference,notes)
- packing(id,trip_id,text,checked)
- attachments(id,trip_id,path)
- Use stable ids and explicit relationships; add auxiliary tables named by the phases before those phases use them.
- Acceptance fixture: A two-day trip with stops in London and Paris, manually entered coordinates and an overlapping reservation.

Environment variables

These go in a .env file the app reads at startup. The pack's .env.example is this table as a file · copy it, never commit the filled-in version.

VariableNeededExampleWhere the value comes from
DATA_DIRrequired./data/wanderlog-proA new private folder this application creates on first run; never serve it as static files.
SECRET_KEYsecretrequiredreplace-with-a-random-secretGenerate with python -c "import secrets; print(secrets.token_hex(32))" and save only in .env.
APP_MODErequiredindieUse indie for loopback-only personal work. Product mode must refuse to start until owner login and the deployment gates are configured.
SITE_URLrequiredhttp://127.0.0.1:5000The origin used for local forms and links; replace with the chosen HTTPS origin in product mode.

The build, in order

  1. Local foundation and data contract

    Create the runnable local foundation for a local trip itinerary with timezone-aware scheduling and an offline bundle, including the real schema and acceptance fixture.

    1. Run the venv command first, then stop and activate it before running the remaining commands. Use your OS instructions: Windows .venv\Scripts\activate.bat in cmd, or .venv\Scripts\Activate.ps1 in PowerShell; macOS/Linux source .venv/bin/activate. Then install the listed packages. Create app.py exposing app, load .env with python-dotenv, and add a /healthz route. Freeze tested dependency versions to requirements.txt. Create .env manually from .env.example; replace SECRET_KEY before launch.

      Files app.pyrequirements.txt.env.example.gitignore

      terminal
      python -m venv .venv
      python -m pip install Flask Flask-WTF python-dotenv waitress tzdata
      python -m pip freeze > requirements.txt
      python -m flask --app app run --host 127.0.0.1
    2. For database-backed state create schema.sql and db.py using this model: trips(id,title,start_date,end_date); stops(id,trip_id,day,position,name,lat,lon,timezone,start_local,duration_minutes); reservations(id,trip_id,reference,notes); packing(id,trip_id,text,checked); attachments(id,trip_id,path). Add the auxiliary relationships explicitly used in later phases; use stable ids, foreign keys, parameterized values and transactions. For canonical files use atomic replacement and hashes instead. Implement python manage.py init and python manage.py seed to create only synthetic data: A two-day trip with stops in London and Paris, manually entered coordinates and an overlapping reservation. Re-running init must not erase data.

      Files schema.sqldb.pymanage.pyfixtures/README.md

      terminal
      python manage.py init
      python manage.py seed
    3. Install Flask-WTF CSRF protection for forms and same-origin fetches, validate Host and Origin against SITE_URL, bound inputs and escape output. Deliberately public intake endpoints get bounded validation and rate limits; signed provider webhooks use signature checks instead of browser CSRF tokens. All other admin routes stay local until product authentication exists. When a later phase tests viewer/member permissions, implement the users, hashed passwords, expiring server sessions and role checks in this foundation first; product mode must never use a fabricated identity from request input. Add error, empty, keyboard-focus and retry states now.

      Files app.pytemplates/base.htmltest/test_foundation.py

    done when · tick each as it passes
    watch out
    • The Flask development server is for local development only. Loopback binding alone does not replace CSRF and origin validation.
  2. Trip facts

    Trip facts for Wanderlog Pro: Create trips and ordered stops with user-entered addresses, optional coordinates and IANA timezones.

    1. Create trips and ordered stops with user-entered addresses, optional coordinates and IANA timezones.

      Files features/trip_facts.pytemplates/trip_facts.html

    2. Add reservations and attachments through a review form; keep confirmations private and avoid logging their contents.

      Files features/trip_facts.py

    3. Use A two-day trip with stops in London and Paris, manually entered coordinates and an overlapping reservation. Check: An invalid latitude is rejected and missing coordinates remain visibly unknown. Then check: The same local time in London and Paris displays distinct corresponding UTC instants. Add a focused regression for the failure case under test/ using a temporary database or folder and fake external services; also perform the visible workflow in a browser.

      Files test/test_trip_facts.py

      terminal
      python -m unittest discover -s test
    done when · tick each as it passes
    watch out
    • Manual itinerary data is not a live flight, hotel or ticket availability feed.
  3. Schedule and route sketch

    Schedule and route sketch for Wanderlog Pro: Compute overlap warnings from time-aware instants and show each stop local timezone next to its time.

    1. Compute overlap warnings from time-aware instants and show each stop local timezone next to its time.

      Files features/schedule_and_route_sketch.pytemplates/schedule_and_route_sketch.html

    2. Draw a simple SVG coordinate route overview with numbered stops and no downloaded basemap; label it a schematic.

      Files features/schedule_and_route_sketch.py

    3. Use A two-day trip with stops in London and Paris, manually entered coordinates and an overlapping reservation. Check: The fixture overlap is flagged with both reservation names. Then check: Reordering stops changes route numbering without changing reservation times. Add a focused regression for the failure case under test/ using a temporary database or folder and fake external services; also perform the visible workflow in a browser.

      Files test/test_schedule_and_route_sketch.py

      terminal
      python -m unittest discover -s test
    done when · tick each as it passes
    watch out
    • Straight lines between coordinates are not driving directions or travel-time estimates.
  4. Offline travel pack

    Offline travel pack for Wanderlog Pro: Generate a printable HTML itinerary with contacts, reservation notes and packing list plus a complete JSON/assets archive.

    1. Generate a printable HTML itinerary with contacts, reservation notes and packing list plus a complete JSON/assets archive.

      Files features/offline_travel_pack.pytemplates/offline_travel_pack.html

    2. Include a redacted share export that omits references and private attachments by default; require explicit inclusion.

      Files features/offline_travel_pack.py

    3. Use A two-day trip with stops in London and Paris, manually entered coordinates and an overlapping reservation. Check: The full pack opens offline with its attached documents. Then check: The share pack contains no reservation reference unless explicitly included. Add a focused regression for the failure case under test/ using a temporary database or folder and fake external services; also perform the visible workflow in a browser.

      Files test/test_offline_travel_pack.py

      terminal
      python -m unittest discover -s test
    done when · tick each as it passes
    watch out
    • A local browser app requires its local server; the exported pack is the offline travel copy.
  5. Portable delivery and clean-start proof

    Finish the Wanderlog Pro replacement with a documented first-run path and a recoverable export.

    1. Document prerequisites, every configuration variable, data locations and the three domain workflows: Trip facts; Schedule and route sketch; Offline travel pack. Include the exclusions, actual costs and source check date 2026-09-05. Commands shown earlier that reference project files are files the builder must implement before running them.

      Files README.md.env.example

    2. Use sqlite3.Connection.backup for the database in DATA_DIR and pause writers while taking the matching attachment snapshot. Keep schema version, hashes and a manifest for wanderlog-pro. Restore into a separate empty directory or isolated deployment, with all outbound actions and schedules disabled. Recreate this proof: A two-day trip with stops in London and Paris, manually entered coordinates and an overlapping reservation. Compare ids/counts and open the result before recording the restore date. Never test a restore over the only live copy.

      Files OPERATIONS.mdscripts/backup.py

    3. Use a new folder and only README instructions to reach the fixture outcome. Install from requirements.txt, initialize storage, run the tests and exercise the UI at 375px and 1280px; use keyboard-only controls and inspect browser errors. Record exactly what passed; do not mark unrun checks complete.

      Files README.mdverification.md

      terminal
      python -m pip install -r requirements.txt
      python -m unittest discover -s test
    done when · tick each as it passes
    watch out
    • Export without an import or restore rehearsal is not verified portability.
what this build does not replace
after v1, if you want it

Need the files? The project pack on the verdict page hands your agent the whole brief · more travel.