[web2py] Re: Web2py sessions table does not exist?

2014-07-24 Thread Mandar Vaze
Cool I learnt a lot from this thread. I used to delete "everything" from both DB as well as applications/myapp/databases folder I think later contains *.table files. I didn't know that I can remove individual *.table files. Also did not know about fake_migration. Gotta try it sometime. In pro

[web2py] Re: error(10053, 'An established connection was aborted by the software in your host machine')

2014-07-24 Thread Dmitry Ermolaev
SOLVED! I update mySQL to 5.6.19 vers! понедельник, 14 июля 2014 г., 15:06:03 UTC+4 пользователь Copper Lark написал: > > > Versionweb2py™Version 2.9.5-trunk+timestamp.2014.03.29.21.54.41Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > 14. > 15. > > Traceback (m

[web2py] Re: Help me stop bashing me head on keyboard...

2014-07-24 Thread Jesse Ferguson
Oh and the conditional problem is that I would like to populate items, Like if you chose a city that's in the database it would auto populate the state input because the city table has a reference to the state.. I would also like to keep the auto-complete functionality (if not in db add to db) f

[web2py] Re: Help me stop bashing me head on keyboard...

2014-07-24 Thread Jesse Ferguson
On Thursday, July 24, 2014 6:12:43 PM UTC-7, Anthony wrote:def myfunction(): if request.post_vars._autocomplete_name_aux and not request.post_vars. category: request.post_vars.category = db.category.insert(name=request. post_vars._autocomplete_name_aux) return dict(form=SQLFORM(db

[web2py] Re: Help me stop bashing me head on keyboard...

2014-07-24 Thread Anthony
On Thursday, July 24, 2014 8:45:39 PM UTC-4, Jesse Ferguson wrote: > > I actually went that route and then realized it would only work for one > field, I would Like to have a few fields with the autocomplete/add > Why is that? Do several autocomplete fields share the same field name of the displ

[web2py] Re: Help me stop bashing me head on keyboard...

2014-07-24 Thread Jesse Ferguson
I actually went that route and then realized it would only work for one field, I would Like to have a few fields with the autocomplete/add, I would also like the form to have some conditional select boxes, and some fields that would be auto-filled if some condition is met... I'm starting to won

[web2py] Re: create and update in one form

2014-07-24 Thread Carlos Hanson
This is one of the solutions I was considering as I tried to formulate my question. I hadn't found that particular section, but I remembered reading something about dealing with multiple tables. One issue that doesn't solve is an ajax call to add to a separate table. In the case of CKEditor, if

[web2py] Re: create and update in one form

2014-07-24 Thread Carlos Hanson
I have only skimmed it. My concern is for one record at a time rather than a grid of multiple records, but I will review it in more detail to see if I can apply it. Thanks. Carlos On Thursday, July 24, 2014 3:36:57 PM UTC-7, 黄祥 wrote: > > had you already try SQLFORM.grid?? > ref: > > http://web

[web2py] Re: Help me stop bashing me head on keyboard...

2014-07-24 Thread Anthony
If it's just a single item being inserted and you can use the autocomplete widget, this solution might be a simple approach: https://groups.google.com/d/msg/web2py/KoL58-IjNT4/2aZrXfp5ECcJ On Thursday, July 24, 2014 7:41:30 PM UTC-4, Jesse Ferguson wrote: > > Thanks Anthony, I just didn't know w

[web2py] Re: Help me stop bashing me head on keyboard...

2014-07-24 Thread Jesse Ferguson
Thanks Anthony, I just didn't know what search terms to use, this video someone linked is the functionality I am looking for. However It looks like some of the attempts are pretty outdated so I will attempt to re-write something. If successful I will share w

[web2py] Re: create and update in one form

2014-07-24 Thread Anthony
Have you looked at http://web2py.com/books/default/chapter/29/07/forms-and-validators#One-form-for-multiple-tables? Anthony On Thursday, July 24, 2014 6:31:11 PM UTC-4, Carlos Hanson wrote: > > Greetings, > > Using plugin_attachments as an example, it defines a table like the > following: > > d

[web2py] Re: create and update in one form

2014-07-24 Thread 黄祥
had you already try SQLFORM.grid?? ref: http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-grid best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2

[web2py] create and update in one form

2014-07-24 Thread Carlos Hanson
Greetings, Using plugin_attachments as an example, it defines a table like the following: db.define_table('plugin_attachments_attachment', Field('tablename', readable=False, writable=False), Field('record_id', 'integer', readable=False, writable=False), [...]) That suggests that I

[web2py] Re: Help me stop bashing me head on keyboard...

2014-07-24 Thread Anthony
The IS_IN_DB validator will produce a select widget unless you (a) put it inside a list (i.e., requires=[IS_IN_DB(...)]) or (b) explicitly specify an alternative widget for the field via the "widget" argument. As for the specific functionality you want, that's not built into web2py, so you will

Re: [web2py] LDAP Auth

2014-07-24 Thread Shane Tzen
On Thu, Dec 19, 2013 at 4:30 PM, Maggs wrote: > > Yes secure ldap is causing a lot of problems. I hope it gets sorted out > eventually. For now I'm having to modify the framework for my needs. Somewhat related issue here. Using a self-signed cert and especially for testing, it seems expedient t

[web2py] Help me stop bashing me head on keyboard...

2014-07-24 Thread Jesse Ferguson
I have a Form that will submit to multiple tables, most items reference items.. For the life of me I cannot figure out how to make the form item not a select box (default behavior). I would like a input/suggest input field and if the input is not in db I would like to add it to DB. If it is in

[web2py] Re: How to conclude posts on one page sorted by creation date in separate blocks.

2014-07-24 Thread Dave S
On Wednesday, July 2, 2014 10:46:21 PM UTC-7, Капылов Данил wrote: > > hello > > How to conclude posts on one page sorted by creation date in separate > blocks. > > Example: unit - Today, the unit - This week, block - Long > I'm way behind on my reading, thanks to other projects, so I apologi

[web2py] Re: Can not import copy_reg

2014-07-24 Thread Richard
I am hosted at JustHost, who has the option on installing Nginx. I'll try that for a better infrastructure. On Thursday, July 24, 2014 9:21:24 AM UTC+2, Massimo Di Pierro wrote: > > I agree with you that Apache is not a good solution any more. Nginx for > example is a much better solution. Neve

[web2py] Re: Multiple Routes - Same App

2014-07-24 Thread 'Michael Gheith' via web2py-users
I plan on shoving this in the app specific routes.py - so it shouldn't mess with the other apps. I tried your code, but it didn't work as expected. You have the right idea though in regards to what I'm trying to do lyn2py. I want to literally shove anything in front of app/controller/function

[web2py] What can cause some of my extra fields to be missing from auth.user?

2014-07-24 Thread Leonel Câmara
Stupid question time. What can cause some of my extra fields to be missing from auth.user? They are only missing from auth.user if I do db.auth_user[auth.user_id] the fields are there. Example of an extra field I have that doesn't show up in auth.user Field('cropped','upload', uploadseparate=T

[web2py] oncreate callback inside a component

2014-07-24 Thread José L .
Hi, I'm using load to put two sqlform.grid inside a page in an application. I have added ... editable=True, create=True, searchable=False, onvalidation=check_documento, oncreate = check_documento, onupdate = check_documento, formname

[web2py] Re: Multiple Routes - Same App

2014-07-24 Thread lyn2py
I am not exactly sure I understand your question, and I don't know how your code looks like, but you could try this: routes_in = ( ('/$anything/$a/$c/$f', '/$a/$c/$f/$anything') ) If you are going to have multiple apps though, this routing system will most likely break

[web2py] Bootstrap MENU (li_class)

2014-07-24 Thread Louis Amon
I'm trying to build a MENU styled with Boostrap. I'd like my items to have the class "btn". How can I do that in web2py ?? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (

[web2py] Re: Multiple Routes - Same App

2014-07-24 Thread 'Michael Gheith' via web2py-users
That's a great idea lyn2py, but I expect to run multiple applications in one web2py instance. I can't have all my applications with the name of sam unfortunately. I just discovered that I can add a URL prefix of "fff" with the following code: routes_in = ( ('/fff/$a/$c/$f', '/$a/

[web2py] Re: The scheduler eats Windows .... (lol)

2014-07-24 Thread Tim Richardson
I used nssm and added four instances of the appname to the command line to create multiple workers. -- 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

[web2py] Re: Multiple Routes - Same App

2014-07-24 Thread lyn2py
In that case, Make sam your app's name, client1 and 2 can be the functions within the controller, or separate controllers for each client. If they share functions, you could shift your function's logic outside (into a module). On Thursday, July 24, 2014 11:50:28 PM UTC+8, Michael Gheith wrot

[web2py] Re: Multiple Routes - Same App

2014-07-24 Thread 'Michael Gheith' via web2py-users
Hello lyn2py, Thank you for your response. Unfortunately it is necessary for me to have the URL prefix of /sam/. I would imagine your strategy would work if it was possible to dynamically add a URL prefix, but I don't think there is a way to do that. Anyone else have any ideas? Massimo? Be

[web2py] Re: Bootstrap datepicker plugin

2014-07-24 Thread Leonel Câmara
New version supporting bootstrap picker options (weeekStart, viewMode, minViewMode) except for format which is automatically determined by w2p_ajax_date. This version is quite useful for stuff like birth dates where you want people to be able to choose the year easily. -- Resources: - http://

Re: [web2py] Re: web2py vs others. Status of 2014

2014-07-24 Thread António Ramos
@Massimo, You could have a dal.js generated automaticaly for the client to access the databases. This is how deployd does it! (they autogenerate dpd.js for the client) http://docs.deployd.com/docs/collections/accessing-collections.md http://docs.deployd.com/docs/collections/reference/dpd-js.md I

[web2py] file transfer from client to server with @service.soap and store on server

2014-07-24 Thread Serge Bourgeois
Hello, I am looking for support to interface 2 web2py applications via @service.soap app1: is running on portable device, has a table with a field (Field('f_assest', type 'upload')), used to store files such as jpeg, zip or pdf files. This app1 can run on stand alone, not connected device, but, w

[web2py] Re: web2py vs others. Status of 2014

2014-07-24 Thread lyn2py
Hi Massimo, I have been reading up a bit on the direction of JS and wondering if this porting of helper system and form generation -- will it be for web2py or it will be a new feature for web3py? Will it be dependent on any particular JS libraries? On Thursday, July 17, 2014 7:35:16 PM UTC+8,

[web2py] Re: The scheduler eats Windows .... (lol)

2014-07-24 Thread Niphlod
don't know the exact way you scheduled it, but as a rule of thumb a single worker process should be aligned with the single service installed. On Thursday, July 24, 2014 12:34:19 PM UTC+2, Tim Richardson wrote: > > I recently decided to add multiple workers to one of my scheduler > services. Re

[web2py] Re: Is it possible to step through scheduler task code in debugger?

2014-07-24 Thread Niphlod
NB: shell and scheduler are pretty much the same scheduler and web not so much, although models are the same. On Thursday, July 24, 2014 12:44:56 PM UTC+2, Tim Richardson wrote: > > > > On Thursday, July 24, 2014 7:41:03 PM UTC+10, Niphlod wrote: >> >> it's a "general issue" with debugging re

Re: [web2py] Returning grid rows where is_active == False

2014-07-24 Thread Vinicius Assef
If you're using auth.signature, you should ignore common filters. On Thu, Jul 24, 2014 at 2:43 AM, Henry Nguyen wrote: > I'm using SQLFORM.grid() to display a list of users from db.auth_user for an > administrative interface. I'd like to display deleted users as well as > active users. Is there a

[web2py] Re: Decimal( error )

2014-07-24 Thread Massimo Di Pierro
This 'Decimal(16.8' is not a valid field type. Did you mean 'decimal(16,8)' ? On Thursday, 24 July 2014 06:02:41 UTC-5, Dmitry Ermolaev wrote: > > in db: > ... > Field(ddd, 'Decimal(16.8')), > ... > > than in admin db update > http://127.0.0.1:8000/polza/appadmin/update/db/goods/9 > > I see: >

[web2py] Re: google ndb

2014-07-24 Thread Massimo Di Pierro
Yes it does. For example: db = DAL('google:datastore')# for google app engine datastore db = DAL('google:datastore+ndb') # for google app engine datastore with ndb

[web2py] Re: load data for front end

2014-07-24 Thread Massimo Di Pierro
I admit I do that. Otherwise you can do var t; jQuery.getJSON('someaction.json').then(function(data){t=data;}); and def someaction(): return response.json({'data':'value'}); The main problem I have is that of building URLs in static ractive pages since there is no URL(...) function. On W

[web2py] Decimal( error )

2014-07-24 Thread Dmitry Ermolaev
in db: ... Field(ddd, 'Decimal(16.8')), ... than in admin db update http://127.0.0.1:8000/polza/appadmin/update/db/goods/9 I see: ddd: 0E-8.00 clicl 'Update' and see error: Enter a number between -1e+10 and 1e+10 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - htt

[web2py] Re: Is it possible to step through scheduler task code in debugger?

2014-07-24 Thread Tim Richardson
On Thursday, July 24, 2014 7:41:03 PM UTC+10, Niphlod wrote: > > it's a "general issue" with debugging remote processing > http://pydev.org/manual_adv_remote_debugger.html > > BTW: if you launch the function in the shell, you won't have access to the > inner workings of the scheduler but you'll

[web2py] The scheduler eats Windows .... (lol)

2014-07-24 Thread Tim Richardson
I recently decided to add multiple workers to one of my scheduler services. Restarting the scheduler service in this case appears to add another N worker processes because the original worker processes aren't terminated when the supervisor process dies. I wondered why the load on MS SQL server

[web2py] Re: Is it possible to step through scheduler task code in debugger?

2014-07-24 Thread Niphlod
it's a "general issue" with debugging remote processing http://pydev.org/manual_adv_remote_debugger.html BTW: if you launch the function in the shell, you won't have access to the inner workings of the scheduler but you'll see what our function/module/etc is doing the env in which tasks are

[web2py] Re: Bootstrap datepicker plugin

2014-07-24 Thread Leonel Câmara
I'm open to extending this plugin so it accepts some settings, one of those settings could be - html5_if_available - and then, in the javascript, I could use something like Modernizr.inputtypes.date to check for browser support. Otherwise I believe html5forms.js or webshim does what you want bu

[web2py] Re: Bootstrap datepicker plugin

2014-07-24 Thread Massimo Di Pierro
html5 has and . web2py does not use them because very few browsers support them. I am wondering is there is js library that adds support for those input types in browsers that do not support them. On Wednesday, 23 July 2014 19:05:44 UTC-5, Leonel Câmara wrote: > > Niphlod if you look at my plu

[web2py] Re: Can not import copy_reg

2014-07-24 Thread Massimo Di Pierro
I agree with you that Apache is not a good solution any more. Nginx for example is a much better solution. Nevertheless some people may not have a choice. On Wednesday, 23 July 2014 14:45:45 UTC-5, Niphlod wrote: > > I seem to be the only "advocate" for ditching apache always and before > anyth

[web2py] Re: secure password hashing on web2py

2014-07-24 Thread 黄祥
glad to hear that, thank you very much for the information, anthony 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 thi

[web2py] load data for front end

2014-07-24 Thread chuan137
Hi All, For quick and dirty develop, is it a good idea to do var t=<%=XML(response.json(rows))%> in template page? Dear Massimo, can you share how do you use Ractivejs usually? For big project, I would divide front end codes from server end. But how about for simple page, where I only nee

[web2py] Is it possible to step through scheduler task code in debugger?

2014-07-24 Thread Stephen Weiss
I want to use a debugger (winpdb) to step through a scheduler module. However, when I run the scheduler in the debugger (-K option) and I set a breakpoint in my module and submit a job to the scheduler_task table, I get debug output (prints) in the console, but the breakpoint is never hit. The

[web2py] google ndb

2014-07-24 Thread Alan Williams
I have read through a few post and I have still not yet been able to determine if web2py supports ndb. The Google/NoSQL support in the DAL is for the GQL, which Google states has been replaces by ndb: - *"DB Datastore:* DB Datastore framework has been replaced with the NDB Datastore fra

[web2py] How do you use multiselection with Web2py and JQuery's Datatables?

2014-07-24 Thread Philip
I am using python 2.7.6 to write a web crawling program with web2py as the user interface. A large amount of UPCs (used to find the items on the websites) are stored in an SQLite database, which is then displayed on the main html page via the JQuery Datatables plugin. The user can then sel

[web2py] Re: simplify parse_as_rest pattern?

2014-07-24 Thread chuan137
Aha, I was not followed it yet. Quick question, would it be able to filter one-to-many or many-to-many relationship? On Wednesday, July 23, 2014 11:20:41 AM UTC+2, Massimo Di Pierro wrote: > > Actually I wanted to deprecate it in favor of the new hypermedia API. > > On Tuesday, 22 July 2014 07:4