[web2py] Re: sql "like' equivalent

[pbreit]

http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#like--regexp--startswith--endswith--contains--upper--lower



On Friday, July 11, 2014 11:46:01 AM UTC-7, Jason Solack wrote:
>
> Hello everyone!
>
> I'm wondering if there is a "like" equivalent in the web2py DAL.
>
> I would like to do something like this:
>
>
> db().select(db.person.name like 'JA')
>
>
> thank you in advance for your help.
>
> Jason
>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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: can web2py expose coffee files to allow source maps ?

[António Ramos]

the point here is not coffeescript but source maps being expose to help
debug coffeescript or other pre processor languages for example in the
browser.




2014-07-11 23:21 GMT+01:00 António Ramos :

> Can this help to use coffeescript instead of javascript ?
>
>
> http://tarantsov.com/WorkflowThu/source-maps-with-coffeescript-and-uglify-js/
>
> web2py does not expose coffeefiles as the video says.. does it?
>
> Regards
>
> António
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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] can web2py expose coffee files to allow source maps ?

[António Ramos]

Can this help to use coffeescript instead of javascript ?

http://tarantsov.com/WorkflowThu/source-maps-with-coffeescript-and-uglify-js/

web2py does not expose coffeefiles as the video says.. does it?

Regards

António

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

[web2py] Re: How to create object of 'Storage' In class I created?

[Omri Levy]

Thanks , It works :)

On Thursday, July 10, 2014 1:00:30 PM UTC+3, Niphlod wrote:
>
> from gluon.storage import Storage
>
>
> mydict = dict(a=1,b=1)
> print mydict['a']
> print mydict.a --> exception
> mydict = Storage(mydict)
> print mydict['a']
> print mydict.a --> no exception
>
>
>
>
> On Thursday, July 10, 2014 4:23:41 AM UTC+2, Omri Levy wrote:
>>
>> Hi ,
>>
>> I have created a class (that i put in models folder), and all it methods 
>> returns complicated dictionaries.
>> When I try to access these variables like Storage (foo.bar) I get the 
>> following exception: 'dict' object has no attribute
>>  I thought that all dictionaries are being converted automatically into 
>> Storage, but i guess they don't.
>> I've tried to wrap the return value with Storage constructor but then I 
>> get an exception saying that there is no such thing as Storage.
>>
>> Can someone please enlighten me?
>>
>> Thanks ,
>>
>> Omri.
>>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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] TV Centric websites

[Tom Clerckx]

Hi all,

I've been working with web2py for a few months now and I must say: I'm a 
big fan.
Nowadays, I'm looking more into building TV-centric sites and I was 
wondering if this is/will be supported in web2py.

I'm talking about websites that you can directly load on the browser of a 
TV or set top box and that are designed for the TV set.

Good examples of such site are:
http://gtv.uinterview.com/
http://www.nytimes.com/gtv/

It's important that the UI is made to run full-screen and the navigation 
can be done using solely arrow-keys and the enter key (which map to the 
remote control arrow-keys and OK key)

If this is/will be supported I would be very interested.
Other suggestions are very welcome as well.

Best regards,
Tom.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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] app engine bug? Invalid view reported for app engine but not elsewhere

[Carl Hunter Roach]

In my default.py I add a function newview

when running locally on 127.0.0.1:8000 all is fine but if I try 
dev_appserver or GAE then newview runs but on returning my browser displays 
the error "invalid view (default/newview.html)

If I add a new html file all runs fine

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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] Delete Query Not Working

[samurai]

As both Manuele and Leonel said, I changed it to args(0). But no use. It 
was still not working.

I actually changed a bit and now I am getting 'd' by get.vars.

def pro_del(): 
 d = request.get_vars.d 
 db(db.products.product_id == d).delete() 
 session.flash = "Product Deleted" 
 redirect(URL('default','index')) 
 #return locals()

Now also everything is working fine except the delete query.
Note: I am redirecting and appending the vars by using a javascript 
function on the view side. If it has to do something with this problem.

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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] Process uploaded file

[David Jobes]

I have a db table that holds the files i have uploaded, i need to then be 
able to process them and add the information into another db table, i have 
not been able to find anything on it or in any book. suggestions or ideas

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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] sql "like' equivalent

[Jason Solack]

Hello everyone!

I'm wondering if there is a "like" equivalent in the web2py DAL.

I would like to do something like this:


db().select(db.person.name like 'JA')


thank you in advance for your help.

Jason

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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] Encode problem in response.cookies

[Arthur Alves]

Hello guys,

I have a problem with response.cookies in web2py. Our project use encode 
utf-8 (Brazil). I have a cookie with people session name, but the cookie is 
set in browser like this "Ju\303\243o" instead "Juão". I try use 
encode('utf-8') in python, and unescape in javascript, and the result is 
the same. Somebody help me?

web2py version 2.8.2

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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: Running web2py with settings in a config file

[Kuba Kozłowicz]

I have following project structure:

T:/MyFolder/web2py.py
T:/MyFolder/etc/config.py

I am trying to run the instance with following command:

C:\Python27\python.exe T:/MyFolder/web2py.py --config=
'T:/MyFolder/etc/config.py'

And I am getting following response:

Cannot import config file ['T:/MyFolder/etc/config.py']

Could you please provide one, complete example of a command, that can run 
the instance from command line and loads the setttings from a config file?

I couldn't find anything neither in the docs nor in the web.

W dniu środa, 9 lipca 2014 14:04:20 UTC+2 użytkownik Massimo Di Pierro 
napisał:
>
> You should in fact use a different filename for your --config. The 
> paramater_<>.py file is meant to contain only the password and it can be 
> overwritten by web2py if you change your password using the admin interface.
>
> On Tuesday, 8 July 2014 06:40:20 UTC-5, Kuba Kozłowicz wrote:
>>
>> I am trying to run web2py application from command line with such a 
>> command:
>>
>> C:\Python27\python.exe T:/MyFolder//web2py.py -a '' --config=
>> parameters_8080.py
>>
>> and I have specified my application's settings in the file called 
>> "parameters_8080.py":
>>
>> password=
>> "pbkdf2(1000,20,sha512)$9b51a45d2413e210$cc5ea267ebe279f1af5dedf3710b3c9e95cf4f8e"
>> port = 8080
>> ip = '127.0.0.1'
>>
>> 1. Whenever I enter one of my application's page, this the file 
>> "parameters_8080.py" gets cleard so that only password field stays inside 
>> it. Why does this happen?
>> I think the docs do not specify clearly how to use '' and what 
>> is going on here.
>>
>>
>> 2. Is it possible to specify that config file somewhere else than in 
>> project's root folder and named as "parameters_.py" ? I want to 
>> create a folder called "etc" in my application and put config there.
>>
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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] update_or_insert - handling record created/modified timestamps

[Carl Hunter Roach]

I am using Web2py on an appengine project and each of my tables include two 
'datetime' fields cDate and mDate to record when the record was created and 
modified respectively.

Last time I used Web2py I'd check if  a record existed and call insert() or 
update_record() appropriately.

Now, I can potentially use update_or_insert() but I don't see how I can 
pass in cDate and mDate for "insert" but mDate only for "update_record"

Does web2py have create/modify fields like it adds an "id" to all tables 
and handle this for me?

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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: update database right from view?

[Julio F Schwarzbeck]

I'd suggest finding an alternative way of handling this, the below can 
become a real pain to maintain, not to mention the complexity of the 
algorithm being a O(n3) will be extremely inefficient and can 
potentially be very slow, try to minimize the use of "inner loops" 
unless there is no other possible way, maybe by crafting a better query 
that pulls the data.


Also, you don't have to create a form in the controller, in fact I 
personally would not recommend this at all, even though web2py allows 
"form helpers", this means that the "developer" will be creating these 
UI elements where it should be done by the UI designer (even if it is 
the same person), this sounds silly but is the basis of the "MVC" design 
pattern, if you are starting with either web2py, python or developing in 
general, try to stick to best practices and you'll slowly start 
understanding why this is so important, especially when dealing with 
large projects.


Having said that, using the standard Model-View-Controller Pattern which 
web2py so elegantly implements, you'd end up doing something like this:


index.html:


[all your form elements, including the loops etc]


index.py:

Call the query to return the data to pass to the view, create a kick-ass 
query(ies) and try to optimize it as much as you can.


db.py (your controller)

DB Definitions

It is extremely simplistic, but it should get you started, there are 
many examples you can read in this list, hope you find one that suits 
your needs.


Regards,

Julio

On 07/09/2014 02:26 PM, Maria Levchenko wrote:

This is my view:
{{for row in texts:}}
 {{=row.sentences}}: {{=row.meaning}}
 {{for ff in row.forms:}}
 {{if len(ff)>0:}}
{{c=ff.split()}}
  {{for cc in c:}} {{=cc}}
 {{pass}}
{{pass}}
{{pass}}
{{pass}}





--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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: show_if belongs condition.second is set()

[villas]

Regarding this code 

:

if isinstance(cond.second, set):
> cond.second = list(cond.second)
> if isinstance(cond.second, (list, tuple)):
>return base, ','.join("[value='%s']" % (v) for v in cond.second)


Why is it not simply this?:

if isinstance(cond.second, (set, list, tuple)):
>return base, ','.join("[value='%s']" % (v) for v in cond.second)


Is there some reason to convert a set to a list first?  Perhaps it is a 
performance related issue?


-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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] Easy to Understand SQLFORM.grid Custom Search

[Vinicius Assef]

Nice. :-)

On Fri, Jul 11, 2014 at 12:33 PM, JoeCodeswell  wrote:
> Dear viniciusban,
>
> Thanks for the comment.
>
> You also said, "How about updating the web2pyslices version, too? ;-) ".
>
> DONE!  :)
>
> Thanks again, viniciusban.
> Love and peace,
> Joe
>
> On Thursday, July 10, 2014 12:10:27 PM UTC-7, viniciusban wrote:
>>
>> Really good.
>>
>> How about updating the web2pyslices version, too? ;-)
>>
>> On Thu, Jul 10, 2014 at 1:09 PM, JoeCodeswell  wrote:
>> > Dear web2py-users,
>> >
>> > I have written a recipe to customize the SQLFORM.grid search WITHOUT the
>> > need to specify a custom search_widget and so needing to read &
>> > understand
>> > the clever web2py implementation source code.
>> >
>> > The maintained link to the recipe is here on joecodeswell.wordpress.com.
>> > An
>> > older version is available on web2pyslices.com.
>> >
>> > Thanks for a GREAT framework and a GREAT community.
>> >
>> > Love and peace,
>> >
>> > Joe
>> >
>> > --
>> > Resources:
>> > - http://web2py.com
>> > - http://web2py.com/book (Documentation)
>> > - http://github.com/web2py/web2py (Source code)
>> > - https://code.google.com/p/web2py/issues/list (Report Issues)
>> > ---
>> > You received this message because you are 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.

Re: [web2py] Easy to Understand SQLFORM.grid Custom Search

[JoeCodeswell]

Dear peter,

Thanks for the reply. I have used your post 
in
 
the past. Reading it and reading the gluon code actually helped me get a 
grid Custom Search WITH a search_widget specified in the grid function 
arguments.

Thanks again, peter.

Love and peace,

Joe 

On Thursday, July 10, 2014 4:20:39 PM UTC-7, peter wrote:
>
> Thanks for this Joe, and it is an interesting approach. However I find the 
> approach I used
>
>
> https://groups.google.com/forum/#!searchin/web2py/sqlform.grid$20search/web2py/9_1ECdKHKUo/8OISg7o8OVIJ
>
> Somewhat easier to understand. Your approach is more novel however. 
>
> Peter
>

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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] Easy to Understand SQLFORM.grid Custom Search

[JoeCodeswell]

Dear viniciusban,







*Thanks for the comment. You also said, "How about updating the 
web2pyslices version, too? ;-) ".DONE!  :)*Thanks again, viniciusban.
Love and peace,
Joe 

On Thursday, July 10, 2014 12:10:27 PM UTC-7, viniciusban wrote:
>
> Really good. 
>
> How about updating the web2pyslices version, too? ;-) 
>
> On Thu, Jul 10, 2014 at 1:09 PM, JoeCodeswell  > wrote: 
> > Dear web2py-users, 
> > 
> > I have written a recipe to customize the SQLFORM.grid search WITHOUT the 
> > need to specify a custom search_widget and so needing to read & 
> understand 
> > the clever web2py implementation source code. 
> > 
> > The maintained link to the recipe is here on joecodeswell.wordpress.com. 
> An 
> > older version is available on web2pyslices.com. 
> > 
> > Thanks for a GREAT framework and a GREAT community. 
> > 
> > Love and peace, 
> > 
> > Joe 
> > 
> > -- 
> > Resources: 
> > - http://web2py.com 
> > - http://web2py.com/book (Documentation) 
> > - http://github.com/web2py/web2py (Source code) 
> > - https://code.google.com/p/web2py/issues/list (Report Issues) 
> > --- 
> > You received this message because you are subscribed to the Google 
> Groups 
> > "web2py-users" group. 
> > To unsubscribe from this group and stop receiving emails from it, send 
> an 
> > email to web2py+un...@googlegroups.com . 
> > For more options, visit https://groups.google.com/d/optout. 
>

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

[web2py] Re: Web2py menu.py question

[Leonel Câmara]

Hey Rahul,

You need something like:

response.menu = [
(T('Analysis'), False, URL(), [
   (T('Revisions'), False, URL('default, 
'index'), []),
   (T('Code Introspection'), False, 
URL('default, 'introspection'), []),
   ])
]

For brevity's sake I did a menu only with analysis, you can add the code 
section to that.

If you want menu items to become active you can do something like:
  (T('Revisions'), request.controller == 
'default' and request.function=='index', URL('default, 'index'), [])


Good luck with your project

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

[web2py] Web2py menu.py question

[Rahul]

Hi All,
I've been stuck up at a point with web2py menus -  Below is a 
part of code in my menu.py file. Now If I have the page structure like 
below and I *first *navigate to say page - Code Index [ codeindex()]. and 
from here I have dynamically added a list of a few code articles which 
generates a dynamic page called Articles.html where the url becomes 
"default/structures/articles" .  From this dynamically generated 
page/location if I navigate back to say menu 'Code Introspection', it does 
not take me there because the path becomes something like " 
default/structures/introspection/" where it should actually be 
"default/introspection" . How do I dynamically achieve this using menus ? 
What needs to be changed? I know from webpage links we can do this - 
"{{=URL('appname','default', 'introspection')}}" can we do a similar thing 
here? Please suggest.

Code: --- 

*menu.py*
response.menu = [
(T('Analysis'), False, URL(), [
   ['Revisions', False, 'index'],
   ['Code Introspection', False, 
'introspection']
   ]),


(T('Code'), False, URL(), [
 ['Code Index', False, 'codeindex'],
 ['My Structures', False, 'structures']
 ]),

*Sincerely, Rahul D.*

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the 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] float usage; 2 decimals

[Stefan van den Eertwegh]

Hi,

I have a float type in the define tables and when he inserts 3.50 into the 
database he makes 4.0 off it.
How comes that it rounds off the float? And not uses the usage of 2 
decimals?

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.