Execute query

[Fabio Lenzarini]

Hi, is possible to perform query like:

join, outer join with open function?

Or I need to use something like:

    sql = []

    sql.append('select firsttable.a, secondTable.b from firsttable join secondTable.....') 

    item.task.execute(sql)

thanks

Fabio

[Drazen D. Babic]

Hi, 

there is no restriction in SQL on the server module, as I understand.

Is it not working?

D.

[Fabio Lenzarini]

I don't know, i don't have try.. 😀

But I just wanted to know if there was something in the i framework if it was to be built by hand.

--
You received this message because you are subscribed to the Google Groups "Jam.py Users Mailing List" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jam-py+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jam-py/fb1db718-b419-4b0b-ab56-6025d2299327n%40googlegroups.com.

[Andrew Yushev]

it is possible, but you must use execute_select method of the task.

The other way is to create a connection and use Python DB API.

For example, for SQLite see

https://docs.python.org/3/library/sqlite3.html

For the project database use can use the connect method of the task

  

вс, 11 апр. 2021 г. в 16:40, Fabio Lenzarini <fabio.l...@gmail.com>:

To view this discussion on the web visit https://groups.google.com/d/msgid/jam-py/CAFnDzjMT475M7pVSdZC%3DroUEgm6GbTQyP8gFZfr-bGgyNDwuig%40mail.gmail.com.