require 'test/unit'
require File.expand_path(File.join(File.dirname(__FILE__), '/testing_app/config/environment.rb'))
class QueryMemcachedTest < Test::Unit::TestCase
def test_extract_table_names
p = "select * from pets"
q = "select * from author_favorites where (author_favorites.author_id = 36) AND (author_favorites.user_id = 11) LIMIT 1"
r = "SELECT * from binary_fields where (binary_fields.place_id = 3)"
s = "select distinct(p.id) from pets p, binary_fields u, binary_fields pu, where pu.user_id = u.id and pu.place_id = p.id and p.id != 3"
t = "select count(*) as count_all from pets inner join binary_fields on pets_id = binary_fields.place_id where (place_id = 3) AND (binary_fields.user_id = 11)"
u = "select * from categories order by created_at DESC limit 10"
v = "SELECT * from pets where id IN (SELECT * from pets where place_id = pets.id)"
w = "SELECT categories.* FROM categories INNER JOIN binary_fields ON binary_fields.id = categories.user_id WHERE ((binary_fields.contact_id = 1))"
assert_equal ['pets'], ActiveRecord::Base.extract_table_names(p)
assert_equal ['author_favorites'], ActiveRecord::Base.extract_table_names(q)
assert_equal ['binary_fields'], ActiveRecord::Base.extract_table_names(r)
assert_equal ['pets', 'binary_fields'], ActiveRecord::Base.extract_table_names(s)
assert_equal ['pets', 'binary_fields'], ActiveRecord::Base.extract_table_names(t)
assert_equal ['categories'], ActiveRecord::Base.extract_table_names(u)
assert_equal ['pets'], ActiveRecord::Base.extract_table_names(v)
assert_equal ['categories', 'binary_fields'], ActiveRecord::Base.extract_table_names(w)
end
end
