Hi,
I have already reached a dead end, although I am still at the
beginning of my project.
Perhaps somebody can help me out of this mess:
I am trying to write a tool to browse data in databases. Unfortunately
the database I am working with
is a ms-sql database which has german umlauts in its table- and cloumn
names. When reflecting tables from
this database I have to overwrite the columnames with ascii-names to
allow sqlalchemy to map the tables to classes.
sqlalchemy.convert_unicode is true and sqlalchemy.encoding is set to
cp1252.
So far so good.
Now I want to display my tables in a generic way:
[Controller]
c.table=table
column = request.GET.get('column')
c.columns = meta.metadata.tables.get(table).c
c.items =
meta.metadata.tables.get(table).select().order_by(column).limit(10).execute()
return render('/databrowse/table.html')
[View]
<table>
<tr>
% for column in c.columns:
<th>
<a href="${h.url_for(controller="databrowse", action="table",
table=c.table, column=column.name)}">${column.name}</a>
</th>
% endfor
</tr>
% for item in c.items:
<tr>
% for column in c.columns:
<td>${item[column.name]}</td>
% endfor
</tr>
% endfor
</table>
but routes produces some unicode error when calling
h.url_for(controller="databrowse", action="table", table=c.table,
column=column.name
in the template:
File 'c:\\TTL\\ttl\\controllers\\databrowse.py', line 29 in table
return render('/databrowse/table.html')
File 'c:\\python25\\lib\\site-packages\\pylons-0.9.6.1-py2.5.egg\
\pylons\\templating.py', line 343 in render
format=format, namespace=kargs, **cache_args)
File 'c:\\python25\\lib\\site-packages\\pylons-0.9.6.1-py2.5.egg\
\pylons\\templating.py', line 228 in render
**options)
File 'c:\\python25\\lib\\site-packages\\mako-0.1.8-py2.5.egg\\mako\\ext
\\turbogears.py', line 49 in render
return template.render(**info)
File 'c:\\python25\\lib\\site-packages\\mako-0.1.8-py2.5.egg\\mako\
\template.py', line 114 in render
return runtime._render(self, self.callable_, args, data)
File 'c:\\python25\\lib\\site-packages\\mako-0.1.8-py2.5.egg\\mako\
\runtime.py', line 287 in _render
_render_context(template, callable_, context, *args,
**_kwargs_for_callable(callable_, data))
File 'c:\\python25\\lib\\site-packages\\mako-0.1.8-py2.5.egg\\mako\
\runtime.py', line 304 in _render_context
_exec_template(inherit, lclcontext, args=args, kwargs=kwargs)
File 'c:\\python25\\lib\\site-packages\\mako-0.1.8-py2.5.egg\\mako\
\runtime.py', line 337 in _exec_template
callable_(context, *args, **kwargs)
File 'c:\\TTL\\data\\templates\\databrowse\\site.html.py', line 26 in
render_body
context.write(unicode(self.body()))
File 'c:\\python25\\lib\\site-packages\\mako-0.1.8-py2.5.egg\\mako\
\runtime.py', line 193 in <lambda>
return lambda *args, **kwargs:callable_(self.context, *args,
**kwargs)
File 'c:\\TTL\\data\\templates\\databrowse\\table.html.py', line 38 in
render_body
context.write(unicode(h.url_for(controller="databrowse",
action="table", table=c.table, column=column.name)))
File 'c:\\python25\\lib\\site-packages\\routes-1.7.1-py2.5.egg\\routes\
\util.py', line 189 in url_for
url = config.mapper.generate(*route_args, **newargs)
File 'c:\\python25\\lib\\site-packages\\routes-1.7.1-py2.5.egg\\routes\
\base.py', line 949 in generate
path = route.generate(**kargs)
File 'c:\\python25\\lib\\site-packages\\routes-1.7.1-py2.5.egg\\routes\
\base.py', line 544 in generate
(key != 'action' or key != 'controller')])
File 'C:\\Python25\\lib\\urllib.py', line 1250 in urlencode
v = quote_plus(str(v))
UnicodeEncodeError: 'ascii' codec can't encode character u'\xdf' in
position 6: ordinal not in range(128)
Can anybody explain me what I am doing wrong?
Thanks in advance!
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"pylons-discuss" group.
To post to this group, send email to pylons-discuss@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/pylons-discuss?hl=en
-~----------~----~----~----~------~----~------~--~---
