Rails Snippets — Arbitrary SQL
Seems I’m in a Ruby/Rails mood today
Sometimes you don’t need the whole Rails stuff and just want to place a query.
Try the following:
[code]]czo0OTpcIkFjdGl2ZVJlY29yZDo6QmFzZS5jb25uZWN0aW9uLihzZWxlY3RfYWxsfHVwZGF0ZSlcIjt7WyYqJl19[[/code]
will do the trick.
Example:
[code]]czo3NDpcImxpc3QgPSBBY3RpdmVSZWNvcmQ6OkJhc2UuY29ubmVjdGlvbi5zZWxlY3RfYWxsKFwic2VsZWN0IGEsYiBmcm9tIGNfdGFie1smKiZdfWxlXCIpXCI7e1smKiZdfQ==[[/code]
==> [ {a => Value_for_a, b => Value_for_b}, {a => Value...}...]
[code]]czoxMTc6XCIgbnVtYmVyX29mX3Jvd3MgPSBBY3RpdmVSZWNvcmQ6OkJhc2UuY29ubmVjdGlvbi51cGRhdGUoXCJ1cGRhdGUgbW9udGgge1smKiZdfXNldCBtb250aF9pZCA9IG1vbnRoX2lkICsxIHdoZXJlIG1vbnRoX2lkID0gMTFcIilcIjt7WyYqJl19[[/code]
If you make use of an already created Rails Model instead of the base class, you will get the benefit of accessors (instead of hash-keys) for the selected objects.
Example (necessary, I know 
)
- create the model
[code]]czozMDpcIiMgc2NyaXB0L2dlbmVyYXRlIG1vZGVsIENUYWJsZVwiO3tbJiomXX0=[[/code]
- use it in your code
[code]]czo1MzpcIiBsaXN0ID0gQ1RhYmxlLmZpbmRfYnlfc3FsKFwic2VsZWN0IGEsYiBmcm9tIGNfdGFibGVcIilcIjt7WyYqJl19[[/code]
- access elements
[code]]czoxMjpcInBwIGxpc3RbMF0uYVwiO3tbJiomXX0=[[/code]
