HTML code for sharing source code

HTML Copy To Clipboarddone!

<div class="highlight" style="background: #f8f8f8"><pre style="line-height: 125%"><div id="lc1">&gt;&gt;&gt; import sqlalchemy
</div><div id="lc2">&gt;&gt;&gt; import sqlalchemy.orm
</div><div id="lc3">&gt;&gt;&gt; e = sqlalchemy.create_engine(&#39;postgres://osm:osm@127.0.0.1:5432/gis&#39;)
</div><div id="lc4">&gt;&gt;&gt; s = sqlalchemy.orm.scoped_session(sqlalchemy.orm.sessionmaker(autoflush=False, autocommit=True, bind=e))
</div><div id="lc5">&gt;&gt;&gt; s.execute(&quot;SELECT ST_AsText(transform(GeometryFromText(&#39;MULTIPOINT(:bbox)&#39;, 4326), 900913))&quot;, dict(bbox=&#39;1 1, 2 2&#39;))
</div><div id="lc6">Traceback (most recent call last): 
</div><div id="lc7"> File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt; 
</div><div id="lc8"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/orm/scoping.py&quot;, line 121, in do 
</div><div id="lc9"> return getattr(self.registry(), name)(*args, **kwargs) 
</div><div id="lc10"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/orm/session.py&quot;, line 755, in execute
</div><div id="lc11"> clause, params or {})
</div><div id="lc12"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;, line 824, in execute
</div><div id="lc13"> return Connection.executors[c](self, object, multiparams, params)
</div><div id="lc14"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;, line 874, in _execute_clauseelement
</div><div id="lc15"> return self.__execute_context(context)
</div><div id="lc16"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;, line 896, in __execute_context
</div><div id="lc17"> self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context)
</div><div id="lc18"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;, line 950, in _cursor_execute
</div><div id="lc19"> self._handle_dbapi_exception(e, statement, parameters, cursor, context)
</div><div id="lc20"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;, line 931, in _handle_dbapi_exception
</div><div id="lc21"> raise exc.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect)
</div><div id="lc22">sqlalchemy.exc.ProgrammingError: (ProgrammingError) syntax error at or near &quot;1&quot;
</div><div id="lc23">LINE 1: ...T_AsText(transform(GeometryFromText(&#39;MULTIPOINT(E&#39;1 1, 2 2&#39;)...
</div><div id="lc24"> ^
</div><div id="lc25"> &quot;SELECT ST_AsText(transform(GeometryFromText(&#39;MULTIPOINT(%(bbox)s)&#39;, 4326), 900913))&quot; {&#39;bbox&#39;: &#39;1 1, 2 2&#39;}
</div></pre></div>
 Colored with <a style="color: #333" href="http://dumpz.org">dumpz.org</a>

BBCODE Copy To Clipboarddone!

[color=#000080][b]>>> [/b][/color][color=#008000][b]import[/b][/color] [color=#0000FF][b]sqlalchemy[/b][/color]
[color=#000080][b]>>> [/b][/color][color=#008000][b]import[/b][/color] [color=#0000FF][b]sqlalchemy.orm[/b][/color]
[color=#000080][b]>>> [/b][/color]e [color=#666666]=[/color] sqlalchemy[color=#666666].[/color]create_engine([color=#BA2121]'postgres://osm:osm@127.0.0.1:5432/gis'[/color])
[color=#000080][b]>>> [/b][/color]s [color=#666666]=[/color] sqlalchemy[color=#666666].[/color]orm[color=#666666].[/color]scoped_session(sqlalchemy[color=#666666].[/color]orm[color=#666666].[/color]sessionmaker(autoflush[color=#666666]=[/color][color=#008000]False[/color], autocommit[color=#666666]=[/color][color=#008000]True[/color], bind[color=#666666]=[/color]e))
[color=#000080][b]>>> [/b][/color]s[color=#666666].[/color]execute([color=#BA2121]"SELECT ST_AsText(transform(GeometryFromText('MULTIPOINT(:bbox)', 4326), 900913))"[/color], [color=#008000]dict[/color](bbox[color=#666666]=[/color][color=#BA2121]'1 1, 2 2'[/color]))
Traceback (most recent call last): 
 File [color=#008000]"<stdin>"[/color], line [color=#666666]1[/color], in <module> 
 File [color=#008000]"/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/orm/scoping.py"[/color], line [color=#666666]121[/color], in do 
 [color=#008000][b]return[/b][/color] [color=#008000]getattr[/color]([color=#008000]self[/color][color=#666666].[/color]registry(), name)([color=#666666]*[/color]args, [color=#666666]**[/color]kwargs) 
 File [color=#008000]"/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/orm/session.py"[/color], line [color=#666666]755[/color], in execute
 clause, params [color=#AA22FF][b]or[/b][/color] {})
 File [color=#008000]"/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py"[/color], line [color=#666666]824[/color], in execute
 [color=#008000][b]return[/b][/color] Connection[color=#666666].[/color]executors[c]([color=#008000]self[/color], [color=#008000]object[/color], multiparams, params)
 File [color=#008000]"/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py"[/color], line [color=#666666]874[/color], in _execute_clauseelement
 [color=#008000][b]return[/b][/color] [color=#008000]self[/color][color=#666666].[/color]__execute_context(context)
 File [color=#008000]"/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py"[/color], line [color=#666666]896[/color], in __execute_context
 [color=#008000]self[/color][color=#666666].[/color]_cursor_execute(context[color=#666666].[/color]cursor, context[color=#666666].[/color]statement, context[color=#666666].[/color]parameters[[color=#666666]0[/color]], context[color=#666666]=[/color]context)
 File [color=#008000]"/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py"[/color], line [color=#666666]950[/color], in _cursor_execute
 [color=#008000]self[/color][color=#666666].[/color]_handle_dbapi_exception(e, statement, parameters, cursor, context)
 File [color=#008000]"/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py"[/color], line [color=#666666]931[/color], in _handle_dbapi_exception
 [color=#008000][b]raise[/b][/color] exc[color=#666666].[/color]DBAPIError[color=#666666].[/color]instance(statement, parameters, e, connection_invalidated[color=#666666]=[/color]is_disconnect)
[color=#FF0000]sqlalchemy.exc.ProgrammingError[/color]: (ProgrammingError) syntax error at or near "1"
[color=#808080]LINE 1: ...T_AsText(transform(GeometryFromText('MULTIPOINT(E'1 1, 2 2')...
 ^
 "SELECT ST_AsText(transform(GeometryFromText('MULTIPOINT(%(bbox)s)', 4326), 900913))" {'bbox': '1 1, 2 2'}
[/color]

--------------------------------------
Colored with http://dumpz.org

Light HTML Copy To Clipboarddone!

That method generates HTML with CSS classes. Hence you'll need the style sheet file

<div class="highlight"><pre><div id="lc1">&gt;&gt;&gt; import sqlalchemy
</div><div id="lc2">&gt;&gt;&gt; import sqlalchemy.orm
</div><div id="lc3">&gt;&gt;&gt; e = sqlalchemy.create_engine(&#39;postgres://osm:osm@127.0.0.1:5432/gis&#39;)
</div><div id="lc4">&gt;&gt;&gt; s = sqlalchemy.orm.scoped_session(sqlalchemy.orm.sessionmaker(autoflush=False, autocommit=True, bind=e))
</div><div id="lc5">&gt;&gt;&gt; s.execute(&quot;SELECT ST_AsText(transform(GeometryFromText(&#39;MULTIPOINT(:bbox)&#39;, 4326), 900913))&quot;, dict(bbox=&#39;1 1, 2 2&#39;))
</div><div id="lc6">Traceback (most recent call last): 
</div><div id="lc7"> File &quot;&lt;stdin&gt;&quot;, line 1, in &lt;module&gt; 
</div><div id="lc8"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/orm/scoping.py&quot;, line 121, in do 
</div><div id="lc9"> return getattr(self.registry(), name)(*args, **kwargs) 
</div><div id="lc10"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/orm/session.py&quot;, line 755, in execute
</div><div id="lc11"> clause, params or {})
</div><div id="lc12"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;, line 824, in execute
</div><div id="lc13"> return Connection.executors[c](self, object, multiparams, params)
</div><div id="lc14"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;, line 874, in _execute_clauseelement
</div><div id="lc15"> return self.__execute_context(context)
</div><div id="lc16"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;, line 896, in __execute_context
</div><div id="lc17"> self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context)
</div><div id="lc18"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;, line 950, in _cursor_execute
</div><div id="lc19"> self._handle_dbapi_exception(e, statement, parameters, cursor, context)
</div><div id="lc20"> File &quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;, line 931, in _handle_dbapi_exception
</div><div id="lc21"> raise exc.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect)
</div><div id="lc22">sqlalchemy.exc.ProgrammingError: (ProgrammingError) syntax error at or near &quot;1&quot;
</div><div id="lc23">LINE 1: ...T_AsText(transform(GeometryFromText(&#39;MULTIPOINT(E&#39;1 1, 2 2&#39;)...
</div><div id="lc24"> ^
</div><div id="lc25"> &quot;SELECT ST_AsText(transform(GeometryFromText(&#39;MULTIPOINT(%(bbox)s)&#39;, 4326), 900913))&quot; {&#39;bbox&#39;: &#39;1 1, 2 2&#39;}
</div></pre></div>
 Colored with <a style="color: #333" href="http://dumpz.org">dumpz.org</a>

Habrahabr.ru HTML Copy To Clipboarddone!

Use that HTML for publications on habrahabr.ru

<blockquote><code>&gt;&gt;&gt;&nbsp;import&nbsp;sqlalchemy
&gt;&gt;&gt;&nbsp;import&nbsp;sqlalchemy.orm
&gt;&gt;&gt;&nbsp;e&nbsp;=&nbsp;sqlalchemy.create_engine(&#39;postgres://osm:osm@127.0.0.1:5432/gis&#39;)
&gt;&gt;&gt;&nbsp;s&nbsp;=&nbsp;sqlalchemy.orm.scoped_session(sqlalchemy.orm.sessionmaker(autoflush=False,&nbsp;autocommit=True,&nbsp;bind=e))
&gt;&gt;&gt;&nbsp;s.execute(&quot;SELECT&nbsp;ST_AsText(transform(GeometryFromText(&#39;MULTIPOINT(:bbox)&#39;,&nbsp;4326),&nbsp;900913))&quot;,&nbsp;dict(bbox=&#39;1&nbsp;1,&nbsp;2&nbsp;2&#39;))
Traceback&nbsp;(most&nbsp;recent&nbsp;call&nbsp;last):&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;File&nbsp;&quot;&lt;stdin&gt;&quot;,&nbsp;line&nbsp;1,&nbsp;in&nbsp;&lt;module&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;File&nbsp;&quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/orm/scoping.py&quot;,&nbsp;line&nbsp;121,&nbsp;in&nbsp;do&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;getattr(self.registry(),&nbsp;name)(*args,&nbsp;**kwargs)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;File&nbsp;&quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/orm/session.py&quot;,&nbsp;line&nbsp;755,&nbsp;in&nbsp;execute
&nbsp;&nbsp;&nbsp;&nbsp;clause,&nbsp;params&nbsp;or&nbsp;{})
&nbsp;&nbsp;File&nbsp;&quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;,&nbsp;line&nbsp;824,&nbsp;in&nbsp;execute
&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;Connection.executors[c](self,&nbsp;object,&nbsp;multiparams,&nbsp;params)
&nbsp;&nbsp;File&nbsp;&quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;,&nbsp;line&nbsp;874,&nbsp;in&nbsp;_execute_clauseelement
&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;self.__execute_context(context)
&nbsp;&nbsp;File&nbsp;&quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;,&nbsp;line&nbsp;896,&nbsp;in&nbsp;__execute_context
&nbsp;&nbsp;&nbsp;&nbsp;self._cursor_execute(context.cursor,&nbsp;context.statement,&nbsp;context.parameters[0],&nbsp;context=context)
&nbsp;&nbsp;File&nbsp;&quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;,&nbsp;line&nbsp;950,&nbsp;in&nbsp;_cursor_execute
&nbsp;&nbsp;&nbsp;&nbsp;self._handle_dbapi_exception(e,&nbsp;statement,&nbsp;parameters,&nbsp;cursor,&nbsp;context)
&nbsp;&nbsp;File&nbsp;&quot;/usr/local/lib/python2.6/dist-packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py&quot;,&nbsp;line&nbsp;931,&nbsp;in&nbsp;_handle_dbapi_exception
&nbsp;&nbsp;&nbsp;&nbsp;raise&nbsp;exc.DBAPIError.instance(statement,&nbsp;parameters,&nbsp;e,&nbsp;connection_invalidated=is_disconnect)
sqlalchemy.exc.ProgrammingError:&nbsp;(ProgrammingError)&nbsp;syntax&nbsp;error&nbsp;at&nbsp;or&nbsp;near&nbsp;&quot;1&quot;
LINE&nbsp;1:&nbsp;...T_AsText(transform(GeometryFromText(&#39;MULTIPOINT(E&#39;1&nbsp;1,&nbsp;2&nbsp;2&#39;)...
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;^
&nbsp;&quot;SELECT&nbsp;ST_AsText(transform(GeometryFromText(&#39;MULTIPOINT(%(bbox)s)&#39;,&nbsp;4326),&nbsp;900913))&quot;&nbsp;{&#39;bbox&#39;:&nbsp;&#39;1&nbsp;1,&nbsp;2&nbsp;2&#39;}
</code></blockquote>Colored with <a href="http://dumpz.org">dumpz.org</a>