Skip to content

Instantly share code, notes, and snippets.

@dandiep
dandiep / gist:1094148
Created July 20, 2011 01:24
MQL Version data
from payload as u
select new(com.mulesoft.mql.example.User) {
name = u.name,
email = u.email,
address = new(com.mulesoft.mql.example.Address) {
address = u.address,
city = u.city,
state = u.state
}
}
@dandiep
dandiep / gist:1094105
Created July 20, 2011 00:54
MQL Merge
<mql:transform query="from yammer.messages select new { text = body.plain }" />
<mql:transform query="from twitter.publicTimeline as tweet select new { text = tweet.text }" />
@dandiep
dandiep / gist:1090793
Created July 18, 2011 22:05
MQL Java
List<User> users = ...;
Map<String,Object> context = new HashMap<String,Object>();
context.put("users", users);
Collection<User> result =
Query.execute("from users where division = 'Engineering'", context);
@dandiep
dandiep / gist:1090771
Created July 18, 2011 21:56
MQL Transform
<mql:transform query="select new { name = u.name, email = u.email}"/>
@dandiep
dandiep / gist:1090770
Created July 18, 2011 21:56
MQL REST service
<mql:query-service name=“UsersService"
address="http://localhost:9002/mulesoft-users"
query="from userManager.users as u where email like 'mulesoft.com'"/>
@dandiep
dandiep / gist:1090766
Created July 18, 2011 21:55
MQL join data from salesforce
from userManager.users as user
join salesforce.query('SELECT Company, MobilePhone
FROM Lead
WHERE Email = \'' + user.email + '\'', 1)
as sfuser
select new {
name = user.name,
email = user.email,
company = sfuser[0].?Company,
mobilePhone = sfuser[0].?MobilePhone
@dandiep
dandiep / gist:1090764
Created July 18, 2011 21:55
MQL transform data
from userManager.users as u
select new {
href = 'http://localhost/users/' + u.id,
name = u.firstName + ' ' + u.lastName,
division = u.division
}
@dandiep
dandiep / gist:1090760
Created July 18, 2011 21:52
Filter Data
from userManager.users
where division = ‘Sales’ and
(email like ‘mulesoft.com’ or email like ‘mulesource.com’)
def request = new Expando();
request.status= 'my tweet'
request.in_reply_to_status_id = 123;
... fill in your object properties
def response = client.resource("http://api.twitter.com/1/statuses/update.json").post(Map.class, request.properties);
import java.util.Map;
@Command("public-tweets")
public class PublicTweetsCommand extends GroovyCommand {
void execute() {
def response = client.resource("http://api.twitter.com/1/statuses/public_timeline.json")
.get(Map[].class);
// print the text field of each tweet object
response.each {