Actually I made a mistake in running some of these py files manually. The
tables exist now and this is what I receive:
2009-04-17 19:04:59,780 INFO sqlalchemy.engine.base.Engine.0x...1230 ()
2009-04-17 19:04:59,796 INFO sqlalchemy.engine.base.Engine.0x...1230 COMMIT
C:\Dev\pysched>python creates
The SERVERS table doesn't exist according to the trace. Did you create
your tables?
Sent from mobile
On Apr 17, 2009, at 7:31 PM, Michael Mileusnich
wrote:
> C:\Dev\pysched>python createservers.py
> D:\Python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy
> \databases\ms
> sql.p
Hi,
I was trying to migrate from 0.4 to 0.5, and I noticed a behavior in
0.5 that wasn't listed in the migration document that I'd like to
disable. It appears that in 0.5, begin no longer allows for
subtransactions by default, and that there is no global flag to turn
this behavior on. Is there a
C:\Dev\pysched>python createservers.py
D:\Python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\databases\ms
sql.py:977: DeprecationWarning: object.__new__() takes no parameters
return super(MSSQLDialect, cls).__new__(cls, *args, **kwargs)
2009-04-17 18:29:10,421 INFO sqlalchemy.engine
On Apr 17, 2009, at 5:46 PM, Michael Mileusnich
wrote:
> First, thanks for being patient and assisting me. I am very thankful.
>
> MS SQL 2005 is the db I am running.
>
> part of my db.py script:
>
> try:
> connection = config.get("db", "connection")
> except:
> print "No Database Spe
First, thanks for being patient and assisting me. I am very thankful.
MS SQL 2005 is the db I am running.
part of my db.py script:
try:
connection = config.get("db", "connection")
except:
print "No Database Specified"
sys.exit(1)
engine = create_engine(connection)
metadata = MetaD
On Fri, Apr 17, 2009 at 2:01 AM, Michael Mileusnich
wrote:
> I am still having issues with pyodbc on Python 2.6.
>
> Platform: Windows XP SP3 32 bit
> Python 2.6
> SQLAlchemy 0.5.3
> pyodbc 2.1.3
>
> I run this exact setup without problems. Maybe if we see the script that
will help. What version
On Mar 25, 2:14 pm, Rick Morrison wrote:
> Yep, same here.
>
> ..on my mssql 2005, I tried this query batch:
>
> """
> set implicit_transactions on
> go
> select 'After implicit ON', @@trancount
>
> exec sp_datatype_info
> go
> select 'After query w/implicit', @@trancount
>
> begin transaction
Michael Mileusnich wrote:
> I add my object to the session and flush. No insert happens. Works fine
> with SQL-LIte. I have have tried adding a commit also but that does not
> help.
turn on your SQL echoing. see if INSERT is emitted. see if COMMIT is
emitted, etc.
>
> On Fri, Apr 17, 200
I add my object to the session and flush. No insert happens. Works fine
with SQL-LIte. I have have tried adding a commit also but that does not
help.
On Fri, Apr 17, 2009 at 10:02 AM, Michael Bayer wrote:
>
>
> can you be more specific what "will not insert" means.
>
>
> Michael Mileusnich wro
can you be more specific what "will not insert" means.
Michael Mileusnich wrote:
> I do not recall having installed FreeTDS.
>
> On Fri, Apr 17, 2009 at 9:56 AM, Michael Bayer
> wrote:
>
>>
>>
>> are you using FreeTDS ? there's a known issue with FreeTDS and SQLA
>> 0.5.
>>
>>
>> Michael Mileu
Ubestim wrote:
>
> The mysql has gone away thing:
> mysql server timeout:60 (1 min)
> I read the source code of SA , and figure out the following
> solutions :
> sl1 --> set pool_size=1 and max_overflow #this will close all
> connections in pool,because the
>
I do not recall having installed FreeTDS.
On Fri, Apr 17, 2009 at 9:56 AM, Michael Bayer wrote:
>
>
> are you using FreeTDS ? there's a known issue with FreeTDS and SQLA 0.5.
>
>
> Michael Mileusnich wrote:
> > I am still having issues with pyodbc on Python 2.6.
> >
> > Platform: Windows XP SP3
are you using FreeTDS ? there's a known issue with FreeTDS and SQLA 0.5.
Michael Mileusnich wrote:
> I am still having issues with pyodbc on Python 2.6.
>
> Platform: Windows XP SP3 32 bit
> Python 2.6
> SQLAlchemy 0.5.3
> pyodbc 2.1.3
>
> When I use SQL-Lite, my tables are created and all my
> -Original Message-
> From: sqlalchemy@googlegroups.com
> [mailto:sqlalch...@googlegroups.com] On Behalf Of JanW
> Sent: 17 April 2009 14:45
> To: sqlalchemy
> Subject: [sqlalchemy] Re: mapping class against arbitrary SQL
> expression
>
>
> OK, thanks,
>
> it does work if you make an
The mysql has gone away thing:
mysql server timeout:60 (1 min)
I read the source code of SA , and figure out the following
solutions :
sl1 --> set pool_size=1 and max_overflow #this will close all
connections in pool,because the
only conn i
OK, thanks,
it does work if you make an alias on the select like this:
s = select([left.c.car_id,
left.c.temperature.label('left_temperature'),
right.c.temperature.label('right_temperature')],
from_obj=tables,
whereclause=and_(left.c.side == 'left',
> -Original Message-
> From: sqlalchemy@googlegroups.com
> [mailto:sqlalch...@googlegroups.com] On Behalf Of JanW
> Sent: 17 April 2009 13:18
> To: sqlalchemy
> Subject: [sqlalchemy] mapping class against arbitrary SQL expression
>
>
> Hi,
>
> is there a way to map a class against an a
Hi,
is there a way to map a class against an arbitrary SQL expression
(read-only would be OK)? I can't find the correct way to define the
selectable for the mapper.
Example:
this table:
carside_table = Table(
'carside', metadata,
Column('id', Integer, primary_key=True),
Column('car_i
the solution was to inherit setup.USER with a non-relative path
fossati.models.client.User.
I misinterpreted the words 'whose mapper...' and believed it was
referencing Entry.user while it is referred to setup.USER.
sandro
--~--~-~--~~~---~--~~
You received this
20 matches
Mail list logo
