http://blog.gmane.org/gmane.comp.python.sqlalchemy.user hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15803 If found that, but that is exactly the opposite of what I want, since with webdav first is looked for the files, a user might choose one of them to open/edit en than the blob needs to be loaded.... On Oct 7, 2008, at 4:27 PM, Michael Bayer 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 -~----------~----~----~----~------~----~------~--~--- Martijn Moeling 2008-10-07T14:48:53 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15802 yeah a ticket helps since thats a lot for me to try to parse --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- Michael Bayer 2008-10-07T14:30:31 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15801 another option for blob columns and similar is the "deferred()" property, which will only load that column on the instance when first accessed. this is also in the docs (and probably is in the book too). On Oct 7, 10:03 am, "Martijn Moeling" <mart...< at >xs4us.nu> 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 -~----------~----~----~----~------~----~------~--~--- Michael Bayer 2008-10-07T14:27:55 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15800 Thanx! In Mysql it seems to be func.octet_length(OBJ.columname) though All the documentation is very confusing, I started out with essential SQLAlchemy which is completely outdated by now... The online docs are not very helpful if you don't know what yu're lokking for. The column specification increases my performance a lot Martijn Moeling -----Oorspronkelijk bericht----- Van: sqlalchemy< at >googlegroups.com [mailto:sqlalchemy< at >googlegroups.com] Namens Empty Verzonden: Tuesday, October 07, 2008 3:18 PM Aan: sqlalchemy< at >googlegroups.com Onderwerp: [sqlalchemy] Re: limit the set of returned columns Hi, something You can specify the column names as part of the query, like session.query(User.name, User.phone). find any func.length() Michael --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- Martijn Moeling 2008-10-07T14:03:08 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15799 Hi, You can specify the column names as part of the query, like session.query(User.name, User.phone). func.length() Michael --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- Empty 2008-10-07T13:18:00 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15798 On Oct 6, 4:11 pm, Marco De Felice <m.de...< at >gmail.com> wrote: Oh, that works too. My suggestion would have gotten you something close to the UNION you were looking for. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- Michael Bayer 2008-10-06T20:58:04 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15797 On Tuesday 07 October 2008 00:01:58 Michael Bayer wrote: neither makes a subquery. The child is declared as polymorphic although it has no inheritants (with_polymorphic= ('*', None) ), probably that triggers the aliasing... ahha i recently changed the dbcook's select_table=... into with_polymorphic=... and that might be the "when". but anyway, it may break on another scenario where the child _is_ polymorphic. here the situation: q.join(child) then q.add-entity(child) does: select child.whatever, parent.whatever FROM child, X, parent join child as child_1 on parent.child_id == child_1.id LEFT OUTER JOIN whatever-eagerloading -> decartX q.add-entity(child) then q.join(child) does: select child_1.whatever, parent.whatever FROM X, parent join child as child_1 on parent.child_id == child_1.id LEFT OUTER JOIN whatever-eagerloading -> no decartX, ok so in either case the joined child is aliased, but in the working case there is no another non-aliased in the FROM. i tried the other way, query(child).join(parent-backref), and this does not work either way: q.add-entity(parent) then q.join(parent) does add parent in the FROM, so decartX q.join(parent) then q.add-entity(parent) does not add parent in the FROM, but dies with: no such column: parent.somecolumn there is only parent_1 in the FROM, while the select wants parent.all-the-columns. to me there's something fishy about all this, it does not work (or break) in the same way. do u want it as ticket? not sure how to formulate it. fixing dbcook to not give false with_polymorphics makes all cases work as there no aliasing, but this is a workaround - IMO false polymorphics should be ignored - or errored and this add_entity/join business has to be fixed too. ciao svilen --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- az< at >svilendobrev.com 2008-10-07T07:58:44 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15796 Hi, Yesterday I was searching this group and the SA 5.0 doc to get something working. Somewere I came across an option to specify the columnames to return (and getting a tuple or so) Let me explain: Keep the following in mind: I have a table which stores files defined with Declarative_base: Class file(Base): __tablename__ = "sometable" Id = Column(Integer, primary_key=True) Filename = Column(String(255), index=True) Permissions = Column(Integer) Store = Column(Someblobtype) Now I need to build a query which results in the following information in any form: Filename, permissions and the "size of" Store I think I need func from sqlalchemy.sql but whatever I try I cannot find any sizeof or alike, I know MySQL has something like that. To build a list of files (in realality it is a store for a webdav server and I greatly simplified this example, I need this since listing a "directory" causes Martijn --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- Martijn Moeling 2008-10-07T10:24:48 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15795 .append() On Tue, 2008-10-07 at 11:20 +0200, robert rottermann wrote: Julien Cigar 2008-10-07T09:32:45 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15794 On Sun, Oct 5, 2008 at 8:56 AM, Michael Bayer <zzzeek< at >gmail.com> wrote: Thanks for pointing out the string syntax, I must have miss that. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- Jorge Vargas 2008-10-07T03:49:36 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15793 and may be related note: the add_entity() seems to be able to add whole classes and separate class.attributes, but this isnt mentioned even in the docstrings (what is "entity" anyway?). add_column() also isnt in the docs. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- az< at >svilendobrev.com 2008-10-07T09:19:11 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15792 On Tuesday 07 October 2008 12:20:49 robert rottermann wrote: 1. clist = [] if x: add sommething to clist if y: add sommething to clist clause = and_( *clist) 2. use clause &= whatever but that will need checking for empty initial clause everytime --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- az< at >svilendobrev.com 2008-10-07T09:13:57 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15791 hi there, I would like to add entries to an and_ clause dinamycally like: and_clause = and_() if x: add sommething to and_clause if y: add sommething to and_clause .. how would I do that thanks robert --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- robert rottermann 2008-10-07T09:20:49 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15790 yes, all is about sa 0.5. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- az< at >svilendobrev.com 2008-10-07T08:42:33 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15789 try attaching a fully reproducing test case, since the one I created seems to work. On Oct 6, 6:45 pm, Martijn Moeling <mart...< at >xs4us.nu> 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 -~----------~----~----~----~------~----~------~--~--- Michael Bayer 2008-10-06T23:09:57 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15788 I have been investigating some more and solved the issue by changing the unbound Unicode to UnicodeText I am using SA 0.5r1 and mysql 5.x the unbound Unicode worked with 0.4, I had to upgrade to 0.5 for some other stuff I used and this confused me. Nevertheless the Fields defined in the DavBaseClass are still not Quoted and the ones defined in the Javascript class are... Maybe something in the DeclerativeMeta left from 0.4? the quoting seems to be changed Thanks! On Oct 6, 2008, at 8:18 PM, Michael Bayer 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 -~----------~----~----~----~------~----~------~--~--- Martijn Moeling 2008-10-06T22:45:24 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15787 Yes, I understand, thank you for your answer. I was hoping that I could find something more pythonic to do the table locking - I know that it isn't quite portable and that's why there isn't something more code oriented, but I didn't want to get to issue a LOCK table <> for this. Thanks. Kyle Schaffrick 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 -~----------~----~----~----~------~----~------~--~--- coder_gus 2008-10-06T19:25:11 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15786 you might want to use a SELECT....FOR UPDATE so that the selected rows are locked for the duration of that transaction. On Oct 6, 2:19 pm, coder_gus <coder_...< at >lavabit.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 -~----------~----~----~----~------~----~------~--~--- Michael Bayer 2008-10-06T18:24:00 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15785 Michael Bayer wrote: Thanks, I didn't found a way through (that's perhaps too alchemical for me now) but i'm solving it with a Association class mapped with relations to Parent and Child and has() relation operator (with I didn't knew before) like the following : or_( Association.parents.has(Parent.field=='filtervalue'), Association.childs.has(Child.field=='filtervalue') ) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- Marco De Felice 2008-10-06T20:11:33 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15784 hi i have a query where q = ...q.initial q = q.join( some_link_name ) ...q.otherstuff q = q.add_entity( target_klas_of_the_above_link) ... this used to work ok, but recently it went doing cartesian products because the join made itself an alias. i made it into: q = ...q.initial q = q.add_entity( target_klas_of_the_above_link) q = q.join( some_link_name ) ...q.otherstuff and this seems to work. anything fishy here? ciao svilen --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- az< at >svilendobrev.com 2008-10-06T20:22:19 http://permalink.gmane.org/gmane.comp.python.sqlalchemy.user/15783 the ambiguity there is what if you set "id" to one thing and "employee_id" to another. I think one would win and the other not. I usually do what you have there with a synonym which is designed for this: mapper(Employee, table, properties={'id':synonym('employee_id')}) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~--- Michael Bayer 2008-10-06T19:27:48 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.python.sqlalchemy.user