On 10/29/07, mmstud [EMAIL PROTECTED] wrote:
Thats handy. Where could i get the utils module you're using for Enum
datatype?
The Enum datatype is from the ASPN cookbook, with type bindings for
SA. Here's part of my utils module.
cheers,
Arnar
# -*- encoding: UTF-8 -*-
import
On 10/29/07, mmstud [EMAIL PROTECTED] wrote:
On 29 loka, 09:08, [EMAIL PROTECTED] wrote:
I dont need history tracking, just revert documents to older ones.
that is history, just not timed history.
Most optimal would it be, if i can make rows with updated fields only,
not to copy whole
Hi there,
On 10/28/07, mmstud [EMAIL PROTECTED] wrote:
Next design problem for me is version table. I have Document model
with DocumentVersion model, but i dont know how to:
- get the latest version of document
- set creator and updator, automatic behavior for this
- update version number
On 10/28/07, mmstud [EMAIL PROTECTED] wrote:
Thanks there were some good ideas to try. Btw. what does the first def
constructor(fun)?
It is a decorator I use on mapped classes constructors. It allows me
to give keyword arguments to constructors with initial values for any
field in class.c
On 9/27/07, jawarumnur [EMAIL PROTECTED] wrote:
thanks, I'll try that, if the relation option foreign_keys didn't do
it.
I think you don't need foreign_keys. The docs for foreign_keys states
that it should be used in conjuction with primaryjoin only if SA can
not guess the FK from the join
On 8/13/07, Christophe de VIENNE [EMAIL PROTECTED] wrote:
I have checked out the trunk and am trying to run the unittests under
linux using pyodbc.
So far, the connection to the database is working, although I had to
name the freetds odbc driver {SQL Server}, including the {}, so the
driver
On 8/5/07, Alexandre CONRAD [EMAIL PROTECTED] wrote:
As Michael pointed out, the ElementTree example stores the XML data
en-masse, so if you don't need those kind of queries, you might see
better performance and a simpler way of life if you just serialize the
ElementTree instances to XML
On 8/3/07, Alexandre CONRAD [EMAIL PROTECTED] wrote:
The nested looks more efficient. But, things are still a little confused
in my head. I need to well put down the pros and cons of each technic
for my needs. I was using XML and I'm now switching to a flat database
with technics I've never
On 8/3/07, King Simon-NFHD78 [EMAIL PROTECTED] wrote:
I think of adjacency lists and nested sets as more about hierarchies of
a single type of object (imagine trying to represent a family tree with
a row for each Person). I don't really think they're relevant in this
case.
If I understand
On 6/25/07, voltron [EMAIL PROTECTED] wrote:
Thank you very much for your feedback guys! I was very worried the
whole day. I did some research and found this:
http://www.evolt.org/article/Four_ways_to_work_with_hierarchical_data/17/4047/index.html
I have to say I've seen better writeups on
On 6/4/07, nathan harmston [EMAIL PROTECTED] wrote:
What kind of overhead is associated with using the autoload flag?
What kind of overhead would be associated with this over a network? (with a
remote database). Is there a way to dump the structure of a database to a
file and import this as
Hi all,
On 5/22/07, Julien Cigar [EMAIL PROTECTED] wrote:
yes of course [1,2,3] is different than [3,2,1] (hopefully), I was
talking for InstrumentedList, not tuple or list or ...
IMO InstrumentedList should definately have the same semantics as a
list - what you're talking about is to make
Hi there,
You can include a command in the dburi that is executed upon
connection start. I use it all the time like this:
mysql://user:[EMAIL
PROTECTED]:3306/dbname?init_command=set%20character%20set%20utf8
Arnar
On 5/14/07, Noam [EMAIL PROTECTED] wrote:
Hello,
I'm trying to use
Hi all,
Say I have this simple model:
DayTimesheet
date: a Date
entries: a list of TimeEntry
TimeEntry:
day: a DayTimesheet
in: a time (HH:MM)
out: a time (HH:MM)
DayTimesheet is the parent of TimeEntry in a one-to-many relationship.
What would be the best way of ensuring the
Hi all,
I have this working to my liking and as promised, here's the code:
It's not complete since I'm omitting some of my model and just showing
you the relevant parts.
This is my model:
verkefni = Table(verkefni, metadata,
Column(verkefni, Integer, primary_key=True),
Column(skrad,
Hi there,
I haven't read the reast of the thread, but I asked a question here of
how to represent a graph. What you need is essentialli an undirected
graph.
On 4/3/07, tml [EMAIL PROTECTED] wrote:
So, if article 1 is related to article 2.. then there should be two
rows in the
On 4/4/07, Arnar Birgisson [EMAIL PROTECTED] wrote:
I often use a different technique. Instead of keeping two lines in the
association table, I only keep one and make a rule that relateditem1
= relateditem2.
Here is the thread on graphs where Mike posted a working solution:
http
Hi Mike,
I've started looking into this and this is exactly what I need. I can
pretty much eat the stuff directly from added_items() and
deleted_items() and insert that into my history-log table.
One question though:
On 3/28/07, Michael Bayer [EMAIL PROTECTED] wrote:
dont have an example
On 4/4/07, Michael Bayer [EMAIL PROTECTED] wrote:
its not going to be able to modify the current flush() plan thats in
progress, so youd either have to insert yourself, dispatch to
class_mapper(HistoryLoggedItem).save_obj() yourself, or process the
Session externally to the flush(), create
Gaetan and Ivo:
Sure thing. I'll implement this one way or another monday or tuesday,
will post what I end up with.
Arnar
On 4/1/07, imbunche [EMAIL PROTECTED] wrote:
I'd also apreciate if you post your code later.
thx in advance.
IvO
On Mar 28, 6:07 pm, Arnar Birgisson [EMAIL PROTECTED
I can't reach www.sqlalchemy.org, anyone else having problems?
Arnar
--~--~-~--~~~---~--~~
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
On 3/29/07, Michael Bayer [EMAIL PROTECTED] wrote:
rebooting hopefully it comes up
Works for me, thanks.
Arnar
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send
Hi Dave,
Thank you very much, seems I should be able to do what I want. I'll
take a stab at it tomorrow and report.
On 3/28/07, Michael Bayer [EMAIL PROTECTED] wrote:
note that by history, we mean things that have occured since the
instance was loaded from the database into the current
I like it all!
Arnar
On 3/10/07, Michael Bayer [EMAIL PROTECTED] wrote:
Well initial response to this post has been overwhelmingly low, but
thats fine with me. After trying to tackle this today, I realized
that I actually didnt want to add a brand new query object and go
through a
Hi Paul,
Yes, I had found this about the datatype size by way of breaking into
the relevant code and setting the parameter length manually. This made
the query work but just unveiled other problems.
I too made no further efforts to get it work as pymssql works fine for
my purposes - although
the table
with varchar or char datatype.
On 2/14/07, Arnar Birgisson [EMAIL PROTECTED] wrote:
Hi there,
I have the following query in SA. It works using pymssql on Linux.
criteria = and_(
tables.salestable.c.dataset==self.xaldataset,
tables.salestable.c.dataset
Hi Rick,
On 2/8/07, Rick Morrison [EMAIL PROTECTED] wrote:
Pymssql, or adodbapi? Client-side cursors, or Server-side?
Pymssql and client side cursors (I guess, I'm just issuing plain
select statements, no stored procs or such).
We use pymssql here over FreeTDS with SQL Server 2005 here
into a list and the
iterate that instead of partially iterating the cursor.
On 2/8/07, Arnar Birgisson [EMAIL PROTECTED] wrote:
Hi Rick,
On 2/8/07, Rick Morrison [EMAIL PROTECTED] wrote:
Pymssql, or adodbapi? Client-side cursors, or Server-side?
Pymssql and client side cursors (I
On 1/5/07, Michael Bayer [EMAIL PROTECTED] wrote:
yeah see, thats exactly the kind of thing i dont want SA's ORM to get
into, because its really thorny..updating the relationship on all child
objects. at the very least, it requires loading them all in, cascading
the change, etc. it gets pretty
On 1/4/07, Michael Bayer [EMAIL PROTECTED] wrote:
Arnar Birgisson wrote:
On 1/3/07, Michael Bayer [EMAIL PROTECTED] wrote:
yeah that would be why. SA's ORM has no ability to update primary key
columns from their original valueyoull have to update it yourself,
or copy the object
Hi folks,
I'm having a problem, illustrated here:
http://paste.turbogears.org/paste/756
This is with Python 2.4 and SA 0.3.3.
What happens is that when I have two parent objects (Jobs in my case)
and one child object (a Page) - and move the child between parents,
the session.flush() does not
On 12/11/06, David Geller [EMAIL PROTECTED] wrote:
2. From what I know about reportlab, there *is* an opensource pdf
toolkit available under a bsd license (although I have never used it)
There is, and it works well, although I haven't used it extensively.
It has advanced features for text
On 11/1/06, Michael Bayer [EMAIL PROTECTED] wrote:
im beginning to regret having viewonly and non_primary as options,since i cant think of anything they do that cant be better accomplishedjust by using Query.select(), or manual queries in conjunction with
query.instances().I think im going to try
Hi there,There was a question on IRC yesterday on how to map a graph (as in nodes and edges) with SA. I didn't have much time to dwell on this but this was a start: http://paste.ufsoft.org/90
I was curious if someone has done this successfully? The problem I have with the above is that the
34 matches
Mail list logo