using System;
using System.Collections.Generic;
using System.Text;

namespace BrazilTimestampReconstruction
{
    class Constants
    {
        public const string GET_ANCHORS_QUERY = "SELECT box1,lc1,seg1,box2,lc2,seg2 FROM Anchors";
        public const string GET_ALL_SEGMENTS = @"SELECT DISTINCT box1, seg1
                                                FROM Anchors
                                                UNION
                                                SELECT DISTINCT box2, seg2
                                                FROM Anchors";
        public const string DEL_FITS =   @"DELETE FROM ClockFit";
        public const string INSERT_FIT = @"INSERT INTO ClockFit VALUES 
                                        (@boxid, @segment,@alpha, @beta, @chi2, @points, @path);";
        public const string DEL_REL_FITS = @"DELETE FROM LocalFit";
        public const string INSERT_REL_FIT = @"INSERT INTO LocalFit VALUES
                                             (@box1, @seg1, @box2, @seg2, @alpha, @beta, @chi2, @points)";

        public const string INIT_GPS_NODE = @"SELECT distinct box1, seg1
                                            FROM Anchors 
                                            WHERE box1 = box2 AND seg1=seg2";

        public const string KEY_SYMB = "_";
        public const char KEY_SYMB_CHAR = '_';
        public const string GPS_NODE = "-1";
        public const double HIGH_CHI = (double) 10000;
        public const int MIN_ANCHORS = 4;
        public const double MAX_GLOBAL_SKEW = 200.0;
        public const double MAX_LOCAL_SKEW = 100.0;
    }

}

/*
         public const string INSERT_FIT = @"INSERT INTO ClockFit VALUES 
                                        (@boxid, @segment, @parNode, @parSegment, @alpha, @beta, @chi2, @points);";

*/