oleander

RAILS_ROOT ||= File.expand_path("../..", __FILE__)

God.watch do |w|
  w.name  = "list_parser"
  w.group = "movify"
  w.interval = 30.seconds
  w.dir      = File.dirname(__FILE__)
  
  w.env = {
    "BUNDLE_GEMFILE" => "#{RAILS_ROOT}/Gemfile",

oleander

Source.create([
  {:name => "CAM", :regex => "cam"}, 
  {:name => "Telesync", :regex => "telesync|([^a-z])ts([^a-z]?)"},
  {:name => "Telecine", :regex => "telecine|([^a-z])tc([^a-z]?)"},
  {:name => "Rx", :regex => "([^a-z])rx([^a-z]?)"},
  {:name => "Screener", :regex => "dvdscr|screener"},
  {:name => "HDTV", :regex => "hdtv"},
  {:name => "DVDRip", :regex => "dvd(-?)rip", :priority => 1},
  {:name => "Workprint", :regex => "workprint"},
  {:name => "BluRay", :regex => "brrip|bluray|blu(-?)ray"}

oleander

SELECT `users`.* FROM `users` INNER JOIN `authentications` ON `authentications`.`user_id` = `users`.`id`

oleander

SELECT `users`.* FROM `users` INNER JOIN `authentications` ON `authentications`.`user_id` = `users`.`id`

oleander

SELECT DISTINCT movies.*
FROM `movies` 
INNER JOIN `torrents` ON `torrents`.`movie_id` = `movies`.`id`
WHERE MATCH (torrents.title) AGAINST('String', IN BOOLEAN MODE)

ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' IN BOOLEAN MODE)' at line 4

oleander

songs = channel.gigs.includes({
  :song => :urls
}).
order("gigs.time DESC").
limit(400).
map{ |g| g.song.spotify }.
reject(&:blank?)

oleander

SELECT channels.* 
FROM channels 
INNER JOIN gigs ON gigs.channel_id = channels.id 
INNER JOIN songs ON songs.id = gigs.song_id 
INNER JOIN songs_urls ON songs_urls.song_id = songs.id 
INNER JOIN urls ON urls.id = songs_urls.url_id
INNER JOIN services ON services.id = urls.service_id

oleander

  position: fixed;
  width: 100%;
  height: 30px;
  border: 1px solid;  
  bottom:0;
  margin: 0px;

oleander

An error occurred: 503 Service Unavailable: {"description": "Could not resolve search", "code": 0, "traceback": ["Traceback (most recent call last):\n", "  File \"/usr/lib/python2.5/site-packages/smisk/mvc/__init__.py\", line 843, in service\n    rsp = self._call_leaf(req_args, req_params)\n", "  File \"/usr/lib/python2.5/site-packages/smisk/mvc/__init__.py\", line 660, in _call_leaf\n    return self.destination(*args, **params)\n", "  File \"/usr/lib/python2.5/site-packages/smisk/mvc/routing.py\", line 65, in __call__\n    return self._call_leaf(*args, **params)\n", "  File \"/usr/lib/python2.5/site-packages/smisk/mvc/routing.py\", line 59, in _call_leaf\n    return self.leaf(*args, **params)\n", "  File \"/usr/lib/python2.5/site-packages/spotify/web_service/common.py\", line 39, in _f\n    return f(*args, **kwargs)\n", "  File \"/usr/lib/python2.5/site-packages/spotify/web_service/common.py\", line 115, in _f\n    return f(page=page, offset=offset, limit=limit, *args, **kwargs)\n", "  File \"/usr/lib/python

oleander

SELECT *, MATCH (songs.title) AGAINST ('Born Bruce') 
  AS song_score,
  MATCH (artists.name) AGAINST ('Born Bruce') 
  AS artist_score
  FROM songs
  INNER JOIN `artists` ON `artists`.`id` = `songs`.`artist_id` 
  WHERE MATCH (artists.name) 
  AGAINST ('Born Burce') OR
  MATCH (songs.title)
  AGAINST ('Born Bruce')