Server version: 5.1.63-log MySQL Community Server (GPL)
SQLAlchemy==0.8.0
I've got a table which has defaults on some columns. When I discover the
table, I get the column names and types, but not the defaults. What am I
doing wrong?
mysql describe component;
MySQL reflects from the SHOW CREATE TABLE output, what does that say in this
case ?
On Mar 25, 2013, at 12:57 PM, Roy Smith r...@panix.com wrote:
Server version: 5.1.63-log MySQL Community Server (GPL)
SQLAlchemy==0.8.0
I've got a table which has defaults on some columns. When I discover
On Mar 25, 2013, at 1:54 AM, Michal Nowikowski godf...@gmail.com wrote:
I got to the point where proper raw SQL query looks as follows:
SELECT
A.id AS a_id,
B_1.id AS b1_id,
B_2.id AS b2_id,
FROM
A
LEFT OUTER JOIN B AS B_1 ON A.id = B_1.a_id AND B_1.c_id = 66
LEFT
I'm looking to do the same (automatic invalidation). Vince, were you able
to get it to work? Any tips worth sharing?
thanks,
--S
On Monday, December 13, 2010 5:31:17 PM UTC-8, Vince Ng wrote:
Hi,
I've been attempting to try to add an abstract layer of Memcache on top of
the current
On Mar 25, 2013, at 1:20 PM, Michael Bayer wrote:
MySQL reflects from the SHOW CREATE TABLE output, what does that say in
this case ?
mysql show create table component;
default is the Python side default. The server side default is
server_default:
for column in metadata.tables['component'].columns:
print %s: %s %s % (column.name, column.type, column.server_default.arg
if column.server_default else None)
On Mar 25, 2013,
Ah, got it. Thanks!
On Mar 25, 2013, at 2:49 PM, Michael Bayer wrote:
default is the Python side default. The server side default is
server_default:
for column in metadata.tables['component'].columns:
print %s: %s %s % (column.name, column.type, column.server_default.arg
*Sorry, just noticed that I replied directly, instead of to the list. Here
are the contents for everyone:*
Thanks for you help. Using the FunctionElement worked quite well, but
I had to tweak the constructor and assign the base parameter to
self.key to make it work properly (failing stack trace