So, we have a glitch where only some users got a created time added to their database entries. However, that is fixed, and now we only want to give a reasonable estimate to the old user so we have accuracy about when they signed up.
See https://git.gnu.io/snowdrift/snowdrift/merge_requests/31#note_328 The first bit can just be done manually (removing erroneous timestamp from a handful of rows). Note that the missing timestamps are inconsistent (like ids 45-48 might be missing but ones before and after are there etc, in a few different blocks of missing section), we don't want to fill them all in with a single time. The action we need to figure out how to code is: *** Go in order by id, starting with id=1 (which has a created_ts already), and check if a row has a created_ts; if null, enter something just a bit later (I say 2 minutes) than the *previous* id. *** Incidentally, we know that all rows with id > 230 have created_ts already, but it wouldn't hurt if the program went through those anyway. So, can anyone help us formulate this action so we can update the DB? If you aren't sure, volunteering to just figure this out with outside help is obviously fine… Thanks, Aaron -- Aaron Wolf Snowdrift.coop <https://snowdrift.coop> _______________________________________________ Dev mailing list [email protected] https://lists.snowdrift.coop/mailman/listinfo/dev
