On 8/27/15 4:41 PM, Demitri Muna wrote:
Hi,
Thanks for the help.
2015-08-27 19:03:18,095 INFO sqlalchemy.engine.base.Engine BEGIN
(implicit)
2015-08-27 19:03:18,096 INFO sqlalchemy.engine.base.Engine SELECT
platedb.plate_pointing.pk AS platedb_plate_pointing_pk,
platedb.plate_pointing.hour_angle AS
platedb_plate_pointing_hour_angle, platedb.plate_pointing.plate_pk AS
platedb_plate_pointing_plate_pk, platedb.plate_pointing.pointing_pk AS
platedb_plate_pointing_pointing_pk,
platedb.plate_pointing.pointing_name AS
platedb_plate_pointing_pointing_name, platedb.plate_pointing.priority
AS platedb_plate_pointing_priority,
platedb.plate_pointing.ha_observable_min AS
platedb_plate_pointing_ha_observable_min,
platedb.plate_pointing.ha_observable_max AS
platedb_plate_pointing_ha_observable_max
FROM platedb.plate_pointing JOIN platedb.plate ON platedb.plate.pk =
platedb.plate_pointing.plate_pk
WHERE platedb.plate.plate_id = %(plate_id_1)s
2015-08-27 19:03:18,096 INFO sqlalchemy.engine.base.Engine
{'plate_id_1': 7555}
2015-08-27 19:03:18,097 DEBUG sqlalchemy.engine.base.Engine Col
('platedb_plate_pointing_pk', 'platedb_plate_pointing_hour_angle',
'platedb_plate_pointing_plate_pk',
'platedb_plate_pointing_pointing_pk',
'platedb_plate_pointing_pointing_name',
'platedb_plate_pointing_priority',
'platedb_plate_pointing_ha_observable_min',
'platedb_plate_pointing_ha_observable_max')
2015-08-27 19:03:18,098 DEBUG sqlalchemy.engine.base.Engine Row (6546,
Decimal('45.0'), 10702, 6369, u'A', 8, Decimal('32.054'),
Decimal('53.465'))
***** 2015-08-27 19:03:18,100 INFO sqlalchemy.engine.base.Engine
SELECT platedb.plate.pk AS platedb_plate_pk, platedb.plate.plate_id AS
platedb_plate_plate_id, platedb.plate.design_pk AS
platedb_plate_design_pk, platedb.plate.location_id AS
platedb_plate_location_id, platedb.plate.comment AS
platedb_plate_comment, platedb.plate.plate_location_pk AS
platedb_plate_plate_location_pk, platedb.plate.temperature AS
platedb_plate_temperature, platedb.plate.epoch AS platedb_plate_epoch,
platedb.plate.rerun AS platedb_plate_rerun, platedb.plate.plate_run_pk
AS platedb_plate_plate_run_pk, platedb.plate.tile_id AS
platedb_plate_tile_id, platedb.plate.name AS platedb_plate_name,
platedb.plate.chunk AS platedb_plate_chunk, platedb.plate.tile_pk AS
platedb_plate_tile_pk, platedb.plate.plate_completion_status_pk AS
platedb_plate_plate_completion_status_pk,
platedb.plate.current_survey_mode_pk AS
platedb_plate_current_survey_mode_pk
FROM platedb.plate
WHERE platedb.plate.pk = %(param_1)s
2015-08-27 19:03:18,100 INFO sqlalchemy.engine.base.Engine {'param_1':
10702}
2015-08-27 19:03:18,101 DEBUG sqlalchemy.engine.base.Engine Col
('platedb_plate_pk', 'platedb_plate_plate_id',
'platedb_plate_design_pk', 'platedb_plate_location_id',
'platedb_plate_comment', 'platedb_plate_plate_location_pk',
'platedb_plate_temperature', 'platedb_plate_epoch',
'platedb_plate_rerun', 'platedb_plate_plate_run_pk',
'platedb_plate_tile_id', 'platedb_plate_name', 'platedb_plate_chunk',
'platedb_plate_tile_pk', 'platedb_plate_plate_completion_status_pk',
'platedb_plate_current_survey_mode_pk')
2015-08-27 19:03:18,101 DEBUG sqlalchemy.engine.base.Engine Row
(10702L, 7555, 7926L, 5007L, u'200', 23, Decimal('14.1'),
Decimal('2014.6'), u' ', 659, None, u'K07_075+17',
u'2014.04.c.apogee2', None, 0, None)
<PlatePointing: plate=7555, pointing=A (id=6546)>
2015-08-27 19:03:18,102 INFO sqlalchemy.engine.base.Engine SELECT
platedb.plate_pointing.pk AS platedb_plate_pointing_pk,
platedb.plate_pointing.hour_angle AS
platedb_plate_pointing_hour_angle, platedb.plate_pointing.plate_pk AS
platedb_plate_pointing_plate_pk, platedb.plate_pointing.pointing_pk AS
platedb_plate_pointing_pointing_pk,
platedb.plate_pointing.pointing_name AS
platedb_plate_pointing_pointing_name, platedb.plate_pointing.priority
AS platedb_plate_pointing_priority,
platedb.plate_pointing.ha_observable_min AS
platedb_plate_pointing_ha_observable_min,
platedb.plate_pointing.ha_observable_max AS
platedb_plate_pointing_ha_observable_max
FROM platedb.plate_pointing JOIN platedb.plate ON platedb.plate.pk =
platedb.plate_pointing.plate_pk
WHERE platedb.plate.plate_id = %(plate_id_1)s
2015-08-27 19:03:18,102 INFO sqlalchemy.engine.base.Engine
{'plate_id_1': 8636}
2015-08-27 19:03:18,103 DEBUG sqlalchemy.engine.base.Engine Col
('platedb_plate_pointing_pk', 'platedb_plate_pointing_hour_angle',
'platedb_plate_pointing_plate_pk',
'platedb_plate_pointing_pointing_pk',
'platedb_plate_pointing_pointing_name',
'platedb_plate_pointing_priority',
'platedb_plate_pointing_ha_observable_min',
'platedb_plate_pointing_ha_observable_max')
Traceback (most recent call last):
File "/home/muna/sdss_python_module/bin/populate_obs_ranges2.py",
line 290, in <module>
filter(Plate.plate_id==plateid).one()
File
"/home/sdss4/products/Linux64/sqlalchemy/0.9.7/lib/python2.7/site-packages/sqlalchemy/orm/query.py",
line 2375, in one
raise orm_exc.NoResultFound("No row was found for one()")
sqlalchemy.orm.exc.NoResultFound: No row was found for one()
this log shows clearly that the second query is not returning any rows
at the DBAPI driver level - you can see that unlike the first query,
there is no "Row" logged. The query you want to run on your database
would be using plate_id 8636 and you want to make sure the JOIN is there
also:
SELECT platedb.plate_pointing.pk AS platedb_plate_pointing_pk,
platedb.plate_pointing.hour_angle AS platedb_plate_pointing_hour_angle,
platedb.plate_pointing.plate_pk AS platedb_plate_pointing_plate_pk,
platedb.plate_pointing.pointing_pk AS
platedb_plate_pointing_pointing_pk, platedb.plate_pointing.pointing_name
AS platedb_plate_pointing_pointing_name, platedb.plate_pointing.priority
AS platedb_plate_pointing_priority,
platedb.plate_pointing.ha_observable_min AS
platedb_plate_pointing_ha_observable_min,
platedb.plate_pointing.ha_observable_max AS
platedb_plate_pointing_ha_observable_max
FROM platedb.plate_pointing JOIN platedb.plate ON platedb.plate.pk =
platedb.plate_pointing.plate_pk
WHERE platedb.plate.plate_id = 8636
--
You received this message because you are subscribed to the Google
Groups "sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to sqlalchemy+unsubscr...@googlegroups.com
<mailto:sqlalchemy+unsubscr...@googlegroups.com>.
To post to this group, send email to sqlalchemy@googlegroups.com
<mailto:sqlalchemy@googlegroups.com>.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.