[web2py] Re: PyCharm license for web2py dev - who wants?

2015-10-14 Thread Luis Valladares
+1. Thanks for the info BTW! El domingo, 11 de octubre de 2015, 14:51:16 (UTC-4:30), Francisco Ribeiro escribió: > > Hello all, > > for those who know PyCharm is a great IDE from JetBrains that provides > free licenses for Open Source projects like web2py ( > https://www.jetbrains.com/buy/opens

[web2py] Re: OperationalError: database is locked

2015-10-14 Thread kenny c
I guess if SQLite cannot handle many concurrent users while writing/reading, should I move to postgres or mongoDB? There will be over 10k rows added every 10mins. Thanks. On Wednesday, October 14, 2015 at 10:03:30 PM UTC-4, kenny c wrote: > > Hi Niphlod, > > Thank you for this information. > >

[web2py] Re: OperationalError: database is locked

2015-10-14 Thread kenny c
Hi Niphlod, Thank you for this information. Could you tell me how you manage to copy new data into db from db2 after finishing the scheduler job? Thank you. On Friday, November 9, 2012 at 10:31:03 AM UTC-5, Niphlod wrote: > > if you can, use a separate db for the scheduler. SQLite doesn't han

[web2py] 0.db naming convention?

2015-10-14 Thread Tom Campbell
I notice there seems to be a convention that application-specific models go in a file named 0.db. Any particular reason for that or inside info that makes it easier to work with later? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Why is https not working (not private) with my implementation of this web2py slice?

2015-10-14 Thread Phillip
I need to use https for a page. I am using the following web2py slice: http://www.web2pyslices.com/slice/show/1507/generate-ssl-self-signed-certificate-and-key-enable-https-encryption-in-web2py I have tried opening web2py with the following line (with and without [-i IP and -p PORT]): pyt

Re: [web2py] how to return nothing

2015-10-14 Thread Dave S
On Wednesday, October 14, 2015 at 5:31:59 PM UTC-7, Dave S wrote: > > > > On Wednesday, October 14, 2015 at 3:27:31 PM UTC-7, Alex Glaros wrote: >> >> does anyone see anything wrong with the update syntax? >> >> def utility_change_column_name(): #used once in a while by programmer. >> Not used b

Re: [web2py] how to return nothing

2015-10-14 Thread Dave S
On Wednesday, October 14, 2015 at 3:27:31 PM UTC-7, Alex Glaros wrote: > > does anyone see anything wrong with the update syntax? > > def utility_change_column_name(): #used once in a while by programmer. Not > used by users. > for r in db.PostalCode: > db(db.PostalCode).update(r.cou

[web2py] Re: _onkeyup / ajax call

2015-10-14 Thread Dave S
On Wednesday, October 14, 2015 at 2:30:03 PM UTC-7, Mark Billion wrote: > > NM. I injected the jquery into the header. > Element selection? /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.googl

[web2py] Re: Import CSV file

2015-10-14 Thread Dave S
On Wednesday, October 14, 2015 at 11:03:02 AM UTC-7, TheFltube wrote: > > Hi folks, glad to join this group > > I tried to import in Web2Py the attached CSV file ( no sensible data, just > fake info for training ;), after having created the corresponding db.py > > It works but only IDs are creat

[web2py] Re: how to return nothing

2015-10-14 Thread Alex Glaros
also, could not get this to work db(db.PostalCode.id > 0).update(PostalCode.countryCode = PostalCode.countryCodeFromGeoNames) -- 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: how to return nothing

2015-10-14 Thread Alex Glaros
hey Leonel, do you see anything wrong with syntax for the parts above the return? this didn't work either: for r in db.PostalCode: db(db.PostalCode.id==r.id).update(countryCode = countryCodeFromGeoNames) db.commit() thanks, Alex -- Resources: - http://web2py.com - http://we

[web2py] Re: how to return nothing

2015-10-14 Thread Leonel Câmara
You can actually return None or an empty string. That said you should use the scheduler instead of you calling it once in a while. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues

[web2py] Re: PyCharm license for web2py dev - who wants?

2015-10-14 Thread Carlos Zenteno
Don't want to burst any bubbles, but, I read somewhere that the free licenses are for the people that work on the Open Source Projects, the developers of the projects, not for the people that use the resulting product. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] Re: PyCharm license for web2py dev - who wants?

2015-10-14 Thread Carlos Costa
+1 2015-10-14 19:41 GMT-03:00 Stuart Rolinson : > +1 > > Thanks, > Stuart > > On Sunday, October 11, 2015 at 12:21:16 PM UTC-7, Francisco Ribeiro wrote: >> >> Hello all, >> >> for those who know PyCharm is a great IDE from JetBrains that provides >> free licenses for Open Source projects like web

[web2py] Re: PyCharm license for web2py dev - who wants?

2015-10-14 Thread Stuart Rolinson
+1 Thanks, Stuart On Sunday, October 11, 2015 at 12:21:16 PM UTC-7, Francisco Ribeiro wrote: > > Hello all, > > for those who know PyCharm is a great IDE from JetBrains that provides > free licenses for Open Source projects like web2py ( > https://www.jetbrains.com/buy/opensource/?product=pycha

Re: [web2py] how to return nothing

2015-10-14 Thread Alex Glaros
does anyone see anything wrong with the update syntax? def utility_change_column_name(): #used once in a while by programmer. Not used by users. for r in db.PostalCode: db(db.PostalCode).update(r.countryCode = r.countryCodeFromGeoNames) return dict() am getting keyword can't be

Re: [web2py] how to return nothing

2015-10-14 Thread Tito Garrido
try: return dict() On Wed, Oct 14, 2015 at 6:43 PM, Alex Glaros wrote: > how to get function to return nothing? > > Goal is simply to avoid pages of records on html page as function runs > > def utility_change_column_name(): #used once in a while by programmer. > Not used by users. > for r in

[web2py] how to return nothing

2015-10-14 Thread Alex Glaros
how to get function to return nothing? Goal is simply to avoid pages of records on html page as function runs def utility_change_column_name(): #used once in a while by programmer. Not used by users. for r in db.PostalCode: db((r.update(r.countryCode = r.countryCodeFromGeoNames)) retu

Re: [web2py] How to import data from csv file in web2py for SQLite database?

2015-10-14 Thread 黄祥
another way around i think you can create a function (e.g. import_data_csv.py) in controller or modules and access it (web browser or terminal) best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - http

[web2py] Re: _onkeyup / ajax call

2015-10-14 Thread Mark Billion
NM. I injected the jquery into the header. On Wednesday, October 14, 2015 at 2:22:39 PM UTC-4, Mark Billion wrote: > > Im pulling my hair out. . . . > > Im using an inline call to the web2py ajax function via the controller as > below: > > ajax_form.element('#Debts_creditor')['_onkeyup'] = >

Re: [web2py] Re: CMS WEB2PY

2015-10-14 Thread Carlos Cesar Caballero Díaz
Yes, it is. Right now is a set of CMS functionalities for web2py apps as posts, pages, comments, tagging and a dashboard (with internationalization support for multilingual sites), in this moment I am working in the authorization system that is very basic. I don't like the most of CMSs becau

Re: [web2py] Re: qrcode

2015-10-14 Thread Michael M
Glad it worked for you! I like the method that I found(just took three working pieces and pushed together) because no static files are generated using StringIO memory and encoding it with Base64. (as far as I know) ;) On Wednesday, October 14, 2015 at 12:11:25 PM UTC-7, Fabiano Almeida wrote:

Re: [web2py] How to import data from csv file in web2py for SQLite database?

2015-10-14 Thread Richard Vézina
:) Richard On Wed, Oct 14, 2015 at 3:00 PM, Dave S wrote: > > > On Wednesday, October 14, 2015 at 11:57:30 AM UTC-7, Richard wrote: >> >> if db(db.table.id > 0).count() == 0: >> db.table2.import_from_csv_file(open(open('mycsv','r')) >> >> So it will be executed only once... >> >> Richard >>

Re: [web2py] Re: qrcode

2015-10-14 Thread Fabiano Almeida
Hi Michael, 2015-10-14 16:00 GMT-03:00 Michael M : > {{=XML(img_tag)}} It worked! Grateful for all! Fabiano. -- 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 Issue

Re: [web2py] Re: qrcode

2015-10-14 Thread Michael M
create a default/qrpage.html insert this {{=XML(img_tag)}} On Wednesday, October 14, 2015 at 10:59:25 AM UTC-7, Fabiano Almeida wrote: > > Hi Michael, > > With your example, return this: > > Qrpage >> StringIO: >> ToQRData:Fabiano Likes MLP:FIMimg:> 0x7f02d1c0a9d0>img_tag:> src="data:image/png;

Re: [web2py] How to import data from csv file in web2py for SQLite database?

2015-10-14 Thread Dave S
On Wednesday, October 14, 2015 at 11:57:30 AM UTC-7, Richard wrote: > > if db(db.table.id > 0).count() == 0: > db.table2.import_from_csv_file(open(open('mycsv','r')) > > So it will be executed only once... > > Richard > You type too fast! /dps > > On Wed, Oct 14, 2015 at 10:48 AM, Prasad

[web2py] Re: How to import data from csv file in web2py for SQLite database?

2015-10-14 Thread Dave S
On Wednesday, October 14, 2015 at 11:03:01 AM UTC-7, Prasad M wrote: > > I am trying to import data from csv in web2py's SQlite databae. > 1) First I have defined table in database. > 2) I wrote db.table2.import_from_csv_file(open(open('mycsv','r')) this > line . > Both steps are in Model. >

Re: [web2py] How to import data from csv file in web2py for SQLite database?

2015-10-14 Thread Richard Vézina
if db(db.table.id > 0).count() == 0: db.table2.import_from_csv_file(open(open('mycsv','r')) So it will be executed only once... Richard On Wed, Oct 14, 2015 at 10:48 AM, Prasad M wrote: > I am trying to import data from csv in web2py's SQlite databae. > 1) First I have defined table in dat

[web2py] Re: Add/Modify Access-Control-Allow-Origin to web2py Service Request

2015-10-14 Thread Leonel Câmara
Do you have crossDomain: true in your jquery ajax request options? -- 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 a

[web2py] Re: Filtering a set of items from a collection issues

2015-10-14 Thread John Smidt
That worked! Thanks for the quick help! On Tuesday, October 13, 2015 at 9:52:47 PM UTC-6, Anthony wrote: > > > > On Tuesday, October 13, 2015 at 12:21:10 PM UTC-4, John Smidt wrote: >> >> Ok, I get how the IS_IN_SET needs a filtered set as the first argument >> but now I'm not sure how to get the

[web2py] _onkeyup / ajax call

2015-10-14 Thread Mark Billion
Im pulling my hair out. . . . Im using an inline call to the web2py ajax function via the controller as below: ajax_form.element('#Debts_creditor')['_onkeyup'] = "ajax('https:.../t2/default/cred_selector', ['creditor'], 'suggestions');" The goal is for this ajax call to control a div that I a

[web2py] How to import data from csv file in web2py for SQLite database?

2015-10-14 Thread Prasad M
I am trying to import data from csv in web2py's SQlite databae. 1) First I have defined table in database. 2) I wrote db.table2.import_from_csv_file(open(open('mycsv','r')) this line . Both steps are in Model. But while displaying data from the same table I am getting repeated rows at each re

Re: [web2py] qrcode

2015-10-14 Thread Carlos Costa
http://www.web2pyslices.com/slice/show/1462/qr-code-builder-with-web2py 2015-10-13 18:04 GMT-03:00 Fabiano Almeida : > Hi all! > > How to dynamically generate qr code in web2py? > > grateful, > > Fabiano. > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - htt

[web2py] Import CSV file

2015-10-14 Thread TheFltube
Hi folks, glad to join this group I tried to import in Web2Py the attached CSV file ( no sensible data, just fake info for training ;), after having created the corresponding db.py It works but only IDs are created for the correct number of rows ( held in CSV ) but no field is actually loaded,

[web2py] Add/Modify Access-Control-Allow-Origin to web2py Service Request

2015-10-14 Thread Ken Smith
I need to create a service that accepts JSON get requests from outside domains. When I try to make the request on an outside domain I get error: "No 'Access-Control-Allow-Origin' header is present on the requested resource." I have the following code in my app's default.py: def call(): r

[web2py] cache.action decorator generates an error

2015-10-14 Thread Krzysztof Socha
Hi, I am trying to configure caching on my site, but it does not seem to work. As soon as I use the cache.action decorator, such as: @cache.action(time_expire=0,cache_model=cache.ram) for any action in the controller, I get an exception thrown with: *'session_' local variable referenced before

Re: [web2py] Custom login form error display

2015-10-14 Thread Krzysztof Socha
> > > Note, if you use form.custom.widget.fieldname in a custom form, you still > get errors displayed automatically (the error is part of the widget > object). The example linked above shows the hiderror option being used. In > that case, you are explicitly suppressing the automatic error disp

Re: [web2py] Re: CMS WEB2PY

2015-10-14 Thread Massimo Di Pierro
Is the CMS you talk about built with web2py? On Tuesday, 13 October 2015 08:17:20 UTC-5, Carlos Cesar Caballero wrote: > > I am working on a site that is builded using custom made CMS, I am > planning to release it to github when it's finished (the cms), right now > you can see the site (work in

Re: [web2py] Re: qrcode

2015-10-14 Thread Fabiano Almeida
Hi Richard, elaphe worked! thank you! How to show a text message with qrcode on same page? Thx 2015-10-13 21:07 GMT-03:00 Richard Vézina : > You can have a look on the side of elaphe : > https://bitbucket.org/whosaysni/elaphe/ > > For most type of code it works... But there were issue with bou

Re: [web2py] Re: qrcode

2015-10-14 Thread Fabiano Almeida
Hi Michael, With your example, return this: Qrpage > StringIO: > ToQRData:Fabiano Likes MLP:FIMimg: 0x7f02d1c0a9d0>img_tag: src="data:image/png;base64,iVBORw0KGgoNSUhEUgAAAQ4AAAEOAQBQysQIAAAB0klEQVR4nO2aQY7cIBBFXwVLs4Qb5Cj4BjnT3MwcZQ4wEl6OBPpZgJ3OIhopTnpsC1YNfouvUulTRbWJT1b99hkBA/nD0rL/ks

Re: [web2py] Re: qrcode

2015-10-14 Thread Fabiano Almeida
Hi Niphlod, I trying to generate qr code with built-in feature, for local use, mobile for reading. thx 2015-10-13 18:20 GMT-03:00 Niphlod : > with any qrcode library or qrcode ondemand service out there ? What did > you try ? > > > On Tuesday, October 13, 2015 at 11:05:23 PM UTC+2, Fabiano Alme

Re: [web2py] Re: qrcode

2015-10-14 Thread Fabiano Almeida
Hi Stifan I installed the semanticwebexample and not found reference to qr code on it. thx 2015-10-13 18:28 GMT-03:00 黄祥 : > i think there is web2py appliances that create some thing like this before > : semanticwebexample > > best regards, > stifan > > -- > Resources: > - http://web2py.com > -

[web2py] Re: qrcode

2015-10-14 Thread Michael M
def qrpage(): #Install Python Modules: (Pillow,qrcode) #https://github.com/lincolnloop/python-qrcode ToQRData = auth.user.username + ' Likes MLP:FIM' import qrcode import StringIO qr = qrcode.QRCode( version=1, error_correction=qrcode.constants.ERROR_COR

[web2py] Re: Oracle drivers.

2015-10-14 Thread Michael M
Has anyone been able to reproduce this? On Thursday, October 8, 2015 at 12:09:45 PM UTC-7, Michael M wrote: > > Thank-you Niphlod! > > On Thursday, October 8, 2015 at 12:08:40 PM UTC-7, Niphlod wrote: >> >> the repo for pydal is the other one no worries though, I linked your >> one in https:/

[web2py] Re: Mod_WSGI deployment problem

2015-10-14 Thread Laurent Lc
It works for me thank you :) Le mercredi 21 janvier 2009 11:35:13 UTC+1, voltron a écrit : > > Hi Massimo! > > thanks for your help. Sadly, that did not work either , another idea? > > Thanks > > On Jan 21, 11:31 am, mdipierro wrote: > > try edit wsgihandler.py and replace this line > > > >

[web2py] Re: Reverse Proxy problem with grid form (bootstrap 3.x)

2015-10-14 Thread Daniel Vogel
I'm still searching for a solution to use auth.wiki behind reverse proxy. Sites with SQLFORM are deformed. I see three capabilities: - auth.wiki fix which eliminate the need of "ProxyHTMLURLMap" - Fix some layout or css code (temporary fix) - wait for next web2py release Am Mittwoch, 9. Sept