gmane.comp.python.web2py

sqlform.grid html text

CtrlSoft — 2012-05-26T18:58:44

hi, how to display in sqlform.grid -> view    html formated text?

i mean:  *someText lazy** fox*   instead of    <b>someText lazy 
<i>fox</i></b>

Wep2Py Database Tables

Horus — 2012-05-26T16:46:26

In the administrative section of your app there are the usual ACL tables. I 
realise there is a *acl_cas* table along with these tables. I am curious as 
to what this tables does?

Sending email with localhost / Postfix

Yarin — 2012-05-26T14:24:27

I'm trying to send email out of web2py via localhost and Postfix, but 
everything I try just fails silently. Having the same issue on my Mac OSX 
and CentOS6 server, each with Postfix installed and able to send emails 
from the command line.

I've played with variations of the following settings:

mail.settings.server='127.0.0.1:25' / 'smtp.localhost:25' / 'localhost' / 
'localhost:25'
mail.settings.sender='you-hcDgGtZH8xNBDgjK7y7TUQ< at >public.gmane.org'
mail.settings.login='' / False / None


Sending mail via gmail SMTP works fine, but I need local postfix capability

java class path

Marian Siwiak — 2012-05-26T13:28:42

Hello,

I am trying to add java applet to my application. I have problem with 
pointing the page to proper path. In and old thread I found Massimo's code 
like:

<applet code="jalview/bin/JalviewLite.class"
archive="/{{=request.application}}/static/jalviewApplet.jar" mayscript 
viewastext> <param name="file" 
value="/{{=request.application}}/static/alnfile"> <param 
name="defaultColour" value="Nucleotide"> </applet >

my question is: where does this path actually start? I have myJavaApp.call 
file and some config files, but I have no idea where to place them. 
JavaConsole says Java tries to search for them in:

network: Cache entry not found [url: 
http://127.0.0.1:8000/MyApp/default/some/furhter/path/myJavaApp.class

but I didn't find a way to place it there.

Help would be much appreciated.

best regards,
Marian

Trouble running from source

RKS — 2012-05-26T04:20:00

Docs say run python2.7 web2py.py in the terminal and all I can get is the 
error:

/Library/Frameworks/Python.framework/Versions/2.7/Resources/Python.app/Contents/MacOS/Python: 
can't open file 'web2py.py'

Maybe I put it in the wrong place where it can't find it?

anybody ever try to do modal registration using only web2py and recaptcha?

weheh — 2012-05-25T23:56:52

I'm trying to do modal registration with a custom form, recaptcha, and an 
ajax follow-through after processing. Recaptcha may have sunk this 
approach. Can you suggest a secure alternative that works better with 
jQuery? Or perhaps give your account of how to do modal registration in 
web2py?

Stripe javascript and form

james c. — 2012-05-25T23:07:33

Thanks for including Stripe APIs in Web2Py.
 
Stripe provides from its' Web site a form and javascript template that 
collects, clients browser, the credit card information, ships it off to 
stripe for validation, and then returns the validated
credit card information as a token via a post to the Web2Py controller.
 
This script looks like it is generating superfish related errors, and it 
looks like there are errors related to where the script wants return the 
token.
 
Has anyone used the Stripe script with Web2Py? Or, was Stripe API for 
Web2PY tested assuming a client form is just going to collect the credit 
card information and return that to the controller?
 
thanks in advance for any recommendations, James

How to never return html?

bob — 2012-05-25T22:55:17

Probably a simple question and I searched both the docs and the group.

I have a path  /api  and I never want to return a html reply,  I'm ok with 
a .xml or .json reply and would like to have the default be .xml

The big issue is that I want other urls (i.e.  /default/) to return html as 
the default.

thanks,
bob

Scheduled Tasks and Google App Engine

Umpei Kurokawa — 2012-05-25T20:49:15

How do you guys schedule tasks for web2py apps using Google App Engine? 

I haven't had luck trying to get web2py's  cron or scheduler to work for 
some reason, 
but Google App Engine's own cron engine seems to be working fine.

4th Edition manual RSS example problems

Jarrod Wilcox — 2012-05-25T17:58:20

The overview chapter adds an RSS facility to the mywiki example.  The 
example code seems to contain typo errors:  "form" instead of "from" and 
"reponse" instead of "response", but that may not be a serious issue.

When these are "corrected", the result of serving mywiki/default/news.rss 
is a page of text rather than the picture shown in the manual.

This appears:

<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0"><channel><title>mywiki rss feed</title><link>http://127.0.0.1:8000/mywiki/default/index</link><description>mywiki news</description><lastBuildDate>Fri, 25 May 2012 13:41:48 GMT</lastBuildDate><generator>PyRSS2Gen-1.0.0</generator><docs>http://blogs.law.harvard.edu/tech/rss</docs><item><title>Pig Latin</title><link>/mywiki/default/show.rss/1</link><description>&lt;p&gt;Ancay ouyay eakspay igpay atinlay?&lt;/p&gt;</description><pubDate>Fri, 25 May 2012 12:02:44 GMT</pubDate></item></channel></rss>


My question is what do do to get the correct result.  All code was cut and 
paste from the e

Can't import a module

Yarin — 2012-05-25T19:19:08

For the first time I'm having trouble importing a module in web2py that 
imports normally elsewhere. I can't understand why this would be so.

I'm trying to use the SendGrid Python API.  I have the sendgrid library in 
my modules folder like all my other modules, and I was trying to import per 
the sample code, but get a 
<type 'exceptions.NameError'> name 'sendgrid' is not defined
error.

But when I do the same import from a flat file using the command line, it 
runs fine.

Here is my controller code, and the sendgrid library is here<https://github.com/sendgrid/sendgrid-python/tree/master/sendgrid>
.

def test():
    import sendgrid

    return 'import worked'

'dict' object is not callable in RSS example from web2py book ch. 3

Thomas Le — 2012-05-25T18:28:04

Hey guys,

Ran into an issue: I copied and pasted the following example from the RSS 
section of chapter 3:
(I changed "reponse.generic_patterns" to "response.generic_patterns", I 
think it's a typo)

def news():
    "generates rss feed form the wiki pages"
    reponse.generic_patterns = ['.rss']
    pages = db().select(db.page.ALL, orderby=db.page.title)
    return dict(
       title = 'mywiki rss feed',
       link = 'http://127.0.0.1:8000/mywiki/default/index',
       description = 'mywiki news',
       created_on = request.now,
       items = [
          dict(title = row.title,
               link = URL('show', args=row.id),
               description = MARKMIN(row.body).xml(),
               created_on = row.created_on
               ) for row in pages])


And I get back the following error when I run that controller function:

*'dict' object is not callable*


I believe it breaks here:

                    items = [rss2.RSSItem(
                title=entry.get('title','(notitle)'),
                link

Bootstrap modal and ajax

Annet — 2012-05-25T18:14:50

In a controller I have the following functions:

def eventList():
    response.view='calendar/eventList.html'
    rows=db(..).select(...)
    if not rows:
        response.flash=response.flash_noresult
    return dict(rows=rows,alert=alert)

def event():
    response.view='calendar/event.html'
    
row=db(db.EventList.id==request.args(0)).select(db.EventList.ALL).first()
    return dict(row=row)


In the index.html view I have the following menu:

<ul class="nav">
  <li class="active"><a data-toggle="pill" 
onclick={{="web2py_component('%s','component-pane')"
  %URL('addressbook','contact.load',args=session.id)}}>Home</a></li>
  <li><a data-toggle="pill" 
onclick={{="web2py_component('%s','component-pane')"
  
%URL('calendar','openingHours.load',args=session.id)}}>Openingtijden</a></li>
  <li><a data-toggle="pill" 
onclick={{="web2py_component('%s','component-pane')"
  %URL('calendar','eventList.load',args=session.id)}}>Event list</a></li>
 </ul>


and component-pane:
  
<div class="row-fluid">
  <div class=

More DB issues

Bruce Wade — 2012-05-25T18:08:35

<class 'psycopg2.extensions.TransactionRollbackError'> deadlock detected
DETAIL: Process 20969 waits for ShareLock on tuple (10,126) of relation
16935 of database 16386; blocked by process 20615. Process 20615 waits for
ShareLock on transaction 19960600; blocked by process 20124. Process 20124
waits for ExclusiveLock on tuple (10,126) of relation 16935 of database
16386; blocked by process 20969. HINT: See server log for query details.
CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."ads" x WHERE "id"
OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"Any suggestions?

compute not working on update

peter — 2012-05-25T17:50:33

I am using web2py 1.99.7 

I have a compute as

db.image.thumb.compute=lambda r:THUMB(r['file'])


I update the whole database 

def update_images():
    rows=db(db.image).select()
    for row in rows:
        row.update(title=row.title)
    db.commit()


Yet, the computes have not occurred.

Similarly if I edit a record and submit, no compute. Yet if I add a record, 
the compute does take place.

Anyone any ideas why?

Thanks
Peter

delete row question

Roberto Perdomo — 2012-05-25T16:19:37

Hi,

I have a single question,

There is a way to run a feature automatically when you delete a record
from a particular table?

Questions for an application with a large number of features and a large database.

David McKeone — 2012-05-25T13:54:18

I've been reviewing Web2py over the last month so that I could evaluate it 
for use with a large-ish commercial application.  This has brought up a few 
questions, so I figured I'd see if anyone has any experience in any of the 
areas I've run into trouble.  I come from a C++ background so I'm fairly 
new to Python (and web2py by extension), but I've been a professional 
programmer for ~10 years, so I have a good general understanding how to 
handle the scale of the application, now I'm just after how to do those 
things in web2py and it's associated Python toolchain.

Hopefully this post will also be a summary of some of the knowledge I've 
found through this group.  

Here are the tools I'm going to be using (Fairly common I would think...):
- PyCharm <http://www.jetbrains.com/pycharm/> 2.5 IDE
- Nose <http://nose.readthedocs.org/en/latest/> for tests
- Jenkins <http://jenkins-ci.org/> for continuous integration (CI)<http://en.wikipedia.org/wiki/Continuous_integration>
- Git <http://git-scm.com/> for versi

Forms with horizontal fields

orsomannaro — 2012-05-25T13:45:21

I'm starting with Web2Py.

I have a model with a large number of fields and I need to display them 
all together in the view.

To arrange/group them logically I need to display them in a horizontal way.

In some cases I need to hide some of these fields, depending on users 
rights.


How can I do this?


Is there a way to create different custom div-based forms layout for a 
single model and let the controller to decide which one to use in the views?


Thank you

recaptcha in LOAD

weheh — 2012-05-25T13:24:34

I'm having trouble getting recaptcha to appear inside a LOAD. I've read 
various threads on the topic but am not sure I know what the last word is 
in how to do this. Anybody familiar with the topic?

Facing the trouble in ajax request

Sanjeet Roy — 2012-05-25T09:15:09

When i make request from the drop down by using onchange event with ajax 
call it only return the first word on my target suppose:-

I am showing the White Cat in drop down on the html page using the list[] 
which are returned from the controller but when i make the ajax call by 
using onchange event its return only the White on my target but i want the 
whole value (White Cat) how it will be possible?

apostrophe in db and text area

Cédric Mayer — 2012-05-25T08:35:30

Hello !
I have a table with "text" fields:
    Field('f_comments', type='text',
          label=T('Comment')),
or even:
    Field('f_form', type='text',
          label=T('Form'), comment=T('Please write HTML here')),
Using appadmin interface, if I use an apostrophe " ' " inside the textarea 
fields and submit the record form, the apostrophe saved, and if I display 
the appadmin form for the same record again, they are displayed inside the 
textarea fields.

But creating my own form:
    form = SQLFORM(db.t_question, record, deletable=True)
apostrophes " ' " do not appear anymore.

I did some copy-paste of what was inside my own textarea to an hexadecimal 
editor, and the apostrophe are replaced with the # 27 (hexa 1B) character 
in the case of my own form.

If I save the form as-is, this 1B character is saved too, and so the 
apostrophe disappears also if I look to the record from the appadmin 
interface.

It is really anoying as I use the content of the fields as pure HTML 
afterwards : not having apostrop