I need to write SQLite function circle. A query like the following will be used to find all R*Tree entries that overlap with a circle centered a 45.3,22.9 with a radius of 5.0:
SELECT id FROM demo_index WHERE id MATCH circle(45.3, 22.9, 5.0)
I have started with this:
[SQLiteFunction(Arguments = 3, FuncType = FunctionType.Scalar, Name = "circle")]
    public class GetPointsInCircle : SQLiteFunction
    {
        public override object Invoke(object[] args)
        {
           double centerX = Convert.ToDouble(args[0]);
           double centerY = Convert.ToDouble(args[1]);
           double radius = Convert.ToDouble(args[2]);
        }
    }
As I searched about Invoke method, it has deal with args which are passed during method call. But how should I get access for current r*-tree to retrive necessary entries?
Aucun commentaire:
Enregistrer un commentaire