I'd like to insert a row with a point geometry with pyspatialite. The sql looks like this:
insert into eqdata(origin_time, url, mag, lat, lon, depth, m_a, region, mt, the_geom)
values ('2013-11-10 07:39:59', 'http://geofon.gfz-potsdam.de/event.php?id=gfz2013walq', 4.300000, -19.840000, 70.050000, 45.000000, 'M',
'Near Coast of Northern Chile', 'None', geomfromtext('POINT(-19.840000 70.050000)', 4326));
This does not work and produces this error:
spatialite.dbapi2.IntegrityError: eqdata.the_geom violates Geometry constraint [geom-type or SRID not allowed]
If I execute the same SQL in the same database with spatialite_gui it works without any problem.
How can I handle this problem with pyspatialite?