On 21 Nov 2013, at 04:27, Michael Bayer mike...@zzzcomputing.com wrote:
unixodbc is what you should use on linux, but OSX comes pre-installed with
iODBC (you can also download and install a newer version of iODBC, even build
it from source, though neither is necessary), and pyodbc has been
I'm getting a Memory error when trying to get data from my database. It
happens during a process that loads fixture data into the database, but the
error always happens at the same point on a line that fetches a single record
from the db.
Essentially the line does `item =
On 20 Nov 2013, at 15:56, Michael Bayer mike...@zzzcomputing.com wrote:
On Nov 20, 2013, at 9:39 AM, Ed Singleton singleto...@gmail.com wrote:
I'm getting a Memory error when trying to get data from my database. It
happens during a process that loads fixture data into the database
On 15 Jul 2013, at 18:11, Michael Bayer mike...@zzzcomputing.com wrote:
On Jul 15, 2013, at 11:06 AM, Ed Singleton singleto...@gmail.com wrote:
I have two tables in SQLAlchemy which are identical and I want to update one
from the other where the rows have the same primary key, and I want
On 19 Jul 2013, at 16:01, Michael Bayer mike...@zzzcomputing.com wrote:
On Jul 19, 2013, at 9:53 AM, Ed Singleton singleto...@gmail.com wrote:
On 15 Jul 2013, at 18:11, Michael Bayer mike...@zzzcomputing.com wrote:
On Jul 15, 2013, at 11:06 AM, Ed Singleton singleto...@gmail.com wrote:
I
I have two tables in SQLAlchemy which are identical and I want to update one
from the other where the rows have the same primary key, and I want to do it in
an efficient way.
I tried joining the tables on the primary key, but SQLAlchemy doesn't appear to
support updates on joined tables at the
On 29 Jun 2010, at 15:24, Michael Bayer wrote:
On Jun 29, 2010, at 9:12 AM, Ed Singleton wrote:
The following code (if you replace the uri with a working one)
raises an error when run against an MSSQL db, but not against Sqlite.
I'm trying to get the same schema (which uses
The following code (if you replace the uri with a working one) raises
an error when run against an MSSQL db, but not against Sqlite.
I'm trying to get the same schema (which uses MSUniqueIdentifer) to
run against MSSQL and Sqlite.
Any help on fixing this is gratefully received, as I'm at a
I wanted to be able to use Varchar('max') for some columns in
SQLAlchemy (for legacy reasons we have both Varchar(max) and Text
columns). I also needed it to create a new database correctly (from
the same schema) in MS SQL and Sqlite, whilst retaining the same
errors as before for all
On 7 Apr 2010, at 21:14, Michael Bayer wrote:
Ed Singleton wrote:
I wanted to be able to use Varchar('max') for some columns in
SQLAlchemy (for legacy reasons we have both Varchar(max) and Text
columns). I also needed it to create a new database correctly (from
the same schema) in MS SQL
the scenes.
Thanks
Ed
On 11 Feb 2010, at 22:23, Ed Singleton wrote:
I've been having a clumsy hack at enabling myself to pass a select
statement as a value to an insert statement. IE:
sa.insert(mytable).values(myothertable.select())
I've got it working in that most basic case, but I'm
On 12 Feb 2010, at 17:43, Michael Bayer wrote:
Ed Singleton wrote:
To partially clarify and answer my own question here (I was very
tired
by the time I pasted this last night)
In the case of:
sa
.insert
(mytable
).values(myothertable.select().filter_by(foo=sa.bindparam(bar))
This doesn't
On 12 Feb 2010, at 17:43, Michael Bayer wrote:
Ed Singleton wrote:
In the case of:
sa
.insert
(mytable
).values(myothertable.select().filter_by(foo=sa.bindparam(bar))
This doesn't currently work because... [snip]
if you're using the @compiler extension to generate this, the same
compiler
On 12 Feb 2010, at 19:36, Michael Bayer wrote:
Ed Singleton wrote:
class InsertFromSelect(ClauseElement):
def __init__(self, table, select):
self.table = table
self.select = select
@compiles(InsertFromSelect)
def visit_insert_from_select(element, compiler, **kw
I wrote a (long) blog post on this for Leopard. I haven't had the
chance to try it out on Snow Leopard.
http://blog.singletoned.net/2009/07/connecting-to-ms-sql-server-from-python-on-mac-os-x-leopard/
If anyone can tell me how to create virtual machines of Snow Leopard,
I'd be happy to try
I've been having a clumsy hack at enabling myself to pass a select
statement as a value to an insert statement. IE:
sa.insert(mytable).values(myothertable.select())
I've got it working in that most basic case, but I'm struggling when
the select statement has bindparams. The insert needs
Thanks, all seems to be working fine now.
Ed
On 31 Jul 2009, at 15:48, Michael Bayer wrote:
try r6225
Ed Singleton wrote:
Revision 6209 in the sa06 branch breaks everything with MSSQL on Mac
and Linux. It's not a major problem as I've reverted back. But I'd
thought I'd let you know
-
checked the code and don't see anything obvious. I haven't been doing
any low-level SA stuff for several weeks so take this with a pinch of
salt.
pjjH
On Jul 30, 8:28 am, Ed Singleton singleto...@gmail.com wrote:
On 30 Jul 2009, at 04:52, Michael Trier wrote:
Hi,
On Wed, Jul 29, 2009
tabular data stream (TDS) protocol
stream is incorrect. The stream ended unexpectedly. (4002)
(SQLExecDirectW)') 'INSERT INTO [ThingTable] (id, text_field) VALUES
(?, ?)' ['flib', 'test\xc2\xa3']
On 29 Jul 2009, at 18:30, Ed Singleton wrote:
Stupidly forgot to attach the files
Revision 6209 in the sa06 branch breaks everything with MSSQL on Mac
and Linux. It's not a major problem as I've reverted back. But I'd
thought I'd let you know.
Stack trace follows:
Traceback (most recent call last):
File /Users/singletoned/.envs/nmailer/lib/python2.6/site-packages/
On 30 Jul 2009, at 04:52, Michael Trier wrote:
Hi,
On Wed, Jul 29, 2009 at 1:30 PM, Ed Singleton
singleto...@gmail.com wrote:
Stupidly forgot to attach the files.
What I'm trying to achieve is:
1) Ability to insert non-ascii chars into the db on Linux
2) The above but for all
On 29 Jul 2009, at 05:43, Michael Trier wrote:
Hi
On Tue, Jul 28, 2009 at 3:14 PM, Ed Singleton
singleto...@gmail.com wrote:
On 26 Jul 2009, at 15:06, Michael Bayer wrote:
i have freetds 0.82, pyodbc 2.1.4. except for binary it mostly
works
fine (with sqla 0.6
I'm trying to build the docs for SA 0.6 on python2.6 on Mac. I've
assumed I need to use Sphinx (which obvously may be quite wrong of
me), so I've easy_installed Sphinx and Mako, and then I run the command:
mkdir docs
sphinx-build doc/build/ docs
It appears to read in fine but then raises
Ah thanks, that seems to work fine now. Very grateful.
For anyone googling this, use the Makefile means:
$ cd doc/build
$ make html
Ed
On 29 Jul 2009, at 16:26, Michael Bayer wrote:
use the Makefile included in the dist
Ed Singleton wrote:
I'm trying to build the docs for SA 0.6
On 25 Jul 2009, at 03:17, mtrier wrote:
On Jul 23, 8:30 am, Ed Singleton singleto...@gmail.com wrote:
I've managed to get SA (0.6 branch) and pyodbc connecting to anMSSQL
db on Mac OS X, but I've recently been trying to get it working on
linux (Debian Lenny) and have been hitting some
query_f, column_type, query_data_type, ascii_or_non_ascii_
On 29 Jul 2009, at 18:27, Ed Singleton wrote:
On 25 Jul 2009, at 03:17, mtrier wrote:
On Jul 23, 8:30 am, Ed Singleton singleto...@gmail.com wrote:
I've managed to get SA (0.6 branch) and pyodbc connecting to anMSSQL
db on Mac OS X
On 25 Jul 2009, at 03:17, mtrier wrote:
On Jul 23, 8:30 am, Ed Singleton singleto...@gmail.com wrote:
I've managed to get SA (0.6 branch) and pyodbc connecting to anMSSQL
db on Mac OS X, but I've recently been trying to get it working on
linux (Debian Lenny) and have been hitting some
On 26 Jul 2009, at 14:33, Timothy N. Tsvetkov wrote:
Please, tell me about using it in OS X? What driver do u use, versions
etc.
I've just started trying to properly document what I did. I've put up
a blog post about it:
On 26 Jul 2009, at 15:06, Michael Bayer wrote:
i have freetds 0.82, pyodbc 2.1.4. except for binary it mostly works
fine (with sqla 0.6).
Is that on Mac, Linux or both?
Did you do any particular configuration of character encodings?
Ed
I've managed to get SA (0.6 branch) and pyodbc connecting to an MSSQL
db on Mac OS X, but I've recently been trying to get it working on
linux (Debian Lenny) and have been hitting some problems.
It's definitely working to some degree. Adding TDS_Version = 8.0 to
my odbc.ini fixed some
On 8 Jul 2009, at 07:29, John Hampton wrote:
John Hampton wrote:
So, the problem that I am having is that when I try to do a query,
I get
back the following error:
sqlalchemy.exc.ProgrammingError: (ProgrammingError) ('The SQL
contains 0
parameter markers, but 1 parameters were
If it helps, I have finally got my system working, now using FreeTDS
0.82, SQLAlchemy 0.5.3, pymssql, Python 2.5, (all on Mac Leopard) and
SQL Server 2005 (on an WinXP vm).
With this setup, your test passes without any problems.
I also tried it out using pyodbc 2.1.5 and the test failed
On 27 Apr, 16:01, Tom Wood thomas.a.w...@gmail.com wrote:
Hi all,
Am having a problem withSQLAlchemy0.5.3 and MSSQL. Running on a
Debian stack, using FreeTDS 0.82, pyodbc 2.1.4, Python 2.5 and
(separately) SQL Server 2000 and SQL Server 2005.
I have a fairly comparable setup, with
On 12/02/07, Jonathan LaCour [EMAIL PROTECTED] wrote:
Today, we are pleased to announce the release of Elixir
(http://elixir.ematia.de), a declarative mapper for SQLAlchemy. Elixir
is the successor to ActiveMapper and TurboEntity, and is a collaboration
between Daniel Haus, Jonathan LaCour
34 matches
Mail list logo