def test_from_url(self):
if not os.getenv('TEST_REMOTE'):
return True
url = "http://spreadsheets.google.com/pub?key=thJa_BvqQuNdaFfFJMMII0Q&output=csv"
t1 = TableFu.from_url(url)
t2 = TableFu(urllib2.urlopen(url))
self.assertEqual(t1.table, t2.table)
def data(self):
"""Return a TableFu instance with data for this model"""
if hasattr(self, '_data') and self._data is not None:
return self._data
if self.file:
# this gets wrapped in a with block for cleanliness
d = TableFu.from_file(self.file.path)
elif self.url:
d = TableFu.from_url(self.url)
else:
return None
if self.columns:
d.columns = self.columns
self._data = d
return self._data
def test_from_url(self):
url = "http://spreadsheets.google.com/pub?key=thJa_BvqQuNdaFfFJMMII0Q&output=csv"
t1 = TableFu.from_url(url)
t2 = TableFu(urllib2.urlopen(url))
self.assertEqual(t1.table, t2.table)
def test_from_url(self):
murders = TableFu.from_url(self.url)
tabled = Table(title="DC Homicides 2010", added_by=self.user, url=self.url)
tabled.save()
self.assertEqual(murders.table, tabled.data.table)
