[web2py] Re: Query for mutually linked id's

2016-02-10 Thread 'Annet' via web2py-users
Hi Niphlod, Thanks for your reply. I have been trying to get the self-refrence and alias to work, but I got stuck. What i've got sofar is: vertexfrom = db.edg_edge.with_alias('vertexfrom') rows = db((db.edg_edge.toID==8) & (db.edg_edge.fromID==db.vtx_vertex.id))\ .select(db.edg_edge.fromID,

[web2py] Re: Organize translations

2016-02-10 Thread Mirek Zvolský
Massimo, do you have a stable translator for czech language? If yes then N/A, if no, I would like make missing translations. If so, - I think it is good idea to do it in web admin for the welcome app (?), or should I pull from somewhere (?) - where can I push/upload the result. (but maybe somebo

[web2py] web2py included on Synology DSM

2016-02-10 Thread Gerd
Hi! I would like to see web2py as a package for the Synology NAS, so i wrote an inquery to the company at https://www.synology.com/en-global/form/inquiry/feedback If you feel the same i suggest you to fill out the form and tell them that we want it ;-) Thanks, Gerd -- Resources: - http://we

[web2py] Re: web2py included on Synology DSM

2016-02-10 Thread Jim S
Done On Wednesday, February 10, 2016 at 7:32:24 AM UTC-6, Gerd wrote: > > Hi! > > I would like to see web2py as a package for the Synology NAS, so i wrote > an inquery to the company at > https://www.synology.com/en-global/form/inquiry/feedback > > If you feel the same i suggest you to fill out

Re: [web2py] Re: Organize translations

2016-02-10 Thread Carlos Cesar Caballero Díaz
Hi Massimo, the Idea could be something like T('my string to translate', 'place_to_find_it') so it will look directly to the needed translation files (as other frameworks do). I was thinking that some kind of "production mode" that could put model files and translations in memory like the conf

[web2py] Re: web2py included on Synology DSM

2016-02-10 Thread xmarx
+1 10 Şubat 2016 Çarşamba 15:32:24 UTC+2 tarihinde Gerd yazdı: > > Hi! > > I would like to see web2py as a package for the Synology NAS, so i wrote > an inquery to the company at > https://www.synology.com/en-global/form/inquiry/feedback > > If you feel the same i suggest you to fill out the for

Re: [web2py] Re: ubuntu web2py

2016-02-10 Thread Jim S
I got this working! Here is what I did. 1. Run the normal web2py installation script for nginx/ubuntu 2. sudo nano edit /etc/systemd/system/emperor.uwsgi.service Add these lines [Unit] Description = uWSGI Emperor After = syslog.target [Service] ExecStart = /usr/local/bin/uwsgi --ini /etc/uwsgi

Re: [web2py] IMPORTANT - WEB2PY CONSULTING

2016-02-10 Thread Carlos Correia
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Please add me. URL: http://memoriapersistente.pt Country: Portugal The page is a bit outdated and shall be updated soon... Thanks, Carlos Correia On 15-02-2015 22:21, Massimo Di Pierro wrote: > We need to update the list of companies that pro

[web2py] Re: web2py included on Synology DSM

2016-02-10 Thread Ron Chatterjee
+1 On Wednesday, February 10, 2016 at 8:44:46 AM UTC-5, xmarx wrote: > > +1 > > 10 Şubat 2016 Çarşamba 15:32:24 UTC+2 tarihinde Gerd yazdı: >> >> Hi! >> >> I would like to see web2py as a package for the Synology NAS, so i wrote >> an inquery to the company at >> https://www.synology.com/en-glob

Re: [web2py] Re: web2py included on Synology DSM

2016-02-10 Thread Fabiano Almeida
+1 2016-02-10 13:16 GMT-02:00 Ron Chatterjee : > +1 > > > On Wednesday, February 10, 2016 at 8:44:46 AM UTC-5, xmarx wrote: >> >> +1 >> >> 10 Şubat 2016 Çarşamba 15:32:24 UTC+2 tarihinde Gerd yazdı: >>> >>> Hi! >>> >>> I would like to see web2py as a package for the Synology NAS, so i wrote >>> a

Re: [web2py] Re: web2py included on Synology DSM

2016-02-10 Thread Nico de Groot
Done. -- 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

[web2py] Re: web2py included on Synology DSM

2016-02-10 Thread Jim S
FYI - I received a reply back from Synology. His reply: Thank you for your message and interest in improving Synology products. There are threads/blogs online where people have performed a custom installation of web2py on our products, and there appears to be Docker

[web2py] Unittest Web2py with Test Runner Error database is locked

2016-02-10 Thread Maelle Taurand
Hy, I want to make unit test with web2py. I follow this page : https://pythonhosted.org/web2py_utils/test_runner.html. Is Web2py Test Runner always a good way for unittesting ? After running execute_tests.py, i have got thie result and an error (logged in report file) *Resu

[web2py] Re: Unittest Web2py with Test Runner Error database is locked

2016-02-10 Thread Dave S
On Wednesday, February 10, 2016 at 11:53:27 AM UTC-8, Maelle Taurand wrote: > > > Hy, > > I want to make unit test with web2py. > > I follow this page : > https://pythonhosted.org/web2py_utils/test_runner.html. > > Is Web2py Test Runner always a good way for unittesting ? > > > After runnin

[web2py] Re: web2py included on Synology DSM

2016-02-10 Thread 黄祥
done -- 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 u

[web2py] Is there any reason to auto include an id field in a SQLFORM.factory?

2016-02-10 Thread Alfonso Serra
Its not big deal but yep, thats the question. The auto id field is messing around with custom forms since i have to calculate the amount of "defined" fields to create the proper html output (html rows or columns). This is the solution im taking but i dont know if theres gonna be a problem dow

[web2py] Check to see if a field is in another table in a computed field

2016-02-10 Thread Greg White
Want a computed field to show whether or not a field value exists in another table started with this... db.define_table( 'inventory', Field('name'), Field('qty', label='Quantity'), Field('MatSize',label='Material Size'), format = '%(name)s') db.define_table( 'POrequest'

[web2py] Getting values from database

2016-02-10 Thread snehalashtekar1234
How to get the database stored values in HTML form -- 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 t

[web2py] Memcache, MEMDB tcp connections not closing

2016-02-10 Thread Russ M
I use memcache and MEMDB for session storage and caching. The CentOS server is setup with an apache modwsgi process group, setup through the wsgihandler.py. I establish the MemcacheClient and MEMDB as the cache and session db in my app's models/db.py file. It appears that when requests have

[web2py] How to insert data from controller to database

2016-02-10 Thread prashant joshi
def insert(): user=request.vars.usersignup email=request.vars.emailsignup pas=request.vars.passwordsignup i want to add these fields with values in database dynamically? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Sourc

[web2py] python Script

2016-02-10 Thread snehalashtekar1234
can we write the python script inweb2py -- 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

[web2py] background color of block sidebar

2016-02-10 Thread rajjmatthur
playing with blocks. I have {{block right_sidebar}} {{end}} I would like to set the background color different in the sidebar area comparing my main page. Any help from the community? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2

[web2py] Re: SQLFORM buttons are misaligned

2016-02-10 Thread Massimo Di Pierro
Thank you! Fixed in trunk On Tuesday, 9 February 2016 14:25:52 UTC-6, SanDiego wrote: > > When used with buttons as follows, SQL form misses the offset causing the > buttons misplaced towards left (see buttons-misaligned.png file). > > buttons = [ > TAG.button(T('Save'),_type="submit"

[web2py] Re: Displalay a form in light box or pop up window in view

2016-02-10 Thread Massimo Di Pierro
Bootstrap3 has built-int modals: https://nakupanda.github.io/bootstrap3-dialog/ You can but {{=form}} in the body of the modal. On Tuesday, 9 February 2016 14:26:05 UTC-6, billmackalis...@gmail.com wrote: > > Hello, A new user migrating from Django to web2py and absolutely loving > it. A quick q

[web2py] Re: How to set default country in dropdown list

2016-02-10 Thread Massimo Di Pierro
I attached a file with a list of all countries On Tuesday, 9 February 2016 19:59:41 UTC-6, Dave S wrote: > > > > On Tuesday, February 9, 2016 at 5:10:03 PM UTC-8, Winter Kryz wrote: >> >> Thanks for the answers >> I tried what xmarx said but it didn't work >> > > What errors did you get? > > >

Re: [web2py] Re: Organize translations

2016-02-10 Thread Massimo Di Pierro
I guess it is possible. It seems to me it complicates things but perhaps I just did not run into your use case. We will discuss on the devlopers list, feel free to join. On Wednesday, 10 February 2016 07:41:42 UTC-6, Carlos Cesar Caballero wrote: > > Hi Massimo, the Idea could be something like

[web2py] Re: Is there any reason to auto include an id field in a SQLFORM.factory?

2016-02-10 Thread Massimo Di Pierro
No reason. It is an implementation issue. The new Form logic that we are working on to replace SQLFORM will not have that. On Wednesday, 10 February 2016 15:00:32 UTC-6, Alfonso Serra wrote: > > > Its not big deal but yep, thats the question. > > The auto id field is messing around with custom fo

[web2py] Re: Getting values from database

2016-02-10 Thread Dave S
On Wednesday, February 10, 2016 at 2:01:52 PM UTC-8, snehalash...@gmail.com wrote: > > How to get the database stored values in HTML form > The basic answer is that a controller extracts the values, and a view displays them. (There is also a model involved that describes the database.) Bot

[web2py] Re: Check to see if a field is in another table in a computed field

2016-02-10 Thread Dave S
On Wednesday, February 10, 2016 at 2:01:52 PM UTC-8, Greg White wrote: > > Want a computed field to show whether or not a field value exists in > another table > I'm not sure that is the right approach. I think that the standard validator IS_IN_DB() is what you want, instead. http://web2py.

[web2py] Re: Is there anyway to disable search and export sections in SQLFORM.grid

2016-02-10 Thread SanDiego
This is what I was looking for. It is in the book but for some reason I missed it: http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-grid-signature Thanks. On Tuesday, February 9, 2016 at 6:37:37 PM UTC-8, Anthony wrote: > > SQLFORM.grid(..., searchable=False, csv=False)

[web2py] Re: How to insert data from controller to database

2016-02-10 Thread Dave S
On Wednesday, February 10, 2016 at 2:01:52 PM UTC-8, prashant joshi wrote: > > def insert(): > user=request.vars.usersignup > email=request.vars.emailsignup > pas=request.vars.passwordsignup > i want to add these fields with values in database dynamically? > In your controller, you'd

[web2py] Re: python Script

2016-02-10 Thread Dave S
On Wednesday, February 10, 2016 at 2:01:52 PM UTC-8, snehalash...@gmail.com wrote: > > can we write the python script inweb2py > There are 2 answers to this. Web2Py depends on a Python installation. (In Windows, it's own copy is packaged with Web2py). You can run ordinary Python scripts in t

[web2py] Re: Displalay a form in light box or pop up window in view

2016-02-10 Thread billmackalister
Thank you for the answer Massimo. I did this like you said to put the form in the body in index/popup.html however, it didn't pop up like the example in the link above. Instead I got it in the same browser. I am guessing my implementation is wrong. × Modal title

[web2py] Re: How to set default country in dropdown list

2016-02-10 Thread Winter Kryz
I tried Field('nationality', requires=IS_IN_SET(nationalities), default='United States') but it gives me the following error name 'nationalities' is not defined I have to mention that I have already load all the nationalities names into a table called 'Nationalities' so what I need is only

[web2py] Re: Spreadsheet.py documentation and status

2016-02-10 Thread Henk huisman
Nice combo! web2py and w2ui. Looks great. Going to try it. Thanks for the link. Op maandag 8 februari 2016 23:35:41 UTC-3 schreef Rimantas Nedzinskas: > > Try this: > >> http://w2ui.com/web/demos/#!combo/combo-3 >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: How to set default country in dropdown list

2016-02-10 Thread Dave S
On Wednesday, February 10, 2016 at 4:57:58 PM UTC-8, Winter Kryz wrote: > > > I tried > Field('nationality', requires=IS_IN_SET(nationalities), default='United > States') > > but it gives me the following error > > name 'nationalities' is not defined > You need to define the set "nationalit

[web2py] Re: Displalay a form in light box or pop up window in view

2016-02-10 Thread Massimo Di Pierro
I see you want a different window, not a modal. then you have to put the form logic in its own controller action and call it from js click me On Wednesday, 10 February 2016 18:00:44 UTC-6, billmackalis...@gmail.com wrote: > > Thank you for the answer Massimo. I did this like you said to put th

[web2py] Re: markmin.js

2016-02-10 Thread Massimo Di Pierro
and the link: https://github.com/mdipierro/markmin.js On Wednesday, 10 February 2016 21:55:06 UTC-6, Massimo Di Pierro wrote: > > I have a new version of markmin.js I recommend this over the python > implementation. It is better to render on the client because oembed does > not require setting

[web2py] markmin.js

2016-02-10 Thread Massimo Di Pierro
I have a new version of markmin.js I recommend this over the python implementation. It is better to render on the client because oembed does not require setting up server side caching. The JS version allows sanitized HTML. Also the heavy lifting is moved to the client. It is not 100% compatible

[web2py] Re: web3py?

2016-02-10 Thread Ron Chatterjee
This may be a off topic, and I am not a pytho expert by any means, that said...wondering for web3py, are we still going to have the utf-8 and object format? I asked because somewhere I read python 3 support both string and utf-8. Data structure can be much more readable and easy to get into wit

[web2py] Re: Probably very naive question from new user

2016-02-10 Thread Tom Campbell
www.pyguy.com has a few beginner-level tutorials that probably answer those questions -- 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 m