maturity, etc.
Thanks for any info,
--
Don Dwiggins
Advanced Publishing Technology
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@
ION]'
(u'dbo_corporatedata', u'dbo')
The statement (in Subhandler, line 138) that triggered this was:
return Table(tableName, self.meta, autoload=True)
where "tableName" is one of the existing tables in the DB, which is
always accessed at startup. Apparently, the s
On 4/10/13 8:27 AM, Don Dwiggins wrote:
On 4/9/13 2:41 PM, Michael Bayer wrote:
and this used to work? if you're using 0.7, it uses a fairly
primitive system based on __import__(). you'd want to make sure
py2exe is putting every .py file under dialects/ into the final package.
Th
I'm using 0.7.9; should I upgrade to
0.8.0?
On Apr 9, 2013, at 3:35 PM, Don Dwiggins <mailto:ddwigg...@advpubtech.com>> wrote:
I have an applicationusing SA that I distributein "compiled" form,
using py2exe. This has been working well, but I recently ran into a
problem
x27;ve recently moved my development from a
Windows XP machine to a Windows 7 environment on a 64-bit machine.
However, I'm using 32-bit Python, and generating 32-bit executables.
--
Don Dwiggins
Advanced Publishing Technology
--
You received this message because you are subscribed to the
versioning other schema objects?
--
Don Dwiggins
Advanced Publishing Technology
--
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
in some web searching to get
the values of these parameters is to code direct SQL execs, followed by
Selects of the output values. Has anyone come up with a better way?
Thanks,
--
Don Dwiggins
Advanced Publishing Technology
--
You received this message because you are subscribed to the Googl
have some control over this: I have a folder of
scripts under version control that get applied when going to a new
release (new/changed SPs, table changes, changes to the data in
"configuration tables"), so I pretty much know what's in each DB by the
rev number of the folde
chema, and not all at the same "revision level".
Would it be feasible to use Alembic in this kind of situation?
To add a wrinkle: we're starting work to port the schema to PostgreSQL.
Could we manage the MSSQL and PostgreSQL implementations in parallel
with Alembic?
Thanks,
--
to identify any way
to distinguish this case from other errors. I wound up gving up on the
pool, and creating a new connection for each request.
--
Don Dwiggins
Advanced Publishing Technology
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy"
ghlight=caching#beaker-caching.
--
Don Dwiggins
Advanced Publishing Technology
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send emai
could let the user know what needs to be updated.
Just a brain dump at this point,
--
Don Dwiggins
Advanced Publishing Technology
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@goo
allables so they can run independently, you should be fine.
>
> Make sense?
Excellent sense; thanks much.
--
Don Dwiggins
Advanced Publishing Technology
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
&quo
olved.
> It's basically a standard worker thread pattern using queues, with
> only a single worker thread, some knowledge about the SA engine and
> the use of Twisted Deferreds to return the result.
Yes, it is nice and simple and clean. It shouldn'
been closed.
I have no specific request at this point, except to suggest an extension
to ResultProxy to handle this part of the DBAPI cursor API as well. For
my purposes, I'll either live with multiple SA execute's or just drop
down to pyodbc for this.
Thanks for listenin
gone on to that great cloud in the sky.)
Thanks,
--
Don Dwiggins
Advanced Publishing Technology
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sq
; version in the
browser until the user presses Save (in session cookies and/or DOM
objects)? For one thing, this will reduce the HTTP traffic, since
there's only the one load of the original data, and one save request.
--
Don Dwiggins
Advanced Publishing Technology
--~--~-~--~
ot;}}
It's giving you just what you ask for: for every row, append two things
to the list: an integer followed by a dictionary for the row. (I'm
dubious about the outer curly braces, though; when I try a similar chunk
of code, I get "[...]".)
If you want a dictionary whose keys
as a gif or jpg).
--
Don Dwiggins
Advanced Publishing Technology
--~--~-~--~~~---~--~~
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 un
Maybe the best approach would be to use a Python shell to run the
sp_columns proc and format the results yourself. (Or, you might check
whether there are already some decent Linux GUI tools like Query Analyzer.)
FWIW,
--
Don Dwiggins
Advanc
You should have a reasonably formatted table creation script, including
indices and FKs.
HTH,
--
Don Dwiggins
Advanced Publishing Technology
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
zipito wrote:
> Good day community.
>
> I don't know whether it is a good place to asc.
Probably as good as any. You might try on the Twisted mailing list (or
newsgroup gmane.comp.python.twisted) as well.
Happy hunting,
--
Don Dwiggins
Advanced Publish
equivalent SA Table declarations and keep them up to date with schema
changes.
Any ideas along these lines?
--
Don Dwiggins
Advanced Publishing Technology
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sql
reflect an entire DB
> meta3 = MetaData(engine)
> meta3.reflect()
This worked on a large mssql DB -- took several minutes to autoload 760
tables and views. I don't think I'll be doing that very often. 8^)
--
Don Dwiggins
Advanced Publishing Technology
--~--~-~--~~--
doing that on some tables would bring in several dozen other tables.
I'm really just trying to reconcile what I read in the docs with how the
code works.
Thanks for any good words,
--
Don Dwiggins
Advanced Publishing Technology
--~--~-~--~~~---~--~~
You rece
select * from dbo.foo(@var)
-- think of it as a "parameterized view".
I agree that something like the "returns_results" hint might be a good
way to go.
--
Don Dwiggins
Advanced Publishing Technology
--~--~-~--~~~---~--~~
You received
orted out
(it's kind of like doing a version upgrade on a running program without
disturbing the program's state 8^). If I've missed something, and this
problem has been well and completely solved, I'd be delighted to hear of it.
--
Don Dwiggins
Advanced Publishing Techno
x27;m just getting started with SA, but I like the ORM level, and I'm
hoping that it will help in this area. (Just having a realized
"object-level schema" should be a big step forward.)
--
Don Dwiggins
Advanced Publishing Technology
--~--~-~--~~~---~--
28 matches
Mail list logo