Ahhh I see. I now call 'setup_all()' after my import call and it seems
to do the trick.
Does sending 'True' as a parameter do anything special that I should be
doing?
Jarrett Chisholm
Prylynx Corporation
IT should be this simple
[email protected]
www.prylynx.com
T: (519) 895-0600
On 27/06/12 03:07 AM, Erik Janssens wrote:
you forgot to call :
setup_all( True )
between definition of the model and the query
On Tue, 2012-06-26 at 11:32 -0700, Jarrett Chisholm wrote:
hey all,
I'm pretty new to elixir (and python). I'm trying to figure out how
to query my new table.
I've got a model that looks like this (it's in it's own folder called
'model', the file is called 'demographic.py')
from elixir import *
metadata.bind = 'mysql://root:THEPASSWORD@localhost/test'
metadata.bind.echo = True
class Demographic(Entity):
name = Field(Unicode(30))
yob = Field(Integer)
description = Field(UnicodeText)
def __repr__(self):
if (self.yob is None):
self.yob = 0000
return '<Demographic "%s" (%d)>' % (self.name, self.yob)
I've got another file that imports the demographic and then tries to
query and get all of the entries:
from model import demographic
...
def get_demographic():
patients = demographic.Demographic.query.all()
print patients
However, I'm getting the following error:
AttributeError: type object 'Demographic' has no attribute 'query'
When I add 'demographic.setup_all()' to the start of the
get_demographic() function, it works. Do I need to call
'demographic.setup_all()' every time I want to query?
Thanks all!
Cheers
--
Jarrett Chisholm
--
You received this message because you are subscribed to the Google
Groups "SQLElixir" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sqlelixir/-/OFRg1oADNzEJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to sqlelixir
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlelixir?hl=en.
--
You received this message because you are subscribed to the Google Groups
"SQLElixir" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlelixir?hl=en.
