gmane.comp.python.web2py

Help on field default computed value

greenpoise — 2013-06-19T18:27:40

how come this returns null:

 Field('seriesnumber',compute=lambda r: '%s%s'% 
(r['id'],r['seriesname'][0:3]))

SQLFORM.factory and list:integer error

Martin Barnard — 2013-06-19T18:22:52

I'm trying to figure out why I get an error with the following code:

def index():
    ids=[]
    form=SQLFORM.factory(
        Field('employees', 'list:integer'),
    )
    if form.process().accepts:
        if form.vars.employees:
            for v in form.vars.employees:
                ids.append(v)


Generally gives me a typerror: 
<type 'exceptions.ValueError'> invalid literal for int() with base 10: ''
which is pointing to: web2py/gluon/dal.py, line 1779, in represent


172.16.180.10.2013-06-19.21-09-19.05836ac3-19f9-486a-9cae-a121a7c19593
<type 'exceptions.ValueError'> invalid literal for int() with base 10: ''
VERSIONweb2py™(2, 4, 2, 'stable', datetime.datetime(2013, 3, 4, 3, 26, 21))
PythonPython 2.7.3: /usr/bin/python (prefix: /usr)TRACEBACK

1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.

Traceback (most recent call last):
  File "/home/www-data/web2py/gluon/restricted.py", line 212, in restricted
    exec ccode in environment
  File "/home/www-data/web2py/applications/experiment/controllers/default.py" <https://172.16.180.11/admin/default/edit/experiment/controllers/default.py>, line 193, in <module>
  File "/home/www-data/web2py/gluon/globals.py", line 193, in <lambda>
    self._caller = lambda f: f()
  File "/home/www-data/web2py/applications/experiment/controllers/default.py" <https://172.16.180.11/admin/default/edit/experiment/controllers/default.py>, line 128, in index
    if form.accepts(request.vars):
  File "/home/www-data/web2py/gluon/sqlhtml.py", line 1528, in accepts
    self.vars.id = self.table.insert(**fields)
  File "/home/www-data/web2py/gluon/dal.py", line 8442, in insert
    ret =  self._db._adapter.insert(self, self._listify(fields))
  File "/home/www-data/web2py/gluon/dal.py", line 1199, in insert
    query = self._insert(table,fields)
  File "/home/www-data/web2py/gluon/dal.py", line 1190, in _insert
    values = ','.join(self.expand(v, f.type) for f, v in fields)
  File "/home/www-data/web2py/gluon/dal.py", line 1190, in <genexpr>
    values = ','.join(self.expand(v, f.type) for f, v in fields)
  File "/home/www-data/web2py/gluon/dal.py", line 1366, in expand
    return str(self.represent(expression,field_type))
  File "/home/www-data/web2py/gluon/dal.py", line 1779, in represent
    obj = map(int,obj)
ValueError: invalid literal for int() with base 10: ''

ERROR SNAPSHOT [image: help]

<type 'exceptions.ValueError'>(invalid literal for int() with base 10: '')

inspect attributes
Frames
   
   - 
   
   *File /home/www-data/web2py/gluon/restricted.py in restricted at line 212
   * code arguments variables
   - 
   
   *File 
   /home/www-data/web2py/applications/experiment/controllers/default.py in 
   <module> at line 193* code arguments variables
   - 
   
   *File /home/www-data/web2py/gluon/globals.py in <lambda> at line 193* 
   code arguments variables
   - 
   
   *File 
   /home/www-data/web2py/applications/experiment/controllers/default.py in 
   index at line 128* code arguments variables
   - 
   
   *File /home/www-data/web2py/gluon/sqlhtml.py in accepts at line 1528* 
   code arguments variables
   - 
   
   *File /home/www-data/web2py/gluon/dal.py in insert at line 8442* code 
   arguments variables
   - 
   
   *File /home/www-data/web2py/gluon/dal.py in insert at line 1199* code 
   arguments variables
   - 
   
   *File /home/www-data/web2py/gluon/dal.py in _insert at line 1190* code 
   arguments variables
   - 
   
   *File /home/www-data/web2py/gluon/dal.py in <genexpr> at line 1190* code 
   arguments variables
   - 
   
   *File /home/www-data/web2py/gluon/dal.py in expand at line 1366* code 
   arguments variables
   - 
   
   *File /home/www-data/web2py/gluon/dal.py in represent at line 1779* code 
   arguments variables
   Function argument list
   
   (self=<gluon.dal.BaseAdapter object>, obj=['4004', ''], 
   fieldtype='list:integer')
   Code listing
   
   1774.
   1775.
   1776.
   1777.
   1778.
   1779.
   
   1780.
   1781.
   1782.
   1783.
   
               elif not isinstance(obj, (list, tuple)):
                   obj = [obj]
               if field_is_type('list:string'):
                   obj = map(str,obj)
               else:
                   obj = map(int,obj)
   
           # we don't want to bar_encode json objects
           if isinstance(obj, (list, tuple)) and (not fieldtype == "json"):
               obj = bar_encode(obj)
           if obj is None:
   
   Variablesbuiltinint<type 'int'>obj['4004', '']builtinmap<built-in 
   function map>

Firebird migrations bug

Alexei Vinidiktov — 2013-06-19T16:28:48

Hello,

I'm using Firebird with my web2py powered app.

I've come across what I think to be a bug in migrations, namely dropping
columns migrations.

If I create a table definition, for example, like this:

db.define_table('card',
    Field('question', 'text', notnull=True),
    Field('answer','text', notnull=True)
    )

The table gets created, everything works fine.

But if I remove a Field definition (drop a column), like so:

db.define_table('card',
    Field('answer','text', notnull=True)
    )

The column gets dropped from the database, but I keep getting this error
message:

<class 'fdb.fbcore.DatabaseError'> ('Error while executing SQL
statement:\n- SQLCODE: -607\n- unsuccessful metadata update\n- column
QUESTION does not exist in table/view CARD', -607, 335544351)

And the sql.log shows that every time I load a page web2py tries to drop
the column that has been deleted thus causing this error.


timestamp: 2013-06-19T23:11:40.214366
ALTER TABLE card DROP question;
timestamp: 2013-06-19T23:11:58.635448
ALTER TABLE card DROP question;


My setup is like this: Mac OS X 10.8.4, Python 2.7.4, web2py 2.5.1,
Firebird 2.5 with the latest fdb driver. But I've come across the same bug
on Windows too.

To reproduce the bug define any table with a couple of columns, get web2py
to create it. Then remove a column definition from from the table
definition.

I've tried fake_migrate but it doesn't solve the problem. Once I remove
fake_migrate the error is back.

GAE 1.8.1 and logging doesn't work

José Manuel López — 2013-06-19T15:26:54

Hi!,
I've change to GAE 1.8.1 and suddenly (before, with GAE 1.7.5 everything 
worked ok) the LOG is not working. None of my debugs lines are dump to 
console. Then I've see that my logging.conf was not being used. This is my 
log config:

[loggers]
keys=root,rocket,markdown,web2py,rewrite,cron,app,welcome, myApp

[logger_myApp]
level=DEBUG
qualname=web2py.app.myApp
handlers=consoleHandler
propagate=0
and in my controller:
import logging
logger = logging.getLogger(request.application)
logger.setLevel(logging.DEBUG)

Anyone knows why this is happening  or any clue at least?
Any help will be very appreciated. 
Thank you in advance

SmartGrid

2013-06-19T15:25:58

I have a smartgrid set up like this:

def manage_patients():
    grid = SQLFORM.smartgrid(db.patient, deletable=True, editable=True, 
create=True, linked_tables=['emergencycontacts','dependents'])
    return dict(grid=grid)


It displays fine but only has a view button to the far right. How do I have 
the add, edit and delete buttons as well?

Thanks.

problem with a date in a form

palomar — 2013-06-19T13:34:52

I have a form that I submit by ajax and I have a problem with a date field.

in my db: 
db.define_table('fatture',
    Field('codice','string', length=10),
    Field('dataf', 'date'))

in my form:
<input id="dataf" name="dataf" type="date">
<input id="codice" name="codice" type="text">

ajax function:
ajax('inseriscifa',['codice','dataf'],':eval') 

controller:
def inseriscifa():      
    form = SQLFORM(db.fatture)
    if form.accepts(request.vars, formname=None):        
        return "alert('ok')"                            
    elif form.errors:
        return "alert('" + XML(TABLE(*[TR(k, v) for k, v in 
form.errors.items()])) + "')"

And, I don't understand why, I got an error about date format:
*enter date as 28/08/1963*

what's wrong? validors are great in web2py, but whit date a I have always 
problem...
s.

web2pyslices down

Johann Spies — 2013-06-19T10:51:26

I get a 404 error (Not found) when I try to access web2pyslices.com

Regards
Johann

Nested JSON vs Single JSON dataset

John Payne — 2013-06-18T18:47:12

Hello,

I'm trying to return some data via JSON to my view.  The problem i'm having 
is that when i do a left outer join, the JSON has two nested sets of data. 
 I'm trying to use SlickGrid which doesn't support complex fields like 
Set1.Field1 , Set2.Field1, etc...

Is there a way to return a single set of JSON data from my controller when 
joining tables?

From Controller:
rows = db().select(
            db.event.eventDesc
            ,db.event.dateCreated
            ,db.event.user_id
            ,db.eventType.eventTypeDesc
            ,db.eventType.id
            ,left=db.eventType.on(db.event.eventType==db.eventType.id))

Json recieved by View:
[{"eventType":{"eventTypeDesc":"Maintenance Action Required","id":2},"event"
:{"eventDesc":"Clean out the closet","user_id":1,"dateCreated":"2013-06-06 
15:02:25"}}] 


Json i would rather receive in View:
{"eventTypeDesc":"Maintenance Action Required","id":2,"eventDesc":"Clean 
out the closet","user_id":1,"dateCreated":"2013-06-06 15:02:25"}



Thanks

Ajax function and returning Row, not string

lesssugar — 2013-06-18T17:39:51

I'm building a cascading dropdown lists. I use web2py ajax function to do 
it. My code:

select 1 (parent):

<select class="generic-widget" id="seafarer_experience_department" 
name="department" 
onchange="jQuery('#seafarer_experience_rank__row').show('fast');ajax('rank', 
['department'], 'seafarer_experience_rank');">
    {{=OPTION('-- Choose department --', _value="")}}
    {{for d in departments:}}
        {{=OPTION(d.name, _value=d.id)}}
    {{pass}}
</select>

select 2 (child):

<select class="generic-widget" id="seafarer_experience_rank" name="rank">
    {{if request.vars.department:}}
        {{for r in ranks:}}
            {{=OPTION(r.name, _value=r.id)}}
        {{pass}}
    {{pass}}
</select>

controller function:

def rank():

    ranks = db(db.rank.department_id == 
request.vars.department).select(db.rank.id, db.rank.name, 
orderby=db.rank.name)

    return ranks

Ajax function calls *rank *function and passess value of the currently 
selected option in *department *select (parent). Then, the function assigns 
DAL query to *ranks *and returns it.

The thing is that *ranks *is a string when returned. My for loop in the 
select 2 is ommited and the its example result code looks like this:

<select class="generic-widget" id="seafarer_experience_rank" name="rank">
"rank.idrank.name137Chief Cook138Chief Steward139Cook 
Assistant140Messman136Second Cook141Steward"
</select>

So it LOOKS like a Row object but it's a string obvioulsy - and so I can't 
get any Row data out of it (r.name, r.id).

Begging for help her :)

How should we work to sync localhost development with GAE?

peibol — 2013-06-18T17:00:49

Hi all:

I've read the deployment recipes but I'm missing something... I've made a 
simple application with the plugin wiki. Then, I configure some pages and 
menus, working in my localhost. How should I proceed in order to deploy it 
to GAE while preserving all the data already set in the local database? 
Should I import table per table (manually or with a custom script)?

Cheers
Peibol

3 forms in 1

2013-06-18T15:40:40

I have one page where I want to show 3 forms. I have a main table with 2 
tables that are related to it. 

So in my models file I have:

db.define_table(
    'dependents',
    Field('dep_id',db.patient),
    Field('first_name'),
    Field('middle_name'),
    Field('last_name'),
    Field('relationship', 'text'))
    
db.define_table(
    'emergencycontacts',
    Field('ec_id',db.patient),
    Field('first_name'),
    Field('middle_name'),
    Field('last_name'),
    Field('address1'),
    Field('address2'),
    Field('city'),
    Field('state'),
    Field('zipcode'),
    Field('country'),
    Field('phone'),
    Field('relationship'))

And db.patient is another table.

So in my form I have:

def register_patient():
    form=SQLFORM.factory(db.patient,db.emergencycontacts, db.dependents)
    if form.process().accepted:
        id = db.patient.insert(**db.patient._filter_fields(form.vars))
        form.vars.patient=id
        id = 
db.emergencycontacts.insert(**db.emergencycontacts._filter_fields(form.vars))
        response.flash='Thanks for filling the form'
        id = db.dependents.insert(**db.dependents._filter_fields(form.vars))
        form.vars.dependents=id
        # and get a list of all persons
    records = 
SQLTABLE(db().select(db.patient.ALL),headers='fieldname:capitalize')

    return dict(form=form, records=records)

So the form displays correctly but I was expecting that the other fields 
for dependents and emergencycontacts would be there for input as well but I 
only get the id fields showing up for input.

Am I doing what I want to do incorrectly?

Thanks,

Tom

row.id with "L" after upgrading to

palomar — 2013-06-18T14:11:14

I've just updated to 2.5.1 and I found this problem:
Inside my site  have a google map and I need to add an array with several 
marker;
in my controller I have a simple query with a cycle
def mappa:
    markers=[]
    for row in db().select(db.produttori.ALL):
       markers.append([row.id, row.lat, row.lng])
return dict(markers=XML(*[markers]))

and I obtein ID + L, like this:
[1L, '12.5', '7.6']

so I need to do int(row.id)
In the older version worked well...
s.

PATCH: updates to browserid_account.py

Holger Schurig — 2013-06-18T13:46:42

1. browserid.org changed into login.persona.org, both URLs and issues. The 
old URL continues to work, but it might be better to use the new ones 
anyway.

2. the plugin did redirecto to http://google.com (Huh?!?!) even when 
"on_login_failure" was set

3. if on_login_failure wasn't set, it redirected to http://google.com, I 
now changed that it now redirects to login.persona.org


I ponder the idea if I change the plugin further, so that on_login_failure 
is a mandatory parameter when creating the BrowserID class instance. Also, 
there is currently no error reportion possible, i.e. the end-user will 
never see if the expiration date was wrong, the issuer was wrong etc. Maybe 
the kind of error should be sent somehow with the redirect?  (I'm still 
very new in web2py and don't exactly know how that could happen ...).

pymongo

Domagoj Kovač — 2013-06-18T11:47:02

Hi,

i would like to use mongoDB directly without DAL.

I added this to the bottom of my model/0.py

# connect to mongoDB
connection = pymongo.MongoClient('localhost', 27017)

# attach to test database
mongo = connection.asset


- this gives me an error
name 'pymongo' is not defined

if i add
import pymongo

# connect to mongoDB
connection = pymongo.MongoClient('localhost', 27017)

# attach to test database
mongo = connection.asset


then i get the error: 
Cannot import module 'pymongo'
What is worng?

Running application outside the web2py folder

Gouthaman Balaraman — 2013-06-18T05:54:03

Hey 
I started web2py by specifying the "applications" folder using --folder 
flag:

This started fine. But when I created a new application from the appadmin, 
the contents of the application were totally empty. Is this expected 
behavior? I am running version 2.5.1.

Thanks
Goutham

BUG: git commit 714fcc52 wreaked german umlaut characters

Holger Schurig — 2013-06-18T09:08:29

Hi, I'm exploring web2py from GIT together with a chrome browser.

When I open the admin, I get the presentation in the german language, 
because this is configured as one of the languages in Chromium (the 
non-google-branded version of Google Chrome). That's ok so far. 
Unfortunately, umlaut characters are show as "?", e.g. not "Über", but 
"?ber". Using Right-Mouse-Click -> Inspect Element, I can see that web2py 
incorrectly sends "<a href="/admin/default/about/examples">?ber</a>". 
Further investigation revealed that the ? characters are already in 
applications/admin/languages/de.py.

"git blame" told me that it was commit 714fcc52, "git show 714fcc52 | grep 
About" will show you an example.

Use reserved keywords of mysql

ajith c t — 2013-06-18T07:09:16

Hi,
     Is there is any update on the usage of reserved keywords in the table 
definition. In this thread 

https://groups.google.com/forum/?fromgroups=#!newtopic/web2py/web2py/hCsxVaDLfT4 Massimo 
says "we need to change it in dal.py."

I need to create a table in mysql db as:

    db.define_table('rms_rule', 
            Field('condition', 
requires=IS_IN_SET(['IsEqual','IsNotEqual','IsGreater','IsLesser','IsNull','IsNotNull','Likeliness','IsMatch','IsNotMatch','In'])),
    )

I tried with backticks(`) as mysql stats and different combinations of 
qoutes.

If I use it as given above the error is a mysql programming error:

ProgrammingError: (1064, "You have an error in your SQL syntax; check the 
manual that corresponds to your MySQL server version for the right syntax 
to use near 'condition VARCHAR(255),\n    description VARCHAR(255) NOT 
NULL,\n    params VARCHA' at line 13")

So it passed DAL but escaping might be the problem. But using the backticks 
as mysql says, it generates syntax error which is caught by DAL. 

db.define_table('rms_rule', 
            Field('`condition`', 
requires=IS_IN_SET(['IsEqual','IsNotEqual','IsGreater','IsLesser','IsNull','IsNotNull','Likeliness','IsMatch','IsNotMatch','In'])),
    )

SyntaxError: invalid table or field name: `condition`

is there any way in escaping these reserve keywords. Its difficult to 
change the field name as its already defined by third party in mysql.

The above thread was one year back.

DatePicker

2013-06-17T21:49:05

I am a bit confused on what I may be missing but how do I have a datepicker 
in my form?

My db.py:

b.define_table('patient', 
    Field('first_name', requires=IS_NOT_EMPTY()),
    Field('last_name', requires=IS_NOT_EMPTY()),
    Field('phone', requires=IS_NOT_EMPTY()),
    Field('date_of_birth', required=IS_DATE(), requires=IS_NOT_EMPTY()))

My Controller:

def display_your_form():
    form = SQLFORM(db.patient)
    return dict(form=form)

and my html:

<center>
<br /><br /><br />
<h1>Web Form</h1>
<br />
<h2>Inputs:</h2>
{{=form}}
<h2>Submitted variables:</h2>
{{=BEAUTIFY(request.vars)}}
</center>

Just doing this for example but was curious of there is more that I have to 
do to make this work so when a user selects date of birth the datepicker 
appears.

Thanks,

Tom

Datepicker

2013-06-18T01:22:15

I am following some examples and created a table with a date of birth 
field. In my form I cannot seem to get the datepicker set to show when 
selecting that field. Is there something special to do to get that to work 
like that?

Thanks

smartgrid reference problem

André Kablu — 2013-06-17T23:36:24

Hi all,

I am trying to create a grid with a query for auth_user table doing this:

def controller1():

    query = ((db.auth_user.id == db.auth_membership.user_id) &
             (db.auth_membership.group_id == 1))
    grid = SQLFORM.smartgrid(db.auth_user,
                             constraints=dict(auth_user=query
                                              ),
                             deletable=False,
                             editable=True,
                             create=False,
                             csv=False)
    return dict(grid=grid)

I am doing a constraint to filter only for members of group 1 in list... 
and it is working fine.

However when I try to click to any referenced table:


It shows this error:

<type 'exceptions.AttributeError'> 'Row' object has no attribute 
'first_name'
I already tried to separate queries in constraints like this:

    query1 = db.auth_membership.user_id == db.auth_user.id
    query2 = db.auth_membership.group_id == 1
    grid = SQLFORM.smartgrid(db.auth_user,
                             constraints=dict(auth_user=query1,
                                              auth_membership=query2
                                              ),
                             deletable=False,
                             editable=True,
                             create=False,
                             csv=False)

However it still return same error when clicking in one of the referenced 
tables.



Do anyone have an idea of what am I doing wrong?

SQLFORM.grid query widget not working

2013-06-17T20:58:44

Hi,
I started using web2py on Windows (with IE) but realized that I needed to 
use Linux (with Firefox).  SQLFORM.grids looked very nice on Windows, but 
now that I am using Linux, they look very plain, and more concerningly, do 
not seem to be working properly for me.  In particular, the query builder 
feature is not appearing when I click in the search bar.  Also, I noticed 
that if I execute a search query (writing the query string on my own since 
the query builder was not working), when I click the Clear button nothing 
happens--the search query is not cleared, the URL remains the same, and the 
rows displayed remain the same.  Am I missing something?  I checked and I 
have Firefox 17.0.5 if it makes a difference.  I would really like to be 
able to use the query string builder.
 
Thanks!