08-11-2019, 12:35 PM
@Tim Curtis
Yeah, I sussed out the schema sometime ago (for a while there was a comment in my code which said "I suppose 's' must stand for system). As it stands now, the script exports all entries tagged 'u'. I don't check the ID on export since that seemed redundant knowing your "add station" functionality. On import, your ID=499 divider as well as existing user-defines are observed en passant since my script lets sqlite3 autoincrement the ID just as yours does. I detest CSV so my script exports and imports the database entries as a JSON file. It's a verbose format but did I mention I detest CSV?
My script doesn't clear out the existing user-defined stations because in my imagined scenarios the user may have already added some stations by hand. Seemed rude to squash them
Regards,
Kent
Yeah, I sussed out the schema sometime ago (for a while there was a comment in my code which said "I suppose 's' must stand for system). As it stands now, the script exports all entries tagged 'u'. I don't check the ID on export since that seemed redundant knowing your "add station" functionality. On import, your ID=499 divider as well as existing user-defines are observed en passant since my script lets sqlite3 autoincrement the ID just as yours does. I detest CSV so my script exports and imports the database entries as a JSON file. It's a verbose format but did I mention I detest CSV?
My script doesn't clear out the existing user-defined stations because in my imagined scenarios the user may have already added some stations by hand. Seemed rude to squash them
Regards,
Kent
