
Security News
Follow-up and Clarification on Recent Malicious Ruby Gems Campaign
A clarification on our recent research investigating 60 malicious Ruby gems.
Install from RubyGems by adding it to your Gemfile
, then bundling.
# Gemfile
gem 'mongo_ql'
$ bundle install
MongoQL.compose do
lookup customers,
on: customer_id == _id.to_id,
as: customers
lookup shippings, :as => shippings do |doc|
match order_id == doc._id,
status == :shipped
end
where province == "ON",
discounts.any? { |d| d.price > 6 }
project _id,
total,
customer => customers.name,
tax => total * tax_rate,
status => If price <= 10, "Not Bad", "Good"
group customer,
total => total.sum,
total_tax => tax.sum * 5
sort age.dsc
end
[{
"$lookup": {
"from": "customers",
"as": "customers",
"localField": "customer_id",
"foreignField": {
"$toString": {
"$toObjectId": "$_id"
}
}
}
}, {
"$lookup": {
"from": "shippings",
"as": "shippings",
"pipeline": [{
"$match": {
"$expr": {
"$and": [{
"$eq": ["$order_id", "$$var__id"]
}, {
"$eq": ["$status", "shipped"]
}]
}
}
}],
"let": {
"var__id": "$_id"
}
}
}, {
"$match": {
"$expr": {
"$eq": ["$province", "ON"]
}
}
}, {
"$project": {
"_id": 1,
"total": 1,
"customer": "customers",
"tax": {
"$multiply": ["$total", "$tax_rate"]
}
}
}, {
"$group": {
"_id": "$customer",
"total": {
"$sum": "$total"
},
"total_tax": {
"$multiply": [{
"$sum": "$tax"
}, 5]
}
}
}, {
"$sort": {
"age": -1
}
}]
FAQs
Unknown package
We found that mongo_ql demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
A clarification on our recent research investigating 60 malicious Ruby gems.
Security News
ESLint now supports parallel linting with a new --concurrency flag, delivering major speed gains and closing a 10-year-old feature request.
Research
/Security News
A malicious Go module posing as an SSH brute forcer exfiltrates stolen credentials to a Telegram bot controlled by a Russian-speaking threat actor.