2026/03/20
Jump to navigation
Jump to search
|
Friday, March 20, 2026 (#79)
|
|
References
|
- 09:27 Something I did yesterday apparently broke things down to the level where the schema-listing no longer works locally, but still works remotely. That's hopefully easier to fix (because it was working) than something relating to the import process, which has never (yet) worked.
- If I can't have step-through debugging, it would at least be nice to have step-through cross-document undo so I could spot the most likely culprits. There's probably a way to do this with git, but it would have to be integrated into the editor somehow (automatic microcommits, to start with, and automatic document-reloads when reverting to an earlier version).
- 10:58 Got it. The problem is that the schema-list-fetcher is set up to assume that DoCommand() won't return until data has been fetched -- i.e.
$oaPipes->Block(FALSE);. If I set it toTRUEinstead (which won't work for other things), it fetches the list.- Now I need to see if running the InOutLoop afterwards will also fix it.
- 10:30 Well, it's already doing that, and obviously not working. I'm thinking the problem must be somewhere within the
$oRun->DoInOutLoop()code. - 10:45 The command-line in question is "
echo 'SHOW SCHEMAS;' | mariadb -hlocalhost -uroot -p<password>". I wonder if theecho '<SQL>' |(etc.) scenario somehow doesn't play nicely with InOutLoop()... - 11:13 Apparently under this circumstance, we do need to wait for
feof()to returnTRUE. My memory is that under other circumstances, this causes the input process to get stuck; we'll have to see what's different about that circumstance, when/if that happens again. - 11:47 I'm experiencing a strong primal urge, no doubt inherited from my primitive coder-forbears at the dawn of time (1970/01/01), to revamp the debug-logging system. I need to be able to format things nicely to the screen and to a text-file that doesn't play nicely with escape-codes, and maybe to another file in HTML format; I need to be able to turn logging on and off at various points so I don't capture lots of stuff going on in the same routines that are working for some things and not for others.