Re: [web2py] VSCODE with linter + debugging in WEB2PY

[Carlos Costa]

Hi, I have a video teaching how to setup web2py launch and debug in vs code.
It is in Portuguese, but you can activate english subtitles, and it is also 
to see what I do in the video.
https://www.youtube.com/watch?v=4LSy5VuLqCQ

Em sexta-feira, 17 de setembro de 2021 às 05:21:04 UTC-3, 
muratkas...@gmail.com escreveu:

> Hi Monir,
>
> I have to explain my env in other words. Before start, you can finish 
> vscode and python setup:
>
> my pc environment is 
> win10/pro, 
> python :3.8.5  (not virtual env)
> vscode 1.60.0
>
> steps:
>
> 1. download web2py *source *code and  extract it to the desired folder.
> 2. open the vscode
> 3. open the folder you extracted web2py source.
> 4. create a *.vscode* folder and copy these files:
>
> *launch.json*
> {
> "version": "0.2.0",
> "configurations": [
> {
> "name": "Python: Current File",
> "type": "python",
> "request": "launch",
> "program": "${file}",
> "console": "integratedTerminal"
> }
> ]
> }
>
> *settings.json  *
> {
> "python.pythonPath": "C:\\your_python_folder\\python.exe",
> "debug.allowBreakpointsEverywhere": true
> }
>
> 6. Press F5 or select link from Menu>Run>Start Debugging
>
> I think it will start. Whenever select any row on the code for debug, it 
> will stop.
>
> Can you try and inform me whether the info is working.
>
> Regards,
> Murat.
>
>
>
> K P , 17 Eyl 2021 Cum, 03:06 tarihinde şunu yazdı:
>
>> Hi Murat
>>
>> I need some help setting up web2py in vs code also. I tried what you said 
>> (and many other things) but none worked. Please help. 
>> (Yardim Edibilur)
>>
>> On Tuesday, September 10, 2019 at 3:03:55 AM UTC-4 muratkas...@gmail.com 
>> wrote:
>>
>>> Hi,
>>> I work with VSCODE like this:
>>> - Open folder includes web2py.py file.
>>> - Insert some debug point to desired lines
>>> - Press F5 
>>>
>>> Also my environment: 
>>> Windows 10 Pro
>>> Web2py Python 2.7
>>> (maybe Py 3> works same.)
>>>
>>> Best.
>>>
>>> ---
>>> Murat KAŞIKÇIOĞLU
>>> +90 (533) 745-1400 <+90%20533%20745%2014%2000>
>>>
>>>
>>>
>>> Monir , 4 Eyl 2019 Çar, 18:55 tarihinde şunu yazdı:
>>>
 Hi All,

 I'm new on Python and also on Web2py. I've been searching some sort of 
 info or step by step about how to config web2py in VS CODE to Debug, Lint, 
 Intelisense, etc... would be nice!

 But unfortunately, all resources I have found so far seems to be 
 deprecated. Even here in the group, this seems to be not relevant topic. 
 Am 
 I wright ?

 I had downloaded Don Jaimanne extension, Pylint, etc without success.

 I would be more than happy with some fresh guide for this

 Regards/

 *Monir*

 -- 
 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.
 To view this discussion on the web visit 
 https://groups.google.com/d/msgid/web2py/CAPMO4iG4HbFnspELy7_uT077RNTAadvzYcAm4mztcJM02Nu3CQ%40mail.gmail.com
  
 
 .

>>> -- 
>> 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.
>>
> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/web2py/66037040-8383-4ea2-8208-f9becdf4a4e4n%40googlegroups.com
>>  
>> 
>> .
>>
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/e07da1b4-aadd-404d-8f17-3254b65d0c51n%40googlegroups.com.

Re: [web2py] Re: LOAD in py4web

[Carlos Costa]

Sorry for the typo.
I want to make a welcome template based on unpoly soon.

Em sex., 28 de fev. de 2020 às 04:21, AGRogers 
escreveu:

> https://unpoly.com/
>
> On Fri, 28 Feb 2020 at 16:22, Massimo Di Pierro <
> massimo.dipie...@gmail.com> wrote:
>
>> never heard of unpolly.js and cannot find it. Have a link?
>>
>>
>> On Wednesday, 26 February 2020 19:32:20 UTC-8, Carlos Costa wrote:
>>>
>>> LOAD is a very cool thing! And beginners just say WOW when they can
>>> create ajax-like experience so easy.
>>> But, IMO, it lacks some important features for modern apps, like error
>>> handling and history handling.
>>>
>>> I have written some simple functions to help cover these things...
>>>
>>> Another way I found very useful was to use unpolly.js. It's magic but
>>> makes me a little lazyer about getting things done with vue.js.
>>> (BTW they created unpolly to avoid using things like vue, react, etc,
>>> really!)
>>>
>>> I would like very much to use vue.js but I am still noob regarding how
>>> to use it with py4web.
>>> Maybe we should really encourage vue.js and stuff alike... but an
>>> initial pattern would be cool.
>>> And IMO it should be simple and very cleared stated in the docs.
>>> So no one will miss LOAD.
>>>
>>> Em domingo, 23 de fevereiro de 2020 15:18:51 UTC-3, RHC escreveu:
>>>>
>>>> HI,
>>>>
>>>> I am beginning to experiment with py4web, I like the sound of it and I
>>>> am looking to convert a web2py project to py4web to see how they compare.
>>>>
>>>> It appears that the LOAD (helper?) that was available in web2py
>>>> templates is not available in py4web. I was using this to populate part of
>>>> a web page, I liked the way you had the option to use LOAD to call a
>>>> separate URL (within the same app) and insert the result into your page
>>>> before returning the page to the client.
>>>>
>>>> What is the reason for the absence of LOAD in py4web? is there a
>>>> recommended alternative method of achieving the same effect? I have used a
>>>> mixture of ajax=True and ajax=False options for this feature.
>>>>
>>>> Thanks,
>>>>
>>>> Richard.
>>>>
>>> --
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/web2py/22d8b9cf-9ce2-464b-809e-32d4dd84fd02%40googlegroups.com
>> <https://groups.google.com/d/msgid/web2py/22d8b9cf-9ce2-464b-809e-32d4dd84fd02%40googlegroups.com?utm_medium=email_source=footer>
>> .
>>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/CACWMBMPXoWfp9iZ7yQtbCw_YU6yh-9M2_xAQ%3Dzj4ocyWTzxuXw%40mail.gmail.com
> <https://groups.google.com/d/msgid/web2py/CACWMBMPXoWfp9iZ7yQtbCw_YU6yh-9M2_xAQ%3Dzj4ocyWTzxuXw%40mail.gmail.com?utm_medium=email_source=footer>
> .
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4NxWHPktoJ9fAJg_f9YKKg7GhpCDg7sRmj_DGHnq2bqC3A%40mail.gmail.com.

[web2py] Re: LOAD in py4web

[Carlos Costa]

LOAD is a very cool thing! And beginners just say WOW when they can create 
ajax-like experience so easy.
But, IMO, it lacks some important features for modern apps, like error 
handling and history handling.

I have written some simple functions to help cover these things...

Another way I found very useful was to use unpolly.js. It's magic but makes 
me a little lazyer about getting things done with vue.js.
(BTW they created unpolly to avoid using things like vue, react, etc, 
really!)

I would like very much to use vue.js but I am still noob regarding how to 
use it with py4web.
Maybe we should really encourage vue.js and stuff alike... but an initial 
pattern would be cool.
And IMO it should be simple and very cleared stated in the docs.
So no one will miss LOAD.

Em domingo, 23 de fevereiro de 2020 15:18:51 UTC-3, RHC escreveu:
>
> HI,
>
> I am beginning to experiment with py4web, I like the sound of it and I am 
> looking to convert a web2py project to py4web to see how they compare.
>
> It appears that the LOAD (helper?) that was available in web2py templates 
> is not available in py4web. I was using this to populate part of a web 
> page, I liked the way you had the option to use LOAD to call a separate URL 
> (within the same app) and insert the result into your page before returning 
> the page to the client.
>
> What is the reason for the absence of LOAD in py4web? is there a 
> recommended alternative method of achieving the same effect? I have used a 
> mixture of ajax=True and ajax=False options for this feature.
>
> Thanks,
>
> Richard.
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/89450727-f077-4ce0-9046-29b39bfc8a90%40googlegroups.com.

Re: [web2py] Re: Web2py or py4web for a brand new project

[Carlos Costa]

Thanks for sharing you experience with py4web, Jim.


Em qua., 22 de jan. de 2020 às 20:04, Kevin Keller 
escreveu:

> The datatables integration for web2py would be super useful. I'm sure we
> could port it over to py4web easily.
>
> I just feel like with all the stuff web2py gave us to get something
> quickly going missing, it'd just another api framework and there are
> fastapi and apistar as well falcon out..
>
> I think having these ease of use stuff back would really hit home and
> would also make it easier to port from web2py.
>
> And we would be pretty much the Jhipster  of the python world no?
>
>
>
> On Wed, 22 Jan 2020, 23:50 Jim S,  wrote:
>
>> Yes, I will post my main utils.py when I have it working better.  I still
>> have to clean up a couple pieces.  It would be up to Massimo if he wanted
>> to add it.  But in response to one of my earlier questions I was told
>> Massimo kept a utility like this out of py4web so people might use better
>> tools like datatables.  And, I doubt my code is 'framework-ready'.  But it
>> could give others insight into how you can work with py4web.
>>
>> Speaking of datatables, I wrote a datatables integration for web2py last
>> summer.  I think I could also add that to my utils.py pretty easily.
>> Actually, the datatables piece would be easier that what I've done writing
>> my own.  Would you use datatables for complete CRUD, or just to list your
>> table for record selection, etc.?
>>
>> Now that you mentioned mtable, I too recall hearing that before, but
>> haven't gotten in to it at all.  Like I said, I haven't jumped in to the
>> client-side javascript much yet, other than jquery.
>>
>> -Jim
>>
>> On Wednesday, January 22, 2020 at 4:31:11 PM UTC-6, Kevin Keller wrote:
>>>
>>> Jim,
>>>
>>> Could your helpers be considered to be added to thr py4web code base?
>>>
>>> If you say you have a sqlform.grid equivalent or something in that
>>> direction?
>>>
>>> I think there was mtable that should take the spot, but haven't seen any
>>> examples yet or at least none thst would replace a sqlform or smartgrid.
>>>
>>> If it is not coming I would probaly consider using datatables js in the
>>> future.
>>>
>>>
>>>
>>>
>>> On Wed, 22 Jan 2020, 21:47 Jim S,  wrote:
>>>
>>>> For me, there is no porting, it is re-writing.  While a lot of the
>>>> capabilities are there in py4web not all are part of py4web.  Due to the
>>>> nature of how things work, a lot of the 'global' structures in web2py have
>>>> to be handled differently in py4web.
>>>>
>>>> SQLFORM.grid is gone.  FORM replaces SQLFORM but doesn't have all the
>>>> features -
>>>> https://py4web.com/_documentation/static/index.html#chapter-10
>>>> auth_group and auth_membership and auth_permission are gone -
>>>> authentication/authorization have changed -
>>>> https://py4web.com/_documentation/static/index.html#chapter-11
>>>>
>>>> With those things being what they are, I've been playing with py4web
>>>> for a few days now and really am liking it.  It is crazy fast.  You may
>>>> have to write some more helpers to do some things that web2py did for you,
>>>> but that's half the fun, isn't it?  For instance, I used the grid that
>>>> web2py's SQLFORM.grid provides for lots of listing pages.  py4web doesn't
>>>> have one so I've written a helper that displays  pages the way my app wants
>>>> to see them.
>>>>
>>>> I believe py4web is going to make it easier to use Vue.js in your
>>>> pages, but I haven't made the just to using Vue yet so I can't really
>>>> comment on that part.
>>>>
>>>> -Jim
>>>>
>>>> On Wednesday, January 22, 2020 at 12:33:10 PM UTC-6, Carlos Costa wrote:
>>>>>
>>>>> Hey Massimo, thanks for the great info.
>>>>>
>>>>> How about porting apps from web2py to py4web?
>>>>>
>>>>> What steps would you recommend?
>>>>>
>>>>> Em qua., 22 de jan. de 2020 às 08:21, AGRogers 
>>>>> escreveu:
>>>>>
>>>>>> OK, thanks. Re reporting errors, I suspect most errors will be due to
>>>>>> my ignorance. But thanks for the encouragement.
>>>>>>
>>>>>> On Tue, Jan 21, 2020, 1:26 PM Massimo Di Pierro 
>>>>>> wrote:
>>>&

Re: [web2py] Re: Web2py or py4web for a brand new project

[Carlos Costa]

Hey Massimo, thanks for the great info.

How about porting apps from web2py to py4web?

What steps would you recommend?

Em qua., 22 de jan. de 2020 às 08:21, AGRogers 
escreveu:

> OK, thanks. Re reporting errors, I suspect most errors will be due to my
> ignorance. But thanks for the encouragement.
>
> On Tue, Jan 21, 2020, 1:26 PM Massimo Di Pierro <
> massimo.dipie...@gmail.com> wrote:
>
>> You should use the py4web documentation. Also please report any error you
>> find.
>>
>>
>> On Tuesday, 14 January 2020 22:03:59 UTC-8, Andrew Rogers wrote:
>>>
>>> Hi
>>>
>>> Is  the documentation for web2py still mostly relevant for py4web?
>>>
>>> Thanks
>>> Andrew
>>>
>>> On Thursday, 12 December 2019 20:47:05 UTC+6:30, icodk wrote:

 Should I use Web2py or py4web for a brand new project ?
 What is still missing from py4web  ?
 Can I debug with pycharm ?
 I need all the great authentication I got with web2py :
 Registration,pass change, groups mail, etc.
 smartgreed will be very nice to have or similar.
 Stability ?
 Can it be deployed with nginx  and pg ?
 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/web2py/d6c0a99a-42c9-4b04-91ab-56c8ac72b8c4%40googlegroups.com
>> 
>> .
>>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/CACWMBMPjhvWrL3%2B0CtjSCFN_fc-246wAbGbBkWKi84Xfixn3Kg%40mail.gmail.com
> 
> .
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4Nwi%2BqJK2UfK8EJo8hwEtEddj7LQz4PFDeWSBVzmT8%2BHPQ%40mail.gmail.com.

Re: [web2py] Re: Vue2pyj - alternative web IDE

[Carlos Costa]

Didnt work here.
I did a fresh install from py4web source and clone vue3pyj.

ERROR:root:Traceback (most recent call last):
  File "/home/carlos/projects/py4web/py4web/core.py", line 472, in wrapper
ret = func(*func_args, **func_kwargs)
  File "/home/carlos/projects/py4web/py4web/core.py", line 438, in wrapper
ret = func(*args, **kwargs)
  File "apps/vue3pyj/__init__.py", line 56, in get_fs
app_rex  = re.compile('^[a-z_][a-z_0-9]*$', flags = re.I)
NameError: name 're' is not defined

Em sex, 27 de set de 2019 às 02:24, Val K  escreveu:

> Vue3pyj now uses the _dashboard password and can be used along it.
> Also I ported shopping cart example from vue
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/f8fb3e9e-cd06-493f-84f6-7507beaa06bf%40googlegroups.com
> .
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4NwEH8E4T3p2R72mBqE0m-%3DnDGOAY8Ag7ysUfYTPBjKahA%40mail.gmail.com.

Re: [web2py] py4web has now a grid ...

[Carlos Costa]

I like the idea of loading components dynamically.
My only point about SFC is about being a standard.

And what about css? Could it be a TFC Three-File-Components?


Em sex, 13 de set de 2019 às 01:11, Massimo Di Pierro <
massimo.dipie...@gmail.com> escreveu:

> To clarify.
>
> I do not like SFC because I do not think js and html belong to the same
> file. py4web has a utils.js which implements a TFC Two-File-Components (I
> claim copyright). This is undocumented and you will not see it in other vue
> apps.
>
> Basically each component has on js and one html file. In the case of the
> grid one mtable.js and one mtable.html. You can customize the html as you
> see fit without need to touch the JS. The JS is not done and I will be
> adding some functionality. In particular I need to handle events to allow
> to save the grid state in the url.
>
>
>
>
>
> On Thursday, 12 September 2019 06:52:23 UTC-7, Carlos Costa wrote:
>>
>> It's done.
>> But I have a question: where will we put component styling?
>> I add an table.css file and linked in layout.html but I think it belongs
>> to the component.
>> I wish we would use Vue SFC format.
>> Now  is possible to use SFC components without using bundlers.
>>
>>
>> Em qui, 12 de set de 2019 às 09:52, Carlos Costa 
>> escreveu:
>>
>>> I liked it.
>>> Much more faster and responsive.
>>>
>>> I didn't get how use search properly.
>>>
>>> I have on suggestion for letting grid more mobile friendly.
>>> Take a look at this snippet https://codepen.io/andornagy/pen/EVXpbR
>>> It is pure CSS.
>>> It transform columns into rows in a card style table.
>>> I have used it, it is very cool, and I think at least the grid should be
>>> mobile friendly.
>>> The only problem is that you must have a data-column attribute.
>>> I have used to manipulate the w2p grid in order to inject this attribute
>>> but this is very slow.
>>> The ideal is it to be generated with this attribute already.
>>> Maybe I can do a PR with this feature.
>>>
>>>
>>> Em qui, 12 de set de 2019 às 03:31, Massimo Di Pierro <
>>> massimo.dipie...@gmail.com> escreveu:
>>>
>>>> ... it is incomplete. It is experimental. The API is subject to change.
>>>> But I could use some community feedback:
>>>>
>>>> from py4web.utils.publisher import Publisher, ALLOW_ALL_POLICY
>>>>
>>>>
>>>> # exposes services necessary to access the db via ajax
>>>> publisher = Publisher(db, policy=ALLOW_ALL_POLICY)
>>>>
>>>>
>>>> # expose as /examples/grid
>>>> @action('grid')
>>>> @action.uses('grid.html')
>>>> def example_grid():
>>>>  return dict(grid=publisher.grid(db.person))
>>>>
>>>> embed in template with [[=grid]] in templates/grid.html as in web2py.
>>>> The difference from web2py is that the grid communicate with the server
>>>> via ajax and the style is in static/components/mtable.html
>>>> Still does not access authentication based access control but will add
>>>> it very soon.
>>>>
>>>> You can try it.
>>>>
>>>> https://github.com/web2py/py4web/blob/master/apps/examples/__init__.py#L41
>>>>
>>>> --
>>>> 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.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/web2py/cc53051f-104c-4b20-97a6-c32f8220d052%40googlegroups.com
>>>> <https://groups.google.com/d/msgid/web2py/cc53051f-104c-4b20-97a6-c32f8220d052%40googlegroups.com?utm_medium=email_source=footer>
>>>> .
>>>>
>>>
>>>
>>> --
>>> At.
>>>
>>> Carlos J. Costa
>>> --
>>> Cientista da Computação - Esp. Gestão em Telecom
>>>
>>
>>
>> --
>> At.
>>
>> Carlos J. Costa
>> --

Re: [web2py] py4web has now a grid ...

[Carlos Costa]

It's done.
But I have a question: where will we put component styling?
I add an table.css file and linked in layout.html but I think it belongs to
the component.
I wish we would use Vue SFC format.
Now  is possible to use SFC components without using bundlers.


Em qui, 12 de set de 2019 às 09:52, Carlos Costa 
escreveu:

> I liked it.
> Much more faster and responsive.
>
> I didn't get how use search properly.
>
> I have on suggestion for letting grid more mobile friendly.
> Take a look at this snippet https://codepen.io/andornagy/pen/EVXpbR
> It is pure CSS.
> It transform columns into rows in a card style table.
> I have used it, it is very cool, and I think at least the grid should be
> mobile friendly.
> The only problem is that you must have a data-column attribute.
> I have used to manipulate the w2p grid in order to inject this attribute
> but this is very slow.
> The ideal is it to be generated with this attribute already.
> Maybe I can do a PR with this feature.
>
>
> Em qui, 12 de set de 2019 às 03:31, Massimo Di Pierro <
> massimo.dipie...@gmail.com> escreveu:
>
>> ... it is incomplete. It is experimental. The API is subject to change.
>> But I could use some community feedback:
>>
>> from py4web.utils.publisher import Publisher, ALLOW_ALL_POLICY
>>
>>
>> # exposes services necessary to access the db via ajax
>> publisher = Publisher(db, policy=ALLOW_ALL_POLICY)
>>
>>
>> # expose as /examples/grid
>> @action('grid')
>> @action.uses('grid.html')
>> def example_grid():
>>  return dict(grid=publisher.grid(db.person))
>>
>> embed in template with [[=grid]] in templates/grid.html as in web2py.
>> The difference from web2py is that the grid communicate with the server
>> via ajax and the style is in static/components/mtable.html
>> Still does not access authentication based access control but will add it
>> very soon.
>>
>> You can try it.
>> https://github.com/web2py/py4web/blob/master/apps/examples/__init__.py#L41
>>
>> --
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/web2py/cc53051f-104c-4b20-97a6-c32f8220d052%40googlegroups.com
>> <https://groups.google.com/d/msgid/web2py/cc53051f-104c-4b20-97a6-c32f8220d052%40googlegroups.com?utm_medium=email_source=footer>
>> .
>>
>
>
> --
> At.
>
> Carlos J. Costa
> --
> Cientista da Computação - Esp. Gestão em Telecom
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4Nz7EEikM52zCBtCo8TNg0zWBj2UM7-p-TjnSMDvyqmJZg%40mail.gmail.com.

Re: [web2py] py4web has now a grid ...

[Carlos Costa]

I liked it.
Much more faster and responsive.

I didn't get how use search properly.

I have on suggestion for letting grid more mobile friendly.
Take a look at this snippet https://codepen.io/andornagy/pen/EVXpbR
It is pure CSS.
It transform columns into rows in a card style table.
I have used it, it is very cool, and I think at least the grid should be
mobile friendly.
The only problem is that you must have a data-column attribute.
I have used to manipulate the w2p grid in order to inject this attribute
but this is very slow.
The ideal is it to be generated with this attribute already.
Maybe I can do a PR with this feature.


Em qui, 12 de set de 2019 às 03:31, Massimo Di Pierro <
massimo.dipie...@gmail.com> escreveu:

> ... it is incomplete. It is experimental. The API is subject to change.
> But I could use some community feedback:
>
> from py4web.utils.publisher import Publisher, ALLOW_ALL_POLICY
>
>
> # exposes services necessary to access the db via ajax
> publisher = Publisher(db, policy=ALLOW_ALL_POLICY)
>
>
> # expose as /examples/grid
> @action('grid')
> @action.uses('grid.html')
> def example_grid():
>  return dict(grid=publisher.grid(db.person))
>
> embed in template with [[=grid]] in templates/grid.html as in web2py.
> The difference from web2py is that the grid communicate with the server
> via ajax and the style is in static/components/mtable.html
> Still does not access authentication based access control but will add it
> very soon.
>
> You can try it.
> https://github.com/web2py/py4web/blob/master/apps/examples/__init__.py#L41
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/cc53051f-104c-4b20-97a6-c32f8220d052%40googlegroups.com
> 
> .
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4Nyoz3yZ61KDywA40Gk7iTFxRrdVKsUQxJYNPa1DBLUDXg%40mail.gmail.com.

Re: [web2py] Descriptografar senha do usuario

[Carlos Costa]

Não é possível.

Em qua, 21 de ago de 2019 às 11:30, Kimus  escreveu:

> Bom dia, estou com um leve probleminha, estou tentando atualizar um
> usuario sem o SQLFORM ou o FORM to fazendo na mão msm, lgoo preciso
> carregar os dados na tela para o usuario atualizar oq ele quiser dos seus
> dados, só que a senha vem criptografadas, gostaria de saber se tem alguma
> forma de descrioptografar essa senha só para colocar ela no input
>
> obg desde ja agradeç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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/855c52d8--476d-b8e9-27249fbb53ff%40googlegroups.com
> 
> .
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4NyFZaJKuC_Tui4baMBq2aG8M4rGzOEaSiR%3DyAHvEXQeWQ%40mail.gmail.com.

Re: [web2py] Re: please help testing web3py

[Carlos Costa]

What is the state of the _scafold? I was not able to register as user.
Need some help on it?

Em ter, 9 de jul de 2019 às 13:05, Stephan  escreveu:

> Okay, with the updated pydal, the errors have disappeared. I succeeded
> cloning a scaffolding app. However, when I try to register in my new app
> (page: http://127.0.0.1:8000/lovit/auth/register) I get an 404:
> WARNING:tornado.access:404 POST /_scaffold/auth/api/register (127.0.0.1)
> 1.47ms
>
> There is a new link to the documentation now on the startpage. I'm not
> sure if it's just a dummy but it does not work. Favicons are missing.
>
> If you need support for the user guide, maybe I can help and evaluate the
> texts from the noob's point of view. I'd recommend that a description of
> the docker installation process be included, since this seems to be the
> best way to publish I suppose.
>
>
> Am Dienstag, 9. Juli 2019 06:45:48 UTC+2 schrieb Massimo Di Pierro:
>>
>> LOL. I love the spinnig gears.
>>
>> You have an older version of pydal. Can you uninstall and pip3 install it
>> again
>>
>> On Monday, 8 July 2019 16:04:23 UTC-7, Stephan wrote:
>>>
>>> As far as I can tell, it works under macOS 10.14.5, I was able to
>>> generate a new app from the admin dashboard.
>>> However, apart from the missing favicon, the console reports these
>>> errors:
>>>
>>> ERROR:root:Traceback (most recent call last):
>>>
>>>   File
>>> "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/web3py/core.py",
>>> line 429, in wrapper
>>>
>>> ret = func(*func_args, **func_kwargs)
>>>
>>>   File
>>> "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site-packages/web3py/core.py",
>>> line 395, in wrapper
>>>
>>> ret = func(*args, **kwargs)
>>>
>>>   File "/Users/stp/Sites/web3py/myapps/_dashboard/__init__.py", line
>>> 178, in api
>>>
>>> from pydal.restapi import RestAPI, ALLOW_ALL_POLICY, DENY_ALL_POLICY
>>>
>>> ModuleNotFoundError: No module named 'pydal.restapi'
>>>
>>>
>>> Please remove these spinning gears!
>>>
>>>
>>>
>>>
>>>
>>> Am Sonntag, 7. Juli 2019 05:57:26 UTC+2 schrieb Massimo Di Pierro:

 Let's test the dashboard today:

 # download web2py from pypi

 python3 -m pip install web3py

 # start it:

 web3py-start myapps

 (pick a one time password  and answer yes when it wants to create
 something, it will create myapps folder and a temp .web3py-service folder)

 # open browser

 http://127.0.0.1:8000/_dashboard

 Now create a new app by cloning scaffold

 Does it work?
 How does it flow?
 What explanations should be necessary?
 Can you write a brief documentation of your experience for other users?


 --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/fa75969d-de34-40a0-a63d-146dc2db44fa%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4Nwe6VZ8oqx1UKmUhaYXotzXW_6g%3Dsnc1qritn07Ls_4eg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] please help testing web3py

[Carlos Costa]

I was able to install, start and create app without problems on Ubuntu 19.4

Em ter, 9 de jul de 2019 às 09:43, Jim Steil  escreveu:

> Works for me now.  I deleted myapps and retried.  Didn't work, got a
> database error (unfortunately, I didn't copy it).  Then python3 -m pip
> install --upgrade web3py.  Worked after that.
>
> -Jim
>
> On Mon, Jul 8, 2019 at 11:44 PM Massimo Di Pierro <
> massimo.dipie...@gmail.com> wrote:
>
>> please delete the apps folder and let it re-create it
>>
>> On Sunday, 7 July 2019 22:10:47 UTC-7, Nico Zanferrari wrote:
>>>
>>> It runs fine on Windows 10, too.
>>> But I'm not able to create a new user and it also complains about
>>> missing favicon.ico.
>>>
>>> Nico
>>>
>>> Il Lun 8 Lug 2019, 01:56 黄祥  ha scritto:
>>>
 run well on docker container : ubuntu and mac

 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.
 To view this discussion on the web visit
 https://groups.google.com/d/msgid/web2py/7f68121a-d157-4445-97e1-57aff3ed8fd0%40googlegroups.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 a topic in the
>> Google Groups "web2py-users" group.
>> To unsubscribe from this topic, visit
>> https://groups.google.com/d/topic/web2py/Jm30RfBpLLo/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to
>> web2py+unsubscr...@googlegroups.com.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/web2py/14ce78c3-aea3-47b5-babd-f3b04c4a8bbd%40googlegroups.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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/CAERBpoDarxt7CsQhxACVd9mrLYQm%3DVTcHeygz3jFM%2BSSTxpbCA%40mail.gmail.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4NxN4z%3DJOBi9%2BbUnoNGxcAySoyB3LP%3DVughoE02Q%3DHkW_Q%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] route 53 or Dns record

[Carlos Costa]

That's good! Not perfect, since after the user is redirected, the URL gets
ugly anyway.
But is quite good.
My domains are not registered in godaddy, but I can migrate to it some day.
Thanks for sharing.

Em ter, 4 de jun de 2019 às 13:19, karthikeyan p <
karthikiotdevelo...@gmail.com> escreveu:

> hai carlos costa , i have an idea for that , i have domain registered with
> godaddy , go daddy subdomain forwarding is unlimited and its free too . you
> can add like this
> in subdomain section add subdomainname as *user1* , target url is 
> *your.pythonanywhere.com/welcome/default/index/user
> <http://your.pythonanywhere.com/welcome/default/index/user>*1 , when*
> user1.yourdomain.com <http://user1.yourdomain.com>* is called you can
> redirect to  *your.pythonanywhere.com/welcome/default/index/user
> <http://your.pythonanywhere.com/welcome/default/index/user>*1
>
> this is my current technique . one good thing is, you have *api* for
> adding subdomain to your dns registry in godaddy.
>
>
>
> On Mon, Jun 3, 2019 at 2:14 AM Carlos Costa 
> wrote:
>
>> It is not possible withou hiring extra web apps.
>> Pythonanywhere requires on web app per subdomain or domain.
>>
>> I move recently to pythonanywhere, because of aws costs.
>> I am happy with evertything in pythonanywhere, unless with this topic.
>> I had to give up the subdomain per user strategy.
>>
>> I moved to a single url strategy in wich I setup on main app as central
>> authentication.
>> My problem is I have one DB for each account and that was too easy to
>> achieve with sudbomains.
>>
>> Em dom, 2 de jun de 2019 às 10:48, karthikeyan p <
>> karthikiotdevelo...@gmail.com> escreveu:
>>
>>> Can i do it with pythonanywhere.com if i am a paid user??
>>>
>>> I have api and program to add/delete/edit dns record in godaddy
>>>
>>> If it is possible to make it with pythonanywhere.com , i am happy somuch
>>>
>>> On Sun, 2 Jun 2019 at 7:16 PM, karthikeyan p <
>>> karthikiotdevelo...@gmail.com> wrote:
>>>
>>>> Thanks alot  for reply . I will try this idea and let you know
>>>>
>>>> On Sun, 2 Jun 2019 at 7:09 PM, Carlos Costa 
>>>> wrote:
>>>>
>>>>> I was about to do this before I gave up on aws because of costs.
>>>>> So I don't know exactly what have to be done.
>>>>> But what I think you have to do is:
>>>>> -use aws api or cli to insert the record on route53 dns
>>>>> -add the respective entry on routes.py on web2py folder
>>>>>  for this maybe you want to store a list of domains in a separate
>>>>> file, a yaml file for example and modify routes.py to read the domains
>>>>> configuration from it
>>>>>  a yaml or plain text file will be easier to parse and feed
>>>>> -force web2py to reload routes
>>>>>  maybe hiting the url on the button we click in admin, or calling the
>>>>> required function internally (I don't know the function now)
>>>>>
>>>>>
>>>>> Em sáb, 1 de jun de 2019 às 15:24, karthikeyan p <
>>>>> karthikiotdevelo...@gmail.com> escreveu:
>>>>>
>>>>>> i have two users  -> *ONE *and *TWO*
>>>>>>
>>>>>> www.example.com/welcome/default/index/*ONE => *if i poster args ONE
>>>>>> ,it will show user ONE's page
>>>>>>
>>>>>> www.example.com/welcome/default/index/*TWO **=> *if i poster args
>>>>>> TWO,it will show user TWO's page
>>>>>>
>>>>>> i want to do :
>>>>>>
>>>>>> one.example.com *=> *to show user ONE's page.
>>>>>>
>>>>>> two.example.com *=> *to show user TWO's page.
>>>>>>
>>>>>> i know that the url prefix record will be added to DNS record.
>>>>>>
>>>>>> i have a domain in godaddy ,they provide api to do this
>>>>>> programmatically.
>>>>>>
>>>>>> if a user signed up in my page i want to make their name as prefix of
>>>>>> my dns . (except ftp ,www. smtp etc)
>>>>>>
>>>>>> any idea ?? any altenatives ?
>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Resources:
>>>>>> - http://web2py.com
>>>>>> - http://web2py.com/book (Documentation)
>

Re: [web2py] route 53 or Dns record

[Carlos Costa]

It is not possible withou hiring extra web apps.
Pythonanywhere requires on web app per subdomain or domain.

I move recently to pythonanywhere, because of aws costs.
I am happy with evertything in pythonanywhere, unless with this topic.
I had to give up the subdomain per user strategy.

I moved to a single url strategy in wich I setup on main app as central
authentication.
My problem is I have one DB for each account and that was too easy to
achieve with sudbomains.

Em dom, 2 de jun de 2019 às 10:48, karthikeyan p <
karthikiotdevelo...@gmail.com> escreveu:

> Can i do it with pythonanywhere.com if i am a paid user??
>
> I have api and program to add/delete/edit dns record in godaddy
>
> If it is possible to make it with pythonanywhere.com , i am happy somuch
>
> On Sun, 2 Jun 2019 at 7:16 PM, karthikeyan p <
> karthikiotdevelo...@gmail.com> wrote:
>
>> Thanks alot  for reply . I will try this idea and let you know
>>
>> On Sun, 2 Jun 2019 at 7:09 PM, Carlos Costa 
>> wrote:
>>
>>> I was about to do this before I gave up on aws because of costs.
>>> So I don't know exactly what have to be done.
>>> But what I think you have to do is:
>>> -use aws api or cli to insert the record on route53 dns
>>> -add the respective entry on routes.py on web2py folder
>>>  for this maybe you want to store a list of domains in a separate file,
>>> a yaml file for example and modify routes.py to read the domains
>>> configuration from it
>>>  a yaml or plain text file will be easier to parse and feed
>>> -force web2py to reload routes
>>>  maybe hiting the url on the button we click in admin, or calling the
>>> required function internally (I don't know the function now)
>>>
>>>
>>> Em sáb, 1 de jun de 2019 às 15:24, karthikeyan p <
>>> karthikiotdevelo...@gmail.com> escreveu:
>>>
>>>> i have two users  -> *ONE *and *TWO*
>>>>
>>>> www.example.com/welcome/default/index/*ONE => *if i poster args ONE
>>>> ,it will show user ONE's page
>>>>
>>>> www.example.com/welcome/default/index/*TWO **=> *if i poster args
>>>> TWO,it will show user TWO's page
>>>>
>>>> i want to do :
>>>>
>>>> one.example.com *=> *to show user ONE's page.
>>>>
>>>> two.example.com *=> *to show user TWO's page.
>>>>
>>>> i know that the url prefix record will be added to DNS record.
>>>>
>>>> i have a domain in godaddy ,they provide api to do this
>>>> programmatically.
>>>>
>>>> if a user signed up in my page i want to make their name as prefix of
>>>> my dns . (except ftp ,www. smtp etc)
>>>>
>>>> any idea ?? any altenatives ?
>>>>
>>>>
>>>>
>>>> --
>>>> 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.
>>>> To view this discussion on the web visit
>>>> https://groups.google.com/d/msgid/web2py/1cfce879-730d-46c0-b59b-2800d2b67954%40googlegroups.com
>>>> <https://groups.google.com/d/msgid/web2py/1cfce879-730d-46c0-b59b-2800d2b67954%40googlegroups.com?utm_medium=email_source=footer>
>>>> .
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>
>>> --
>>> At.
>>>
>>> Carlos J. Costa
>>> --
>>> Cientista da Computação - Esp. Gestão em Telecom
>>>
>>> --
>>> 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 a topic in the
>>> Google Groups "web2py-users" group.
>>> To unsubscribe from this topic, visit
>>> https://groups.google.com/d/topic/web2py/H9GXvTn6fcE/unsubscribe.
>>> To unsubscribe from this group and all its t

Re: [web2py] route 53 or Dns record

[Carlos Costa]

I was about to do this before I gave up on aws because of costs.
So I don't know exactly what have to be done.
But what I think you have to do is:
-use aws api or cli to insert the record on route53 dns
-add the respective entry on routes.py on web2py folder
 for this maybe you want to store a list of domains in a separate file, a
yaml file for example and modify routes.py to read the domains
configuration from it
 a yaml or plain text file will be easier to parse and feed
-force web2py to reload routes
 maybe hiting the url on the button we click in admin, or calling the
required function internally (I don't know the function now)


Em sáb, 1 de jun de 2019 às 15:24, karthikeyan p <
karthikiotdevelo...@gmail.com> escreveu:

> i have two users  -> *ONE *and *TWO*
>
> www.example.com/welcome/default/index/*ONE => *if i poster args ONE ,it
> will show user ONE's page
>
> www.example.com/welcome/default/index/*TWO **=> *if i poster args TWO,it
> will show user TWO's page
>
> i want to do :
>
> one.example.com *=> *to show user ONE's page.
>
> two.example.com *=> *to show user TWO's page.
>
> i know that the url prefix record will be added to DNS record.
>
> i have a domain in godaddy ,they provide api to do this programmatically.
>
> if a user signed up in my page i want to make their name as prefix of my
> dns . (except ftp ,www. smtp etc)
>
> any idea ?? any altenatives ?
>
>
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/1cfce879-730d-46c0-b59b-2800d2b67954%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4NxBT_32PK0c4co%2BJmYOyWvPG%2Byb-ksy2WwzvufFEjW1VQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: How can I generate hash for user password like web2py

[Carlos Costa]

If you can use web2py itself for this task, dot it like this:
hash = CRYPT()('text to hash')[0]

Em qua, 29 de mai de 2019 às 19:05, João Matos 
escreveu:

> I use Python's hashlib module. It contains pbkdf2.
>
> segunda-feira, 27 de Maio de 2019 às 12:13:54 UTC+1, Константин Комков
> escreveu:
>>
>> Can somebody told about free library for windows (.dll) which can
>> generate hash of password like web2py (pbkdf2 + sha512)?
>>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/8155e38e-8a25-479f-b8b8-73dc31a6d0a1%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4NyYpkgJDQbPWxhmUm9Am7zuYYnWpCEhqvWxUhL%2BGwmqxQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: A little suggestion: Create a forum for web3py

[Carlos Costa]

I don't agree this is reinvent the wheel.
Maybe Slack is reinventing the wheel.
Reinvent the wheel, from the Cambridge dictionary:

> to waste time trying to create something that someone else has already
> created


We are having a good experience with chat support on telegram group.
There is already a long running Brazilian group where we have a great
experience, and recently we opened a World group, for support in English.
We will probably create a Telegram group for Web3py too.
A good chat sometimes is faster and we can communicate other kind of
subjects related to web2py too.
It has its advantages but also disadvantages.
For example, it is not good for indexing things on topics for later search.
For that, a typical mailing list is still better.
Also, slack seems to have some limitations on free accounts.

I don't oppose to creating a slack account, but I oppose not creating also
a typical forum.




Em qua, 29 de mai de 2019 às 13:45, António Ramos 
escreveu:

> Do we need to reinvent the wheel again ?
> why not  use for ex...
>
> https://slack.com
>
> or many others out there?
>
>
> Em sex, 24 de mai de 2019 às 21:41, Dave S 
> escreveu:
>
>>
>>
>> On Friday, May 24, 2019 at 10:14:24 AM UTC-7, Ari Lion BR Sp wrote:
>>>
>>> In this while, please join us on our Telegram Group...
>>>
>>> https://t.me/web2py_world
>>>
>>> !!!
>>> Thanks!
>>>
>>
>>
>> Maybe I'm too old-school, but having to set up Telegram on my phone in
>> order to use Telegram on the web (with a decent-sized screen) to be really
>> annoying.
>>
>> /dps
>>
>>
>>
>>>
>>> Em sexta-feira, 24 de maio de 2019 05:15:09 UTC-3, Massimo Di Pierro
>>> escreveu:

 yes. but after it is officially released.

 On Wednesday, 22 May 2019 18:24:44 UTC-7, Daniel Guilhermino wrote:
>
> Hi,
>
> I believe that over time the web2py/web3py forum mixing the two
> frameworks in the same place will be very polluted and probably will even
> create confusion for users. I would like suggest setting up a specific
> forum for web3py.
>
> Best regards,
>
> Daniel Guilhermino
>
 --
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/web2py/073e3554-4550-47f8-8302-31387caa4d86%40googlegroups.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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/CAEM0BxOvh654VfubzmQLpujTpw6rgUASPM0BZhtDgAxSck1Dnw%40mail.gmail.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4NwnYujv-c2G-FEvh-n8mJW%2BjxkPMOw-Ba2HKn8x9kKcFg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: web2py managing capacity ?

[Carlos Costa]

sociability?

Em sex, 24 de mai de 2019 às 05:18, 黄祥 
escreveu:

> how to use it with postgresql ?
>>
>
> pls set the uri connection first
> *e.g. private/appconfig.ini*
> uri = postgres://postgres:password@localhost/database_name
>
> *ref:*
>
> http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Connection-strings-the-uri-parameter-
>
>
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/9a708b39-7b1e-4c77-a4b3-49b7bdac9215%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4Nw626C_QyRFDH0wz1bJ52WROSubFequnb4-p1h1WB5BOA%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Electron, NWjs or Netralinojs and web2py

[Carlos Costa]

I did it with python cef and was easy.

Em qui, 23 de mai de 2019 às 11:08, rāma  escreveu:

> Hi,
>
> Is there anyone working on packaging web2py as an webview app?
>
> Is it easily deployable with these kits?
>
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/f53f9374-d9ee-45e2-aa29-04988789172e%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4NxKft2Evw47D4r9poVmG9xQMBz2_TxTAnATSmpGVXMY2g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: new DBAPI in pydal for both web2py and web3py

[Carlos Costa]

+1 restapi

Em sáb, 18 de mai de 2019 às 06:58, Massimiliano 
escreveu:

> +1 for restapi :-)
>
> On Saturday, May 18, 2019 at 7:30:47 AM UTC+2, Massimo Di Pierro wrote:
>>
>> How about restapi or friendlyql?
>>
>> I do not want to tie this to web3py or dal too much. there is no reason
>> this syntax cannot be ported to other ORMs
>>
>> On Friday, 17 May 2019 10:02:24 UTC-7, John Bannister wrote:
>>>
>>> As you are da man I would suggest DaQL .. DALQL is a bit of a mouth full
>>> J
>>>
>>>
>>>
>>> *From:* web...@googlegroups.com [mailto:web...@googlegroups.com] *On
>>> Behalf Of *Massimiliano
>>> *Sent:* 17 May 2019 18:56
>>> *To:* web...@googlegroups.com
>>> *Subject:* Re: [web2py] Re: new DBAPI in pydal for both web2py and
>>> web3py
>>>
>>>
>>>
>>> DALQL
>>>
>>>
>>>
>>>
>>>
>>> On Fri, May 17, 2019 at 5:42 PM Massimo Di Pierro 
>>> wrote:
>>>
>>> I am embarrassed I have forgotten all about latin. :-(
>>>
>>>
>>>
>>> The italian equivalent would be "accesso" but does not sound nice to me.
>>>
>>>
>>>
>>> I am not too concerned about naming conflicts as long as the name is
>>> simple to remember and conveys what it does.
>>>
>>> After all it is the name of a file and a class, not a package.
>>>
>>>
>>>
>>> I do not think Gate/ Bus, etc convey it. {something}QL would be nice but
>>> {anything simple}QL appears to be taken.
>>>
>>> Also this is not just a QL as it supports all rest methods with policies.
>>>
>>>
>>>
>>> Massimo
>>>
>>>
>>>
>>>
>>>
>>> --
>>> 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 web...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/web2py/059b32ee-e5f0-45d4-800f-cfee8d353202%40googlegroups.com
>>> 
>>> .
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>>
>>>
>>>
>>> --
>>>
>>> Massimiliano
>>>
>>> --
>>> 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 web...@googlegroups.com.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/web2py/CANPTPxJumAdQ3veA%3Dw76xbrAD-aFLDZoyrzhTQJ9Nu88HzZt9Q%40mail.gmail.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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/dae7d0f9-f42e-47df-8eec-409f7b520710%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4Nycs1_9L2sJdpwaX8hZVi9d2vMqo6TzwegHCNcczEJtbw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: new DBAPI in pydal for both web2py and web3py

[Carlos Costa]

I liked it, sounds Italian.
Sometimes when you have a restriction it inspires creativity.
For example, if we would have a rule to give only Italian (Massimo origin
is the reason here) names to Web2py stuff (web2py itself included) we could
come up with more natural and interesting names.
Like Django. It sounds natural and cool. But I don't like the framework.
But I believe it's one thing the helps spread the word and make it
well known.
I love web2py and I am already loving web3py but surely do not love these
names, neither the fact web2py is little known these days.
I really hope that web3py will be the next top fullstack web framework, and
will contribute for that. But this name does not help.

Em sex, 17 de mai de 2019 às 10:03, António Ramos 
escreveu:

> there we go again about naming something ...
>
> Jut call it Gluino! to glue data to the app..
>
> Em sex, 17 de mai de 2019 às 11:37, villas  escreveu:
>
>> acquisAPI
>>
>> acquis Shortened from acquis communautaire: French acquis (“that which
>> has been acquired or obtained”) + communautaire (“of the community”).
>>
>>
>>
>>
>> On Thursday, 16 May 2019 07:33:21 UTC+1, Massimo Di Pierro wrote:
>>>
>>> how about we simply call it "Access"?
>>>
>>> On Wednesday, 15 May 2019 06:58:37 UTC-7, Anthony wrote:

 On Wednesday, May 15, 2019 at 12:53:27 AM UTC-4, Massimo Di Pierro
 wrote:
>
> We can change the name but api is too ambiguous. Any other idea?
>

 Not sure. RESTAPI? HTTPAPI?

>>> --
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/web2py/b89a5a76-8692-40f9-b797-4eebfec67cca%40googlegroups.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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/CAEM0BxM9zSuGORmypOr2Tw6BCnYpidNZegG%3DP0J2EpMO0DCBaA%40mail.gmail.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4Nz6mgPmkVaL-mW94KCxbp5%3Dmif5b%2BSopFPRLpk3Dk3cmw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

[web2py] Re: new DBAPI in pydal for both web2py and web3py

[Carlos Costa]

Aweome!

I made a similar API for my apps, but is simpler.
I like this one more as it is more complete.

Mine is called Consult (because we call query as consulta in Portuguese)
This is very useful to integrate ui components such as datatable, or 
anything.

Maybe dal-api should be a good name.
If you want to use Consult, it is ok if it make sense for you, lol.


Em terça-feira, 14 de maio de 2019 03:18:42 UTC-3, Massimo Di Pierro 
escreveu:
>
> You may have missed this but there is a new functionality in PyDAL that 
> allows you to create very powerful APIs. It is called DBAPI.
> It is still not 100% stable but it is working and I could use some help 
> testing it.
> web3py's equivalent of appadmin will be called dbadmin (90% done) and it 
> is based on DBAPI.
> Even if primarily designed for web3py it works for web2py too and you can 
> find some preliminary examples below.
> Hope it is self-explanatory.
>
> DBAPI EXAMPLES 
>
> Inspired by GraphQL but not quite the same
>
> Less powerful but simpler to use
>
> Self descriptive (@model=True) and policy based (policy set serverside)
>
> Support complex queries like: 
>
>- name.eq=Clark Kent
>- name.ne=Clark Kent
>- name.gt=Clark Kent
>- name.lt=Clark Kent
>- name.ge=Clark Kent
>- name.le=Clark Kent
>- name.startswith=Clark
>- name.contains=Kent
>- not.real_identity.name.contains=Wayne
>- not.superhero.tag.superpower.description.eq=Flight
>
> Support de-normalization: 
>
>- @lookup=real_identity
>- @lookup=real_identity[name]
>- @lookup=real_identity[name,job]
>- @lookup=identity:real_identity[name,job]
>- @lookup=identity!:real_identity[name,job]
>- @lookup=superhero.tag
>- @lookup=superhero.tag[strength]
>- @lookup=superhero.tag[strength].superpower
>- @lookup=superhero.tag[strength].superpower.description
>
> Fast. Even the most complex query is implemented with at most 2 selects + 
> 1 select for each denormalized link table
> Example Model 
>
> db.define_table(
> 'person',
> Field('name'),
> Field('job'))
>
> db.define_table(
> 'superhero',
> Field('name'),
> Field('real_identity', 'reference person'))
>
> db.define_table(
> 'superpower',
> Field('description'))
>
> db.define_table(
> 'tag',
> Field('superhero', 'reference superhero'),
> Field('superpower', 'reference superpower'),
> Field('strength', 'integer'))
>
> Example Controller 
>
> from pydal.dbapi import DBAPI, Policy
> policy = Policy()
> policy.set('*', 'GET', authorize=lambda tablename, id, get_vars, 
> post_vars:True, allowed_patterns=['*'])
> policy.set('*', 'PUT', authorize=lambda tablename, id, get_vars, 
> post_vars:False)
> policy.set('*', 'POST', authorize=lambda tablename, id, get_vars, 
> post_vars:False)
> policy.set('*', 'DELETE', authorize=lambda tablename, id, get_vars, 
> post_vars:False)
>
> def api():
> return DBAPI(db, policy)(request.method, request.args(0), request.args(1),
>  request.get_vars, request.post_vars)
>
> Example GET URLs 
> /superheroes/default/api.json/superhero 
>
> {
> "count": 3,
> "status": "success",
> "code": 200,
> "items": [
> {
> "real_identity": 1,
> "name": "Superman",
> "id": 1
> },
> {
> "real_identity": 2,
> "name": "Spiderman",
> "id": 2
> },
> {
> "real_identity": 3,
> "name": "Batman",
> "id": 3
> }
> ],
> "timestamp": "2019-05-14T06:14:06.764966",
> "api_version": "0.1"
> }
>
> /superheroes/default/api.json/superhero&@model=true 
>
> {
> "status": "error",
> "timestamp": "2019-05-14T06:14:06.997662",
> "message": "Invalid table name: superhero_amp_@model=true",
> "code": 400,
> "api_version": "0.1"
> }
>
> /superheroes/default/api.json/superhero?@lookup=real_identity 
>
> {
> "count": 3,
> "status": "success",
> "code": 200,
> "items": [
> {
> "real_identity": {
> "name": "Clark Kent",
> "job": "Journalist",
> "id": 1
> },
> "name": "Superman",
> "id": 1
> },
> {
> "real_identity": {
> "name": "Peter Park",
> "job": "Photographer",
> "id": 2
> },
> "name": "Spiderman",
> "id": 2
> },
> {
> "real_identity": {
> "name": "Bruce Wayne",
> "job": "CEO",
> "id": 3
> },
> "name": "Batman",
> "id": 3
> }
> ],
> "timestamp": "2019-05-14T06:14:06.931746",
> "api_version": "0.1"
> }
>
> /superheroes/default/api.json/superhero?@lookup=identity:real_identity 
>
> {
> "count": 3,
> "status": "success",
> "code": 200,
> 

Re: [web2py] Re: Future of web2py

[Carlos Costa]

I don't think all PWA cases must work 100% offline.
For 100% offline apps you just need a server to "install" your app, and so
web2py would be handy, but no more after install in client.
This is not case we should aim as web2py as focused on database driven apps.

Sync database may be desirable in some cases but no viable in many cases.
For most cases you want to cache a bit of data, like user data for example.
Think of a ordering or data collecting app, you may want to cache
items/products and also the order and sync it later.
For me this would be awesome but a little complicated.

My opinion is that for now if scaffold helped you to be eligible for A2HS
feature and cache static assets in client, it would be very helpful.

Em seg, 13 de mai de 2019 às 07:46, Val K  escreveu:

> my example is not fully featured PWA, but it works offline and as I
> mentioned above it is possible to make that web23py application will show
> something better than nothing when offline
>
> --
> 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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/fd6ea76b-7d3b-4704-886b-a2e6bc4d6e47%40googlegroups.com
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4NxhgGCB%3D9VndXzS4-ZsKMOtgQnbG0BJzLJbnFo29xQeDQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: Future of web2py

[Carlos Costa]

Untill this moment, for me, it means that in a second run, the app can open
instantly, mostly because of cached assets.
It does not mean that it will always partially work offline. It depends on
the need.
I think most apps made with web2py (and maybe web3py will be in the same
case) are dependent on server data and interactions.
Most data cannot be cached.
So it's my case.

One advantage of PWA is it being elligible for the A2HS (add to home
screen) funcionality.
Sometimes it is not viable for the user have installed a native mobile
version of a web app for long time, because the use is not frequent.

Basically, we need:
1 - a manifest.json
2 - icons referenced in the manifest.json, used to build the thome icon and
the splash screen
3 - a service worker js to be registered for the app, to be served at app
root. In web2py it is done with routes.py
4 - (optional) workbox to cache automatically all the app assets. (I
haven't got this working yet)

The first 3 steps are the only need to the browser display the A2HS pop up.






Em sáb, 11 de mai de 2019 às 19:07, Massimo Di Pierro <
massimo.dipie...@gmail.com> escreveu:

> I agree with the article. It is unclear to me that people agree about the
> meaning of pwa. Does it mean you can run the app locally as in web2py and
> access via the browser? (web2py and web3py can do this) or does it mean
> that the app is mostly client-side and you can run the client (in browser
> or cordova) without any interaction with a server? This is possible but it
> is up to the developer of the front-end. but  is it useful?
>
> On Saturday, 11 May 2019 00:40:35 UTC-7, mweissen wrote:
>>
>> I think, progessive web applications are a very important way to create
>> native-like apps and it would be nice, if web3py could support pwas. There
>> is an interesting article about the future of pwas:
>>
>> https://enonic.com/progressive-web-apps
>>
>> Regards, Martin
>>
>> Am Sa., 11. Mai 2019 um 05:45 Uhr schrieb 黄祥 <
>> steve.van.chris...@gmail.com>:
>>
>>> What is pwa?
>>>
>>>
>>> ref:
>>> https://en.wikipedia.org/wiki/Progressive_web_applications
>>> https://developers.google.com/web/progressive-web-apps/
>>> https://developer.mozilla.org/en-US/docs/Web/Progressive_web_apps
>>>
>>> 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.
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/web2py/d4d39e2f-0ab5-400b-b46a-ceaa9ef3da18%40googlegroups.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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/4b9537f9-013f-49b3-a72a-b4749ee64596%40googlegroups.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4Nys-5ovCVsLsoRd_4jnJhk%2B%2BEjd1mao%3Df_1RQA3pY5mKg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: Future of web2py

[Carlos Costa]

Recently Google released official support to PWAs in Play Store.

So, if a web2py or web3py scaffoles ships with PWA support, it will be easy
to deploy it on web and Play Store
We would be able make web and mobile apps easily.

This technique is saving me hours and hours.

Em sáb, 11 de mai de 2019 às 04:40, Martin Weissenboeck 
escreveu:

> I think, progessive web applications are a very important way to create
> native-like apps and it would be nice, if web3py could support pwas. There
> is an interesting article about the future of pwas:
>
> https://enonic.com/progressive-web-apps
>
> Regards, Martin
>
> Am Sa., 11. Mai 2019 um 05:45 Uhr schrieb 黄祥  >:
>
>> What is pwa?
>>
>>
>> ref:
>> https://en.wikipedia.org/wiki/Progressive_web_applications
>> https://developers.google.com/web/progressive-web-apps/
>> https://developer.mozilla.org/en-US/docs/Web/Progressive_web_apps
>>
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/web2py/d4d39e2f-0ab5-400b-b46a-ceaa9ef3da18%40googlegroups.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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/CAMcwXCevb4KiOgh-OVjXvOQYwb%3DVPYVxT52S_hx6ukEQAAXmAA%40mail.gmail.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4NyFF6Btk29CPjw9TobbUN8SMw2PxiSmTdYVz5HkBK68DQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: Future of web2py

[Carlos Costa]

I am developing this on web2py apps and I plan to contribute with it on
web3py.

Em sex, 10 de mai de 2019 às 03:35, Martin Weissenboeck 
escreveu:

> Is it planned that web3py will support the development of PWAs?
> Martin
>
> Am Fr., 10. Mai 2019 um 03:58 Uhr schrieb Massimo Di Pierro <
> massimo.dipie...@gmail.com>:
>
>> Good question.
>>
>> We are not dropping web2py support. We will continue improve web2py. You
>> may have seen a lot of work in that direction recently, mostly thanks to
>> Paolo. Also over the years we made web2py work with python 3.
>>
>> Yet web2py is showing its age. If you are building something new I will
>> recommend you use web3py. It will be usable by the end of May and stable by
>> July. If you want to port your existing apps to python 3, rather than
>> staying with web2py + python 3, I would recommend you jump one more step
>> and port it directly to web3py. If you want to stick with python 2, you
>> will not have a choice.
>>
>> Massimo
>>
>>
>>
>>
>> On Wednesday, 8 May 2019 04:52:44 UTC-7, Rafael Oliveira wrote:
>>>
>>> Will web3py replace web2py? Will web2py end? Sorry for my English. I
>>> used the google translator.
>>>
>> --
>> 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.
>> To view this discussion on the web visit
>> https://groups.google.com/d/msgid/web2py/c99109e1-8e7b-46f7-ab17-a0912581f3ae%40googlegroups.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.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/web2py/CAMcwXCf6_8PiWvFtKB9YFPq_J2VxFsO%2BRbNcsAfVJ-nsGm96OQ%40mail.gmail.com
> 
> .
> For more options, visit https://groups.google.com/d/optout.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/CAGsD4NxZV26Pzgmp%2BNpMB7vk%3Dz%3DBAEOHb1%2BpbFq7MDkv_bvS8g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

Re: [web2py] Re: Future of web2py

[Carlos Costa]

Massimo,

could you create some issues related to these things to be done?
I will be easier if anyone wants to contribute.
I want to contribute but don't know exactly how.

Em qui, 2 de mai de 2019 às 09:16, rāma  escreveu:

> ONE month!? Sounds super exciting.
>
> On Thursday, 2 May 2019 15:16:21 UTC+8, Massimo Di Pierro wrote:
>>
>> yes. for my prospective it is very close to be done. we have:
>>
>> [x] more than x10 faster than web2py
>> [x] pydal (same as web2py)
>> [x] routing (like bottle or flask)
>> [x] T
>> [x] helpers (99% compatible with a web2py)
>> [x] template (same as web2py)
>> [x] sessions (in cookies, db, redis, memcache) (need more testing)
>> [90%] forms (very similar to web2py)
>> [50%] _dashboard (equivalent of admin)
>> [0%] grid
>> [0%] appadmin replacement
>> [0%] auth
>>
>> The last 3 will very different from web2py. grid will be more JS based.
>> appadmin will use the grid and be based on some variation collection/json
>> and/or graphql support for pydal. auth will be replaced by plugguble
>> modules and a simple database structure. groups will be replaced by generic
>> hierarchical tags. Maybe I will be done in one more month.
>>
>> I could use some help adding missing functions to _dashboard.
>>
>> On Tuesday, 30 April 2019 13:46:04 UTC-7, villas wrote:
>>>
>>> Check this out:
>>> https://github.com/web2py/web3py
>>>
>>> Search this current group for recent posts on 'web3py'.
>>>
>>> Regards, D
>>>
>>>
>>>
>>> On Tuesday, 30 April 2019 18:35:04 UTC+1, Gabor Nyul wrote:

 We are talking for about 2 years now about a possible web3py and other
 possible addons to it.
 What do you think, when we can get the first insight of it? If at all...

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


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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] bye bye T, welcome pluralize

[Carlos Costa]

Looks nice!

What would be the best approach to translate phrases and longer texts?

Em seg, 29 de abr de 2019 às 10:59, Carlos Cesar Caballero Díaz <
carlos.caball...@cfg.jovenclub.cu> escreveu:

> It looks good!! I can work to support categories if you think it worth it.
> Allow something like T("string", "category") or T("string",
> cat="category"). A category would map to an specific folder of json
> internationalization files, if there is no category specified, it will map
> to a default category. Something like this would make the translations
> reutilization easier.
>
> Greetings.
> El 26/4/19 a las 1:53 a.m., Massimo Di Pierro escribió:
>
> web3py now uses this:
>
> https://pypi.org/project/pluralize/
> https://github.com/web2py/pluralize
>
> thoughts? comments?
>
> --
> 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.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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] Enjoying web2py

[Carlos Costa]



Em qui, 18 de abr de 2019 às 08:25, Kevin Keller 
escreveu:

> Just wanted to say that im working on app on an old Acer one 32 bit 2gb
> machine with web2py, midori as Browser and Vim as code editor and I'm
> enjoying it a lot!
>
> Thanks for creating such a great batteries included framework.
>
> I barely had to touch html so far to get the prototype working and I
> didn't have to configuring or installing anything.
>
> It's pure productivity.
>
> --
> 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.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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: web3py again....

[Carlos Costa]

Will it have default url routes?

beyond that,  my thought about ui widgets:
I think it would be nice:
1 - to have an easy integration via a model rest api
2- be agnostice to client side frameworks
3 - come with a default client side framework (preferably vue)
4 - have a ui lib by default
5 - have a template for building custom ui widgets using vue (like single 
page components or something.) that integrates easily, 
maybe with some client api, with the server

Em quinta-feira, 28 de março de 2019 06:16:15 UTC-3, Massimo Di Pierro 
escreveu:
>
> I know this comes up once in a while but ...
>
> https://github.com/web2py/web3py
>
> what do you think? 
>
> It is very preliminary but I will have an admin soon.
> Backporting SQLFORM, grid and Auth, should not be that complicated, 
> although I think we can do better.
>
> Massimo
>
>

-- 
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: New International Telegram Support Group

[Carlos Costa]

we noticied this group has no administrator, so we are moving to a new one, 
here is the link https://t.me/joinchat/DYZrfBT-bIsVhwLZc1hG8Q 


Em terça-feira, 19 de março de 2019 12:14:17 UTC-3, Carlos Costa escreveu:
>
> We have had a good experience with the brazilian telegram group dedicated 
> to to support web2py users.
>
> But the english speaking group is not used at.
>
> Here is the link to join it: https://t.me/web2py_en
>
> Also, here is the link to the Brazilian group (portuguese speaking and 
> some portunhol allowed too :D ): https://t.me/web2pybrasil
>

-- 
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] New International Telegram Support Group

[Carlos Costa]

We have had a good experience with the brazilian telegram group dedicated 
to to support web2py users.

But the english speaking group is not used at.

Here is the link to join it: https://t.me/web2py_en

Also, here is the link to the Brazilian group (portuguese speaking and some 
portunhol allowed too :D ): https://t.me/web2pybrasil

-- 
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] Can I do INSERT INTO statement with DAL syntax ?

[Carlos Costa]

I think it is not possible yet.
If you don't care about performance, in this case you can do it by code.
But if you care, use db.executesql...

Em sex, 12 de out de 2018 às 12:44, icodk  escreveu:

> something like :
>
> INSERT INTO Customers (CustomerName, City, Country)
> SELECT SupplierName, City, Country FROM Suppliers
> WHERE Country=1;
>
>
> --
> 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.
>


-- 
At.

Carlos J. Costa
--
Cientista da Computação - Esp. Gestão em Telecom

-- 
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: Web2Py + VueJS SPA (Webpack)

[Carlos Costa]

This bootstrap-vue.js transparently integrated with web2py  backend woud be
a dream.
IMO this would be half the web3py.

2017-12-04 11:42 GMT-02:00 :

> Hi Massimo, I thought you might be interested in this:
> https://bootstrap-vue.js.org/
>
> Quite a new project, MIT license, currently under very active development
> mainly by a Canadian and an Iranian.
>
>
>
> On Tuesday, November 14, 2017 at 12:36:52 PM UTC-7, Massimo Di Pierro
> wrote:
>>
>> This is fantastic. Thank you Carlos,
>> please email me personally about you work. I think this is the path to
>> the future of web2py.
>>
>> On Tuesday, 14 November 2017 10:48:03 UTC-6, Carlos A. Armenta Castro
>> wrote:
>>>
>>> I have using Web2Py for too many years for commercial websites and for
>>> Intranets in México, I want to say that Web2Py is an AMAZING Framework!!!
>>> For my new project I need to use an SPA VueJs + Webpack for the
>>> FrontEnd  ( http://quasar-framework.org/ ) and a Web2Py as my BackEnd
>>> API Server.
>>> I'm curious about to integrate his two web frameworks using web2py
>>> routes to serve this two apps in the same port but different URL.
>>>
>>> Example:
>>> http://127.0.1.1/welcome/api ---> My Web2py API Controller
>>> http://127.0.1.1/welcome   ---> My VueJS APP with webpack  (
>>> http://quasar-framework.org/ ) <-- Pointing to index.html in *dist/ *
>>> and permit to use all the static files deposited in the same path
>>> *dist/**
>>>
>>> *VueJS + Webpack APP Structure*
>>>
>>> ├── *dist/ * *# Compiled APP (Serve this files as the 
>>> static SPA)*
>>> │   *└── index.html
>>> │   ├── fonts/
>>> │   │   └── ...
>>> │   ├── static/
>>> │   │   └── ...
>>> │   ├── js/
>>> │   │   └── ...*
>>> ├── config/
>>> │   ├── index.js# main project config
>>> │   └── ...
>>> ├── src/
>>> │   ├── main.js # app entry file
>>> │   ├── App.vue # main app component
>>> │   ├── components/ # ui components
>>> │   │   └── ...
>>> │   └── assets/ # module assets (processed by webpack)
>>> │   └── ...
>>> ├── static/ # pure static assets (directly copied)
>>> ├── test/
>>> ...
>>>
>>> Actually I am doing this work in my NginX Server but I Will be happy if I 
>>> can do the same thing easily using pure web2py
>>>
>>> Why using the same port?  Because the CORS issues, this is the best and 
>>> easy way to deal with CORS. I know I can use sub-domains in the same port, 
>>> I know I can use ALLOW ORIGIN headers in W2P side but that are not options 
>>> for me in this case.
>>>
>>> NginX config working:
>>>
>>> location / {
>>> index index.html index.htm;
>>> root /home/www-data/vue/applications/simott;
>>> try_files $uri $uri/ /index.html;
>>> }
>>>
>>> location /api {
>>> uwsgi_pass  unix:///tmp/web2py.socket;
>>> include uwsgi_params;
>>> uwsgi_param UWSGI_SCHEME $scheme;
>>> uwsgi_param SERVER_SOFTWARE nginx/$nginx_version;
>>>
>>>}
>>>
>>> Any recommendations? Thanks in advance!
>>>
>>> --
> 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.
>



-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
<º))><

-- 
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 2.15.1 is OUT

[Carlos Costa]

I have a problem with this version.

This does not work anymore:

db.define_table('tabela', Field('campo'))
form = SQLFORM.factory(db.tabela.campo)

I throws this:

Traceback (most recent call last):
  File "C:\Users\carlos.costa\Downloads\web2py\gluon\restricted.py", line 219, 
in restricted
exec(ccode, environment)
  File 
"C:/Users/carlos.costa/Downloads/web2py/applications/teste/controllers/default.py"
 , line 
66, in 
  File "C:\Users\carlos.costa\Downloads\web2py\gluon\globals.py", line 409, in 

self._caller = lambda f: f()
  File 
"C:/Users/carlos.costa/Downloads/web2py/applications/teste/controllers/default.py"
 , line 
13, in teste
form = SQLFORM.factory(db.tabela.campo)
  File "C:\Users\carlos.costa\Downloads\web2py\gluon\sqlhtml.py", line 1919, in 
factory
return SQLFORM(DAL(None).define_table(table_name, *fields),
  File 
"C:\Users\carlos.costa\Downloads\web2py\gluon\packages\dal\pydal\base.py", line 
587, in define_table
table = self.lazy_define_table(tablename, *fields, **args)
  File 
"C:\Users\carlos.costa\Downloads\web2py\gluon\packages\dal\pydal\base.py", line 
599, in lazy_define_table
table = table_class(self, tablename, *fields, **args)
  File 
"C:\Users\carlos.costa\Downloads\web2py\gluon\packages\dal\pydal\objects.py", 
line 351, in __init__
field.bind(self)
  File 
"C:\Users\carlos.costa\Downloads\web2py\gluon\packages\dal\pydal\objects.py", 
line 1633, in bind
'Field %s is already bound to a table' % self.longname)
ValueError: Field tabela.campo is already bound to a table



Em segunda-feira, 10 de julho de 2017 18:40:08 UTC-3, Massimo Di Pierro 
escreveu:
>
> It took a year. Thanks to everybody who contributed. There are a ton of 
> bug fixes and speed improvements.
>
> I would encourage everybody who contributed to add a comment in this 
> thread explaining the main features/improvements they have made.
>
> If anything does not work or was broken it is only fault and I will remedy 
> if reported.
>
> Massimo
>

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

[Carlos Costa]

+1 on date picker. It is totally outdated.

Em segunda-feira, 5 de junho de 2017 05:39:11 UTC-3, Karoly Kantor escreveu:
>
> Dear Massimo,
>
> I saw your question in the developers group where I cannot post, therefore 
> i do it here.
>
> I am currently aware of the following issues to be fixed:
>
> 1. Google 2nd generation SQL is definitely a problem. Please note I made a 
> temporary hack to fix it, described here: 
> https://groups.google.com/forum/?fromgroups=#!topic/web2py/vs39zZpaH7g
>
> 2. We have a long overdue issue with the password reset emails not sending 
> on GAE. I am using a temporary dirty workaround that sends a plain text new 
> password, search for the issue about "lazyT object being passed to GAE".
>
> 3. I am having trouble making the date picker work nicely across all 
> browsers, especially where there is a native solution. Microsoft Edge is 
> the worst case. In general, would be good to have a nicer date picker
>
> 4. General comment: We have "batteries included", however, some of those 
> batteries now have newer versions than included, e.g. bootstrap
>
>
>
>
>

-- 
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: The Almighty Form

[Carlos Costa]

Great tip.

I did something similar, but in views.
I wrote a function to take a form and break it into a giver number of
columns using bootstrap grid classes.
The default stacked layout gets pretty boring with time.

2017-04-26 18:18 GMT-03:00 Alfonso Serra :

> This is great i have found a way to have full control on how a form is
> displayed and behave other than writing mystyle(form) in a view.
>
> This is how it would look like:
> def stylefrm(self):
> #create any custom header or form.custom.begin
> frm = FORM(_class="myform")
>
> #iterate over the fields and create any behaviour and style you like
>
> for fld in self.fields:
> field = self.table[fld] #access the SQLFORM to inspect field
> properties
>
> #implement keepvalues
> if self.keepvalues:
> out = LABEL(fld, _for=fld) + INPUT(_name=fld, requires=field.
> requires, _value=self.vars[fld])
> else:
> out = LABEL(fld, _for=fld) + INPUT(_name=fld, requires=field.
> requires)
>
> frm.append(out)
>
> # add the hidden fields + token
> frm.append(self.hidden_fields())
>
> #add any submit button
> frm.append(INPUT(_type="submit", _value="submit"))
>
> return str(frm)
>
> # replace web2py html serialization for your own
> SQLFORM.xml = stylefrm
>
> def index():
> frm = SQLFORM.factory(
> Field("name", "string")
> , Field("quantity", "integer")
> , Field("price", "double")
> )
> # remove SQLFORM factory auto id field
> frm.fields.pop(0)
>
> result = "Not submitted"
>
> if frm.process(keepvalues=True).accepted:
> result = "All good"
> elif frm.errors:
> result = "Not good"
>
> return locals()
>
> View:
> {{=frm}}
> {{=result}}
>
> --
> 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.
>



-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
<º))><

-- 
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] Permission denied: '/var/lib/web2py/applications/admin/private/hosts.deny'

[Carlos Costa]

hosts listed in this file are have access denied.
If this is the problem, just remove the host from the file or remove the
entire file.

Also, all web2py files must belong to the specified user in the apache
virtual user.

2017-03-30 7:02 GMT-03:00 Nicola Gramola :

> Hello.
>
> I've installed web2py with Apache 2.4 and mod_wsgi in a RedHat
> distribution.
> When I try to conect /admin system rease error
> [Errno 13] Permission denied: '/var/lib/web2py/applications/
> admin/private/hosts.deny'
> The hosts file have all permissions
>
> Thanks
>
>
> Virtual Host conf
>
> 
> ...
>   WSGIDaemonProcess web2py user=apache group=apache display-name=%{GROUP}
>
>   WSGIProcessGroup web2py
>
>   WSGIScriptAlias / /var/lib/web2py/wsgihandler.py
>
>   
> AllowOverride None
> Require all granted
> 
>   Require all granted
> 
>   
>
>   AliasMatch ^/([^/]+)/static/(?:_[\d]+.[\d]+.[\d]+/)?(.*)
> /var/lib/web2py/applications/$1/static/$2
>
>   
> Require all granted
>   
> ...
> 
>
> --
> 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.
>



-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
<º))><

-- 
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] Javascript load order and templates

[Carlos Costa]

A proper way to do this is to put the page javascript in the page_js block
It is the declared in the default layout.html.

To use it just do this in your view

{{block page_js}}
 ...put your js here...
{{end page_js}}

This way it will be inserted in the right place into the rendered page.


2017-03-31 11:45 GMT-03:00 David Orme :

> Hello,
>
> I'm using wavesurfer in a site, so have included it at the bottom of
> layout.html.
>
> 
> 
> 
> http://cdnjs.cloudflare.com/ajax/libs/wavesurfer.js/1.
> 0.52/wavesurfer.min.js">
>
> But then one of my views has javascript code to setup a wavesurfer player.
> This is currently included at the bottom of the view - note that it
> includes some web2py expressions to populate variables.
>
> 
> 
>var wavesurfer = WaveSurfer.create({
>  container: '#waveform',
>});
>   wavesurfer.load("{{=URL('static', record.static_filepath)}}");
> 
>
> It doesn't work, but I think for the simple reason that the script in the
> view is included ahead of the scripts loaded in the layout (the contents of
> the view all gets stuck inside {{include}} in the layout, right?). If I put
> copy those layout javascript lines into the view ahead of my local inline
> script, then it works. However, I don't think I want pages loading the same
> javascript twice, so now I have to load those javascript files at the end
> of every view.
>
> Is there a canonical way to handle this? Do blocks allow me to split
> insert the contents of a view into different parts of the layout? Or am I
> better off turning the script into a static JS file that all pages load and
> adding a simple order-agnostic javascript to define the java variables.
>
> Many thanks,
> David
>
> --
> 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.
>



-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
<º))><

-- 
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: web2pyslices

[Carlos Costa]

About fiddle, I think we can easily do the view and controller part.
But what about the other parts like models, modules, database, etc?
Would it be really necessary or have a reliable solution?

I think we could do only view, controller and model.
For the model maybe we should have an interface to build and and fill 
sample (virtual) tables.
But I don´t know how to do it without the need a lot of HD.
Maybe a virtual database driver could be implemented for DAL, for runing 
small tables in memory only or simply use sqlite temporary files.


Em terça-feira, 21 de março de 2017 16:53:16 UTC-3, Massimo Di Pierro 
escreveu:
>
> web2pyslices is becoming hard to maintain. Right now the best solution is 
> to create a github repo and move all the recipes into issues. We will 
> deprecate by closing them. People with gihub accounts can post and comment 
> issues/recipes. Unless you have a better solution, this will be done within 
> the next week.
>
> One sideffect is that we will lose some information about authorship of 
> the recipes and the comments. We will add a notice "created by {...}" but 
> the {...} name will be the web2pyslices username and that may not mean 
> anything in the gihub context.
>
> At this I do not have a better solution but please share your thoughts. 
>
>

-- 
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: web2pyslices

[Carlos Costa]

What about this: http://www.web2pyref.com/
Who owns it?
Could we migrate slices data to it?

Em terça-feira, 21 de março de 2017 16:53:16 UTC-3, Massimo Di Pierro 
escreveu:
>
> web2pyslices is becoming hard to maintain. Right now the best solution is 
> to create a github repo and move all the recipes into issues. We will 
> deprecate by closing them. People with gihub accounts can post and comment 
> issues/recipes. Unless you have a better solution, this will be done within 
> the next week.
>
> One sideffect is that we will lose some information about authorship of 
> the recipes and the comments. We will add a notice "created by {...}" but 
> the {...} name will be the web2pyslices username and that may not mean 
> anything in the gihub context.
>
> At this I do not have a better solution but please share your thoughts. 
>
>

-- 
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: web2pyslices

[Carlos Costa]

+1 for the web2py fiddle idea.
Maybe it could be run on an entirely Python sandbox. There are some libs
available to accomplish this.

2017-03-22 11:29 GMT-03:00 Richard Vézina <ml.richard.vez...@gmail.com>:

> Just an idea, need coding though, maybe we could create a basic app where
> the slice has to be a working example a la fiddle (web2py-fiddle). I know
> it difficult and involve a lot of security, sandboxing, etc, but it would
> be interresting to have demo of slice, that make sure we have the exact
> code to make it works...
>
> Richard
>
> On Wed, Mar 22, 2017 at 7:42 AM, Carlos Costa <yamandu.co...@gmail.com>
> wrote:
>
>> I'd like to help maintain it. And I vote for a web2py solution.
>> Not using would let us in a "shoemaker's son always goes barefoot"
>> situation.
>> I think this is embarrassing.
>>
>> 2017-03-22 1:23 GMT-03:00 Kiran Subbaraman <subbaraman.ki...@gmail.com>:
>>
>>> I agree that the managing web2pyslices as issues may be one way to go.A
>>> couple of options that I have in mind
>>>
>>> *Option 1 / bl.ocks.org <http://bl.ocks.org>*
>>> But there is another idea that I have been considering for sometime...
>>> I follow the d3js community once in a while, and they have this nice way
>>> to contribute and expand on the examples created using d3js. These examples
>>> are hosted on http://bl.ocks.org. If an example is created on Gist, and
>>> follows a prescribed template, then it is hosted as an example on
>>> bl.ocks.org.
>>>
>>> The template and process is defined here: https://bl.ocks.org/-/about
>>>
>>> The work that the bl.ocks.org application does, needs to be replicated
>>> in some form by another application in the web2py world (This has similar
>>> problems - hosting, and computation power, etc)
>>>
>>> *Option 2 / Gists, with PR based list*
>>>
>>>- Post a slice on gist
>>>- Raise a PR, with this link - this is similar to the way one raises
>>>PRs to lists such as this - https://github.com/akullpp/awesome-java
>>>- If someone creates a web2pyslices.github.io on this site, then you
>>>have an autogenerated webpage with the curated list of slices.
>>>
>>>
>>> The reason am plugging for Gist based solutions is that it makes
>>> contribution to that Gist, or improvement in code a possibility (however
>>> remote).
>>>
>>> On Wednesday, March 22, 2017 at 1:23:16 AM UTC+5:30, Massimo Di Pierro
>>> wrote:
>>>>
>>>> web2pyslices is becoming hard to maintain. Right now the best solution
>>>> is to create a github repo and move all the recipes into issues. We will
>>>> deprecate by closing them. People with gihub accounts can post and comment
>>>> issues/recipes. Unless you have a better solution, this will be done within
>>>> the next week.
>>>>
>>>> One sideffect is that we will lose some information about authorship of
>>>> the recipes and the comments. We will add a notice "created by {...}" but
>>>> the {...} name will be the web2pyslices username and that may not mean
>>>> anything in the gihub context.
>>>>
>>>> At this I do not have a better solution but please share your thoughts.
>>>>
>>>> --
>>> 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.
>>>
>>
>>
>>
>> --
>>
>>
>> Carlos J. Costa
>> Cientista da Computação  | BS Computer Science
>> Esp. Gestão em Telecom   | PgC Telecom Mangement
>> <º))><
>>
>> --
>> 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

Re: [web2py] Re: web2pyslices

[Carlos Costa]

I'd like to help maintain it. And I vote for a web2py solution.
Not using would let us in a "shoemaker's son always goes barefoot"
situation.
I think this is embarrassing.

2017-03-22 1:23 GMT-03:00 Kiran Subbaraman :

> I agree that the managing web2pyslices as issues may be one way to go.A
> couple of options that I have in mind
>
> *Option 1 / bl.ocks.org *
> But there is another idea that I have been considering for sometime...
> I follow the d3js community once in a while, and they have this nice way
> to contribute and expand on the examples created using d3js. These examples
> are hosted on http://bl.ocks.org. If an example is created on Gist, and
> follows a prescribed template, then it is hosted as an example on
> bl.ocks.org.
>
> The template and process is defined here: https://bl.ocks.org/-/about
>
> The work that the bl.ocks.org application does, needs to be replicated in
> some form by another application in the web2py world (This has similar
> problems - hosting, and computation power, etc)
>
> *Option 2 / Gists, with PR based list*
>
>- Post a slice on gist
>- Raise a PR, with this link - this is similar to the way one raises
>PRs to lists such as this - https://github.com/akullpp/awesome-java
>- If someone creates a web2pyslices.github.io on this site, then you
>have an autogenerated webpage with the curated list of slices.
>
>
> The reason am plugging for Gist based solutions is that it makes
> contribution to that Gist, or improvement in code a possibility (however
> remote).
>
> On Wednesday, March 22, 2017 at 1:23:16 AM UTC+5:30, Massimo Di Pierro
> wrote:
>>
>> web2pyslices is becoming hard to maintain. Right now the best solution is
>> to create a github repo and move all the recipes into issues. We will
>> deprecate by closing them. People with gihub accounts can post and comment
>> issues/recipes. Unless you have a better solution, this will be done within
>> the next week.
>>
>> One sideffect is that we will lose some information about authorship of
>> the recipes and the comments. We will add a notice "created by {...}" but
>> the {...} name will be the web2pyslices username and that may not mean
>> anything in the gihub context.
>>
>> At this I do not have a better solution but please share your thoughts.
>>
>> --
> 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.
>



-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
<º))><

-- 
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: How do you use web2py app work with phonegap?

[Carlos Costa]

I am using cordova and bootstrap for rapid prototyping.
Next I will change it to static pages interacting via json webservices.

2016-03-21 7:23 GMT-03:00 eric cuver :

> ok thank you i'll check
>
>
> Le dimanche 20 mars 2016 21:24:05 UTC+1, pbreit a écrit :
>>
>> Ionic is free. But it does use Angular.
>>
>> You can't just "use a CSS framework" as mentioned above. You need a
>> framework that can manage data and interactions with server.
>>
>> Maybe look at Onsen or F7?
>>
>>
>> https://www.airpair.com/ionic-framework/posts/hybrid-apps-ionic-famous-f7-onsen
>>
>>
>>
>> On Sunday, March 20, 2016 at 12:14:14 PM UTC-7, eric cuver wrote:
>>>
>>> Ionic it pays I believe? and  I do not like angular
>>>
>>> Le dimanche 20 mars 2016 05:05:09 UTC+1, pbreit a écrit :

 Ionic is a good choice.

 As mentioned, Web2py will run on your server and mostly deliver and
 receive JSON to/from the mobile app.


 On Saturday, March 19, 2016 at 3:12:42 AM UTC-7, eric cuver wrote:
>
> hi Leonel,
>
> which client (boostrap, jquery mobile, ionic.)  for design with
> phonegap advises you ?
>
>
> Le vendredi 18 mars 2016 18:41:22 UTC+1, Leonel Câmara a écrit :
>>
>> I'm sorry but you show fundamental misconceptions about what phonegap
>> does, what web2py does, how they run in the devices and server, and about
>> how they can and should interact.
>>
>> Your questions don't even make sense. I can't help you until you know
>> more about web2py, phonegap, what REST APIs are and how do you access 
>> them
>> using javascript.
>>
> --
> 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.
>



-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
<º))><

-- 
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] qrcode

[Carlos Costa]

http://www.web2pyslices.com/slice/show/1462/qr-code-builder-with-web2py

2015-10-13 18:04 GMT-03:00 Fabiano Almeida :

> Hi all!
>
> How to dynamically generate qr code in web2py?
>
> grateful,
>
> Fabiano.
>
> --
> 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.
>



-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
<º))><

-- 
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: PyCharm license for web2py dev - who wants?

[Carlos Costa]

+1

2015-10-14 19:41 GMT-03:00 Stuart Rolinson :

> +1
>
> Thanks,
> Stuart
>
> On Sunday, October 11, 2015 at 12:21:16 PM UTC-7, Francisco Ribeiro wrote:
>>
>> Hello all,
>>
>> for those who know PyCharm is a great IDE from JetBrains that provides
>> free licenses for Open Source projects like web2py (
>> https://www.jetbrains.com/buy/opensource/?product=pycharm ). To request
>> such a license, I need to know how many of you would want one of these as
>> well so I can provide them with a number of seats.
>>
>> A "+1" response for me is enough but I will also need your email address
>> to send you the license key (which you can send on a private message).
>>
>> Kind regards,
>> Francisco
>>
> --
> 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.
>



-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
<º))><

-- 
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: My son made a new web2py logo

[Carlos Costa]

Interesting story.

2015-06-02 11:43 GMT-03:00 Massimo Di Pierro massimo.dipie...@gmail.com:

 web2py was called gluon. Than I was given 24 hours to change or be sued.
 In retrospect I should have them sue me because of the publicity and
 because I would have won. Anyway, in 24 web2py was the only thing I could
 find that returned no hits from the trademarks database.

 On Monday, 1 June 2015 17:12:39 UTC-5, Carlos Costa wrote:

 A little off now but I waited for a moment to say that.
 IT IS ONLY AN OPINION.

 Maybe the only thing I do not like in Web2py is its name.
 I really love Web2py and use it and advocate it but this name is not a
 strength.

 Many frameworks have better sounding names.

 I would consider rename it in the next BIG version.
 Web3py sounds even worst.

 Its one of the best tools I have used. I think it deserves a better name.
 I know it is a big change...
 I know I should have suggestions, but no, I don't have any for now.
 But give a look at other frameworks and see how they are more
 marketable.

 I made a list of some framework names I found are some way better:
 BlueBream, CherryPy, CubicWeb, Django, Flask, Grok, Nagare, Pyjamas,
 Pylons, Pyramid, TACTIC, Tornado, TurboGears, Webware, Zope 2, Camping,
 Padrino, Ruby on Rails, Sinatra, Merb, PureMVC, AIDA/Web, Application
 Express, Compojure, Flex, Grails, Kepler, Morfik, Ocsigen, Opa, OpenACS,
 Seaside, Zotonic, ColdBox Platform, Fusebox, Mach-II, Model-Glue, Apache
 Click, Apache OFBiz, Apache Sling, Apache Struts, Apache Tapestry, Apache
 Wicket, FormEngine, Grails, ItsNat, JavaServer Faces, JBoss Seam, OpenXava,
 Play, RIFE, Spring, Stripes, Vaadin, Wavemaker, WebObjects, ztemplates,
 Catalyst, Dancer, Mason, Maypole, Mojolicious, CakePHP, CodeIgniter,
 Drupal, Fat-Free Framework, FuelPHP, Fusebox, Joomla, Lithium, Nette
 Framework, PRADO, SilverStripe, Solodev CMS, Symfony, Zend Framework,
 Zikula, Pyjamas, Pylons, Pyramid, TACTIC, Tornado, TurboGears, Webware,
 BlueBream, Zope, Application Express, Flex, Kepler, Lift, Ocsigen, Opa,
 OpenACS, Seaside,

 For %py% ones, the most I like is CherryPy :)

 2015-06-01 17:11 GMT-03:00 Richard Vézina ml.richard.vez...@gmail.com:

 Yes that my point not WII but WII...

 Anyway, it nice!

 :)

 Richard

 On Mon, Jun 1, 2015 at 4:07 PM, Massimo Di Pierro 
 massimo.dipie...@gmail.com wrote:

 Anyway, I am not suggesting a new logo. I am thinking if anybody wants
 to submit a new more polished examples app that preserves the content, I am
 all for it.


 On Monday, 1 June 2015 14:57:03 UTC-5, Robert Porter wrote:

 You could almost combine the / / of the W with the II and the pi
 symbol into one character.

 On Monday, 1 June 2015 11:06:16 UTC-7, Massimo Di Pierro wrote:

 Time to revamp the web site?

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




 --


 Carlos J. Costa
 Cientista da Computação  | BS Computer Science
 Esp. Gestão em Telecom   | PgC Telecom Mangement
 º))

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




-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
º))

-- 
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: My son made a new web2py logo

[Carlos Costa]

A little off now but I waited for a moment to say that.
IT IS ONLY AN OPINION.

Maybe the only thing I do not like in Web2py is its name.
I really love Web2py and use it and advocate it but this name is not a
strength.

Many frameworks have better sounding names.

I would consider rename it in the next BIG version.
Web3py sounds even worst.

Its one of the best tools I have used. I think it deserves a better name.
I know it is a big change...
I know I should have suggestions, but no, I don't have any for now.
But give a look at other frameworks and see how they are more marketable.

I made a list of some framework names I found are some way better:
BlueBream, CherryPy, CubicWeb, Django, Flask, Grok, Nagare, Pyjamas,
Pylons, Pyramid, TACTIC, Tornado, TurboGears, Webware, Zope 2, Camping,
Padrino, Ruby on Rails, Sinatra, Merb, PureMVC, AIDA/Web, Application
Express, Compojure, Flex, Grails, Kepler, Morfik, Ocsigen, Opa, OpenACS,
Seaside, Zotonic, ColdBox Platform, Fusebox, Mach-II, Model-Glue, Apache
Click, Apache OFBiz, Apache Sling, Apache Struts, Apache Tapestry, Apache
Wicket, FormEngine, Grails, ItsNat, JavaServer Faces, JBoss Seam, OpenXava,
Play, RIFE, Spring, Stripes, Vaadin, Wavemaker, WebObjects, ztemplates,
Catalyst, Dancer, Mason, Maypole, Mojolicious, CakePHP, CodeIgniter,
Drupal, Fat-Free Framework, FuelPHP, Fusebox, Joomla, Lithium, Nette
Framework, PRADO, SilverStripe, Solodev CMS, Symfony, Zend Framework,
Zikula, Pyjamas, Pylons, Pyramid, TACTIC, Tornado, TurboGears, Webware,
BlueBream, Zope, Application Express, Flex, Kepler, Lift, Ocsigen, Opa,
OpenACS, Seaside,

For %py% ones, the most I like is CherryPy :)

2015-06-01 17:11 GMT-03:00 Richard Vézina ml.richard.vez...@gmail.com:

 Yes that my point not WII but WII...

 Anyway, it nice!

 :)

 Richard

 On Mon, Jun 1, 2015 at 4:07 PM, Massimo Di Pierro 
 massimo.dipie...@gmail.com wrote:

 Anyway, I am not suggesting a new logo. I am thinking if anybody wants to
 submit a new more polished examples app that preserves the content, I am
 all for it.


 On Monday, 1 June 2015 14:57:03 UTC-5, Robert Porter wrote:

 You could almost combine the / / of the W with the II and the pi
 symbol into one character.

 On Monday, 1 June 2015 11:06:16 UTC-7, Massimo Di Pierro wrote:

 Time to revamp the web site?

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




-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
º))

-- 
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 to read latin encoded characters correctly from MSSQL?

[Carlos Costa]

Whe I use pyodbc only, I can read and convert characters correctly.
But always replace accentuated characters with '?'.

I already tried the db_codec='cp1252' and db_codec='latin1' attribute in 
DAL.
In fact, MSSQL uses its own collation: sql_latin1_general_cp1_ci_as as 
collation.
But both latin1 and cp1252 work fine with pyodbc only by simply 
doing row[0].decode('cp1252') for example.

I also tried to use filter_out and SQLCustomType but they receive tha value 
already decoded wrong.

Any other thing may I be missing beyond hack DAL?

-- 
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] websocket messaging VS scheduler

[Carlos Costa]

I would like to use scheduler with a task sends websocket messages but it 
looks like they conflict with each other.
I am able to run only one of them.

If I start scheduler first, websocket freezes web2py.
If I start websocket first scheduler do not run any worker.

I start we2py with web2py.py -K app -a password -X -D15

In some action I do this to start the websocket

import subprocess
subprocess.call(python gluon/contrib/websocket_messaging.py -k mykey -p 
.split(' '))

but this freezes everything.

If I start websocket from shell manually both things work but I would like 
my app  to guarantee that things are running.

Some idea why this is not possible?

Running 2.9.12 with python 2.7 on Ubuntu 14.10

-- 
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: WEB2PY Certificate ?

[Carlos Costa]

And what is the future of experts4solutions ?

2015-03-25 0:19 GMT-03:00 Massimo Di Pierro massimo.dipie...@gmail.com:

 Looks like you did. :-O

 Anyway, the point of a university is that we do not usually teach courses
 about specific technologies. We use specific technologies to serve more
 abstract purposes. For example I teach CSC438 which is about the internal
 design of web frameworks and I use web2py as one of the (main) examples.

 We use Python in many classes but the goal is not teach python. The goal
 is to teach programming (for, if, def, return).

 Anyway, it would be nice to have more material about teaching web2py
 and/or teaching with web2py. Perhaps we could crowdsource the effort. If I
 have a list of 10 topics that people would want me to cover in detail I can
 make some short videos. I am sure other people here would be willing to
 help.

 Massimo



 On Tuesday, 24 March 2015 12:39:02 UTC-5, Ron Chatterjee wrote:

 We should clone you saying!? lol. jk:-). Would be nice to have an advance
 course like that. Someone should write to the dean and sign me up.



 On Tuesday, March 24, 2015 at 12:19:23 PM UTC-4, Massimo Di Pierro wrote:

 No. Perhaps there should be. But not yet.

 On Tuesday, 24 March 2015 08:40:40 UTC-5, Ron Chatterjee wrote:

 Massimo,

 On that note. I have seen some of that lecture and it seems very
 undergrad level. Is there a grad level course that you can offer where we
 can go through each API (or the most important one). Lets create few stand
 alone code and go line by line to understand how the framework is made? Get
 into more depth and complexity. Lets say someone is already a web2py
 developer but he wants to push the envelop and become an expert or even
 better (since no one can't clone you. lol). Is there a course like that?

 Ron


 On Tuesday, March 24, 2015 at 3:34:26 AM UTC-4, Massimo Di Pierro wrote:

 Yes.
 http://www.cdm.depaul.edu/ipd/Programs/Pages/
 WebDevelopmentwithPython.aspx

 I teach it and it is basically a course on web2py. Problem is, I am
 too busy to teach it and I have not been teaching it in one year.

 Anyway, past lectures are all online. I am considering automating the
 certification process. I have a large database of questions/problems.

 Massimo

 On Monday, 23 March 2015 21:53:16 UTC-5, KPlusPlus wrote:

 Hello

 I was wondering if there's an organization/institution can offer a
 WEB2PY Certificate with or without Course ?

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




-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
º))

-- 
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: Install in hostgator

[Carlos Costa]

Have you seen this?
http://www.web2pyslices.com/slice/show/1567/running-web2py-on-hostgator-shared-host

2015-03-22 23:24 GMT-03:00 LoveWeb2py atayloru...@gmail.com:

 Did anyone ever find a complete solution to this? I'm using web2py on
 hostgator and after following this tutorial I can only get my app to work
 if I name it init. Also, if I try to access another controller for example:
 www.mysite.com/controller/ I get a 404 error. Does this have something to
 do with my htaccess or routes? They are setup exactly how this thread
 recommends

 On Thursday, April 10, 2014 at 1:28:14 PM UTC-4, RTBS wrote:

 Hey Criss,

 Great testimonial and I would love to use hostgator.  However, I would
 also like to use web2py.  Currently, a complete tutorial does not exist to
 make these two work together.  It seems some people have been able to get
 this to work, unfortunately, I am not one of them.

 The django tutorial on the hostgator web page works great and only took
 about 10 min. to get working.  https://support.hostgator.
 com/articles/django-with-fastcgi

 I am looking for something similar for web2py.  I really hate to tie up
 their support team on an issue that they shouldn't be supporting.  I'm
 surprised that no one has written a white-paper how-to on this one.  Maybe
 I'm missing something so simple that no one has bothered to mention it.

 Thanks again, you have solidified my resolve to make this work (or at
 least ask their support team again).


 On Wednesday, April 9, 2014 10:43:10 AM UTC-7, criss shirley wrote:

 Hey Everyone

 I saw many of peoples asking about the best web hosting with best
 resultat so

  i'm here to giving and sharing you my experience :

 I have been with Hostgator for over 4 years now having moved from many
 different hosts before finding the right one, Hostgator. I have never had
 such a fantastic service from any company anywhere! Hostgator are simply
 the best you will find, the customer service is amazing, 24/7 and they help
 with all kinds of advice, even when it isnt server related. They have techs
 working for them that actually care for the customers and this has been
 proven time and time again when I had issues with scripts, even though it
 wasnt up to Hostgator to fix these issues, they gave me great advice to get
 the scripts working. I have a dedicated pro server, fully managed and a
 level 4 VPS, both are perfect for my entire business and I have a lot of
 sites!

 Anyway, Hostgator are simply the best hosting company out there and that
 is the reason why they are so popular, if you are searching for a hosting
 company, you dont need to, just go to Hostgator!

 If you are looking to host your website, my strongest advise is to go
 with Hostgator and you will never regret doing so...

 With hostgator 1 cent coupon, you can get hostgator hosting in just 1
 cent for first month.

  You can use following coupons to get discount:

 $0.01 First Month, Coupon Code - markdownhost

 To sign up in hostgator here : http://goo.gl/3cVZNd


 Le samedi 14 mai 2011 05:21:13 UTC+1, José Eloy a écrit :

 Hello!

 Recently a customer bought a hosting plan (business) with hostgator.
 I'm developing for him a web2py application, I have doubts of how to
 deploy it. Somebody can help me? The application runs well in
 localhost (ubuntu).

 Thanks in advance

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




-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
º))

-- 
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] several vars in page

[Carlos Costa]

Question 1:
The parenthesis are wrong. The _href attribute is inside I and not A
helper. In fact, a parenthesis was missing too.
{{if page:}}
{{request.vars.page = [page - 1] }}
{{=SPAN(A(I(T('Previous')), _href = URL(vars = request.vars ) ) ) }}
{{elif len(rows)  items_per_page:}}
{{request.vars.page = [page + 1] }}
{{=SPAN(A(T('Next'), _href = URL(vars = request.vars ) ) ) }}
{{pass}}

Question 2:
If you are getting the following error: non-keyword arg after keyword arg
That is because you must always write first the unnamed arguments and and
the named arguments after.

2015-03-19 20:18 GMT-03:00 黄祥 steve.van.chris...@gmail.com:

 hi,

 i have several vars that store : view (grid or list), sort (a_z, z_a,
 highest_price, lowest_price, newest), search_product, category_product
 (drop down list IS_IN_DB() ) and product_brand (drop down list IS_IN_DB() )

 search_product, category_product (drop down list IS_IN_DB() ) and
 product_brand (drop down list IS_IN_DB() ) is on the other file (sidebar)

 *question 1 :*
 *works well*
 {{if page:}}
 {{=SPAN(A(T('Previous'),
   _href = URL(*vars = dict(request.vars, page = [page - 1]*) ) ) ) }}
 {{elif len(rows)  items_per_page:}}
 {{=SPAN(A(T('Next'),
   _href = URL(*vars = dict(request.vars, page = [page + 1]*) ) ) ) }}
 {{pass}}

 *no errors occured but the result is not expected*
 {{if page:}}
 * {{request.vars.page = [page - 1] }}*
 {{=SPAN(A(I(T('Previous'),
   _href = URL(*vars = request.vars* ) ) ) }}
 {{elif len(rows)  items_per_page:}}
 * {{request.vars.page = [page + 1] }}*
 {{=SPAN(A(T('Next'),
   _href = URL(*vars = request.vars* ) ) ) }}
 {{pass}}

 why the result is not expected, when i have multiple vars in 1 page (the
 page vars value is not store in vars)?

 *question 2 :*
 *works well*
 {{if page:}}
 {{=SPAN(A(T('Previous'),
   _href = URL(vars = dict(*request.vars, page = [page - 1]*) ) ) ) }}
 {{elif len(rows)  items_per_page:}}
 {{=SPAN(A(T('Next'),
   _href = URL(vars = dict(*request.vars, page = [page + 1]*) ) ) ) }}
 {{pass}}

 *an error occured*
 {{if page:}}
 {{=SPAN(A(T('Previous'),
   _href = URL(vars = dict(*page = [page - 1], request.vars*) ) ) ) }}
 {{elif len(rows)  items_per_page:}}
 {{=SPAN(A(T('Next'),
   _href = URL(vars = dict(*page = [page + 1], request.vars*) ) ) ) }}
 {{pass}}

 my 2nd question is why if i assign the var page first it return an error?

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




-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
º))

-- 
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: Search in web2py book case sensitive

[Carlos Costa]

+1

2015-03-19 14:07 GMT-03:00 Massimo Di Pierro massimo.dipie...@gmail.com:

 done. Thanks.

 On Thursday, 19 March 2015 05:26:22 UTC-5, Kiran Subbaraman wrote:

 Yes, it is.
 This line of code probably needs to be changed:
 https://github.com/mdipierro/web2py-book/blob/master/
 controllers/default.py#L152 to
 k = data.lower().find(search.lower())




 On Thursday, March 19, 2015 at 2:35:59 PM UTC+5:30, Kenneth wrote:

 Hello,

 is the search function in web2py Book supposed to be case sensitive?

 I went to the online book and typed sqlform in the search field.

 Was a little bit surprised when I got: No results for sqlform
 Searching for SQLFORM works.


 Kenneth

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




-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
º))

-- 
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: Function being called twice from one button click

[Carlos Costa]

Use the browser console to investigate.
Look at the Network tab if it performs two actions with that URL.
Another thing that may sound stupid but it is not uncommon and I have
already seen it.
Some people double click buttons, icons in the web too.
I saw a case that a delay between clicks was need.
Another thing to look is the page delay. If it delays too much the person
may click again.

2015-02-26 9:46 GMT-03:00 Leonel Câmara leonelcam...@gmail.com:

 I don't see how it can happen. Your costumer probably has a virus or
 something. It may also be a buggy browser extension (tell him to try with
 the browser in private mode so the extensions are off).

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




-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
º))

-- 
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] Translate Controller names and Function names

[Carlos Costa]

Very interesting question. It must have some effect on SEO.
I have seen this post but it does not seem to solve exactly this
https://groups.google.com/forum/#!searchin/web2py/translate$20url/web2py/3adXUSCGQQQ/TaKfRagHyvMJ

Although if you have a different URL for different content it will be
indexed.
If the two apps are working in two different domains they will be indexed
accordingly.

I tried to do what you want by interception the request object but it doe
not work.

One way is to use routes.py and write one rule per URL.

2015-01-27 10:12 GMT-02:00 Francisco Costa m...@franciscocosta.com:

 I'm using the Parameter-based rewrite system
 http://web2py.com/books/default/chapter/29/04/the-core#Parameter-based-system
 and I would like to find a strategy to **translate controller names and
 function names**.

 I have 2 domains and I use only one app for both, but I would like to have
 the controllers and functions translated for the non-english one.

 Something like this:

  - http://domain.com/article/new (english - default language)
  - http://domain.pt/artigo/novo(portuguese - translation)

 What would be the best way to achieve this?

 PS: I also would like to have some redirection if someone typed the wrong
 domain extension:
 http://domain.pt/article/new - http://domain.pt/artigo/novo


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




-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
º))

-- 
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: We could have something like this

[Carlos Costa]

It does not the same thing but it does.

It was intend to keep recipes, but one can post links to anything too.
Thinking this way it is even better than meteorhelp.

But the main difference I see is the dated layout, design and UX.
It is a nice tool but already needs a refresh.

2014-10-21 11:23 GMT-02:00 António Ramos ramstei...@gmail.com:

 differs in the fact that its not only for recipes

 i can see where to find videos, faqs, books etc as listed in the left

 Also reviews from users are nice.
 Maybe web2py slices does the same thing but its not clear for occasionaly
 users/readers

 regards



 2014-10-20 23:39 GMT+01:00 Dave S snidely@gmail.com:



 On Monday, October 20, 2014 2:41:26 PM UTC-7, Ramos wrote:

 it was not a question.
 we know everything is possible.

 Its just that finding info about web2py are sometimes dificult

 A site like this could help and also rate the source of info.


 In what way do you see it as being different web2pyslices?

 /dps




 Regards

 2014-10-20 22:37 GMT+01:00 Derek sp1...@gmail.com:

 Is that a question? Are you asking if you can build a site like that? I
 don't see why not. In fact, instantpress almost meets your needs, though
 you might want to customize the theme a bit.

 On Monday, October 20, 2014 3:12:29 AM UTC-7, Ramos wrote:

 http://meteorhelp.com/

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


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




-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
º))

-- 
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: We could have something like this

[Carlos Costa]

We have Web2py Slices.

http://www.web2pyslices.com

2014-10-20 19:41 GMT-02:00 António Ramos ramstei...@gmail.com:

 it was not a question.
 we know everything is possible.

 Its just that finding info about web2py are sometimes dificult

 A site like this could help and also rate the source of info.

 Regards

 2014-10-20 22:37 GMT+01:00 Derek sp1d...@gmail.com:

 Is that a question? Are you asking if you can build a site like that? I
 don't see why not. In fact, instantpress almost meets your needs, though
 you might want to customize the theme a bit.

 On Monday, October 20, 2014 3:12:29 AM UTC-7, Ramos wrote:

 http://meteorhelp.com/

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




-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
º))

-- 
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] Accesing table from external database

[Carlos Costa]

I don't get it.
You can make DAL connection to SQL Server, what is the problem you can not?

2014-09-17 16:39 GMT-03:00 José Eloy pepe.e...@gmail.com:

 Hello!

 I need to populate a combobox in a FORM (or SQL FORM) with the content of
 a field of a table which is in an external SQL Server database. I know that
 is not possible to reference an external database using DAL, but how can I
 to load the content of the external field in a SQLFORM field (combobox)?

 Any idea?

 Regards.

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




-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
º))

-- 
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 2.9.7 is OUT

[Carlos Costa]

Cool!


2014-09-05 2:47 GMT-03:00 Massimo Di Pierro massimo.dipie...@gmail.com:

 same as 2.9.6 except:

 - a few more bug fixes
 - sessions are stores in sessions/XX/YY/ subfolder to avoid proliferation
 of files under the same folder which causes slowdown
 - cache.disk has been rewritten by Leonel and it much better.

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




-- 


Carlos J. Costa
Cientista da Computação  | BS Computer Science
Esp. Gestão em Telecom   | PgC Telecom Mangement
º))

-- 
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] The Zen of web2py

[Carlos Costa]

I like it.

I wonder if we could do it in an organized in some way.

Recently I lost to convince my boss to change everything to web2py because
there are few developers that know it.
So it would be very good to have a massive community. As we will have more
opportunities to work on the framework we love best.

Groups like this have little exposure outside. We need something else!


2014-07-09 10:03 GMT-03:00 Philip Kilner p...@xfr.co.uk:

 Hi,

 On 09/07/14 13:31, horridohobbyist wrote:

 Let's improve web2py's PR. A blast of articles over the next year could
 change the fortunes of our favourite web framework.


 Good piece, great finish.

 I'll take that as a challenge, and see if I can describe my own journey
 from desktop databases to web2py via Zope and Plone as succinctly!

 :-)


 --

 Regards,

 PhilK


 e: p...@xfr.co.uk - m: 07775 796 747

 'work as if you lived in the early days of a better nation'
 - alasdair gray


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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom
º))

-- 
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] The Zen of web2py

[Carlos Costa]

I agree with you Massimo, the best ones are those that built something.
Videos like this http://vimeo.com/6782736 helped me to decide to stay with
web2py.
Not only that title is quite marketish but content is so true.


2014-07-09 12:28 GMT-03:00 Massimo Di Pierro massimo.dipie...@gmail.com:

 I think this would help a lot web2py.

 I can share some personal experience. In my experience the best articles
 are those that show how to build something and focus on one feature at the
 time. People are very religious about certain frameworks and for the
 message to get across one really has to convince them that web2py will save
 them time and pain. One cannot convince everybody, but one can choose a
 target audience.

 I like comparison: this is how you do X in Django (for example) - this is
 how you do in web2py. The reason I like them is that they talk to a clear
 audience and users of both frameworks have something to learn from each
 other. Mind some people are very touchy and they do not like to be told
 that another kid has a shiner tool.

 Massimo



 On Wednesday, 9 July 2014 08:12:55 UTC-5, yamandu wrote:

 I like it.

 I wonder if we could do it in an organized in some way.

 Recently I lost to convince my boss to change everything to web2py
 because there are few developers that know it.
 So it would be very good to have a massive community. As we will have
 more opportunities to work on the framework we love best.

 Groups like this have little exposure outside. We need something else!


 2014-07-09 10:03 GMT-03:00 Philip Kilner p...@xfr.co.uk:

 Hi,

 On 09/07/14 13:31, horridohobbyist wrote:

 Let's improve web2py's PR. A blast of articles over the next year could
 change the fortunes of our favourite web framework.


 Good piece, great finish.

 I'll take that as a challenge, and see if I can describe my own journey
 from desktop databases to web2py via Zope and Plone as succinctly!

 :-)


 --

 Regards,

 PhilK


 e: p...@xfr.co.uk - m: 07775 796 747

 'work as if you lived in the early days of a better nation'
 - alasdair gray


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




 --
 Att.

 Carlos J. Costa
 Cientista da Computação
 Esp. Gestão em Telecom
 º))

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom
º))

-- 
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 Rocks ... Again :)

[Carlos Costa]

+1


2014-07-03 8:38 GMT-03:00 lyn2py lyn...@gmail.com:

 Finally, have ironed out all the kinks and sorted out all the errors. Most
 of them come about because of user-problems (yes, me), because I don't
 deploy to production often enough to keep up with the versions of all other
 supporting platforms/software. In addition, my memory sometimes fail me and
 I run into errors, make mistakes unknowingly and carelessly (Don't work too
 late! Stop when you are tired!).

 If you are planning to deploy to production servers, I just want to
 reassure you that what works on localhost will work on production servers.
 Web2py is very reliable! It was a journey of twist and turns, but
 fortunately I only needed to start over once and it was all ok after that.

 And the familiar feeling sets in again... the more I code with Web2py, the
 more I want to praise it! Web2py ROCKS! Thank you to Massimo and all
 developers for putting in your time, effort and expertise to make Web2py
 such a wonderful framework and contribute to this sharing community.

 THANK YOU.

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom
º))

-- 
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 do I view text on view.html

[Carlos Costa]

You should create and action for that view and pass it in dictionary to the
view


2014-06-16 7:08 GMT-03:00 Maurice Waka mauricew...@gmail.com:

  My code:




 class Person():
  name = 'Victor'
  def say(self, what):
  print(self.name, what)


 getattr(person, attr_name)

 How do I display 'Victor' on web2py html.view?

 I tried using:

 {{=getattr(person, attr_name)}}


  I know this could be wrong and I cant get a result either

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom
º))

-- 
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] Trying to use the LOAD helper, if a button is clicked

[Carlos Costa]

It may work if this button is inside the component loaded.


2014-06-13 20:47 GMT-03:00 Omri Levy my.mail...@gmail.com:

 Hi ,

 So I have a ticket system, and I want to allow user to edit the ticket
 without leaving the page.
 I don't want to LOAD the edit_page and hide it, but only load it once user
 is clicking on the ticket body.
 Another thing is, when user edits the ticket, he should again see changes
 on the same page.

 Is this possible? I'm a bit confused, because LOAD works fine, but not
 when using conditions with JS.

 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.




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom
º))

-- 
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: How do I view text on view.html

[Carlos Costa]

I guess you need to familiarize yourself more with not just with web2py but
also with web development, right?

Anthony is right, you should read web2py book at www.web2py.com/book, at
least the first chapters to get a start.
At first you need to understand MVC.

For example you may have:

in db.py (Model)

class Person():
 name = 'Victor'

in default.py (Controler)


def index():

person = Person()

return dict(person=person)


in default/index.html (View)


{{=person.name}}




2014-06-16 10:24 GMT-03:00 Anthony abasta...@gmail.com:

 This doesn't look anything like typical web2py code. I would recommend
 that you read some of the book and follow the typical patterns and then
 come back with questions if you're having trouble. In general, though, note
 that you won't be using the print statement to display anything in HTML
 pages -- print is for printing to the console.

 Anthony


 On Monday, June 16, 2014 6:08:55 AM UTC-4, Maurice Waka wrote:

  My code:




 class Person():
  name = 'Victor'
  def say(self, what):
  print(self.name, what)


 getattr(person, attr_name)

 How do I display 'Victor' on web2py html.view?

 I tried using:

 {{=getattr(person, attr_name)}}


  I know this could be wrong and I cant get a result either

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom
º))

-- 
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: web2py CMS

[Carlos Costa]

I found Plone very hard to do almost anything.
For simple sites I would not recomend although it is really the best in the
Python world.


2014-06-04 6:02 GMT-03:00 Philip Kilner phil.kil...@gmail.com:

 Hi,

 +1 for Plone from me, too.

 If you only need something lightweight, it may be OTT - but if you need
 a mature product that you will not outgrow then Plone is well worth a look.

 It's not hard to knit web2py and Plone together - depends what you want
 to achieve obviously, but where I've needed both Plone's CMS strengths
 and web2py's RDBMS strengths in a single project, I've found it easier
 to embed a web2py application in a Plone page than /vice versa/.


 --

 Regards,

 PhilK


 'a bell is a cup...until it is struck'

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom
º))

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

[Carlos Costa]

We have some options as I know.

Kpax from Massimo
http://vimeo.com/1098656
https://github.com/mdipierro/web2py-appliances/tree/master/KPax2


Quoca and Movuca (more lika a social app) from Bruno Rocha
http://quokkaproject.org/
https://github.com/rochacbruno/Movuca

https://code.google.com/p/instant-press/


2014-05-30 17:52 GMT-03:00 Fabiano Almeida fabi...@techno7.com.br:

 Hi Andrey,

 Do you need a blog?


 2014-05-30 11:21 GMT-03:00 Andrey K kmelevs...@gmail.com:

 I am interested to add in CMS system for our web2py application.
  Quick search does not give me any solutions. Is there any CMS plugin
 already or any recipes on it?
 Any thoughts, suggestions, links and comments would be very appreciated.
 Thank you in advance!

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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: requires IS_IN_DB set as a union of two queries

[Carlos Costa]

Sorry, I should have written:

db.owner.own_veh_fk.requires=IS_IN_DB(db(query),'vehicle.id',
'%(manufacturer)s %(vin)s')

If you need to pass a set so you need to call db(query) in order to execute
the query.



2014-05-28 21:46 GMT-03:00 98uj...@gmail.com:

 I did try:
 query =  query1 | guery2
 and received error: Set | Set or similar


 On Wednesday, May 28, 2014 7:47:36 PM UTC-4, 98u...@gmail.com wrote:

 Thank you Mr. Massimo and your colleagues for bringing the web2py to the
 masses.
 I need to have a field that will present a choice of values that result
 from a union of query1 and query2
 How can i create a set that would go where the question mark is? Thanks
 for any help!

 query1=((db.vehicle.id==db.owner.own_veh_fk)(db.owner.
 own_end_date!=None))

 query2=(~db.vehicle.id.belongs(db(db.owner.own_veh_fk==db.vehicle.id
 )._select(db.vehicle.id)))

 db.owner.own_veh_fk.requires=IS_IN_DB((db(?)),'vehicle.id',
 '%(manufacturer)s %(vin)s')

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] DAL Referencing By Name Not By ID Possible?

[Carlos Costa]

Give a look here:
http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Legacy-databases-and-keyed-tables

But I think it won't work in your case because name is a string.
Our you can model it another way.

db.define_table('tiers',
Field('name', 'string'),
Field('created_on', 'datetime', default=request.now),
format = '%(name)s')

db.define_table('metrics',
Field('tier_name', 'string', requires=IS_IN_DB(db, 'tiers.name
',%(name)s')),
Field('total_count', 'integer'),
Field('total_size', 'bigint'),
Field('created_on', 'datetime', default=request.now))

However, this will not enforce reference at db level, only in application.
But you can query an join it by name without problems.

query = db(db.tiers.name == db.metrics.tier_name).select()
metric = db(db.metrics.tier_name == 'name').select()

or you can obviously write a helper function to short it

get_metrics = lambda name: db(db.metrics.tier_name == name).select()
get_tier = lambda name: db(db.tier.name == name).select().first()

tier = get_tier(name)
tier_metrics = get_metrics(name)


2014-05-27 21:35 GMT-03:00 'Michael Gheith' via web2py-users 
web2py@googlegroups.com:

 I have two pretty basic tables:

 db.define_table('tiers',
 Field('name', 'string'),
 Field('created_on', 'datetime', default=request.now),
 format = '%(name)s')

 db.define_table('metrics',
 Field('tier_id', 'reference tiers'),
 Field('total_count', 'integer'),
 Field('total_size', 'bigint'),
 Field('created_on', 'datetime', default=request.now))

 I pre populated my tiers table with data.  When I store data in my metrics
 table, I don't know off hand the tier_id.  I know the tier name though.  Is
 there a way I can use the tier name instead of the tier_id in this
 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.




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] DAL Referencing By Name Not By ID Possible?

[Carlos Costa]

You are welcome! :)


2014-05-28 11:08 GMT-03:00 'Michael Gheith' via web2py-users 
web2py@googlegroups.com:

 Many thanks for this, I found it to be helpful :)


 On Wednesday, May 28, 2014 6:30:31 AM UTC-5, yamandu wrote:

 Give a look here: http://web2py.com/books/default/chapter/29/06/the-
 database-abstraction-layer#Legacy-databases-and-keyed-tables

 But I think it won't work in your case because name is a string.
 Our you can model it another way.

 db.define_table('tiers',
 Field('name', 'string'),
 Field('created_on', 'datetime', default=request.now),
 format = '%(name)s')

 db.define_table('metrics',
 Field('tier_name', 'string', requires=IS_IN_DB(db, 'tiers.name
 ',%(name)s')),
 Field('total_count', 'integer'),
 Field('total_size', 'bigint'),
 Field('created_on', 'datetime', default=request.now))

 However, this will not enforce reference at db level, only in application.
 But you can query an join it by name without problems.

 query = db(db.tiers.name == db.metrics.tier_name).select()
 metric = db(db.metrics.tier_name == 'name').select()

 or you can obviously write a helper function to short it

 get_metrics = lambda name: db(db.metrics.tier_name == name).select()
 get_tier = lambda name: db(db.tier.name == name).select().first()

 tier = get_tier(name)
 tier_metrics = get_metrics(name)


 2014-05-27 21:35 GMT-03:00 'Michael Gheith' via web2py-users 
 web...@googlegroups.com:

 I have two pretty basic tables:

 db.define_table('tiers',
 Field('name', 'string'),
 Field('created_on', 'datetime', default=request.now),
 format = '%(name)s')

 db.define_table('metrics',
 Field('tier_id', 'reference tiers'),
 Field('total_count', 'integer'),
 Field('total_size', 'bigint'),
 Field('created_on', 'datetime', default=request.now))

 I pre populated my tiers table with data.  When I store data in my
 metrics table, I don't know off hand the tier_id.  I know the tier name
 though.  Is there a way I can use the tier name instead of the tier_id in
 this 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+un...@googlegroups.com.

 For more options, visit https://groups.google.com/d/optout.




 --
 Att.

 Carlos J. Costa
 Cientista da Computação
 Esp. Gestão em Telecom

 EL MELECH NEEMAN!
 אָמֵן

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] requires IS_IN_DB set as a union of two queries

[Carlos Costa]

Have you tried something like:

query1=((db.vehicle.id==db.owner.own_veh_fk)(db.owner.own_end_date!=None))

query2=(~db.vehicle.id.belongs(db(db.owner.own_veh_fk==db.vehicle.id
)._select(db.vehicle.id)))

query = query1  query2

db.owner.own_veh_fk.requires=IS_IN_DB(query,'vehicle.id', '%(manufacturer)s
%(vin)s')





2014-05-28 20:47 GMT-03:00 98uj...@gmail.com:

 Thank you Mr. Massimo and your colleagues for bringing the web2py to the
 masses.
 I need to have a field that will present a choice of values that result
 from a union of query1 and query2
 How can i create a set that would go where the question mark is? Thanks
 for any help!

 query1=((db.vehicle.id
 ==db.owner.own_veh_fk)(db.owner.own_end_date!=None))

 query2=(~db.vehicle.id.belongs(db(db.owner.own_veh_fk==db.vehicle.id
 )._select(db.vehicle.id)))

 db.owner.own_veh_fk.requires=IS_IN_DB((db(?)),'vehicle.id',
 '%(manufacturer)s %(vin)s')

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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 select a column of numbers into a list so that I can manipulate the list

[Carlos Costa]

Try:

 nums3 = db(db.Measures).select( db.Measures.measure_value,
orderby=db.Measures.measure_date_time).as_list()


2014-05-26 7:20 GMT-03:00 Syd Stewart sydney.w.stew...@gmail.com:

 Hi

 What is the simplest way please to select a column of figures (floats and
 int) into a list, so I can manipulate the list e.g randomise the order

  nums3 = db(db.Measures).select( db.Measures.measure_value,
 orderby=db.Measures.measure_date_time)

  meannums= sum(nums3)/float(len(nums3))

 This calculation of the mean keeps giving me an error

   File /home/sydstewart/web2py/applications/SydOwn/controllers/test.py 
 https://sydstewart.pythonanywhere.com/admin/default/edit/SydOwn/controllers/test.py,
  line 92, in cusum
 qnum[i][k] = (nums3[k]) - (meannums)
 TypeError: unsupported operand type(s) for -: 'Row' and 'int'


 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.




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] Can't login to Admin interface

[Carlos Costa]

How did you started web2py?


2014-05-21 2:36 GMT-03:00 shubham agarwal shubhamagarwal...@gmail.com:

 I'am trying to login to the web2py admin interface but my password is not
 been accepted. I'm pretty sure that the password is correct. Can anyone
 help me with this issue.

 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.




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] going crazy with pyfpdf

[Carlos Costa]

It uses pyfpdf to convert it.
But there are some restrictions as I remember.
You check it here https://code.google.com/p/pyfpdf/


2014-05-21 12:13 GMT-03:00 Carlos Cesar Caballero Díaz 
desarro...@spicm.cfg.sld.cu:

  Hi, I need some help, when I call a view with .pdf this:

 html
 head
 titleReport/title
 /head
 body
 table
 tr
 td width=50%name/td
 td width=50%pepe/td
 /tr
 /table
 /body
 /html

 or this:

 body
 table
 tr
 td width=50%name/td
 td width=50%pepe/td
 /tr
 /table
 /body

 returns a blank one page pdf. Now if I put the content before the body
 tag, it is rendered, but the table allways throw a
 Table column/cell width not specified, unable to continue error.

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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: TAG helper can not parse html

[Carlos Costa]

Yeah, the error is thrown by HTMLParser, TAG is build on top of it.
I will try some other tools like Beautifull Soup.

Thanks.


2014-05-20 10:04 GMT-03:00 Anthony abasta...@gmail.com:

 No, TAG is only a basic parser and not robust against errors in the HTML.
 You should probably use a more sophisticated tool, such as Beautiful Soup
 (which is built on top of the lxml and html5lib parsers). The standard
 library also includes the HTMLParser module, but you may run into similar
 problems with that.

 Anthony


 On Tuesday, May 20, 2014 8:14:37 AM UTC-4, yamandu wrote:

 I am trying to parse a HTML with the TAG helper from a fetched URL using
 urllib.
 The HTML is broken in some parts, it has end span tags without respective
 start span tags.

 TAG helper gives error: unable to balance span tag.

 I tested it. Open tags not closed are parsed, but not closed tags without
 open.

 Would be there a work around for this?

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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: help with helper!

[Carlos Costa]

It is because you are using it the wrong way.

MENU helper itself generates the html marckup, ul, li, a, etc

Give a look at the documentation here
http://web2py.com/books/default/chapter/29/05/the-views?search=menu#MENU

Look that MENU has some optional arguments to setup the classes to custom
ones:

The MENU helper takes the following optional arguments:

   - _class: defaults to web2py-menu web2py-menu-vertical and sets the
   class of the outer UL elements.
   - ul_class: defaults to web2py-menu-vertical and sets the class of the
   inner UL elements.
   - li_class: defaults to web2py-menu-expand and sets the class of the
   inner LI elements.
   - li_first: allows to add a class to the first list element.
   - li_last: allows to add a class to the last list element.


But it always generate the same kind of structure:

 print MENU([['One', False, 'link1', [['Two', False, 'link2')
ul class=web2py-menu web2py-menu-vertical
  li class=web2py-menu-expand
 a href=link1One/a
 ul class=web2py-menu-vertical
lia href=link2Two/a/li
 /ul
  /li
/ul

I you really need a different one, you should write it your own.

If your menus don't change do it hardcoded.



2014-05-15 15:58 GMT-03:00 Dave S snidely@gmail.com:



 On Thursday, May 15, 2014 10:21:48 AM UTC-7, greenpoise wrote:

 Yes font-awesome is what I am trying to use. Both attempts, yours and
 yamandu prompt me the same error

 (name, active, link) = item[:3]
 ValueError: need more than 2 values to unpack



 Is there a line number associated with that error message?  Is item
 something in your code, or is it part of the helper?  Evidently it's being
 created with only 2 values, instead of the 3 needed.  I'm tempted to say
 that active should be a boolean, but that's just a guess.

 /dps




 On Wednesday, May 14, 2014 8:36:48 PM UTC-7, Joe Barnhart wrote:

 I see you're using font-awesome.  You need to add fa as well as the
 icon name you want fa-home.  I also recommend you use the URL helper if
 you ever want the url re-writing features of web2py.  My recommendation is:

 A(I(_class=fa fa-home),SPAN(Home,_class=menu-item-parent),_href=
 URL('index'))

 Please notice the underscore in the class and href entries.  That is
 how web2py knows you want those to wind up on the final HTML version of the
 element and keeps the names from colliding with Python identifiers (like
 class).


 On Wednesday, May 14, 2014 2:59:03 PM UTC-7, greenpoise wrote:

 I need help with this helper!

 I have this

 a href=index.html title=Homei class=fa-home/i span class=
 menu-item-parentHome/span/a


 and I made this:

 [A(I(SPAN(_class=('menu-item-parent','Home')), _class='fa-home',_title=
 'Home',), False, None, []),]



 I am missing the URL('home) cant get it to work. Where should I put it?


 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.




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] help with helper!

[Carlos Costa]

Like this

A(I(_class=fa-home),SPAN(Home,_class=menu-item-parent),_href=index.html,
_title=Home)


2014-05-14 18:59 GMT-03:00 greenpoise danel.sega...@gmail.com:

 I need help with this helper!

 I have this

 a href=index.html title=Homei class=fa-home/i span class=
 menu-item-parentHome/span/a


 and I made this:

 [A(I(SPAN(_class=('menu-item-parent','Home')), _class='fa-home',_title=
 'Home',), False, None, []),]



 I am missing the URL('home) cant get it to work. Where should I put it?


 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.




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] help with helper!

[Carlos Costa]

Are you using it in the MENU helper?


2014-05-14 20:14 GMT-03:00 greenpoise danel.sega...@gmail.com:

 I tried this but didnt work. I am using it in the menu section


 Thanks



 On Wednesday, May 14, 2014 3:59:19 PM UTC-7, yamandu wrote:

 Like this

 A(I(_class=fa-home),SPAN(Home,_class=menu-item-parent),_href=index.html,
 _title=Home)


 2014-05-14 18:59 GMT-03:00 greenpoise danel@gmail.com:

 I need help with this helper!

 I have this

 a href=index.html title=Homei class=fa-home/i span class=
 menu-item-parentHome/span/a


 and I made this:

 [A(I(SPAN(_class=('menu-item-parent','Home')), _class='fa-home',_title=
 'Home',), False, None, []),]



 I am missing the URL('home) cant get it to work. Where should I put it?


 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+un...@googlegroups.com.

 For more options, visit https://groups.google.com/d/optout.




 --
 Att.

 Carlos J. Costa
 Cientista da Computação
 Esp. Gestão em Telecom

 EL MELECH NEEMAN!
 אָמֵן

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] OAuth - Can Users Authenticate without an Internet connection?

[Carlos Costa]

If they share the same DB and they all are in the same network, the builtin
authentication will work.

If not, you may want to sync the authentication tables while you have
connection. So each local application will have a copy.



2014-05-01 12:22 GMT-03:00 Brando bhe...@trustcc.com:

 What are my options if I want users to be able to login with or without an
 internet connection and still be able to centrally control authentication
 on all the nodes?   Keep in mind that these machines will have internet
 connection throughout the day, however they will be offline for an hour or
 two at the time.



 On Wednesday, April 30, 2014 1:46:01 PM UTC-7, yamandu wrote:

 If each node must authenticate with OAuth with it will requires internet
 connection.
 Give a look here: https://developers.google.com/accounts/docs/OAuth2


 2014-04-30 16:30 GMT-03:00 Brando bhe...@trustcc.com:

 I want to use OAuth + Google and want to know if things will work if a
 node is offline.  My app model is as follows.


 I will have about 15 laptops in the field.
 Each laptop will have a local copy of the app installed.
 The laptop may/may not have Internet access.
 I plan on using Couchbase for the DB
 I need to be able to restrict access to a particular user (if they get
 fired or something)

 Is it possible to allow people to login even if they don't have Internet
 access?  How would this work?

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




 --
 Att.

 Carlos J. Costa
 Cientista da Computação
 Esp. Gestão em Telecom

 EL MELECH NEEMAN!
 אָמֵן

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] OAuth - Can Users Authenticate without an Internet connection?

[Carlos Costa]

If each node must authenticate with OAuth with it will requires internet
connection.
Give a look here: https://developers.google.com/accounts/docs/OAuth2


2014-04-30 16:30 GMT-03:00 Brando bhe...@trustcc.com:

 I want to use OAuth + Google and want to know if things will work if a
 node is offline.  My app model is as follows.


 I will have about 15 laptops in the field.
 Each laptop will have a local copy of the app installed.
 The laptop may/may not have Internet access.
 I plan on using Couchbase for the DB
 I need to be able to restrict access to a particular user (if they get
 fired or something)

 Is it possible to allow people to login even if they don't have Internet
 access?  How would this work?

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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: first() as aggregation function

[Carlos Costa]

I think he is looking for the first record of each group, not the first
record of the entire result.
I think there is no such function in web2py yet.

I have performed a similar task for reporting using this:
https://docs.python.org/2/library/itertools.html#itertools.groupby

It will require more computation and memory as you will have do it in
memory but is possible and simple.


2014-04-28 10:33 GMT-03:00 Jim S j...@qlf.com:


 http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#first-and-last

 Is this what you were looking for?

 -Jim

 On Monday, April 28, 2014 7:20:15 AM UTC-5, Manuele wrote:

 Hi!
 does exists or can be implemented an aggregation function that returns
 the first element of a group instead of the sum, max, min or avg result?

 Thank you... as usual :)

 Manuele

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] URLising Links in Tables

[Carlos Costa]

Use represent and the tag A helper.

db.table_name.link_field.represent = lambda value, row: A(value,
_href=value)


2014-04-28 13:17 GMT-03:00 jaw...@gmail.com:

 Hi

 I've created a run-of-the-mill table:

 def index():
 grid = SQLFORM.grid(db.table_name, user_signature=False)
 return dict(grid=grid)

 One of the columns in the table is an actual link - how do I go about
 making this clickable?

 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.




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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: first() as aggregation function

[Carlos Costa]

Jim, I thought that at first too. :)


2014-04-28 16:06 GMT-03:00 Niphlod niph...@gmail.com:

 seems to me that you should use windowing functions instead

 there's no need to introduce a new method you can use expression
 themselves in the select, and extract the field as usual

 myexpr = 'first_value(b_field) over (partition by a_field order by
 b_field)'
 rows = db2(db2.test_table.id  0).select(myexpr, db2.test_table.a_field)
 for row in rows:
 print row.aa, row[myexpr]




 On Monday, April 28, 2014 4:46:43 PM UTC+2, Manuele wrote:

 Il 28/04/14 16:05, Carlos Costa ha scritto:
  I think he is looking for the first record of each group, not the
  first record of the entire result.
  I think there is no such function in web2py yet.
 
  I have performed a similar task for reporting using this:
  https://docs.python.org/2/library/itertools.html#itertools.groupby
 
  It will require more computation and memory as you will have do it in
  memory but is possible and simple.
 starting from the point I'm using postgresql (v. 9.3) I was thinking
 about introducing a new method to the class Expression in dal defined as
 follows:

 def array_agg(self):
 db = self.db
 return Expression(db, db._adapter.AGGREGATE, self, 'array_agg',
 self.type)

 and get the first argument of the returned list.

 maybe this method can be introduced in the dal code but for the moment
 Is there a way to locally monkey patch the Expression class for my
 application?

 thank you
 Cheers

 Manuele

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] too many values to unpack

[Carlos Costa]

To show some code should help us to help you.

This type of error occurs when something like this is tried;
d = dict(a='a',b='b')
a, b, c = d



2014-04-16 6:36 GMT-03:00 Richard richard.dijks...@planet.nl:


 I have a working app and added a list of form in the response variables
 from the controller tot the view. Now the app comes with the error too
 many values to unpack.
 I can imagine that there is a limit tot the response size. Is there and
 how can I increase this.

 Background info: I want to add a button to records for changing and
 deleting that record. So I create a list of forms with the specific
 record=id parameter. This solution is not optimal for memory and speed, but
 quite easy to implement. Some clever rpc functionality might also do the
 trick.

 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.




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] 'Table' object has no attribute 'attr'

[Carlos Costa]

The book says in
http://web2py.com/books/default/chapter/29/07/forms-and-validators
causes the hidden fields to be passed with the submission, no more, no
less. form.accepts(...) is not intended to read the received hidden fields
and move them into form.vars. The reason is security. Hidden fields can be
tampered with. So you have to explicitly move hidden fields from the
request to the form:

form.vars.a = request.vars.a


So I think you do not have attr field in the table activity, do you?

If so, you should do something like that:

values=request.vars
del values['attr']
db(db.activity._id == request.vars['id']).update(**dict(values))





2014-04-16 13:36 GMT-03:00 Richard richard.dijks...@planet.nl:

 I have used a form in a view and want to update a record after submit:

 View:
 {{=SQLFORM(db.activity, record = a.id, deletable = True,
 hidden=dict(attr='chgact'))}}


 controller:

 if (request.vars['attr'] == 'chgact') and
 (request.vars['delete_this_record'] != 'on'):
 db(db.activity._id ==
 request.vars['id']).update(**dict(request.vars))

 I use the convention in the controller because is is described in the
 manual in chapter 6:

 The update of record with given id can be done with:
 Inserting and updating from a dictionary

 A common issue consists of needing to insert or update records in a table
 where the name of the table, the field to be updated, and the value for the
 field are all stored in variables. For example: tablename, fieldname, and
 value.

 The insert can be done using the following syntax:

 db[tablename].insert(**{fieldname:value})

 The update of record with given id can be done with:
 db(db[tablename]._id==id).update(**{fieldname:value})

 Notice we used table._id instead of table.id. In this way the query works
 even for tables with a field of type id which has a name other than id.


 What is going wrong?

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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: Brazilian web2py users, what system do you use to receive credit card payments?

[Carlos Costa]

Pagseguro, for sure is the most used here in Brazil.
It belongs to UOL, it has a lot of advertising on TV.
Its the best know and trusted.

Another options are:
-mercado pago
-bcash
-moip
-braspag
-f2b
-paypal Brasil

I tried to sort them in an order of popularity.


2014-04-11 23:54 GMT-03:00 samuel bonill pythonn...@gmail.com:

 i use stripe.com

 El viernes, 11 de abril de 2014 09:39:15 UTC-5, Leonel Câmara escribió:

 I have a Brazilian costumer and I will need to implement this soon so I'm
 now evaluating the available options. Any suggestions?

 Until now I have found this project by Bruno Rocha:
 https://github.com/rochacbruno/python-pagseguro

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] AYUDA como ajustar la resolucion de la pagina de web segun el navegador ?

[Carlos Costa]

Mayra, esto es lo grupo web2py en ingles.
Por favor, reecriba tu question en ingles para que qualquier uno pueda
compreenderla.
Asi tenes mas chances de ser respondida.

Mayra, this is the web2py group in english.
Please, rewrite your question in english so anyone can understand it.
So you more chances to be answered.

The default layout.html already fits well and resizes itself when displayed
and smaller devices.
You can teste this by simpling resizing your browser window.
For me, it looks like you have a issue with your own css styling.
Maybe you need to redesign it avoiding fixed widths and heights.
Also give a look at the Bootstrap documentation, it is the css (and other
things) framework used now in Web2py.
Look how you can design your layout safely across different devices using
the appropriated classes.
http://getbootstrap.com/2.3.2/scaffolding.html#gridSystem


2014-04-15 9:12 GMT-03:00 Mayra Marticorena marticorenama...@gmail.com:

 hola buen dia , como andan ? estoy teniendo problemas de resolucion en mi
 pagina de web , http://www.distribuidorahenry.com.ar/welcome/default/index, 
 si entro en la pc que he utilize para armar esta misma , se ve claramente
 , sin embargo cuando entro con otra pc se ve mal , saltos de pagina e
 margenes etc . Existe un parche , que automaticamente se ajuste a los
 diferentes resoluciones , de los navegadores ? .
 Desde ya , muchas gracias !

 mayra

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] Need a developer. Seattle Wa

[Carlos Costa]

I guess it will be easier to find devs to work remotely for you.
Here in the group or even in ODesk for example.
Or if you prefer a local dev, you can hire a Django dev and ask him to
learn web2py.
He will find a very easy learning curve.


2014-04-04 2:59 GMT-03:00 Brando bhe...@trustcc.com:

 It's pretty easy to find Django developers out there; however, I can't
 seem to find web2py devs.  I have an upcoming project to build an app for
 data entry and report generation for security audits (penetration testing).
  I need a developer who can help me build out the code base and is familiar
 with ajax/jquery data entry.

 Can someone point me in the right direction?

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




-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 
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] Fun with Scheduler

[Carlos Costa]

Very good idea. I have not learned to use scheduler yet.
This would be very useful, I think.


2013/6/5 Joe Barnhart joe.barnh...@gmail.com

 I think the web2py scheduler is the most amazing thing ever added to the
 platform.  It is truly a wonder in that it works so well and has such a
 clean design.

 I was trying to improve it in the most minor way -- I wanted to create a
 decorator that causes a function to be submitted to the scheduler instead
 of being executed directly.  That way I could easily switch from background
 to foreground processing by commenting out the decorator, or add new
 functions to the scheduler by adding the decorator.  Here's what I came up
 with:


 def scheduled(name=Scheduled,timeout=60):
 def wrap(f):
 def new_f(*a):
 current.db.scheduler_task.insert(
 task_name=name,
 function_name=f.__name__,
 args='%s'%str(list(a)),
 timeout=timeout)
 return new_f
 return wrap


 In this decorator, I only passed two variables to the scheduler --
 task_name and timeout.  The heck of it is, I think the decorator is working
 except I'm running into a conceptual problem with the scheduler in
 general.  Using it I can create a new scheduled task:


 @scheduled(name='import_times')
 def import_cl2times(fid):
 from ssobjects import SsMessage
 from ssimporter import SsImportTimes
 if fid:
 fname=current.db.fileobject(fid).get('filename')
 SsImportTimes.cl2read(fid)
 msg=SsMessage(subject=Meet results,message=File import of meet
 results %s is complete.%fname)
 msg.send()
 return


 This code lives in a module and is called by the scheduler.  Or maybe
 isn't.  I seem to be having module/controller/model difficulty at the
 moment.

 I have much of my functionality in modules, to permit the speed of
 compiled code in my rather large and growing website.  I would like to call
 the decorator from either the context of the models, or from tasks already
 running in the background, in a module.  Yes, I have background tasks which
 schedule other background tasks.  Have I mentioned how much I love the
 scheduler??!?

 I can't seem to get the various imports right to have the scheduler
 actually be able to run a bit of code in a module.  i had it working at one
 point when the scheduler and all of its background tasks were in the model
 file.  But I couldn't schedule tasks from a module since the module can't
 see the model's context.  But now that everything is in modules, the
 scheduler can't seem to find the code to run it.

 Any help is appreciated.


  --

 ---
 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/groups/opt_out.






-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 

--- 
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/groups/opt_out.

Re: [web2py] Avoiding extra quries when using DAL

[Carlos Costa]

Maybe something like that.
You could do the query and save it as a dict and work on it.

result = db(db.table2.id  0).select().as_dict()
retVal = [entity.name for entity in result]


2013/6/4 guruyaya guruy...@gmail.com

 Lets examine this code for a sec:
 db.define_table('table1',Field('name'))
 db.define_table('table2',Field('table1', db.table1), Field('name2'))

 Now, if I need a list of all table2 entries, but not the table1 entries,
 I'll do something like this:

 retVal = []
 for entity in db(db.table2.id  0).select():
 retVal += entity.name2

 BUT
 As you well know, web2py acctuall did ask for table1 info, just in case
 I'll do this:

 retVal = []
 for entity in db(db.table2.id  0).select():
 retVal += entity.table1.name

 On a normal hosting, it doesn't matter that much, but on GAE, it does an
 extra query to the datastore, and that's just a waste.
 Is there a way to avoid that?

 Thanks in advance
 Yair

 --

 ---
 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/groups/opt_out.






-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 

--- 
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/groups/opt_out.

Re: [web2py] Re: Avoiding extra quries when using DAL

[Carlos Costa]

Hum, I forgot the problem has two tables. Nice!


2013/6/4 Massimo Di Pierro massimo.dipie...@gmail.com

 I would replace

 retVal = []
 for entity in db(db.table2.id  0).select():
 retVal += entity.table1.name

 with

 table1_map = db(db.table2 http://db.table2.id/).select().as_dict()
 retVal = [table1_map[entity.table1].name http://entity.table1.name/ for
 entity in db(db.table2 http://db.table2.id/).select()]

 It will loads all records from table1 in ram but your code does it too.
 Two queries instead of many.
 select().as_dict() creates a dict where the key is the id and the value is
 the record.

 On Tuesday, 4 June 2013 04:25:06 UTC-5, guruyaya wrote:

 Lets examine this code for a sec:
 db.define_table('table1',**Field('name'))
 db.define_table('table2',**Field('table1', db.table1), Field('name2'))

 Now, if I need a list of all table2 entries, but not the table1 entries,
 I'll do something like this:

 retVal = []
 for entity in db(db.table2.id  0).select():
 retVal += entity.name2

 BUT
 As you well know, web2py acctuall did ask for table1 info, just in case
 I'll do this:

 retVal = []
 for entity in db(db.table2.id  0).select():
 retVal += entity.table1.name

 On a normal hosting, it doesn't matter that much, but on GAE, it does an
 extra query to the datastore, and that's just a waste.
 Is there a way to avoid that?

 Thanks in advance
 Yair

  --

 ---
 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/groups/opt_out.






-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 

--- 
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/groups/opt_out.

Re: [web2py] form.custom in modal window

[Carlos Costa]

Have you tested it without modal?
Just hit the url for mailVcard.load and make shure it works.
If if works you may have to debug the javascript using firebug for example.


2013/5/16 Annet anneve...@googlemail.com

 I have the following link to open a view in a modal window:


 a href=#vCardModal data-toggle=modalimg
 src={{=URL('static','img/icons/vCard.png')}} alt= width=48px
 height=48px //a

 div id=vCardModal class=modal hide fade
   {{=LOAD('vcard','mailVcard.load', args=node.id, ajax=True,
 ajax_trap=True)}}
 /div !-- /modal --


 This is the mailVcard.load view:


 div class=modal-header
   button type=button class=close data-dismiss=modal
 aria-hidden=truetimes;/button
   h3{{=response.bannerHeader}}/h3
 /div !-- /.modal-header --
 div class=modal-body
   form action= enctype=multipart/form-data method=post
 class=form-horizontal
 div class=control-group
   div class=controls
 {{=form.custom.widget.replyTo}}
   /div !-- /.controls --
 /div !-- /.control-group --
 div class=control-group
   div class=controls
 {{=form.custom.widget.to}}
   /div !-- /.controls --
 /div !-- /.control-group --
 /div !-- /.modal-body --
 div class=modal-footer
   div class=control-group
 div class=controls
   {{=form.custom.submit}}
   button type=button class=btn data-dismiss=modal
 style=margin-right: 125px;Sluit/button
   {{=form.custom.end}}
 /div !-- /.controls --
   /div !-- /.control-group --
 /div !-- /.modal-footer --

 When I click the submit button, nothing happens. What in Bootstrap modal
 is the cause of this problem,
 what is the easiest way to solve it?


 Regards,

 Annet

  --

 ---
 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/groups/opt_out.






-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 

--- 
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/groups/opt_out.

Re: [web2py] How to run web2py on Linux Shared Hosting With No Shell, or SSH access

[Carlos Costa]

Have you asked your host for SSH access?
I have used hostgator, I have to ask then to grant me SSH access, and even
with this is a pain to make web2py run there.
If they dont give it anyway, consider change the host, give a try at
pythonanywhere.com, you should install web2py with one click.


2013/5/16 Neeraj Kumar neeraj.mo...@gmail.com

 Hi,

 I am trying to deploy Web2Py on my linux shared hosting with
 siliconhouse.net.

 Python runs on their system, able to run HelloWorld.py

 But when i unzipped the files on my public_html folder(with 755 permission
 on *.py files), instead of running it, it shows me listing of all files
 including *.py files.

 I am not sure what the problem is? If i click on any *.py files, it shows
 me 500-Internal Server Error 500.

 I have no shell or SSH access, is there a simple and easy way for me to be
 able to run web2py on this.

 They are using mod_python, and i can not deploy mod_wsgi. Is there any
 alternate, or is there something i can do my editable area i.e. inside
 public_html/..., so that when open my site i should be able to see running
 web2py application of my choice?

 I shall be highly thankful for any assistance on this.

 Regards,
 Neeraj Kumar



 --

 ---
 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/groups/opt_out.






-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 

--- 
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/groups/opt_out.

Re: [web2py] Dynamic IS_IN_DB

[Carlos Costa]

You may try something like this:

for id in id_list:
 query = query | (db.asset_class.id == id)
requires = IS_IN_DB(query,..)


2013/5/2 Domagoj Kovač doctorko...@gmail.com

 Hi,

 i want to have dynamic query in my IS_IN_DB validator:
 requires = IS_IN_DB(db((db.asset_class.id == 10) |
(db.asset_class.id == 9) |
(db.asset_class.id == 7)), 'asset_class.id',
 '%(name)s', zero=T(-- Odaberite --))

 I want to have query like this but, right now my values are hardcoded, how
 can i generate something like (db.asset_class.id == 10) | (db.asset_class.
 id == 9) | (db.asset_class.id == 7)

 Lets say that i have a list of ids in available_classes = db(
 db.asset_class.id  0).select()

 --

 ---
 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/groups/opt_out.






-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 

--- 
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/groups/opt_out.

Re: [web2py] Doubt in the example provided on web2py manual page 98

[Carlos Costa]

Probably you are confused because of this code present in index.html:

{{elif 'content' in globals():}}
{{=content}}
{{else:}}
{{=BEAUTIFY(response._vars)}}
{{pass}}

If theres no content it renders the BEAUTIFY(response._vars) just like the
generic view, so its not the generic view being rendered but a similar view.



2013/3/14 Sarbjit singh sarbjit1...@gmail.com

 In the 5th edition of web2py manual, for the example of images app, I have
 one doubt :-

 As per that app code, we create db in models (db.py) and then we write
 some code in controller (default.py) as :-

 def index():
images = db().select(db.image.ALL, orderby=db.image.title)
return dict(images=images)

 In the documentation it is written :-

 If you do not write a view, the dictionary is rendered by
 views/generic.html and a call to the index action would look like this:

 It seems to work like this only but my question is when we create a new
 app as specified in the manual. default/index.html is already present
 (index name is same as my function name in default.py), then why
 generics.html is being used and not index.html which is already present. In
 first example, index.html is seemed to be used.

 Thanks
 Sarbjit

 --

 ---
 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/groups/opt_out.






-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 

--- 
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/groups/opt_out.

Re: [web2py] REF: SQLFORM.grid: Determine when a new record is added

[Carlos Costa]

Check oncreate argument.


2013/3/14 Teddy Nyambe software@gmail.com

 I want to add logic when a user clicks on submit to add a new record using
 the SQLFORM.grid, I would like to do something. I have checked the vars and
 args there is nothing to indicate this only when a form is requested for
 add, edit, view...

 --

 ...
 Teddy Lubasi Nyambe
 Opensource Zambia
 Lusaka, ZAMBIA

 Cell: +260 97 7760473
 website: http://www.opensource.org.zm

 ~/
 Human Knowledge belongs to the world! - AntiTrust

 Man is a tool-using animal. Without tools he is nothing, with tools he is
 all - Thomas Carlyle 1795-1881

 /~

 --

 ---
 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/groups/opt_out.






-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 

--- 
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/groups/opt_out.

Re: [web2py] Re: creating groups

[Carlos Costa]

You can create records and the the auth_group to create a group give a look
at it in the database admin, it is simple.

For example:
form = crud.create(db.auth_group)

with this line you can create a form where the user will insert a record,
so creating a new group.

To put someone in a group simply add a record in auth_membership.
Something like this:
form = crud.crate(db.auth_membership)

User must fill group and the user to add.

For setting preferences you can create another table that references a
group.
Put fields in this table for the preferences.
Something like this.

db.define_table('group_preferences'),
   Field('group',db.auth_group),
   Field('chat'),boolean), .. # other fields as
need
)

To verify if a user can chat with another you can do something like this:

can_chat = db(db.auth_group.user==userid_to_chat 
db.group_preferences.group==db.auth_group.id 
db.group_preferences.chat).select()
if len(can_chat)  0:
  # if you got some record in the query the you can chat
























2013/3/2 sasogeek sasog...@yahoo.com

 Help...

  --

 ---
 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/groups/opt_out.






-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 

--- 
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/groups/opt_out.

Re: [web2py] refresh div in a html page (web2py)

[Carlos Costa]

What you get when you access the test2.html url in the browser?
Maybe the url is wrong.
Try to inspect using firebug in error console.


2012/12/18 yn yn lkga...@gmail.com

 Hi I am starting using web2py. I have a page web Test.html in view with a
 div: . On the other hand, I have a page web in the same folder: Test2.html
 with some code in python:

 {{items = ['a', 'b', 'c']}}{{i=1}}table{{for item in items:}}
 tr
 td/brSOME CONTENT/td
 /tr{{i=i+1}}{{pass}}/table

 How can I do to put the Test2.html content in the div IDtest? any example?
 Thanks. The goal is to learn how to insert a dynamic table in IDtest. I
 mean, I would refresh the IDtest content afther pushing a button for
 example

 LAST TEST: I have tested

 script src={{=URL('static', 'js/jquery.js')}} 
 type=text/javascript/script ... and then script 
 type=text/javascriptjQuery(document).ready(function() { 
 setInterval(function() {var url ='{{=URL('Test2.html')}}'; 
 jQuery('#IDtest').load(url);alert(HELLO);}, 5000); }); I can see the HELLO 
 evrey 5 seconds but nothing in div... any sugestions?

 I can see HELLO every 5 seconds but nothing happens related to div... It
 seems the load doesn't work... Any solutions? I have read on the net that
 load works on the server side but I don't know how to translate that in
 web2py?

 --







-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

-- 

Re: [web2py] formatting time string during field update

[Carlos Costa]

In web2py_ajax.html there is the format that is used for jquery, try that.


2012/12/18 marino segnan sgn...@gmail.com

 Hello,

 I am a beginner with web2py and I have this apparently simple problem.
 I have a db table:

   db.define_table('tappe',
Field('ora','time',requires=IS_TIME('%H:%M'))
 )

 I would like to display the time in  all the forms
 always in the same format as the validator, foe example '12:13'
 but:

 1)  I tried represent(..) and works only in crud.read(..);
crud.update(..) ignores it

 2) I tried using SQLFORM(..) and changed the variable value, eg.

  form.vars.ora = row.ora.strftime('%H:%M')

  and the string is temporarily formatted as requested,
  but when I edit it, it changes again to ' %H:%M:%S'

 What am I missing?
 What is the recommended solution?

 Thanks in advance.

 --







-- 
Att.

Carlos J. Costa
Cientista da Computação
Esp. Gestão em Telecom

EL MELECH NEEMAN!
אָמֵן

--