gmane.comp.python.sqlalchemy.user

timing all queries

qvx — 2008-08-29T17:44:44

Is there a way to record the execution time for all queries issued by sqlalchemy? Thanks, Tvrtko --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy< at >googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---

Re: Extension Mapper

Michael Bayer — 2008-08-29T16:32:31

in r5069, "extension" can be a list of SessionExtension objects. You can also append to session.extensions. On Aug 29, 2008, at 11:36 AM, GustaV wrote: --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy< at >googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---

Re: Extension Mapper

Michael Bayer — 2008-08-29T16:19:50

On Aug 29, 2008, at 11:36 AM, GustaV wrote: since I'm plugging SessionExtension quite a bit I'll look into turning that collection into a list. For now you can try monkeypatching or subclassing TG's extension. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy< at >googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---

Re: Unicode not getting translated to SQL Server?

Mike — 2008-08-29T16:07:16

Hi Rick, On Aug 29, 11:02 am, "Rick Morrison" gmail.com> wrote: That sounds like a plan. I think I used to have that installed, but I may be confusing it with adodb. Thanks for the tip! Mike --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy< at >googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---

Re: Unicode not getting translated to SQL Server?

Rick Morrison — 2008-08-29T16:02:33

That's not going to work with pymssql as your DBAPI. Pymssql is based on Microsoft's DBLib (circa 1991 or so), which does not support unicode and never will: it's been unmaintained for something like 10 years now. You'll either need to convert everything to str() before it hits the DBAPI (which is what I do, I'm still using pymssql), or switch to pyodbc. on windows, it should be easy to switch to pyodbc. Just install pyodbc, SQLAlchemy will look for it first, in preference over pymssql. Rick --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy< at >googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---

Re: Constructors not called?

andrew cooke — 2008-08-29T15:44:35

sorry - i should have checked the faq (i was reading the manual). thanks again for the speedy, helpful replies. andrew On Aug 29, 11:40 am, Michael Bayer zzzcomputing.com> wrote: --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy< at >googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---

Re: Unicode not getting translated to SQL Server?

Mike — 2008-08-29T15:41:15

Hi Mr. Bayer, On Aug 29, 10:10 am, Michael Bayer zzzcomputing.com> wrote: Since I am autoloading, I didn't know I could use the Unicode type to override what was reflected. How do I do that? There's only so much I can give being that I'm talking about accounting data, but here's a sample that should work:



from sqlalchemy import create_engine, Column, Float, Integer
from sqlalchemy import MetaData, String, Table, Unicode
from sqlalchemy.orm import mapper, sessionmaker

class Acct_Prefs(object):
    ''' Table object for tbl_Acct_Prefs '''
    def __init__(self, empID, pref_name, pref_value):
        self.empID = empID
        self.pref_name = pref_name
        self.pref_value = pref_value

    def __repr__(self):
        return "" % (self.empID,
self.pref_name,
                                                    self.pref_value)

class TimeEntries(object):
    ''' Table object for tbl_TimeEntries '''
    def __init__(self, dateworked, empid, reg, ot, ce,



Re: Constructors not called?
Michael Bayer — 2008-08-29T15:40:32
On Aug 29, 2008, at 11:22 AM, andrew cooke wrote:


yes.



an FAQ entry on this is here:  http://www.sqlalchemy.org/trac/wiki/FAQ#whyisntmy__init__calledwhenIloadobjects


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy< at >googlegroups.com
To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: Extension Mapper
GustaV — 2008-08-29T15:36:54
You must be right.
Of course, Turbogears2 already add an extension to the session, and it
looks like it is not a list of extension anyway (or maybe in the
latest trunk?).
What the best way then? To subclass the tg2 extension with mine and
continue to call overloaded method from mine? Anything better?

On Aug 29, 3:57 am, Michael Bayer zzzcomputing.com> wrote:
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy< at >googlegroups.com
To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---


Constructors not called?
andrew cooke — 2008-08-29T15:22:09
Hi,

Not sure if I'm misunderstanding what's happening, whether I have a
bug, or whether this is normal behaviour, but as far as I can tell
mapped objects that are returned from a query do not have their
constructor called.  Is that correct?

In a bit more detail - I have a mapping defined to class Metric, and a
query() returns a Metric instance, with the correct attributes, but if
in the constructor I have something like:

class Metric(object):
    def __init__(self):
        self.constructor_called = True

then the instance returned by query does not have the
"constructor_called" attribute (my actual code is more complex, but
that's the general idea).

Is this normal behaviour?  Is there any way to get the constructor to
be called?  I can work around this if not, but would liek to be sure I
am not ignoring an error of some kind.

I've looked through the documentation, but couldn't find anything
relevant.  Apologies if I've missed the obvious.  This is with version
0.4.7p1

Thanks,
Andrew

--~--~---------~


Re: Unicode not getting translated to SQL Server?
Michael Bayer — 2008-08-29T15:10:11
On Aug 29, 2008, at 10:53 AM, Mike wrote:


without a sample of the code and schema in use, we can't say for sure  
what the issue is.   Are you making usage of the Unicode type at least ?


You might want to enable convert_unicode=True on your Engine, or  
override the specific columns requiring unicode compatibility with the  
Unicode type.  String columns are reflected by default without unicode  
awareness.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy< at >googlegroups.com
To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: Orphans not deleted using cascade parameter
Michael Bayer — 2008-08-29T15:06:30
Unfortunately,  without an illustration of your usage pattern, we  
can't assist with your issue.    Here's the same test case again from  
earlier in the thread.  Can you modify it to look like your failing  
condition ?

rom sqlalchemy import *
from sqlalchemy.orm import *
from sqlalchemy.ext.declarative import declarative_base

engine = create_engine('sqlite://', echo=True)
Base = declarative_base()

class PublicationElement(Base):
     __tablename__ = 'publication'
     publication_id = Column(Integer, primary_key=True)
     name = Column(Unicode(255))


class SectionElement(Base):
     __tablename__ = 'section'
     section_id = Column(Integer, primary_key=True)
     publication_id = Column(Integer,
ForeignKey('publication.publication_id'), nullable=False)
     publication = relation('PublicationElement', cascade="all, delete-
orphan", backref='sections')
     name = Column(Unicode(255))


Base.metadata.create_all(engine)

Session = sessionmaker(bind=engine)

sec1 = SectionElement(name='s1',
publicatio


Unicode not getting translated to SQL Server?
Mike — 2008-08-29T14:53:48
Hi,

I have a weird issue wherein I send a unicode string to SQL Server
2000 using SqlAlchemy in a wxPython program. A little history would
probably help: I created a timesheet program last year using wxPython
and connected to my databases using pymssql. In the hopes of making
this program more flexible and efficient, I decided to switch to
SqlAlchemy.

In my program, I can view 26 separate time periods that show the
user's time worked. To tell what period I am in, I grab the title of
the wx frame. I store this in one of my tables so that the next time
the user opens their timesheet, it will open to the last opened time
period. Anyway, it appears that the wxPython returns the title as a
unicode string.

When I try to commit this string to my database, SqlAlchemy blows up
and gives me this huge traceback:

Traceback (most recent call last):
  File "\\debianis\loginscript$\PythonPackages\Development
\Timesheet_sa
\ts_worksheet_MT.py", line 689, in onClose
    session.flush()
  File "c:\python25\lib\site-packa


Re: wx and SqlAlchemy
Mike — 2008-08-29T14:41:58
Werner,

On Aug 29, 2:21 am, "Werner F. Bruhin" free.fr> wrote:

As I was working on creating my new thread, I realized that it's more
than likely that it's my fault. The value I am setting is derived from
what pay period I am currently viewing in my application. I figure
this out using a hack where I grab my frame's title. The title returns
unicode which is something that SQL Server doesn't like since the
field is set to varchar, not nvarchar. For some reason, this works
using pymssql, but not with SqlAlchemy. I will write a separate post
to that effect.

Mike
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy< at >googlegroups.com
To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: Orphans not deleted using cascade parameter
Alex Mathieu — 2008-08-29T12:59:57
Hi Michael,

I had the same problem for a while. I'm not exactly sure what I did in
order to fix this (have 2 ideas in my mind, need to figure out which
of it it was). As soon as I remember, I'll let you know.

On Aug 29, 1:44 am, Michael Brickenstein mfo.de> wrote:
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy< at >googlegroups.com
To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: Replacement for query.mapper.class_
2008-08-29T11:51:14
see query._mapper_zero(), _only_mapper_zero(), _mapper_zero_or_none() 

On Friday 29 August 2008 11:32:30 Paul Johnston wrote:

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy< at >googlegroups.com
To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---


Replacement for query.mapper.class_
Paul Johnston — 2008-08-29T08:32:30
Hi,

Hope everyone is well, not been around for a while.

I've noticed one of my apps has broken with an SA upgrade. It was
using query.mapper.class_ to determine the class from a query, but
query.mapper no longer exists.

What's the 0.5 way of doing this?

Paul

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy< at >googlegroups.com
To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: Orphans not deleted using cascade parameter
Michael Brickenstein — 2008-08-29T08:49:47
I forgot to mention, that I use 0.5.0beta 3.

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy< at >googlegroups.com
To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---


max(datetime) does not return a datetime. Bug or feature ?
Remi Jolin - SysGroup — 2008-08-29T11:44:00
Hello,

consider the following (Elixir syntax sorry)
class A(Entity):
    creation_date = Field(DateTime)
   ...

A.query().max(A.creation_date) returns a unicode and not a datetime as
max([a.creation_date for a in A.query()]) returns

Is it a bug ? (sqlalchemy version 0.4.6)

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy< at >googlegroups.com
To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: wx and SqlAlchemy
Mike — 2008-08-29T14:32:30
Werner,

On Aug 29, 2:21 am, "Werner F. Bruhin" free.fr> wrote:


I'm not sure I really have a model. I created a separate Python file
to hold my table classes, but in my wx.App, I import those classes and
then map them to autoloaded tables. Then I bind my session object.
This may not be the correct way to integrate SA into wx (or any other
project), but I haven't seen any SA code in anything except for
TurboGears examples.

Mike
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "sqlalchemy" group.
To post to this group, send email to sqlalchemy< at >googlegroups.com
To unsubscribe from this group, send email to sqlalchemy+unsubscribe< at >googlegroups.com
For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---


Re: Orphans not deleted using cascade parameter
Michael Brickenstein — 2008-08-29T05:44:21
Hi!
Hi have a similar problem using
table reflection a la sqlsoup. My DB Backend ist postgresql 8.3.

I have a many to many relation:
orms5=# \d project_programming_language
  Table "public.project_programming_language"
         Column          |  Type   | Modifiers
-------------------------+---------+-----------
 project_id              | integer | not null
 programming_language_id | integer | not null
Indexes:
    "projprogpkconstraint" PRIMARY KEY, btree (project_id,
programming_language_id)
Foreign-key constraints:
    "programmierspracheconstraint" FOREIGN KEY
(programming_language_id) REFERENCES
programming_language(programming_language_id) ON DELETE CASCADE
    "projektconstraint" FOREIGN KEY (project_id) REFERENCES
project(project_id) ON DELETE CASCADE

I got the same message, when delete an object of the table
programming_language:

Dependency rule tried
to blank-out primary key column

As you can see, the foreign key constraints in the db work fine:
I can drop the row via a
DELETE
statement in sql