2007/8/13, Rick Morrison [EMAIL PROTECTED]:
That SQL log is from the table existence check.
Although it's unclear from the trace and log as to
whether the check is for the table create
or for the table drop, it is correctly using
the default schema, which is 'dbo' on all
MSSQL platforms.
Hello.
I did submit a job offer to the python web page at
http://www.python.org/community/jobs/ but looks like it will take some
time to be up. Since the job is related to sa I'm posting here also the
announcement. If you are interested, or know somebody who knows somebody
else who...
Found it! Apparently someone had written the connect string
incorrectly (a slash instead of a colon) on the pre-production
machine...
-S
On Aug 14, 12:21 pm, SOS [EMAIL PROTECTED] wrote:
I am getting some kind of error from (apparently) cx_Oracle when
attempting to connect. I am using
It's for the delete (which then does not happen because the table is not
found)
Sure, but the drop is being issued in the correct default schema (dbo). The
error is not that the drop is being issued in the wrong schema, it is that
the table was *created* in the wrong schema, and so is not where
2007/8/14, Rick Morrison [EMAIL PROTECTED]:
It's for the delete (which then does not happen because the table is not
found)
Sure, but the drop is being issued in the correct default schema (dbo).
No it's not. If I don't enable checkfirst the table is dropped, which
means both statements are
Sure, but the drop is being issued in the correct default schema (dbo).
No it's not. If I don't enable checkfirst the table is dropped, which
means both statements are issued on the wrong schema (considering that
the check is right).
Ah OK I didn't get that from the previous
messages. Then it
I just put beta2 up. The important things in this release are major
MS-SQL and Oracle fixes, after we got some on-the-ground testing done.
Theres also a new function we're planning to use in Pylons called
engine_from_config(), which reads a configuration dictionary (such
as from a .ini file)
performance-wise - do u have any test/target for profiling? else i can
repeat some tests i did somewhen in february (if i remember them..)
=
while looking to replace all {} with dict/Dict(), i found some things.
Here the list, quite random, probably some can be just ignored if not
Should ansisql recognize and use default schemas,
or should the DB dialect somehow override the construction of the table
name?
The more I think about this, the more I'm becoming convinced that specifying
an implicit default schema in all generated SQL is a pretty bad idea. The
reason is that
For our app we'd like the user to construct and save search queries
that we execute on the database. My first thought was to construct
something like:
predicate = and_(or_(item.c.id5, item.c.id3),
item.c.name.like('aap')))
And save this to a pickle column in the database. But it gives:
raise
On Aug 14, 11:29 am, Michael Bayer [EMAIL PROTECTED] wrote:
I just put beta2 up. The important things in this release are major
MS-SQL and Oracle fixes, after we got some on-the-ground testing done.
Theres also a new function we're planning to use in Pylons called
engine_from_config(),
I'm trying to make sequences in the Oracle database.
Here's my model
def init():
#conf = paste.deploy.CONFIG
#uri = conf['sqlalchemy.dburi']
if 'login' in session:
uri=1
else:
conf = paste.deploy.CONFIG
uri =
I'm trying to make sequences in the Oracle database.
Here's my model
def init():
#conf = paste.deploy.CONFIG
#uri = conf['sqlalchemy.dburi']
if 'login' in session:
uri=1
else:
conf = paste.deploy.CONFIG
uri =
I've been using the following code for obtaining a mapper class
from some other mapper.
class_mapper(self.__class__).props[name].mapper.class
'props' is no longer available however I found '_Mapper__props'.
Is this the right replacement or is there a smarter way?
Andreas
pgpLkaS4WLfE3.pgp
databases/sqlite: (reflecttable)
pragma_names is missing the BOOLEAN word/type - nulltype
btw why isn't each dialect-typeclass adding it's own entry to that
pragma_names, respectively to the colspecs ?
Or, each class to have those pragmaword and basetype, and the dicts to
be made by walking
theres a method for now, get_property(). it has some extra
features, such as resolve_synonyms.
On Aug 14, 2007, at 3:15 PM, Andreas Jung wrote:
I've been using the following code for obtaining a mapper class
from some other mapper.
class_mapper(self.__class__).props[name].mapper.class
On Aug 14, 2007, at 1:37 PM, Koen Bok wrote:
For our app we'd like the user to construct and save search queries
that we execute on the database. My first thought was to construct
something like:
predicate = and_(or_(item.c.id5, item.c.id3),
item.c.name.like('aap')))
And save this to a
On Aug 14, 2007, at 3:30 PM, [EMAIL PROTECTED] wrote:
databases/sqlite: (reflecttable)
pragma_names is missing the BOOLEAN word/type - nulltype
btw why isn't each dialect-typeclass adding it's own entry to that
pragma_names, respectively to the colspecs ?
Or, each class to have those
we dont have a schema attribute on Sequence right now. we have
only limited testing support for issuing CREATE statements in an
alternate schema, and those are all against Postgres (since i only
have oracle XE here...). adding schema to Sequence is ticket #584
and we also need to do
On Aug 14, 2007, at 12:38 PM, svilen wrote:
performance-wise - do u have any test/target for profiling? else i can
repeat some tests i did somewhen in february (if i remember them..)
look in test/perf for some, just added a mass-insert/mass-select test.
also the current branch im doing
On Aug 14, 2007, at 2:12 PM, Brian Beck wrote:
0.4 looks awesome. Some names jump out at me though:
* sessionmaker - Strange that it's a noun, and not a verb (like
make_session)
the verb would be, make_session_maker. or make_session_class,
except in some cases it might not be an actual
orm.util.AliasedClauses._create_row_adapter()
class AliasedRowAdapter( object):
1. can't this be made as standalone class, returning an
instance, initialized with the map, which is then __call__()ed ?
is it faster to say self.map or to say map from locals() ? its
probably not
On 8/14/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
im not sure try/except is faster here - im pretty sure a missing
key is likely and exception throws are very expensive. would be
worth a try to see if the missing key exception actually occurs
here.
i'll have to check, last 3 years
On Aug 14, 2007, at 4:35 PM, Michael Bayer wrote:
On Aug 14, 2007, at 12:38 PM, svilen wrote:
---
orm.attribute
AttributeManager.init_attr():
the saving this one eventualy does is too small, compared to a
property call of ._state.
i havent benched this in a while but my
24 matches
Mail list logo