[web2py] Paypal integration and reservation system

2014-07-18 Thread ceriox
Hi
i need to implement a reservation system:


   - the user can accept a reservation and the system must block the 
   moneys
   - After x times (for example 1 week) my software can abort the payment 
   and the user have the money back
   - After x times (for example 1 week) my software can accept the payment 
   and accept the money

anyone can help me or have any example?

thanks for help

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] Paypal integration and reservation system

2014-07-18 Thread Vasile Ermicioi
https://developers.braintreepayments.com/javascript+python/sdk/overview/how-it-works


On Fri, Jul 18, 2014 at 11:09 AM, ceriox cer...@gmail.com wrote:

 Hi
 i need to implement a reservation system:


- the user can accept a reservation and the system must block the
moneys
- After x times (for example 1 week) my software can abort the payment
and the user have the money back
- After x times (for example 1 week) my software can accept the
payment and accept the money

 anyone can help me or have any example?

 thanks for help

 --
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 ---
 You received this message because you are subscribed to the Google Groups
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to web2py+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] Paypal integration and reservation system

2014-07-18 Thread ceriox
thanks for your reply, but i can't understand well ... i'm not a good 
programmer, do you have a working example?


Il giorno venerdì 18 luglio 2014 11:25:19 UTC+2, Vasile Ermicioi ha scritto:


 https://developers.braintreepayments.com/javascript+python/sdk/overview/how-it-works


 On Fri, Jul 18, 2014 at 11:09 AM, ceriox cer...@gmail.com javascript: 
 wrote:

 Hi
 i need to implement a reservation system:


- the user can accept a reservation and the system must block the 
moneys 
- After x times (for example 1 week) my software can abort the 
payment and the user have the money back
- After x times (for example 1 week) my software can accept the 
payment and accept the money 

 anyone can help me or have any example?

 thanks for help

 -- 
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 --- 
 You received this message because you are subscribed to the Google Groups 
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to web2py+un...@googlegroups.com javascript:.
 For more options, visit https://groups.google.com/d/optout.




-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Direct editing inside a grid

2014-07-18 Thread Serge Bourgeois
Hello,

I could sort it out...

For those who could be interrested, here under the key elements of my 
solution.

1. In the model, create the following functions (here for string and drop 
list):

def options_widget(field,value,**kwargs):
return 
SQLFORM.widgets.options.widget(field,value,_class=generic-widget,**kwargs)

def string_widget(field,value,**kwargs):
return 
SQLFORM.widgets.string.widget(field,value,_class='string',**kwargs )


In the controller, in the function that you want to contain the editing 
grid:
def my_function_name(): # here my tale name = t_txw_expense_template
if len(request.post_vars) 0:
for key, value in request.post_vars.iteritems():
(field_name,sep,row_id) = key.partition('_row_') # field_name 
will look like field_name_row_99
if row_id:
db(db.t_txw_expense_template.id == 
row_id).update(**{field_name:value})
   # the name of the attribute is used to know which row is involved

# for each field that you want to see:

db.t_txw_expense_template.f_expense_template.represent = lambda value, 
row: string_widget(db.t_txw_expense_template.f_expense_template, value,

  **{'_name':'f_expense_template_row_%s' % row.id})

db.t_txw_expense_template.f_header.represent = lambda value, row: 
string_widget(db.t_txw_expense_template.f_header, value,   

  **{'_name':'f_header_row_%s' % row.id})

db.t_txw_expense_template.f_project.represent = lambda value, row: 
options_widget(db.t_txw_expense_template.f_project, value,   

  **{'_name':'f_project_row_%s' % row.id})

 # and so on...
 form = SQLFORM.smartgrid(db.t_txw_expense_template, # and so on...
# selectable = dict(t_txw_expense_template= 
None)
 selectable= lambda ids : 
redirect(URL('my_function_name',vars=request._get_vars)),   
   
 )
  #remove selectable's checkboxes
form.elements(_type='checkbox',_name='records',replace=None)
return dict (form = form)
Hope this can help...

Le jeudi 17 juillet 2014 21:57:12 UTC+2, Anthony a écrit :

 I don't have time to look into it, but seeing some code and a traceback 
 might help.

 Anthony

 On Thursday, July 17, 2014 12:18:39 PM UTC-4, Serge Bourgeois wrote:

 Thanks Antony!. Do you know if there is any plan to develop such a 
 feature? If yes, do you have any idea of availability ? 

 Still a third question: I tried the idea proposed here : 


 http://www.web2pyslices.com/slice/show/1928/basic-inline-editing-in-sqlformgrid-no-plugin-no-javascript

 but, I got a message saying that I couldn't change the objects already 
 existing ... (I guess the name of the fields, even with migrate == False). 

 Maybe you have any good idea to turn around this issue?

 Serge
  

 Le jeudi 17 juillet 2014 17:21:05 UTC+2, Anthony a écrit :

 This is not available out of the box, though it would be nice.

 Anthony

 On Thursday, July 17, 2014 10:25:20 AM UTC-4, Serge Bourgeois wrote:

 Hello,

 In order to simplify the user interface of basic controller functions, 
 I want to offer direct editing in SQLFORM.smartgrid, using the same 
 widgets 
 (string, options, uploads, ...) than those available in create or edit. 

 Maybe, I missed the point in the doc?

 Thank you for any advice.

 Serge



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] links in admin when using more than one domain / autoroutes

2014-07-18 Thread lyn2py
Not a major gripe, but perhaps something could be improved?

I am using *scripts/autoroutes.py* and in the admin, all my apps appear to 
link to *http://ip or domain/index* (it's the same address) for all the 
apps. If it isn't a major thing to accomplish within web2py, I would like 
to suggest perhaps the correct links could be displayed instead of the same 
address. For instance:

#routes.conf

abc.com /abc/default
xyz.com /xyz/default
… (5 apps or more)

In web2py admin,

*abc* app - *abc.com/index* instead of *http://ip or domain/index*
*xyz* app - *xyz.com/index* instead of *http://ip or domain/index*

As my setup is stable, I have yet to test if the parametric router would 
work for the admin links

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: error(10053, 'An established connection was aborted by the software in your host machine')

2014-07-18 Thread Dmitry Ermolaev
in web2py shell, when I open DB urls:
http://127.0.0.1:8000/ipay/appadmin
this error occurred ((

sometimes mySQL rise this error in random
and I restart server (Windirs server 2008 R2)
than all work fine about 2-3 days
than error occure again (

среда, 16 июля 2014 г., 15:45:15 UTC+4 пользователь Massimo Di Pierro 
написал:

 This is not the problem. You should not close connections in web2py. 
 web2py may need to recycle them in the connection pool.
 Can you connect to your database via other means? For example the python 
 shell or the web2py shell?




-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Weird bug using a computed field and then having an update using expressions

2014-07-18 Thread Leonel Câmara
Thanks Anthony for the detailed explanation. It makes sense, but I think 
this is an example of a leaky abstraction - I shouldn't have to care. Maybe 
the DAL could delay computed fields until after insertion if it detects an 
Expression.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Web2py Deployment Script for Ubuntu 14.04

2014-07-18 Thread Auden RovelleQuartz
This recipe which had worked:

{
One step production deployment

Here are some steps to install apache+python+mod_wsgi+web2py+postgresql 
from scratch.

On Ubuntu:

wget http://web2py.googlecode.com/hg/scripts/setup-web2py-ubuntu.sh
chmod +x setup-web2py-ubuntu.sh
sudo ./setup-web2py-ubuntu.sh

}

*no longer works when using the Ubuntu 14.04 operating system.*

Instead of getting the default web2py welcome application (when you type 
in the IP address on the browser), an Apache default page is displayed.

returning to Ubuntu 12.04 operating system fixed the issue (the deployement 
recipe worked on that older Ubuntu version)

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Weird bug using a computed field and then having an update using expressions

2014-07-18 Thread Anthony
Could get complicated. Feel free to submit a pull request.

On Friday, July 18, 2014 8:04:47 AM UTC-4, Leonel Câmara wrote:

 Thanks Anthony for the detailed explanation. It makes sense, but I think 
 this is an example of a leaky abstraction - I shouldn't have to care. Maybe 
 the DAL could delay computed fields until after insertion if it detects an 
 Expression.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Weird bug using a computed field and then having an update using expressions

2014-07-18 Thread Leonel Câmara
I'm not comfortable enough with the DAL code base to do this kind of, in 
part, architectural change. I would probably change _listify to return both 
newfields.values() and the to_compute list instead of computing it. Then 
only after updating/inserting would I calculate the compute fields.

This change would also fix another leaky abstraction - you having to 
update fields that are not actually being updated just because you need 
them in the compute function.

Doing these changes would probably fix all the problems I see people having 
in this user group with computed fields.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Weird bug using a computed field and then having an update using expressions

2014-07-18 Thread Anthony
The problem is that updates do not involve pulling the existing records 
from the database into web2py, so web2py doesn't have access to the 
existing field values (nor does web2py know which fields are needed by the 
compute function). Also, because computed field values could be different 
for each record, you cannot simply issue a single database update but 
instead must iterate over each record and do individual updates. So, for 
updates to tables with computed fields, we would have to first do the 
database update, then select all the records in the set, then loop over the 
records and call update_record on each record. This wouldn't necessarily be 
needed all the time, so maybe could be triggered via a new recompute 
argument to .update():

db(query).update(field1='newvalue', recompute=True)

Anthony

On Friday, July 18, 2014 8:47:14 AM UTC-4, Leonel Câmara wrote:

 I'm not comfortable enough with the DAL code base to do this kind of, in 
 part, architectural change. I would probably change _listify to return both 
 newfields.values() and the to_compute list instead of computing it. Then 
 only after updating/inserting would I calculate the compute fields.

 This change would also fix another leaky abstraction - you having to 
 update fields that are not actually being updated just because you need 
 them in the compute function.

 Doing these changes would probably fix all the problems I see people 
 having in this user group with computed fields.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Weird bug using a computed field and then having an update using expressions

2014-07-18 Thread Leonel Câmara
I like it! That would allow web2py to keep the old behaviour (so backwards 
compatible) of computing before updating, when possible, but allow us to 
force a more complete recomputation when necessary.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Weird bug using a computed field and then having an update using expressions

2014-07-18 Thread Anthony
If you don't mind, maybe add a Google Code issue and link to this thread.

Anthony

On Friday, July 18, 2014 9:17:47 AM UTC-4, Leonel Câmara wrote:

 I like it! That would allow web2py to keep the old behaviour (so backwards 
 compatible) of computing before updating, when possible, but allow us to 
 force a more complete recomputation when necessary.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Weird bug using a computed field and then having an update using expressions

2014-07-18 Thread Leonel Câmara
That I can do!

Submitted here:
https://code.google.com/p/web2py/issues/detail?id=1951thanks=1951ts=1405691098

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] How do I serve static files with caching

2014-07-18 Thread Sarbjit
Hi,

In my application, there are few static images which needs to be visible 
for all pages.

Currently, I am serving these files using the below code

img src={{=URL(r=request,c='static/images',f='image1.jpg')}} alt= /

Q1 :- Is it the right way to serve the image file?

Q2 :- How could I enable caching for these static files? Please note, I am 
using fast_download technique for database uploaded images, but I am not 
sure on if this can be used and how can be used?


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: How do I serve static files with caching

2014-07-18 Thread Anthony
On Friday, July 18, 2014 10:21:59 AM UTC-4, Sarbjit wrote:

 Hi,

 In my application, there are few static images which needs to be visible 
 for all pages.

 Currently, I am serving these files using the below code

 img src={{=URL(r=request,c='static/images',f='image1.jpg')}} alt= /

 Q1 :- Is it the right way to serve the image file?


URL('static', 'images/image1.jpg')
 

 Q2 :- How could I enable caching for these static files? Please note, I am 
 using fast_download technique for database uploaded images, but I am not 
 sure on if this can be used and how can be used?


The browser will cache your static files. No need to cache on the server, 
as they are not generated dynamically.

Anthony

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: How do I serve static files with caching

2014-07-18 Thread Sarbjit
Thanks Anthony for quick response.

Are you saying if I use the URL with the mentioned syntax, then browser 
will cache static files automatically?

Because the fast_download technique that I used (picked from web2py 
application development cookbook) enables browser cache for database 
uploaded images.

-Sarbjit

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: How do I serve static files with caching

2014-07-18 Thread Niphlod




 The browser will cache your static files. No need to cache on the server, 
 as they are not generated dynamically.



sadly it won't. For a debatable design decision, static files are not 
served with cache headers.
the correct way to enable far in the future cache headers and avoid 
multiple 304s is to use static versioning, i.e. 

  URL('static', '_1.2.3/images/image1.jpg')

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: How do I serve static files with caching

2014-07-18 Thread Anthony
I should have been more precise. The browser will cache the static files 
and re-use them, but it will still send requests to the server to check 
whether the cached version has expired (if not expired, the server will 
send a 304 response indicating the cached version is still current, so the 
entire file will not be re-sent). This assumes you are using web2py to 
serve the static files (as opposed to configuring your web server to do so 
directly).

Anthony

On Friday, July 18, 2014 10:56:41 AM UTC-4, Niphlod wrote:



 The browser will cache your static files. No need to cache on the server, 
 as they are not generated dynamically.



 sadly it won't. For a debatable design decision, static files are not 
 served with cache headers.
 the correct way to enable far in the future cache headers and avoid 
 multiple 304s is to use static versioning, i.e. 

   URL('static', '_1.2.3/images/image1.jpg')


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] Web2py Deployment Script for Ubuntu 14.04

2014-07-18 Thread Richard Vézina
You can update the script if you can.

Must be a couple of package renamed from Ubuntu side...

:)

Richard


On Fri, Jul 18, 2014 at 8:14 AM, Auden RovelleQuartz oves@gmail.com
wrote:

 This recipe which had worked:

 {
 One step production deployment

 Here are some steps to install apache+python+mod_wsgi+web2py+postgresql
 from scratch.

 On Ubuntu:

 wget http://web2py.googlecode.com/hg/scripts/setup-web2py-ubuntu.sh
 chmod +x setup-web2py-ubuntu.sh
 sudo ./setup-web2py-ubuntu.sh

 }

 *no longer works when using the Ubuntu 14.04 operating system.*

 Instead of getting the default web2py welcome application (when you type
 in the IP address on the browser), an Apache default page is displayed.

 returning to Ubuntu 12.04 operating system fixed the issue (the
 deployement recipe worked on that older Ubuntu version)

 --
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 ---
 You received this message because you are subscribed to the Google Groups
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to web2py+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] DAL query for optional integer field (Postgres)

2014-07-18 Thread Mandar Vaze
Background :

I'm using postgres (web2py 2.9.5 - but I don't think it matters)
I have an integer field - which is optional say Number of pets  I have 
NOT set any default value (I think for Postgres - this means default NULL)

When user does not select from the drop down 
IS_EMPTY_OR(IS_IN_SET([1,2,3,4])) - I see value None in the grid (Seems 
OK)

I have *another grid* where I need to find people with 1 pet - I *also* 
need to *count* people who have *not specified* the count. So (part of) my 
query is :

db.user_profile.pets.belongs([1, None])

But this returns only the profiles with number of pet as 1 i.e. Profiles 
where number of pets is NOT specified isn't returned.

I checked db._lastsql - it turns out it is Postgres that doesn't return the 
rows (So it is not really web2py's fault)

The raw query is :
SELECT * FROM user_profile WHERE user_profile.pets IN (1,NULL);

I also tried :

~db.user_profile.pets.belongs([2,3,4])

Assuming None isn't part of 2,3,4 - so those rows will be returned - but 
only the rows with pets=1 are returned.

Queries :

1. What is the default value at Postgres level ? (*psql command prompt 
shows white space under pets column for those records*)
2. What DAL query should I use to get *both* pets specified as 1 and 
pets count not specified ?

Thanks,
-Mandar

P.S: I'm not sure subject makes sense or matches with my question, but I 
didn't know how to summarize my query in the subject

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: DAL query for optional integer field (Postgres)

2014-07-18 Thread Leonel Câmara
Postgres is right NULL doesn't equal anything dude.

db((db.user_profile.pets==1)|(db.user_profile.pets== None)).count()

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Web2py Forms and Javascript

2014-07-18 Thread Jesse Ferguson
This is kind of two questions but I would like to build a app to handle 
Invoicing, We have some satellite offices in other towns and it would be nice 
to get rid of our hand written paper forms and faxing(FORM 
https://drive.google.com/file/d/0BydRLdL9cc4mNzhjR1U3MHVPVjA/edit?usp=sharing 
). I would like to know whats the best practice for building the data model on 
large forms? Should the form be all one table? There's about 35 items, which 20 
or so would just be integers (amounts of item).. below I have an example of 
what I'm thinking of going with. Finally I would like to implement a 
auto-filling form, for example if the user types in a location that has already 
been put in once before it will automatically fill in the mileage and person to 
attn to, would this be best handled with a javascript framework? If so could 
you push me towards one to learn? (my javascript is weak but I'm working on it 
:))

Thanks in advance!
Jesse Ferguson

EXAMPLE MODEL

db.define_table('invoice',
Field('price_list', 'integer'),
Field('account_code','string'),
Field('company', 'string'),
Field('attn', 'string'),
Field('customer_order_number', 'string'),
Field('ccc_so_num', 'string'),
Field('date_of_work', 'date'),
Field('wo_location', 'string'),
Field('lease', 'string'),
Field('details', 'list:reference'),
)

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] Web2py Forms and Javascript

2014-07-18 Thread Richard Vézina
For the prefilled data you have this :
db.invoice.fieldname.default = your previous predefined form data

For your model, I think it is much more complex then that... For instance,
what's happen when there is new Items? You add new column to your model
each time? (bad idea). Also storing company in the invoice table is a bad
idea (denormalized) because you will have to input each time company name
and address in you company field. For this you may consider to add a
company table and change your company string field like that :

 Field('company', 'reference company'),

You will have to populate company table first with another form then select
the new inserted company after in your invoice form.

The same goes for the items they should go in an item/product table and you
should have a items_id field that could be of time list:reference where you
select the item, though you will not be able to precise the quantity that
way.

There is tonnes of schema design for invoice app :

Here some UML :

https://www.google.ca/search?q=invoice+database+schemaespv=2tbm=ischimgil=j-vKuBZKWTALKM%253A%253Bhttps%253A%252F%252Fencrypted-tbn2.gstatic.com%252Fimages%253Fq%253Dtbn%253AANd9GcRrkWvL-9FvYRH5sr5lgH6QWiut3gK4MfVzMP26BcvCI2rV7x-u%253B503%253B285%253B2YNCt_eklOX5dM%253Bhttps%25253A%25252F%25252Fpeople.ok.ubc.ca%25252Frlawrenc%25252Fteaching%25252F304%25252FNotes%25252Fsource=iuusg=__q2COFwdJchOn1mZeO6vYLLlpjHk%3Dsa=Xei=wnXJU-T3D8SUyASKs4CgBQved=0CB4Q9QEwAAbiw=1920bih=995#facrc=_imgrc=j-vKuBZKWTALKM%253A%3B2YNCt_eklOX5dM%3Bhttps%253A%252F%252Fpeople.ok.ubc.ca%252Frlawrenc%252Fteaching%252F304%252FNotes%252FER%252FInvoice.png%3Bhttps%253A%252F%252Fpeople.ok.ubc.ca%252Frlawrenc%252Fteaching%252F304%252FNotes%252F%3B503%3B285


Richard




On Fri, Jul 18, 2014 at 2:57 PM, Jesse Ferguson ifl...@gmail.com wrote:

 This is kind of two questions but I would like to build a app to handle
 Invoicing, We have some satellite offices in other towns and it would be
 nice to get rid of our hand written paper forms and faxing(FORM
 https://drive.google.com/file/d/0BydRLdL9cc4mNzhjR1U3MHVPVjA/edit?usp=sharing
 ). I would like to know whats the best practice for building the data model
 on large forms? Should the form be all one table? There's about 35 items,
 which 20 or so would just be integers (amounts of item).. below I have an
 example of what I'm thinking of going with. Finally I would like to
 implement a auto-filling form, for example if the user types in a location
 that has already been put in once before it will automatically fill in the
 mileage and person to attn to, would this be best handled with a javascript
 framework? If so could you push me towards one to learn? (my javascript is
 weak but I'm working on it :))

 Thanks in advance!
 Jesse Ferguson

 EXAMPLE MODEL

 db.define_table('invoice',
 Field('price_list', 'integer'),
 Field('account_code','string'),
 Field('company', 'string'),
 Field('attn', 'string'),
 Field('customer_order_number', 'string'),
 Field('ccc_so_num', 'string'),
 Field('date_of_work', 'date'),
 Field('wo_location', 'string'),
 Field('lease', 'string'),
 Field('details', 'list:reference'),
 )

 --
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 ---
 You received this message because you are subscribed to the Google Groups
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to web2py+unsubscr...@googlegroups.com.
 For more options, visit https://groups.google.com/d/optout.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] JSONRPC and Pyjamas - what I must do?

2014-07-18 Thread Dmitry Ermolaev


in test application - empty screen ((

https://lh6.googleusercontent.com/-ZTlrUB707cQ/U8mFaGGIeAI/ACU/YohLR1zqIu0/s1600/pyjam.png

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: JSONRPC and Pyjamas - what I must do?

2014-07-18 Thread Dmitry Ermolaev


https://lh4.googleusercontent.com/-x041vI2wSPM/U8mJ8zE_XiI/ACg/n7FQeKokoB8/s1600/pyjam-2.png


суббота, 19 июля 2014 г., 0:41:04 UTC+4 пользователь Dmitry Ermolaev 
написал:

 in test application - empty screen ((


 https://lh6.googleusercontent.com/-ZTlrUB707cQ/U8mFaGGIeAI/ACU/YohLR1zqIu0/s1600/pyjam.png



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] SQLFORM.grid: sorting

2014-07-18 Thread Jacinto Parga
Hi, 

I solved it putting the foreing key format in the controller, before the 
grid:

def familia_manage():
*db.auth_user._format = '%(last_name)s %(first_name)s'*
fields=[db.t_familiares.f_nombre, 
db.t_familiares.f_apellidos,db.t_familiares.f_titular]
form = SQLFORM.grid(db.t_familiares, fields=fields )
return locals()

Where, in the table declaration:

db.t_familiares.f_titular.requires= 
(IS_IN_DB(db,'auth_user.id','%(last_name)s ''%(first_name)s'))

When I press the header I get it order by last_name instead of id.


El lunes, 21 de mayo de 2012 22:24:23 UTC+2, backseat escribió:

 Thanks Jim, I somehow missed the 'orderby' parameter to SQLFORM.grid 

 On Mon, 21 May 2012 13:11:31 -0700 (PDT), massimo@gmail.com 
 javascript: said: 

  foreign key. You can do a join. 

 Thanks Massimo; however, that's a little cryptic. Could you explain how a 
 join can be used to determine the sort order when I click on a 
 SQLFORM.grid header? 

 Thanks, 
 Keith 
 -- 
 You can have everything in life you want if you help enough other people 
 get what they want - Zig Ziglar. 

 Who did you help today? 


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] как сделать передачу данных от сервера к клиенту без AJAX

2014-07-18 Thread Dmitry Ermolaev
как быстро обновлять данные на странице у клиента при изменении данных на 
сервере?
без использования AJAX or FLASH

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: problem with request_reset_password routes on server

2014-07-18 Thread Massimo Di Pierro
I am not 100% sure of why you have the settings you have. Whether you want 
to keep them that way or now. My advice is this...

write your code so that it works as you expect on localhost without 
routes.py, even if the Urls are not the ones you want. Then you edit the 
routes so that you get the Urls you want without any change in your code. 
we can help with that. You may need two different routes.py on localhost 
and on a production site depending on the configuration of the server.

Massimo

On Thursday, 17 July 2014 19:47:08 UTC-5, Júlia Rizza wrote:

 Hello,

 I have a controller called 'painel.py' and the following config in my 
 *db.py* file:
 ## configure auth policy
 auth.settings.mailer=mail
 auth.settings.controller = 'painel'
 auth.settings.actions_disabled.append('register')
 auth.settings.registration_requires_verification = False
 auth.settings.registration_requires_approval = False
 auth.settings.allow_basic_login = False
 auth.settings.reset_password_requires_verification = True
 auth.settings.login_url = URL('painel', 'index')
 auth.settings.login_next = URL('painel', 'dashboard')
 auth.settings.logged_url = URL('painel', 'dashboard')
 auth.settings.request_reset_password_next = URL('painel', 'index')
 auth.settings.reset_password_next = URL('painel', 'index')
 auth.settings.logout_next=URL('painel', 'index')
 auth.settings.profile_next = URL('painel', 'dashboard')
 auth.settings.retrieve_username_next = URL('painel', 'dashboard')
 auth.settings.retrieve_password_next = URL('painel', 'dashboard')
 auth.settings.change_password_next = URL('painel', 'dashboard')
 auth.settings.on_failed_authentication = URL('painel', 'index')

 I defined *painel.py* as auth controller so the login url when it is an 
 invalid login won't be crashing, but the user function is still on the 
 *default.py* controller. But now when I access the 
 'request_reset_password' page and try to enter my username and submit the 
 form, it works normally on localhost but not on server (Apache on Ubuntu). 
 The routes when submiting the form are '/user/request_reset_password' on 
 localhost, but '/myapp/*painel*/user/request_reset_password' (wrong 
 controller) on server. Is there a better way to fix this?

 *routes.py*



 *BASE = ''routes_in = ((BASE + '/', BASE + '/myapp/painel/index'),
 (BASE + '/user/$anything', BASE + '/myapp/default/user/$anything'),
 (BASE + '/download/$anything', BASE + 
 '/myapp/default/download/$anything'),(BASE + '/call/$anything', BASE + 
 '/myapp/default/call$anything'),(BASE + '/data/$anything', BASE + 
 '/myapp/default/data/$anything'),(BASE + '/myapp/static/$anything', 
 BASE + '/myapp/static/$anything'),(BASE + '/myapp/appadmin', BASE + 
 '/myapp/appadmin'),(BASE + '/myapp/appadmin/$anything', BASE + 
 '/myapp/appadmin/$anything'),(BASE + '/index', BASE + 
 '/myapp/painel/index'),(BASE + '/start', BASE + 
 '/myapp/painel/start'),(BASE + '/dashboard', BASE + 
 '/myapp/painel/dashboard'),(BASE + '/monitor', BASE + 
 '/myapp/painel/monitor'),(BASE + '/accept/$anything', BASE + 
 '/myapp/painel/accept/$anything'),(BASE + '/invite', BASE + 
 '/myapp/painel/invite'),(BASE + '/invite/$anything', BASE + 
 '/myapp/painel/invite/$anything'),(BASE + '/delete/$anything', BASE + 
 '/myapp/painel/delete/$anything'),(BASE + '/$anything', BASE + 
 '/myapp/painel/board/$anything'),)routes_out = [(x, y) for (y, x) in 
 routes_in]*


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] SQLFORM.grid: sorting

2014-07-18 Thread Massimo Di Pierro
You cannot a have an inner join in smartgrid. That's the biggest difference 
in this case. You can have orderby.





On Monday, 21 May 2012 15:47:53 UTC-5, Jim S wrote:

  Massimo - Is there a way to do it with a .smartgrid.  I know the question 
 wasn't on .smartgrid, but I'm using that extensively and too would like 
 some sort of solution.

 -Jim

 On 5/21/2012 3:11 PM, Massimo Di Pierro wrote: 

 foreign key. You can do a join.

 On Monday, 21 May 2012 14:49:06 UTC-5, Jim S wrote: 

 You can specify the sort order using the orderby parameter.  But, I 
 don't know how you get it to sort by the displayed value of a foreign 
 key column. 

 Ex: 

 orderby = [~db.asset.acquiredOn, db.asset.assetTag, db.asset.description] 

 ~ orders descending. 

  -Jim 

 On 5/21/2012 2:23 PM, Keith Edmunds wrote: 
  Two questions re SQLFORM.grid sorting. 
  
  1. Is it possible to specify the initial sort order? 
  
  2. I'm displaying a table that includes a foreign field. When I click 
 on 
  the header to sort by that field, it sorts by the field id rather than 
 by 
  the (displayed) foreign field. Can I sort by the displayed field? 
  
  Thanks, 
  Keith 

  

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: как сделать передачу данных от сервера к клиенту без AJAX

2014-07-18 Thread Derek
Server Push - though i'm not sure it's supported in Web2Py.

On Friday, July 18, 2014 2:00:22 PM UTC-7, Dmitry Ermolaev wrote:

 как быстро обновлять данные на странице у клиента при изменении данных на 
 сервере?
 без использования AJAX or FLASH


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] Web2py Forms and Javascript

2014-07-18 Thread 黄祥
for autofiling please check it on the book about dal default or ajax 
autocompletion
ref:
http://web2py.com/books/default/chapter/29/11/jquery-and-ajax#Auto-completion
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer

as richard said : please have normalization on your table.
e.g.
# create table : invoice_header
db.define_table('invoice_header', 
Field('invoice_no'), 
Field('invoice_date', 'date'), 
Field('customer', 'reference customer'), 
Field('grand_total', 'integer'), 
auth.signature )

# create table : invoice_detail
db.define_table('invoice_detail', 
Field('invoice_no', 'reference invoice_header'), 
Field('product', 'reference product'), 
Field('quantity', 'integer'), 
Field('price', 'integer'), 
Field('total_price', 'integer'), 
Field('grand_total', 'integer'), 
auth.signature )

for company info, i usually have a query from created_on field, that refer 
to auth_user table and show it when print the invoice, you can also learn 
from web2py appliances, estore and pos online store.

best regards,
stifan

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] Web2py Forms and Javascript

2014-07-18 Thread Jesse Ferguson
 I think this would work better however I am not sure about the items.. is 
the item_entry table how its normally done? Examples online vary... 
A completed Service order would have multiple Item_entry references... Just 
doesn't seem like the right way to do it.. 


db.define_table('company',

 Field('name', 'string'))


 db.define_table('lease',

 Field('name', 'string'),

 Field('attn', 'string'),

 Field('location', 'string'))


 db.define_table('account_code',

 Field('code','string'))


 db.define_table('item',

 Field('name', 'string'),

 Field('pl_no', 'integer'),

 Field('cost', 'double'))


 db.define_table('item_entry',

 Field('item', 'reference item'),

 Field('amount', 'double'))


 db.define_table('service_order',

 Field('so_date', 'date'),

 Field('so_num', 'integer'),

 Field('so_hours', 'double'),

 Field('total_cost', 'double'),

 Field('notes', 'text'),

 Field('company', 'reference company'),

 Field('lease', 'reference lease'),

 Field('acct_code', 'reference account_code'),

 Field('items', 'list:reference item_entry')

 )



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: PythonAnywhere Web2py Script

2014-07-18 Thread Mandar Vaze
I have some scripts that do not output anything - but I know they work 
(Mostly DB initialization, populate initial DB etc.)
You can put some print statements in voltrin_grabber.py just for 
debugging - see if you hit those print statements.

On Wednesday, July 16, 2014 7:07:21 PM UTC+5:30, Tom Russell wrote:

 I am trying to run a script that I have in my app. While the log files 
 seem to show my script ran, it does not update the db I have for my app. On 
 the schedule tab in pythonanywhere I have this set up so not sure if it is 
 correct:

 python2.7 /home/tsrdatatech/web2py/web2py.py -S ttheorydataextractor -M -R 
 /home/tsrdatatech/web2py/applications/ttheorydataextractor/modules/
 voltrin_grabber.py

 And a sample output of what the log says when it runs is below:

 2014-07-14 23:00:44 -- Completed task, took 17.00 seconds, return code was 0.
 web2py Web Framework
 Created by Massimo Di Pierro, Copyright 2007-2014
 Version 2.9.5-stable+timestamp.2014.03.16.02.35.39
 Database drivers available: SQLite(sqlite3), MySQL(pymysql), MySQL(MySQLdb), 
 MySQL(mysqlconnector), PostgreSQL(psycopg2), PostgreSQL(pg8000), 
 MSSQL(pyodbc), DB2(pyodbc), Teradata(pyodbc), Ingres(pyodbc), 
 MongoDB(pymongo), IMAP(imaplib)

 2014-07-15 23:00:30 -- Completed task, took 11.00 seconds, return code was 0.


 It seems like it opens web2py but doesnt really run the script I have I 
 think.

 Thanks.


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


Re: [web2py] Alternative IDEs?

2014-07-18 Thread Mandar Vaze


On Monday, July 14, 2014 6:58:51 PM UTC+5:30, Ramos wrote:

 Sublime Text 

 
Does ST have web2py integration ? 

as sasogeek wrote help me find methods and variables easily. for example 
autocomplete options to choose from after using a dot operator?

Are there any plugins for that ?

I know pycharm paid version has this (community edition doesn't, still it 
is my IDE of choice)

-Mandar



 2014-07-14 13:35 GMT+01:00 'sasogeek' via web2py-users 
 web...@googlegroups.com javascript::

 Are there any alternative IDEs for web2py?
 I'm in search of an IDE for web2py that can help me find methods and 
 variables easily. for example autocomplete options to choose from after 
 using a dot operator? the default browser ide lacks quite a number of 
 things in making programming easy. Web2py in itself I believe makes 
 developing applications really really easy, but I believe writing the code 
 should be just as easy the development process itself... if you get what I 
 mean.
  
 -- 
 Resources:
 - http://web2py.com
 - http://web2py.com/book (Documentation)
 - http://github.com/web2py/web2py (Source code)
 - https://code.google.com/p/web2py/issues/list (Report Issues)
 --- 
 You received this message because you are subscribed to the Google Groups 
 web2py-users group.
 To unsubscribe from this group and stop receiving emails from it, send an 
 email to web2py+un...@googlegroups.com javascript:.
 For more options, visit https://groups.google.com/d/optout.




-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: DAL query for optional integer field (Postgres)

2014-07-18 Thread Mandar Vaze

On Friday, July 18, 2014 10:42:47 PM UTC+5:30, Leonel Câmara wrote:

 Postgres is right NULL doesn't equal anything dude.

 db((db.user_profile.pets == 1)|(db.user_profile.pets == None)).count()


web2py user mailing list has NEVER failed me
Leonel - Thanks a LOT !!! (Yes, it worked.)

(I wonder why I didn't think of it myself)

-Mandar
 

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: error(10053, 'An established connection was aborted by the software in your host machine')

2014-07-18 Thread Dmitry Ermolaev


350 errors for 5 hours work ((

why?

if I use LOAD(... ajax=True)

{{=LOAD('where', 'for_addr.load', vars={'addr': addr}, ajax=True, 
times=100, timeout=2,

content=IMG(_src=URL('static','images/loading.gif'), _width=48))}}

https://lh4.googleusercontent.com/-2IkS4jBRT48/U8nnRAPGF2I/ACw/v1HqII0eT-g/s1600/err10053-3.png

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: error(10053, 'An established connection was aborted by the software in your host machine')

2014-07-18 Thread Dmitry Ermolaev
in mySQL ipay.err
=
2014-07-19 07:53:07 1512 [Warning] C:\Program Files\MySQL\MySQL Server 
5.6\bin\mysqld: Forcing close of thread 1933  user: 'root'

2014-07-19 07:53:07 1512 [Warning] C:\Program Files\MySQL\MySQL Server 
5.6\bin\mysqld: Forcing close of thread 1921  user: 'root'

2014-07-19 07:53:07 1512 [Warning] C:\Program Files\MySQL\MySQL Server 
5.6\bin\mysqld: Forcing close of thread 1928  user: 'root'


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: error(10053, 'An established connection was aborted by the software in your host machine')

2014-07-18 Thread Dmitry Ermolaev

2014-07-19 07:53:32 1560 [Note] Plugin 'FEDERATED' is disabled.
2014-07-19 07:53:32 648 InnoDB: Warning: Using 
innodb_additional_mem_pool_size is DEPRECATED. This option may be removed 
in future releases, together with the option innodb_use_sys_malloc and with 
the InnoDB's internal memory allocator.
2014-07-19 07:53:32 1560 [Note] InnoDB: Using atomics to ref count buffer 
pool pages
2014-07-19 07:53:32 1560 [Note] InnoDB: The InnoDB memory heap is disabled
2014-07-19 07:53:32 1560 [Note] InnoDB: Mutexes and rw_locks use Windows 
interlocked functions
2014-07-19 07:53:32 1560 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-07-19 07:53:32 1560 [Note] InnoDB: Not using CPU crc32 instructions
2014-07-19 07:53:32 1560 [Note] InnoDB: Initializing buffer pool, size = 
8.0M
2014-07-19 07:53:32 1560 [Note] InnoDB: Completed initialization of buffer 
pool
2014-07-19 07:53:32 1560 [Note] InnoDB: Highest supported file format is 
Barracuda.
2014-07-19 07:53:36 1560 [Note] InnoDB: 128 rollback segment(s) are active.
2014-07-19 07:53:36 1560 [Note] InnoDB: Waiting for purge to start
2014-07-19 07:53:36 1560 [Note] InnoDB: 5.6.16 started; log sequence number 
940666479
2014-07-19 07:53:36 1560 [Note] Server hostname (bind-address): '*'; port: 
3306
2014-07-19 07:53:36 1560 [Note] IPv6 is available.
2014-07-19 07:53:36 1560 [Note]   - '::' resolves to '::';
2014-07-19 07:53:36 1560 [Note] Server socket created on IP: '::'.
2014-07-19 07:53:37 1560 [Note] Event Scheduler: Loaded 0 events
2014-07-19 07:53:37 1560 [Note] C:\Program Files\MySQL\MySQL Server 
5.6\bin\mysqld: ready for connections.
Version: '5.6.16-log'  socket: ''  port: 3306  MySQL Community Server (GPL)

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: Web2py Deployment Script for Ubuntu 14.04

2014-07-18 Thread Brian M
I posted about this a couple weeks ago along with what worked for me


,,https://groups.google.com/forum/#!searchin/web2py/Apache$20Ubuntu%7Csort:date/web2py/o6OGQRQTN6Y/oJJQMGChgpcJ

On Friday, July 18, 2014 7:14:18 AM UTC-5, Auden RovelleQuartz wrote:

 This recipe which had worked:

 {
 One step production deployment

 Here are some steps to install apache+python+mod_wsgi+web2py+postgresql 
 from scratch.

 On Ubuntu:

 wget http://web2py.googlecode.com/hg/scripts/setup-web2py-ubuntu.sh
 chmod +x setup-web2py-ubuntu.sh
 sudo ./setup-web2py-ubuntu.sh

 }

 *no longer works when using the Ubuntu 14.04 operating system.*

 Instead of getting the default web2py welcome application (when you type 
 in the IP address on the browser), an Apache default page is displayed.

 returning to Ubuntu 12.04 operating system fixed the issue (the 
 deployement recipe worked on that older Ubuntu version)


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


[web2py] Re: test_has_right_title does not pass in the exercise given in :http://killer-web-development.com/

2014-07-18 Thread jjs0sbw
Stackoverflow has a good answer to this question.

http://stackoverflow.com/questions/19282549/web2py-testing-with-selenium-webdriver

I am working the tutorial now and these changes worked for me...

def test_has_right_title(self):
# First he looks at the topbar and sees 'Microposts On Steroids'
title = self.browser.title
self.assertEqual('Microposts On Steroids', title)

def test_has_right_title(self):
# First he looks at the topbar and sees 'Tukker.Me Privacy Policy'
title = self.browser.title
self.assertEqual('Tukker.Me Privacy Policy', title)

def test_has_right_title(self):
# First he looks at the topbar and sees 'About Tukker.Me'
title = self.browser.title
self.assertEqual('About Tukker.Me', title)

Have fun..

On Friday, June 28, 2013 4:25:20 AM UTC-7, shai...@signumsol.com wrote:

  I tried what you suggested, but it gave the same error. :(

 On Tuesday, June 25, 2013 8:24:48 PM UTC+5:30, dhmorgan wrote:

 you're welcome; I'd been wanting to run through the tutorial, 

 yes,within test_static_pages.py (though I guess you've probably tried it 
 by now) it will work that way; I don't know selenium well enough to say 
 whether his example should work or whether browser.title is the preferred 
 way; I'd comment to him on the site but it's taken over by spammers

 On Tuesday, June 25, 2013 4:08:25 AM UTC-5, shai...@signumsol.com wrote:

 Thank you so much for responding Danny.
 Do you mean to say that I need to change the statement :title = 
 self.browser.find_element_by_tag_name('title')  to...
title = self.browser.title ...??

 On Monday, June 24, 2013 12:12:20 PM UTC+5:30, shai...@signumsol.com 
 wrote:


 In the tukker application example given in the 
 killer-web-development.com the test_has_right_title fails in-spite 
 of having the exact code and steps followed according to the instructions 
 on the website. 
 The message I get after running the application is :

 FAIL: test_has_right_title (test_static_pages.TestPrivacyPage)
 --
 Traceback (most recent call last):
   File 
 /home/shailajack/Desktop/python_prog/web2py/applications/tukker/fts/test_static_pages.py,
  
 line 18, in test_has_right_title
 self.assertEqual('Tukker.Me Privacy Policy', title.text)
 AssertionError: 'Tukker.Me Privacy Policy' != u''


 Can anyone please help me to figure out where I'm going wrong??

 Thanks



-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
web2py-users group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.