gmane.comp.python.web2py

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 examples in the online version of the manual.

Jarrod

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=entry('link',None),
                description=entry.get('description',''),
                pubDate=entry.get('created_on', now)
                ) for entry in feed.get('entries',[])])


In web2py/gluon/serializers.py in rss at line 107

I'm running version 2.0.0 (2012-05-16 18:23:15) dev

Can anyone tell if either this is a bug, or an error on my end?

Thanks for the help,
Thomas

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="span12">
    <div class="component-pane">
      
{{=LOAD('addressbook','contact.load',args=session.id,ajax=True,target='component-pane')}}
    </div> <!-- /component-pane -->
  </div><!-- /span -->
</div><!-- /row -->


In the eventList.html view I have the following code:

<script type="text/javascript">

  $("a[data-toggle=modal]").click(function (e) {
  target = $(this).attr('data-target')
  url = $(this).attr('href')
  $(target).load(url);
  })
  
</script>

{{if rows:}}
  <table>
    <tbody>
      {{for row in rows:}}
        ..
      {{pass}}
      </tbody>
    </table>
   </div> <!-- /results -->
{{pass}}

<div class="modal hide fade" id="myModal">
</div> <!-- /modal -->


In this case the modal window open without problem and displays the event 
details.

However, when I replace the menu with:
<ul class="nav">
  <li class="active"><a 
href="{{=URL('addressbook','contact',args=row.id)">Home</a></li>
  <li><a 
href="{{=URL('calendar','openingHours',args=row.id)">Openingtijden</a></li>
  <li><a href="{{=URL('calendar','eventList',args=row.id)">Event 
list</a></li>
 </ul>

And keep the views the same, the modal window pops up but remains empty. 
When I add a static text to;

<div class="modal hide fade" id="myModal">
  <p>This is a static text.</p>
</div> <!-- /modal -->

The modal window pops up and displays the static text.

What is the difference between these approaches and how do I get the event 
details displayed in the modal window?


Kind regards,

Annet.

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 version control

I won't go into too much detail about the actual application, but to give a 
little bit of background about the scope of the problem: it is a deployed 
app and the database has just under 100 tables and can reach sizes of 
~40GB.  In this theoretical use of web2py there would be 1 copy of web2py 
and 1 copy of my application for each database.  The project would also 
have multiple developers coding against the same code base with a fairly 
quick release cycle (hence, code quality, testing, CI and Git are all 
paramount)

So, after that long intro, here are the pain points I've run into:

   1. Getting nose tests running was a bit of a challenge, and it seemed to 
   expose an area that may be missing from web2py for large-ish applications
      - Referencing Nico de Groot's excellent web2py slice<http://www.web2pyslices.com/slice/show/1465/unittesting-doctesting-and-userinterface-testing>I was able to get testing going with UnitTest.  This gave me a good idea of 
      how automated testing could be done with web2py, but I really wanted to use 
      nose tests.
      - That led me to the Sahana Eden <http://eden.sahanafoundation.org/>code base (the only large web2py application that I'm aware of that looks 
      comparable to the application I'd like to build).  Referencing their 
      modules/test_utils/run.py<http://eden.sahanafoundation.org/browser/modules/test_utils/run.py>, 
      tests/nose.py <http://eden.sahanafoundation.org/browser/tests/nose.py>and 
      modules/test_utils/Web2pyNosePlugin.py<http://eden.sahanafoundation.org/browser/modules/test_utils/Web2pyNosePlugin.py>files I was able to get nose tests running (and they put out coverage and 
      xunit for Jenkins too!).  Cool.
      - Those first two bullets took some time and it really made me 
      wonder... I see that web2py itself uses nose tests (seemingly an admission 
      that at least one web2py developer sees value in nose) and yet us lowly 
      web2py application developers are relegated to (what I've seen to be) an 
      official stance that we should be using doctests for all our tests with 
      web2py.  Why is there not better support for automated unit testing?  Have 
      I completely missed some documentation or recommendation somewhere?
         - Why can I do this: python web2py.py --run_system_tests
         - But I can't do this to test my application?: python web2py.py 
         --run_tests -M -S myapp   
         - or this for use with TDD<http://en.wikipedia.org/wiki/Test-driven_development>?: 
         python web2py.py --run_tests -M -S myapp -R 
         applications/myapp/tests/controllers/user.py  (Modelled after how Sahana 
         Eden had their test directory structure setup)
      - This isn't really the fault of web2py, but even with my solution I 
      am still unable to use PyCharm's built-in nose testing support, since they 
      have their own test harness and, as far as I know, that isn't compatible 
      with web2py.py (Go vote for web2py support<http://youtrack.jetbrains.com/issue/PY-1648>if you haven't please!) 
   2. All models are loaded for each request
      - Loading all ~100 table models took ~3 seconds per request.
      - After reviewing this group I believe I understand why this is, but 
      I do lament the fact that the model terminology will be inaccurate.  I will 
      have to load all my "real" models into seperate modules<http://movu.ca/demo/article/show/11/model-less-apps-using-data-models-and-modules-in-web2py> (Thanks 
      for your great post about doing it though Bruno!) and the end result is 
      that in any app of significant size, models will actually mean "request 
      startup/initialization" and ../modules/datamodels will be my "real" models. 
       
   3. No first-class PyCharm support
      - This IDE is really quite great (love the debugger, coverage, git 
      and lint checks), did I mention that you should go vote for web2py 
      support <http://youtrack.jetbrains.com/issue/PY-1648>?
      - In any case, using the if 0: import hints<http://kollerie.wordpress.com/2009/04/07/setting-up-your-ide-for-web2py-development/>and adding both the web2py directory and my application's directory to the 
      PYTHONPATH within my PyCharm project allowed all the lint checks to pass 
      (very handy to have the little red/yellow/green square in the top-right as 
      a sanity check while you code)
   4. Jenkins, web2py folder and application folder
      - Has anyone done Jenkins testing of your application with web2py and 
      nose/unitest?  What's the process here? (Here is my best guess)
         - Use Jenkins Git to retrieve my application into a dedicated 
         folder -- /myapp
         - Download zip of web2py source and decompress it into a folder -- 
         /web2py
         - Move application source into web2py applications - 
         /web2py/applications/myapp
         - Run nose tests with coverage and output XUnit compatible xml for 
         Jenkins consumption
      
Since this was a fairly lengthy post, thanks for getting to this point and 
I appreciate any answers you may be able to provide!  Keep in mind that my 
assertions are intended to be the viewpoint of someone who has come to the 
project with fresh eyes and and a non-Python programming background.  If 
I've attacked any purposeful design decisions, then that was not my 
intention.  The vast majority of web2py looks like it will be very easy to 
use; it's just some of this peripheral testing & infrastructure stuff that 
has presented challenges.

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 apostrophes leads to errors if I try to have some 
Javascript in those fields.

1) What is the difference between the form generated in appadmin, and the 
one generated by SQLFORM ?
2) Is there a way not to escape " ' " in text fields ?

{{=LOAD}} functionality

Annet — 2012-05-25T07:07:35

I have a view site/index.html which extends site/generic.html which extends 
scaffold.html.

scaffold.html contains the <head></head> and <body></body> tags. The body 
only contains {{inlcude}}

site/generic.html contains the site header and footer and a 
<container></container> tag containing {{include}}

I have groups of functions, these groups are menu items in a navigation 
bar. I'd like the dropdown menus to have ajax functionality, so in the code 
that renders the dropdown menus I have:

<a onclick="web2py_component('{{=_link}}', 'component-pane')">{{=_name}}</a>

which renders the following items:

<a onclick="web2py_component('/bootstrap/calendar/openingHours/283', 
'component-pane')">Opening hours</a>


The problem is that I don't know where to put the component-pane:

<div id="component-pane"
  <div class="row-fluid">
    <div class="span7">
      {{=LOAD()}}
    </div> <!-- /span -->
    <div class="span5">
    </div> <!-- /span -->
  </div> <!-- /row -->
</div> <!-- /component-pane -->

and what to put in the {{=LOAD()}}, for initially there is nothing to load, 
this depends on which item in dropdown menu is being clicked.


Regards,

Annet

A Web2py CMS like Joomla ?

Andrew — 2012-05-25T03:54:54

There have been numerous posts on a web2py based cms, and I know there are 
many solutions out there, at varying stages of development.   They each 
have a different focus so it is not a simple question of "which one is 
best".  I won't try and mention them by name.

However,  A colleague of mine was talking about Joomla and I wanted to be 
able to offer some "strategy" on a comparable web2py cms.   Would anyone 
care to comment on which of the web2py cms' would be a contender to Joomla 
?  If not now, perhaps with a roadmap for the future.

Personally, and I've said it before,  cms functionality is very important, 
and I think we should highlight the cms offerings on the web2py website.  
Not necessarily one, but showcase the "best of ...".    For example, look 
at http://www.zope.org/the-world-of-zope   It mentions Plone and Silva.  
Such a thing would also strenghten the adopton of web2py.  Are they 
production ready enough to do that ?

Thankyou.

Andrew W