Trygger: triggers defined on Yahoo! Query Language Console
Trygger is a Firefox plugin for end users to define sharing rules over websites. To this end, websites are conceived as database tables where sharing is realized as database-like triggers over these tables. As an example, think of Twitter and WordPress as hosting a table of “tweets” and “blog posts”, respectively. You can be interested in publishing into your WordPress blog, tweets from your colleagues that contain the hashtag #SAC2013. The Trygger expression will look something like: ON INSERT a new tweet LIKE “%SAC2013%” DO INSERT a post(tweet) INTO my blog. This is the vision Trygger strives to accomplish. In this page we show the steps to follow to create the previous example as a Trygger.
Follow these steps to install the TRYGGER as a Grease Monkey script into FireFox, and execute the showed trygger example.
STEP 1: Add Grease Monkey to your FireFox browser. The add-on is available clicking this link. Follow the instructions to install it.
STEP 2: Install the TRYGGER script. The script is publicly accessible in the UserScript community. The script will be installed in your browser after clicking the INSTALL button.
STEP 3: Go and log into the YQL Console. Click this link and log in at the top of the page. If you don`t have any Yahoo! account, you can use the Trygger's Facebook account to log in (user: iker.azpeitia@ehu.es passsword: YQLtrigger).
STEP 4: Create your first Trygger. The trygger could be "publish on the yqltrygger's wordpress blog, any tweet of the user yqltrygger containing the Hash Tag #SAC2013". To do so, copy and paste the following trygger into the "YOUR YQL STATEMENT" text box. After that click the "Create Trygger Alias" link:
CREATE TRYGGER twitter2wp AFTER SELECT CHANGES ON twitter.search WHEN q='from:yqltrygger' and text like "%#SAC2013%" BEGIN insert into wordpress.post (title, description, blogurl, username, password) values (NEW.created_at.*, NEW.text.*, "http://trygger.wordpress.com", "yqltrygger", "tryggeryql") END
STEP 5: Raise an event Publish a tweet with the #SAC2013 hash tag. If you don´t have any twitter account, you can access the Trygger's twitter account at this link (user: @yqltrygger pass: tryggeryql) and publish a tweet similar to this: I was here #SAC2013
STEP 6: Check it!! You can check the target blog http://trygger.wordpress.com/. Notice the latency, it could take 10 minutes to detect the event and fire the trigger. NOTE: If more than one trygger is defined affecting the http://trygger.wordpress.com/ blog, it could result in the publication of multiple copies of a post.
