Changes to TwinSN table?

[jchiang87]

Hi @rbiswas4,

I'm trying to run your https://github.com/DarkEnergyScienceCollaboration/Monitor/blob/master/examples/reference_lc.ipynb notebook, but I'm getting this error for cell 14:

DatabaseError                             Traceback (most recent call last)
<ipython-input-14-aeb7556a9869> in <module>()
----> 1 ids = reflc.allIdinTable(chunksize=None)
      2 print(ids.astype(int).values.flatten())

/u/gl/jchiang/links/desc_projects/Monitor/python/desc/monitor/truth.pyc in allIdinTable(self, sqlconstraint, chunksize)
    272 
    273         x = pd.read_sql_query(query, con=self.dbConnection,
--> 274                               chunksize=chunksize)
    275         return x
    276 

/nfs/farm/g/desc/u1/LSST_Stack_2016-04-12/lsstsw/miniconda/lib/python2.7/site-packages/pandas/io/sql.pyc in read_sql_query(sql, con, index_col, coerce_float, params, parse_dates, chunksize)
    429     return pandas_sql.read_query(
    430         sql, index_col=index_col, params=params, coerce_float=coerce_float,
--> 431         parse_dates=parse_dates, chunksize=chunksize)
    432 
    433 

/nfs/farm/g/desc/u1/LSST_Stack_2016-04-12/lsstsw/miniconda/lib/python2.7/site-packages/pandas/io/sql.pyc in read_query(self, sql, index_col, coerce_float, params, parse_dates, chunksize)
   1597 
   1598         args = _convert_params(sql, params)
-> 1599         cursor = self.execute(*args)
   1600         columns = [col_desc[0] for col_desc in cursor.description]
   1601 

/nfs/farm/g/desc/u1/LSST_Stack_2016-04-12/lsstsw/miniconda/lib/python2.7/site-packages/pandas/io/sql.pyc in execute(self, *args, **kwargs)
   1574             ex = DatabaseError(
   1575                 "Execution failed on sql '%s': %s" % (args[0], exc))
-> 1576             raise_with_traceback(ex)
   1577 
   1578     @staticmethod

/nfs/farm/g/desc/u1/LSST_Stack_2016-04-12/lsstsw/miniconda/lib/python2.7/site-packages/pandas/io/sql.pyc in execute(self, *args, **kwargs)
   1562                 cur.execute(*args, **kwargs)
   1563             else:
-> 1564                 cur.execute(*args)
   1565             return cur
   1566         except Exception as exc:

pymssql.pyx in pymssql.Cursor.execute (pymssql.c:7483)()

DatabaseError: Execution failed on sql 'SELECT snid FROM TwinkSN': (207, "Invalid column name 'snid'.DB-Lib error message 207, severity 16:\nGeneral SQL Server error: Check messages from the SQL Server\n")

Has there been a change to that table?

[rbiswas4]

@jchiang87 yes, I think 'snid' has changed to 'id' as part of the work in trying to get ready for run 3. I will fix reference_lc.ipynb today. We should have been more careful trying to change tables. Sorry!