[web2py] Re: membership form with default input values

Before form= db.auth_membership.group_id.default=some_group_id Kind regards, Annet i created a membership form using > form = crud.create(db.auth_membership) > > this gives me a form with two select fields. how do i create the form to > have for instance the 3rd option automatically selected

[web2py] Re: DAL does not return correct id when inserting a record where the id is specified

The DAL does this to get the id for MySQL inserts: self.execute('select last_insert_id();') Unfortunately, the value of last_insert_id() is only updated when the id is auto-generated, so it stores the last auto-generated id (which you observed), not the last id. In order to get the last id (wh

[web2py] membership form with default input values

i created a membership form using form = crud.create(db.auth_membership) this gives me a form with two select fields. how do i create the form to have for instance the 3rd option automatically selected? -- --- You received this message because you are subscribed to the Google Groups "web2py-

[web2py] Re: DAL does not return correct id when inserting a record where the id is specified

I'm porting a legacy table to a new table having a different schema. The old table had a field (order_number) that was unique and autoincrementing but not the primary key. I want to use those old values as the primary key in the new table. -- --- You received this message because you are sub

[web2py] Re: DAL does not return correct id when inserting a record where the id is specified

Why are you specifying the ids? On Tuesday, August 6, 2013 10:27:03 PM UTC-4, Jim Gregory wrote: > > I noticed an odd behavior when inserting a record in a MySQL table. Given > a table: > > db.define_table('person', Field('name')) > > inserting some records without specifying the id returns the

[web2py] DAL does not return correct id when inserting a record where the id is specified

I noticed an odd behavior when inserting a record in a MySQL table. Given a table: db.define_table('person', Field('name')) inserting some records without specifying the id returns the correct id: >>> db.person.insert(name='John') 1 >>> db.person.insert(name='Bill') 2 But specifying the id whe

[web2py] Values in request.vars persist/doubled when form submitted after unexpected logout/session deletion

I have a controller function which is protected by a standard authentication decorator ("@auth.requires_login()"). The function presents a page containing some forms (which contain a bunch of INPUTS() of _type = 'hidden' and one INPUT(_type = 'image', which presents the submission button). If

[web2py] Re: read a field from a row based on a (wait for it...) variable

,.-'"...``~., .,.-"..."-., .,/...":, .,?..

[web2py] Re: URL filter chain

Model files are executed on every request before the controller action is called, so you could simply put your code in a model file (note, most of the code could actually go in a module, which you could then simply import in a model). Models are executed in alphabetical order, so if you want you

[web2py] Re: web2py hanging after DB error - Windows / rocket / pyodbc / SQL Server

We have the same (similar) issue using mssql on Windows: when we get a pyodbc.ProgrammingError typically relating to a foreign key, we have to restart web2py. This is particularly frustrating problem as these errors happen every time you rename/delete a column with a foreign key. E.g. creat

Re: [web2py] Re: URL filter chain

See this old thread: https://groups.google.com/forum/#!topic/web2py/vW4ygi96LLU It may help you. On Tue, Aug 6, 2013 at 9:24 PM, Marcio Andrey Oliveira wrote: > So I don't know what to do. I was reading about the conditional models but > it doesn't seem to be what I want. > > I will try to expla

[web2py] Re: URL filter chain

So I don't know what to do. I was reading about the conditional models but it doesn't seem to be what I want. I will try to explain (forgive my bad English): >From my own application I want to be able to intercept requests to some / all URLs (it varies based on what I want to do) so that I coul

[web2py] Re: Good Basic Tutorial: "Twitter Clone in web2py" - source on github.

graet !! I learned from this book web2py link El martes, 6 de agosto de 2013 10:05:43 UTC-5, Rob_McC es

[web2py] Re: exercise: automatic conversion of a static site into a web2py site

I just pushed a new version: https://github.com/web2py/web2py/blob/master/scripts/import_static.py Massimo On Tuesday, 6 August 2013 16:51:31 UTC-5, tim spear wrote: > > Hi Massimo, > > Thanks for the reply. > I'm a bit new to this but I looked in > https://github.com/web2py/web2py/tree/maste

[web2py] Re: onbeforeunload & SQLFORM(db.table) submit

solved this with the following code as you suggested: populate() fills some data in according tables and does also del session.tmpstation i've added a timeout also, user can refresh or reopen the url from a faulty action such as closing page etc def confirm(): TIMEOUT=60*2 if session.tm

[web2py] Re: Security advisory: BREACH and Django

On second thought, if SQLFORM(..., detect_record_change=True), the _formkey token is a hash of the record fields rather than a random UUID, so it would remain the same from request to request, thus enabling the exploit. Perhaps we should add a random string to the record hash in that case. On T

[web2py] Re: exercise: automatic conversion of a static site into a web2py site

Hi Massimo, Thanks for the reply. I'm a bit new to this but I looked in https://github.com/web2py/web2py/tree/master/scripts and in https://code.google.com/p/web2py/ and could not find scripts/import_static.py Not sure I looked in the right place? Ta, Tim On Tuesday, August 6, 2013 6:38:0

[web2py] Re: Generated password changes between functions

Can you attach a minimal app that reproduces the problem (preferably in the current stable version of web2py)? As an aside, instead of using your reverse() function, to reverse a string, you can do mystring[::-1]. Anthony On Tuesday, August 6, 2013 4:08:26 PM UTC-4, Annet wrote: > > The think

[web2py] Re: Generated password changes between functions

No matter what I try I keep ending up with two different passwords. The strange thing is that when I replace this: password=generate_password(name,now) with this: password='6#TestValue' The function works, '6#TestValue' is both inserted into the auth_user table's password field and sent to th

[web2py] Re: prevent web2py regenerating tables in any situation

nope. In no possible way web2py drops the tables from the db. NB: you MUST have tables defined if you want to access them with DAL, but this doesn't mean they are dropped in the backend. If you remove a table definition from your code, it just means that web2py won't know that that table exists.

Re: [web2py] Re: prevent web2py regenerating tables in any situation

It is not deleted. You can't see it in /appadmin because you removed define_table call. Marin On Tue, Aug 6, 2013 at 9:38 PM, Behnam Izadi wrote: > tanks but I want to delete table definiton on db.py without physical table > deletion on hard disk. when I remove a "db.define" statement , the >

[web2py] Re: prevent web2py regenerating tables in any situation

tanks but I want to delete table definiton on db.py without physical table deletion on hard disk. when I remove a "db.define" statement , the correspondent table will be deleted. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubsc

[web2py] Re: Security advisory: BREACH and Django

> I know that there are security experts/security "fans" watching over > web2py's code, so I'll leave this topic to them for further analysis, but > as Anthony suggested it seems that web2py is fine. Django and Rails use a > somewhat "static" token, while web2py generates a new one for every f

[web2py] Re: onbeforeunload & SQLFORM(db.table) submit

you need to hook up to the submit event of the form and disabling what you added as onbeforeunload. Lots of examples around, e.g. http://stackoverflow.com/questions/1973708/how-to-prevent-onbeforeunload-from-being-called-when-clicking-submit-button On Tuesday, August 6, 2013 8:54:15 PM UTC+2, A

[web2py] Re: prevent web2py regenerating tables in any situation

either setting migrate=False in all tables or setting migrate_enabled=False http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=migrate_enabled However, loosing all the data is not something that happens unless you drop the table: web2py at most just alters the ta

[web2py] Re: Is there any way to work with static files outside web2py directory?

1) web2py is portable, so if this problem originates by lack of space in the c: drive, move web2py under d: and your photos to the static folder 2) routes.py can just manage the "realm" of web2py. Having web2py not able by default to suffer from directory traversal attacks (i.e. getting access b

[web2py] onbeforeunload & SQLFORM(db.table) submit

def add(): form = SQLFORM.factory(Field('url', 'string')) if form.process().accepted: mystation = info.station(form.vars.url) session.tmpstation = mystation redirect(URL('confirm')) return dict(form=form) def confirm(): ... prepopulating form with vars fro

[web2py] Re: Security advisory: BREACH and Django

well, from what I read it seems that they somehow manage to inspect the content-length of the compressed output given that: - somehow are able to inject a simil-token - the compression algo is know in advance hence the estimation of the content-length would give them the right token, because if t

Re: [web2py] Re: Demistifying web2py

> That's like saying 'Shaolin Kung Fu' is only for physical fitness, not for > fighting. LOL, I'm thinking on adding the quote! -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from

[web2py] prevent web2py regenerating tables in any situation

I don't want web2py regenerate or alter my tables any way. I lost my data 3 times because of this. how can I prevent it? -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, sen

Re: [web2py] web2py admin access

You need to set a parameters_PORT.py file that contains a password for admin... Because admin is disabled for security in production. Try this from web2py folder in bash on your prod server : sudo -u www-data python -c "from gluon.main import save_password; save_password('123456',443)" # 123456 =

Re: [web2py] Re: Demistifying web2py

That's like saying 'Shaolin Kung Fu' is only for physical fitness, not for fighting. Technically, it started as a fitness regimen for monks, but it is also good for fighting. On Tuesday, August 6, 2013 3:00:11 AM UTC-7, Massimo Di Pierro wrote: > > Saying "it is only a teaching tool" without e

[web2py] Re: Security advisory: BREACH and Django

One recommendation is to randomize the "secret" per request (the attack works by guessing the secret one character at a time). web2py already randomizes its CSRF tokens on every request (which I take it Django does not do), so not sure web2py has the same vulnerability with regard to the CSRF t

[web2py] Re: IS web2py good for largescale

Hi Joe et al, My first step.. I would use a tool like https://errormator.com/ now, to determine what the real issues are. You might be surprised or not. Then if a migration to web2py is warranted I would use the same tool during development to optimize the application and keep metrics as the us

[web2py] web2py admin access

hello, i setup web2py following the commands using one step production for wget http://web2py.googlecode.com/hg/scripts/setup-web2py-ubuntu.sh running this on raspbian. i'm unable to get admin access to work from the machine that its on. after a couple days of searching i'm no where closer to

[web2py] Re: Security advisory: BREACH and Django

As I understand this has nothing to do with Django. They discovered a ssh vulnerability that can used to decrypt part of traffic. It will affect all of us if un patched. On Tuesday, 6 August 2013 10:55:06 UTC-5, Chun-Hung Chen wrote: > > Hi, > > FYI > https://www.djangoproject.com/weblog/2013/au

Re: [web2py] Re: Demistifying web2py

El martes, 6 de agosto de 2013 11:20:01 UTC-3, Relsi Hur Maron escribió: > > > Cool, all is better inside the context. > I just made a search and saw this www.slideshare.net/rochacbruno/desmistificando-web2py-tdc2011 (it's been for a while) and I think there's lot of that presentation I can use.

[web2py] Re: exercise: automatic conversion of a static site into a web2py site

Try this: scripts/import_static.py I just committed it to trunk. Usage: python scripts/import_static.py source_folder applications/web2py_app On Tuesday, 6 August 2013 08:05:24 UTC-5, tim spear wrote: > > Hi Massimo, if you are still reading this stuff. > > I've been playing with web2py and w

Re: [web2py] no driver available ('sqlite2', 'sqlite3')

Thank you, I'll try it again... 2013/8/6 Niphlod > tested also on ubuntu server 13.04 64 bit: no issues at all. > once logged in in the freshly-installed server, all I had to do was: > > wget > https://raw.github.com/web2py/web2py/master/scripts/setup-web2py-nginx-uwsgi-ubuntu.sh > sudo bash se

Re: [web2py] Upload a file without a form

Hello Eduardo, You can use db.table.insert(...) or db.table.field.store(...). Details: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#More-on-uploads Marin On Tue, Aug 6, 2013 at 5:01 PM, Eduardo Cruz wrote: > I need to upload a file that I will create on th

[web2py] Re: URL filter chain

yes On Tuesday, 6 August 2013 07:14:34 UTC-5, Anthony wrote: > > > > On Tuesday, August 6, 2013 3:13:48 AM UTC-4, Massimo Di Pierro wrote: >> >> The wsgi middleware is really not the web2py way of doing this. It is a >> compatibility mode of allowing third party middleware of interoperating >>

[web2py] Security advisory: BREACH and Django

Hi, FYI https://www.djangoproject.com/weblog/2013/aug/06/breach-and-django/ -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroup

[web2py] contrib IS_NOT_EMAIL()

Here IS_NOT_EMAIL() validator : class IS_NOT_EMAIL: def __init__(self, error_message='You can\'t use email as username'): self.e = error_message def __call__(self, value): if not IS_EMAIL()(value)[1]: return (value, self.e) return (value, None) Enjoy H

Re: [web2py] Re: username and email login (auth)

Create a IS_NOT_EMAIL() validator : class IS_NOT_EMAIL: def __init__(self, error_message='You can\'t use email as username'): self.e = error_message def __call__(self, value): if not IS_EMAIL()(value)[1]: return (value, self.e) return (value, None) Base

[web2py] Good Basic Tutorial: "Twitter Clone in web2py" - source on github.

I found a good tutorial today on web2py, there are 3 parts, source on github. https://github.com/neilisfragile/witter Nice to see more and more learning resources for web2py. I seem to learn best from examples. Twitter Clone Tutorial in web2py 30 June, 2013 Link: http://fragile.org.uk/2013

[web2py] Upload a file without a form

I need to upload a file that I will create on the fly, is there a way to do that without using a form? -- --- You received this message because you 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

Re: [web2py] Re: Is it possible to know what view was rendered?

I'll elaborate a bit more. I'll be back soon. ;-) On Tue, Aug 6, 2013 at 11:06 AM, Anthony wrote: > Not sure I understand. If you have multiple possible views that could be > rendered for a given action, don't you have to explicitly set the value of > response.view in your app code? The view that

[web2py] Re: Generated password changes between functions

> > In this line of code: >> >> >> form[0].insert(10,DIV(LABEL(H5(password),_class="control-label"),_class="control-group")) >> > > What do you mean? In your example run above, password appears to have the > correct value both before and after that line. Are you saying the label > shown in the

[web2py] Re: How to specify which table to edit during join?

https://groups.google.com/d/msg/web2py/Yl-6-oYA9C4/EkmwLNz3IegJ Should be the first table mentioned in the query, but there is a feature request to make that customizable. Anthony On Tuesday, August 6, 2013 7:18:13 AM UTC-4, Alex Glaros wrote: > > Using a grid with a join, I'd like to have user

[web2py] Re: Generated password changes between functions

> In this line of code: > > > form[0].insert(10,DIV(LABEL(H5(password),_class="control-label"),_class="control-group")) > What do you mean? In your example run above, password appears to have the correct value both before and after that line. Are you saying the label shown in the HTML is the w

Re: [web2py] Re: Demistifying web2py

I think we should not listen to criticism, but not refute them in the mouth, but with codes. And this is what they are worried about web2py is picking up and growing in the web development community. Let's Work! Ovidio Marinho Falcao Neto ITJP.NET.BR ovid

Re: [web2py] Re: Demistifying web2py

Cool, all is better inside the context. =) Em terça-feira, 6 de agosto de 2013 09h47min06s UTC-3, Alan Etkin escreveu: > > > I think he is making a joke. Nobody says that but some dishonest people > form the > > competition. > > Yeah, some of the statements I called criticism are very ridicu

Re: [web2py] Re: Is it possible to know what view was rendered?

Not sure I understand. If you have multiple possible views that could be rendered for a given action, don't you have to explicitly set the value of response.view in your app code? The view that gets rendered is either the view in response.view or it is the generic view (unless of course your cod

[web2py] Is there any way to work with static files outside web2py directory?

Hello I have installed web2py on disk C: but I also have many many static images located on disk D: Of course there easiest way just to move all images files from disk D: to static folder of web2py. But I don't want to do this way. I tried to use routes.py files but it doesn't work for me. May

Re: [web2py] no driver available ('sqlite2', 'sqlite3')

tested also on ubuntu server 13.04 64 bit: no issues at all. once logged in in the freshly-installed server, all I had to do was: wget https://raw.github.com/web2py/web2py/master/scripts/setup-web2py-nginx-uwsgi-ubuntu.sh sudo bash setup-web2py-nginx-uwsgi-ubuntu.sh then right at the end of the

Re: [web2py] Re: Demistifying web2py

2013/8/6 Anthony : >> web2py has too much magic > > > A couple of nice quotes from Zed Shaw: > https://twitter.com/zedshaw/status/80415443558477825 > https://twitter.com/zedshaw/status/80418794526351360 Zed Shaw quotes might be slightly unpleasant to some, but we cannot say he doesn't go to poin

Re: [web2py] Re: Is it possible to know what view was rendered?

Yes, but there's a more complex scenario. Let's say I have a list page, where I can 2 views: one to show when db is emtpy and other to show when db is populated. Other scenario is to test a logged_in action. If I don't have a logged in user, another page must exist. In all these cases above all v

[web2py] Re: How to make a search form

assuming your controller receives some request.vars.search that contains the term to search for, it's actually pretty easy term = request.vars.search tb = db.yourtable look_into = [fixed list of fields] #or something like look_into = [field for field in tb.fields if tb[field].readable and tb[

[web2py] Re: Is it possible to know what view was rendered?

I think you would have to manually check with the response.view file (or the compiled version) is present (if not, assume the generic view was used). Anthony On Tuesday, August 6, 2013 7:58:21 AM UTC-4, viniciusban wrote: > > I'm working on tests in apps, again. > > To test a controller, we usu

[web2py] Re: exercise: automatic conversion of a static site into a web2py site

Hi Massimo, if you are still reading this stuff. I've been playing with web2py and was thinking it was missing an easy way to import static sites and was thinking of writing one similar to your proposed challenge. Do you know if anyone did produce a functional solution? I see this thread is f

[web2py] Re: Demistifying web2py

> > web2py *has too much magic* A couple of nice quotes from Zed Shaw: https://twitter.com/zedshaw/status/80415443558477825 https://twitter.com/zedshaw/status/80418794526351360 -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsu

[web2py] Re: Generated password changes between functions

Hi Anthony, I am completely puzzled as to what happens, I added a warning variable to the function, to which I write the value of password throughout the code: password=generate_password(name,now) warning=' no form: ' + password form=SQLFORM.factory(db.auth_user,ignore_rw=True,submit_button='Re

Re: [web2py] Re: Demistifying web2py

> I think he is making a joke. Nobody says that but some dishonest people form > the > competition. Yeah, some of the statements I called criticism are very ridiculous and I would like to mention them because they are funny. However I think that users who do not know web2py except for what is sai

Re: [web2py] Is it possible to know what view was rendered?

If response.view not been completed and finalized, there is no session, so it was not used. Ovidio Marinho Falcao Neto ITJP.NET.BR ovidio...@gmail.com 83 8826 9088 - Oi 83 9336 3782 - Claro Brasil

[web2py] How to make a search form

making a search form using crud is quite simple with the crud.search(db.table) function. but that returns a search field for all the fields in the table. how do i make one search field (a 'search bar') that searches all the fields using the select option 'contains' or any of the given options w

[web2py] Re: How to find and change registration process

Specifically, form=auth() calls the __call__ method of the Auth class, which then reads request.args(0) to figure out which Auth action has been requested and calls the appropriate Auth method to generate and process the form. In this case, it would call auth.register(). If you create your own

[web2py] Re: URL filter chain

On Tuesday, August 6, 2013 3:13:48 AM UTC-4, Massimo Di Pierro wrote: > > The wsgi middleware is really not the web2py way of doing this. It is a > compatibility mode of allowing third party middleware of interoperating > with web2py. It has only been tested in simple cases. It was recently >

[web2py] Re: Generated password changes between functions

> > userID=db.auth_user.insert(**db.auth_user._filter_fields( > form.vars)) > db.auth_membership.insert(user_id=userID,group_id=PROFILEGROUPID) > > db.auth_membership.insert(user_id=userID,group_id=ACCOUNTGROUPID) > > db.auth_memb

[web2py] Re: Nice change to admin interface for editing files, what about static files?

I just discovered, it wasn't obvious to me, that the headings will *COLLAPSE * the file list. I also like to Cmd- Click on a file to open in a NEW tab in my Browser. Collapse Feature Example: While editing a file, like db.py, the menu is: models db.py menu.py controllers

[web2py] Re: How to find and change registration process

just change the url of the registration in the menu to point to your own controller or hack in in the default/user function def user(): if request.args(0) == 'register': your own code, returning. form = whatever . return dict(form=auth()) On Tue

Re: [web2py] no driver available ('sqlite2', 'sqlite3')

the "modern" script was tested with 12.04 and 12.10. I'm downloading the 13.04 to see if there is any adjustments to make. -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, s

[web2py] Is it possible to know what view was rendered?

I'm working on tests in apps, again. To test a controller, we usually check if some view was used, but when response.view doesn't exist, generic. is used and response.view is not updated accordingly. In this situation, how may know which view was really rendered? -- --- You received this mess

[web2py] How to specify which table to edit during join?

Using a grid with a join, I'd like to have user edit only records they created. How do you let grid know which table you want to edit when there are multiple tables in the join? Error received is: 'Row' object has no attribute 'created_by' If you can, please type the answer using example belo

[web2py] Re: Generated password changes between functions

Massimo, Thanks fro your reply. strange. when you say python 2.6.4 do you mean the problem is only present > with this version or that you have only tested it with this version of > python? > I meant web2py version 2.4.6, which I am running at the moment. I coded the function a while ago, in

[web2py] Re: Generated password changes between functions

strange. when you say python 2.6.4 do you mean the problem is only present with this version or that you have only tested it with this version of python? On Tuesday, 6 August 2013 04:46:12 UTC-5, Annet wrote: > > In my application I have a custom registration function. The function > processes

Re: [web2py] Re: Demistifying web2py

Saying "it is only a teaching tool" without explaining why seems to imply that we, the developers, are saying so. Well, we are not saying that. We never did. One thing is saying that web2py was originally created as a teaching tool (true) another is to dismiss web2py as only a teaching tool (fa

[web2py] Generated password changes between functions

In my application I have a custom registration function. The function processes registration forms and sends the user an email with his username and password, this worked well in previous versions of web2py, however, in version 2.4.6 the generated password changes between inserting a record into

Re: [web2py] Re: Demistifying web2py

I think i have a dishonest friend 2013/8/6 Massimo Di Pierro > I think he is making a joke. Nobody says that but some dishonest people > form the competition. > > Massimo > > > On Tuesday, 6 August 2013 01:37:39 UTC-5, Relsi Hur Maron wrote: >> >> >> web2py is* just* for learning? why? >> >

Re: [web2py] Re: How to create a hyperlink from a display field in sqlForm?

if you use Massimo's suggested code: db.TaxonomyDetail.objectID.represent = lambda id, record:A(record.objectID, _target = "_blank", _href = URL('manage_object_super_type',id)) Then in ' manage_object_super_type' do something like this: def manage_object_super_type(): ## data = crud.rea

[web2py] Re: Demistifying web2py

I think he is making a joke. Nobody says that but some dishonest people form the competition. Massimo On Tuesday, 6 August 2013 01:37:39 UTC-5, Relsi Hur Maron wrote: > > > web2py is* just* for learning? why? > > > Em segunda-feira, 5 de agosto de 2013 16h58min05s UTC-3, Alan Etkin > escreveu:

[web2py] Re: URL filter chain

The wsgi middleware is really not the web2py way of doing this. It is a compatibility mode of allowing third party middleware of interoperating with web2py. It has only been tested in simple cases. It was recently rewritten (untested) nobody uses it, and I am considering dropping the feature.