Marcin Krol wrote:
>
> I have indeed turned that on and looked there for hints, but I haven't
> found anything - e.g. I can see queries and parameters, but not values
> returned by SQL:
>
> INFO:sqlalchemy.engine.base.Engine.0x...a98c:SELECT newhosts.id AS
> newhosts_id, newhosts.ip AS newho
> sts_ip, newhosts.hostname AS newhosts_hostname, newhosts.location AS
> newhosts_location, newhosts.arc
> hitecture_id AS newhosts_architecture_id, newhosts.os_kind_id AS
> newhosts_os_kind_id, newhosts.os_ve
> rsion_id AS newhosts_os_version_id, newhosts.virtualization_id AS
> newhosts_virtualization_id, newhos
> ts.shareable AS newhosts_shareable, newhosts.shareable_between_projects
> AS newhosts_shareable_betwee
> n_projects, newhosts.cpu AS newhosts_cpu, newhosts.ram AS newhosts_ram,
> newhosts.notes AS newhosts_n
> otes, newhosts.physical_box AS newhosts_physical_box,
> newhosts.project_id AS newhosts_project_id
> FROM newhosts, reservation_newhosts
> WHERE %(param_1)s = reservation_newhosts.reservation_id AND newhosts.id
> = reservation_newhosts.host_
> id
> INFO:sqlalchemy.engine.base.Engine.0x...a98c:{'param_1': 2}
>
> No values returned in sight.
>
> I have sql logging configured like this:
>
> logging.basicConfig(filename=globalpath + os.sep + 'sql.log')
> logging.getLogger('sqlalchemy.engine').setLevel(logging.DEBUG)
> logging.getLogger('sqlalchemy.orm.unitofwork').setLevel(logging.DEBUG)the logging configuration is not working. You should see DEBUG lines in your log output, and at the very least you'd see empty result sets after a SELECT. Make sure nothing else is changing the log level later on, including "echo=True" which should never be used with explicit logging (yes this is documented as well). --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---
