The "code" in the macro is not pretty to look at. I don't do pretty code until I've got proof of concept working.
Proof of concept works (I think, proof in the pudding), so now I can consider making pretty code. If you want to play with the working "select * from *tag*" (a *tag* is a virtual, distributed, and dynamic *table*), download the attached and drag into whatever TiddlyWiki instance (TiddlyWiki.com !) Two tiddlers: - *SQL Macros* - *select * from Examples* On Friday, November 25, 2022 at 11:09:55 AM UTC-4 Charlie Veniot wrote: > It would be some nice if a search of "duplicates" in tiddlywiki.com's > documentation lead to the "de-duplication" line in the "Filter Expressions" > tiddler. > > Better if it lead to a tiddler that discussed the broader topic of > allowing/disallowing duplicates, with info about the de-duplication filter > run prefix and the unique operator. All very good and related stuff. > > Anyway, that last bug was related to uniqueness being automagically > applied, and having to add a "=" prefix to eliminate de-duplication. > > > > On Friday, November 25, 2022 at 10:49:48 AM UTC-4 Charlie Veniot wrote: > >> Oops, still have a bug in there. On it. >> >> On Friday, November 25, 2022 at 10:39:46 AM UTC-4 Charlie Veniot wrote: >> >>> Okay, "nulls" handled, for this sample query, anyhoo. >>> >>> Must test with different "tables" (in what I'm doing, I'm using tags as >>> the way to define virtual tables; a bit different, yet oh-so-cool, from >>> dbms': the tables are dynamic in regards to columns, as the columns are >>> whatever existing fields in tiddlers that have the tag.) >>> >>> New version of PDF attached. >>> >>> On Friday, November 25, 2022 at 12:44:42 AM UTC-4 Charlie Veniot wrote: >>> >>>> Arg! You are absolutely right. I skipped handling empty fields. >>>> >>>> I had imposed on myself a hard 10:30 PM cutoff time on that first >>>> crack at it, and had not gotten around to validating the result set. >>>> >>>> First thing to fix when I get back at it tomorrow. >>>> >>>> Thanks ! >>>> >>>> On Thu, Nov 24, 2022 at 11:39 PM Eric Shulman <[email protected]> >>>> wrote: >>>> >>>>> This is some interesting stuff! >>>>> >>>>> I notice that in the PDF output, if a tiddler listed in "The record >>>>> set" table doesn't have some fields (or the field value is blank, or two >>>>> fields have exactly the same value), that row of the table omits the >>>>> corresponding cell, rather than showing a blank placeholder cell (or a >>>>> repeated value if two fields have matching values). The result is that >>>>> the >>>>> cells for that tiddler don't align with the corresponding field name >>>>> headings. >>>>> >>>>> Example 1: >>>>> "Interactive Git Documentation by Devin Weaver" has a blank "type" >>>>> field. >>>>> The result is that the "url" field value is displayed under the "type" >>>>> column heading >>>>> >>>>> Example 2: >>>>> "Simple Zork-like Game by Jed Carty" has the same timestamp for >>>>> "created" and "modified" (20141118143636664). >>>>> The result is that the "modified" field value is omitted from the >>>>> table, and the "text" field value is displayed under the "tags" column >>>>> heading. >>>>> >>>>> Since I can't look at your code to see what you are doing, I can only >>>>> guess at some possible workarounds for these issues. >>>>> >>>>> I assume you are using some filter syntax to iterate over the fields >>>>> of a tiddler and using something like "get<fieldname>" to retrieve the >>>>> values that are shown in the table cells. If this is the case, you might >>>>> try using something like "get<fieldname>else[]", which would ensure that >>>>> empty/missing fields are converted to blank text rather than being >>>>> omitted. For the duplicate value problem, you might try preceding the >>>>> relevant filter run syntax with "=" to preserve duplicate values in the >>>>> results. >>>>> >>>>> Hope this helps, >>>>> -e >>>>> On Thursday, November 24, 2022 at 6:29:38 PM UTC-8 [email protected] >>>>> wrote: >>>>> >>>>>> select * from Examples >>>>>> >>>>>> Results (preceded by sanity-checks of steps towards result set) in >>>>>> attached PDF. >>>>>> >>>>>> On Thursday, November 24, 2022 at 8:39:39 PM UTC-4 Charlie Veniot >>>>>> wrote: >>>>>> >>>>>>> Working on: select * from Examples >>>>>>> >>>>>>> Using TiddlyWiki.com >>>>>>> >>>>>>> The tag "Examples" being the table. >>>>>>> >>>>>>> On Thursday, November 24, 2022 at 4:46:34 PM UTC-4 Charlie Veniot >>>>>>> wrote: >>>>>>> >>>>>>>> As always, the question of "how would I do that/this in TiddlyWiki" >>>>>>>> just grabs me by the jugular (i.e. it gets all of my attention.) >>>>>>>> >>>>>>>> Proof of concept prototype pending ... >>>>>>>> >>>>>>> -- >>>>> You received this message because you are subscribed to a topic in the >>>>> Google Groups "TiddlyWiki" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/tiddlywiki/GWxH8tPzDn4/unsubscribe. >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> [email protected]. >>>>> To view this discussion on the web visit >>>>> https://groups.google.com/d/msgid/tiddlywiki/0c91473e-d7eb-46a5-b888-91a0e34b7d24n%40googlegroups.com >>>>> >>>>> <https://groups.google.com/d/msgid/tiddlywiki/0c91473e-d7eb-46a5-b888-91a0e34b7d24n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/3517edca-937c-4fa7-a94c-44980ac3536bn%40googlegroups.com.
TW-SQL.json
Description: application/json
