from astropy.table import Table
from ... import gama
from astropy.tests.helper import remote_data

SQL_QUERY = "SELECT * FROM SpecAll LIMIT 5"
GAMA_URL = "http://www.gama-survey.org/"

@remote_data
def test_GAMA_query_sql_async():
    """Tests that a URL to the GAMA website is returned."""
    result = gama.core.GAMA.query_sql_async(SQL_QUERY)
    assert result.startswith(GAMA_URL)

@remote_data
def test_GAMA_query_sql():
    """Tests that a valid HDUList object is returned."""
    result = gama.core.GAMA.query_sql(SQL_QUERY)
    assert isinstance(result, Table)

