[web2py] Calling Controller Function from javascript
How to call the Controller function from javascript
[web2py] How to upload the file through the controller in uploads folder and insert them into database
def create():
import os
filepath = os.path.join(request.folder,'uploads')
form = FORM(TABLE(TR("Compliance
Activity:",INPUT(_type="text",_name="activity",requires=IS_NOT_EMPTY(error_message='Please
Enter the Activity'))),
TR("Document:",INPUT(_type="file",_name="fileupload",requires=IS_NOT_EMPTY(error_message='Please
Select the file you want to Upload'))),
TR("",INPUT(_type="submit",_value="SUBMIT"
if form.accepts(request.vars, session):
session.activity = form.vars.activity
session.fileupload = form.vars.fileupload.filename
db.submit_compliance_detail.insert(compliance_activity=session.activity,compliance_manager='themisde...@gmail.com',compliance_owner=auth.user.email,document=session.fileupload)
response.flash = 'uploaded'
return dict(form=form)
[web2py] How to Change the date format
Hi to all, I want to change the date format during the insertion in database default is YYY-MM-DD but i want to insert in database by using the DD- MM- and Month should be in the 'jan' format . Please help me
Re: [web2py] How to Change the date format
Thanks
Re: [web2py] How to Change the date format
Thanks
[web2py] How to Generate the effective report by using web2py
Following is my code but i don't get the report in proper format and
when we got the pdf than the column is collapse with each other so
please kindly help me :-
def listing():
response.title = "abc"
# define header and footers:
head = THEAD(TR(TH("Activity",_width="20%"),
TH("Due Date",_width="10%"),
TH("Company",_width="10%"),
TH("city",_width="10%"),
TH("Area of Law",_width="10%"),
TH("legislation",_width="10%"),
TH("Rules and Regulations",_width="20%"),
TH("Status",_width="10%"),
_bgcolor="#A0A0A0"))
foot = TFOOT(TR(TH("LCM+",_width="100%", _align="center"),
_bgcolor="#E0E0E0"))
# create several rows:
rows = []
for row in db((db.compliance_tracker.company == session.company) &
(db.compliance_tracker.time_line >= session.strtdate) &
(db.compliance_tracker.time_line <= session.enddate)).select():
col = row.id % 2 and "#F0F0F0" or "#FF"
rows.append(TR(TD('%s'%row.compliance_activity,_width="20%"),
TD("%s"%row.time_line,_width="10%"),
TD("%s"%row.company,_width="10%"),
TD("%s"%row.city,_width="10%"),
TD("%s"%row.area_of_law,_width="10%"),
TD("%s"%row.legislation,_width="10%"),
TD("%s"%row.rules_and_regulations,_width="20%"),
TD("%s"%row.status,_width="10%"),
_bgcolor=col))
# make the table object
body = TBODY(*rows)
table = TABLE(*[head,foot, body],
_border="1", _align="center", _width="100%")
if request.extension=="pdf":
from gluon.contrib.pyfpdf import FPDF, HTMLMixin
# define our FPDF class (move to modules if it is reused
frequently)
class MyFPDF(FPDF, HTMLMixin):
def header(self):
self.set_font('Arial','B',12)
self.cell(0,10, response.title ,1,0,'C')
self.ln(20)
def footer(self):
self.set_y(-15)
self.set_font('Arial','I',8)
txt = 'Page %s of %s' % (self.page_no(),
self.alias_nb_pages())
self.cell(0,10,txt,0,0,'C')
pdf=MyFPDF()
# first page:
pdf.add_page()
pdf.write_html(str(XML(table, sanitize=False)))
response.headers['Content-Type']='application/pdf'
return pdf.output(dest='S')
else:
# normal html view:
return dict(table=table)
Re: [web2py] Re: How to Generate the effective report by using web2py
no Actually we have problem in the fields if we take the lage data from database than it is creating the problem
Re: [web2py] Re: How to Generate the effective report by using web2py
Ross Can you send me the CODE for that thanks in advance because i want to generate the report properly through FPDF. On Thu, Feb 16, 2012 at 6:31 PM, Ross Peoples wrote: > I had to write a lot of code to get FPDF to do proper headers, footers, > and page numbers. Then about another 100 lines of code to get it to wrap > long lines of text inside of a table. I'm also not using HTML to PDF > conversion. I am using FPDF's methods to create PDFs. If I recall > correctly, I tried to use paragraphs and even new line characters to force > the line to break, but ended up having to use absolute positioning for the > lines. It sounds terrible, I know, but I have been using this successfully > for a little while. I basically wrote a module that takes a query (just > like SQLFORM.grid) and generates a PDF with headers, footers, a logo, and > can even group data into multiple tables, all while wrapping long text and > repeating column headers on each new page. It was a lot of work, but the > reports look pretty good. > > Mariano, what about FPDF are you planning on updating? And are you > planning to break backwards-compatibility? >
Re: [web2py] Re: How to Generate the effective report by using web2py
Ross i am new in web2py and python so please what are you planning put in the repository because i want to generate the report by using FPDF and i also generated the report but now in the rows i have the large text so Problems are arising on the view On Fri, Feb 17, 2012 at 12:02 AM, Mariano Reingart wrote: > Ross: > > I'm planning a unicode patch and a better support to html rendering > using web2py helpers > They will not break compatibility. > If you want, you can sent me your changes, I could add it somewhere or > using as a base of a new reporting functions. > > It would be great if you can fill an issue: > > http://code.google.com/p/pyfpdf/ > > BTW, if you want, I can give you commit access. > > Best regards > > Mariano Reingart > http://www.sistemasagiles.com.ar > http://reingart.blogspot.com > > > > On Thu, Feb 16, 2012 at 10:01 AM, Ross Peoples > wrote: > > I had to write a lot of code to get FPDF to do proper headers, footers, > and > > page numbers. Then about another 100 lines of code to get it to wrap long > > lines of text inside of a table. I'm also not using HTML to PDF > conversion. > > I am using FPDF's methods to create PDFs. If I recall correctly, I tried > to > > use paragraphs and even new line characters to force the line to break, > but > > ended up having to use absolute positioning for the lines. It sounds > > terrible, I know, but I have been using this successfully for a little > > while. I basically wrote a module that takes a query (just like > > SQLFORM.grid) and generates a PDF with headers, footers, a logo, and can > > even group data into multiple tables, all while wrapping long text and > > repeating column headers on each new page. It was a lot of work, but the > > reports look pretty good. > > > > Mariano, what about FPDF are you planning on updating? And are you > planning > > to break backwards-compatibility? >
Re: [web2py] Re: How to Generate the effective report by using web2py
Thanks Ross On Fri, Feb 17, 2012 at 6:23 PM, Ross Peoples wrote: > Sanjeet. > > I sent some code to Mariano last night. So we will have to wait and see if > it works for him. >
[web2py] Validate the Checkbox
I have the multiple check-box in one row in Controller I want to validate it form controller when the user submit his request without selecting any of the check-box than it should be shown the error message "Please select at least one check-box"
Re: [web2py] Re: Validate the Checkbox
TR("Type:",(TD(INPUT(_type="checkbox",_name="a",_value="a",_size="0"),"A"))),
(TD(INPUT(_type="checkbox",_name="b",_value="b",_size="0"),"B")),
(TD(INPUT(_type="checkbox",_name="c",_value="c",_size="0"),"C"))),
TR("",INPUT(_type="submit",_value="SUBMIT" ))
On Tue, Feb 21, 2012 at 11:28 AM, whowhywhat wrote:
> please could post your controller code..
>
> On Feb 21, 10:32 am, Sanjeet Kumar wrote:
> > I have the multiple check-box in one row in Controller I want to validate
> > it form controller when the user submit his request without selecting any
> > of the check-box than it should be shown the error message "Please select
> > at least one check-box"
>
Re: [web2py] Re: Validate the Checkbox
I got it but you are putted here the same name of the check box through
which we can validate the multiple checkbox eaisly but here i want the
value of the different check box in different variables for checking the
multiple conditions.
such as
qury=db((db.employee.name==a ) | (db.employee.name==b ) | (db.employee.name==b
)).select()
On Tue, Feb 21, 2012 at 1:36 PM, whowhywhat wrote:
> also
>
>
> TR("Type:",TD(INPUT(_type="checkbox",_name="options",_value="a",_size="0",requires
> = IS_NOT_EMPTY(error_message="Please select
> at least one check-box"))," A" ...
>
> to have your required error message
>
> Please check out the excellent web2py documentation for forms and
> validators http://web2py.com/books/default/chapter/29/7#Validators
>
>
> On Feb 21, 12:51 pm, whowhywhat wrote:
> > You can also just write a jquery validator for the same..
> >
> > On Feb 21, 12:49 pm, whowhywhat wrote:
> >
> >
> >
> >
> >
> >
> >
> > > This should work. Although it is ugly (it gives a error message under
> > > all the checkboxes :P ).. but does validate as you require. Please
> > > check and let me know.
> >
> > > def multi_check_box():
> > > form = FORM(TABLE(
> >
> > >
> TR("Type:",TD(INPUT(_type="checkbox",_name="options",_value="a",_size="0",requires
> > > = IS_NOT_EMPTY())," A",
> >
> > > INPUT(_type="checkbox",_name="options",_value="b",_size="0")," B",
> >
> > > INPUT(_type="checkbox",_name="options",_value="c",_size="0")," C")),
> > > TR("",INPUT(_type="submit",_value="SUBMIT"
> > > if form.accepts(request.vars,session):
> >
> > > return dict(form=form)
> >
> > > On Feb 21, 11:09 am, Sanjeet Kumar wrote:
> >
> > > >
> TR("Type:",(TD(INPUT(_type="checkbox",_name="a",_value="a",_size="0"),"A"))),
> >
> > > > (TD(INPUT(_type="checkbox",_name="b",_value="b",_size="0"),"B")),
> >
> > > > (TD(INPUT(_type="checkbox",_name="c",_value="c",_size="0"),"C"))),
> > > > TR("",INPUT(_type="submit",_value="SUBMIT" ))
> >
> > > > On Tue, Feb 21, 2012 at 11:28 AM, whowhywhat
> wrote:
> > > > > please could post your controller code..
> >
> > > > > On Feb 21, 10:32 am, Sanjeet Kumar wrote:
> > > > > > I have the multiple check-box in one row in Controller I want to
> validate
> > > > > > it form controller when the user submit his request without
> selecting any
> > > > > > of the check-box than it should be shown the error message
> "Please select
> > > > > > at least one check-box"
>
[web2py] Hide the Links based on Permission
I am using the same layout for the Admin and Client but i want to hide some links for the clients in my page based on the permissions
[web2py] Re: Validate the Checkbox
Thanks My problems are solved
[web2py] Re: Requesting Feedback for Web2py Instant Admin
Can I add the dropdown for searching in Plugin_instant_admin
Re: [web2py] Re: Hide the Links based on Permission
Thanks Annet
On Wed, Feb 22, 2012 at 2:51 PM, Annet wrote:
> Hi Sanjeet,
>
> If Admin and Client are groups you could also do:
>
>
> {{if auth.has_membership('Admin'):}}
> Admin links
> {{elif auth.has_membership('Client'}}
> Client links
> {{pass}}
>
>
> Regards,
>
> Annet
[web2py] Hide the Extra added fields from auth table during the registrations
I am added the some extra fields in the auth_user table and i want to hide those fields when the user will go for the registration user can only see the following fields during the registration: - First name - Last name - email-id - Password - verify password
[web2py] want to insert the data in database when the user will log-in first time
I want to insert the data in database when the user will log-in first time
. if the user refresh the index page after login it will again insert the
date and time I have the following sample code i know this code is wrong
but i want to insert the data only first time when the user will log-in.
@auth.requires_login()
def index():
#response.flash = c
if auth.is_logged_in():
response.flash='You are logged in'
else:
import datetime
c=datetime.datetime.now()
for row in db(db.auth_user.email ==
auth.user.email).select(db.auth_user.first_name):
firstname=row.first_name
db.employee_detail.insert(employee_id = auth.user.email,
employee_name=firstname, employee_login_time=c)
return dict(message=T('Hello World'))
Re: [web2py] Re: want to insert the data in database when the user will log-in first time
Thanks Massimo
On Fri, Feb 24, 2012 at 9:23 PM, Massimo Di Pierro <
massimo.dipie...@gmail.com> wrote:
> How about adding this at the bottom of your model:
>
> def do_something(form):
> auth.settings.login_onaccept = do_something
>
> On Feb 24, 3:47 am, Sanjeet Kumar wrote:
> > I want to insert the data in database when the user will log-in first
> time
> > . if the user refresh the index page after login it will again insert the
> > date and time I have the following sample code i know this code is wrong
> > but i want to insert the data only first time when the user will log-in.
> >
> > @auth.requires_login()
> > def index():
> > #response.flash = c
> > if auth.is_logged_in():
> > response.flash='You are logged in'
> > else:
> > import datetime
> > c=datetime.datetime.now()
> > for row in db(db.auth_user.email ==
> > auth.user.email).select(db.auth_user.first_name):
> > firstname=row.first_name
> > db.employee_detail.insert(employee_id = auth.user.email,
> > employee_name=firstname, employee_login_time=c)
> > return dict(message=T('Hello World'))
>
[web2py] cron setup
Can anyone give me the brief description to how I set the cron to run the task in background with example.
Re: [web2py] Re: cron setup
Exactly I need the examples On Mon, Feb 27, 2012 at 4:56 AM, Luciano Pacheco wrote: > I think Sanjeet means, I example of the task. > > What is a good practice in the task, or what kind of variables are present > in the local namespace "automagically", etc. A task should be a class a > function, a python module? > > I had the same question last week when I was reading this chapter. :-) > > Regards, > -- > Luciano Pacheco > blog.lucmult.com.br > > On Mon, Feb 27, 2012 at 10:08 AM, Alan Etkin wrote: > >> It's all in the book (if you haven't seen yet) >> >> http://web2py.com/books/default/chapter/29/4#Cron >> >> By the way, The link in web2py to cron (http://web2py.com/books/ >> default/reference/29/cron<http://web2py.com/books/default/reference/29/cron>) >> is broken (returns an invalid function >> message) >> >> On 26 feb, 13:09, Sanjeet Kumar wrote: >> > Can anyone give me the brief description to how I set the cron to run >> the >> > task in background with example. >> > > > >
[web2py] Time Substraction
I am going to develop the time management sheet for that i have the one
table name employee table and i am allready taken the login and logout time
and i want to substract the time when i substract the time it show me in
nanoseconds when i convert this nanosecond to the minute it totally
confused me so if any one have solution please help me following is my
controller and database :-
*
Table:-*
db.define_table('employee_detail',
Field('employee_id'),
Field('employee_name'),
Field('employee_login_date','date'),
Field('employee_logout_date','date'),
Field('employee_login_time'),
Field('employee_logout_time'),
Field('total_time'))*
Controller:-*
def lgin(form):
import datetime
import time
currentdate=datetime.date.today()
now = time.localtime(time.time())
session.sttime=time.time()
currenttime = time.strftime("%H:%M:%S", now)
session.time = currenttime
#response.flash=currentdate
for row in db(db.auth_user.email ==
auth.user.email).select(db.auth_user.first_name):
firstname=row.first_name
db.employee_detail.insert(employee_id = auth.user.email,
employee_name=firstname, employee_login_date=currentdate,
employee_login_time=currenttime)
return ''
def lgout(usr):
import datetime
import time
currentdate=datetime.date.today()
now = time.localtime(time.time())
ettime=time.time()
duration = ettime-session.sttime
du = str(duration / 600)
currenttime = time.strftime("%H:%M:%S", now)
db((db.employee_detail.employee_id == auth.user.email) &
(db.employee_detail.employee_login_date == currentdate) &
(db.employee_detail.employee_login_time ==
session.time)).update(employee_logout_date=currentdate,
employee_logout_time=currenttime, total_time=du)
return ''
[web2py] Re: Time Substraction
showing AttributeError: 'datetime.timedelta' object has no attribute 'minutes'
On Tuesday, February 28, 2012 1:47:40 AM UTC+5:30, Ross Peoples wrote:
>
> Well, one of the issues is going to be that you are using 'date' for your
> fields instead of 'datetime'. When using 'datetime', it becomes easy to do
> something like this:
>
> delta = row.employee_logout_date - row.employee_login_date
> minutes = delta.minutes + (delta.hours * 60)
>
> On Monday, February 27, 2012 11:54:56 AM UTC-5, Sanjeet Kumar wrote:
>>
>> I am going to develop the time management sheet for that i have the one
>> table name employee table and i am allready taken the login and logout time
>> and i want to substract the time when i substract the time it show me in
>> nanoseconds when i convert this nanosecond to the minute it totally
>> confused me so if any one have solution please help me following is my
>> controller and database :-
>> *
>> Table:-*
>>
>> db.define_table('employee_detail',
>> Field('employee_id'),
>> Field('employee_name'),
>> Field('employee_login_date','date'),
>> Field('employee_logout_date','date'),
>> Field('employee_login_time'),
>> Field('employee_logout_time'),
>> Field('total_time'))*
>>
>> Controller:-*
>>
>> def lgin(form):
>> import datetime
>> import time
>> currentdate=datetime.date.today()
>> now = time.localtime(time.time())
>> session.sttime=time.time()
>> currenttime = time.strftime("%H:%M:%S", now)
>> session.time = currenttime
>> #response.flash=currentdate
>> for row in db(db.auth_user.email ==
>> auth.user.email).select(db.auth_user.first_name):
>> firstname=row.first_name
>> db.employee_detail.insert(employee_id = auth.user.email,
>> employee_name=firstname, employee_login_date=currentdate,
>> employee_login_time=currenttime)
>> return ''
>>
>> def lgout(usr):
>> import datetime
>> import time
>> currentdate=datetime.date.today()
>> now = time.localtime(time.time())
>> ettime=time.time()
>> duration = ettime-session.sttime
>> du = str(duration / 600)
>> currenttime = time.strftime("%H:%M:%S", now)
>> db((db.employee_detail.employee_id == auth.user.email) &
>> (db.employee_detail.employee_login_date == currentdate) &
>> (db.employee_detail.employee_login_time ==
>> session.time)).update(employee_logout_date=currentdate,
>> employee_logout_time=currenttime, total_time=du)
>> return ''
>>
>>
>>
> On Monday, February 27, 2012 11:54:56 AM UTC-5, Sanjeet Kumar wrote:
>>
>> I am going to develop the time management sheet for that i have the one
>> table name employee table and i am allready taken the login and logout time
>> and i want to substract the time when i substract the time it show me in
>> nanoseconds when i convert this nanosecond to the minute it totally
>> confused me so if any one have solution please help me following is my
>> controller and database :-
>> *
>> Table:-*
>>
>> db.define_table('employee_detail',
>> Field('employee_id'),
>> Field('employee_name'),
>> Field('employee_login_date','date'),
>> Field('employee_logout_date','date'),
>> Field('employee_login_time'),
>> Field('employee_logout_time'),
>> Field('total_time'))*
>>
>> Controller:-*
>>
>> def lgin(form):
>> import datetime
>> import time
>> currentdate=datetime.date.today()
>> now = time.localtime(time.time())
>> session.sttime=time.time()
>> currenttime = time.strftime("%H:%M:%S", now)
>> session.time = currenttime
>> #response.flash=currentdate
>> for row in db(db.auth_user.email ==
>> auth.user.email).select(db.auth_user.first_name):
>> firstname=row.first_name
>> db.employee_detail.insert(employee_id = auth.user.email,
>> employee_name=firstname, employee_login_date=currentdate,
>> employee_login_time=currenttime)
>> return
Re: [web2py] Re: Time Substraction
Thanks Massimo
On Tue, Feb 28, 2012 at 10:33 AM, Massimo Di Pierro <
massimo.dipie...@gmail.com> wrote:
> Delta has only days and seconds.
>
> On Feb 27, 9:55 pm, Sanjeet Kumar wrote:
> > showing AttributeError: 'datetime.timedelta' object has no attribute
> 'minutes'
> >
> >
> >
> >
> >
> >
> >
> > On Tuesday, February 28, 2012 1:47:40 AM UTC+5:30, Ross Peoples wrote:
> >
> > > Well, one of the issues is going to be that you are using 'date' for
> your
> > > fields instead of 'datetime'. When using 'datetime', it becomes easy
> to do
> > > something like this:
> >
> > > delta = row.employee_logout_date - row.employee_login_date
> > > minutes = delta.minutes + (delta.hours * 60)
> >
> > > On Monday, February 27, 2012 11:54:56 AM UTC-5, Sanjeet Kumar wrote:
> >
> > >> I am going to develop the time management sheet for that i have the
> one
> > >> table name employee table and i am allready taken the login and
> logout time
> > >> and i want to substract the time when i substract the time it show me
> in
> > >> nanoseconds when i convert this nanosecond to the minute it totally
> > >> confused me so if any one have solution please help me following is my
> > >> controller and database :-
> > >> *
> > >> Table:-*
> >
> > >> db.define_table('employee_detail',
> > >> Field('employee_id'),
> > >> Field('employee_name'),
> > >> Field('employee_login_date','date'),
> > >> Field('employee_logout_date','date'),
> > >> Field('employee_login_time'),
> > >> Field('employee_logout_time'),
> > >> Field('total_time'))*
> >
> > >> Controller:-*
> >
> > >> def lgin(form):
> > >> import datetime
> > >> import time
> > >> currentdate=datetime.date.today()
> > >> now = time.localtime(time.time())
> > >> session.sttime=time.time()
> > >> currenttime = time.strftime("%H:%M:%S", now)
> > >> session.time = currenttime
> > >> #response.flash=currentdate
> > >> for row in db(db.auth_user.email ==
> > >> auth.user.email).select(db.auth_user.first_name):
> > >> firstname=row.first_name
> > >> db.employee_detail.insert(employee_id = auth.user.email,
> > >> employee_name=firstname, employee_login_date=currentdate,
> > >> employee_login_time=currenttime)
> > >> return ''
> >
> > >> def lgout(usr):
> > >> import datetime
> > >> import time
> > >> currentdate=datetime.date.today()
> > >> now = time.localtime(time.time())
> > >> ettime=time.time()
> > >> duration = ettime-session.sttime
> > >> du = str(duration / 600)
> > >> currenttime = time.strftime("%H:%M:%S", now)
> > >> db((db.employee_detail.employee_id == auth.user.email) &
> > >> (db.employee_detail.employee_login_date == currentdate) &
> > >> (db.employee_detail.employee_login_time ==
> > >> session.time)).update(employee_logout_date=currentdate,
> > >> employee_logout_time=currenttime, total_time=du)
> > >> return ''
> >
> > > On Monday, February 27, 2012 11:54:56 AM UTC-5, Sanjeet Kumar wrote:
> >
> > >> I am going to develop the time management sheet for that i have the
> one
> > >> table name employee table and i am allready taken the login and
> logout time
> > >> and i want to substract the time when i substract the time it show me
> in
> > >> nanoseconds when i convert this nanosecond to the minute it totally
> > >> confused me so if any one have solution please help me following is my
> > >> controller and database :-
> > >> *
> > >> Table:-*
> >
> > >> db.define_table('employee_detail',
> > >> Field('employee_id'),
> > >> Field('employee_name'),
> > >> Field('employee_login_date','date'),
> > >> Field('empl
Re: [web2py] Re: cron setup
i tried this but i am not be able to run my controller Can you give me the simple example through which i can run the function written under the controller inside my application On Mon, Feb 27, 2012 at 5:39 PM, Luciano Pacheco wrote: > Example: > > http://movu.ca/demo/article/show/31/web2py-cron-task > > My first try in movu.ca :-) > > > On Mon, Feb 27, 2012 at 2:32 PM, Sanjeet Kumar wrote: > >> Exactly I need the examples >> >> >> On Mon, Feb 27, 2012 at 4:56 AM, Luciano Pacheco wrote: >> >>> I think Sanjeet means, I example of the task. >>> >>> What is a good practice in the task, or what kind of variables are >>> present in the local namespace "automagically", etc. A task should be a >>> class a function, a python module? >>> >>> I had the same question last week when I was reading this chapter. :-) >>> >>> Regards, >>> -- >>> Luciano Pacheco >>> blog.lucmult.com.br >>> >>> On Mon, Feb 27, 2012 at 10:08 AM, Alan Etkin wrote: >>> >>>> It's all in the book (if you haven't seen yet) >>>> >>>> http://web2py.com/books/default/chapter/29/4#Cron >>>> >>>> By the way, The link in web2py to cron (http://web2py.com/books/ >>>> default/reference/29/cron<http://web2py.com/books/default/reference/29/cron>) >>>> is broken (returns an invalid function >>>> message) >>>> >>>> On 26 feb, 13:09, Sanjeet Kumar wrote: >>>> > Can anyone give me the brief description to how I set the cron to run >>>> the >>>> > task in background with example. >>>> >>> >>> >>> >>> >> > > > -- > Luciano Pacheco > blog.lucmult.com.br >
[web2py] Get the IP of the System
How we can get the IP address of the system
[web2py] Capture the system shut down and browser close event
I am going to develop the time sheet app so for that i captured the login
and logout event through this :-
auth.settings.login_onaccept = lambda form: lgin(form)
auth.settings.logout_onlogout = lambda usr: lgout(usr)
and one more question in my mind when the browser will be closed by some
reasons and the system will be shut-down due to power loss that time how we
capture the event and will show it logout and update our database following
is my database and the controller :-
database:-
db.define_table('employee_login_detail',
Field('employee_id'),
Field('employee_name'),
Field('employee_login_date'),
Field('employee_login_time'),
Field('employee_logout_date',default='Logged in'),
Field('employee_logout_time',default='Logged in'),
Field('total_minutes',default='Logged in'))
Controller:-
def lgin(form):
import datetime
import time
currentdate=datetime.date.today()
now = time.localtime(time.time())
starttime = datetime.datetime.now()
session.starttime = starttime
currenttime = time.strftime("%H:%M:%S", now)
session.time = currenttime
for row in db(db.auth_user.email ==
auth.user.email).select(db.auth_user.first_name):
firstname=row.first_name
db.employee_login_detail.insert(employee_id = auth.user.email,
employee_name=firstname, employee_login_date=currentdate,
employee_login_time=currenttime)
return ''
def lgout(usr):
import datetime
import time
currentdate=datetime.date.today()
now = time.localtime(time.time())
endtime=datetime.datetime.now()
starttime = session.starttime
delta = (endtime - starttime)
totalminutes = str(delta.seconds / 60)
currenttime = time.strftime("%H:%M:%S", now)
db((db.employee_login_detail.employee_id == auth.user.email) &
(db.employee_login_detail.employee_login_date == currentdate) &
(db.employee_login_detail.employee_login_time ==
session.time)).update(employee_logout_date=currentdate,
employee_logout_time=currenttime, total_minutes=totalminutes)
return ''
Re: [web2py] Re: cron setup
I am not be able to get you properly can you give me the better clarification i have the default controller and the index function can you tell me how can i run the index function by using crontab which are in my application folder. On Tue, Feb 28, 2012 at 4:12 PM, Luciano Pacheco wrote: > Following the same example. > > In you controller: > > from applications.instore.modules.background_updater main > > def force_background_updater(): > ret = main() > return 'The result was: %s' % ret > > But, the cron is run time based tasks, usually those tasks won't be used > in controller.One exception is when you want to force a task to run. > > Regards, > > > On Tue, Feb 28, 2012 at 9:11 PM, Sanjeet Kumar wrote: > >> i tried this but i am not be able to run my controller Can you give me >> the simple example through which i can run the function written under the >> controller inside my application >> >> >> On Mon, Feb 27, 2012 at 5:39 PM, Luciano Pacheco wrote: >> >>> Example: >>> >>> http://movu.ca/demo/article/show/31/web2py-cron-task >>> >>> My first try in movu.ca :-) >>> >>> >>> On Mon, Feb 27, 2012 at 2:32 PM, Sanjeet Kumar wrote: >>> >>>> Exactly I need the examples >>>> >>>> >>>> On Mon, Feb 27, 2012 at 4:56 AM, Luciano Pacheco wrote: >>>> >>>>> I think Sanjeet means, I example of the task. >>>>> >>>>> What is a good practice in the task, or what kind of variables are >>>>> present in the local namespace "automagically", etc. A task should be a >>>>> class a function, a python module? >>>>> >>>>> I had the same question last week when I was reading this chapter. :-) >>>>> >>>>> Regards, >>>>> -- >>>>> Luciano Pacheco >>>>> blog.lucmult.com.br >>>>> >>>>> On Mon, Feb 27, 2012 at 10:08 AM, Alan Etkin wrote: >>>>> >>>>>> It's all in the book (if you haven't seen yet) >>>>>> >>>>>> http://web2py.com/books/default/chapter/29/4#Cron >>>>>> >>>>>> By the way, The link in web2py to cron (http://web2py.com/books/ >>>>>> default/reference/29/cron<http://web2py.com/books/default/reference/29/cron>) >>>>>> is broken (returns an invalid function >>>>>> message) >>>>>> >>>>>> On 26 feb, 13:09, Sanjeet Kumar wrote: >>>>>> > Can anyone give me the brief description to how I set the cron to >>>>>> run the >>>>>> > task in background with example. >>>>>> >>>>> >>>>> >>>>> >>>>> >>>> >>> >>> >>> -- >>> Luciano Pacheco >>> blog.lucmult.com.br >>> >> >> > > > -- > Luciano Pacheco > blog.lucmult.com.br >
Re: [web2py] Re: cron setup
Yes I want to run the index function of my default controller in a cron is this possible or not ? On Tue, Feb 28, 2012 at 4:58 PM, Luciano Pacheco wrote: > You want to run the index function of your controller in a cron ? > > Usually it doesn't make sense, but, in the example file > > # file: applications/instore/modules/background_updater.py > > from applications.instore.controllers.default import index > > # instead of time.sleep(5), inside the function main() > index() > > I alson didn't understand what you want, if this doesn't solve your > question, try explain your use case. > > Regards, > > > On Tue, Feb 28, 2012 at 10:00 PM, Sanjeet Kumar wrote: > >> I am not be able to get you properly can you give me the better >> clarification i have the default controller and the index function can you >> tell me how can i run the index function by using crontab which are in my >> application folder. >> >> >> On Tue, Feb 28, 2012 at 4:12 PM, Luciano Pacheco wrote: >> >>> Following the same example. >>> >>> In you controller: >>> >>> from applications.instore.modules.background_updater main >>> >>> def force_background_updater(): >>> ret = main() >>> return 'The result was: %s' % ret >>> >>> But, the cron is run time based tasks, usually those tasks won't be used >>> in controller.One exception is when you want to force a task to run. >>> >>> Regards, >>> >>> >>> On Tue, Feb 28, 2012 at 9:11 PM, Sanjeet Kumar wrote: >>> >>>> i tried this but i am not be able to run my controller Can you give me >>>> the simple example through which i can run the function written under the >>>> controller inside my application >>>> >>>> >>>> On Mon, Feb 27, 2012 at 5:39 PM, Luciano Pacheco wrote: >>>> >>>>> Example: >>>>> >>>>> http://movu.ca/demo/article/show/31/web2py-cron-task >>>>> >>>>> My first try in movu.ca :-) >>>>> >>>>> >>>>> On Mon, Feb 27, 2012 at 2:32 PM, Sanjeet Kumar >>>>> wrote: >>>>> >>>>>> Exactly I need the examples >>>>>> >>>>>> >>>>>> On Mon, Feb 27, 2012 at 4:56 AM, Luciano Pacheco >>>>>> wrote: >>>>>> >>>>>>> I think Sanjeet means, I example of the task. >>>>>>> >>>>>>> What is a good practice in the task, or what kind of variables are >>>>>>> present in the local namespace "automagically", etc. A task should be a >>>>>>> class a function, a python module? >>>>>>> >>>>>>> I had the same question last week when I was reading this chapter. >>>>>>> :-) >>>>>>> >>>>>>> Regards, >>>>>>> -- >>>>>>> Luciano Pacheco >>>>>>> blog.lucmult.com.br >>>>>>> >>>>>>> On Mon, Feb 27, 2012 at 10:08 AM, Alan Etkin wrote: >>>>>>> >>>>>>>> It's all in the book (if you haven't seen yet) >>>>>>>> >>>>>>>> http://web2py.com/books/default/chapter/29/4#Cron >>>>>>>> >>>>>>>> By the way, The link in web2py to cron (http://web2py.com/books/ >>>>>>>> default/reference/29/cron<http://web2py.com/books/default/reference/29/cron>) >>>>>>>> is broken (returns an invalid function >>>>>>>> message) >>>>>>>> >>>>>>>> On 26 feb, 13:09, Sanjeet Kumar wrote: >>>>>>>> > Can anyone give me the brief description to how I set the cron to >>>>>>>> run the >>>>>>>> > task in background with example. >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Luciano Pacheco >>>>> blog.lucmult.com.br >>>>> >>>> >>>> >>> >>> >>> -- >>> Luciano Pacheco >>> blog.lucmult.com.br >>> >> >> > > > -- > Luciano Pacheco > blog.lucmult.com.br >
Re: [web2py] Re: cron setup
Thanks Luciano i will try. On Tue, Feb 28, 2012 at 5:06 PM, Luciano Pacheco wrote: > I have written to you how to do that. > > Copy and paste: > > , but, in the example file, do this changes: > > # file: applications/instore/modules/background_updater.py > > from applications.instore.controllers.default import index > > # instead of time.sleep(5), inside the function main() > index() > > On Tue, Feb 28, 2012 at 10:33 PM, Sanjeet Kumar wrote: > >> Yes I want to run the index function of my default controller in a cron >> is this possible or not ? >> >> On Tue, Feb 28, 2012 at 4:58 PM, Luciano Pacheco wrote: >> >>> You want to run the index function of your controller in a cron ? >>> >>> Usually it doesn't make sense, but, in the example file >>> >>> # file: applications/instore/modules/background_updater.py >>> >>> from applications.instore.controllers.default import index >>> >>> # instead of time.sleep(5), inside the function main() >>> index() >>> >>> I alson didn't understand what you want, if this doesn't solve your >>> question, try explain your use case. >>> >>> Regards, >>> >>> >>> On Tue, Feb 28, 2012 at 10:00 PM, Sanjeet Kumar >>> wrote: >>> >>>> I am not be able to get you properly can you give me the better >>>> clarification i have the default controller and the index function can you >>>> tell me how can i run the index function by using crontab which are in my >>>> application folder. >>>> >>>> >>>> On Tue, Feb 28, 2012 at 4:12 PM, Luciano Pacheco wrote: >>>> >>>>> Following the same example. >>>>> >>>>> In you controller: >>>>> >>>>> from applications.instore.modules.background_updater main >>>>> >>>>> def force_background_updater(): >>>>> ret = main() >>>>> return 'The result was: %s' % ret >>>>> >>>>> But, the cron is run time based tasks, usually those tasks won't be >>>>> used in controller.One exception is when you want to force a task to run. >>>>> >>>>> Regards, >>>>> >>>>> >>>>> On Tue, Feb 28, 2012 at 9:11 PM, Sanjeet Kumar >>>>> wrote: >>>>> >>>>>> i tried this but i am not be able to run my controller Can you give >>>>>> me the simple example through which i can run the function written under >>>>>> the controller inside my application >>>>>> >>>>>> >>>>>> On Mon, Feb 27, 2012 at 5:39 PM, Luciano Pacheco >>>>>> wrote: >>>>>> >>>>>>> Example: >>>>>>> >>>>>>> http://movu.ca/demo/article/show/31/web2py-cron-task >>>>>>> >>>>>>> My first try in movu.ca :-) >>>>>>> >>>>>>> >>>>>>> On Mon, Feb 27, 2012 at 2:32 PM, Sanjeet Kumar < >>>>>>> sanjeet@gmail.com> wrote: >>>>>>> >>>>>>>> Exactly I need the examples >>>>>>>> >>>>>>>> >>>>>>>> On Mon, Feb 27, 2012 at 4:56 AM, Luciano Pacheco >>>>>>> > wrote: >>>>>>>> >>>>>>>>> I think Sanjeet means, I example of the task. >>>>>>>>> >>>>>>>>> What is a good practice in the task, or what kind of variables are >>>>>>>>> present in the local namespace "automagically", etc. A task should be >>>>>>>>> a >>>>>>>>> class a function, a python module? >>>>>>>>> >>>>>>>>> I had the same question last week when I was reading this chapter. >>>>>>>>> :-) >>>>>>>>> >>>>>>>>> Regards, >>>>>>>>> -- >>>>>>>>> Luciano Pacheco >>>>>>>>> blog.lucmult.com.br >>>>>>>>> >>>>>>>>> On Mon, Feb 27, 2012 at 10:08 AM, Alan Etkin >>>>>>>>> wrote: >>>>>>>>> >>>>>>>>>> It's all in the book (if you haven't seen yet) >>>>>>>>>> >>>>>>>>>> http://web2py.com/books/default/chapter/29/4#Cron >>>>>>>>>> >>>>>>>>>> By the way, The link in web2py to cron (http://web2py.com/books/ >>>>>>>>>> default/reference/29/cron<http://web2py.com/books/default/reference/29/cron>) >>>>>>>>>> is broken (returns an invalid function >>>>>>>>>> message) >>>>>>>>>> >>>>>>>>>> On 26 feb, 13:09, Sanjeet Kumar wrote: >>>>>>>>>> > Can anyone give me the brief description to how I set the cron >>>>>>>>>> to run the >>>>>>>>>> > task in background with example. >>>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Luciano Pacheco >>>>>>> blog.lucmult.com.br >>>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> Luciano Pacheco >>>>> blog.lucmult.com.br >>>>> >>>> >>>> >>> >>> >>> -- >>> Luciano Pacheco >>> blog.lucmult.com.br >>> >> >> > > > -- > Luciano Pacheco > blog.lucmult.com.br >
Re: [web2py] Get the IP of the System
i want to insert the system ip address in the database so how i get the ip of the system through web2py controller On Tue, Feb 28, 2012 at 7:29 PM, Phyo Arkar wrote: > Which system? > > On 2/28/12, Sanjeet Kumar wrote: > > How we can get the IP address of the system > > >
Re: [web2py] Get the IP of the System
I want to insert the client system IP address in my database through the controller can you explain how i get the client IP address of the system when they login. On Tue, Feb 28, 2012 at 7:29 PM, Phyo Arkar wrote: > Which system? > > On 2/28/12, Sanjeet Kumar wrote: > > How we can get the IP address of the system > > >
Re: [web2py] Re: Capture the system shut down and browser close event
Alan can you explain in detail
On Tue, Feb 28, 2012 at 7:58 PM, Alan Etkin wrote:
> For checking if the server is up from the client browser (without
> refreshing the page) you can use jQuery .ajax() and a simple function
> at the controller to return the server state. I have submitted a LOAD
> helper enhancement to perform a ajax loop at the client side. It could
> be used for this purpose also (by defining an iterative javascript
> routine in a .load view)
>
> The inverse case is more difficult. Your operating system should write
> a sentry file before turning off for the web2py app to check it in a
> cron task or you could examine the system environment for checking the
> status from the web2py app also.
>
> Another way would be to have an operating system script to fire on
> shut down with a web request to the web2py application. The web2py app
> should implement a listener to perform the required actions before
> system shut down.
>
> On Feb 28, 7:55 am, Sanjeet Kumar wrote:
> > I am going to develop the time sheet app so for that i captured the login
> > and logout event through this :-
> > auth.settings.login_onaccept = lambda form: lgin(form)
> > auth.settings.logout_onlogout = lambda usr: lgout(usr)
> >
> > and one more question in my mind when the browser will be closed by some
> > reasons and the system will be shut-down due to power loss that time how
> we
> > capture the event and will show it logout and update our database
> following
> > is my database and the controller :-
> >
> > database:-
> >
> > db.define_table('employee_login_detail',
> > Field('employee_id'),
> > Field('employee_name'),
> > Field('employee_login_date'),
> > Field('employee_login_time'),
> > Field('employee_logout_date',default='Logged in'),
> > Field('employee_logout_time',default='Logged in'),
> > Field('total_minutes',default='Logged in'))
> >
> > Controller:-
> >
> > def lgin(form):
> > import datetime
> > import time
> > currentdate=datetime.date.today()
> > now = time.localtime(time.time())
> > starttime = datetime.datetime.now()
> > session.starttime = starttime
> > currenttime = time.strftime("%H:%M:%S", now)
> > session.time = currenttime
> > for row in db(db.auth_user.email ==
> > auth.user.email).select(db.auth_user.first_name):
> > firstname=row.first_name
> > db.employee_login_detail.insert(employee_id = auth.user.email,
> > employee_name=firstname, employee_login_date=currentdate,
> > employee_login_time=currenttime)
> > return ''
> >
> > def lgout(usr):
> > import datetime
> > import time
> > currentdate=datetime.date.today()
> > now = time.localtime(time.time())
> > endtime=datetime.datetime.now()
> > starttime = session.starttime
> > delta = (endtime - starttime)
> > totalminutes = str(delta.seconds / 60)
> > currenttime = time.strftime("%H:%M:%S", now)
> > db((db.employee_login_detail.employee_id == auth.user.email) &
> > (db.employee_login_detail.employee_login_date == currentdate) &
> > (db.employee_login_detail.employee_login_time ==
> > session.time)).update(employee_logout_date=currentdate,
> > employee_logout_time=currenttime, total_minutes=totalminutes)
> > return ''
>
Re: [web2py] Re: Capture the system shut down and browser close event
Massimo how can i use this
On Tue, Feb 28, 2012 at 7:41 PM, Massimo Di Pierro <
massimo.dipie...@gmail.com> wrote:
> you need do use websockets (gluon/contrib/comet_messaging.py)
>
> On Feb 28, 4:55 am, Sanjeet Kumar wrote:
> > I am going to develop the time sheet app so for that i captured the login
> > and logout event through this :-
> > auth.settings.login_onaccept = lambda form: lgin(form)
> > auth.settings.logout_onlogout = lambda usr: lgout(usr)
> >
> > and one more question in my mind when the browser will be closed by some
> > reasons and the system will be shut-down due to power loss that time how
> we
> > capture the event and will show it logout and update our database
> following
> > is my database and the controller :-
> >
> > database:-
> >
> > db.define_table('employee_login_detail',
> > Field('employee_id'),
> > Field('employee_name'),
> > Field('employee_login_date'),
> > Field('employee_login_time'),
> > Field('employee_logout_date',default='Logged in'),
> > Field('employee_logout_time',default='Logged in'),
> > Field('total_minutes',default='Logged in'))
> >
> > Controller:-
> >
> > def lgin(form):
> > import datetime
> > import time
> > currentdate=datetime.date.today()
> > now = time.localtime(time.time())
> > starttime = datetime.datetime.now()
> > session.starttime = starttime
> > currenttime = time.strftime("%H:%M:%S", now)
> > session.time = currenttime
> > for row in db(db.auth_user.email ==
> > auth.user.email).select(db.auth_user.first_name):
> > firstname=row.first_name
> > db.employee_login_detail.insert(employee_id = auth.user.email,
> > employee_name=firstname, employee_login_date=currentdate,
> > employee_login_time=currenttime)
> > return ''
> >
> > def lgout(usr):
> > import datetime
> > import time
> > currentdate=datetime.date.today()
> > now = time.localtime(time.time())
> > endtime=datetime.datetime.now()
> > starttime = session.starttime
> > delta = (endtime - starttime)
> > totalminutes = str(delta.seconds / 60)
> > currenttime = time.strftime("%H:%M:%S", now)
> > db((db.employee_login_detail.employee_id == auth.user.email) &
> > (db.employee_login_detail.employee_login_date == currentdate) &
> > (db.employee_login_detail.employee_login_time ==
> > session.time)).update(employee_logout_date=currentdate,
> > employee_logout_time=currenttime, total_minutes=totalminutes)
> > return ''
>
Re: [web2py] Get the IP of the System
Thanks Anthony i solved it by taking the IP by using the request.env.remote_addr remote address will be there but by using the list i get it properly On Wed, Feb 29, 2012 at 9:19 AM, Anthony wrote: > I've seen recommendations to check request.env.http_client_ip, > request.env.http_x_forwarded_for, and request.env.remote_addr, in that > order (remote_addr should always be there, but you want one of the other > two if available because the client may be behind a proxy). > > Anthony > > > On Tuesday, February 28, 2012 10:33:32 PM UTC-5, Sanjeet Kumar wrote: >> >> I want to insert the client system IP address in my database through the >> controller can you explain how i get the client IP address of the system >> when they login. >> >> On Tue, Feb 28, 2012 at 7:29 PM, Phyo Arkar wrote: >> >>> Which system? >>> >>> On 2/28/12, Sanjeet Kumar wrote: >>> > How we can get the IP address of the system >>> > >>> >> >>
Re: [web2py] Re: cron setup
I have the following code in my crontab :-
0-59/1****root **applications/welcome/cron/test.py
and the following code in my test.py which are inside the cron folder in my
application :-
db.person.insert(name="Alex")
and i want to insert this into the table person which are defined in the
model db.py :-
db.define_table('person', Field('name'))
so please help me through this example how automatically insert/update the
data in database by using cron job.
On Tue, Feb 28, 2012 at 5:10 PM, Sanjeet Kumar wrote:
> Thanks Luciano i will try.
>
>
> On Tue, Feb 28, 2012 at 5:06 PM, Luciano Pacheco wrote:
>
>> I have written to you how to do that.
>>
>> Copy and paste:
>>
>> , but, in the example file, do this changes:
>>
>> # file: applications/instore/modules/background_updater.py
>>
>> from applications.instore.controllers.default import index
>>
>> # instead of time.sleep(5), inside the function main()
>> index()
>>
>> On Tue, Feb 28, 2012 at 10:33 PM, Sanjeet Kumar wrote:
>>
>>> Yes I want to run the index function of my default controller in a cron
>>> is this possible or not ?
>>>
>>> On Tue, Feb 28, 2012 at 4:58 PM, Luciano Pacheco wrote:
>>>
>>>> You want to run the index function of your controller in a cron ?
>>>>
>>>> Usually it doesn't make sense, but, in the example file
>>>>
>>>> # file: applications/instore/modules/background_updater.py
>>>>
>>>> from applications.instore.controllers.default import index
>>>>
>>>> # instead of time.sleep(5), inside the function main()
>>>> index()
>>>>
>>>> I alson didn't understand what you want, if this doesn't solve your
>>>> question, try explain your use case.
>>>>
>>>> Regards,
>>>>
>>>>
>>>> On Tue, Feb 28, 2012 at 10:00 PM, Sanjeet Kumar
>>>> wrote:
>>>>
>>>>> I am not be able to get you properly can you give me the better
>>>>> clarification i have the default controller and the index function can you
>>>>> tell me how can i run the index function by using crontab which are in my
>>>>> application folder.
>>>>>
>>>>>
>>>>> On Tue, Feb 28, 2012 at 4:12 PM, Luciano Pacheco wrote:
>>>>>
>>>>>> Following the same example.
>>>>>>
>>>>>> In you controller:
>>>>>>
>>>>>> from applications.instore.modules.background_updater main
>>>>>>
>>>>>> def force_background_updater():
>>>>>> ret = main()
>>>>>> return 'The result was: %s' % ret
>>>>>>
>>>>>> But, the cron is run time based tasks, usually those tasks won't be
>>>>>> used in controller.One exception is when you want to force a task to run.
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>>
>>>>>> On Tue, Feb 28, 2012 at 9:11 PM, Sanjeet Kumar >>>>> > wrote:
>>>>>>
>>>>>>> i tried this but i am not be able to run my controller Can you give
>>>>>>> me the simple example through which i can run the function written under
>>>>>>> the controller inside my application
>>>>>>>
>>>>>>>
>>>>>>> On Mon, Feb 27, 2012 at 5:39 PM, Luciano Pacheco
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Example:
>>>>>>>>
>>>>>>>> http://movu.ca/demo/article/show/31/web2py-cron-task
>>>>>>>>
>>>>>>>> My first try in movu.ca :-)
>>>>>>>>
>>>>>>>>
>>>>>>>> On Mon, Feb 27, 2012 at 2:32 PM, Sanjeet Kumar <
>>>>>>>> sanjeet@gmail.com> wrote:
>>>>>>>>
>>>>>>>>> Exactly I need the examples
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Mon, Feb 27, 2012 at 4:56 AM, Luciano Pacheco <
>>>>>>>>> lucm...@gmail.com> wrote:
>>>>>>>>>
>>>>>>>>>> I think Sanjeet means, I example of the task.
>>>>>>>>>>
>>>>>>>>>> What is a good practice in the task, or what kind of variables
>>>>>>>>>> are present in the local namespace "automagically", etc. A task
>>>>>>>>>> should be a
>>>>>>>>>> class a function, a python module?
>>>>>>>>>>
>>>>>>>>>> I had the same question last week when I was reading this
>>>>>>>>>> chapter. :-)
>>>>>>>>>>
>>>>>>>>>> Regards,
>>>>>>>>>> --
>>>>>>>>>> Luciano Pacheco
>>>>>>>>>> blog.lucmult.com.br
>>>>>>>>>>
>>>>>>>>>> On Mon, Feb 27, 2012 at 10:08 AM, Alan Etkin
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> It's all in the book (if you haven't seen yet)
>>>>>>>>>>>
>>>>>>>>>>> http://web2py.com/books/default/chapter/29/4#Cron
>>>>>>>>>>>
>>>>>>>>>>> By the way, The link in web2py to cron (http://web2py.com/books/
>>>>>>>>>>> default/reference/29/cron<http://web2py.com/books/default/reference/29/cron>)
>>>>>>>>>>> is broken (returns an invalid function
>>>>>>>>>>> message)
>>>>>>>>>>>
>>>>>>>>>>> On 26 feb, 13:09, Sanjeet Kumar wrote:
>>>>>>>>>>> > Can anyone give me the brief description to how I set the cron
>>>>>>>>>>> to run the
>>>>>>>>>>> > task in background with example.
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Luciano Pacheco
>>>>>>>> blog.lucmult.com.br
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> Luciano Pacheco
>>>>>> blog.lucmult.com.br
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>> --
>>>> Luciano Pacheco
>>>> blog.lucmult.com.br
>>>>
>>>
>>>
>>
>>
>> --
>> Luciano Pacheco
>> blog.lucmult.com.br
>>
>
>
Re: [web2py] Re: cron setup
Luciano i removed the one * before the applications and tryed than i got
the following error :-
OperationalError: unable to open database file
Traceback (most recent call last):
File "/home/tls-sanjeet/Desktop/test/web2py/gluon/restricted.py", line
204, in restricted
exec ccode in environment
File "applications/welcome/models/db.py", line 14, in
db = DAL('sqlite://storage.sqlite')
File "/home/tls-sanjeet/Desktop/test/web2py/gluon/dal.py", line 4749, in
__init__
raise RuntimeError, "Failure to connect, tried %d times:\n%s" %
(attempts, tb)
RuntimeError: Failure to connect, tried 5 times:
Traceback (most recent call last):
File "/home/tls-sanjeet/Desktop/test/web2py/gluon/dal.py", line 4736, in
__init__
self._adapter = ADAPTERS[self._dbname](*args)
File "/home/tls-sanjeet/Desktop/test/web2py/gluon/dal.py", line 1655, in
__init__
self.pool_connection(connect)
File "/home/tls-sanjeet/Desktop/test/web2py/gluon/dal.py", line 444, in
pool_connection
self.connection = f()
File "/home/tls-sanjeet/Desktop/test/web2py/gluon/dal.py", line 1654, in
connect
return self.driver.Connection(dbpath, **driver_args)
OperationalError: unable to open database file
On Wednesday, February 29, 2012 6:39:22 PM UTC+5:30, lucmult wrote:
>
>
>
> On Wed, Feb 29, 2012 at 11:10 PM, Sanjeet Kumar wrote:
>
>> I have the following code in my crontab :-
>>
>> 0-59/1****root **applications/welcome/cron/test.py
>>
>
> put just 1 * before applications/
>
> [],
> --
> Luciano Pacheco
> blog.lucmult.com.br
>
[web2py] Add the drop-down in plugin_instant_admin for best searching
How can i implement the drop-down in plugin_instant_admin for best searching
[web2py] New web2py stable 1.99.5 creating problems and breaking the backward compatibility
i am very excited to use the new version of web2py 1.99.5 . when i downloaded it and use than i face the to many problems i am not be able to go the database administration when i click on the database administration it is redirecting to the site view and i also copied the my application which i developed in the previous version it is breaking the backward compatibility with plugin_instant_admin .
[web2py] Re: web2py 1.99.5 is OUT
i am very excited to use the new version of web2py 1.99.5 . when i
downloaded it and use than i face the to many problems i am not be able to
go the database administration when i click on the database administration
it is redirecting to the site view and i also copied the my application
which i developed in the previous version it is breaking the backward
compatibility with plugin_instant_admin .
On Friday, March 2, 2012 3:02:09 AM UTC+5:30, Massimo Di Pierro wrote:
>
> Many changes and improvements. Please check it asap and report your
> findings here.
>
> Attention: We slightly changed the behavior of auth.archive because
> version 1.99.* behaved differently than documented. If you are using
> auth.archive make sure to test your code.
>
> ## 1.99.5
> - admin in Russian (Bulat), Japanese (Omi) and Slovenian (Robert Valentak)
> - included web-based debugger (experimental, thanks Mariano)
> - def index(): return dict(a=gluon.tools.Expose(folder))
> - db.table.field.like(...,case_sensitive=False) (thanks Floyd)
> - db.table.field.regexp(...) for sqlite and postgres
> - db(...,ignore_common_filters=True)
> - db(db.dog_id.belongs(db.dogs.owner=='james')).select()
> - db(...).select().group_by_value(db.table.field) (thanks Yair)
> - db = DAL('imap://user:password@server:port') support (thanks Alan Etkin)
> - db = DAL('teradata://DSN=dsn;UID=user;PWD=pass; DATABASE=database')
> (thanks Adrew \
> Willmott)
> - db = DAL('mongodb://127.0.0.1:5984/db') (experimental, thanks Mark
> Breedveld)
> - db = DAL('cubrid') (experimental)
> - db = DAL('postgres:pg8000:...') and DAL('postgres:psycopg2:...')
> - pg8000 now ships with web2py )thanks Mariano)
> - reponse.delimiters = ('\\[','\\]') (thanks Denes)
> - auth.user_groups stores user groups
> - auth.is_impersonating()
> - populate can now deal with computed fields (thanks Tsvi Mostovicz)
> - new rediscache (thanks niphold)
> - sync languages capability (thanks Yair)
> - improved markmin auto-links
> - improved ldap support (thanks Omi)
> - added TimeCollector (thanks Caleb)
> - better cpdb.py (thanks pasxidis)
> - conditional menu items (reponse.menu=[(title,bool,link,[],condition)]
> - scripts/services/service.py (thanks Ross)
> - gluon/contrib/login_methods/browserid_account.py (thanks Pai)
> - gluon/contrib/htmlmin.py for html minimization (thanks kerncece)
> - web2py_component has timeout parameter, thanks Alan
> - 100's of small bug fixes and small improvements
>
>
>
[web2py] Re: web2py 1.99.5 is OUT
i am very excited to use the new version of web2py 1.99.5 . when i downloaded it and use than i face the to many problems i am not be able to go the database administration when i click on the database administration it is redirecting to the site view and i also copied the my application which i developed in the previous version it is breaking the backward compatibility with plugin_instant_admin .
Re: [web2py] Re: web2py 1.99.5 is OUT
when i am going to database administration i will be redirected to the site and i am using the instant_admin in my application but in that version all the layout for instant admin are breaked. On Fri, Mar 2, 2012 at 9:35 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > what specifically breaks? > > > On Friday, 2 March 2012 00:46:28 UTC-6, Sanjeet Kumar wrote: >> >> i am very excited to use the new version of web2py 1.99.5 . when i >> downloaded it and use than i face the to many problems i am not be able to >> go the database administration when i click on the database administration >> it is redirecting to the site view and i also copied the my application >> which i developed in the previous version it is breaking the backward >> compatibility with plugin_instant_admin . > >
Re: [web2py] Re: web2py 1.99.5 is OUT
In the new version 1.99.6 database administration problem are fixed but it is also breaking the plugin_instant_admin backward compatibility actually i am using the plugin_instant_admin in my application and when i copied the application in new version and run it than plugin_instant_admin layout is not working. On Fri, Mar 2, 2012 at 9:35 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > what specifically breaks? > > > On Friday, 2 March 2012 00:46:28 UTC-6, Sanjeet Kumar wrote: >> >> i am very excited to use the new version of web2py 1.99.5 . when i >> downloaded it and use than i face the to many problems i am not be able to >> go the database administration when i click on the database administration >> it is redirecting to the site view and i also copied the my application >> which i developed in the previous version it is breaking the backward >> compatibility with plugin_instant_admin . > >
Re: [web2py] Re: New web2py stable 1.99.5 creating problems and breaking the backward compatibility
Thanks pbreit In the new version 1.99.6 database administration problem are fixed but it is also breaking the plugin_instant_admin backward compatibility actually i am using the plugin_instant_admin in my application and when i copied the application in new version and run it than plugin_instant_admin layout is not working. On Fri, Mar 2, 2012 at 11:32 PM, pbreit wrote: > This has been fixed in 1.99.6
Re: [web2py] Re: New web2py stable 1.99.5 creating problems and breaking the backward compatibility
OK thanks Anthony On Sat, Mar 3, 2012 at 9:25 AM, Anthony wrote: > In the new version 1.99.6 database administration problem are fixed but it >> is also breaking the plugin_instant_admin backward compatibility actually i >> am using the plugin_instant_admin in my application and when i copied the >> application in new version and run it than plugin_instant_admin layout is >> not working. >> > > What exactly is wrong with plugin_instant_admin? If it is just a CSS > issue, then it's not a backward compatibility problem, as you're not > required to use the new "welcome" app CSS upon web2py upgrade. > > Anthony >
Re: [web2py] Re: web2py 1.99.5 is OUT
Sorry Massimo its my mistake it was the layout problem On Sat, Mar 3, 2012 at 11:19 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > How does it break it? Can you post a traceback? > > > On Friday, 2 March 2012 21:28:38 UTC-6, Sanjeet Kumar wrote: >> >> In the new version 1.99.6 database administration problem are fixed but >> it is also breaking the plugin_instant_admin backward compatibility >> actually i am using the plugin_instant_admin in my application and when i >> copied the application in new version and run it than plugin_instant_admin >> layout is not working. >> >> On Fri, Mar 2, 2012 at 9:35 PM, Massimo Di Pierro < >> massimo.dipie...@gmail.com> wrote: >> >>> what specifically breaks? >>> >>> >>> On Friday, 2 March 2012 00:46:28 UTC-6, Sanjeet Kumar wrote: >>>> >>>> i am very excited to use the new version of web2py 1.99.5 . when i >>>> downloaded it and use than i face the to many problems i am not be able to >>>> go the database administration when i click on the database administration >>>> it is redirecting to the site view and i also copied the my application >>>> which i developed in the previous version it is breaking the backward >>>> compatibility with plugin_instant_admin . >>> >>> >>
[web2py] Cron Set up
Can anyone explain me how i set up the background task in web2py
Re: [web2py] Cron Set up
Thanks Bruno On Mon, Mar 5, 2012 at 10:16 AM, Bruno Rocha wrote: > > > On Mon, Mar 5, 2012 at 1:39 AM, Sanjeet Kumar wrote: > >> Can anyone explain me how i set up the background task in web2py > > > http://movu.ca/demo/article/show/31/web2py-cron-task > > Also in the book there is a topic talking about it. > > -- > > Bruno Rocha > [http://rochacbruno.com.br] > >
Re: [web2py] Cron Set up
I am using the following model for test the cron :
db.define_table(('emp'),
Field('name'))
and in crontab file inside the welcome app i am using the :
*/1 * * * * root *applications/welcome/modules/background_updater.py
and makes the file inside the modules folder background_updater.py and used
the code :
db.emp.insert(name = 'Alex')
this code is inserting the Alex in the table emp within 1 minutes interval
this code is working in the version of web2py 1.99.4 perfectly but when i
try this same code in the version 1.99.7 i got the following error :-
RuntimeError: Failure to connect, tried 5 times:
Traceback (most recent call last):
File "/home/tls-sanjeet/Desktop/web2py/gluon/dal.py", line 5955, in
__init__
self._adapter = ADAPTERS[self._dbname](*args)
File "/home/tls-sanjeet/Desktop/web2py/gluon/dal.py", line 1732, in
__init__
self.pool_connection(connect)
File "/home/tls-sanjeet/Desktop/web2py/gluon/dal.py", line 465, in
pool_connection
self.connection = f()
File "/home/tls-sanjeet/Desktop/web2py/gluon/dal.py", line 1731, in
connect
return self.driver.Connection(dbpath, **driver_args)
OperationalError: unable to open database file
[web2py] Use the other login page instead of index
I am using the index as my home page and i want to call the another controller for login when the user click on the login link
Re: [web2py] Use the other login page instead of index
Actually i want to go to the another function in the default controller
when i click on the login it should be call the function such as emp()
istead of index and after login i want to stay on the emp() only
On Mon, Mar 5, 2012 at 1:14 PM, Bruno Rocha wrote:
> the login is by default in defautl/user/login not in index.
>
> you can set your own controller and function.
>
> Create a new controller with a function to expose dict(form=auth()) and in
> models set:
>
> auth.settings.controller = "myothercontroller"
> auth.settings.function = "myfunction"
>
> I am not sure if navbar will be automatically updated but you can create
> your own links using URL("controller", "function", args="login")
>
>
>
> http://zerp.ly/rochacbruno
> Em 05/03/2012 04:13, "Sanjeet Kumar" escreveu:
>
> I am using the index as my home page and i want to call the another
>> controller for login when the user click on the login link
>
>
Re: [web2py] Use the other login page instead of index
My problem is solved through capturing the login event
On Mon, Mar 5, 2012 at 1:48 PM, Sanjeet Kumar wrote:
> Actually i want to go to the another function in the default controller
> when i click on the login it should be call the function such as emp()
> istead of index and after login i want to stay on the emp() only
>
>
> On Mon, Mar 5, 2012 at 1:14 PM, Bruno Rocha wrote:
>
>> the login is by default in defautl/user/login not in index.
>>
>> you can set your own controller and function.
>>
>> Create a new controller with a function to expose dict(form=auth()) and
>> in models set:
>>
>> auth.settings.controller = "myothercontroller"
>> auth.settings.function = "myfunction"
>>
>> I am not sure if navbar will be automatically updated but you can create
>> your own links using URL("controller", "function", args="login")
>>
>>
>>
>> http://zerp.ly/rochacbruno
>> Em 05/03/2012 04:13, "Sanjeet Kumar" escreveu:
>>
>> I am using the index as my home page and i want to call the another
>>> controller for login when the user click on the login link
>>
>>
>
[web2py] get the dynamically value from the list and send the mail by using the cron job
i am able to send the mail through the cron job but when i am going to send the mail by fetching the email id from the database i got confused in the logic :- i have the followng code : list = [] import datetime currentdate = datetime.datetime.now() for row in db(db.employee.time == currentdate).select(): list.append(row.empdetail) here is my send mail function it is sending only the last id i know the for loop scope is ended that is the reason its happening but i am not be able to get the proper solution to send the mail to the each of the id only once with the all details when the date will be matched in the same table more than one emp details are there so i want to send the mail to the each individual employee at a time.
[web2py] Re: get the dynamically value from the list and send the mail by using the cron job
Actually i have the one company table :-
db.define_table(('comany'),
Field('cowner_id'),
Field('details'),
Field('due_date','date'))
here i want to send the mail with the details by using the cron when the
date will match to the due date :-
i have the following code in my modules send.py :-
from gluon.tools import Mail
mail=Mail()
#specify server
mail=auth.settings.mailer
mail.settings.server='smtp.gmail.com:587'
mail.settings.login='usern...@mail.com:password'
#specify address to send as
mail.settings.sender='usern...@mail.com'
#send the message
try:
import datetime
list[]
currentdate = datetime.date.today()
for row in db(db.company.due_date == currentdate).select():
list.append(details)
mail.send(to=[row.cowner_id],
subject='Sending the mail by using Cron job',
message=str(list))
except Exception, e:
print 'oops: %s' % e
here the problem is the if the i have many companies in our database than
how i sent the different mail to each of the different companies at a time
with all details when the due_date will match to the each of the companies.
here the for loop scope is ended so that is the reason to it is sending and
taking the only last data from my database and if i sent the mail by using
inside the scope of the for loop than the for each of the rows mail will be
sent with the details so its frustrated that is the reason i want to sent
the only one mail with all the details to the companies with date which
matches the today's date. But if the more than one companies in our
database than it is taking only the last because scope of for loop is ended
so how i resolve these issues please help me.
Re: [web2py] Hide the Extra added fields from auth table during the registrations
Thanks Bruno On Friday, February 24, 2012 11:36:08 AM UTC+5:30, rochacbruno wrote: > > def user(): > *if 'register' in request.args: > fields_to_hide = ['city', 'preferred_color', 'soccer_team'] > for fieldname in fields_to_hide: > field = db.auth_user[fieldname] > field.readable = field.writable = False* > > > > return dict(form=auth()) > > > On Fri, Feb 24, 2012 at 3:21 AM, Sanjeet Kumar wrote: > >> I am added the some extra fields in the auth_user table and i want to >> hide those fields when the user will go for the registration user can only >> see the following fields during the registration: >> >> >>- First name >>- Last name >>- email-id >>- Password >>- verify password >> >> > > > -- > > Bruno Rocha > [http://rochacbruno.com.br] > >
[web2py] Get the image from database
I have the following table :-
d.define_table(('employee',
)
[web2py] Get the Image from the database filtered on the email id
I have the following table :-
db.define_table(('employee',
Field('email_id', requires = IS_EMAIL()),
Field('image', 'upload'))
i want to show the image according to the filtration of email id. how it
will be possible in web2py
Re: [web2py] Re: Get the Image from the database filtered on the email id
Thanks Anthony
On Wed, Mar 7, 2012 at 8:40 PM, Anthony wrote:
> URL('default', 'download', args=db(db.employee.email_id ==
> some_id).select().first().image)
>
> This assumes you have the standard download() function in your default.py
> controller:
>
> def download():
> return response.download(request, db)
>
> Anthony
>
>
> On Wednesday, March 7, 2012 3:20:39 AM UTC-5, Sanjeet Kumar wrote:
>>
>> I have the following table :-
>>
>> db.define_table(('employee',
>>Field('email_id', requires = IS_EMAIL()),
>>Field('image', 'upload'))
>>
>> i want to show the image according to the filtration of email id. how it
>> will be possible in web2py
>>
>
Re: [web2py] Re: get the dynamically value from the list and send the mail by using the cron job
Thanks Alan On Thu, Mar 8, 2012 at 3:24 AM, Alan Etkin wrote: > If you want to avoid redundant mails, you can set a sequence of sent > id's and compare them at every loop iteration > > for message to send: >if not (the message was sent): >send the email > > Also, you should store email sent info between actions/task instances > to be able to query the sent list before sending. You can use a > special table or an extra field. > > On 6 mar, 09:29, Sanjeet Kumar wrote: > > i am able to send the mail through the cron job but when i am going to > send > > the mail by fetching the email id from the database i got confused in the > > logic :- > > > > i have the followng code : > > > > list = [] > > import datetime > > currentdate = datetime.datetime.now() > > for row in db(db.employee.time == currentdate).select(): > > list.append(row.empdetail) > > here is my send mail function it is sending only the last id i know the > for > > loop scope is ended that is the reason its happening but i am not be able > > to get the proper solution to send the mail to the each of the id only > once > > with the all details when the date will be matched in the same table more > > than one emp details are there so i want to send the mail to the > > each individual employee at a time. >
Re: [web2py] Re: get the dynamically value from the list and send the mail by using the cron job
Thanks Kim i will try this
On Thu, Mar 8, 2012 at 5:03 AM, Sean Kim wrote:
> Not really sure what you're saying, but I assume that basically you
> want to email the company with due date that matches current date.
> Wouldn't this work?
>
> currentdate = datetime.date.today()
> for row in db(db.company.due_date==currentdate).select():
> mail.send(to=[row.cowner_id],
>subject='Sending the mail by using Cron job'
> message=row.details)
>
> Why are you appending the company details to the list? If you want to
> get all of the company's details and email that to everyone, you will
> need to email once the loop's done retrieving all the details and
> emails.
>
> co_details = []
> co_emails = []
> for row in db(db.company.due_date==currentdate).select():
>co_emails.append(row.cowner_id)
>co_details.append(row.details)
>
> msg = ' '.join(co_details)
> for co_email in co_emails:
># you could just do to=co_emails if you don't need to send
> individual emails
>mail.send(to=[co_email],
> subject='Sending the mail by using Cron job'
>message=msg)
>
>
> On Mar 6, 11:17 pm, Sanjeet Kumar wrote:
> > Actually i have the one company table :-
> >
> > db.define_table(('comany'),
> > Field('cowner_id'),
> > Field('details'),
> > Field('due_date','date'))
> >
> > here i want to send the mail with the details by using the cron when the
> > date will match to the due date :-
> >
> > i have the following code in my modules send.py :-
> >
> > from gluon.tools import Mail
> > mail=Mail()
> > #specify server
> > mail=auth.settings.mailer
> > mail.settings.server='smtp.gmail.com:587'
> > mail.settings.login='usern...@mail.com:password'
> > #specify address to send as
> > mail.settings.sender='usern...@mail.com'
> > #send the message
> > try:
> > import datetime
> > list[]
> > currentdate = datetime.date.today()
> > for row in db(db.company.due_date == currentdate).select():
> > list.append(details)
> > mail.send(to=[row.cowner_id],
> > subject='Sending the mail by using Cron job',
> > message=str(list))
> > except Exception, e:
> > print 'oops: %s' % e
> >
> > here the problem is the if the i have many companies in our database than
> > how i sent the different mail to each of the different companies at a
> time
> > with all details when the due_date will match to the each of the
> companies.
> > here the for loop scope is ended so that is the reason to it is sending
> and
> > taking the only last data from my database and if i sent the mail by
> using
> > inside the scope of the for loop than the for each of the rows mail will
> be
> > sent with the details so its frustrated that is the reason i want to sent
> > the only one mail with all the details to the companies with date which
> > matches the today's date. But if the more than one companies in our
> > database than it is taking only the last because scope of for loop is
> ended
> > so how i resolve these issues please help me.
>
Re: [web2py] Re: Get the Image from the database filtered on the email id
Anthony i have one more question regarding this when the employee will
update his image than the updated images are shown but i guess the one more
problem here is the previous images are not deleted from our database so
how the previous image will be deleted when the employee will update the
image.
On Fri, Mar 9, 2012 at 9:11 AM, Sanjeet Kumar wrote:
> Thanks Anthony
>
>
> On Wed, Mar 7, 2012 at 8:40 PM, Anthony wrote:
>
>> URL('default', 'download', args=db(db.employee.email_id ==
>> some_id).select().first().image)
>>
>> This assumes you have the standard download() function in your default.py
>> controller:
>>
>> def download():
>> return response.download(request, db)
>>
>> Anthony
>>
>>
>> On Wednesday, March 7, 2012 3:20:39 AM UTC-5, Sanjeet Kumar wrote:
>>>
>>> I have the following table :-
>>>
>>> db.define_table(('employee',
>>>Field('email_id', requires = IS_EMAIL()),
>>>Field('image', 'upload'))
>>>
>>> i want to show the image according to the filtration of email id. how it
>>> will be possible in web2py
>>>
>>
>
Re: [web2py] Re: Get the Image from the database filtered on the email id
ok Antony On Fri, Mar 9, 2012 at 9:50 AM, Anthony wrote: > Anthony i have one more question regarding this when the employee will >> update his image than the updated images are shown but i guess the one more >> problem here is the previous images are not deleted from our database so >> how the previous image will be deleted when the employee will update the >> image. >> > > You mean the image isn't deleted from the filesystem, right? If you want > to delete old images upon update, I think you have to do that manually. We > should probably automate that. > > Anthony >
Re: [web2py] Re: Get the Image from the database filtered on the email id
Ok Anthony how can we automate that
Re: [web2py] Re: Get the Image from the database filtered on the email id
Ok Anthony Thanks
[web2py] add the drop-down and multiple selection in grid
How can i add the drop-down in the grid for the better searching and when i select the multiple check box at a time should be able to delete it by using the one button
[web2py] Web2Py Version 1.99.7 giving the trace back during run the Cron
I am using the following model for test the cron :
db.define_table(('emp'),
Field('name'))
and in crontab file inside the welcome app i am using the :
*/1 * * * * root *applications/welcome/modules/background_updater.py
and makes the file inside the modules folder background_updater.py and used
the code :
db.emp.insert(name = 'Alex')
this code is inserting the Alex in the table emp within 1 minutes interval
this code is working in the version of web2py 1.99.4 perfectly but when i
try this same code in the version 1.99.7 i got the following error :-
RuntimeError: Failure to connect, tried 5 times:
Traceback (most recent call last):
File "/home/tls-sanjeet/Desktop/web2py/gluon/dal.py", line 5955, in
__init__
self._adapter = ADAPTERS[self._dbname](*args)
File "/home/tls-sanjeet/Desktop/web2py/gluon/dal.py", line 1732, in
__init__
self.pool_connection(connect)
File "/home/tls-sanjeet/Desktop/web2py/gluon/dal.py", line 465, in
pool_connection
self.connection = f()
File "/home/tls-sanjeet/Desktop/web2py/gluon/dal.py", line 1731, in
connect
return self.driver.Connection(dbpath, **driver_args)
OperationalError: unable to open database file
[web2py] Re: Multiple Login methods
Hi Hassan please refer this link i think it will be useful for you :- http://www.web2py.com/books/default/chapter/29/9#Integration-with-OpenID,-Facebook,-etc. On Monday, March 12, 2012 8:30:36 PM UTC+5:30, Hassan Alnatour wrote: > > Dear ALL, > > I want to use Facebook and linked in and open iD and the normal auth > form form login and registration , how can i do that and when i use > this things for my website where dose the user register ?? > > Best Regards,
[web2py] How to check the extension of file from the controller
I have the upload field in table i want to check the file extension from the controller during the upload i am using :- SQLFORM.factory(db.emp_detail) if form.accepts(request.vars, session): img = form.vars.image if file.extension == 'something': update query
[web2py] Generate the render the html file in to doc file
How can i render the html file in to the doc file
Re: [web2py] Re: Generate the render the html file in to doc file
ok thanks Allan On Thu, Mar 15, 2012 at 5:13 PM, Alan Etkin wrote: > If you want to render html output as .rtf (a similar type of document > that will work in old ms-word versions) check the book at 10.3.2 > (PyRTF) > > On Mar 15, 8:15 am, Sanjeet Kumar wrote: > > How can i render the html file in to the doc file >
Re: [web2py] Re: How to check the extension of file from the controller
Thanks Anthony correct Alan i tried this working fine
On Thu, Mar 15, 2012 at 10:14 PM, Alan Etkin wrote:
> Anthony's answer is the right one, mine is for retrieving the
> extension of the url requested
>
> On 15 mar, 10:40, Anthony wrote:
> > request.vars.image.filename.split('.')[-1]
> >
> > or
> >
> > import os
> > os.path.splitext(request.vars.image.filename)[1][1:]
> >
> > Anthony
> >
> >
> >
> >
> >
> >
> >
> > On Thursday, March 15, 2012 6:18:10 AM UTC-4, Sanjeet Kumar wrote:
> >
> > > I have the upload field in table i want to check the file extension
> from
> > > the controller during the upload i am using :-
> >
> > > SQLFORM.factory(db.emp_detail)
> > > if form.accepts(request.vars, session):
> > > img = form.vars.image
> > > if file.extension == 'something':
> > > update query
>
[web2py] Re: How to hide all fields of SQLFORM with submit button only?
first write the following code and than use the SQLFORM it will hide your name field db.to_be_lawyer.name.readable = False On Mar 26, 3:31 pm, web2py_lover wrote: > How to hide all fields of SQLFORM with submit button only? > > all fields of db.to_be_lawyer are 'name' and 'age'. > > I try > db.to_be_lawyer.name.default = 'default name' > db.to_be_lawyer.age.default = '28' > form_to_be_lawyer= SQLFORM(db.to_be_lawyer, fields=[], buttons > = [INPUT(_type='submit',_value="apply to be a lawyer")] ) > > but fail.
[web2py] Re: SQLForm.grid : is it possible to delete multiple rows at once ?
can use the following :- form=SQLFORM.grid(db.auth_user, create=False, selectable = lambda ids: del_emp(ids)) def del_emp(ids): if not ids: response.flash='Please Select the Check-box to Delete' else: for row in ids: db(db.auth_user.id == row).delete() pass pass return '' you can see the submit button at the bottom of grid you can select the multiple check-box at a time and click the submit button it will delete the all select-able row at a time On Mar 26, 12:06 pm, Sebastien Stormacq wrote: > Thanks ! > > > > > > > > On Saturday, March 24, 2012 5:26:52 AM UTC+1, Javier wrote: > > > sabsto > > > You can use selectable, for example: > > > selectable = lambda ids: delete(ids) > > form=SQLFORM.grid(query,selectable=selectable) > > > def delete(ids): > > to_delete=db(db.tabla.id.belongs(ids)) > > to_delete.delete() > > > On Fri, Mar 23, 2012 at 9:46 PM, Derek wrote: > > >> Or you could avoid javascript, store the IDs of the "deleted" items in > >> the session and do your own calls to the DAL to delete items. > > >> On Friday, March 23, 2012 7:33:42 AM UTC-7, Anthony wrote: > > >>> Is it possible to select and delete multiple rows with one button click > using SQLFORM.grid ? (instead of clicking delete on each row) > I tried the "selectable" property but this doesn't help to delete. > I searched the archive of this group / mailing-list without success > > >>> Not out of the box. I suppose you could add a column (via the "links" > >>> argument) with "delete" checkboxes, and then add a "delete checked" button > >>> to the page with a Javascript event handler that identifies the checked > >>> records, submits a request to the server, and then possibly reloads the > >>> whole page or just the grid via Ajax. > > >>> Anthony
[web2py] Facing Trouble in Cascading drop-down with ajax
I am using the three cascading drop-down menu with the help of slices i am able to show the value in the second drop-down filtered on the first one but i am not be able to shown the value in the third drop-down filtration on the second via ajax so please help me.
Re: [web2py] Re: Facing Trouble in Cascading drop-down with ajax
Yes my code is from web2py slices
I have the following view :-
{{left_sidebar_enabled,right_sidebar_enabled=True,False}}
{{extend 'adminlayout.html'}}
Themis Project Console
Select Organization :
{{for org in organization:}}
{{=org.organization}}
{{pass}}
Select Department :
{{for category in categories:}}
{{=category.category}}
{{pass}}
Select Employee Email :
{{for maker in makers:}}
{{=maker.email}}
{{pass}}
{{=form}}
and the following Controller :-
def admin_assign_project():
for row2 in db(db.image.email == auth.user.email).select():
images=row2.image
db.assign_project.id.readable=False
form=SQLFORM.grid(db.assign_project)
projects=db().select(db.admin_add_project.ALL)
organization=db().select(db.auth_user.ALL)
categories = db().select(db.category.ALL)
if request.vars.org_name:
makers =
db(db.auth_user.organization==request.vars.org_name).select(db.auth_user.ALL)
else:
makers = db(db.auth_user.organization=='').select(db.auth_user.ALL)
return dict(organization=organization,categories=categories, makers=makers,
images=images, form=form)
def admin_assign():
makers =
db((db.auth_user.organization==request.vars.org_name)).select(db.auth_user.ALL)
result = ""
for maker in makers:
result += "" +
str(maker.category) + ""
result += ""
return XML(result)
def admin_assign_pro():
makers =
db((db.auth_user.department==request.vars.category_name)).select(db.auth_user.ALL)
result = ""
for maker in makers:
result += "" +
str(maker.email+'\t'+'('+maker.first_name+'\t'+maker.last_name+')') +
""
result += ""
return XML(result)
Here I want to value in second drop-down category_name filtered on the
first drop-down org_name which are selected and the value in the third
drop-down maker_name filtered on the second drop-down which will be
selected via ajax.
I am getting the value only in the second drop-down but i am not be able to
get the value in the third drop-down filtered on the second . Thanks in
advance .
[web2py] Re: cascading select, automatic triggers
Can you post your code for three cascading select via ajax i need this code
thanks in advance
On Thursday, April 21, 2011 10:19:46 AM UTC+5:30, ニコノコ wrote:
>
> I have a form with three cascading selects. A change in the selection,
> causes it to change the contents of the other selects. They work just fine,
> but I have other optional fields in the form which I wish the user to check
> out or input something before doing a "real" user triggered form submit.
>
> What are my other options for triggering the changes in the cascading
> selects without doing a submit of the form? Other than using JQuery, that
> is.
>
> I tried adding a checkbox as a workaround so that a user must click it
> first, something like "All of the above is complete and correct." If the
> user clicks on it, but there are form errors, the checkbox resets to False.
> I tried to set the form.vars.completed variable in a function called by
> onvalidation, but it's not changing the value. Also tried 'value',
> '_value', '_checked' of the form.element('#myselect'), with no success.
> (Can I even change the values a user has entered in a form?)
>
> /r
> Nik
>
Re: [web2py] Re: Facing Trouble in Cascading drop-down with ajax
Thanks Alan
On Fri, Mar 30, 2012 at 6:11 PM, Alan Etkin wrote:
> There may be javascript issues:
>
>
> > onchange="ajax('admin_assign',['org_name'],'shadow_clone');"
>
> Wouldn't the 'shadow_clone' be specified as '#shadow_clone'? (as it is an
> element selected by id)
>
> > onchange="jQuery(maker_name).remove(); ...
>
> Does the maker_name js variable exist? if maker_name is an element's name
> I'd use this instead:
>
> jQuery('[name=maker_name]').remove();
>
>
> On Friday, March 30, 2012 1:54:48 AM UTC-3, Sanjeet Kumar wrote:
>>
>> Yes my code is from web2py slices
>>
>> I have the following view :-
>>
>> {{left_sidebar_enabled,right_**sidebar_enabled=True,False}}
>> {{extend 'adminlayout.html'}}
>>
>> Themis Project Console
>>
>>
>>
>>
>>
>> Select Organization : > onchange="ajax('admin_assign',**['org_name'],'shadow_clone');"**>
>> {{for org in organization:}}
>>
>> {{=org.organization}}
>>
>> {{pass}}
>>
>>
>>
>>
>> Select Department : > onchange="jQuery(maker_name).**remove();
>> ajax('admin_assign_pro', ['category_name'], 'shadow_clone');">
>> {{for category in categories:}}
>> > {{=" selected='selected'" if
>> str(category.category)==**request.vars.category_name
>> else ""}}>
>> {{=category.category}}
>>
>> {{pass}}
>>
>>
>>
>>
>>
>>
>>Select Employee Email :
>> {{for maker in makers:}}
>> > {{=XML(" selected='selected'") if
>> str(maker.email)==request.**vars.maker_name else ""}}>
>> {{=maker.email}}
>>
>> {{pass}}
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> {{=form}}
>>
>>
>> and the following Controller :-
>>
>>
>> def admin_assign_project():
>> for row2 in db(db.image.email == auth.user.email).select():
>> images=row2.image
>> db.assign_project.id.readable=**False
>> form=SQLFORM.grid(db.assign_**project)
>> projects=db().select(db.admin_**add_project.ALL)
>> organization=db().select(db.**auth_user.ALL)
>> categories = db().select(db.category.ALL)
>> if request.vars.org_name:
>> makers = db(db.auth_user.organization==**request.vars.org_name).select(**
>> db.auth_user.ALL)
>> else:
>> makers = db(db.auth_user.organization==**'').select(db.auth_user.ALL)
>> return dict(organization=**organization,categories=**categories,
>> makers=makers, images=images, form=form)
>>
>> def admin_assign():
>> makers = db((db.auth_user.organization=**=request.vars.org_name)).**
>> select(db.auth_user.ALL)
>> result = ""
>> for maker in makers:
>> result += "" +
>> str(maker.category) + ""
>> result += ""
>> return XML(result)
>>
>>
>> def admin_assign_pro():
>> makers = db((db.auth_user.department==**request.vars.category_name)).
>> **select(db.auth_user.ALL)
>> result = ""
>> for maker in makers:
>> result += "" +
>> str(maker.email+'\t'+'('+**maker.first_name+'\t'+maker.**last_name+')')
>> + ""
>> result += ""
>> return XML(result)
>>
>>
>> Here I want to value in second drop-down category_name filtered on the
>> first drop-down org_name which are selected and the value in the third
>> drop-down maker_name filtered on the second drop-down which will be
>> selected via ajax.
>>
>> I am getting the value only in the second drop-down but i am not be able
>> to get the value in the third drop-down filtered on the second . Thanks in
>> advance .
>>
>
Re: [web2py] Re: Facing Trouble in Cascading drop-down with ajax
Thanks Antony I got it
On Fri, Mar 30, 2012 at 6:55 PM, Anthony wrote:
> > onchange="ajax('admin_assign',**['org_name'],'shadow_clone');"
>>
>> Wouldn't the 'shadow_clone' be specified as '#shadow_clone'? (as it is an
>> element selected by id)
>>
>
> No, the third argument of ajax() is just the id of the target element --
> the ajax() function itself prepends the "#" to select the specific element.
> So you cannot just specify any jQuery selector there -- it has to be an
> element id.
>
> Anthony
>
[web2py] Show the pop up by using the controller
I want to use the pop up on certain conditions through controller
