> Hi Simon
thanks for your answer
but i can't understand what's "fetchall()" mean
i remove the " fetchall()" it still work
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from
I wasn't advocating making this connection "in general" (though I like the
autoconfigure option!), but only specifically for the case of reflection -
in this case, we know the DB supports it, and it would result in a better
python interface to the already existing tables.
On Thu, Jul 3, 2014 at 3
On 7/3/14, 6:15 PM, Mike Bayer wrote:
> On 7/3/14, 5:45 PM, Paul Molodowitch wrote:
>> I noticed that sqlalchemy now properly sets the onpudate / ondelete
>> properties of foreign keys when reflecting tables:
>>
>> https://bitbucket.org/zzzeek/sqlalchemy/issue/2183/support-on-delete-update-in-fore
On 7/3/14, 5:45 PM, Paul Molodowitch wrote:
> I noticed that sqlalchemy now properly sets the onpudate / ondelete
> properties of foreign keys when reflecting tables:
>
> https://bitbucket.org/zzzeek/sqlalchemy/issue/2183/support-on-delete-update-in-foreign-key
>
> However, it doesn't seem to set
I noticed that sqlalchemy now properly sets the onpudate / ondelete
properties of foreign keys when reflecting tables:
https://bitbucket.org/zzzeek/sqlalchemy/issue/2183/support-on-delete-update-in-foreign-key
However, it doesn't seem to set the cascade properties of relationships to
reflect th
Muchos grasias, Michael!
Issue resolved.
There were a couple of other ForeignKey issues, seems to be okay now.
So far I understand that there is a lot to learn for me, so I was wondering
- do you by chance accept apprentices ?
I would be willing to help writing fixes/minor features whatever for
OK thats great but you have a long way to go:
import cycle:
classic$ .venv/bin/python
Python 2.7.5 (default, Mar 7 2014, 19:17:16)
[GCC 4.2.1 Compatible Apple LLVM 5.0 (clang-500.2.79)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import model
Traceback (m
this works fine for me:
def upgrade():
mytype = ENUM('a', 'b', 'c', create_type=False, name='myenum')
mytype.create(op.get_bind(), checkfirst=False)
op.create_table('t1',
sa.Column('id', sa.Integer(), nullable=False),
sa.Column('col1', mytype)
)
op.create_ta
Hi Mike!
I've updated requirements. Let me check if I didn't commit something.
четверг, 3 июля 2014 г., 20:41:55 UTC+3 пользователь Michael Bayer написал:
>
> to start with, you have an import cycle. fix that first.
>
> classics-MacBook-Pro-2:artFlask classic$ .venv/bin/python
> Python 2.7.5 (d
Hey guys,
I am facing the same issue, I am using PostgreSQL and want to use native
ENUM type in two tables. For migration I am going to use alembic.
Did you guys find out any was to do this?
Thanks,
Anton
On Thursday, May 1, 2014 10:33:21 AM UTC-7, Michael Bayer wrote:
>
> OK. ENUM is somethi
this project needs:
1. a package
2. a setup.py file
3. a requirements.txt file
I am running in each dependency indivdually as I get import errors.
very painful.
On 7/3/14, 1:19 PM, trusted...@gmail.com wrote:
> Mike, here is the source for the models:
> https://github.com/ArtAPI/artFlask/
to start with, you have an import cycle. fix that first.
classics-MacBook-Pro-2:artFlask classic$ .venv/bin/python
Python 2.7.5 (default, Mar 7 2014, 19:17:16)
[GCC 4.2.1 Compatible Apple LLVM 5.0 (clang-500.2.79)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>
>
> Particularly since sqlalchemy has already established that it's willing to
> expire dict members when they may not be valid anymore - ie, what it does
> to clear any "cached" values from a row proxy after the session is
> committed.
>
> well it doesn't expire the deleted object right now becaus
On 7/3/14, 1:01 PM, Paul Molodowitch wrote:
>
>
> That makes sense... but if if it really means nothing, and we
> shouldn't be looking at it, then why keep it's attributes around at all?
because it is an additional step to actually erase the attributes and
just hadn't been considered.
> Particu
Mike, here is the source for the models:
https://github.com/ArtAPI/artFlask/blob/refactoring/model/__init__.py
I would really apprieciate your feedback on this, I'm really new to flask
and SQLAlchemy.
The other source files (artList.py etc) are also there.
Thank you,
Andrey
четверг, 3 июля 2014
On Wed, Jul 2, 2014 at 9:22 PM, Mike Bayer wrote:
>
> On 7/2/14, 10:05 PM, Paul Molodowitch wrote:
>
> Suppose I have a super simple table like this:
>
> class Dinosaur(Base):
> __tablename__ = 'dinosaurs'
> id = Column(Integer, primary_key=True)
> name = Column(String(255))
>
>
Adding import instruction to artList.py didn't seem to help:
from model import Artwork, Person
What else can I do ?
четверг, 3 июля 2014 г., 17:33:09 UTC+3 пользователь Michael Bayer написал:
>
>
> On 7/3/14, 3:23 AM, trust...@gmail.com wrote:
> > Hi, Michael,
> >
> > here is the stack trace:
Hello,
I'm trying to override __new__ method on the declarative base.
Calling super(Base, cls).__new__ actually calls itself.
Something is happening with the mro, but I'm not quite sure what and how to
proceed.
At the bottom of this email is a small example that demonstrates the
problem.
Rega
HI
I am using pyramid framework with sqlalchemy , I want to update 100
different column with different values.
is there any function available like add_all to update a table(ex
update_all ) in sqlalchemy.
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy
On 7/2/14, 9:24 AM, Chung WONG wrote:
> Hi list,
>
> For this problem I am even having trouble think of a proper subject
> for it.
> I try my best to express as clear as possible and sorry for any
> confusions.
>
> Say there are three classes with relationship defined as below:
> class User(Base)
On 7/3/14, 3:23 AM, trusted...@gmail.com wrote:
> Hi, Michael,
>
> here is the stack trace:
> File "/home/andrey/projects/art/artFlask/api/artList.py", line 30,
> in post
> item = app_ctx.create_item_from_context()
> File "/home/andrey/projects/art/artFlask/utils/app_ctx.py", line 53,
> in
Ok, Mike. Thanks.
Ended up removing the trigger from the model and pushing that code to the
controller, so that "foo" updates the "bar" attribute after form data with
UserCourse objects is handled.
On Wednesday, July 2, 2014 9:42:11 PM UTC-4, Michael Bayer wrote:
>
>
> On 7/2/14, 2:59 PM, Bria
On Thu, Jul 3, 2014 at 8:48 AM, 'Frank Liou' via sqlalchemy
wrote:
> def get_query():
> conn = engine.connect()
> check = 'SELECT * FROM friends'
> obj = [conn.execute(check)]
> jqs = json.dumps(obj)
> return jqs
>
>
>
> result is
>
> Internal Server Error
>
> The server encoun
def get_query():
conn = engine.connect()
check = 'SELECT * FROM friends'
obj = [conn.execute(check)]
jqs = json.dumps(obj)
return jqs
result is
Internal Server Error
The server encountered an internal error and was unable to complete your
request. Either the server is ov
Hi, Michael,
here is the stack trace:
File "/home/andrey/projects/art/artFlask/api/artList.py", line 30, in post
item = app_ctx.create_item_from_context()
File "/home/andrey/projects/art/artFlask/utils/app_ctx.py", line 53, in
create_item_from_context
item = ModelClass(**data)
File
25 matches
Mail list logo