[sqlalchemy] Re: connect mssql wrong(sqlalchemy.exc.DBAPIError: (Error) ('08001', '[08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server \xb2\xbb\xb4\xe6\xd4\xda\xbb\xf2\xb7\xc3\xce\xca\xb1\

2012-08-17 Thread nepaul
Help! 在 2012年8月17日星期五UTC+8上午10时56分58秒,nepaul写道: my code: import sqlalchemy db = sqlalchemy.create_engine(mssql+pyodbc://root:123456@localhost/DumpResult) conn = db.connect() print db -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To

[sqlalchemy] Re: How to disable Foreign Keys to clear database

2012-08-17 Thread GHZ
There is a recipe for dropping FK constraints: http://www.sqlalchemy.org/trac/wiki/UsageRecipes did you find that? In addition, if you wanted to keep the FKs enabled, there is an example here using Metadata.sorted_tables, to get the table list in dependency order.

Re: [sqlalchemy] Re: How to disable Foreign Keys to clear database

2012-08-17 Thread Gregory Rehm
Thanks so much! that worked great. It seems like google directed me everywhere except to the recipes. On Fri, Aug 17, 2012 at 4:32 AM, GHZ geraint.willi...@gmail.com wrote: There is a recipe for dropping FK constraints: http://www.sqlalchemy.org/trac/wiki/UsageRecipes did you find that? In

RE: [sqlalchemy] Re: how to get into PG database, is the url the right way? newbie question

2012-08-17 Thread Gery .
Thanks Simon again for your nice explanation, I finally found a way to do that, thanks. Cheers, Gery __ Piensa en el medio ambiente - mantenlo en la pantalla. NO lo imprimas si NO es necesario.

Re: [sqlalchemy] how to get into PG database, is the url the right way? newbie question

2012-08-17 Thread Martijn Moeling
I have made this for my project and I do not see why you are using Openlayers for this. This has nothing to do with sqlalchemy. off topic: Ext.form.Panel has no 'protocol' so I think you should extend FormPanel to include that functionality. Ext.direct is the way to go for stuff like this.

Re: [sqlalchemy] how to get into PG database, is the url the right way? newbie question

2012-08-17 Thread Martijn Moeling
or take a look at this: var store = new GeoExt.data.FeatureStore({ layer: sundials, proxy: new GeoExt.data.ProtocolProxy({ protocol: new OpenLayers.Protocol.HTTP({ url: sundials.kml, format: new OpenLayers.Format.KML() }) }), fields: [