> > On spatialite the column type Float remains Float, but in Postgres the
> > Column becomes Real.
>
>
> Postgresql doesn't use the word "Float" to represent the type. It
> accepts the word "float" to create the type, but depending on precision
> will resolve it to REAL or DOUBLE
Hi to alls,
I have a problem with import and export real/float datatype from postgres
to spatialite and viceversa.
I have a table with some colums defined like this:
Column('skeleton_lenght', Float(2,2))
The sqlalchemy method charges the table in a Postgres DB and in a
Spatialite DB
Il giorno giovedì 11 settembre 2014 18:39:24 UTC+2, Jonathan Vanasco ha
scritto:
i once thought about extending SqlAlchemy to handle this issue behind the
scenes, but each database treats `IN()` differently. for example: oracle
maxes out at a number of elements, while mysql maxes out based
I had a mystical appearence!!!
I will put in a dictionary the parameters of searching used in the GUI.
If I would to sort the record, the script will re-do the search, which at
this time will use only a few parametrs, and I'll put an ORDER_BY in the
query.
The script will write dinamically as
Hi,
if I create many or request with a little number of id (list populated
with 10 values), the script return to me this message: Expression tree is
too large (maximum depth 1000)
So, It's possibile there is a limit for sqlite? This is a big problem for
using sqlalchemy/sqlite.
I cannot
Hi Michael and thanks a lot.
Il giorno venerdì 5 settembre 2014 18:23:31 UTC+2, Michael Bayer ha scritto:
you batch out the values to be used in the IN, then one of two choices:
my preference is to run separate SELECT statements, using IN with each
batch. If you really can’t do that, you
Bayer ha scritto:
On Sep 9, 2014, at 4:45 PM, pyArchInit ArcheoImagineers
pyarc...@gmail.com javascript: wrote:
Hi Michael and thanks a lot.
Il giorno venerdì 5 settembre 2014 18:23:31 UTC+2, Michael Bayer ha
scritto:
you batch out the values to be used in the IN, then one of two choices
Hi to all,
I looked for around the web without success.
I need to reproduce this kind of SQL distinct query:
SELECT DISTINCT column1 from table where column3= 'Value'
or two or more:
SELECT DISTINCT column1,column2 from table where column3= 'Value'
I tried something like this without success:
with a percent sign).
On Sep 27, 2013 5:06 PM, pyArchInit ArcheoImagineers
pyarchi...@gmail.com wrote:
Thanks a lot...sorry for my prevous post that I delete beacause I didn't
undestand I must to use this ~
def test_not_like(self):
Session = sessionmaker(bind=self.engine, autoflush=True
a lot and best regards
Luca
On Sun, Sep 29, 2013 at 5:57 PM, Michael Bayer mike...@zzzcomputing.comwrote:
On Sep 29, 2013, at 10:56 AM, pyArchInit ArcheoImagineers
pyarchi...@gmail.com wrote:
Hi to all.
I try to use the code in this way (query LIKE with OR operator)
res = session.query
Hi, and thanks for reply.
I try to use it but I make for sure a mistake:
def test_not_like(self): self.table_name = 'site_table' Session =
sessionmaker(bind=self.engine, autoflush=True, autocommit=True) session =
Session() query = session.query(SITE) table =
Table(self.table_name,self.metadata,
properly the result I expected but is a LIKE query, but I
need a NOT LIKE operator as I wrote in the object of this topic.
It's possible I didn't understand yours suggestion?
mmm...any ideas?
Thanks a lot fon any help.
Bye
Luca
On Fri, Sep 27, 2013 at 12:38 PM, pyArchInit ArcheoImagineers
Hi to all,
I need to realize a query like this
select * from my_table where field not like %value1% and field not like
%value2%
with a sqlalchemy sintax. I looked for around the documentation but it
seems be impossible.
Am I wrong? It's possible that the only way could be to use the
13 matches
Mail list logo