[web2py] Paypal integration and reservation system
Hi i need to implement a reservation system: - the user can accept a reservation and the system must block the moneys - After x times (for example 1 week) my software can abort the payment and the user have the money back - After x times (for example 1 week) my software can accept the payment and accept the money anyone can help me or have any example? thanks for help -- 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] Paypal integration and reservation system
https://developers.braintreepayments.com/javascript+python/sdk/overview/how-it-works On Fri, Jul 18, 2014 at 11:09 AM, ceriox cer...@gmail.com wrote: Hi i need to implement a reservation system: - the user can accept a reservation and the system must block the moneys - After x times (for example 1 week) my software can abort the payment and the user have the money back - After x times (for example 1 week) my software can accept the payment and accept the money anyone can help me or have any example? thanks for help -- 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] Paypal integration and reservation system
thanks for your reply, but i can't understand well ... i'm not a good programmer, do you have a working example? Il giorno venerdì 18 luglio 2014 11:25:19 UTC+2, Vasile Ermicioi ha scritto: https://developers.braintreepayments.com/javascript+python/sdk/overview/how-it-works On Fri, Jul 18, 2014 at 11:09 AM, ceriox cer...@gmail.com javascript: wrote: Hi i need to implement a reservation system: - the user can accept a reservation and the system must block the moneys - After x times (for example 1 week) my software can abort the payment and the user have the money back - After x times (for example 1 week) my software can accept the payment and accept the money anyone can help me or have any example? thanks for help -- 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 javascript:. 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: Direct editing inside a grid
Hello, I could sort it out... For those who could be interrested, here under the key elements of my solution. 1. In the model, create the following functions (here for string and drop list): def options_widget(field,value,**kwargs): return SQLFORM.widgets.options.widget(field,value,_class=generic-widget,**kwargs) def string_widget(field,value,**kwargs): return SQLFORM.widgets.string.widget(field,value,_class='string',**kwargs ) In the controller, in the function that you want to contain the editing grid: def my_function_name(): # here my tale name = t_txw_expense_template if len(request.post_vars) 0: for key, value in request.post_vars.iteritems(): (field_name,sep,row_id) = key.partition('_row_') # field_name will look like field_name_row_99 if row_id: db(db.t_txw_expense_template.id == row_id).update(**{field_name:value}) # the name of the attribute is used to know which row is involved # for each field that you want to see: db.t_txw_expense_template.f_expense_template.represent = lambda value, row: string_widget(db.t_txw_expense_template.f_expense_template, value, **{'_name':'f_expense_template_row_%s' % row.id}) db.t_txw_expense_template.f_header.represent = lambda value, row: string_widget(db.t_txw_expense_template.f_header, value, **{'_name':'f_header_row_%s' % row.id}) db.t_txw_expense_template.f_project.represent = lambda value, row: options_widget(db.t_txw_expense_template.f_project, value, **{'_name':'f_project_row_%s' % row.id}) # and so on... form = SQLFORM.smartgrid(db.t_txw_expense_template, # and so on... # selectable = dict(t_txw_expense_template= None) selectable= lambda ids : redirect(URL('my_function_name',vars=request._get_vars)), ) #remove selectable's checkboxes form.elements(_type='checkbox',_name='records',replace=None) return dict (form = form) Hope this can help... Le jeudi 17 juillet 2014 21:57:12 UTC+2, Anthony a écrit : I don't have time to look into it, but seeing some code and a traceback might help. Anthony On Thursday, July 17, 2014 12:18:39 PM UTC-4, Serge Bourgeois wrote: Thanks Antony!. Do you know if there is any plan to develop such a feature? If yes, do you have any idea of availability ? Still a third question: I tried the idea proposed here : http://www.web2pyslices.com/slice/show/1928/basic-inline-editing-in-sqlformgrid-no-plugin-no-javascript but, I got a message saying that I couldn't change the objects already existing ... (I guess the name of the fields, even with migrate == False). Maybe you have any good idea to turn around this issue? Serge Le jeudi 17 juillet 2014 17:21:05 UTC+2, Anthony a écrit : This is not available out of the box, though it would be nice. Anthony On Thursday, July 17, 2014 10:25:20 AM UTC-4, Serge Bourgeois wrote: Hello, In order to simplify the user interface of basic controller functions, I want to offer direct editing in SQLFORM.smartgrid, using the same widgets (string, options, uploads, ...) than those available in create or edit. Maybe, I missed the point in the doc? Thank you for any advice. Serge -- 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] links in admin when using more than one domain / autoroutes
Not a major gripe, but perhaps something could be improved? I am using *scripts/autoroutes.py* and in the admin, all my apps appear to link to *http://ip or domain/index* (it's the same address) for all the apps. If it isn't a major thing to accomplish within web2py, I would like to suggest perhaps the correct links could be displayed instead of the same address. For instance: #routes.conf abc.com /abc/default xyz.com /xyz/default … (5 apps or more) In web2py admin, *abc* app - *abc.com/index* instead of *http://ip or domain/index* *xyz* app - *xyz.com/index* instead of *http://ip or domain/index* As my setup is stable, I have yet to test if the parametric router would work for the admin links -- 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: error(10053, 'An established connection was aborted by the software in your host machine')
in web2py shell, when I open DB urls: http://127.0.0.1:8000/ipay/appadmin this error occurred (( sometimes mySQL rise this error in random and I restart server (Windirs server 2008 R2) than all work fine about 2-3 days than error occure again ( среда, 16 июля 2014 г., 15:45:15 UTC+4 пользователь Massimo Di Pierro написал: This is not the problem. You should not close connections in web2py. web2py may need to recycle them in the connection pool. Can you connect to your database via other means? For example the python shell or the web2py shell? -- 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: Weird bug using a computed field and then having an update using expressions
Thanks Anthony for the detailed explanation. It makes sense, but I think this is an example of a leaky abstraction - I shouldn't have to care. Maybe the DAL could delay computed fields until after insertion if it detects an Expression. -- 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 Deployment Script for Ubuntu 14.04
This recipe which had worked: { One step production deployment Here are some steps to install apache+python+mod_wsgi+web2py+postgresql from scratch. On Ubuntu: wget http://web2py.googlecode.com/hg/scripts/setup-web2py-ubuntu.sh chmod +x setup-web2py-ubuntu.sh sudo ./setup-web2py-ubuntu.sh } *no longer works when using the Ubuntu 14.04 operating system.* Instead of getting the default web2py welcome application (when you type in the IP address on the browser), an Apache default page is displayed. returning to Ubuntu 12.04 operating system fixed the issue (the deployement recipe worked on that older Ubuntu version) -- 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: Weird bug using a computed field and then having an update using expressions
Could get complicated. Feel free to submit a pull request. On Friday, July 18, 2014 8:04:47 AM UTC-4, Leonel Câmara wrote: Thanks Anthony for the detailed explanation. It makes sense, but I think this is an example of a leaky abstraction - I shouldn't have to care. Maybe the DAL could delay computed fields until after insertion if it detects an Expression. -- 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: Weird bug using a computed field and then having an update using expressions
I'm not comfortable enough with the DAL code base to do this kind of, in part, architectural change. I would probably change _listify to return both newfields.values() and the to_compute list instead of computing it. Then only after updating/inserting would I calculate the compute fields. This change would also fix another leaky abstraction - you having to update fields that are not actually being updated just because you need them in the compute function. Doing these changes would probably fix all the problems I see people having in this user group with computed fields. -- 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: Weird bug using a computed field and then having an update using expressions
The problem is that updates do not involve pulling the existing records from the database into web2py, so web2py doesn't have access to the existing field values (nor does web2py know which fields are needed by the compute function). Also, because computed field values could be different for each record, you cannot simply issue a single database update but instead must iterate over each record and do individual updates. So, for updates to tables with computed fields, we would have to first do the database update, then select all the records in the set, then loop over the records and call update_record on each record. This wouldn't necessarily be needed all the time, so maybe could be triggered via a new recompute argument to .update(): db(query).update(field1='newvalue', recompute=True) Anthony On Friday, July 18, 2014 8:47:14 AM UTC-4, Leonel Câmara wrote: I'm not comfortable enough with the DAL code base to do this kind of, in part, architectural change. I would probably change _listify to return both newfields.values() and the to_compute list instead of computing it. Then only after updating/inserting would I calculate the compute fields. This change would also fix another leaky abstraction - you having to update fields that are not actually being updated just because you need them in the compute function. Doing these changes would probably fix all the problems I see people having in this user group with computed fields. -- 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: Weird bug using a computed field and then having an update using expressions
I like it! That would allow web2py to keep the old behaviour (so backwards compatible) of computing before updating, when possible, but allow us to force a more complete recomputation when necessary. -- 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: Weird bug using a computed field and then having an update using expressions
If you don't mind, maybe add a Google Code issue and link to this thread. Anthony On Friday, July 18, 2014 9:17:47 AM UTC-4, Leonel Câmara wrote: I like it! That would allow web2py to keep the old behaviour (so backwards compatible) of computing before updating, when possible, but allow us to force a more complete recomputation when necessary. -- 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: Weird bug using a computed field and then having an update using expressions
That I can do! Submitted here: https://code.google.com/p/web2py/issues/detail?id=1951thanks=1951ts=1405691098 -- 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 do I serve static files with caching
Hi, In my application, there are few static images which needs to be visible for all pages. Currently, I am serving these files using the below code img src={{=URL(r=request,c='static/images',f='image1.jpg')}} alt= / Q1 :- Is it the right way to serve the image file? Q2 :- How could I enable caching for these static files? Please note, I am using fast_download technique for database uploaded images, but I am not sure on if this can be used and how can be used? -- 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 do I serve static files with caching
On Friday, July 18, 2014 10:21:59 AM UTC-4, Sarbjit wrote: Hi, In my application, there are few static images which needs to be visible for all pages. Currently, I am serving these files using the below code img src={{=URL(r=request,c='static/images',f='image1.jpg')}} alt= / Q1 :- Is it the right way to serve the image file? URL('static', 'images/image1.jpg') Q2 :- How could I enable caching for these static files? Please note, I am using fast_download technique for database uploaded images, but I am not sure on if this can be used and how can be used? The browser will cache your static files. No need to cache on the server, as they are not generated dynamically. Anthony -- 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 do I serve static files with caching
Thanks Anthony for quick response. Are you saying if I use the URL with the mentioned syntax, then browser will cache static files automatically? Because the fast_download technique that I used (picked from web2py application development cookbook) enables browser cache for database uploaded images. -Sarbjit -- 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 do I serve static files with caching
The browser will cache your static files. No need to cache on the server, as they are not generated dynamically. sadly it won't. For a debatable design decision, static files are not served with cache headers. the correct way to enable far in the future cache headers and avoid multiple 304s is to use static versioning, i.e. URL('static', '_1.2.3/images/image1.jpg') -- 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 do I serve static files with caching
I should have been more precise. The browser will cache the static files and re-use them, but it will still send requests to the server to check whether the cached version has expired (if not expired, the server will send a 304 response indicating the cached version is still current, so the entire file will not be re-sent). This assumes you are using web2py to serve the static files (as opposed to configuring your web server to do so directly). Anthony On Friday, July 18, 2014 10:56:41 AM UTC-4, Niphlod wrote: The browser will cache your static files. No need to cache on the server, as they are not generated dynamically. sadly it won't. For a debatable design decision, static files are not served with cache headers. the correct way to enable far in the future cache headers and avoid multiple 304s is to use static versioning, i.e. URL('static', '_1.2.3/images/image1.jpg') -- 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 Deployment Script for Ubuntu 14.04
You can update the script if you can. Must be a couple of package renamed from Ubuntu side... :) Richard On Fri, Jul 18, 2014 at 8:14 AM, Auden RovelleQuartz oves@gmail.com wrote: This recipe which had worked: { One step production deployment Here are some steps to install apache+python+mod_wsgi+web2py+postgresql from scratch. On Ubuntu: wget http://web2py.googlecode.com/hg/scripts/setup-web2py-ubuntu.sh chmod +x setup-web2py-ubuntu.sh sudo ./setup-web2py-ubuntu.sh } *no longer works when using the Ubuntu 14.04 operating system.* Instead of getting the default web2py welcome application (when you type in the IP address on the browser), an Apache default page is displayed. returning to Ubuntu 12.04 operating system fixed the issue (the deployement recipe worked on that older Ubuntu version) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
[web2py] DAL query for optional integer field (Postgres)
Background : I'm using postgres (web2py 2.9.5 - but I don't think it matters) I have an integer field - which is optional say Number of pets I have NOT set any default value (I think for Postgres - this means default NULL) When user does not select from the drop down IS_EMPTY_OR(IS_IN_SET([1,2,3,4])) - I see value None in the grid (Seems OK) I have *another grid* where I need to find people with 1 pet - I *also* need to *count* people who have *not specified* the count. So (part of) my query is : db.user_profile.pets.belongs([1, None]) But this returns only the profiles with number of pet as 1 i.e. Profiles where number of pets is NOT specified isn't returned. I checked db._lastsql - it turns out it is Postgres that doesn't return the rows (So it is not really web2py's fault) The raw query is : SELECT * FROM user_profile WHERE user_profile.pets IN (1,NULL); I also tried : ~db.user_profile.pets.belongs([2,3,4]) Assuming None isn't part of 2,3,4 - so those rows will be returned - but only the rows with pets=1 are returned. Queries : 1. What is the default value at Postgres level ? (*psql command prompt shows white space under pets column for those records*) 2. What DAL query should I use to get *both* pets specified as 1 and pets count not specified ? Thanks, -Mandar P.S: I'm not sure subject makes sense or matches with my question, but I didn't know how to summarize my query in the subject -- 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: DAL query for optional integer field (Postgres)
Postgres is right NULL doesn't equal anything dude. db((db.user_profile.pets==1)|(db.user_profile.pets== None)).count() -- 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 Forms and Javascript
This is kind of two questions but I would like to build a app to handle Invoicing, We have some satellite offices in other towns and it would be nice to get rid of our hand written paper forms and faxing(FORM https://drive.google.com/file/d/0BydRLdL9cc4mNzhjR1U3MHVPVjA/edit?usp=sharing ). I would like to know whats the best practice for building the data model on large forms? Should the form be all one table? There's about 35 items, which 20 or so would just be integers (amounts of item).. below I have an example of what I'm thinking of going with. Finally I would like to implement a auto-filling form, for example if the user types in a location that has already been put in once before it will automatically fill in the mileage and person to attn to, would this be best handled with a javascript framework? If so could you push me towards one to learn? (my javascript is weak but I'm working on it :)) Thanks in advance! Jesse Ferguson EXAMPLE MODEL db.define_table('invoice', Field('price_list', 'integer'), Field('account_code','string'), Field('company', 'string'), Field('attn', 'string'), Field('customer_order_number', 'string'), Field('ccc_so_num', 'string'), Field('date_of_work', 'date'), Field('wo_location', 'string'), Field('lease', 'string'), Field('details', 'list: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.
Re: [web2py] Web2py Forms and Javascript
For the prefilled data you have this : db.invoice.fieldname.default = your previous predefined form data For your model, I think it is much more complex then that... For instance, what's happen when there is new Items? You add new column to your model each time? (bad idea). Also storing company in the invoice table is a bad idea (denormalized) because you will have to input each time company name and address in you company field. For this you may consider to add a company table and change your company string field like that : Field('company', 'reference company'), You will have to populate company table first with another form then select the new inserted company after in your invoice form. The same goes for the items they should go in an item/product table and you should have a items_id field that could be of time list:reference where you select the item, though you will not be able to precise the quantity that way. There is tonnes of schema design for invoice app : Here some UML : https://www.google.ca/search?q=invoice+database+schemaespv=2tbm=ischimgil=j-vKuBZKWTALKM%253A%253Bhttps%253A%252F%252Fencrypted-tbn2.gstatic.com%252Fimages%253Fq%253Dtbn%253AANd9GcRrkWvL-9FvYRH5sr5lgH6QWiut3gK4MfVzMP26BcvCI2rV7x-u%253B503%253B285%253B2YNCt_eklOX5dM%253Bhttps%25253A%25252F%25252Fpeople.ok.ubc.ca%25252Frlawrenc%25252Fteaching%25252F304%25252FNotes%25252Fsource=iuusg=__q2COFwdJchOn1mZeO6vYLLlpjHk%3Dsa=Xei=wnXJU-T3D8SUyASKs4CgBQved=0CB4Q9QEwAAbiw=1920bih=995#facrc=_imgrc=j-vKuBZKWTALKM%253A%3B2YNCt_eklOX5dM%3Bhttps%253A%252F%252Fpeople.ok.ubc.ca%252Frlawrenc%252Fteaching%252F304%252FNotes%252FER%252FInvoice.png%3Bhttps%253A%252F%252Fpeople.ok.ubc.ca%252Frlawrenc%252Fteaching%252F304%252FNotes%252F%3B503%3B285 Richard On Fri, Jul 18, 2014 at 2:57 PM, Jesse Ferguson ifl...@gmail.com wrote: This is kind of two questions but I would like to build a app to handle Invoicing, We have some satellite offices in other towns and it would be nice to get rid of our hand written paper forms and faxing(FORM https://drive.google.com/file/d/0BydRLdL9cc4mNzhjR1U3MHVPVjA/edit?usp=sharing ). I would like to know whats the best practice for building the data model on large forms? Should the form be all one table? There's about 35 items, which 20 or so would just be integers (amounts of item).. below I have an example of what I'm thinking of going with. Finally I would like to implement a auto-filling form, for example if the user types in a location that has already been put in once before it will automatically fill in the mileage and person to attn to, would this be best handled with a javascript framework? If so could you push me towards one to learn? (my javascript is weak but I'm working on it :)) Thanks in advance! Jesse Ferguson EXAMPLE MODEL db.define_table('invoice', Field('price_list', 'integer'), Field('account_code','string'), Field('company', 'string'), Field('attn', 'string'), Field('customer_order_number', 'string'), Field('ccc_so_num', 'string'), Field('date_of_work', 'date'), Field('wo_location', 'string'), Field('lease', 'string'), Field('details', 'list: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. -- 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] JSONRPC and Pyjamas - what I must do?
in test application - empty screen (( https://lh6.googleusercontent.com/-ZTlrUB707cQ/U8mFaGGIeAI/ACU/YohLR1zqIu0/s1600/pyjam.png -- 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: JSONRPC and Pyjamas - what I must do?
https://lh4.googleusercontent.com/-x041vI2wSPM/U8mJ8zE_XiI/ACg/n7FQeKokoB8/s1600/pyjam-2.png суббота, 19 июля 2014 г., 0:41:04 UTC+4 пользователь Dmitry Ermolaev написал: in test application - empty screen (( https://lh6.googleusercontent.com/-ZTlrUB707cQ/U8mFaGGIeAI/ACU/YohLR1zqIu0/s1600/pyjam.png -- 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] SQLFORM.grid: sorting
Hi, I solved it putting the foreing key format in the controller, before the grid: def familia_manage(): *db.auth_user._format = '%(last_name)s %(first_name)s'* fields=[db.t_familiares.f_nombre, db.t_familiares.f_apellidos,db.t_familiares.f_titular] form = SQLFORM.grid(db.t_familiares, fields=fields ) return locals() Where, in the table declaration: db.t_familiares.f_titular.requires= (IS_IN_DB(db,'auth_user.id','%(last_name)s ''%(first_name)s')) When I press the header I get it order by last_name instead of id. El lunes, 21 de mayo de 2012 22:24:23 UTC+2, backseat escribió: Thanks Jim, I somehow missed the 'orderby' parameter to SQLFORM.grid On Mon, 21 May 2012 13:11:31 -0700 (PDT), massimo@gmail.com javascript: said: foreign key. You can do a join. Thanks Massimo; however, that's a little cryptic. Could you explain how a join can be used to determine the sort order when I click on a SQLFORM.grid header? Thanks, Keith -- You can have everything in life you want if you help enough other people get what they want - Zig Ziglar. Who did you help today? -- 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] как сделать передачу данных от сервера к клиенту без AJAX
как быстро обновлять данные на странице у клиента при изменении данных на сервере? без использования AJAX or FLASH -- 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: problem with request_reset_password routes on server
I am not 100% sure of why you have the settings you have. Whether you want to keep them that way or now. My advice is this... write your code so that it works as you expect on localhost without routes.py, even if the Urls are not the ones you want. Then you edit the routes so that you get the Urls you want without any change in your code. we can help with that. You may need two different routes.py on localhost and on a production site depending on the configuration of the server. Massimo On Thursday, 17 July 2014 19:47:08 UTC-5, Júlia Rizza wrote: Hello, I have a controller called 'painel.py' and the following config in my *db.py* file: ## configure auth policy auth.settings.mailer=mail auth.settings.controller = 'painel' auth.settings.actions_disabled.append('register') auth.settings.registration_requires_verification = False auth.settings.registration_requires_approval = False auth.settings.allow_basic_login = False auth.settings.reset_password_requires_verification = True auth.settings.login_url = URL('painel', 'index') auth.settings.login_next = URL('painel', 'dashboard') auth.settings.logged_url = URL('painel', 'dashboard') auth.settings.request_reset_password_next = URL('painel', 'index') auth.settings.reset_password_next = URL('painel', 'index') auth.settings.logout_next=URL('painel', 'index') auth.settings.profile_next = URL('painel', 'dashboard') auth.settings.retrieve_username_next = URL('painel', 'dashboard') auth.settings.retrieve_password_next = URL('painel', 'dashboard') auth.settings.change_password_next = URL('painel', 'dashboard') auth.settings.on_failed_authentication = URL('painel', 'index') I defined *painel.py* as auth controller so the login url when it is an invalid login won't be crashing, but the user function is still on the *default.py* controller. But now when I access the 'request_reset_password' page and try to enter my username and submit the form, it works normally on localhost but not on server (Apache on Ubuntu). The routes when submiting the form are '/user/request_reset_password' on localhost, but '/myapp/*painel*/user/request_reset_password' (wrong controller) on server. Is there a better way to fix this? *routes.py* *BASE = ''routes_in = ((BASE + '/', BASE + '/myapp/painel/index'), (BASE + '/user/$anything', BASE + '/myapp/default/user/$anything'), (BASE + '/download/$anything', BASE + '/myapp/default/download/$anything'),(BASE + '/call/$anything', BASE + '/myapp/default/call$anything'),(BASE + '/data/$anything', BASE + '/myapp/default/data/$anything'),(BASE + '/myapp/static/$anything', BASE + '/myapp/static/$anything'),(BASE + '/myapp/appadmin', BASE + '/myapp/appadmin'),(BASE + '/myapp/appadmin/$anything', BASE + '/myapp/appadmin/$anything'),(BASE + '/index', BASE + '/myapp/painel/index'),(BASE + '/start', BASE + '/myapp/painel/start'),(BASE + '/dashboard', BASE + '/myapp/painel/dashboard'),(BASE + '/monitor', BASE + '/myapp/painel/monitor'),(BASE + '/accept/$anything', BASE + '/myapp/painel/accept/$anything'),(BASE + '/invite', BASE + '/myapp/painel/invite'),(BASE + '/invite/$anything', BASE + '/myapp/painel/invite/$anything'),(BASE + '/delete/$anything', BASE + '/myapp/painel/delete/$anything'),(BASE + '/$anything', BASE + '/myapp/painel/board/$anything'),)routes_out = [(x, y) for (y, x) in routes_in]* -- 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] SQLFORM.grid: sorting
You cannot a have an inner join in smartgrid. That's the biggest difference in this case. You can have orderby. On Monday, 21 May 2012 15:47:53 UTC-5, Jim S wrote: Massimo - Is there a way to do it with a .smartgrid. I know the question wasn't on .smartgrid, but I'm using that extensively and too would like some sort of solution. -Jim On 5/21/2012 3:11 PM, Massimo Di Pierro wrote: foreign key. You can do a join. On Monday, 21 May 2012 14:49:06 UTC-5, Jim S wrote: You can specify the sort order using the orderby parameter. But, I don't know how you get it to sort by the displayed value of a foreign key column. Ex: orderby = [~db.asset.acquiredOn, db.asset.assetTag, db.asset.description] ~ orders descending. -Jim On 5/21/2012 2:23 PM, Keith Edmunds wrote: Two questions re SQLFORM.grid sorting. 1. Is it possible to specify the initial sort order? 2. I'm displaying a table that includes a foreign field. When I click on the header to sort by that field, it sorts by the field id rather than by the (displayed) foreign field. Can I sort by the displayed field? Thanks, Keith -- 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: как сделать передачу данных от сервера к клиенту без AJAX
Server Push - though i'm not sure it's supported in Web2Py. On Friday, July 18, 2014 2:00:22 PM UTC-7, Dmitry Ermolaev wrote: как быстро обновлять данные на странице у клиента при изменении данных на сервере? без использования AJAX or FLASH -- 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 Forms and Javascript
for autofiling please check it on the book about dal default or ajax autocompletion ref: http://web2py.com/books/default/chapter/29/11/jquery-and-ajax#Auto-completion http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer as richard said : please have normalization on your table. e.g. # create table : invoice_header db.define_table('invoice_header', Field('invoice_no'), Field('invoice_date', 'date'), Field('customer', 'reference customer'), Field('grand_total', 'integer'), auth.signature ) # create table : invoice_detail db.define_table('invoice_detail', Field('invoice_no', 'reference invoice_header'), Field('product', 'reference product'), Field('quantity', 'integer'), Field('price', 'integer'), Field('total_price', 'integer'), Field('grand_total', 'integer'), auth.signature ) for company info, i usually have a query from created_on field, that refer to auth_user table and show it when print the invoice, you can also learn from web2py appliances, estore and pos online store. 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.
Re: [web2py] Web2py Forms and Javascript
I think this would work better however I am not sure about the items.. is the item_entry table how its normally done? Examples online vary... A completed Service order would have multiple Item_entry references... Just doesn't seem like the right way to do it.. db.define_table('company', Field('name', 'string')) db.define_table('lease', Field('name', 'string'), Field('attn', 'string'), Field('location', 'string')) db.define_table('account_code', Field('code','string')) db.define_table('item', Field('name', 'string'), Field('pl_no', 'integer'), Field('cost', 'double')) db.define_table('item_entry', Field('item', 'reference item'), Field('amount', 'double')) db.define_table('service_order', Field('so_date', 'date'), Field('so_num', 'integer'), Field('so_hours', 'double'), Field('total_cost', 'double'), Field('notes', 'text'), Field('company', 'reference company'), Field('lease', 'reference lease'), Field('acct_code', 'reference account_code'), Field('items', 'list:reference item_entry') ) -- 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: PythonAnywhere Web2py Script
I have some scripts that do not output anything - but I know they work (Mostly DB initialization, populate initial DB etc.) You can put some print statements in voltrin_grabber.py just for debugging - see if you hit those print statements. On Wednesday, July 16, 2014 7:07:21 PM UTC+5:30, Tom Russell wrote: I am trying to run a script that I have in my app. While the log files seem to show my script ran, it does not update the db I have for my app. On the schedule tab in pythonanywhere I have this set up so not sure if it is correct: python2.7 /home/tsrdatatech/web2py/web2py.py -S ttheorydataextractor -M -R /home/tsrdatatech/web2py/applications/ttheorydataextractor/modules/ voltrin_grabber.py And a sample output of what the log says when it runs is below: 2014-07-14 23:00:44 -- Completed task, took 17.00 seconds, return code was 0. web2py Web Framework Created by Massimo Di Pierro, Copyright 2007-2014 Version 2.9.5-stable+timestamp.2014.03.16.02.35.39 Database drivers available: SQLite(sqlite3), MySQL(pymysql), MySQL(MySQLdb), MySQL(mysqlconnector), PostgreSQL(psycopg2), PostgreSQL(pg8000), MSSQL(pyodbc), DB2(pyodbc), Teradata(pyodbc), Ingres(pyodbc), MongoDB(pymongo), IMAP(imaplib) 2014-07-15 23:00:30 -- Completed task, took 11.00 seconds, return code was 0. It seems like it opens web2py but doesnt really run the script I have I think. 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.
Re: [web2py] Alternative IDEs?
On Monday, July 14, 2014 6:58:51 PM UTC+5:30, Ramos wrote: Sublime Text Does ST have web2py integration ? as sasogeek wrote help me find methods and variables easily. for example autocomplete options to choose from after using a dot operator? Are there any plugins for that ? I know pycharm paid version has this (community edition doesn't, still it is my IDE of choice) -Mandar 2014-07-14 13:35 GMT+01:00 'sasogeek' via web2py-users web...@googlegroups.com javascript:: Are there any alternative IDEs for web2py? I'm in search of an IDE for web2py that can help me find methods and variables easily. for example autocomplete options to choose from after using a dot operator? the default browser ide lacks quite a number of things in making programming easy. Web2py in itself I believe makes developing applications really really easy, but I believe writing the code should be just as easy the development process itself... if you get what I mean. -- 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 javascript:. 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: DAL query for optional integer field (Postgres)
On Friday, July 18, 2014 10:42:47 PM UTC+5:30, Leonel Câmara wrote: Postgres is right NULL doesn't equal anything dude. db((db.user_profile.pets == 1)|(db.user_profile.pets == None)).count() web2py user mailing list has NEVER failed me Leonel - Thanks a LOT !!! (Yes, it worked.) (I wonder why I didn't think of it myself) -Mandar -- 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: error(10053, 'An established connection was aborted by the software in your host machine')
350 errors for 5 hours work (( why? if I use LOAD(... ajax=True) {{=LOAD('where', 'for_addr.load', vars={'addr': addr}, ajax=True, times=100, timeout=2, content=IMG(_src=URL('static','images/loading.gif'), _width=48))}} https://lh4.googleusercontent.com/-2IkS4jBRT48/U8nnRAPGF2I/ACw/v1HqII0eT-g/s1600/err10053-3.png -- 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: error(10053, 'An established connection was aborted by the software in your host machine')
in mySQL ipay.err = 2014-07-19 07:53:07 1512 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld: Forcing close of thread 1933 user: 'root' 2014-07-19 07:53:07 1512 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld: Forcing close of thread 1921 user: 'root' 2014-07-19 07:53:07 1512 [Warning] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld: Forcing close of thread 1928 user: 'root' -- 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: error(10053, 'An established connection was aborted by the software in your host machine')
2014-07-19 07:53:32 1560 [Note] Plugin 'FEDERATED' is disabled. 2014-07-19 07:53:32 648 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator. 2014-07-19 07:53:32 1560 [Note] InnoDB: Using atomics to ref count buffer pool pages 2014-07-19 07:53:32 1560 [Note] InnoDB: The InnoDB memory heap is disabled 2014-07-19 07:53:32 1560 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2014-07-19 07:53:32 1560 [Note] InnoDB: Compressed tables use zlib 1.2.3 2014-07-19 07:53:32 1560 [Note] InnoDB: Not using CPU crc32 instructions 2014-07-19 07:53:32 1560 [Note] InnoDB: Initializing buffer pool, size = 8.0M 2014-07-19 07:53:32 1560 [Note] InnoDB: Completed initialization of buffer pool 2014-07-19 07:53:32 1560 [Note] InnoDB: Highest supported file format is Barracuda. 2014-07-19 07:53:36 1560 [Note] InnoDB: 128 rollback segment(s) are active. 2014-07-19 07:53:36 1560 [Note] InnoDB: Waiting for purge to start 2014-07-19 07:53:36 1560 [Note] InnoDB: 5.6.16 started; log sequence number 940666479 2014-07-19 07:53:36 1560 [Note] Server hostname (bind-address): '*'; port: 3306 2014-07-19 07:53:36 1560 [Note] IPv6 is available. 2014-07-19 07:53:36 1560 [Note] - '::' resolves to '::'; 2014-07-19 07:53:36 1560 [Note] Server socket created on IP: '::'. 2014-07-19 07:53:37 1560 [Note] Event Scheduler: Loaded 0 events 2014-07-19 07:53:37 1560 [Note] C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld: ready for connections. Version: '5.6.16-log' socket: '' port: 3306 MySQL Community Server (GPL) -- 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 Deployment Script for Ubuntu 14.04
I posted about this a couple weeks ago along with what worked for me ,,https://groups.google.com/forum/#!searchin/web2py/Apache$20Ubuntu%7Csort:date/web2py/o6OGQRQTN6Y/oJJQMGChgpcJ On Friday, July 18, 2014 7:14:18 AM UTC-5, Auden RovelleQuartz wrote: This recipe which had worked: { One step production deployment Here are some steps to install apache+python+mod_wsgi+web2py+postgresql from scratch. On Ubuntu: wget http://web2py.googlecode.com/hg/scripts/setup-web2py-ubuntu.sh chmod +x setup-web2py-ubuntu.sh sudo ./setup-web2py-ubuntu.sh } *no longer works when using the Ubuntu 14.04 operating system.* Instead of getting the default web2py welcome application (when you type in the IP address on the browser), an Apache default page is displayed. returning to Ubuntu 12.04 operating system fixed the issue (the deployement recipe worked on that older Ubuntu version) -- 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: test_has_right_title does not pass in the exercise given in :http://killer-web-development.com/
Stackoverflow has a good answer to this question. http://stackoverflow.com/questions/19282549/web2py-testing-with-selenium-webdriver I am working the tutorial now and these changes worked for me... def test_has_right_title(self): # First he looks at the topbar and sees 'Microposts On Steroids' title = self.browser.title self.assertEqual('Microposts On Steroids', title) def test_has_right_title(self): # First he looks at the topbar and sees 'Tukker.Me Privacy Policy' title = self.browser.title self.assertEqual('Tukker.Me Privacy Policy', title) def test_has_right_title(self): # First he looks at the topbar and sees 'About Tukker.Me' title = self.browser.title self.assertEqual('About Tukker.Me', title) Have fun.. On Friday, June 28, 2013 4:25:20 AM UTC-7, shai...@signumsol.com wrote: I tried what you suggested, but it gave the same error. :( On Tuesday, June 25, 2013 8:24:48 PM UTC+5:30, dhmorgan wrote: you're welcome; I'd been wanting to run through the tutorial, yes,within test_static_pages.py (though I guess you've probably tried it by now) it will work that way; I don't know selenium well enough to say whether his example should work or whether browser.title is the preferred way; I'd comment to him on the site but it's taken over by spammers On Tuesday, June 25, 2013 4:08:25 AM UTC-5, shai...@signumsol.com wrote: Thank you so much for responding Danny. Do you mean to say that I need to change the statement :title = self.browser.find_element_by_tag_name('title') to... title = self.browser.title ...?? On Monday, June 24, 2013 12:12:20 PM UTC+5:30, shai...@signumsol.com wrote: In the tukker application example given in the killer-web-development.com the test_has_right_title fails in-spite of having the exact code and steps followed according to the instructions on the website. The message I get after running the application is : FAIL: test_has_right_title (test_static_pages.TestPrivacyPage) -- Traceback (most recent call last): File /home/shailajack/Desktop/python_prog/web2py/applications/tukker/fts/test_static_pages.py, line 18, in test_has_right_title self.assertEqual('Tukker.Me Privacy Policy', title.text) AssertionError: 'Tukker.Me Privacy Policy' != u'' Can anyone please help me to figure out where I'm going wrong?? 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.