authored by Wayne Witzel III

paster shell - do people know about it?

On January 21, 2010 In sqlalchemy, pylons Permalink
Today I was having a chat today about Pylons vs. Django and for the most part it was pretty diplomatic. We got to talking about the Admin interface the Django has. Which you don't have to do any extra boiler plate for, it is just there for you. With Pylons you have to use something like FormAlchemy or use Turbogears to get a similar style admin interface for your models and data. Since we were sitting at a computer, I went ahead brought up a quick project and did a little demo of the paster shell. Sure, it involves typing and it isn't as pretty or "fast" as an admin panel, but he didn't even know it existed. One of the common things he mentioned was, "if I want to change the menus that are dynamically defined" or "if a username needs to be changed" .. and the application itself doesn't have a custom admin panel, with Pylons he had to do raw SQL.
$paster shell pylons_config.ini

All objects from demo.lib.base are available
Additional Objects:
   mapper     -  Routes mapper object
   wsgiapp    -  This project's WSGI App instance
   app        -  paste.fixture wrapped around wsgiapp

>>> error_user = meta.Session.query(model.User).filter_by(username='wwitzel 3').one()
>>> # nice thing about this, is you also will get exceptions throw if more than one record exists
>>> error_user.username
u'wwitzel 3'
>>> error_user.username = 'wwitzel3'
>>> meta.Session.commit()
>>> menu_typo = meta.Session.query(model.Menu).filter_by(id=1).one()
>>> menu_typo.value
>>> menu_typo.value = 'About'
>>> meta.Session.commit()
So that is a very simple example of how one would use the paster shell to update some bad data in the database while ensuring integrity of your custom model and extension code. After I showed this to my friend he wasn't as concerned about the lack of a web interface for administration within Pylons.
Read and Post Comments

SQLalchemy and JSON w/ Pylons - Best Practices

On August 17, 2009 In sqlalchemy, pylons Permalink
I asked the question I Stackoverflow and maybe it was too generic for the site, since it just got trolled with "Google keyword" by some d-bag. So I deleted it and figured I'd throw it up on my blog a see about getting some feedback from the people who read this pile about. The reason I ask this is mainly because I am preparing to do some updated screencasts for Pylons. I've seen multiple ways referenced in official docs and I have done it a few different ways myself. I am using Pylons and I am curious what the best practices are for this common scenario? I have used something similar to this for auto-magically making the conversion happen.
# The auto-magic version
# I pulled this off a blog, forget the source.
def _sa_to_dict(obj):
    for item in obj.__dict__.items():
        if item[0][0] is '_':
        if isinstance(item[1], str):
            yield [item[0], item[1].decode()]
            yield item

def json(obj):
    if isinstance(obj, list):
        return dumps(map(dict, map(_sa_to_dict, obj)))
        return dumps(dict(_sa_to_dict(obj)))

# here is the controller
def index(self, format='html'):
    templates = Session.query(Template).all()
    if format == 'json':
        return json(templates)
I have also done the version where you use the jsonify decorator and build your dictionary manually, something like this, which is ok if I need to define some custom behavior for my JSON, but as the default behavior seems excessive.
def index(self, format='html'):
    if format == 'json':
        q = Session.query
        templates = [{'id':,
                      'title': t.title,
                      'body': t.body} for t in q(Template)]
        return templates
I've also created an inherited SA class which defines a json method and have used that on all my objects to convert them to JSON. Similar to the the fedora extensions. Maybe I missed some obviously library out there or some obvious helper in the Pylons packages, but I feel like this is a very common task being done a dozen different ways between docs, source, and my own personal projects. Curious what others are doing / using.
Read and Post Comments

Jython 2.5 and snakefight for deploying Pylons w/ SQLAlchemy + Oracle.

UPDATE / 13 March 2009: snakefight 0.3 now has a --include-jar option, prefer that to using my hack. After reading P. Jenvey's blog post about Deploying Pylons Apps to Java Servlet Containers I immediately downloaded the Jython 2.5 beta and installed snakefight to give it a try. One of our services where I work is a Pylons based application. It is deployed using paster and Apache ProxyPass. Our main application is written in Java and is deployed as a war under Jetty. So if I can get my Pylons application built as a war and deployed that way, it would greatly simplify our deployment process. [sourcecode language="bash"] $ sudo /opt/jython25/bin/easy_install snakefight $ /opt/jython25/bin/jython develop $ /opt/jython25/bin/jython bdist_war --paster-config dev_r2.ini ... output of success and stuff ... $ cp dist/project-0.6.8dev.war /opt/jetty/webapps [/sourcecode] Now I visit my local server and hit the project context. I get some database errors, kind of expected them. So for the time being, I'll be running this directly using Jython to speed up the debugging process. A quick googling of my DB issues turns up zxoracle for SQLalchemy which uses Jython zxJDBC. I install that in to sqlalchemy/databases as and give it another go. Changing the oracle:// lines in my .ini file to now read zxoracle:// Now it can't find the 3rd party Oracle libraries (ojdbc.jar). [sourcecode] $ cd ./dist $ jar xf project-0.6.8dev.war $ cd WEB-INF/lib $ ls # no ojdbc.jar as expected ... $ cd ~/project $ export CLASSPATH=/opt/jython25/jython.jar:/usr/lib/jvm/java/jre/lib/ext/ojdbc.jar $ /opt/jython25/bin/jython /opt/jython25/bin/paster serve --reload dev_r2.ini [/sourcecode] Now it is looking a little better and it able to find the jar, but still a DB issue, now with SQLalchemy library. Not having a ton of time to investigate, I decide to try rolling back my SQAlachemy version for Jython. Turns out rolling back to 0.5.0 fixed the issue. I'll be investigating why it was breaking with 0.5.2 soon (tm). So now I rerun it, and get a new error. [sourcecode lang="bash"] AttributeError: 'ZXOracleDialect' object has no attribute 'optimize_limits' [/sourcecode] I decide I am just going to go in to the and add optimize_limits = False to the ZXOracleDialect. No idea what this breaks or harms, but I do it anyway and rerun the application. Success! Every thing is working now. No liking the idea of having to manually insert the Oracle jar in to the WEB-INF/lib and not really wanting to much around with environment variables, I also implemented a quick and dirty include-java-libs for snakefight, the diff for is below. This allows me to pass in a : separated list of jars to include in the WEB-INF/lib. EDIT: The diff I posted isn't needed since I put it on my hg repo. You can grab it from here. So now I am back to building my war. Just as before. [sourcecode lang="bash"] $ /opt/jython25/bin/jython bdist_war --paste-config dev_r2.ini --include-java-libs /opt/jython25/extlibs/ojdbc.jar running bdist_war creating build/bdist.java1.6.0_12 creating build/bdist.java1.6.0_12/war creating build/bdist.java1.6.0_12/war/WEB-INF creating build/bdist.java1.6.0_12/war/WEB-INF/lib-python running easy_install project adding eggs (to WEB-INF/lib-python) adding jars (to WEB-INF/lib) adding WEB-INF/lib/jython.jar adding Paste ini file (to dev_r2.ini) adding Paste app loader (to WEB-INF/lib-python/ generating deployment descriptor adding deployment descriptor (WEB-INF/web.xml) created dist/project-0.6.8dev-py2.5.war $ cp dist/project-0.6.8dev-py2.5.war /opt/jetty/webapps $ sudo /sbin/service jetty restart [/sourcecode] And presto! I am in business. My pylons application is deployed under Jetty and all the selenium functional tests are passing. I am sure there is probably a easier, neater, or cleaner way to do all this, but this was my first iteration through and also my first time ever deploying a WAR to a java servlet container so all in all I am happy with the results. Performance seems about the same as when running the application with paster serve, but Jetty does use a little more memory than before (expected I guess).
Read and Post Comments

Pylons and long-live AJAX request.

On February 04, 2009 In python, code, pylons Permalink
So I am playing around in Firefox with XMLHttpRequest. Looking in to a way to facilate a server update to a client without have to refresh the page or use Javascript timers. So the long-live HTTP request seems the way to go. This little app will at most have 20-30 connections at once, so I am not worried about the open connection per client. The data it calculates is rather large and intensive to gather, so I paired it with the cache decorator snippet found on ActiveState and used in Expert Python Programming. This example feeds a cached datetime string. The caching lets different client receive the same data during the cache process. There is some lag between the updates since they all set their sleep at different points, there may be away around this though. So here is my basic index.html. [sourcecode language="html"] This will push data from the server to you every 5 seconds .. enjoy!

    [/sourcecode] Now the controller code itself. [sourcecode language="python"] class ServerController(BaseController): def index(self): response.headers['Content-type'] = 'multipart/x-mixed-replace;boundary=test' return data_stream() def data_stream(stream=True): yield datetime_string() while stream: time.sleep(5) yield datetime_string() @memorize(duration=15) def datetime_string(): content = '--test\nContent-type: application/xml\n\n' content += '\n' content += '' + str( + '\n' content += '--test\n' return content [/sourcecode] Also the decorator code for good measure. [sourcecode language="python"] cache = {} def is_old(entry, duration): return time.time() - entry['time'] > duration def compute_key(function, args, kw): key = pickle.dumps((function.func_name, args, kw)) return hashlib.sha1(key).hexdigest() def memorize(duration=10): def _memorize(function): def __memorize(*args, **kw): key = compute_key(function, args, kw) if (key in cache and not is_old(cache[key], duration)): return cache[key]['value'] result = function(*args, **kw) cache[key] = {'value': result, 'time':time.time()} return result return __memorize return _memorize [/sourcecode] Full working demo will be available in the HG repos shortly.

    Read and Post Comments

How-To: Python, Pylons, and Windows

On October 07, 2008 In python, pylons, deploy Permalink
A friend having issues installing Pylons on Windows XP with Python 2.6 gave me the idea to do this quick write up. So here it is, the 6 step method for running Pylons on Windows XP.
  • Download Python.
  • Add Python to your path and launch a command prompt.
  • Download, python
  • Download simplejson, python --without-speedups install
  • easy_install Pylons
  • easy_install formbuild
  • Do a quick test; paster create --template=pylons
And that is all she wrote. Pretty easy. The reason we install simplejson seperate is because the default behavior is to build with speedups and well .. by default, that behavior won't work on a standard Windows XP machine. So we install it seperate to avoid any conflicts.
Read and Post Comments
Next Page ยป