Skip to Content
This question has been flagged
datepython2.7openerp7.0
3 Respostes
23775 Vistes
Avatar
Anirudh Lou

I am trying to retrieve a list in my database. My statement is this:

    cr.execute("select es.* from student_resource es where es.date between '"+str(date_from)+"' and '"+str(date_to)+"'")

where date_from and date_to are of type fields.date but when when executed, that is i am trying to access my view, it says:

TypeError: cannot concatenate 'str' and 'int' objects

What did i miss with my statement?

Avatar
Descartar
Avatar
Emipro Technologies Pvt. Ltd.
Best Answer

Hello,

As your fields are fields.date then you do not need to convert into string. Please write your query as like below.

cr.execute("select es.* from student_resource es where es.date between '" + date_from + "' and '" + date_to + "' ")
or
cr.execute("select es.* from student_resource es where es.date between '%s' and '%s' " %(date_from, date_to) )
Update : or
query = "select es.* from student_resource es where es.date between '%s' and '%s' " %(date_from, date_to)
cr.execute(query)

When you retrieve any date/datetime value from data base into any python variable it is always in string s

o no need to convert into string. 

I hope it will resole your issue.

Thanks. 

Avatar
Descartar
Anirudh Lou
Autor

I've tried your suggestion sir but I get "ValueError: unsupported format character 'W' (0x57) at index 545" when i try "...between ? and ? ",(date_from, date_to) )" i get "IndexError: tuple index out of range"

Emipro Technologies Pvt. Ltd.

Just try as I have updated my answer. I have test it at my side it is executed perfectly.

Avatar
Akhil P Sivan
Best Answer

I think you can use the to_date() in psql for that.

Try like this:

cr.execute("select es.* from student_resource es where es.date between to_date(date_from, 'YYYY/MM/DD') and to_date(date_to, 'YYYY/MM/DD')")  
OR 
cr.execute("select es.* from student_resource es where es.date between to_date("+str(date_from)+", 'YYYY/MM/DD') and to_date("+str(date_to)+", 'YYYY/MM/DD') ")

Avatar
Descartar
Avatar
Marvin Taboada
Best Answer

Quoting Psycopg official references (see here) :

Psycopg casts Python variables to SQL literals by type. Many standard Python types are already adapted to the correct SQL representation.

Don't manually add single quotes depending of the data type, let Psycopg do that for you.

cr.execute( 
    """INSERT INTO some_table (an_int, a_date, a_string) VALUES (%s, %s, %s);""",
    (11, datetime.date(2007, 07, 27), "Odoo rocks!"))

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Set 0 for a 'None' value which is inside a list Solved
list python2.7 openerp7.0
Avatar
Avatar
2
de des. 19
4976
How to make a dynamique _order in python ?
python2.7 openerp7.0 orderby
Avatar
Avatar
1
de març 15
7055
please explain this strange override super behaviour
python orm python2.7 openerp7.0
Avatar
0
de febr. 16
3672
How to populate a one2many field from another one2many field? Solved
one2many python2.7 openerp7 openerp7.0
Avatar
Avatar
2
d’ag. 15
7294
How to set parent_id while creating it's child on on_change method?
on_change python2.7 openerp7.0 populate
Avatar
Avatar
1
d’ag. 15
5432