C:\Dev\pysched>python createservers.py
D:\Python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\databases\ms
sql.py:977: DeprecationWarning: object.__new__() takes no parameters
return super(MSSQLDialect, cls).__new__(cls, *args, **kwargs)
2009-04-17 18:29:10,421 INFO sqlalchemy.engine.base.Engine.0x...0270 BEGIN
2009-04-17 18:29:10,437 INFO sqlalchemy.engine.base.Engine.0x...0270 INSERT
INTO
[SERVERS] ([SERVER], [IP], [PORT], [OS], [JSERVER], [STARTED], [STDIN],
[LOGIN]
, [CWD], [ASSIGNEDONLY]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
2009-04-17 18:29:10,437 INFO sqlalchemy.engine.base.Engine.0x...0270
['agent1',
'192.168.0.100', 2000, 0, None, 1, 1, 1, 1, 0]
2009-04-17 18:29:10,500 INFO sqlalchemy.engine.base.Engine.0x...0270
ROLLBACK
Traceback (most recent call last):
File "createservers.py", line 9, in <module>
session.flush()
File
"d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\
session.py", line 1351, in flush
self._flush(objects)
File
"d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\
session.py", line 1422, in _flush
flush_context.execute()
File
"d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\
unitofwork.py", line 244, in execute
UOWExecutor().execute(self, tasks)
File
"d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\
unitofwork.py", line 707, in execute
self.execute_save_steps(trans, task)
File
"d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\
unitofwork.py", line 722, in execute_save_steps
self.save_objects(trans, task)
File
"d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\
unitofwork.py", line 713, in save_objects
task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
File
"d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\orm\
mapper.py", line 1347, in _save_obj
c = connection.execute(statement.values(value_params), params)
File
"d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\engi
ne\base.py", line 824, in execute
return Connection.executors[c](self, object, multiparams, params)
File
"d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\engi
ne\base.py", line 874, in _execute_clauseelement
return self.__execute_context(context)
File
"d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\engi
ne\base.py", line 896, in __execute_context
self._cursor_execute(context.cursor, context.statement,
context.parameters[0
], context=context)
File
"d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\engi
ne\base.py", line 950, in _cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor, context)
File
"d:\python26\lib\site-packages\sqlalchemy-0.5.3-py2.6.egg\sqlalchemy\engi
ne\base.py", line 931, in _handle_dbapi_exception
raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidat
ed=is_disconnect)
sqlalchemy.exc.ProgrammingError: (ProgrammingError) ('42S02', "[42S02]
[Microsof
t][ODBC SQL Server Driver][SQL Server]Invalid object name 'SERVERS'. (208)
(SQLE
xecDirectW); [42000] [Microsoft][ODBC SQL Server Driver][SQL
Server]Statement(s)
could not be prepared. (8180)") u'INSERT INTO [SERVERS] ([SERVER], [IP],
[PORT]
, [OS], [JSERVER], [STARTED], [STDIN], [LOGIN], [CWD], [ASSIGNEDONLY])
VALUES (?
, ?, ?, ?, ?, ?, ?, ?, ?, ?)' ['agent1', '192.168.0.100', 2000, 0, None, 1,
1, 1
, 1, 0]
C:\Dev\pysched>
On Fri, Apr 17, 2009 at 5:05 PM, Michael Trier <[email protected]> wrote:
>
> On Apr 17, 2009, at 5:46 PM, Michael Mileusnich <[email protected]>
> wrote:
>
> First, thanks for being patient and assisting me. I am very thankful.
>
> MS SQL 2005 is the db I am running.
>
> part of my db.py script:
>
> try:
> connection = config.get("db", "connection")
> except:
> print "No Database Specified"
> sys.exit(1)
>
> engine = create_engine(connection)
>
> metadata = MetaData(engine)
>
> Session = scoped_session(sessionmaker(bind=engine, autoflush=False,
> autocommit=True))
>
> action_table = Table(
> 'ACTIONS', metadata,
> Column('ACTIONID', String(48), primary_key=True),
> Column('TITLE', String(128)),
> Column('CMDLINE', String(512)),
> Column('STDIN', Text),
> Column('STARTINDIR', String(512)),
> Column('PRIO', Integer),
> Column('USERID', Integer, ForeignKey('USERS.USERID')))
>
> ...
> more tables here
> ...
> etc
>
> mapper(action, action_table)
>
> here is my create:
>
> new_action = action(ACTIONID = '500', CMDLINE = 'sol')
> session.add(new_action)
> session.flush()
>
> also how do I turn on echo?
>
> On Fri, Apr 17, 2009 at 3:24 PM, Michael Trier < <[email protected]>
> [email protected]> wrote:
>
>> On Fri, Apr 17, 2009 at 2:01 AM, Michael Mileusnich <<[email protected]>
>> [email protected]> wrote:
>>
>>> I am still having issues with pyodbc on Python 2.6.
>>>
>>> Platform: Windows XP SP3 32 bit
>>> Python 2.6
>>> SQLAlchemy 0.5.3
>>> pyodbc 2.1.3
>>>
>>> I run this exact setup without problems. Maybe if we see the script that
>> will help. What version of MSSQL?
>>
>>> --
>>> Michael Trier
>>> <http://blog.michaeltrier.com/>http://blog.michaeltrier.com/
>>> <http://thisweekindjango.com/>http://thisweekindjango.
>>
>>
> engine = create_engine(connection, echo=True)
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
