[web2py] Import CSV in appadmin to update database

2012-07-17 Thread Mark Li
Is there a way I can add an import excel (saved as csv) option in the appadmin that can update multiple data tables (one of them an intermediate/relational table)? for example the excel file (saved as csv): *ID | title |category|* 1 | one |

[web2py] Import CSV in appadmin to update database

2012-07-17 Thread Mark Li
I would like to know how I would add an import csv (from excel) option to appadmin that would update multiple database tables (one of them a relational/intermediate table). For example, the CSV file would look like this (in excel) ID | posttitle |category

[web2py] Re: Import CSV in appadmin to update database

2012-07-17 Thread Mark Li
I am also unable to import a CSV file using the list:reference format (exporting then importing with no changes still doesn't work). I get the error message : Unable to parse CSV file 'nonetype'object has no attribute '__getitem__' On Tuesday, July 17, 2012

[web2py] Unit Testing Database Best Practices

2012-07-23 Thread Mark Li
I'm fairly new to test-driven development and have decided it is the best way to go for my new webapp. While functional tests with selenium seem to be more straightforward (as far as what the tests want to accomplish), I'm lost on what unit tests for the database should test for. For example, i

Re: [web2py] Unit Testing Database Best Practices

2012-07-23 Thread Mark Li
ns. > > Cheers! > > Richard > > > On Sun, Jul 22, 2012 at 9:41 PM, Mark Li wrote: > >> I'm fairly new to test-driven development and have decided it is the best >> way to go for my new webapp. While functional tests with selenium seem to >> be mor

[web2py] Empty Database value is not None, but an empty string

2012-07-23 Thread Mark Li
I have a table defined in the following manner: db.define_table('songinfo', Field('songtitle'), Field('artist')) When I add an empty entry, or upload a CSV with empty values, I can only access those values with a database call like songs = db(db.songinfo.artist=="").select() as opposed to db(d

[web2py] Re: Empty Database value is not None, but an empty string

2012-07-23 Thread Mark Li
t that a default value >> of None will be inserted. >> >> Anthony >> >> On Monday, July 23, 2012 5:02:33 PM UTC-4, Mark Li wrote: >>> >>> I have a table defined in the following manner: >>> >>> db.define_table('songinfo', &

Re: [web2py] Re: Empty Database value is not None, but an empty string

2012-07-23 Thread Mark Li
C-7, viniciusban wrote: > > As far as I know, let "notnull=False" and "required=False" for your > fields and don't set "default" property. > > > > On 07/23/2012 06:32 PM, Mark Li wrote: > > Unfortunately the lambda method didn't w

[web2py] Select Distinct for more than 1 distinct value

2012-07-23 Thread Mark Li
I have a database setup with id and 'dogname.' I would like to retrieve distinct values of dogname, but allow for 2 of each dogname. So instead of limiting it to one distinct value, there could be 2 identical dognames that are retrieved, but no more than that. Is there a way to set this kind of

[web2py] Re: Select Distinct for more than 1 distinct value

2012-07-23 Thread Mark Li
> I would say that the main question is how much data you have. I mean, it > is probably easier to grab all the data and then discard (or simply loop > over) the data you do not need. However, if you have a huge number of > records that may not be practical. > > > On Monda

Re: [web2py] Unit Testing Database Best Practices

2012-07-23 Thread Mark Li
default/show/260 >> > > that guide is too old, have execfile() :S. Search in the group on how to > use modules in your app. > > 2012/7/22 Mark Li > >> I'm fairly new to test-driven development and have decided it is the best >> way to go for my new webapp.

Re: [web2py] Re: Empty Database value is not None, but an empty string

2012-07-24 Thread Mark Li
table.validate_and_insert() or simply mytable.insert()? > > Do you get same results (blank values) inserting it from web2py shell > using simply mytable.insert()? > > -- > Vinicius Assef > > > > On Monday, July 23, 2012 5:58:19 PM UTC-4, Mark Li wrote: > >

Re: [web2py] Re: Empty Database value is not None, but an empty string

2012-07-25 Thread Mark Li
928, ininsert raise e OperationalError: near ")": syntax error The 'example.csv' file is located in my web2py folder. On Wednesday, July 25, 2012 6:23:56 AM UTC-7, Anthony wrote: > > Can you attach a sample CSV file that fails, and show your table model > co

Re: [web2py] Re: Empty Database value is not None, but an empty string

2012-07-25 Thread Mark Li
ord2,text,text > 3,record3,text, > > > I tested with trunk. Can you try the same example from the shell, as I did? > > On Wednesday, 25 July 2012 16:27:44 UTC-5, Mark Li wrote: >> >> I'm using SQLite3 on Windows (running from source). I didn't install >

Re: [web2py] Re: Import CSV in appadmin to update database

2012-07-25 Thread Mark Li
look something like this: db.define_table('table1', Field('title'), Field('age'), Field('uuid')) On Wednesday, July 18, 2012 3:35:22 AM UTC-7, Johann Spies wrote: > > On 18 July 2012 03:41, Mark Li wrote: > >> I am also unable to import

[web2py] import_from_csv_file with validation

2012-07-26 Thread Mark Li
Is there something like validate_and_insert() for import_from_csv_file()? I would like to update my database with csv files, but have the form validators fired to ensure that the data inserted is of the correct type. --

[web2py] Accessing static file with consecutive hypens in filename.

2012-07-26 Thread Mark Li
I have a static file named person---dog-3.jpg When I try to access the file through http://127.0.0.1:8000/myapp/static/pets/person---dog-3.jpg I get an "invalid request" error. However, if I rename the file to person-dog-3.jpg, it works fine. I have a very large number of files named this way

[web2py] Using UUID in a many to many database

2012-07-27 Thread Mark Li
I currently have 3 data tables setup, one is an intermediate table linking a many to many relationship. I would like to use UUID as the reference ID, so I insert the uuid into the intermediate table instead of the normal ID. However this doesn't work as expected, all the fields in the relational

[web2py] Invalid File Format when importing from CSV to db

2012-07-28 Thread Mark Li
I used db.export_to_csv_file(open('somefile.csv', 'wb')) to export my database, but when I try to import it with db.import_from_csv_file(open('somefile.csv', 'rb')) I get the following error Traceback (most recent call last): File "", line 1, in File "C:\users\mark\documents\dubliners\we

[web2py] Re: Using UUID in a many to many database

2012-07-28 Thread Mark Li
Thanks for the tip Anthony On Saturday, July 28, 2012 12:28:15 PM UTC-7, Anthony wrote: > > db.define_table('people', >> Field('uuid', length=64, default=uuid.uuid4() >> > > Note, you may not want to set default=uuid.uuid4() -- that will set the > default to a single fixed uuid value for the enti

[web2py] Re: Invalid File Format when importing from CSV to db

2012-07-28 Thread Mark Li
I found my problem. Turns out saving a CSV file in excel will add trailing commas for empty cells, so after "END" in the original CSV file, there would be "" for each empty cell (based on the number of column fields). On Saturday, July 28, 2012 12:23:20 PM UTC-7, Mark

[web2py] Re: Unit test and request object

2012-08-06 Thread Mark Li
Was having trouble with this too, thanks for find this! On Friday, April 8, 2011 7:03:21 AM UTC-7, Jérémie wrote: > > Some more points. > > I finally succeeded to reset request thanks to matclab's comments and > code on the slice (http://www.web2pyslices.com/main/slices/take_slice/ > 67) : > >

[web2py] Option to visit Non-mobile site with @mobilize

2012-08-25 Thread Mark Li
I would like to add the option to visit the regular version of the site on the mobile-view. However, from my understanding of @mobilize, it automatically redirects to the mobile version of the page if a mobile device is detected. Is there a way to override this behavior if a visitor on a mobile

[web2py] Re: Option to visit Non-mobile site with @mobilize

2012-08-26 Thread Mark Li
#x27;.'.join(items) > > You could add that logic yourself to a model file, but make it conditional > so it isn't executed if the user has selected the desktop version (that > choice can be stored in the session). > > Anthony > > On Saturday, August 25, 2012 8:04:

[web2py] Setting request.vars without URL args

2012-08-26 Thread Mark Li
I want a link that will redirect users to the desktop view of my page (from the mobile view), where I will store a session variable to remember that the user wants to stay in desktop view. However, I would rather not use URL args because I don't want the args, like '?mobile=false', attached to

[web2py] Using request.user_agent to check if Android device

2012-08-30 Thread Mark Li
I would like to use request.user_agent to check if a device is an Android. I'm currently using is_mobile() to check and load the mobile view, but I would like to break it down one more step and add some code only for Android devices. Is there any way to go about this? And would this be more ef

[web2py] Best Method to implement a "like" button

2012-09-10 Thread Mark Li
I have 3 datatables as follows: db.define_table('songs', Field('songname'), format='%(songname)s') db.define_table('likes', Field('username', 'reference auth_user'), Field('songname', 'reference songs')) with the 3rd table being db.auth_user I would like to implement a "like" b

[web2py] Re: Best Method to implement a "like" button

2012-09-11 Thread Mark Li
n. The whole process seems somewhat sluggish, are there any unnecessary database calls I'm making? On Tuesday, September 11, 2012 4:53:44 AM UTC-7, villas wrote: > > How about: in 'likes' make a unique composite index of both fields > (created at DB level). Try to insert a

[web2py] Plain Text and HTML Email with auth.messages.verify_email

2012-09-14 Thread Mark Li
Is it possible to send both Plain Text and HTML Emails with auth.messages.verify_email? From the book, it seems auth.messages.verify_email only accepts a single string. --

[web2py] Re: Plain Text and HTML Email with auth.messages.verify_email

2012-09-14 Thread Mark Li
27;html body')) On Friday, September 14, 2012 2:25:04 PM UTC-7, Massimo Di Pierro wrote: > > If the email text looks like '' it should be send as html. > > On Friday, 14 September 2012 12:12:21 UTC-5, Mark Li wrote: >> >> Is it possible to send both Pl

[web2py] Resend email_verify like request_reset_password

2012-09-14 Thread Mark Li
I would like to know how I should go about adding a 'resend_email_verify' action to utilize the 'request_reset_password' action, but instead of sending a link to the reset_password view, it simply resends auth.message.verify_email . --

[web2py] Changing auth validator error messages

2012-09-16 Thread Mark Li
Is it possible to change the validator error messages in for auth fields like "value already in database or empty," without having to redefine all the validators for that field? For example, I wanted to change the validator error message for IS_NOT_IN_DB for auth_user.email, and I wrote: db.aut

[web2py] Re: Changing auth validator error messages

2012-09-17 Thread Mark Li
ist' object has no attribute 'error_message' On Sunday, September 16, 2012 7:37:52 PM UTC-7, Massimo Di Pierro wrote: > > I think you can do: > > db.auth_user.email.requires.error_message = T() > > Unless they have more then one validator. > > On S

[web2py] Specify sender name in auth.settings.mailer

2012-09-17 Thread Mark Li
I am using 'mycomp...@gmail.com' as my email address for auth.settings.mailer.settings.sender and the sender name shows up as 'mycompany' in the received email. However, I would like to edit the sender name so it is different from 'mycompany'. Is there any way to accomplish this using the maile

[web2py] Re: Specify sender name in auth.settings.mailer

2012-09-17 Thread Mark Li
Yep here it is: http://code.google.com/p/web2py/issues/detail?id=1017 On Monday, September 17, 2012 12:05:40 PM UTC-7, Massimo Di Pierro wrote: > > Looks like there is not but there should be. Can you please open a ticket > about this? > > On Monday, 17 September 2012 12:57:10

[web2py] Re: Changing auth validator error messages

2012-09-17 Thread Mark Li
-7, Massimo Di Pierro wrote: >>> >>> I think you can do: >>> >>> db.auth_user.email.requires.error_message = T() >>> >>> Unless they have more then one validator. >>> >>> On Sunday, 16 September 2012 21:21:00 UTC-5, Ma

Re: [web2py] Re: Best Method to implement a "like" button

2012-09-18 Thread Mark Li
Thanks for the response guys! I'm going with rochabruno's method as it is the most straightfoward, I hadn't really looked into the compute capabilities. On Tuesday, September 11, 2012 3:55:21 PM UTC-7, rochacbruno wrote: > > The computation should be > > compute= lambda row: "%(username)s-%(song

[web2py] Httponly for cookies/sessions

2013-01-14 Thread Mark Li
I haven't found anything in the web2py documentation about setting the httponly attribute for cookies and sessions. For sessions, there is session.secure() to set the session cookies to secure, is there a similiar method to setting the httponly option for session cookies? Also for regular coo

[web2py] Re: Httponly for cookies/sessions

2013-01-14 Thread Mark Li
On Monday, January 14, 2013 2:45:21 PM UTC-8, Mark Li wrote: > > I haven't found anything in the web2py documentation about setting the > httponly attribute for cookies and sessions. > > For sessions, there is session.secure() to set the session cookies to > secure, is

[web2py] Re: Httponly for cookies/sessions

2013-01-14 Thread Mark Li
Yep that did the trick, thanks Anthony! On Monday, January 14, 2013 2:45:21 PM UTC-8, Mark Li wrote: > > I haven't found anything in the web2py documentation about setting the > httponly attribute for cookies and sessions. > > For sessions, there is session.secure() to set th

[web2py] Register action using info from POST

2013-01-22 Thread Mark Li
I am currently using web2py's auth to return a registration form. However, I would also like users to be able to register RESTfully, with the email and password information in a POST call. How would I write a register action that mimics auth.register(), except the information is from a POST, no

[web2py] Re: Register action using info from POST

2013-01-23 Thread Mark Li
l and password fields in the request are empty. All other validators seem to be working fine. If anyone has previous experience with validate_and_insert with the auth_user table, and knows of any registration holes this way, please let me know! On Tuesday, January 22, 2013 6:50:06 PM UTC-8, Ma

[web2py] Re: Register action using info from POST

2013-01-29 Thread Mark Li
you can define an >> onaccept function that raises an HTTP >> exception<http://web2py.com/books/default/chapter/29/04#HTTP-and-redirect>in >> order to return a string: >> >> def register(): >> def success(form): >> raise HTTP(200, '

[web2py] DAL and MySQL indexing

2013-01-31 Thread Mark Li
Simple question. My web2py app just received a heavy amount of traffic, and I was looking for ways I could optimize performance. I am currently using MySQL, and using a database query like rows = db(db.tablename.category=="category_name").select() I am aware that web2py does not automatically cr

Re: [web2py] DAL and MySQL indexing

2013-01-31 Thread Mark Li
Awesome, thanks for that! On Thursday, January 31, 2013 4:43:24 PM UTC-8, rochacbruno wrote: > > Since you have the indexes created on DB backend, The DAL will use this > for any query on that table, because the output of .select() is in fact a > pure SQL statement. > > > -- --- You received

[web2py] Append to list:reference or list:string with update_record

2012-10-25 Thread Mark Li
Is it possible to append to a database list (like list:reference or list:string) with update_record, as opposed to explicitly stating the whole list for update_record? --

[web2py] Re: autodelete image computed field

2012-11-09 Thread Mark Li
Any success on getting the computed thumbnail image to autodelete? I'm having trouble with this too, where an update of a new thumbnail will not delete the old file. On Saturday, April 28, 2012 5:06:25 PM UTC-7, ctrlSoft wrote: > > > hi i have a resize function wich creates image thumbanils... >

[web2py] Updating profile does not update auth.user for computed field

2012-11-12 Thread Mark Li
I am currently using auth.profile() for a form where users can update their information. I have an 'upload' field for images, and a computed field that creates a thumbnail of the previous field. When the user hits 'save profile', auth.user is updated only for the original 'upload' field, not th

[web2py] Re: Updating profile does not update auth.user for computed field

2012-11-14 Thread Mark Li
sprint at PyCon Ar. > > On Monday, 12 November 2012 22:40:14 UTC-6, Mark Li wrote: >> >> I am currently using auth.profile() for a form where users can update >> their information. I have an 'upload' field for images, and a computed >> field that create

[web2py] Orderby does not work field type 'double', sorts as if floats were strings

2012-11-21 Thread Mark Li
I currently have a table with 'scores' as one of the fields, with the field type 'double'. When I go to fetch a row (ordered by scores) and print the scores, they come back sorted as if they were strings. I use the following: rows = db(db.song_table).select(orderby = db.song_table.scores) for

[web2py] Re: Orderby does not work field type 'double', sorts as if floats were strings

2012-11-22 Thread Mark Li
Yes this is on SQLite, is this a problem unique to SQLite? On Thursday, November 22, 2012 1:58:41 AM UTC-8, Niphlod wrote: > > is this on SQLite ? > > On Thursday, November 22, 2012 3:44:38 AM UTC+1, Mark Li wrote: >> >> I currently have a table with 'scores&#x

[web2py] Re: Orderby does not work field type 'double', sorts as if floats were strings

2012-11-22 Thread Mark Li
Ahh thanks Niphlod! On Thursday, November 22, 2012 2:49:28 PM UTC-8, Niphlod wrote: > > yep, support for decimal is kinda absent so it's treated "like a string". > > On Thursday, November 22, 2012 10:10:23 PM UTC+1, Mark Li wrote: >> >> Yes this is on SQL

[web2py] Re: Changing auth validator error messages

2012-11-28 Thread Mark Li
> the db.py file after the > auth.define_tables(username=False, signature=False) > > Thanks > > On Monday, September 17, 2012 3:21:00 AM UTC+1, Mark Li wrote: >> >> Is it possible to change the validator error messages in for auth fields >> like "value a

[web2py] Standalone DAL fetching old/obsolete data (mysql)

2012-11-28 Thread Mark Li
For some functional tests I'm running, I am fetching a row, clicking on a button, and then fetching the same row to see if the button action worked. I have the following to establish a database connection (using DAL outside of web2py environment): path_to_database = path.join(path.curdir, "datab

Re: [web2py] Standalone DAL fetching old/obsolete data (mysql)

2012-11-28 Thread Mark Li
m%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_18> > Click > here.<http://r1.wisestamp.com/r/landing?promo=18&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_18> >

[web2py] Returning a token for Android app authentication

2012-12-31 Thread Mark Li
I am currently trying to authenticate users on an Android app to my Web2py application. I am not comfortable implementing this on my own without some guidance/advice, as I'm worried about the security of the login information becoming jeopardized. I am following the guideline for authenticatio

[web2py] Re: Returning a token for Android app authentication

2013-01-01 Thread Mark Li
n Monday, 31 December 2012 21:28:04 UTC-6, dlypka wrote: >>>> >>>> I developed a solution for this. >>>> I posted it here: >>>> https://groups.google.com/forum/?fromgroups=#!topic/web2py/YVYQHRJmcos >>>> >>>> Happy New Year! >&

[web2py] Re: Returning a token for Android app authentication

2013-01-03 Thread Mark Li
gt; that is one less problem to solve, > You probably just have to mimic the HTTP messages that a browser would > send. > > On Tuesday, January 1, 2013 5:19:50 PM UTC-6, Mark Li wrote: >> >> Thanks for the responses, and Happy New Years to you guys too! >> >> dlypka, fo

[web2py] Re: Returning a token for Android app authentication

2013-01-04 Thread Mark Li
I'm still pretty new to this! On Thursday, January 3, 2013 7:57:45 PM UTC-8, dlypka wrote: > > But are you reconnecting to the same web2py session on each request? > > On Thursday, January 3, 2013 3:20:01 PM UTC-6, Mark Li wrote: >> >> I reviewed your code again and lo

[web2py] Re: Remember me with custom or alternate login?

2013-06-05 Thread Mark Li
Does anyone know why the session.auth.remember and session.auth.expiration are only saved after a new page load? Currently, I am making an ajax call that sets session.auth.remember and session.auth.expiration (after auth.login_bare()). If I close the browser after the ajax call without a new pa

[web2py] Re: Remember me with custom or alternate login?

2013-06-06 Thread Mark Li
Here's the relevant part of the code I'm using. I make an ajax call to the function below def ajax_login(): email = request.vars.email password = request.vars.password remember_me = request.vars.remember_me user = auth.login_bare(email, password) if user: if remember_

[web2py] Re: Remember me with custom or alternate login?

2013-06-06 Thread Mark Li
on_id_name]["expires"] = session.auth. > expiration > > That will happen the next time Auth is initialized (which would happen on > the next request), but it won't happen if you simply close the browser. > > Anthony > > On Thursday, June 6, 2013 5:33:37 PM UTC-4

[web2py] Inner join and left join in a many to many relationship

2013-07-17 Thread Mark Li
I have an intermediate table representing a many to many relationship between users and songs. Users can like/dislike many songs, and songs can be liked/disliked by many users. I am trying to retrieve a list of 30 songs, that can be any songs except for songs that have been disliked by the user

[web2py] Re: Inner join and left join in a many to many relationship

2013-07-18 Thread Mark Li
gname == db.songs.id) & (db.likes.username == auth.user.id)) , orderby='', limitby=(0,30)) If there are any mistakes please let me know! On Wednesday, July 17, 2013 8:05:18 PM UTC-7, Mark Li wrote: > > I have an intermediate table representing a many to many relationship > be

[web2py] Force user to reenter password to save auth.profile() changes

2013-08-07 Thread Mark Li
I currently have a "settings" page, where a form created by auth.profile() is displayed. I want to force the user to re-enter his/her password in order to save any changes they make to their profile (such as email, username, etc). Not really sure the best way to go about this, all the authentic

[web2py] Re: Force user to reenter password to save auth.profile() changes

2013-08-09 Thread Mark Li
Wednesday, August 7, 2013 10:18:17 PM UTC-7, Mark Li wrote: > > I currently have a "settings" page, where a form created by auth.profile() > is displayed. I want to force the user to re-enter his/her password in > order to save any changes they make to their profile (such as e

[web2py] Specifying onvalidation with auth.profile() prevents default onaccepts method

2013-09-05 Thread Mark Li
Currently I am creating a form with auth.profile() I have an onvalidation method to perform some extra checks. form = auth.profile() if form.process(onvalidation=reauthenticate_user).accepted: response.flash = "Changes Saved" elif form.errors: response.flash = "Errors found This prev

[web2py] Re: Specifying onvalidation with auth.profile() prevents default onaccepts method

2013-09-05 Thread Mark Li
4:46:11 PM UTC-7, Massimo Di Pierro wrote: > > This > > form = auth.profile() > form.process(onvalidation=reauthenticate_user) > > is wrong because auth.profile() already calls process inside. Instead you > should do: > > auth.settings.profile_onvalidation.append(reauthentica

[web2py] Re: Specifying onvalidation with auth.profile() prevents default onaccepts method

2013-09-06 Thread Mark Li
rm DOM after the form has been > processed, so the new field will not get added to form.vars. However, in > your onvalidation function, you should be able to replace > form.vars.confirm_password with request.vars.confirm_password. > > Anthony > > On Friday, September 6,

Re: [web2py] 1071, 'Specified key was too long; max key length is 767 bytes'

2013-10-09 Thread Mark Li
Just wanted to chime in on this. For me, I had to add a "length=255" to all my "unique=True" fields, even after adding length=255 for the "string" fields. On Wednesday, October 9, 2013 11:46:48 AM UTC-7, Niphlod wrote: > > sorry for being late. This is from web2py's 2.6.0 changelog. > > Attentio

[web2py] Database models don't import when using IPython 1.0.0 with web2py 2.7 (interactive shell)

2013-10-10 Thread Mark Li
I recently upgraded to the new version of web2py from 2.5 (on Pythonanywhere); everything seems to work fine except for the interactive shell. Using the command "python web2py.py -M -S appname" worked fine with 2.5, but now it doesn't seem to import the database models. I get the error "name '

[web2py] Retrieving user id for auth.settings.reset_password_onaccept

2013-10-19 Thread Mark Li
I'm trying to retrieve the user id for auth.settings.reset_password_onaccept.append( code needing user id here). The user is not logged in when they reset their password. The auth.reset_password function contains the user object, but I'm not sure how I can obtain that user id to use in onaccept

[web2py] Re: 2.4.7 problems

2013-10-20 Thread Mark Li
I've just encountered this problem myself, and I opened a ticket about this since I couldn't find one already posted. http://code.google.com/p/web2py/issues/detail?id=1736&thanks=1736&ts=1382314136 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/we

[web2py] cache.action questions (views with db selects, and different views for logged-in users)

2013-10-20 Thread Mark Li
I have 2 questions about cache.action Firstly, I am looking into cache.action to cache several static pages (about, contact, etc), that rarely change content. For users who aren't logged in, the pages would be the same. However, if a user is logged in, then there are links to the users' profile

[web2py] Re: cache.action questions (views with db selects, and different views for logged-in users)

2013-10-21 Thread Mark Li
Thanks Niphlod and Anthony! That answered my question about caching views with database selects. However, my problem with client-side caching differently for logged-in and non-logged in users is still a problem. Niphlod, I'm not sure what you're referring to by the "user" parameter. The closet

[web2py] After reset password, delete rows from table associated with user

2013-11-05 Thread Mark Li
I currently have a table of tokens db.define_table('mobile_tokens', Field ('username', 'reference auth_user'), Field ('token') ) After a user resets their password, all the mobile tokens for that user should also be deleted. After a user resets their password, is it possible to user a

[web2py] Re: After reset password, delete rows from table associated with user

2013-11-06 Thread Mark Li
Thanks for pointing me in the right direction, Stifan. I added this line to the model file: db.auth_user._after_update.append(lambda s: remove_mobile_token(s, db)) and this function in a module def remove_mobile_token(set, db): request = current.request #delete mobile tokens if the

[web2py] Saving incomplete form with required fields (to prevent dynamically added form inputs from disappear

2013-11-23 Thread Mark Li
I currently have 2 tables as follows, with a form containing values both tables db.define_table('playlist', Field('title', notnull=True), Field('description'), Field('tags'), Field('genre', 'reference genre') Field('finished', 'boolean') ) db.define_table('playlist_trac

[web2py] Re: Saving incomplete form with required fields (to prevent dynamically added form inputs from disappear

2013-11-23 Thread Mark Li
incomplete record and mark the "finished" column as false. This way, the playlist id already exists and I can save the playlist_tracks to the reference table. The validators will still apply when the user submits the form. On Saturday, November 23, 2013 6:50:19 PM UTC-8, Mark Li wrot

Re: [web2py] Re: Saving incomplete form with required fields (to prevent dynamically added form inputs from disappear

2013-11-26 Thread Mark Li
Yep, the "finished" field will prevent the unfinished records from being exposed where they shouldn't be. On Mon, Nov 25, 2013 at 11:15 AM, Dave S wrote: > On Saturday, November 23, 2013 11:44:05 PM UTC-8, Mark Li wrote: >> >> I think I've found an optimal

[web2py] Prevent multiple submit buttons from showing "Working..." on submit

2013-12-04 Thread Mark Li
I currently have 2 submit buttons in a form. When a user clicks on one of them, it changes both submit input values to "Working..." I looked into web2py.js and tried applying the suggestion there for preventing "Working.." from showing up on the buttons /*if you don't want to see "working..."

[web2py] Re: Prevent multiple submit buttons from showing "Working..." on submit

2013-12-05 Thread Mark Li
Hey Niphlod, The 2 submit buttons have different names, here's the resulting HTML. However, clicking on either results in both having the "working..." message. Is this not intended behavior? One of the form submit buttons is from the SQLFORM (i add a _na

Re: [web2py] Re: Prevent multiple submit buttons from showing "Working..." on submit

2013-12-07 Thread Mark Li
js is the same one shipped with the > latest web2py ? > You can fetch it here > > https://raw.github.com/web2py/web2py/master/applications/welcome/static/js/web2py.js > > > On Friday, December 6, 2013 12:31:17 AM UTC+1, Mark Li wrote: >> >> Hey Niphlod, >>

Re: [web2py] Re: Prevent multiple submit buttons from showing "Working..." on submit

2013-12-11 Thread Mark Li
all the inputs in the form ... that syntax **should** leave >>> out all inputs with a name attribute.... >>> Can you pack a minimal app to reproduce the issue ? >>> >>> >>> >>> On Sunday, December 8, 2013 3:28:06 AM UTC+1, Mark Li wrote: &

[web2py] Re: 1054, "Unknown column in 'field list'... Help me

2014-06-05 Thread Mark Li
I've had this happen several times, and the solution provided in this link have worked for me. http://comments.gmane.org/gmane.comp.python.web2py/42344 On Sunday, March 9, 2014 11:58:29 PM UTC-7, sujin...@gmail.com wrote: > > I had made MXPDEVICE table, and I added MXPPCPLATFORM table yesterday.

[web2py] Display registration error for auth.register_bare()

2014-07-21 Thread Mark Li
Is it possible to return the registration error msg from auth.register_bare(), similar to how auth.register() would display the error msg after submit? From what I can gather in the source, seems like it only returns False on fail, and the user object on success. I would like to display more in

[web2py] Re: Display registration error for auth.register_bare()

2014-07-21 Thread Mark Li
Maybe I'm not going about this in the right way. I basically want auth.register() functionality, but without a page reload on registration fail; just a flash msg of the error. On Monday, July 21, 2014 12:07:05 PM UTC-7, Mark Li wrote: > > Is it possible to return the registration err

[web2py] Re: Display registration error for auth.register_bare()

2014-07-22 Thread Mark Li
14:59:34 UTC-5, Mark Li wrote: >> >> Maybe I'm not going about this in the right way. I basically want >> auth.register() functionality, but without a page reload on registration >> fail; just a flash msg of the error. >> >> On Monday, July 21, 2014 12:07:05 P

[web2py] Re: Display registration error for auth.register_bare()

2014-07-23 Thread Mark Li
11:55:33 UTC-5, Mark Li wrote: >> >> Hey Massimo! Just for clarification, are you referring to opening a >> ticket for: >> >> 1. auth.register() only showing a flash msg on registration error, >> without a page reload >> >> OR >> >> 2

[web2py] How to prevent interactive shell from 303 error with redirect in model file.

2014-07-26 Thread Mark Li
I am currently redirecting my "index" page to another page (the "splash" page). The index page is the default function in my routes.py. The idea, is that if a user visits the "index" page, they will get redirected to the "splash" page, which works fine. At it's core, my redirect code looks like

[web2py] Re: How to prevent interactive shell from 303 error with redirect in model file.

2014-07-27 Thread Mark Li
onvenient method to check whether we > have an http request vs. a shell or scheduler run (maybe a flag such as > request.is_http_request). Feel free to submit a Google Code issue about > this. > > Anthony > > On Saturday, July 26, 2014 9:38:54 PM UTC-4, Mark Li wrote: >

[web2py] Re: Display registration error for auth.register_bare()

2014-07-30 Thread Mark Li
t via AJAX (and return errors via ajax as well)? Or would this involve adding changes to auth.register() as well, such as providing an option auth.register(ajax=False)? On Wednesday, July 23, 2014 4:42:05 PM UTC-7, Mark Li wrote: > > Posted up a ticket for both suggestions: > > https

Re: [web2py] Re: duplicate ids on using auth.login and auth.register forms on same page

2014-08-14 Thread Mark Li
Was this problem addressed, or is there are workaround for this? I am currently trying to implement something very similar, where both auth.login() and auth.register() forms are on the same page. Currently, they produce duplicate ID's (ex. both login and register password inputs have the id of

[web2py] How to differentiate logic for auth.login() and auth.register() forms on the same page?

2014-08-14 Thread Mark Li
I am currently using auth.login() and auth.register() forms on the same page I would like to use the following code for the login (to allow users to sign up with either username or email) auth.settings.login_userfield = 'email' if request.vars.email and IS_EMAIL()(request.vars.email)[1]: aut

[web2py] Re: How to differentiate logic for auth.login() and auth.register() forms on the same page?

2014-08-14 Thread Mark Li
Yep that did it, thanks Leonel! On Thursday, August 14, 2014 4:55:45 PM UTC-7, Leonel Câmara wrote: > > You need to differentiate them using the form name. > > Something like: > > if request.post_vars._formname == 'login': ># do my login stuff > -- Resources: - http://web2py.com - http://we

Re: [web2py] Re: SQLFORM generating duplicate ids in HTML

2014-08-15 Thread Mark Li
Was the duplicate ID's bug ever fixed or addressed with an optional prefix field? It currently looks like I would have to manually alter all the ID's of my auth.login() form, because auth.register() form is on the same page. On Wednesday, January 27, 2010 5:17:14 PM UTC-8, Jonathan Lundell wrote

[web2py] How to alter attributes of multiple elements with the same prefix, in a form

2014-08-18 Thread Mark Li
I am currently trying to alter all the ID's of the elements in the auth.login() form. Basically, I want to add a prefix or suffix to all the elements that have an ID. All of the id's (except for the submit button row), are prefixed with "auth_user_". Is it possible to use form.elements() to sel

[web2py] Registration passworld field security risk on form failure?

2014-08-25 Thread Mark Li
I am currently looking into whether or not password fields should be cleared on registration error after the form fails server-side validation. At the moment, web2py shows the password after a registration error, instead of leaving it blank. While this may make editing the password easier (in c

[web2py] Re: Registration passworld field security risk on form failure?

2014-08-26 Thread Mark Li
wrote: > > Have you actually looked at it? I believe it just returns asterisks. > > On Monday, August 25, 2014 3:02:49 PM UTC-7, Mark Li wrote: >> >> I am currently looking into whether or not password fields should be >> cleared on registration error after the form fails

[web2py] Re: Registration passworld field security risk on form failure?

2014-08-27 Thread Mark Li
t; Thus on re-submitting the form, they would not think to alter the password >> and would just submit a password with asterisks. >> >> On Monday, August 25, 2014 3:25:44 PM UTC-7, Derek wrote: >>> >>> Have you actually looked at it? I believe it just returns asterisks

  1   2   >