<div class="gmail_quote"><br>Hi to alls,<div><br></div><div>I've somes problems to make running my pyarchinit plugin under windows. </div><div><br></div><div>Pyarchinit use sqlalchemy and under mac os x and Linux, all run properly.</div>
<div><br></div>
<div>It's possible make using the python installed under windows and not the embedded into Qgis, or put sqlalchemy as psycopg2 into the distribution?</div><div><br></div><div>Let me know! 8 )</div><div><br></div><div>
Bye bye and thank you!</div><div><br></div><div>Luca</div><div><br></div><div>Under windows I receive this error:</div><div><br></div><div><span style="font-family:arial, sans-serif;font-size:10px"><p>
Traceback (most recent call last): <br> File "C:/Documents and Settings/Administrator/.qgis//python/plugins <br>\pyarchinit\pyarchinit_Site_mainapp.py", line 217, in <br>on_pushButton_save_pressed <br> test_insert = self.insert_new_rec() <br>
File "C:/Documents and Settings/Administrator/.qgis//python/plugins <br>\pyarchinit\pyarchinit_Site_mainapp.py", line 234, in insert_new_rec <br></p><p> self.DB_MANAGER.max_num_id(self.TABLE_NAME, self.ID_TABLE)+1, <br>
File "C:/Documents and Settings/Administrator/.qgis//python/plugins <br>\pyarchinit\modules\db\pyarchinit_db_manager.py", line 262, in <br>max_num_id <br> table = Table(self.id_table, self.metadata, autoload = True) <br>
</p><p> File "c:\python25\Lib\site-packages\sqlalchemy\schema.py", line 108, <br>in __call__ <br> return type.__call__(self, name, metadata, *args, **kwargs) <br> File "c:\python25\Lib\site-packages\sqlalchemy\schema.py", line 236, <br>
in __init__ <br> _bind_or_error(metadata).reflecttable(self, <br>include_columns=include_columns) <br> File "c:\python25\Lib\site-packages\sqlalchemy\engine\base.py", line <br>1265, in reflecttable <br> self.dialect.reflecttable(conn, table, include_columns) <br>
File "c:\python25\Lib\site-packages\sqlalchemy\databases <br>\postgres.py", line 638, in reflecttable <br> c = connection.execute(t, table=table_oid) <br> File "c:\python25\Lib\site-packages\sqlalchemy\engine\base.py", line <br>
824, in execute <br> return Connection.executors[c](self, object, multiparams, params) <br> File "c:\python25\Lib\site-packages\sqlalchemy\engine\base.py", line <br>874, in _execute_clauseelement <br> return self.__execute_context(context) <br>
File "c:\python25\Lib\site-packages\sqlalchemy\engine\base.py", line <br>896, in __execute_context <br> self._cursor_execute(context.cursor, context.statement, <br>context.parameters[0], context=context) <br>
File "c:\python25\Lib\site-packages\sqlalchemy\engine\base.py", line <br>946, in _cursor_execute <br> <a href="http://self.engine.logger.info" target="_blank">self.engine.logger.info</a>(repr(parameters)) <br>
File "C:\OSGeo4W\apps\Python25\lib\logging\__init__.py", line 985, <br>
in info <br> apply(self._log, (INFO, msg, args), kwargs) <br> File "C:\OSGeo4W\apps\Python25\lib\logging\__init__.py", line 1101, <br>in _log <br> self.handle(record) <br> File "C:\OSGeo4W\apps\Python25\lib\logging\__init__.py", line 1111, <br>
in handle <br> self.callHandlers(record) <br> File "C:\OSGeo4W\apps\Python25\lib\logging\__init__.py", line 1148, <br>in callHandlers <br> hdlr.handle(record) <br> File "C:\OSGeo4W\apps\Python25\lib\logging\__init__.py", line 655, <br>
in handle <br> self.emit(record) <br> File "C:\OSGeo4W\apps\Python25\lib\logging\__init__.py", line 757, <br>in emit <br> self.handleError(record) <br> File "C:\OSGeo4W\apps\Python25\lib\logging\__init__.py", line 706, <br>
in handleError <br> traceback.print_exception(ei[0], ei[1], ei[2], None, sys.stderr) <br> File "C:\OSGeo4W\apps\Python25\lib\traceback.py", line 128, in <br>print_exception <br> print_tb(tb, limit, file) <br>
File "C:\OSGeo4W\apps\Python25\lib\traceback.py", line 70, in <br>print_tb <br> ' File "%s", line %d, in %s' % (filename,lineno,name)) <br> File "C:\OSGeo4W\apps\Python25\lib\traceback.py", line 16, in _print <br>
file.write(str+terminator) <br>IOError: [Errno 9] Bad file descriptor <br></p><p>Versione Python: <br>2.5.4 (r254:67916, Dec 23 2008, 15:10:54) [MSC v.1310 32 bit (Intel)] <br></p><p>Percorso Python: ['C:/Documents and Settings/Administrator/.qgis// <br>
python/plugins\\pyarchinit\\modules\\gui', 'C:/Documents and Settings/ <br>Administrator/.qgis//python/plugins\\pyarchinit\\modules\\gis', 'C:/ <br>Documents and Settings/Administrator/.qgis//python/plugins\\pyarchinit\ <br>
\modules\\db', 'C:/Documents and Settings/Administrator/.qgis//python/ <br>plugins\\pyarchinit\\modules\\utility', 'C:/Documents and Settings/ <br>Administrator/.qgis//python/plugins\\pyarchinit', 'C:/OSGeo4W/apps/ <br>
qgis-unstable/./python', 'C:/Documents and Settings/ <br>Administrator/.qgis//python', 'C:/Documents and Settings/ <br>Administrator/.qgis//python/plugins', 'C:/OSGeo4W/apps/qgis-unstable/./ <br>python/plugins', 'C:\\OSGeo4W\\apps\\gdal-16\\pymod', 'C:\\', 'C:\ <br>
\WINDOWS\\system32\\python25.zip', 'C:\\OSGeo4W\\apps\\Python25\ <br>\DLLs', 'C:\\OSGeo4W\\apps\\Python25\\lib', 'C:\\OSGeo4W\\apps\ <br>\Python25\\lib\\plat-win', 'C:\\OSGeo4W\\apps\\Python25\\lib\\lib-tk', <br>
'C:\\OSGeo4W\\apps\\qgis-unstable\\bin', 'C:\\OSGeo4W\\apps\ <br>\Python25', 'C:\\OSGeo4W\\apps\\Python25\\lib\\site-packages', 'C:\ <br>\OSGeo4W\\apps\\Python25\\lib\\site-packages\\win32', 'C:\\OSGeo4W\ <br>
\apps\\Python25\\lib\\site-packages\\win32\\lib', 'C:\\OSGeo4W\\apps\ <br>\Python25\\lib\\site-packages\\Pythonwin', 'C:\\OSGeo4W\\apps\ <br>\Python25\\lib\\site-packages\\wx-2.8-msw-unico</p></span></div>
</div><br>