python - SQLAlchemy/Flask/Postgres编程错误:

Question

我正在 Flask 中设置一个应用程序，我刚刚将一个新表“StudyGroup”引入到我的数据库架构中。我仍在测试，所以我只是删除创建加载数据库，直到一切正常。我在我的用户模型中使用 Flask-Security，这是 UserMixin 部分的来源。

在尝试创建和提交其中一个新对象时，Sqlalchemy 给了我一个 "ProgrammingError: <unprintable ProgrammingError object>"错误我完全不明白这意味着什么。下面的代码片段和完整的回溯......

模型.py代码:

from app import db
from flask.ext.security import Security, SQLAlchemyUserDatastore, UserMixin, RoleMixin, login_required

class User(db.Model, UserMixin):  
    id = db.Column(db.Integer, primary_key = True)
    username = db.Column(db.String(64), index = True)
    user_groups=db.relationship('Studygroup',
        secondary=users_x_groups,
        backref = db.backref('group_members', lazy = 'dynamic'),
        lazy='dynamic') 
    groups_founded = db.relationship("Studygroup", backref="group_founder")



class Studygroup(db.Model): #can't reduce this any further because I don't know what's blowing up
    id = db.Column(db.Integer, primary_key=True)
    created=db.Column(db.DateTime())
    founder = db.Column(db.Integer, db.ForeignKey('user.id'))
    groupname=db.Column(db.String(255))
    about = db.Column(db.Text)
    locationstr=db.Column(db.String(255))
    zipcode=db.Column(db.String(5))
    profilepiclink=db.Column(db.String(140))
    latitude=db.Column(db.Float())
    longitude=db.Column(db.Float())
    openclosed= db.Column(db.SmallInteger)
    group_topics=db.relationship('Topic',
        secondary=groups_x_topics,
        backref = db.backref('topic_groups', lazy = 'dynamic'),
        lazy='dynamic')
    group_courses=db.relationship('Course',
        secondary=groups_x_courses,
        backref = db.backref('course_groups', lazy = 'dynamic'),
        lazy='dynamic')
    group_events = db.relationship("Event", backref="studygroup")
    group_posts = db.relationship("Post", backref="studygroup")

    def __init__(self, founderid,groupname,about=None,locationstr=None,zipcode='00000',profilepiclink=None,openclosed=1,topicids=[],courseids=[]):
        self.created=datetime.datetime.utcnow()
        founder=User.query.get(founderid) #I've tried this with a User instead of an integer input, same error
        self.founder=founder
        self.groupname=groupname
        self.about=about
        self.locationstr=locationstr
        self.zipcode=zipcode
        self.profilepiclink=profilepiclink
        self.openclosed=1 #all groups default to open
        for topicid in topicids:
            self.group_topics.append(topicid)
        for courseid in courseids:
            self.group_courses.append(courseid)
        self.group_members.append(founder) 
        if zipcode=='00000':
            self.latitude=90.00
            self.longitude=0.00000
        else:
            (self.latitude, self.longitude)=eval(r.get("zipcode:"+str(zipcode))) #TESTING

和 db_populate.py 代码: 从应用程序导入应用程序、数据库、用户数据存储 from app.models import Course, User, Studygroup, Topic, Event 导入追溯 导入集合

def dropit_popit():
    db.session.commit() #prevents an error
    db.drop_all()
    with app.app_context():
        db.create_all()
    u2=collections.defaultdict()
    u2[0] = MakeUserInDb('Alex','<email redacted>','password','94110')
    for x in range(1,20):
        if x%10==0: print x
        if x%10: db.session.commit()
        usethiszip=random.choice(possiblezips)
        u2[x]=MakeUserInDb(username="TEST", email='User'+str(x)+'@User.com', password='password', zipcode=usethiszip)
    uuuu=User.query.get(1) #Earlier, tried using User instead of userid with lookup to fix
    print uuuu  #returns the first user I made

    #note: All of the above works for creating users etc. I recently introduced Studygroup and that's what I'm testing.

    try:
        dat_groop=Studygroup(1,"TESTGROUP",about="Dis be group",locationstr="Frisco",zipcode='94110',profilepiclink=None,openclosed=1,topicids=[],courseids=[])
        db.session.add(dat_groop)
        db.session.commit() #THIS IS WHERE THE ERROR HAPPENS
    except:
        print traceback.print_exc()

和回溯:

Traceback (most recent call last):

      File "db_populate.py", line 139, in dropit_popit
    db.session.commit()
  File "/Library/Python/2.7/site-packages/sqlalchemy/orm/scoping.py", line 114, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/Library/Python/2.7/site-packages/sqlalchemy/orm/session.py", line 703, in commit
    self.transaction.commit()
  File "/Library/Python/2.7/site-packages/sqlalchemy/orm/session.py", line 361, in commit
    self._prepare_impl()
  File "/Library/Python/2.7/site-packages/sqlalchemy/orm/session.py", line 340, in _prepare_impl
    self.session.flush()
  File "/Library/Python/2.7/site-packages/sqlalchemy/orm/session.py", line 1718, in flush
    self._flush(objects)
  File "/Library/Python/2.7/site-packages/sqlalchemy/orm/session.py", line 1789, in _flush
    flush_context.execute()
  File "/Library/Python/2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 331, in execute
    rec.execute(self)
  File "/Library/Python/2.7/site-packages/sqlalchemy/orm/unitofwork.py", line 475, in execute
    uow
  File "/Library/Python/2.7/site-packages/sqlalchemy/orm/persistence.py", line 64, in save_obj
    table, insert)
  File "/Library/Python/2.7/site-packages/sqlalchemy/orm/persistence.py", line 558, in _emit_insert_statements
    execute(statement, params)
  File "/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py", line 1449, in execute
    params)
  File "/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
    compiled_sql, distilled_params
  File "/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py", line 1698, in _execute_context
    context)
  File "/Library/Python/2.7/site-packages/sqlalchemy/engine/base.py", line 1691, in _execute_context
    context)
  File "/Library/Python/2.7/site-packages/sqlalchemy/engine/default.py", line 331, in do_execute
    cursor.execute(statement, parameters)
ProgrammingError: <unprintable ProgrammingError object>

想法？我在这里做错了什么？

谢谢!

Answer 1

错误可能发生在你做的地方

MakeUserInDb('Alex','<email redacted>','password','94110')

在你做的另一行:

MakeUserInDb(username="TEST", email='User'+str(x)+'@User.com', password='password', zipcode=usethiszip)

在数据库中创建新对象时始终使用 kwargs，就像在第二个示例中所做的那样。错误的原因是该类期望参数按特定顺序排列，而您可能没有将它们放入。当您使用 kwargs 时，顺序无关紧要。