stucco_evolution 0.4 has been released. It is a migration tool for
SQLAlchemy that attempts to deal with packaged dependencies having their
own migration scripts. Reading - as depends on,
web application - openid package - users/groups package
web application - users/groups package
When asked
On Thursday, April 19, 2012 1:43:59 PM UTC-4, Michael Bayer wrote:
If you've seen my recent talks you saw that I'm a little skeptical of what
you're terming non-monolithic databases.Let's say this means, a
database with a set of tables maintained by entirely different packages,
but
So there you have it. It very well may be that there is exactly one use
case for this package, but who doesn't need to keep track of users and
groups? Other than that it does a passable job of applying hand-written
linear database upgrades, and it is short.
that it is, and the surprise
The query is simply returning rows with one column. For example
session.query(X.a, X.b).all() would return a potentially less surprising
list rows with two columns. The rows can be indexed by name or number. The
'L' is just Python telling you it is a long integer.
--
You received this message
Is this pysqlite issue about SELECT not starting a transaction related?
http://code.google.com/p/pysqlite/issues/detail?id=21
--
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
I suppose you explicitly don't want to call User.morestuff.otherproperty? I
like doing it that way, but it could be that I am underusing SQLAlchemy's
inheritance features. The following works fine:
package 1:
Base1 = declarative_base()
class User(Base1): pass
package 2:
Base2 =
You should expect better ORM performance in newer versions. You should go
straight to 0.6 and see what happens, with an eye on the 0.5 and 0.6 release
notes for the things that most people have to change (it shouldn't be a big
deal).
RunSnakeRun is supposed to be a nifty profiler. Can you
for each
managed package.
stucco_evolution is 200 lines of code with automated tests that provide 100%
statement coverage. It works well for me, but the functions in the API do
not have very good names. Suggestions welcome.
Daniel Holth
--
You received this message because you are subscribed
Thanks Mike. I will have to edit the pysqlite C source code if I want to
prevent it from committing when the query does not contain any of the
strings select, insert, update, delete, or replace.
if (!strcmp(buf, select)) {
return STATEMENT_SELECT;
} else if (!strcmp(buf,
It looks like SQLAlchemy 0.7's events make it a lot easer to prepend /*
select */ to every statement.
Daniel
--
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
I thought I could prepend /* update * / to every statement but that didn't
work. Instead, https://bitbucket.org/dholth/pysqlite/changeset/cdc3a85dcb49
Obviously it should be a flag. Something like
pysqlite2.surprise_transactions(False)
--
You received this message because you are subscribed
Can someone help me understand why DDL seems to not be transactional here:
import sqlalchemy
e = sqlalchemy.create_engine('sqlite://')
c = e.connect()
t = c.begin()
c.execute(CREATE TABLE foo (bar INTEGER))
t.rollback()
assert u'foo' in e.table_names() # True
But, if I start up `sqlite3 db.db`
session.query(sqlalchemy.func.max(MappedClass.column)).scalar()
--
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
You might be interested to know that the situation is more like If you are
not using MySQL, you probably have transactional DDL. Even SQLite has it.
According to
http://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_Analysis
- PostgreSQL - yes
- MySQL -
I am trying to subclass a mapped class from another package for no
other reason than to add a utility method. The polymorphic_on
condition, if it were defined, would have to be 'True'. Example:
class Mapped(declarative_base()):
# columns
class Utility(Mapped):
def is_something(self):
Thank you! I never would have thought of appending a superclass as an
alternative to subclassing or monkeypatching. No wonder Python is so
hard to optimize. I wound up doing the monkey patch and it seems to
work just fine.
--
You received this message because you are subscribed to the Google
On Dec 21, 6:27 pm, gizli mehm...@gmail.com wrote:
Hi all,
This is only for people who use the zope extension for SA (http://
pypi.python.org/pypi/zope.sqlalchemy). Consider the following:
for task in conn.query(Task):
conn.begin_nested()
try:
conn.delete(task)
A SQLAlchemy dialect that can be used to read OpenEdge 10 (aka
Progress) databases over ODBC.
I only use it to read from the database so although it is useful it is
certainly incomplete. There is enough there to make queries against
reflected tables.
It was remarkably easy to implement against
P.S. My application uses reflection. For MySQL it would make so much
sense to combine table exists with show me the table, since they
are the same request. We should cache the result.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to
19 matches
Mail list logo