Edit Question - KnowledgeHub

Title Body

I got the tutorial http://www.rmunn.com/sqlalchemy-tutorial/tutorial.html When I compile got the error message The debugged program raised the exception unhandled NameError "name 'BoundMetaData' is not defined" I am use the latest sqlAlchemy . How Could I fixed this? After read this I modified to my own for latest version sqlAlchemy: from sqlalchemy import * engine = create_engine('mysql://root:mypassword@localhost/mysql') metadata = MetaData() users = Table('users', metadata, Column('user_id', Integer, primary_key=True), Column('name', String(40)), Column('age', Integer), Column('password', String), ) metadata.create_all(engine) i = users.insert() i.execute(name='Mary', age=30, password='secret') i.execute({'name': 'John', 'age': 42}, {'name': 'Susan', 'age': 57}, {'name': 'Carl', 'age': 33}) s = users.select() rs = s.execute() row = rs.fetchone() print 'Id:', row[0] print 'Name:', row['name'] print 'Age:', row.age print 'Password:', row[users.c.password] for row in rs: print row.name, 'is', row.age, 'years old It raise error raise exc.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect) sqlalchemy.exc.ProgrammingError: (ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' \n\tPRIMARY KEY (user_id)\n)' at line 5") '\nCREATE TABLE users (\n\tuser_id INTEGER NOT NULL AUTO_INCREMENT, \n\tname VARCHAR(40), \n\tage INTEGER, \n\tpassword VARCHAR, \n\tPRIMARY KEY (user_id)\n)\n\n' ()

Tags (comma-separated) Cancel