Skip to content

Macro description: filter database and dump gpx #809

Description

@aa1vs

Problem Statement

Currently my workflow maintains many (2500) zipped gpx files.

I loop over recent finds to different databases (based on their country||state). In each database i filter using a where statement. Often these are challenge specific so language like difficulty||terrain not in (select difficulty||terrain where found). The details of the where statement changes. Then i export a gpx file with a name based on the database name. I also rename the caches in that gpx based on whatever element is useful for that challenge. The custom variables and mtag functionality of gsak make this happen.

Proposed Solution

Needed for this
Filter based on sqlite where statement
Flow control
Loop
Access to current database name
Ability to switch databases

A language with functions instead of subroutines would really clean up this code.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions