is setting echo=True somewhere or using Python's logging
module and turning on SA logging. see the docs/FAQ with regards to
SA's usage of logging.
On Feb 9, 11:42 am, saxon75 [EMAIL PROTECTED] wrote:
settings.db_string = 'mysql://user:[EMAIL PROTECTED]/db'
I'm using MySQL 4.1.14-Debian_5
Here's what I get:
mysql show variables like 'lower_case_table_names';
++---+
| Variable_name | Value |
++---+
| lower_case_table_names | 0 |
++---+
from sqlalchemy import *
engine = create_engine('mysql://my database')
connection = engine.connect()
print connection.execute(show variables like
'lower_case_table_names').fetchone()
('lower_case_table_names', array('c', '0'))
--~--~-~--~~~---~--~~
You
That did it. Thanks!
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL
It must be something stupid on my end, then. I'm sure I'll smack
myself when I figure it out.
Thanks for your help.
On Dec 20, 6:24 pm, Michael Bayer [EMAIL PROTECTED] wrote:
i just tried out your example and it executes fine using mysql 5, query
output is:
SELECT blog_articles.timestamp AS
Hi there,
I'm looking for a little help using MySQL functions in a WHERE clause
with SQLAlchemy.
The query I'd like to do is something like SELECT * FROM x WHERE
YEAR(FROM_UNIXTIME(timestamp)) == '2006';
Here's how I've tried to implement it:
metadata = MetaData()
articles_table =
The initial query I posted definitely works--I've been using something
very much like it for a long time in my existing application. I've
only recently discovered SA, though, and I'm trying to incorporate it
into my design. FROM_TIMESTAMP can definitely take an integer input.
Anyway, thanks.