librelist archives

Reference table with sqlalchemy using create_all

Reference table with sqlalchemy using create_all by Italo Maia
- Re: [flask] Reference table with sqlalchemy using create_all by Alex K
  - Re: [flask] Reference table with sqlalchemy using create_all by Italo Maia
    - Re: [flask] Reference table with sqlalchemy using create_all by Italo Maia
      - Re: [flask] Reference table with sqlalchemy using create_all by Jesse Dubay
        
        Re: [flask] Reference table with sqlalchemy using create_all by Italo Maia

Reference table with sqlalchemy using create_all

From:: Italo Maia
Date:: 2011-09-16 @ 15:55

Hi folks. I have a table that references another with foreignkey but when
using create_all a sqlalchemy.exc.NoReferencedTableError is thrown. Any
suggestions on how to proceed?? Using flask-sqlalchemy here.

-- 
"A arrogância é a arma dos fracos."

===========================
Italo Moreira Campelo Maia
Bacharel em Ciência da Computação - UECE
Desenvolvedor WEB e Desktop (Java, Python, Lua)
Coordenador do Pug-CE
-----------------------------------------------------
http://www.italomaia.com/
http://twitter.com/italomaia/
http://eusouolobomau.blogspot.com/
-----------------------------------------------------
Turtle Linux  9.10 - http://tiny.cc/blogturtle910
Turtle Linux 10.10 - http://bit.ly/cEw4ET
===========================

Re: [flask] Reference table with sqlalchemy using create_all

From:: Alex K
Date:: 2011-09-16 @ 15:58

Italo, can you show sqlalchemy models?


On Fri, Sep 16, 2011 at 7:55 PM, Italo Maia <italo.maia@gmail.com> wrote:

> Hi folks. I have a table that references another with foreignkey but when
> using create_all a sqlalchemy.exc.NoReferencedTableError is thrown. Any
> suggestions on how to proceed?? Using flask-sqlalchemy here.
>
> --
> "A arrogância é a arma dos fracos."
>
> ===========================
> Italo Moreira Campelo Maia
> Bacharel em Ciência da Computação - UECE
> Desenvolvedor WEB e Desktop (Java, Python, Lua)
> Coordenador do Pug-CE
> -----------------------------------------------------
> http://www.italomaia.com/
> http://twitter.com/italomaia/
> http://eusouolobomau.blogspot.com/
> -----------------------------------------------------
> Turtle Linux  9.10 - http://tiny.cc/blogturtle910
> Turtle Linux 10.10 - http://bit.ly/cEw4ET
> ===========================
>

Re: [flask] Reference table with sqlalchemy using create_all

From:: Italo Maia
Date:: 2011-09-16 @ 16:03

There you go: http://dpaste.org/suCsH/

2011/9/16 Alex K <lestatcheb@googlemail.com>

> Italo, can you show sqlalchemy models?
>
>
> On Fri, Sep 16, 2011 at 7:55 PM, Italo Maia <italo.maia@gmail.com> wrote:
>
>> Hi folks. I have a table that references another with foreignkey but when
>> using create_all a sqlalchemy.exc.NoReferencedTableError is thrown. Any
>> suggestions on how to proceed?? Using flask-sqlalchemy here.
>>
>> --
>> "A arrogância é a arma dos fracos."
>>
>> ===========================
>> Italo Moreira Campelo Maia
>> Bacharel em Ciência da Computação - UECE
>> Desenvolvedor WEB e Desktop (Java, Python, Lua)
>> Coordenador do Pug-CE
>> -----------------------------------------------------
>> http://www.italomaia.com/
>> http://twitter.com/italomaia/
>> http://eusouolobomau.blogspot.com/
>> -----------------------------------------------------
>> Turtle Linux  9.10 - http://tiny.cc/blogturtle910
>> Turtle Linux 10.10 - http://bit.ly/cEw4ET
>> ===========================
>>
>
>


-- 
"A arrogância é a arma dos fracos."

===========================
Italo Moreira Campelo Maia
Bacharel em Ciência da Computação - UECE
Desenvolvedor WEB e Desktop (Java, Python, Lua)
Coordenador do Pug-CE
-----------------------------------------------------
http://www.italomaia.com/
http://twitter.com/italomaia/
http://eusouolobomau.blogspot.com/
-----------------------------------------------------
Turtle Linux  9.10 - http://tiny.cc/blogturtle910
Turtle Linux 10.10 - http://bit.ly/cEw4ET
===========================

Re: [flask] Reference table with sqlalchemy using create_all

From:: Italo Maia
Date:: 2011-09-16 @ 16:35

Weird, i changed:
user_id = db.Column(db.Integer, db.ForeignKey("users.id"), unique=True)
to
user_id = db.Column(db.Integer, db.ForeignKey("users.*email*"), unique=True)

And it worked! This can't be right...

2011/9/16 Italo Maia <italo.maia@gmail.com>

> There you go: http://dpaste.org/suCsH/
>
>
> 2011/9/16 Alex K <lestatcheb@googlemail.com>
>
>> Italo, can you show sqlalchemy models?
>>
>>
>> On Fri, Sep 16, 2011 at 7:55 PM, Italo Maia <italo.maia@gmail.com> wrote:
>>
>>> Hi folks. I have a table that references another with foreignkey but when
>>> using create_all a sqlalchemy.exc.NoReferencedTableError is thrown. Any
>>> suggestions on how to proceed?? Using flask-sqlalchemy here.
>>>
>>> --
>>> "A arrogância é a arma dos fracos."
>>>
>>> ===========================
>>> Italo Moreira Campelo Maia
>>> Bacharel em Ciência da Computação - UECE
>>> Desenvolvedor WEB e Desktop (Java, Python, Lua)
>>> Coordenador do Pug-CE
>>> -----------------------------------------------------
>>> http://www.italomaia.com/
>>> http://twitter.com/italomaia/
>>> http://eusouolobomau.blogspot.com/
>>> -----------------------------------------------------
>>> Turtle Linux  9.10 - http://tiny.cc/blogturtle910
>>> Turtle Linux 10.10 - http://bit.ly/cEw4ET
>>> ===========================
>>>
>>
>>
>
>
> --
> "A arrogância é a arma dos fracos."
>
> ===========================
> Italo Moreira Campelo Maia
> Bacharel em Ciência da Computação - UECE
> Desenvolvedor WEB e Desktop (Java, Python, Lua)
> Coordenador do Pug-CE
> -----------------------------------------------------
> http://www.italomaia.com/
> http://twitter.com/italomaia/
> http://eusouolobomau.blogspot.com/
> -----------------------------------------------------
> Turtle Linux  9.10 - http://tiny.cc/blogturtle910
> Turtle Linux 10.10 - http://bit.ly/cEw4ET
> ===========================
>



-- 
"A arrogância é a arma dos fracos."

===========================
Italo Moreira Campelo Maia
Bacharel em Ciência da Computação - UECE
Desenvolvedor WEB e Desktop (Java, Python, Lua)
Coordenador do Pug-CE
-----------------------------------------------------
http://www.italomaia.com/
http://twitter.com/italomaia/
http://eusouolobomau.blogspot.com/
-----------------------------------------------------
Turtle Linux  9.10 - http://tiny.cc/blogturtle910
Turtle Linux 10.10 - http://bit.ly/cEw4ET
===========================

Re: [flask] Reference table with sqlalchemy using create_all

From:: Jesse Dubay
Date:: 2011-09-16 @ 17:37

> class User(UserMixin):

There's your problem :) User needs to inherit from db.Model as well.

Jesse

On Fri, Sep 16, 2011 at 9:35 AM, Italo Maia <italo.maia@gmail.com> wrote:
> Weird, i changed:
> user_id = db.Column(db.Integer, db.ForeignKey("users.id"), unique=True)
> to
> user_id = db.Column(db.Integer, db.ForeignKey("users.email"), unique=True)
> And it worked! This can't be right...
>
> 2011/9/16 Italo Maia <italo.maia@gmail.com>
>>
>> There you go: http://dpaste.org/suCsH/
>>
>> 2011/9/16 Alex K <lestatcheb@googlemail.com>
>>>
>>> Italo, can you show sqlalchemy models?
>>>
>>> On Fri, Sep 16, 2011 at 7:55 PM, Italo Maia <italo.maia@gmail.com> wrote:
>>>>
>>>> Hi folks. I have a table that references another with foreignkey but
>>>> when using create_all a sqlalchemy.exc.NoReferencedTableError is thrown. Any
>>>> suggestions on how to proceed?? Using flask-sqlalchemy here.
>>>>
>>>> --
>>>> "A arrogância é a arma dos fracos."
>>>>
>>>> ===========================
>>>> Italo Moreira Campelo Maia
>>>> Bacharel em Ciência da Computação - UECE
>>>> Desenvolvedor WEB e Desktop (Java, Python, Lua)
>>>> Coordenador do Pug-CE
>>>> -----------------------------------------------------
>>>> http://www.italomaia.com/
>>>> http://twitter.com/italomaia/
>>>> http://eusouolobomau.blogspot.com/
>>>> -----------------------------------------------------
>>>> Turtle Linux  9.10 - http://tiny.cc/blogturtle910
>>>> Turtle Linux 10.10 - http://bit.ly/cEw4ET
>>>> ===========================
>>>
>>
>>
>>
>> --
>> "A arrogância é a arma dos fracos."
>>
>> ===========================
>> Italo Moreira Campelo Maia
>> Bacharel em Ciência da Computação - UECE
>> Desenvolvedor WEB e Desktop (Java, Python, Lua)
>> Coordenador do Pug-CE
>> -----------------------------------------------------
>> http://www.italomaia.com/
>> http://twitter.com/italomaia/
>> http://eusouolobomau.blogspot.com/
>> -----------------------------------------------------
>> Turtle Linux  9.10 - http://tiny.cc/blogturtle910
>> Turtle Linux 10.10 - http://bit.ly/cEw4ET
>> ===========================
>
>
>
> --
> "A arrogância é a arma dos fracos."
>
> ===========================
> Italo Moreira Campelo Maia
> Bacharel em Ciência da Computação - UECE
> Desenvolvedor WEB e Desktop (Java, Python, Lua)
> Coordenador do Pug-CE
> -----------------------------------------------------
> http://www.italomaia.com/
> http://twitter.com/italomaia/
> http://eusouolobomau.blogspot.com/
> -----------------------------------------------------
> Turtle Linux  9.10 - http://tiny.cc/blogturtle910
> Turtle Linux 10.10 - http://bit.ly/cEw4ET
> ===========================
>

Re: [flask] Reference table with sqlalchemy using create_all

From:: Italo Maia
Date:: 2011-09-16 @ 17:43

It works! My savior! \ö/!

2011/9/16 Jesse Dubay <jesse@thefortytwo.net>

> > class User(UserMixin):
>
> There's your problem :) User needs to inherit from db.Model as well.
>
> Jesse
>
> On Fri, Sep 16, 2011 at 9:35 AM, Italo Maia <italo.maia@gmail.com> wrote:
> > Weird, i changed:
> > user_id = db.Column(db.Integer, db.ForeignKey("users.id"), unique=True)
> > to
> > user_id = db.Column(db.Integer, db.ForeignKey("users.email"),
> unique=True)
> > And it worked! This can't be right...
> >
> > 2011/9/16 Italo Maia <italo.maia@gmail.com>
> >>
> >> There you go: http://dpaste.org/suCsH/
> >>
> >> 2011/9/16 Alex K <lestatcheb@googlemail.com>
> >>>
> >>> Italo, can you show sqlalchemy models?
> >>>
> >>> On Fri, Sep 16, 2011 at 7:55 PM, Italo Maia <italo.maia@gmail.com>
> wrote:
> >>>>
> >>>> Hi folks. I have a table that references another with foreignkey but
> >>>> when using create_all a sqlalchemy.exc.NoReferencedTableError is
> thrown. Any
> >>>> suggestions on how to proceed?? Using flask-sqlalchemy here.
> >>>>
> >>>> --
> >>>> "A arrogância é a arma dos fracos."
> >>>>
> >>>> ===========================
> >>>> Italo Moreira Campelo Maia
> >>>> Bacharel em Ciência da Computação - UECE
> >>>> Desenvolvedor WEB e Desktop (Java, Python, Lua)
> >>>> Coordenador do Pug-CE
> >>>> -----------------------------------------------------
> >>>> http://www.italomaia.com/
> >>>> http://twitter.com/italomaia/
> >>>> http://eusouolobomau.blogspot.com/
> >>>> -----------------------------------------------------
> >>>> Turtle Linux  9.10 - http://tiny.cc/blogturtle910
> >>>> Turtle Linux 10.10 - http://bit.ly/cEw4ET
> >>>> ===========================
> >>>
> >>
> >>
> >>
> >> --
> >> "A arrogância é a arma dos fracos."
> >>
> >> ===========================
> >> Italo Moreira Campelo Maia
> >> Bacharel em Ciência da Computação - UECE
> >> Desenvolvedor WEB e Desktop (Java, Python, Lua)
> >> Coordenador do Pug-CE
> >> -----------------------------------------------------
> >> http://www.italomaia.com/
> >> http://twitter.com/italomaia/
> >> http://eusouolobomau.blogspot.com/
> >> -----------------------------------------------------
> >> Turtle Linux  9.10 - http://tiny.cc/blogturtle910
> >> Turtle Linux 10.10 - http://bit.ly/cEw4ET
> >> ===========================
> >
> >
> >
> > --
> > "A arrogância é a arma dos fracos."
> >
> > ===========================
> > Italo Moreira Campelo Maia
> > Bacharel em Ciência da Computação - UECE
> > Desenvolvedor WEB e Desktop (Java, Python, Lua)
> > Coordenador do Pug-CE
> > -----------------------------------------------------
> > http://www.italomaia.com/
> > http://twitter.com/italomaia/
> > http://eusouolobomau.blogspot.com/
> > -----------------------------------------------------
> > Turtle Linux  9.10 - http://tiny.cc/blogturtle910
> > Turtle Linux 10.10 - http://bit.ly/cEw4ET
> > ===========================
> >
>



-- 
"A arrogância é a arma dos fracos."

===========================
Italo Moreira Campelo Maia
Bacharel em Ciência da Computação - UECE
Desenvolvedor WEB e Desktop (Java, Python, Lua)
Coordenador do Pug-CE
-----------------------------------------------------
http://www.italomaia.com/
http://twitter.com/italomaia/
http://eusouolobomau.blogspot.com/
-----------------------------------------------------
Turtle Linux  9.10 - http://tiny.cc/blogturtle910
Turtle Linux 10.10 - http://bit.ly/cEw4ET
===========================