Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>So... I got bored and needed something to do:</p> <pre><code>topics = { "Project", "Mary", "Mr. Moore", "Project Omega"} pcall ( require , 'luarocks.require' ) require 'lpeg' local locale = lpeg.locale ( ) local endofstring = -lpeg.P(1) local endoftoken = (locale.space+locale.punct)^1 table.sort ( topics , function ( a , b ) return #a &gt; #b end ) -- Sort by word length (longest first) local topicpattern = lpeg.P ( false ) for i = 1, #topics do topicpattern = topicpattern + topics [ i ] end function wikify ( input ) local topicsleft = { } for i = 1 , #topics do topicsleft [ topics [ i ] ] = true end local makelink = function ( topic ) if topicsleft [ topic ] then topicsleft [ topic ] = nil return "[[" .. topic .. "]]" else return topic end end local patt = lpeg.Ct ( ( lpeg.Cs ( ( topicpattern / makelink ) )* #(-locale.alnum+endofstring) -- Match topics followed by something thats not alphanumeric + lpeg.C ( ( lpeg.P ( 1 ) - endoftoken )^0 * endoftoken ) -- Skip tokens that aren't topics )^0 * endofstring -- Match adfinum until end of string ) return table.concat ( patt:match ( input ) ) end print(wikify("Mary and Mr. Moore work together on Project Omega. Mr. Moore hates both Mary and Project Omega, but Mary simply loves the Project.")..'"') print(wikify("Mary and Mr. Moore work on Project Omegality. Mr. Moore hates Mary and Project Omega, but Mary loves the Projectaaa.")..'"') </code></pre> <p>I start off my making a pattern which matches all the different topics; we want to match the longest topics first, so sort the table by word length from longest to shortest. Now we need to make a list of the topics we haven't seen in the current input. makelink quotes/links the topic if we haven't seen it already, otherwise leaves it be.</p> <p>Now for the actual lpeg stuff:</p> <ul> <li><code>lpeg.Ct</code> packs all our captures into a table (to be concated together for output)</li> <li><code>topicpattern / makelink</code> captures a topic, and passes in through our makelink function.</li> <li><code>lpeg.Cs</code> substitutes the result of makelink back in where the match of the topic was.</li> <li><code>+ lpeg.C ( ( lpeg.P ( 1 ) - locale.space )^0 * locale.space^1 )</code> if we didn't match a topic, skip a word (that is, not spaces followed by a space)</li> <li><code>^0</code> repeat.</li> </ul> <p>Hope thats what you wanted :)</p> <p>Daurn</p> <p>Note: Edited code, description no longer correct</p>
    singulars
    1. This table or related slice is empty.
    1. POWiki-fying a text using LPeg
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USdaurnimator
    1. USdaurnimator
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POWiki-fying a text using LPeg
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COAwesome effort, I'm learning a lot. Also, it is case sensitive (which I admit I didn't specifically mention or test in the example), but I think that is fixed easily enough by tracking all topics in their lowercased form, although I think lpeg.P() might disagree with me. Bigger issues: it likes to match partial words, and it drops the data after the last match when I run your code. For example, try this (modified) test: print(wikify("Mary and Mr. Moore work on Project Omegality. Mr. Moore hates Mary and Project Omega, but Mary loves the Projectaaa.")) It shows both issues.
      singulars
      1. PO
      1. USStigma
    2. COFixed/Changed :)
      singulars
      1. PO
      1. USdaurnimator
    3. COThis is awesome. A real gem. Thank you for your efforts - I learned a lot from you. If you have the chance still, could you explain how one would, for example, match topics case insensitively? I am imagining pre-processing each topic to look like a lpeg form of the following regex: '[Mm][Aa][Rr][Yy]', but somehow I think that is the wrong way to take it. -- Either way, I am accepting this answer, since I have learned plenty from it and it does everything I have asked. Thanks! :)
      singulars
      1. PO
      1. USStigma
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload