[MSNoise] database_tools.py query failing

[Thomas Lecocq]

Rob,

The stack procedure should not send any "%", as the stack is done "per 
pair"...

could you:

1/ print the "pair" in the database_tools query
2/ send a screenshot of your Station table

Thanks

Thomas


Le 14/05/2014 17:26, Abbott, Robert E a écrit :
> Thomas,
>
> I am still experiencing this same problem on 1.2.4. Mac OS X and MySQL.
>
> Thanks,
> Rob
>
>
> From: <Abbott>, Robert Abbott <reabbot at sandia.gov<mailto:reabbot at sandia.gov>>
> Date: Tuesday, April 1, 2014 2:51 PM
> To: Python Package for Monitoring Seismic Velocity Changes using Ambient Seismic Noise <msnoise at mailman-as.oma.be<mailto:msnoise at mailman-as.oma.be>>
> Subject: database_tools.py query failing
>
> Thomas,
>
> When trying to use s04stack.py, I keep getting the message of "Found 000 updated days" when it is not true. I have tried changing the "–i" interval to no avail (e.g. s04stack.py -m -r -i 100). I think I have traced the problem to the following queries in database_tools.py:
>
> if pair == '%':
>          days = session.query(Job).filter(Job.day >= date1).filter(Job.day <= date2).filter(Job.type == type).filter(Job.lastmod >= lastmod).group_by(Job.day).order_by(Job.day).all()
>      else:
>          days = session.query(Job).filter(Job.pair == pair).filter(Job.day >= date1).filter(Job.day <= date2).filter(Job.type == type).filter(Job.lastmod >= lastmod).group_by(Job.day).order_by(Job.day).all()
>
> The call from s04stack.py goes to the ELSE conditions, but days == [ ] after the query.
>
> If I manually set 'pair = '%' on the line before, then 'days' returns what looks to be correct. As the only difference in the two queries is filtering by Job.pair, maybe that is the problem. I am attaching a screenshot of my jobs table.  I manually changed 'lastmod' at one point to yesterday in case the –i switch was not working correctly.
>
> I am on Mac OS X.
>
> Thanks,
> Rob
>
>
> +----------------------------+
> Robert E. Abbott, Ph.D.
> Sandia National Laboratories
> Geophysics Department MS 0750
> P.O. Box 5800
> Albuquerque, NM 87185-0750
> (505) 845-0266
> +----------------------------+
>
> +----------------------------+
> Robert E. Abbott, Ph.D.
> Sandia National Laboratories
> Geophysics Department MS 0750
> P.O. Box 5800
> Albuquerque, NM 87185-0750
> (505) 845-0266
> +----------------------------+
>
> _______________________________________________
> MSNoise mailing list
> MSNoise at mailman-as.oma.be
> http://mailman-as.oma.be/mailman/listinfo/msnoise