[Modeling-users] ec.fetch and SQL "in"

[Yannick G. <yan...@sa...>]

=2D----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Hi,=20
  Is there a way to make a fetch the same way you do with the SQL "in" ?
ex: "status in [1, 2, 5, 23]"

It is not that hard to make something like :=20
 =20
 qryLines =3D []
 for status in statuses:
     qryLines.append("( status =3D=3D %d)" % status)
 qry =3D " OR ".join(qryLines)

but it look like a hack to me and is probably really inefficient for
large lists since spark and the DBMS will have quite a ugly string to
parse.
 =20

=2D --=20
Yannick Gingras
Byte Gardener, Savoir-faire Linux inc.
(514) 276-5468

=2D----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/CZtsrhy5Fqn/MRARAjv2AJ0U9yhkMoVr7I78mmLwXZgbV4WgUgCghp5N
DdNV1VCDc5k7JkCCEsWyKTU=3D
=3Dvy0y
=2D----END PGP SIGNATURE-----