[web2py] Re: web2py and Sublime Text

[Cássio Botaro]

Sorry, i delete the repository but until wednesday will return with 
improvements.

-- 
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] how to: tumblr login for web2py

[Falko Delarue]

Thanks, I added it!

On Sunday, January 4, 2015 11:44:19 PM UTC+1, Michele Comitini wrote:
>
> Very nice! just one detail to make it easier for the ones that do not have 
> apt-get...
>
> sudo apt-get install python-oauth2
>
> can be replaced with:
>
> pip install --user python-oauth2
>
> making it portable to any environment where web2py works
>
> 2015-01-03 13:44 GMT+01:00 Falko Delarue  >:
>
>> This is how you login to your web2py app with Tubmblr 
>>
>> Register a Tubmblr app (you will of course need a Tubmblr account)
>>
>> https://www.tumblr.com/oauth/register
>>
>> and configure later at 
>>
>> https://www.tumblr.com/settings/apps
>>
>> get the consumer key and secret
>>
>> install the oauth2 lib (instructions only for ubuntu)
>>
>> sudo apt-get install python-oauth2
>>
>> download the pytumblr lib from (Download ZIP in right menu)
>>
>> https://github.com/tumblr/pytumblr
>>
>> extract only the pytumblr folder to yourapp/modules
>>
>> edit yourapp/modules/pytumblr/__init__.py and add dot "." in front of the 
>> helpers and request import like this
>>
>> from .helpers import validate_params, validate_blogname
>> from .request import TumblrRequest
>>
>> add the following code to your db.py 
>>
>> consumer_key = 'XXX'
>> consumer_secret = 'XX'
>>
>> request_token_url = 'http://www.tumblr.com/oauth/request_token'
>> authorize_url = 'http://www.tumblr.com/oauth/authorize'
>> access_token_url = 'http://www.tumblr.com/oauth/access_token'
>>
>> from gluon.contrib.login_methods.oauth10a_account import OAuthAccount
>> import pytumblr
>>
>> class TumblrOAuth(OAuthAccount):
>> """OAuth for Tumblr"""
>> def get_user(self):
>> if not self.accessToken():
>> return None
>>
>> client = pytumblr.TumblrRestClient(
>> consumer_key,
>> consumer_secret,
>> self.accessToken().key,
>> self.accessToken().secret,
>> )
>>
>> info = client.info()
>> if info and ('user' in info):
>> return dict(
>> first_name=info['user']['name'],
>> registration_id='tumblr:%s' % info['user']['name'],
>> )
>>
>> auth.settings.login_form = TumblrOAuth(globals(), consumer_key, 
>> consumer_secret, authorize_url, request_token_url, access_token_url)
>>
>> Replace the consumer key and secret with yours! Tumblr does not provide 
>> first or last name or an id thats why only the crude info in the return. I 
>> do not really need to create proper users so this is enough for me, you can 
>> improve on that. Also this approach will let you log in only with Tumblr, 
>> you will have to figure our the rest, this is only a basic tutorial.
>>
>> Did I miss anything? Did you like that? Write a comment!
>>
>>  -- 
>> 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 .
>> 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] Mail don't send without errors

[Gael Princivalle]

Hello all.

I've got a strange problem. With a specific mail configuration I don't have 
any error but emails are not going out.
So if I use this configuration mails are not going out:

Model:
mail = auth.settings.mailer
mail.settings.server = 'zimbra.mydomain.com:25'
mail.settings.sender = 'sa...@mydomain.com'
mail.settings.login = 'sa...@mydomain.com:password'

Controller:
email_sent = mail.send(to=['myem...@gmail.com'],
  subject = subject,
  reply_to=email,
  message=message)
And email_sent = 1, crazy.

And in the same application with another configuration emails are going out.
mail = auth.settings.mailer
mail.settings.server = 'smtp.anotherdomain.com:587'
mail.settings.sender = 'sa...@anotherdomain.com'
mail.settings.login = 'user_name:password'

Someone knows why or where I can search for debug information's ? 

Thanks,bye.


-- 
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] setup-web2py-nginx-uwsgi-ubuntu.sh

[Richard Vézina]

It was not an email passwd, it was admin password... If you omit it, the
installation script may have install web2py anyway, but not setting
password for admin interface... If this password is not setted up properly
web2py prevent access to admin interface... If you want to correct the
situation, try this :

sudo -u www-data python -c "from gluon.main import save_password;
save_password('123456',443)"

Where 123456 is your password surrounding with single quote.

It should create a file named parameters_443.py or parameters_8000.py
depending of your configuration... If you don't use HTTPS, change '443' up
there by the actual port number you use to access your web2py server
instance.

Richard

On Mon, Dec 29, 2014 at 9:11 AM, Александр Остыловский  wrote:

> Hello!
> Run on ubuntu 14.04 installation of nginx-uwsgi with a script that comes
> with web2py directory scripts:
>
> sudo ./setup-web2py-nginx-uwsgi-ubuntu.sh
>
> During installation, it asked in particular e-mail, password.
> I go to the browser to 127.0.0.1.
> web2py says he works (it is clear that even with nginx).
> But when you try to log into the administrative interface says
> "Admin is disabled, since it is impossible to gain access to the password
> file"
>
>
>  --
> 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] Re: Mail don't send without errors

[Niphlod]

are you sure that the problem is not that the rejection happens after the 
SMTP accepted the mail ? web2py doesn't do too much magic in terms of 
return value...it uses sendmail() from smtplib and traps any exception. 
If you don't see exceptions, smtplib.sendmail isn't raising, so it means 
that the mail is accepted for at least one recipient. From then on, you 
should inspect SMTP's server logs.

-- 
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] Request Password not working correct

[Ramashish Gaurav]

Hi all,

I have deployed my app on internet. At initial stage, every thing was 
working great. No bugs. When a user would register himself, a confirmation 
email would be successfully sent to the user's registered email id. Even 
the 'Lost Password' option was working correct. Now I made some changes in 
my app few days ago. I cannot remember at which places. Now following bug 
came up. 

When the user goes for 'Lost Password' option, he is successfully 
redirected to 'request_reset_password' page. There is a form to accept the 
users email id. The default title "Request reset password" which used to 
appear earlier does not appears now on the 'request_reset_password' page. 
Neither the value of button "Request reset password' appears on it. Instead 
an empty value is there on the submit button. Now when the user submits his 
email id, there is a mail generated at "my_em...@gmail.com" but with no 
link and no subject i.e. an empty mail. Also the mail generated at 
"my_em...@gmail.com" is not sent to "user_em...@gmail.com". I don't know 
what to do now to debug it. I am not finding a place to start with. However 
the confirmation email sent during registering process is still working 
right. Only the reset password email is not working. Also :

auth.settings.reset_password_requires_verification = True

is done in db.py .

Please help me debug this error. (If it is internal error and cannot be 
debugged, then can you please give me an alternative way to implement reset 
password function).

-- 
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: Request Password not working correct

[Dave S]

On Monday, January 5, 2015 8:49:34 AM UTC-8, Ramashish Gaurav wrote:
>
> Hi all,
>
> I have deployed my app on internet. At initial stage, every thing was 
> working great. No bugs. When a user would register himself, a confirmation 
> email would be successfully sent to the user's registered email id. Even 
> the 'Lost Password' option was working correct. Now I made some changes in 
> my app few days ago. I cannot remember at which places.
>

That sounds like you don't use source control to keep a record of your 
previous versions (and of changes between versions).  If you don't, may I 
recommend that you do?  One of the things a good source control tool does 
is provide a way for you to narrow down *when *a bug was introduced, which 
helps to narrow down *where* it was introduced.

If you're not familiar with source control, aka version control, here's a 
good introduction:
http://ericsink.com/vcbe/>

(I'm a Mercurial-type; somewhere between an advanced beginner and a power 
user; I can also use SVN, because I have to at work.)

/dps


-- 
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: setup-web2py-nginx-uwsgi-ubuntu.sh

[Александр Остыловский]

Much easier. You must use https (not nttp) and then everything works.

понедельник, 29 декабря 2014 г., 21:11:44 UTC+7 пользователь Александр 
Остыловский написал:
>
> Hello!
> Run on ubuntu 14.04 installation of nginx-uwsgi with a script that comes 
> with web2py directory scripts:
>
> sudo ./setup-web2py-nginx-uwsgi-ubuntu.sh
>
> During installation, it asked in particular e-mail, password.
> I go to the browser to 127.0.0.1.
> web2py says he works (it is clear that even with nginx).
> But when you try to log into the administrative interface says
> "Admin is disabled, since it is impossible to gain access to the password 
> file"
>
>
>

-- 
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: Any way for placing many views in one html file?

[Przemysław Loesch]

Solved. Just to give a tip to another newbie:
1. In "mycontroler.py" place the code "response.view = 'myview.html' " to 
force executing "myview.html" regardless of a function name.
2. In "myview.html" use {{if request.function==anyviewname:}} to execute 
just a block of code designed for a certain view.
Or just look inside "appadmin.py" and "appadmin.html" of your application 
to get the idea.
Przemek

-- 
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 on AWS EC2

[NeoToren]

Must be something really simple (and stupid on my behalf) that I am doing 
or not doing correctly...

While in the web2py folder on the AWS instance, I've run web2py by trying 
both specifying the port and without it:
1. python web2py.py -i 0.0.0.0 -a mypwd
2. python web2py.py -i 0.0.0.0 -a mypwd -p 8000

In both cases it replies with the usual:
*web2py Web Framework*
*Created by Massimo Di Pierro, Copyright 2007-2015*
*Version 2.9.11-stable+timestamp.2014.09.15.23.35.11*
*Database drivers available: SQLite(sqlite3), MySQL(pymysql), 
PostgreSQL(pg8000), IMAP(imaplib)*
*please visit:*
* http://127.0.0.1:8000/ *
*use "kill -SIGTERM 27150" to shutdown the web2py server*

Which I take as "the web2py server is up and running"

Tried to access web2py server at:
1. ec2-xx-xx-xx-xx.compute-1.amazonaws.com 

(where the xx are the numbers in the Public DNS as they appear on my 
instance on EC2 page)

2. ec2-xx-xx-xx-xx.compute-1.amazonaws.com 
:8000

3. xx.xx.xx.xx/ and with the port specified xx.xx.xx.xx:8000/
the actual IP address numbers...

4. https://ec2-xx-xx-xx-xx.compute-1.amazonaws.com 
/admin/default/index with 
or without port...

Just doesn't work.
Eventually the browser says it takes too long to load page so page doesn't 
exist or cannot be accessed.





-- 
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 to display columns of data without abbreviation in the database aministrative interface?

[Przemysław Loesch]

Thank you very much Dave! The "truncate" parameter works perfect. 
Additionally I've just learned how to place many views in one html file 
what was the subject of my second question on this group.
Thanks a lot!
PS. Przemek from Gonzaga University is not me - I live in Poland.

-- 
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 RESTful timeout

[Bart]

Adding exception handling inside my RESTful api fixed my problem. 
 Sometimes my RESTful posts contained corrupted data and this would cause 
an exception and hang future posts. Adding try/except solved my issue.

Thanks,
Bart

On Friday, November 21, 2014 8:36:36 AM UTC-7, Bart wrote:
>
> I have a python script that posts data to my web2py/application/projects 
> database using RESTful services.  Everything works fine for an hour or two, 
> but then all future posts will timeout.  If, using a web browser, I reload 
> the web2py application's main page then the RESTful services start working 
> again for another hour or two.  Any ideas why I cant run a script 24/7 to 
> GET/POST data to my web2py application's RESTful services? 
>

-- 
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] Python-Docx Split Between Controller and View

[David Wellsandt]

I'm going crazy here to implement a reporting system for .docx files. I 
read several examples of streaming a file (like CSV outputs and such), but 
they were all from the controller. Since there will be several report 
formats for my application, I wanted to move all the reports to the views. 
I SWEAR I had it working and then fouled it up somehow.

Here's what works.

*controllers/sale.py*
@auth.requires_login()
def test5():
from docx import Document
from docx.shared import Inches
import StringIO
output = StringIO.StringIO()
document = Document()
sales = db(db.sale.property==db.property.id).select()
document.add_heading('Sales', 0)
response.headers['Content-Type']=
'application/vnd.openxmlformats-officedocument.wordprocessingml.document'
response.headers['Content-Disposition'] = "attachment; 
filename=Comparable Sales.docx"
response.write(output.getvalue(), escape=False)
document.save(output)
return output.getvalue() 

It produces a .docx file. No data yet, but just a file with the heading 
caption that reads, "Sales."



Then, I tried splitting stuff up a bit.

*controllers/sale.py*
@auth.requires_login()
def test4():
response.view = 'default/test2.html'
return locals()

*views/default/test2.html*
{{
from docx import Document
from docx.shared import Inches
import StringIO
output = StringIO.StringIO()
document = Document()
sales = db(db.sale.property==db.property.id).select()
document.add_heading('Sales', 0)
response.headers['Content-Type']=
'application/vnd.openxmlformats-officedocument.wordprocessingml.document'
response.headers['Content-Disposition'] = "attachment; filename=Comparable 
Sales.docx"
document.save(output)
response.write(output.getvalue(), escape=False)
}}

With the split-up deal, it downloads fine. When I open it, Word alerts me 
first, "The file Comparable Sales.docx cannot be opened because there are 
problems with the contents."

I click OK and get:

"Word found unreadable content in Comparable Sales.docx. Do you want to 
recover the contents of this document?"

I click OK and it opens with the correct content.

I've tried several variations, such as moving the sales query to the 
controller, removing the Content-Disposition header, etc. No luck.

I've tried comparing the underlying document.xml files, but I don't notice 
any notable differences. I've validated and checked for errors.

So, clearly I'm very close if it's actually getting the content, but what 
have I done that keeps making it corrupt?

-- 
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] Not getting expected results from a query

[Greg White]

I am brand new to web2py and know a little python, so I am a definite 
novice. I am trying to build a purchasing agent app and am getting result 
"0" from function cost3. I am expecting to get a sum of the values for a 
specified job number (in cost2) in table PO Field mycost when I specify a 
job number in function cost2.. but I am not getting a sum of those numbers 
but am getting 0 instead. Any help would be appreciated, thanks.

db

db.define_table('jobinfo',
Field('jobnumber', 'integer', requires=IS_NOT_EMPTY()),
Field('jobname', 'string', requires=IS_NOT_EMPTY()),
Field('jobbudget', 'double'),
format = '%(jobnumber)s')

db.define_table('vendortype',
Field('vtype', 'string', requires=IS_NOT_EMPTY()),
format = '%(vtype)s')

db.define_table('vendorr',
Field('company_name',requires=IS_NOT_EMPTY()),
Field('address1',requires=IS_NOT_EMPTY()),
Field('address2'),
Field('city',requires=IS_NOT_EMPTY()),
Field('co_state',requires=IS_NOT_EMPTY()),
Field('zip',requires=IS_NOT_EMPTY()),
Field('vendor_type', db.vendortype),
Field('terms'),
format = '%(company_name)s')

db.define_table('POreq',
Field('job_id', db.jobinfo, requires=IS_NOT_EMPTY()),
Field('Vendor_id', db.vendorr, requires=IS_NOT_EMPTY()),
Field('Qty_1'),
Field('Description_1'),
Field('Notes_1'),
Field('RequiredBy_1','date'),
format = '%(Vendor_id)s')

db.define_table('PO',
Field('job_id', db.jobinfo ),
Field('vname',db.vendorr),
Field('Qty_1', 'double'),
Field('Description_1'),
Field('Notes_1'),
Field('RequiredBy_1','date'),
Field('mycost', 'double'),
format = '%(job_id)s')

controller

def cost2():
form=FORM('Job Number: ',
INPUT(_name='jobnumber', requires=IS_INT_IN_RANGE(0,9000)),
INPUT(_type='submit')).process()
if form.accepted:
redirect(URL('cost3',args=form.vars.jobnumber))
return dict(form=form)

def cost3():
jnum = request.args(0,cast=int)
a = 0
for row in db(db.PO.job_id==jnum).select():
a = a + row.mycost
return a

-- 
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: Struggling with multi user

[Gary Cowell]

Once again, thank you. I'll get there in the end.

On Sunday, 4 January 2015 02:37:09 UTC, Massimo Di Pierro wrote:
>
> I would do:
>
> db.define_table(
> 'shoe',
> Field('model',db.model),
> Field('purchased','date'),
> Field('price','integer'),
> auth.signature, # include created_by and created_on
> format=lambda r: '%s %s %s' % (r.model.manufacturer.name
> ,r.model.model,r.purchased)) 
>
> along with a common filter as you suggested:
>
> db.shoe._common_filter = lambda query: db.shoe.created_by == auth.user_id 
>
> Massimo
>
>
>
> On Saturday, 3 January 2015 13:00:24 UTC-6, Gary Cowell wrote:
>>
>> Hello
>>
>> Sorry for the probably obvious questions, but I do search for answers 
>> honest :)
>>
>> Anyway, what I want is for my table rows to be user specific. Such that 
>> when each user registers, the database looks empty to them, until they 
>> start creating rows in their forms. 
>>
>> I have added these definitions to each table:
>>
>> db.define_table(
>> 'shoe',
>> Field('model',db.model),
>> Field('purchased','date'),
>> Field('price','integer'),
>> Field('created_on', 'datetime',
>>   default=request.now, update=request.now, writable=False),
>> *Field('created_by', 'reference auth_user',*
>> *  default=auth.user_id, update=auth.user_id, writable=False),*
>> format=lambda r: '%s %s %s' % (r.model.manufacturer.name
>> ,r.model.model,r.purchased)) 
>>
>> So I've added created_by referencing auth_user, and this places the 
>> logged in user into the row
>>
>> I could add code to the controller, the simple controller looks like
>>
>> @auth.requires_login()
>> def shoe():
>>form = SQLFORM(db.shoe)
>>if form.process().accepted:
>>response.flash = 'form accepted'
>>elif form.errors:
>>response.flash = 'form has errors'
>>else:
>>response.flash = 'please fill out the form'
>>return dict(form=form)
>>
>> Perhaps with a SQLFORM.factory somehow?
>>
>> Or is CRUD the way to go? I have no idea about CRUD yet (nor much of an 
>> idea about most of this right now, but I'm learning)
>>
>> Or perhaps using common_filter? Somehow like this:
>>
>> table._common_filter = lambda query: db.shoe.created_by == auth.user.id 
>>
>> I don't mind really which way this gets done, but if there's a canonical 
>> way, or a best practice way, I'd like to learn that, instead of the 'wrong 
>> but works' way.
>>
>> Thanks!
>>
>> Gary
>>
>>

-- 
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: models: markmin.py

[Massimo Di Pierro]

what app are you talking about? Please post the files and we can tell you 
what they do. They do not come with web2py.

On Sunday, 4 January 2015 07:25:15 UTC-6, Dmitry Ermolaev wrote:
>
>
> Hi
>
> what does markmin.py 
> 
>  in 
> models?
>

-- 
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 on AWS EC2

[Niphlod]

maybe the the linux vm has a firewall on port 8000 by default 
security groups aren't configured for port 8000. if you're using the 
"vanilla" amazon ec2 instance, see the related documents on 
http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/using-network-security.html#adding-security-group-rule

BTW:  with or without the explicit -p 8000 it will only listen to port 
8000, so don't even try to reach it from http://xxx.xxx./: you need to 
use ALWAYS http://xxx.xxx.xxx:8000/ .

btw2: if you're not skilled in system administration and you don't want to 
learn there are far better environments to deploy web2py which will take 
care of the administrative side of things. If instead you want to learn 
something on the process, see the bazillions guides around the internet ^_^

On Sunday, January 4, 2015 10:11:01 PM UTC+1, NeoToren wrote:
>
> Must be something really simple (and stupid on my behalf) that I am doing 
> or not doing correctly...
>
> While in the web2py folder on the AWS instance, I've run web2py by trying 
> both specifying the port and without it:
> 1. python web2py.py -i 0.0.0.0 -a mypwd
> 2. python web2py.py -i 0.0.0.0 -a mypwd -p 8000
>
> In both cases it replies with the usual:
> *web2py Web Framework*
> *Created by Massimo Di Pierro, Copyright 2007-2015*
> *Version 2.9.11-stable+timestamp.2014.09.15.23.35.11*
> *Database drivers available: SQLite(sqlite3), MySQL(pymysql), 
> PostgreSQL(pg8000), IMAP(imaplib)*
> *please visit:*
> * http://127.0.0.1:8000/ *
> *use "kill -SIGTERM 27150" to shutdown the web2py server*
>
> Which I take as "the web2py server is up and running"
>
> Tried to access web2py server at:
> 1. ec2-xx-xx-xx-xx.compute-1.amazonaws.com 
> (where the xx are the numbers in the Public DNS as they appear on my 
> instance on EC2 page)
>
> 2. ec2-xx-xx-xx-xx.compute-1.amazonaws.com :8000
>
> 3. xx.xx.xx.xx/ and with the port specified xx.xx.xx.xx:8000/
> the actual IP address numbers...
>
> 4. https://ec2-xx-xx-xx-xx.compute-1.amazonaws.com 
> /admin/default/index 
> with or without port...
>
> Just doesn't work.
> Eventually the browser says it takes too long to load page so page doesn't 
> exist or cannot be accessed.
>
>
>
>
>
>

-- 
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: Not getting expected results from a query

[Niphlod]

start with:

def cost3():
jnum = request.args(0,cast=int)
a = 0
results = db(db.PO.job_id==jnum).select()
for row in results:

a = a + row.mycost
return dict(a=a, howmany=len(results))



so you can check how many rows are you actually selecting :P


On Sunday, January 4, 2015 4:17:03 AM UTC+1, Greg White wrote:
>
> I am brand new to web2py and know a little python, so I am a definite 
> novice. I am trying to build a purchasing agent app and am getting result 
> "0" from function cost3. I am expecting to get a sum of the values for a 
> specified job number (in cost2) in table PO Field mycost when I specify a 
> job number in function cost2.. but I am not getting a sum of those numbers 
> but am getting 0 instead. Any help would be appreciated, thanks.
>
> db
>
> db.define_table('jobinfo',
> Field('jobnumber', 'integer', requires=IS_NOT_EMPTY()),
> Field('jobname', 'string', requires=IS_NOT_EMPTY()),
> Field('jobbudget', 'double'),
> format = '%(jobnumber)s')
>
> db.define_table('vendortype',
> Field('vtype', 'string', requires=IS_NOT_EMPTY()),
> format = '%(vtype)s')
>
> db.define_table('vendorr',
> Field('company_name',requires=IS_NOT_EMPTY()),
> Field('address1',requires=IS_NOT_EMPTY()),
> Field('address2'),
> Field('city',requires=IS_NOT_EMPTY()),
> Field('co_state',requires=IS_NOT_EMPTY()),
> Field('zip',requires=IS_NOT_EMPTY()),
> Field('vendor_type', db.vendortype),
> Field('terms'),
> format = '%(company_name)s')
>
> db.define_table('POreq',
> Field('job_id', db.jobinfo, requires=IS_NOT_EMPTY()),
> Field('Vendor_id', db.vendorr, requires=IS_NOT_EMPTY()),
> Field('Qty_1'),
> Field('Description_1'),
> Field('Notes_1'),
> Field('RequiredBy_1','date'),
> format = '%(Vendor_id)s')
>
> db.define_table('PO',
> Field('job_id', db.jobinfo ),
> Field('vname',db.vendorr),
> Field('Qty_1', 'double'),
> Field('Description_1'),
> Field('Notes_1'),
> Field('RequiredBy_1','date'),
> Field('mycost', 'double'),
> format = '%(job_id)s')
>
> controller
>
> def cost2():
> form=FORM('Job Number: ',
> INPUT(_name='jobnumber', requires=IS_INT_IN_RANGE(0,9000)),
> INPUT(_type='submit')).process()
> if form.accepted:
> redirect(URL('cost3',args=form.vars.jobnumber))
> return dict(form=form)
>
> def cost3():
> jnum = request.args(0,cast=int)
> a = 0
> for row in db(db.PO.job_id==jnum).select():
> a = a + row.mycost
> return a
>
>

-- 
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] Re: setup-web2py-nginx-uwsgi-ubuntu.sh

[Richard Vézina]

Also!!

:)

Richard

On Sat, Jan 3, 2015 at 11:23 PM, Александр Остыловский  wrote:

> Much easier. You must use https (not nttp) and then everything works.
>
> понедельник, 29 декабря 2014 г., 21:11:44 UTC+7 пользователь Александр
> Остыловский написал:
>
>> Hello!
>> Run on ubuntu 14.04 installation of nginx-uwsgi with a script that comes
>> with web2py directory scripts:
>>
>> sudo ./setup-web2py-nginx-uwsgi-ubuntu.sh
>>
>> During installation, it asked in particular e-mail, password.
>> I go to the browser to 127.0.0.1.
>> web2py says he works (it is clear that even with nginx).
>> But when you try to log into the administrative interface says
>> "Admin is disabled, since it is impossible to gain access to the password
>> file"
>>
>>
>>  --
> 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] What is "represent" syntax for external url?

[Alex Glaros]

What is controller "represent" syntax for creating a link to an external 
url?

"URL" is the name of the field that contains the url (
http://www.gov-ideas.com/). When I use this:

db.SuperObjectURL.URL.represent = lambda v, r: A(r.URL, _href=URL('URL', 
args=r.URL))

Instead of getting this:

http://www.gov-ideas.com/";>

Part of the link address includes my local web2py path:

http://127.0.0.1:8000/ES1/default/URL/http%3A//gov-ideas.com

thanks

Alex Glaros

-- 
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: What is "represent" syntax for external url?

[Niphlod]

/ironic mode on/ why of all names choosing just something that closely 
resemble some web2py function? are you asking for troubles?!?!
/ironic mode off/

URL() in web2py is a function to create urls (usually related to web2py 
applications).
If you have an url that is complete (such as http://www.gov-ideas.com/) you 
don't need to pass it to the URL function.

tl;dr: use
db.SuperObjectURL.URL.represent = lambda v, r: A(r.URL, _href=r.URL)


On Monday, January 5, 2015 10:16:22 PM UTC+1, Alex Glaros wrote:
>
> What is controller "represent" syntax for creating a link to an external 
> url?
>
> "URL" is the name of the field that contains the url (
> http://www.gov-ideas.com/). When I use this:
>
> db.SuperObjectURL.URL.represent = lambda v, r: A(r.URL, _href=URL('URL', 
> args=r.URL))
>
> Instead of getting this:
>
> http://www.gov-ideas.com/";>
>
> Part of the link address includes my local web2py path:
>
> http://127.0.0.1:8000/ES1/default/URL/http%3A//gov-ideas.com
>
> thanks
>
> Alex Glaros
>

-- 
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: What is "represent" syntax for external url?

[Alex Glaros]

thanks Niphlod,

works

Alex

-- 
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: max value in linked tables

[JaapP]

Thanks a lot, i learned something new today :)

Obvious solution, once you think of it, and much quicker than building 
loops.

Best regards,

Jaap

On Monday, December 29, 2014 10:51:01 AM UTC+1, Massimo Di Pierro wrote:
>
> db.employee_contract.contract_id == db.contract.id)
> & (db.employee_contract.employee_id == db.employee.id
>
> I think you should do it:
>
> contracts = ((db.employee_contract.contract_id == db.contract.id)&
>  (db.employee_contract.employee_id == db.employee.id))
>
> rows = db(contracts).select(db.employee.ALL, db.contract.ALL, orderby=
> db.employee.id|~db.contract.start_date, distinct=db.employee.id)
>
> On Sunday, 28 December 2014 15:57:10 UTC-6, JaapP wrote:
>>
>> Hi,
>>
>> Any hints about how to tackle the following problem greatly appreciated:
>>
>> given three tables:
>>
>> *employee*:
>> id
>> name
>> ...
>>
>> *contract*:
>> id
>> start_date
>> fte100
>> ...
>>
>> *employee_contract:*
>> id
>> employee_id
>> contract_id
>>
>> An employee can have one or more contracs; they are linked through the 
>> employee_contract table.
>>
>> I would like to find a query that returns the contract details for the 
>> latest contract for an employee; 
>>
>> i've solved a little step of my puzzle and can retrieve the latest 
>> contract by doing something like this:
>>
>> employee_id = 10
>>
>> contr = db(   (db.employee.id == employee_id)
>> & (db.employee_contract.contract_id == db.contract.id)
>> & (db.employee_contract.employee_id == db.employee.id)
>>   ).select(db.employee.ALL, db.contract.start_date.max())
>>
>> latest_start_date = contr.contract.start_date.max()
>>
>>
>> but i need also the corresponding contract.fte100 field.
>>
>> Can this be done by using the DAL, or should i construct a loop to find 
>> the answer?
>>
>> Best regards,
>>
>> Jaap
>>
>

-- 
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: Any way for placing many views in one html file?

[Rufus]

It has been a while since I did anything with web2py, but I seem to recall 
that if you didn't have a view for a function it would
open up a default view, which is also in a file.   (Was it generic.html?)   
Anyway, the point being you might want to use that
for your "catch all" file instead of creating your own specific file.

On Sunday, January 4, 2015 4:59:40 AM UTC-5, Przemysław wrote:
>
> Solved. Just to give a tip to another newbie:
> 1. In "mycontroler.py" place the code "response.view = 'myview.html' " to 
> force executing "myview.html" regardless of a function name.
> 2. In "myview.html" use {{if request.function==anyviewname:}} to execute 
> just a block of code designed for a certain view.
> Or just look inside "appadmin.py" and "appadmin.html" of your application 
> to get the idea.
> Przemek
>

-- 
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 RESTful timeout

[Dave S]

On Sunday, January 4, 2015 9:04:21 PM UTC-8, Bart wrote:
>
> Adding exception handling inside my RESTful api fixed my problem. 
>  Sometimes my RESTful posts contained corrupted data and this would cause 
> an exception and hang future posts. Adding try/except solved my issue.
>

It's always good to heard about forward progress!

/dps

-- 
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 to display columns of data without abbreviation in the database aministrative interface?

[Dave S]

On Sunday, January 4, 2015 12:42:30 AM UTC-8, Przemysław wrote:
>
> Thank you very much Dave! The "truncate" parameter works perfect. 
> Additionally I've just learned how to place many views in one html file 
> what was the subject of my second question on this group.
> Thanks a lot!
> PS. Przemek from Gonzaga University is not me - I live in Poland.
>
>
He the basketball player was playing in Portland over the weekend, with his 
parents visiting from Poland.

 You guys do get around  ;-)

/dps

-- 
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] Is the .select(cache.x) cleared automatically upon expiration?

[Robin Manoli]

Hi!

When caching selects, in memory or disk, are they then cleared 
automatically when the expiration time is over? Removed and forgotten?
Or is there some cleanup script similar to the one for sessions?

- Robin

-- 
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 and Sublime Text

[Cássio Botaro]

We back with improvements and better descriptions!

http://cassiobotaro.github.io/my_environment/

-- 
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: Websocket doesn't work on stable version

[samuel bonill]

are you running the Tornado Websocket server ?

El domingo, 4 de enero de 2015 16:09:20 UTC-5, Tito Garrido escribió:
>
> Hi Folks,
>
> I am using 2.9.11 and when I try to use $.web2py.web2py_websocket('ws://
> 127.0.0.1:/realtime/mygroup', function(e){alert(e.data)}) I receive 
> error 403 Forbidden from the server.
>
> Chrome: WebSocket connection to 'ws://127.0.0.1:/realtime/mygroup' 
> failed: Error during WebSocket handshake: Unexpected response code: 403
>
> Firefox: 
> Firefox can't establish a connection to the server at ws://127.0.0.1
> :/realtime/mygroup.
>
> var ws = new WebSocket(url);
>
>
> From python terminal it works: 
> >> from gluon.contrib.websocket_messaging import websocket_send
> >>> websocket_send('http://127.0.0.1:', 'Hello World', 'mykey', 
> 'mygroup')
> ''
> >>> 
>
> What am I missing?
>
> Regards,
>
> Tito
>
> -- 
>
> Linux User #387870
> .
>  _/_õ|__|
> ..º[ .-.___.-._| . . . .
> .__( o)__( o).:___
>  

-- 
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: Any way for placing many views in one html file?

[Anthony]

Note that this is a bit inefficient, as web2py will parse the entire view 
for each page requested. It will help if you compile the views.

Anthony

On Sunday, January 4, 2015 4:59:40 AM UTC-5, Przemysław wrote:
>
> Solved. Just to give a tip to another newbie:
> 1. In "mycontroler.py" place the code "response.view = 'myview.html' " to 
> force executing "myview.html" regardless of a function name.
> 2. In "myview.html" use {{if request.function==anyviewname:}} to execute 
> just a block of code designed for a certain view.
> Or just look inside "appadmin.py" and "appadmin.html" of your application 
> to get the idea.
> Przemek
>

-- 
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: Request Password not working correct

[Ramashish Gaurav]

Thanks Dave,

I will take your valuable advice but I still need to debug it. Can you (and 
someone) please help me about it.

Regards,
Ramashish

On Tuesday, January 6, 2015 1:11:57 AM UTC+5:30, Dave S wrote:
>
>
>
> On Monday, January 5, 2015 8:49:34 AM UTC-8, Ramashish Gaurav wrote:
>>
>> Hi all,
>>
>> I have deployed my app on internet. At initial stage, every thing was 
>> working great. No bugs. When a user would register himself, a confirmation 
>> email would be successfully sent to the user's registered email id. Even 
>> the 'Lost Password' option was working correct. Now I made some changes in 
>> my app few days ago. I cannot remember at which places.
>>
>
> That sounds like you don't use source control to keep a record of your 
> previous versions (and of changes between versions).  If you don't, may I 
> recommend that you do?  One of the things a good source control tool does 
> is provide a way for you to narrow down *when *a bug was introduced, 
> which helps to narrow down *where* it was introduced.
>
> If you're not familiar with source control, aka version control, here's a 
> good introduction:
> http://ericsink.com/vcbe/>
>
> (I'm a Mercurial-type; somewhere between an advanced beginner and a power 
> user; I can also use SVN, because I have to at work.)
>
> /dps
>
>
>

-- 
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.