[web2py] Fields and button in single row in SQLFORM Factory

2017-07-30 Thread Amit Kumar Modak
Hello, I have created a form using Form Factory, which has two fields. form=SQLFORM.factory(Field('Name','string'), Field('Age', 'number')) Is there any by which both the fields and the submit button can be made to appear in a single row? Thanks,

[web2py] Re: passing additional variables in selectable function of sqlform.grid

2017-07-23 Thread Amit Kumar Modak
Thanks Anthony. I tried that as well, but it didn't work. Amit -- 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 becaus

[web2py] Re: passing additional variables in selectable function of sqlform.grid

2017-07-22 Thread Amit Kumar Modak
I tried this but it didn't work. form=SQLFORM.grid(db.Student, editable=False, deletable=False, showbuttontext=False, selectable = [('Assign', lambda ids : assign(ids, form))], csv=F

[web2py] passing additional variables in selectable function of sqlform.grid

2017-07-21 Thread Amit Kumar Modak
Hello, I have created a form with sqlform.grid and added an additional sqlform.factory to the same form. The sqlform.grid has a selectable function where I want to pass the value of sqlform.factory fields. Please suggest how this can be done. Regards, Amit -- Resources: - http://web2py.com

[web2py] Re: Customising Calendar widgets in Start Date and End date of SmartGrid

2017-01-14 Thread Amit Kumar Modak
Hello, Has anybody solution to this? Regards, Amit On Friday, January 13, 2017 at 3:46:14 PM UTC+5:30, Amit Kumar Modak wrote: > > Hello, > > I am using Smartgrid in which there are two date fields Start Date and End > Date. > Is it possible to make in Start Date field Ca

[web2py] Customising Calendar widgets in Start Date and End date of SmartGrid

2017-01-13 Thread Amit Kumar Modak
Hello, I am using Smartgrid in which there are two date fields Start Date and End Date. Is it possible to make in Start Date field Calendar widget only dates ahead of today enabled and in End Date only dates ahead of date selected in Start Date is enabled. Regards, Amit -- Resources

[web2py] global name 'web2py_extract' is not defined

2016-12-09 Thread Amit Kumar Modak
The following line of code is giving error global name 'web2py_extract' is not defined response.flash=web2py_extract('month', db.Player.DateOfBirth) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.

[web2py] Difference of two date field in years

2016-12-09 Thread Amit Kumar Modak
How to get the difference of two date field in years. dateutil.relativedelta.relativedelta is not working as it is not able to recognise date fields as date. Thanks, Amit -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code

[web2py] Non-Editable field in SQLFORM

2016-12-09 Thread Amit Kumar Modak
Hello, How can I make a field non-editable in SQLFORM, while it should be allowed to take a value in insert. Regards, Amit -- 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] web2py framework as iOS app backend

2015-02-25 Thread Amit Kumar
, Flask and Web2Py... based on the documents it appears that web2py is a good fit. I wanted to check in the group if anyone has used web2py for iOS backend. These are going to be native iOS and Android apps. thanks for your time. amit -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Cassandra Support

2013-10-16 Thread Amit Saharana
Hi, just for information, does web2py support Cassandra Database. I didn't get any specific information about it through search engines. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/i

Re: [web2py] Re: Converting Field of a SQLFORM.grid to local timezone of a user.....

2013-02-12 Thread Amit
Can we use "represent" callback in case of hugh number of rows(lets say 2 or more rows is there in db), will it not be causing to slow down the whole process, means, while converting utc time to target timezone's time one by one for each row and then displayed to UI using SQLFORM.grid()? Pleas

[web2py] How to use web2py confirmation form ?

2012-11-21 Thread Amit
Hi, I have Delete button on SQLFORM.grid and upon clicking on it , it should popup confirmation dialog before deleting the records and once user click on OK , it should delete the records. For that purpose I used web2py confirmation form but it is not working. please check below the code : def

[web2py] Re: Set: no tables selected

2012-11-21 Thread Amit
Fixed :). using smart_query: db.smart_query([db.status],query).delete() where query is in string format. On Wednesday, 21 November 2012 15:23:44 UTC+5:30, Amit wrote: > > I have done slight changes in the code and its working for select() > statement but still facing problem in case

[web2py] Re: Set: no tables selected

2012-11-21 Thread Amit
ted* Same applies for delete() statement, even for delete we can't specify the database table name as a parameter like select(). On Wednesday, 21 November 2012 12:01:08 UTC+5:30, Amit wrote: > > I have added button "Delete" beside Clear button on SQLFORM.grid and when > user

[web2py] Set: no tables selected

2012-11-20 Thread Amit
I have added button "Delete" beside Clear button on SQLFORM.grid and when user selects query and click on it , I am passing the query to my controller function and using regular expression I just prepending "db." and changing "=" to "==" and passing the query to the db() function but it throws

Re: [web2py] Re: Unable to call the onclick on my custom button on SQLFORM.grid

2012-11-20 Thread Amit
: > > > On Tuesday, November 20, 2012 10:19:25 AM UTC+1, Amit wrote: >> >> If I use A instead of button then its calling perfectly but i have to >> show Delete as a button not as a link. >> > > Style the A as a button. With bootstrap's included just add a clas

Re: [web2py] Re: Unable to call the onclick on my custom button on SQLFORM.grid

2012-11-20 Thread Amit
-**delete",_type="button",_href=U**RL('test')) > > > On Tuesday, November 20, 2012 6:27:18 AM UTC+1, Amit wrote: >> >> Thanks Niphold for sharing the example code, but still it is not working >> means upon clicking on the "Delete"

[web2py] Re: Unable to call the onclick on my custom button on SQLFORM.grid

2012-11-19 Thread Amit
I assume that just going to the "test" function and return back would not > be enough ? (i.e. a simple _href=URL('test') on that button) > > On Monday, November 19, 2012 2:56:36 PM UTC+1, Amit wrote: >> >> upon clicking the button , I need to make query

[web2py] Re: Unable to call the onclick on my custom button on SQLFORM.grid

2012-11-19 Thread Amit
upon clicking the button , I need to make query to db and delete the records... On Monday, 19 November 2012 19:23:54 UTC+5:30, Niphlod wrote: > > the _onclick parameter is "translated" to just a plain onclick attribute > of the tag you're using. > > When you do in HTML mylink nothing will > hap

[web2py] Re: Unable to call the onclick on my custom button on SQLFORM.grid

2012-11-19 Thread Amit
Could you elaborate more on this with some example code? On Monday, 19 November 2012 19:13:58 UTC+5:30, Niphlod wrote: > > _onclick expects a javascript fragment to be executed. > > On Monday, November 19, 2012 2:40:24 PM UTC+1, Amit wrote: >> >> Hi, >> I have

[web2py] Unable to call the onclick on my custom button on SQLFORM.grid

2012-11-19 Thread Amit
Hi, I have added one custom button after *Search* and *Clear* buttons of SQLFORM.grid but unable to associate the action onto it, onclick is not getting called.Please see below the code: grid = SQLFORM.grid(db.test_table,deletable=True) grid[0][1][1].components = [ TAG.button('testbutt

Re: [web2py] Re: Getting error near "interval_time": syntax error

2012-11-14 Thread Amit
db,"date('now','-interval_time minutes') > updated_on")* it returns nothing. So can you please help me out write the above query in Sqlite. Thanks, Amit On Wed, Nov 14, 2012 at 3:36 PM, Niphlod wrote: > > Il giorno mercoledì 14 novembre 2012 09:51:43 UTC+1, Amit

[web2py] Getting error near "interval_time": syntax error

2012-11-14 Thread Amit
del self.db._timings[:-TIMINGSSIZE] return ret Variables a ('SELECT status.serial_no, status.name, status.in...dated_on) GROUP BY status.serial_no, status.name;',) b {} self ret undefined self.cursor self.cursor.execute *I am suspecting something is wrong with Expression syntax but unable to catch it , please help me resolve this issue.* Thanks, Amit * * --

[web2py] Re: ImportError: Cannot import module 'requests'

2012-11-12 Thread Amit
com"], "subject": "Update", "text": str(testmessage) } ) return r On Monday, 12 November 2012 15:00:43 UTC+5:30, Amit wrote: > > I am getting below error on python shell: > > Py

[web2py] Re: ImportError: Cannot import module 'requests'

2012-11-12 Thread Amit
module available on python ? > > i.e. if you open a python shell, what you get when you do > > import requests > > ? > > Il giorno lunedì 12 novembre 2012 10:12:08 UTC+1, Amit ha scritto: >> >> Hi, >> >> I am using scheduler in my application

[web2py] ImportError: Cannot import module 'requests'

2012-11-12 Thread Amit
Hi, I am using scheduler in my application which will periodically sends mail to the user, but when i start worker on command prompt using web2py.py -K MyApp, its giving follwoing error on command prompt: D:\web2py2.1.1\web2py>web2py.py -K MyApp No handlers could be found for logger "web2py"

Re: [web2py] Re: Optimized way to use web2py Scheduler

2012-11-09 Thread Amit
o run more than one tasks at the same time period then I should go to the approach of starting more than one workers. Thanks, Amit On Fri, Nov 9, 2012 at 3:16 PM, Niphlod wrote: > ehm, missing something here: worker(s) do(es) auto-assignments of tasks. > there's no web2py involved in a

[web2py] Optimized way to use web2py Scheduler

2012-11-08 Thread Amit
ed way to use web2py scheduler? Regards, Amit --

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-07 Thread Amit
they make request for application but can't be able to access the application pages because on server command prompt it will ask for password, so how to make it password free? On Wed, Nov 7, 2012 at 6:52 PM, Michele Comitini wrote: > Amit, > > A "self" was missing this

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-06 Thread Amit
://www.cafesoft.com/products/cams/ps/docs30/admin/ConfiguringApache2ForSSLTLSMutualAuthentication.html So x509_auth.py expects surname but above link doesn't provide option to fill surname :( Regards, Amit On Tue, Nov 6, 2012 at 8:34 PM, Michele Comitini wrote: > self.subject

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-06 Thread Amit
Address) # IMPORTANT WE USE THE CERT SERIAL AS UNIQUE KEY FOR THE USER p['registration_id'] = self.serial Variables a undefined b undefined builtinreduce self.subject.surname [] self self.subject p {'first_name': 'A | m | i | t'

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-06 Thread Amit
I am using Python 2.7.2. On Tue, Nov 6, 2012 at 6:33 PM, Michele Comitini wrote: > What is your python version? > > > 2012/11/6 Amit > >> Hi Michele, >> I used Simpatica to generates the certificates but failed to deploy to >> the web2py server, please check

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-06 Thread Amit
Hi Michele, I used Simpatica to generates the certificates but failed to deploy to the web2py server, please check once the first mail in this mail chain where I explained the problem in details. Regards, Amit On Tue, Nov 6, 2012 at 4:52 PM, Michele Comitini wrote: > I suggest looking at c

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-06 Thread Amit
ert. > ca-cert is used if you're willing to auth users through x509, but given > that your understanding on certificates is basic I'd say you don't need it. > > Il giorno martedì 6 novembre 2012 04:00:37 UTC+1, Amit ha scritto: >> >> Thanks for your respons

[web2py] Getting error "Login not allowed. No valid x509 crentials"

2012-11-06 Thread Amit
tps://127.0.0.1:8000/MyApp/default/index It is displaying below message on the browser: *Login not allowed. No valid x509 crentials* * * Please guide me what I am doing wrong. Regards, Amit --

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-05 Thread Amit
: ssl_error_rx_record_too_long) *Hope this will help you to understand the problem.* *Thanks, Amit* * On Mon, Nov 5, 2012 at 5:17 PM, LightDot wrote: > One way I know of is the same Niphlod told you in his previous post - use > openssl to generate the certificate. He gave you the complete command > example, I d

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-05 Thread Amit
certificate. SSL is OFF* and on browser it display following error message: *SSL received a record that exceeded the maximum permissible length. (Error code: ssl_error_rx_record_too_long)* So no idea, how to resolve this? Thanks, Amit On Mon, Nov 5, 2012 at 4:10 PM, Niphlod wrote: > the us

Re: [web2py] Re: Problem in deploying ssl certificates to Rocket server.

2012-11-04 Thread Amit
know any other way to create these certificates without password on windows then please do share me. waiting for your response. Thanks, Amit On Fri, Nov 2, 2012 at 6:23 PM, Niphlod wrote: > certs are supposed to be generated without passwords. Even in apache, etc, > if you protect

[web2py] Problem in deploying ssl certificates to Rocket server.

2012-11-01 Thread Amit
nnot be shown because the authenticity of the received data could not be verified. Please contact the website owners to inform them of this problem. Alternatively, use the command found in the help menu to report this broken site.* Could anyone please help me out to resolve this issue? Regards, Amit --

[web2py] Problem in SQLFORM.grid()

2012-10-28 Thread Amit
_id field of Add screen. Second problem is : How can I make “Email Ids” field to accept only email ids and maximum number of email ids should be allowed to enter is 5? Please help me resolve this issue. Regards, Amit --

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-09-02 Thread Amit
Thanks Anthony :) Regards, Amit On Fri, Aug 31, 2012 at 4:47 PM, Anthony wrote: > On Thursday, August 30, 2012 10:44:51 PM UTC-4, Amit wrote: >> >> As I told you I have created my own custom html without extending >> layout.html. > > > "I have created my own

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-08-30 Thread Amit
As I told you I have created my own custom html without extending layout.html. I am not sure how to load JQuery in that? Please check the whole html file in attachement once and suggest me how to support JQuery in the html. Regards, Amit On Thu, Aug 30, 2012 at 4:53 PM, Anthony wrote: >

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-08-30 Thread Amit
; } but if I use JQuery instead of directly putting record name, its not working.Please suggest is it a proper way to send the parameters to the controller function. Regards, Amit On Thu, Aug 30, 2012 at 2:44 PM, Amit wrote: > Anthony, > I observe one more thing, as I have launched

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-08-30 Thread Amit
page, may be some temporary page is getting created with these values. what I understood is this page is not record_config page that's why it is not calling onclick of the button , hence not calling javascript, JQuery stuffs also. Please provide your inputs on this. Regards, Amit On Thu, A

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-08-30 Thread Amit
+ > jQuery("input[name=name_text_field]").val();' > > The value will be available as request.args(0) in the record_config() > function. > > Anthony > > > On Thursday, August 30, 2012 2:41:40 AM UTC-4, Amit wrote: >> >> H

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-08-29 Thread Amit
Hi Anthony, I used the code which you have suggested but it's not working at all, it is not calling record_config() function of controller. second point is if the above approach is successful then how would I retrieve the value in controller side: def record_config(): print 'inside rec

Re: [web2py] Re: How to pass html text field value to the controller function?

2012-08-29 Thread Amit
t 29, 2012 6:18:57 AM UTC-4, Amit wrote: >> >> Hi, >> I have to send textfield value from html to controller function, how to >> achieve it, please see the code below : >> >> > >>onClick = 'window.location="{{=URL('defa**ult', &#x

Re: [web2py] How to pass html text field value to the controller function?

2012-08-29 Thread Amit
to do once > you have pass the input value to this function. > > Richard > > > On Wed, Aug 29, 2012 at 6:18 AM, Amit wrote: > >> Hi, >> I have to send textfield value from html to controller function, how to >> achieve it, please see the code below : >&

[web2py] How to pass html text field value to the controller function?

2012-08-29 Thread Amit
Hi, I have to send textfield value from html to controller function, how to achieve it, please see the code below : I have one text field on html page named record name, user can input the name of the record which I want to pass to the record_config() function of default.py but i am unable

Re: [web2py] Re: How to call controller function upon onClick from html?

2012-08-28 Thread Amit
rm ,inside same table but still it is giving same error so how to get the text field value and pass it to the args? Regards, Amit On Mon, Aug 27, 2012 at 7:21 PM, Anthony wrote: > The onclick property of an HTML element must be Javascript. You cannot > call a server-side Python function d

[web2py] Re: How to call controller function upon onClick from html?

2012-08-27 Thread Amit
Thanks Anthony, its working as expected :) regards, Amit On Monday, 27 August 2012 19:21:46 UTC+5:30, Anthony wrote: > > The onclick property of an HTML element must be Javascript. You cannot > call a server-side Python function directly from the browser. If you want > the button

[web2py] Re: how to send function arguments value from redirect()?

2012-08-27 Thread Amit
y, 28 August 2012 11:09:56 UTC+5:30, Amit wrote: > > hi, > I have to send the arguments value from redirect to the target function, > for e.g: > > redirect(URL(r=request,f='record_config')) > > def record_config(record_id): > > > I have to send the

[web2py] how to send function arguments value from redirect()?

2012-08-27 Thread Amit
hi, I have to send the arguments value from redirect to the target function, for e.g: redirect(URL(r=request,f='record_config')) def record_config(record_id): I have to send the value of record_id from the redirect() to the record_config() function OR is it some other way to send value of rec

[web2py] How to call controller function upon onClick from html?

2012-08-27 Thread Amit
Hi, I have created one html file with list of records, each records are there in a row of table in html and there is one corresponding button (type as button) for each record so when user clicks on it , it should take the id of that record from the html call controller function which will

Re: [web2py] Re: how to use javascript code in web2py html pages?

2012-08-26 Thread Amit
Thanks Anthony to finding the issue, after modifying the code as per your suggestion,its working fine now. Regards, Amit On Fri, Aug 24, 2012 at 5:01 PM, Anthony wrote: > Also, a tip -- if you think web2py is causing a problem with your code, > try the code in a page not served by web2p

[web2py] how to use javascript code in web2py html pages?

2012-08-23 Thread Amit
Hi, I have html file with one text field with submit button inside form.I added javascript code to validate the textfield but its not working at all, why is it so? does web2py not support javascript function? please check below the code : function textFieldValidation() { var x=document.for

Re: [web2py] Re: how to parse xml in web2py?

2012-08-23 Thread Amit
Thanks guys for helping me to write xml parsing in python..I will use ElementTree Or cElementTree to extract data from xml and let you people know about the outcome. @Anthony: My mistatke :( , I manually written the xml so did mistake on matching opening and closing tags. Thanks once again Amit

[web2py] how to parse xml in web2py?

2012-08-23 Thread Amit
Hi, I have web service method in my application which will receive xml file from the request, i need to parse it and save the extracted data to the database. Please suggest me the best way to parse xml in web2py. xml format would be like below: 123456 2012-06-30 1 adadafdfd

Re: [web2py] Re: Help me to write SQL query in web2py

2012-08-23 Thread Amit
It should work from inside select() also, i used it only for convenient. Regards, Amit On Wed, Aug 22, 2012 at 5:33 PM, mcamel wrote: > Amit, > > Does it works if you use tbl.created_on.max() inside the select(), instead > of max_created_on?. > > I mean, is it n

Re: [web2py] Database interaction with custom html in web2py.

2012-08-23 Thread Amit
for each employee record so user can click which can open employee edit html page and from there user can change employee details and save it to the database, what is the best way to achieve it in web2py? Regards, Amit On Wed, Aug 22, 2012 at 8:38 PM, Anthony wrote: > Note, you do

Re: [web2py] Database interaction with custom html in web2py.

2012-08-21 Thread Amit
Thanks Khalil for providing solution with example..I will write as per below instruction and let you know the result. Thanks once again :) Amit On Wed, Aug 22, 2012 at 11:42 AM, Khalil KHAMLICHI < khamlichi.kha...@gmail.com> wrote: > 1) controller page1: controllers/default.py >

Re: [web2py] Re: Help me to write SQL query in web2py

2012-08-21 Thread Amit
interval_time,max_created_on,groupby=tbl.device_id|tbl.sensor_id) Regards, Amit On Wed, Aug 22, 2012 at 11:44 AM, mcamel wrote: > Hi Amit, > > Could you post the final code that works?. > > Thanks. > > -- > > > > --

[web2py] Database interaction with custom html in web2py.

2012-08-21 Thread Amit
Hi, I generated one custom html file which is having one text field where user has to enter id and one submit button. I have to use it in following manner: 1. User has to enter the id and press the submit button 2. after pressing submit button, id value has to be validated in xyz table. 3. first

Re: [web2py] Re: NameError: global name 'requests' is not defined

2012-08-21 Thread Amit
I resolved the issue, somehow after installing it to Lib/site-packages of python installation path , it has not added to PYTHONPATH, because of that requests is not recognized, i have explicitly added it to the PYTHONPATH then its working fine. Thanks, Amit On Tue, Aug 21, 2012 at 4:02 PM, Amit

Re: [web2py] Re: NameError: global name 'requests' is not defined

2012-08-21 Thread Amit
se that with the request object > (without the s) that is available in web2py). > > Their examples lacks of the import line (import requests). > Of course you need to install that to be able to use it with pip install > requests. > > Il giorno martedì 21 agosto 2012 12:09:24

[web2py] NameError: global name 'requests' is not defined

2012-08-21 Thread Amit
Hi, I am using mailgun libraries to send mail from my web2py application,I followed example given in mailgun site mailgun.com: 1. requests.post(("https://api.mailgun.net/v2/samples.mailgun.org/messages";), 2. auth=("api", "key-3ax6xnjp29jd6fds4gc373sgvjxteol0"), 3. data={ 4.

Re: [web2py] Re: Help me to write SQL query in web2py

2012-08-20 Thread Amit
Thanks a lot Massimo and mcamel, its working as expected :) Regards, Amit On Sat, Aug 18, 2012 at 7:04 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > My bad. It should be > > t.created_on.max() > > > On Saturday, 18 August 2012 04:26:37 UTC-5, mcamel wrote:

[web2py] Help me to write SQL query in web2py

2012-08-16 Thread Amit
I have written one sql query: select device_id, sensor_id, max(created_on) from test.abc_tbl where date_sub(now(), interval interval_time minute) > created_on group by device_id, sensor_id; How to write it in web2py? Please help me to do the same. Thanks. --

Re: [web2py] Re: How to keep database connection alive ?

2012-08-09 Thread Amit
Hi, Migrated to MySql from Sqlite and tested the purging feature, its working as intended :) Thanks a lot you guys for assisting me to resolve it :) Regards, Amit On Thu, Aug 9, 2012 at 10:05 AM, Amit wrote: > This is also not working giving same error: "ProgrammingError: Cannot >

Re: [web2py] Re: How to keep database connection alive ?

2012-08-08 Thread Amit
This is also not working giving same error: "ProgrammingError: Cannot operate on a closed database." :( Regards, Amit On Thu, Aug 9, 2012 at 9:58 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > This definitively would not work... > > how about > > @sc

Re: [web2py] Re: How to keep database connection alive ?

2012-08-08 Thread Amit
7;) db(db.appliance_tbl.created_on < yesterday).delete() is it correct? OR do I need to re-define all the tables for local db instance?if no, then how this instance will be able to recognize all tables? Please guide me to resolve this. Thanks, Amit On Wed, Aug 8, 2012 at 10:49 PM, Mass

[web2py] How to keep database connection alive ?

2012-08-07 Thread Amit
Hi, I am using SQlite database for my web2py application, I have to keep the same db instance which is created at first time request comes to model db.py db = DAL('sqlite://storage.sqlite') database connection is getting closed once request is completed so I am not able to use the "db" for so

[web2py] WARNING:web2py:unable to open SSL certificate. SSL is OFF in web2py 1.99.7

2012-08-02 Thread Amit
t;*. does PyOpenSSL-0.13 not supported by Web2py 1.99.7 version OR is there any other problem? Can anyone please help me out how to resolve this issue? Regards, Amit --

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-31 Thread Amit
is other two client and server pem encoded key files , how to generate them? On Tue, Jul 31, 2012 at 3:17 PM, Amit wrote: > Hi Michele, > Still I am not able to achieve X509 authentication, I am able to generate > following files using CA menu: > cacert.key (CA private key) >

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-31 Thread Amit
ficate 2. generate server priv keys + certificates signed by the above ca certificate 3. generate client priv keys + certificates signed by the above ca certificate but I am not able to generate above 2. and 3. so pleae guide me to generate the same. Thanks, Amit > > > On Thu, Jul 26

[web2py] how to use pycurl in web2py?

2012-07-30 Thread Amit
Hi, I want to use pycurl in my web2py app to send Post request to the server, I added Pycurl path(path to pycurl.c file ---> pycurl-7.19.0\src) to pythonpath and tried to import pycurl in default.py class but it throws error " No module named pycurl" even i tried to add pycurl.c file in mudule

[web2py] Re: Facing problem of settingup web2py project in Eclipse.

2012-07-29 Thread Amit
r , its working fine, so not sure why eclipse is displaying import errors. Can anybody help me to resolve this problem? Thanks, Amit On Friday, 20 July 2012 10:49:29 UTC+5:30, Amit wrote: > > Hi, > I followed below link to configure Web2py project in eclipse: > > http://al

Re: [web2py] Getting error: DLL load failed: The operating system cannot run %1

2012-07-27 Thread Amit
Found the problem :), I was using wrong version of M2Crypto so uninstalled it and install M2Crypto-0.20.2.win32-py2.7 version and its working fine. On Fri, Jul 27, 2012 at 12:02 PM, Amit wrote: > I Have installed python 2.7.2 and M2Crypto-0.21.1-py2.7.egg-info in my > Windows XP SP3 machi

[web2py] Getting error: DLL load failed: The operating system cannot run %1

2012-07-26 Thread Amit
I Have installed python 2.7.2 and M2Crypto-0.21.1-py2.7.egg-info in my Windows XP SP3 machine and wherever i am using import statement: from M2Crypto import X509,ASN1,Rand,EVP,RSA its throwing error * DLL load failed: The operating system cannot run %1.* it seems like M2Crypto version is no

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-26 Thread Amit
llers/public.py>, line 28, in from M2Crypto import X509, ASN1, Rand, EVP, RSA So not able to execute it :(. I have installed M2Crypto-0.21.1-py2.7.egg-info for windows . I couldn't able to identify what is the exact problem, so can you please help me to resolve it? Thanks, Amit On Thu,

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-25 Thread Amit
Thanks Michele,I am going to generate keys using simpatica, I will let you know if i face any problem. Thanks, Amit On Wed, Jul 25, 2012 at 7:01 PM, Michele Comitini < michele.comit...@gmail.com> wrote: > 2012/7/25 Amit : > > Michele, > > > > I have gone through

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-25 Thread Amit
so is it the same, if yes then I need to create auth.settings.login_form = X509Auth() instance ? Thanks, Amit On Wed, Jul 25, 2012 at 2:28 PM, Michele Comitini < michele.comit...@gmail.com> wrote: > > simpatica > > - generate ca priv key + self signed c

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-25 Thread Amit
sure Michele, let me go through the code,If i am not wrong simpatica is to generate the certificate file for the client and if you are having any sample code to use x509 in case of web service then please do share with me. Thanks, Amit On Wed, Jul 25, 2012 at 12:34 PM, Michele Comitini

Re: [web2py] Re: how to achieve public/private key authentication for web service in web2py?

2012-07-24 Thread Amit
your REST action with @auth.requires_login(). > This will give you access to information contained in the certificate > such common name or serial id. To customize you can extend the X509_Auth > class. > > To generate test certificates fast you can use simpatica as Derek > correct

[web2py] how to achieve public/private key authentication for web service in web2py?

2012-07-24 Thread Amit
Hi, I have to provide public/private key authentication for accessing web service (REST) from client in my web2py application.How to achieve it? Scenario: 1.Each client will have unique private key which will be sent to the server alongwith request. 2. Server has to authenticate private key usi

[web2py] how to use db connection multiple times with scheduler?

2012-07-19 Thread Amit
hi, I have to implement one scenario where scheduler will make the query to database periodically to retrieve data(lets say every 10 mins), i have written function inside model db.py to retrieve the data, and from controller i am staring the scheduler and assign the job to get the data periodic

[web2py] Facing problem of settingup web2py project in Eclipse.

2012-07-19 Thread Amit
Hi, I followed below link to configure Web2py project in eclipse: http://allisterx.blogspot.in/2009/06/using-web2py-framework-on-eclipse.html but after setting up when i open my application which is there inside application folder of web2py_src folder, I saw so many errors on the module. once i

[web2py] how to compare date time in web2py?

2012-07-19 Thread Amit
Hi, I have some records in a table and each record is having one field of type datetime [fromat : 2012-07-19 23:12:0 (-MM-DD HH:MM:SS)], table structure is: Emp_ID Emp_Name Emp_Address Emp_Salary updated_on(Type: datetime) periodically getting data against each Emp_ID and updating to the p

Re: [web2py] Re: How to start a thread upon starting of webserver?

2012-07-18 Thread Amit
Mayer wrote: > Can't you use in a model. > cache.ram('parallel_thread_name', , None) > so that you have the thread created at first connection. > > I don't know how to close it afterwards though. Maybe using a cron job ? > > Le jeudi 19 juillet 2012 05:24:

Re: [web2py] Re: How to start a thread upon starting of webserver?

2012-07-18 Thread Amit
Hi Massimo, could you please provide me the solution for this? On Wednesday, 18 July 2012 08:37:23 UTC+5:30, Amit wrote: > > for development purpose I am using Rocket but will deploy the application > to ubuntu machine where web server will be apache, so please provide me > solut

[web2py] Re: User Login/Logout authentication event

2012-07-17 Thread amit
For logout, I could not find logout_onaccept. There is though: auth.settings.logout_onlogout I am using v 1.99.7. --

Re: [web2py] Re: How to start a thread upon starting of webserver?

2012-07-17 Thread Amit
lt-in web server) or apache? > > > On Monday, 16 July 2012 23:42:49 UTC-5, Amit wrote: >> >> Hi, >> I have one timer thread which has to start once when web sever starts >> very first time and stop when web server stops, means it should be running >> continuously

Re: [web2py] Re: Making a field non-editable, but writable using SQLFORM

2012-07-17 Thread Amit Kumar
On Tue, Jul 17, 2012 at 6:15 PM, Anthony wrote: > Sorry, I was referring to >> >> db.table.field.writable = False # change the field to writable false >> >> >>> Second, even something like the above wouldn't be a problem for >>> concurrent users, as the above would all happen within a single requ

Re: [web2py] Re: Making a field non-editable, but writable using SQLFORM

2012-07-17 Thread amit
field to writable in one request > does not affect it another request. > I am not sure if I understand this for db.table.field.writable. The change is occurring within the shared DAL object. Is it not? Best Regards -Amit --

Re: [web2py] Re: Making a field non-editable, but writable using SQLFORM

2012-07-17 Thread Amit Kumar
server; one possible sequence is: A 1, B 1, B 2, B 3, A 2, A 3. At the point of , the db field is not writable and so the form will not be correct. On Tue, Jul 17, 2012 at 12:46 PM, Anthony wrote: > Can you elaborate? > > > On Tuesday, July 17, 2012 12:24:37 AM UTC-4, amit wrote: >

[web2py] How to start a thread upon starting of webserver?

2012-07-16 Thread Amit
Hi, I have one timer thread which has to start once when web sever starts very first time and stop when web server stops, means it should be running continuously irrespective of how many users interacting with the application so there is only one instance of this thread running though out life

Re: [web2py] Re: Making a field non-editable, but writable using SQLFORM

2012-07-16 Thread amit
Old thread, but this would trigger a race condition in case of multiple concurrent users. On Friday, June 17, 2011 5:12:27 AM UTC+8, JayShaffstall wrote: > > I'd been thinking I needed to do that between form creation and the > accepts call, but you're right, it works even after that point. I >

Re: [web2py] Re: how to delete records from table older than 1 day?

2012-07-16 Thread Amit
mployee.created_on < yesterday).delete() > > > > On Monday, July 16, 2012 12:12:56 PM UTC+2, Amit wrote: >> >> Hi, >> I have created table Employe with following fields: >> db.define_table( >>'Employee', >>Field('creat

[web2py] how to delete records from table older than 1 day?

2012-07-16 Thread Amit
Hi, I have created table Employe with following fields: db.define_table( 'Employee', Field('created_on','datetime', default=request.now), Field('emp_id'), Field('emp_age'), Field('emp_address), ) inserting data into the table is working fine but when i am trying to delete data one

  1   2   >