>
> easy_install.main(['-Zmad', sitePKG, "sqlalchemy"])
>
> But this gets me 0.6.6.
>
> Gets 0.6.6 if I do the above on Ubuntu 10.10 Maverick, just did the same
> in a VirtualBox/Win 7 machine and I get 0.6.7.
>
>
That's odd. Thank you for the
On Sat, May 7, 2011 at 11:11 AM, werner wrote:
> Just FYI,
>
> I am installing things on Ubuntu 10.10 (Maverick) and when I do this:
>
> easy_install.main(['-Zmad', sitePKG, "sqlalchemy==0.6.8"])
>
>
Maybe I'm confusing the issue but the la
column definition to add the
SPARSE keyword.
--
Michael Trier
http://michaeltrier.com/
--
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 gr
>
>
> Does anyone know how I can add a Column to an existing not yet mapped
> Table?
>
> To add a column use append_column:
http://www.sqlalchemy.org/docs/core/schema.html#sqlalchemy.schema.Table.append_column
Note that doesn't do anything database schema wise for you.
qlalchemy.org/docs/orm/session.html#sqlalchemy.orm.attributes.get_history
>
> --
Michael Trier
http://michaeltrier.com/
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.c
I can quickly refer to get started on
> before_insert and also how to modify a insert statement in
> before_insert?
>
>
This is the area of the docs that describe before_insert and other
MapperExtensions. It's laid out pretty clearly and quite easy to implement:
http://www.sqlalchemy.o
strategies for improved performance.
> return self._in_impl(operators.in_op, operators.notin_op, other)
> --
>
Michael Trier
http://michaeltrier.com/
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this g
07/orm/events.html
http://www.sqlalchemy.org/docs/orm/interfaces.html?highlight=attributeextension#sqlalchemy.orm.interfaces.AttributeExtension
--
Michael Trier
http://michaeltrier.com/
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To po
> On Jun 8, 2010, at 5:38 PM, Clovis Fabricio wrote:
>
>> I'm connecting to mssql server 2000 through pyodbc, via FreeTDS odbc
>> driver, on linux ubuntu 10.04.
>>
>> Sqlalchemy 0.5 uses DATETIME for sqlalchemy.Date() fields.
>>
>> Now Sqlalchemy 0.6 uses DATE, but sql server 2000 doesn't have a
Hello,
On Mar 21, 2010, at 10:43 AM, Manlio Perillo wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Michael Bayer ha scritto:
>> SQLAlchemy 0.6beta2 is now available.This beta may be the last before
>> the 0.6.0 final release. We've hopefully gotten every largish change into
Hello Tan,
On Mar 16, 2010, at 7:57 PM, Tan Yi wrote:
> I mean, I tried to debug a program, using session add() to insert new
> records to database after I deleted all the old records from a table.
> I used the schema.sequence() to build up a mapper
> Can anyone help?
>
> On 3月16日, 下午2时05分,
Hello,
On Mar 4, 2010, at 10:50 PM, Richard Lopes wrote:
> Hi,
>
> I have this mapper defined:
>
> mapper(Resource, resource_table,
>properties = {'type' : relation(ResourceType,lazy = False),
>'groups' : relation(Group, secondary =
> model.tables['resource_group'], backref = 'resou
Hi,
On Mar 1, 2010, at 8:31 PM, Gerry Reno wrote:
> Ok, I fixed all the boolean clause tests but now I'm getting this
> exception on a Text object:
>
> AttributeError: 'Text' object has no attribute 'get_col_spec'
>
> I see where the type system has been revamped but isn't get_col_spec
> still
Hello Jinal,
On Mar 1, 2010, at 7:39 PM, Jinal Jhaveri wrote:
> I would like to store a zlib compressed version of a table field.
> Whats the best way to handle this where all "gets" to that field
> decompress the content and all "sets" to that field "compresses" the
> content
You probably want
On Feb 28, 2010, at 11:21 AM, Manlio Perillo wrote:
> By the way, it seems there is a bug in the documentation:
> http://www.sqlalchemy.org/docs/reference/sqlalchemy/connections.html?highlight=create_engine#sqlalchemy.create_engine
>
> """echo=False – if True, the Engine will log all statements a
Hello,
On Feb 26, 2010, at 2:32 AM, karikris...@gmail.com wrote:
> I could not get "from sqlalchemy.databases.mysql import MSBinary"
> working on my windows XP as well as my Ubuntu 32 and 64 bit machines.
>
> Are they dropped?
>
> Here are summary
>
> ActivePython 2.6.0.0 (ActiveState Software
Hello,
On Feb 24, 2010, at 2:51 PM, st...@mailbag.com wrote:
> Does anyone have a clue on this error? Is it due to a change in
> SQLAlchemy between 0.4.0 and 0.5.8?
>
See:
http://www.sqlalchemy.org/trac/wiki/05Migration
sqlalchemy.logging was renamed to sqlalchemy.log
Michael
--
You recei
Hello,
On Feb 24, 2010, at 11:59 AM, Gregg Lind wrote:
> Is there a nice way to get server_version_info from an existing
> connection or engine?
>
> Right now it looks quite buried in (for pg):
> sqlalchemy.database.postgres.PGDialiect().server_version_info(myconnection).
>
The dialect contain
Hi,
On Feb 10, 2010, at 6:54 PM, David Ressman wrote:
> Hello,
>
> First of all, I'll apologize if this is a really basic question. I've not
> been using SQLAlchemy for long, and I've only very recently picked up Python.
> Even though I've looked everywhere I can think of for an answer to this
> hello all,
>
> I am newbie in sqlalchemy.I am thrilled by the sqlachemy features. But i got
> struck in the how to write the not null for the following:
>
> create table organisation(orgcode varchar(30) not null,orgname text not
> null,primary key(orgcode));
>
> I have written the using de
On Feb 8, 2010, at 3:14 PM, Michael Bayer wrote:
> Domingo Aguilera wrote:
>> Did you use iodbc or unixodbc ?
>
> OSX has some kind of odbc built in, I used that. I think there was a
> document somewhere regarding how it all works (maybe try googling mssql +
> osx).
Yeah it's an implementation
On Feb 7, 2010, at 12:52 PM, Domingo Aguilera wrote:
> Michael,
>
> I installed the tdsodbc package and now it's working in the ubuntu
> server. Tks a lot !!
>
> On Feb 7, 11:33 am, Domingo Aguilera
> wrote:
>> Tks Michael, I never saw the setup directive. Did you compile driver
>> and setup
Hi,
On Feb 7, 2010, at 9:59 AM, Domingo Aguilera wrote:
> I tried 0.8 with 0.6b1 but didn't work. Both 0.8 and 1.0.2 work with
> sqla 0.5.8 without problems.
>
> I began trying using pyodbc in ubuntu yesterday but can't even make it
> run unixodbc with freetds to reach a sqlserver . If someon
> I tried 0.8 with 0.6b1 but didn't work. Both 0.8 and 1.0.2 work with
> sqla 0.5.8 without problems.
>
> I began trying using pyodbc in ubuntu yesterday but can't even make it
> run unixodbc with freetds to reach a sqlserver . If someone has
> configuration tips ot make this work please l
> I have an object from the ORM called obj which has an attribute
> obj.related_objects.
>
> If I do "for ro in obj.related_objects:" does that do a query for each
> iteration?
>
> I have thousands of related_objects per obj and it is not as fast as i
> would like.
It will if you don't eager loa
he actual classes just use autoload.
--
Michael Trier
http://michaeltrier.com/
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegro
nvarchar, ntext)
> >
> > Absolutely any ideas will be appreciated. I'm not sure what to try
> > next. For now I'm going to document how I set up Linux.
Excellent. I'll dig into this tomorrow if I get a chance to see if I can
help propel this along.
--
SA and freetds, and as you said,
> xODBC being optional if you don't mind not using DSNs.
>
Sorry my mistake. You are correct.
--
Michael Trier
http://michaeltrier.com/
http://thisweekindjango.com/
--~--~-~--~~~---~--~~
You received this message becaus
gets converted properly. By default we ignore the
convert_unicode when using pyodbc, but that won't work with freetds in the
mix. We plan to correct this in 0.6 with the ability to pass additional
dbapi information.
Finally my stack is:
Mac: SA -> iODBC -> FreeTDS -> pyodbc ->
On Mon, Jun 8, 2009 at 5:29 PM, Michael Bayer wrote:
>
>
> I'd rather a flag, or better yet in 0.6 a freetds specific dialect/url,
> i.e. mssql+freetds://.
>
I personally like the freetds dialect idea because there's a lot more issues
specific to freetds than just this
s no reason for the local
variable. It can be simplified as:
CREATE PROCEDURE mySP
AS
SELECT TOP 1 aVar
FROM [dbo].[someTable] (UPDLOCK)
WHERE
priority > 0
ORDER BY priority DESC
GO
--
Michael Trier
http://michaeltrier.com/
--~--~-~--~~---
It may not be what you want but have you explored our full text search
support through the use of the match operator?
On May 10, 2009, at 6:13 AM, Nicholas Dudfield
wrote:
>
> Greetings,
>
> I have been using SQLA for a few months.
>
> For admin CRUD index pages I have been using a naive se
On Apr 29, 2009, at 10:08 AM, Tom Wood wrote:
>
> Some additional info, and a possible fix:
>
> I can reproduce this problem running the SQLAlchemy dialect unit
> tests. Using a trunk (r5930) checkout, FreeTDS 0.82 with tds protocol
> version 8.0, pyodbc 2.1.4, Python 2.5 and SQL Server 2005,
t;> from sqlalchemy.databases.mssql import MSSQLDialect
>> MSSQLDialect.do_begin = lambda self, conn: pass
>>
>> Not sure this is related though (or if this is a good solution), just
>> thought I'd let it know in case it helps.
>>
>> greetings,
>>
VALUES (?, ?, ?, ?, ?, ?)
> 2009-04-24 16:10:30,707 INFO sqlalchemy.engine.base.Engine.0x...6110
> ['500', None, 'sol', None, None, None]
> 2009-04-24 16:10:30,723 INFO sqlalchemy.engine.base.Engine.0x...6110
> COMMIT
> 2009-04-24 16:10:30,723 INFO sqlalchemy.eng
?, ?, ?, ?)
> 2009-04-24 16:10:30,707 INFO sqlalchemy.engine.base.Engine.0x...6110
> ['500', None, 'sol', None, None, None]
> 2009-04-24 16:10:30,723 INFO sqlalchemy.engine.base.Engine.0x...6110
> COMMIT
> 2009-04-24 16:10:30,723 INFO sqlalchemy.engine.base.Engine.0x.
ad at this point from what I understand.
Additionally I'll point out that I have a project called Django-SQLAlchemy
(http://gitorious.org/projects/django-sqlalchemy) that has the aim of
automatically making SQLAlchemy accessible through D
experience with. So in other words you have to write HAVING COUNT(*) > 1,
and can't refer to an alias as in HAVING ticket_count > 1.
--
Michael Trier
http://blog.michaeltrier.com/
http://thisweekindjango.com/
--~--~-~--~~~---~--~~
You received thi
?)
> 2009-04-17 19:05:07,217 INFO sqlalchemy.engine.base.Engine.0x...0270
> ['agent1',
>
> '192.168.0.100', 2000, 0, None, 1, 1, 1, 1, 0]
> 2009-04-17 19:05:07,217 INFO sqlalchemy.engine.base.Engine.0x...0270
> COMMIT
>
>
>
>
> On Fri, Apr 17, 20
name 'SERVERS'.
> (208) (SQLE
> xecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL
> Server]Statement(s)
> could not be prepared. (8180)") u'INSERT INTO [SERVERS] ([SERVER],
> [IP], [PORT]
> , [OS], [JSERVER], [STARTED], [STDIN], [LOGIN], [CWD]
umn('STARTINDIR', String(512)),
> Column('PRIO', Integer),
> Column('USERID', Integer, ForeignKey('USERS.USERID')))
>
> ...
> more tables here
> ...
> etc
>
> mapper(action, action_table)
>
> here is my create:
will help. What version of MSSQL?
> --
> Michael Trier
> http://blog.michaeltrier.com/
> http://thisweekindjango.com/
>
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group
mpty.
>> >
>> > Here is some example code that does not work:
>> >
>> > from sqlalchemy.orm import *
>> >
>> > from db import *
>> >
>> > session = getsession()
>> >
>> > new_serv = server(SERVER = "t
blem. My only guess is that it's a TDS thing (I believe you
said you were using that). The odd thing is that the list of items you're
seeing across the wire is exactly what I'm getting as well and what should
be expected.
--
Michael Trier
http://blog.michaeltrier.com/
ht
Hi,
On Tue, Feb 17, 2009 at 5:22 PM, Ken wrote:
>
> On Feb 17, 3:13 pm, Michael Trier wrote:
> > backref supports the same arguments as relation(), which include an
> order_by
> > argument.
> >
> > http://www.sqlalchemy.org/docs/05/reference/orm/mapping.html?h
ly. I don't see an option for that in the
> Relation()/backref() arguments. What am I missing?
>
backref supports the same arguments as relation(), which include an order_by
argument.
http://www.sqlalchemy.org/docs/05/reference/orm/mapping.html?highlight=backref#sqlalchemy
ing or a script that gets run once that
> generates code for use.
> -
There's this: http://www.sqlalchemy.org/trac/wiki/UsageRecipes/AutoCode
--
Michael Trier
http://blog.michaeltrier.com/
http://thisweekindjango.com/
--~--~-~--~~~---~--~~
You receive
r)).update({'title':'updated'},
synchronize_session=False)
3
I'd be interested to see what your analysis uncovers.
--
Michael Trier
http://blog.michaeltrier.com/
http://thisweekindjango.com/
--~--~-~--~~~---~--~~
You received this me
you
> > wouldn't need the "dbo" segment ?
>
> Thank you for the answer.
>
> Well, I am using SQLServer 2000. I don't see this option. Dropping the
> dbo part gives me this error:
>
SQL 2000 doesn't really support schemas, but the idea of an owner.
to be filtered. Then for the remaining items need to loop
> through to get the value?!
>
> I figured there was a uniform function that would return dictionary of
> key/value pairs that is available on all the possible return objects.
>
> __dict__ is good e
to
> the current 0.5 release (I know this since you're referencing a line
> of code only present in prior versions of 0.5). this has been fixed.
>
Yeah, I just double checked with your test case and it works in the recent
version.
--
Michael Trier
ht
>
>
> Is there anyway to print the query with the params in place?
>
There's this Recipe (http://www.sqlalchemy.org/trac/wiki/DebugInlineParams
).
--
Michael Trier
http://blog.michaeltrier.com/
http://thisweekindjango.com/
--~--~-~--~~~---~--~~
to handle SQLAlchemy mapped classes (RumAlchemy) and a form
> generator using tw.forms (tw.rum).
>
Very nice work! I'm very excited about what you're doing. Thank you.
--
Michael Trier
http://blog.michaeltrier.com/
http://thisweekindjango.com/
--~--~-~--~~~-
On Sat, Jan 10, 2009 at 9:54 PM, Michael Trier wrote:
> 1. Override do_begin so that it creates a cursor and then executes on the
>> cursor:
>>
>> def do_begin(self, connection):
>> cursor = connection.cursor()
>> cursor.execu
re certainly errors. My
understanding is that it's a lot slower than pyodbc. Other than that I just
don't know. I'd like to get it to full test passing as well. I think it's
certainly possible.
--
Michael Trier
http://blog.michaeltrier.com/
http://thisweekindjango.com/
--
everyone's connection strings, but you should use the new syntax.
> ps. I miss the "one page" documentation(easier to search) , is that
> available or can be done with sphinx?
>
Have you tried the sphinx search? I think it's the b
Hi,
On Fri, Jan 9, 2009 at 12:45 PM, t...@twopeasinabucket.com <
t...@twopeasinabucket.com> wrote:
>
> On Jan 7, 10:41 pm, "Michael Trier" wrote:
> > Hi,
> >
> > On Wed, Jan 7, 2009 at 10:43 PM, Jaimy Azle
> wrote:
> >
> > > Hi,
&g
Hi,
On Wed, Jan 7, 2009 at 10:43 PM, Jaimy Azle wrote:
>
> Hi,
>
> it seems mssql wrapper for pymmsql DBAPI driver in sqlalchemy 0.5.0
> (release) is broken. I haven't check it out with adodbapi, but
> pyodbc confirmed works.
>
Thanks for the test. I will look at this tomorrow.
Michael
--~--~
so we
make sure we get it corrected.
Thanks
--
Michael Trier
http://blog.michaeltrier.com/
http://thisweekindjango.com/
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this gro
y
> mod the db.
>
Yeah the syntax is just:
CREATE VIRTUAL TABLE tablename using FTS3 (...)
When I wrote the unit tests I just did the create sql manually using execute
and then autoloaded from there. I'd like to see the support of the USING
syntax.
--
Mi
ot mapped in any way to Objects. With the ORM
it knows the mapping through the Mapper and handles that.
I guess a larger question is what are you not able to achieve with the ORM
that you can achieve with the SQL Expression Language?
--
Michael Trie
Hi,
On Fri, Jan 2, 2009 at 11:56 PM, Jaimy Azle wrote:
>
> On Saturday, January 3, 2009, 7:07:00 AM, Michael Trier wrote:
>
> > Would it be possible for you to do up a test case demonstrating the
> > problem? If so, we could get to it very quickly.
>
> sure, here i
you to do up a test case demonstrating the problem?
If so, we could get to it very quickly.
--
Michael Trier
http://blog.michaeltrier.com/
http://thisweekindjango.com/
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
Hi,
On Mon, Dec 29, 2008 at 7:19 AM, Ning wrote:
>
> Hi all,
>
> I am pretty new for using sqlalcemy. I am able to connect postgre
> database, but we recently moved data from postgre to SQL sever 2005.
>
> I have tried to connect sql sever 2005 as following:
>
> DB = sqlalchemy.create_engine('''
Record_count is never set.
Michael
On Dec 23, 2008, at 3:27 PM, Philip wrote:
>
> I am having a problem that I am not able to figure out. Maybe someone
> else can see what I am doing wrong. I am building a query using the
> SQL expression language. Then printing the SQL statement and counting
65 matches
Mail list logo
