I have made this for my project and I do not see why you are using Openlayers
for this.
This has nothing to do with sqlalchemy.
off topic: Ext.form.Panel has no 'protocol' so I think you should extend
FormPanel to include that functionality. Ext.direct is the way to go for stuff
like this.
since 4.x is so much
better (consistant) , faster and more stable, I guess GeoExt is over a year
behind reality. If you use that try if you can wait for GeoExt2
On Aug 18, 2012, at 02:24 , Martijn Moeling mart...@xs4us.nu wrote:
I have made this for my project and I do not see why you are using
:
On Mar 4, 2012, at 2:18 PM, Martijn Moeling wrote:
sqlalchemy.exc.DataError: (DataError) invalid input syntax for integer:
Blablabla
LINE 3: WHERE ide_applicationcontroller.Application = E'Blablabla...
^
'SELECT ide_controller.Id
, 2012, at 11:55 , Martijn Moeling wrote:
Michael,
Thank you for confirming my worries and adding reason to it.
I'm not sure if you remember al my questions in the past but with my project
I'm constantly hitting the impossible, although its fun, it can be
frustrating sometimes.
What
, at 6:52 AM, Martijn Moeling wrote:
I think I've got it working correctly.
in my mixin I now do:
@declared_attr
def id(self):
return ExtColumn('JSid',Unicode(255), default = None)
so the id property is actually stored in the DB Column 'JSid'
Since my introspection
Hi
I have some weird behavior due to a class wit both Id and id columns.
Id is the primary key like on every declarative class.
id is just a data column
class Application()
__tablename….
Id = Column(Integer, primary_key=True)
id
Correction:
SA version is 0.7.4 not 0.7.3
--
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 group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
# go nuts
is all you need.
On Feb 28, 2011, at 10:17 AM, Martijn Moeling wrote:
Hi,
I know this is an OLD threat but I was searching the group to see If I was
not the first one doing this.
I am not sure I understand very well what this threat is all about, but I
Michael,
Interesting stuff, The first part I had almost covered, I did not have the
_constructor part.
It wil be part of something more complex…
Thankx,
Martijn
On Jan 30, 2012, at 17:46 , Michael Bayer wrote:
On Jan 30, 2012, at 9:49 AM, Martijn Moeling wrote:
sorry I have to get
, Michael Bayer wrote:
On Jan 30, 2012, at 9:49 AM, Martijn Moeling wrote:
sorry I have to get back on this. I renamed all Columns in my application
definitions to MyColumn a while back. and everything worked.
Now that I'm starting to use functionality of MyColumn. (The reason I needed
creation.
I thought about specifying tables to see if that forces the creation order.
Anyway it works now
Martijn
On Jan 18, 2012, at 21:14 , Martijn Moeling wrote:
I managed to get PG (9.0) installed and I am in the process over moving over
from MySQL,
I allready have stuff working and am now
Hi,
I am use to setup the collation in MySQL to ci_utf8 (Case Insensitive)
I would like the same behaviour on PostgreSQL.
I use Unicode (Or UnicodeText) as columntype
If I leave the Collation empty it defaults to C which means it looks at
bytecodes so it will NOT be case insensitive.
That is not going to work.
let me explain:
Polymorphic inheritance uses tables and discriminators and some logic somewhere
in the system. (As far as I can tell both SA and databases can do the job, i
have to look into that)
For each object there will be a table, including the base object.
I managed to get PG (9.0) installed and I am in the process over moving over
from MySQL,
I allready have stuff working and am now trying to get the main reason for the
Quick move: Sequence.
I have a object like:
seq=Sequence('serialnumber', metadata=Base.metadata)
Class Object1(Base):
You are welcome,
I get a lot of help from here, taking some load of Michael's back is the least
I can do.
I got the idea from your story that you needed to understand how the mechanics
are.
I'm blessed in having very complex polymorphic self relating setups with lots
of mixins and Object
about that, it has to work the other way
around too
Thanks
Martijn
On Jan 18, 2012, at 22:39 , Conor wrote:
On 01/18/2012 02:14 PM, Martijn Moeling wrote:
I managed to get PG (9.0) installed and I am in the process over moving over
from MySQL,
I allready have stuff working and am now trying
…. more work
Thank you Michael!
Martijn
On Jan 17, 2012, at 02:29 , Michael Bayer wrote:
On Jan 16, 2012, at 5:14 PM, Martijn Moeling wrote:
I am planning on using PG for production but for now I'm stuck on Mysql.
Mysql does not seem to support Sequence..
can't I just do x = Column
Bump.
On Jan 10, 2012, at 12:06 , Martijn Moeling wrote:
Hi,
I am running into something
I am using MySQL but am moving to Postgress so I'm looking for something
compatible with the two.
I have to generate an unique number for each record created into a column
separate from the Id
, 2012, at 6:29 AM, Martijn Moeling wrote:
Now I need to import data from the current production system. This data
already has Serialnumbers generated.
What should I do to make this work? Do I need the sequence created after
the Import and set the Start value to the last imported SerialNumber
Hi,
I am running into something
I am using MySQL but am moving to Postgress so I'm looking for something
compatible with the two.
I have to generate an unique number for each record created into a column
separate from the Id, call it SerialNumber
I have found the Sequence object.
Say I make
I use Float for money at the moment.
I am moving from Mysql to Postgres and have not had any issues but i'm not sure
if Float actually works correctly.
Floats are being used for both broken number values and for money values.
should I change to numeric for Postgres as I do not see that Column
Kinda lame I could not find that I should have known
Thanks!
On Dec 9, 2011, at 16:01 , Michael Bayer wrote:
On Dec 9, 2011, at 5:28 AM, Martijn Moeling wrote:
Hi,
I'm puzzled on how to get this working:
class User(base):
Id = Column (Integer
Hi,
I'm puzzled on how to get this working:
class User(base):
Id = Column (Integer, primarykey=true)
Name= Column(Unicode(100))
Session.query(User).filter(User.Name.like(query+%)).all()
is all fine.
now I want to add an extension
Hi,
Something rendered my sqlalchemy on OSX lion unusable
Traceback (most recent call last):
File /Users/martijn/Documents/workspace/UCO/src/ConvertData.py, line 9, in
module
from sqlalchemy import *
File
Never mind…
I still had library definitions in eclipse set to python 2.6….
Thanks for reading
Martijn
On Oct 6, 2011, at 13:02 , Martijn Moeling wrote:
Hi,
Something rendered my sqlalchemy on OSX lion unusable
Traceback (most recent call last):
File /Users/martijn/Documents
Hi!
As a big fan of SQLA I am looking for a way to implement something which would
in fact be something like phpmysqladmin but based on SQLA and not as big. I
know about migrate but that is not the way to go for me.
Basically I would like to generate:
databases
tables
Python objects
extjs which I
use for my project.
I'll be in touch!
Martijn
On Sep 6, 2011, at 16:09 , Michael Bayer wrote:
On Sep 6, 2011, at 9:38 AM, Martijn Moeling wrote:
Hi!
As a big fan of SQLA I am looking for a way to implement something which
would in fact be something like phpmysqladmin
Thank you for all the effort you put in.
SQLAlchemy has been a proven tool for me and as it seems for many others.
On Aug 1, 2011, at 02:17 , Michael Bayer wrote:
SQLAlchemy version 0.7.2 is now available.
A lot has been going on leading up to this release, and there was actually a
Hi,
I know this is an OLD threat but I was searching the group to see If I was
not the first one doing this.
I am not sure I understand very well what this threat is all about, but I want
to extend the Column class for a different reason.
I want to add extra functionality to the Column class
is all you need.
On Feb 28, 2011, at 10:17 AM, Martijn Moeling wrote:
Hi,
I know this is an OLD threat but I was searching the group to see If I was
not the first one doing this.
I am not sure I understand very well what this threat is all about, but I
want to extend the Column
Hi,
I would like to store all time values in my database as UTC values
(automatically). I already have the proper conversion routines in my own CALDAV
server but I have many more places where I would like to store dates.
what would be a logical place to hook in those conversion routines so
Cool that is what I thought,
On Feb 19, 2011, at 17:32 , Michael Bayer wrote:
On Feb 19, 2011, at 6:40 AM, Martijn Moeling wrote:
Hi,
I would like to store all time values in my database as UTC values
(automatically). I already have the proper conversion routines in my own
CALDAV
Hi,
I am running into something weird results I do not really understand. SA 0.6.6
I have a Polymorhic table setup, where I need to get the columnlist for
outputting the ExtJs 4 Model.
Basically it should output
( 'User' : { fields : [
{'field1' : 'int'},
a BIG THANK YOU for all your help
Martijn
On Feb 14, 2011, at 14:04 , Martijn Moeling wrote:
Eric (and Michael),
Thank you for your comments, I agree with you totally.
I am not much of a database guy and never have been.
During my education I did not pay much attention to those
lessons
curve but once three or four techniques are mastered they come
pretty easily.
On Feb 13, 2011, at 4:35 PM, Martijn Moeling wrote:
Michael,
I looked at the code and I can not say more than that its very interesting,
I have to see how it works and more importantly how It fits into my objects
not seem to be relevant.
Martijn
On Feb 14, 2011, at 14:04 , Martijn Moeling wrote:
Eric (and Michael),
Thank you for your comments, I agree with you totally.
I am not much of a database guy and never have been.
During my education I did not pay much attention to those
lessons either
#3, discriminator ext2 - how can more than one Extra row be
referenced? Why is extras assumed to be one-to-many when it can only be
many-to-one ?
On Feb 12, 2011, at 9:57 AM, Martijn Moeling wrote:
This whole thing is driving me crazy, What I want:
class Extra(Base
.
Your solution is definitively one I could not have put together myself.
Although I have tried. SQLAlchemy is so powerful that it is hard to find the
right options for the job.
Thank you again!
Martijn
On Feb 13, 2011, at 21:19 , Michael Bayer wrote:
On Feb 13, 2011, at 6:14 AM, Martijn Moeling
really need the @declared_attr way of doing stuff and that is not related to
this question but might influence this question so I left it in..
Martijn
On Feb 10, 2011, at 18:13 , Michael Bayer wrote:
On Feb 10, 2011, at 4:20 AM, Martijn Moeling wrote:
Another small thing:
I took
with or without a
discriminator column. A single class can't be mapped in both ways.If
there's no discriminator, there's just one class that can be used for
returned rows.
Martijn
On Feb 12, 2011, at 15:57 , Martijn Moeling wrote:
This whole thing is driving me crazy, What I want
Another small thing:
I took a look at:
ForeignKeyConstraint(['invoice_id', 'ref_num'], ['invoice.invoice_id',
'invoice.ref_num'])
Now for Polymorphic tables:
in baseclass:
baseclass.discriminator happens to be the __tablename__ of the polymorphic
Martijn
On Feb 7, 2011, at 5:55 PM, Michael Bayer wrote:
On Feb 7, 2011, at 11:42 AM, Martijn Moeling wrote:
I think, I might be helped with the create_instance event
Assuming you're talking about when the ORM establishes an instance from a
newly fetched row, you can use
to their needs. I find that the deeper I dive into SA, the
less examples are available, the harder it is to test functionality and
sometimes documentation gets more sparse.
Thank you again...
Martijn
On Feb 8, 2011, at 4:21 PM, Michael Bayer wrote:
On Feb 8, 2011, at 6:05 AM, Martijn
Hi,
I am having a small issue with multiple python modules and declarative...
I might miss something but
Consider:
a.py:
8---
Base = declarative_base()
class A(Base):
...
8---
b.py
Base = declarative_base()
class B(Base):
without a Base at all so there is no Issue
Am I right? in understanding your comments on my first mail in this topic?
Martijn
On Feb 8, 2011, at 7:46 PM, Michael Bayer wrote:
On Feb 8, 2011, at 1:19 PM, Martijn Moeling wrote:
Hi,
I am having a small issue with multiple python
, Martijn Moeling wrote:
Michael,
Do you ever sleep?
I am not sure I get your point. How do I set up a common Base.
I could do Base= Declarative_base()
from a import A (or * not sure how this differs in this case)
from b import B (or *)
If I do not declare Base in module a I get
Clear!
On Feb 8, 2011, at 10:21 PM, Michael Bayer wrote:
On Feb 8, 2011, at 3:57 PM, Martijn Moeling wrote:
Clear, if all packages are in the same project that is..
and what if in a.py I want to inherit some class mapped with b.py
mixin does not allways work as a solution
Hi,
It is me again with an interesting thing, I've searched the net, this group
etc. Not a lot of people seem interested in append_result, I AM!!
I am looking for a way to implement the following:
I have many tables, a lot with polymorphic inheritance and self and cross
references.
In order
the molecule stuff makes it even more confusing..
Will take me some time though
Martijn
On Feb 7, 2011, at 5:18 PM, Michael Bayer wrote:
On Feb 7, 2011, at 10:55 AM, Martijn Moeling wrote:
Hi,
It is me again with an interesting thing, I've searched the net, this group
etc. Not a lot
.
postal_as_concrete.pypostal_as_joined_semi_decl.py
On Jan 31, 2011, at 10:58 AM, Michael Bayer wrote:
On Jan 31, 2011, at 4:27 AM, Martijn Moeling wrote:
Hi,
First I need to let you know I do everything declarative..
To make things understandable I have chosen to use objects
Hi,
First I need to let you know I do everything declarative..
To make things understandable I have chosen to use objects a bit more close to
real-life.
There is a base object Person with a one-to-many relationship to the table
addresses:
class Person(Base):
__tablename__ =
this right from the beginning helps me a lot.
The definition of Affiliation, Person and Company can be found below.
Martijn
On Jan 4, 2011, at 9:55 AM, Martijn Moeling wrote:
Hi
I have done the following:
class Affiliation(Base):
__tablename__ = affiliations
Id
Michael,
Thank you,
reading trough your example (and running it)
made me understand a bit more how SQLA works.
I managed to get it all working,
Since I was on my way to something a bit slightly more complex ...one last
Question
What if I would like to:
Class RelationType(Base):
Simon (and the others),
thank you! the someClass.__table__works...
Kind regards,
Martijn
On Oct 27, 2010, at 5:02 PM, King Simon-NFHD78 wrote:
-Original Message-
From: sqlalchemy@googlegroups.com [mailto:sqlalch...@googlegroups.com]
On Behalf Of Martijn Moeling
Sent: 27
I did this in one of my previous projects.
what I did was to make a python module, with the right SQLAlchemy includes and
all the mapper objects. what I did not do is connecting to the database (it
makes the class module database independent)
What it does is it implements the iCal standard, it
Hi,
I have a huge definition module where I create Python objects and use
declarative.
Since not all databases (Multiple for different customers) need all tables I do
not like to use create_all
is there any way to create just the tables I really need (according to some
config list or
Hi,
I have a weird problem.
(Mysql)
When I do a create_all(), i get the error :
File
/Library/Python/2.6/site-packages/SQLAlchemy-0.5.8-py2.6.egg/sqlalchemy/engine/base.py,
line 931, in _handle_dbapi_exception
raise exc.DBAPIError.instance(statement, parameters, e,
Hi All,
I am having a very bad day (or two to be honest), spending time
reading error messages.
I am sorry to say but the SQLALCHEMY documentation is not very helpful
when using declarative_base when it is about relations..
It should be very easy for you database guy's (which I'm not,
Simon-NFHD78 wrote:
-Original Message-
From: sqlalchemy@googlegroups.com
[mailto:sqlalch...@googlegroups.com] On Behalf Of Martijn Moeling
Sent: 15 October 2009 14:42
To: sqlalchemy@googlegroups.com
Subject: [sqlalchemy] Declerative Relation trouble
Hi All,
I am having a very bad
I downgraded SQLA to version 0.5.5, no luck, (Simon) what version of
python are you using?
On Oct 15, 2009, at 4:45 PM, Martijn Moeling wrote:
Hi Simon/all,
When I run your example i get:
Traceback (most recent call last):
File /var/www/PyWebOs/caltst.py, line 41, in module
cal
] On Behalf Of Martijn Moeling
Sent: 15 October 2009 15:55
To: sqlalchemy@googlegroups.com
Subject: [sqlalchemy] Re: Declerative Relation trouble
I downgraded SQLA to version 0.5.5, no luck, (Simon) what version of
python are you using?
2.5.1 on Linux
Simon
Mod_python has nothing to do with this project, so I run it
from idle within X
On Oct 15, 2009, at 5:23 PM, King Simon-NFHD78 wrote:
-Original Message-
From: sqlalchemy@googlegroups.com
[mailto:sqlalch...@googlegroups.com] On Behalf Of Martijn Moeling
Sent: 15 October 2009 16:21
)
I'll keep you posted!
Martijn
On Oct 15, 2009, at 5:33 PM, King Simon-NFHD78 wrote:
-Original Message-
From: sqlalchemy@googlegroups.com
[mailto:sqlalch...@googlegroups.com] On Behalf Of Martijn Moeling
Sent: 15 October 2009 16:27
To: sqlalchemy@googlegroups.com
Subject: [sqlalchemy
So To complete Simons suggestion about idle,
Do not use the -n switch on idle when playing with SQLAlchemy.
On Oct 15, 2009, at 6:55 PM, Martijn Moeling wrote:
(in the mean time I drove home. dinner soon)
Indeed, running it from command line changes things,
Strange
Hi,
I have a python module where I am implementing several classes.
When I do a metadata.create_all(engine)
every time Mysql trows an exception (1064, PROGRAMMING ERROR), but on
a different table, I think SQLAlchemy is behaving different every time
I run the program.
ie (one of the
Thanks Guy's!
Kinda stupid, but that happens with the use of examples.
Martijn
On Oct 14, 2009, at 3:34 PM, limodou wrote:
On Wed, Oct 14, 2009 at 9:03 PM, Martijn Moeling mart...@xs4us.nu
wrote:
Hi,
I have a python module where I am implementing several classes.
When I do
Hi
I needed a Unicode(1) Column in one of my tables.
It was translated into a char(1) column in MySQL.
When querying the table, I get a: AttributeError: 'Set' object has no
attribute 'decode'
Which disappears if I make the column a Unicode(2), so there might be a
small bug in the
I had similar problems, part of it turned out to be the encoding send
from the browser.
on forms you can set the encoding (in the formtag, check
http://www.w3schools.com
if the page is other than UTF-8 (check your browser view-
encoding menu).
I changed everything to utf-8 by setting
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
specification increases my performance a lot
Martijn Moeling
-Oorspronkelijk bericht-
Van: sqlalchemy@googlegroups.com [mailto:[EMAIL PROTECTED]
Namens Empty
Verzonden: Tuesday, October 07, 2008 3:18 PM
Aan: sqlalchemy@googlegroups.com
Onderwerp: [sqlalchemy] Re: limit the set of returned 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 [EMAIL PROTECTED] wrote:
Thanx!
In Mysql it seems to be func.octet_length(OBJ.columname
I accedently posted the message premature, an was in the process of completing
it. The answer seems suitable.. Thanks!!
-Oorspronkelijk bericht-
Van: sqlalchemy@googlegroups.com [mailto:[EMAIL PROTECTED] Namens Michael Bayer
Verzonden: Monday, October 06, 2008 5:19 PM
Aan: sqlalchemy
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
73 matches
Mail list logo