nginx + mruby experiment, /songs/random endpoint.

nginx.conf

server {
  location /songs/random {
    mruby_content_handler '/var/www/apps/songs/random.rb';
  }
 
  location /words/random {
    mruby_content_handler '/var/www/apps/words/random.rb';
  }
}

songs_random.rb

begin
  row = `sqlite3 /var/www/apps/shared/songs.db "SELECT * FROM songs ORDER BY RANDOM() LIMIT 1;"`
  row = row.split('|')

  song = {
    id: row[0],
    artist: row[1],
    title: row[2],
    listen_url: row[3],
    post_url: row[4],
    tags: row[5],
    created_at: row[6]
  }

  Nginx::rputs JSON::stringify({ song: song })
rescue Exception => e
  Ngixn::rputs e
end