Ejemplo n.º 1
0
 /// <summary>
 /// Returns the template table for imports ways in Sql Server
 /// </summary>
 /// <returns>Template table for saving way</returns>
 public static DataTable GetTableWays()
 {
     ConstructDataTable ways = new ConstructDataTable("dbo.Ways");
     ways.AddColumn("id", TypeDataTable.Int64);
     ways.AddColumn("typeGeo", TypeDataTable.Byte);
     ways.AddColumn("times", TypeDataTable.DateTime);
     return ways.GetDataTable();
 }
Ejemplo n.º 2
0
 /// <summary>
 /// Returns the template table for imports ways and nodes in Sql Server
 /// </summary>
 /// <returns>Template table for saving way and refs (nodes in way)</returns>
 public static DataTable GetTableWaysRefs()
 {
     ConstructDataTable waysRefs = new ConstructDataTable("dbo.WaysRefs");
     waysRefs.AddColumn("idWay", TypeDataTable.Int64);
     waysRefs.AddColumn("idNode", TypeDataTable.Int64);
     waysRefs.AddColumn("orders", TypeDataTable.Int16);
     return waysRefs.GetDataTable();
 }
Ejemplo n.º 3
0
 /// <summary>
 /// Returns the template table for imports geos as a varbinary(max) in Sql Server
 /// </summary>
 /// <returns>Template table for saving geos as a varbinary(max)</returns>
 public static DataTable GetTableGeo()
 {
     ConstructDataTable constructDataTable = new ConstructDataTable("dbo.Geo");
     constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
     constructDataTable.AddColumn("bin", TypeDataTable.ByteArray);
     constructDataTable.AddColumn("typeGeo", TypeDataTable.Int16);
     return constructDataTable.GetDataTable();
 }
Ejemplo n.º 4
0
 /// <summary>
 /// Returns the template table for imports nodes in Sql Server
 /// </summary>
 /// <returns>Template table for saving node</returns>
 public static DataTable GetTableNodes()
 {
     ConstructDataTable nodes = new ConstructDataTable("dbo.Nodes");
     nodes.AddColumn("id", TypeDataTable.Int64);
     nodes.AddColumn("lat", TypeDataTable.Double);
     nodes.AddColumn("lon", TypeDataTable.Double);
     nodes.AddColumn("times", TypeDataTable.DateTime);
     return nodes.GetDataTable();
 }
Ejemplo n.º 5
0
        /// <summary>
        /// Returns the template table for imports ways in Sql Server
        /// </summary>
        /// <returns>Template table for saving way</returns>
        public static DataTable GetTableWays()
        {
            ConstructDataTable ways = new ConstructDataTable("dbo.Ways");

            ways.AddColumn("id", TypeDataTable.Int64);
            ways.AddColumn("typeGeo", TypeDataTable.Byte);
            ways.AddColumn("times", TypeDataTable.DateTime);
            return(ways.GetDataTable());
        }
Ejemplo n.º 6
0
        /// <summary>
        /// Returns the template table for imports ways and nodes in Sql Server
        /// </summary>
        /// <returns>Template table for saving way and refs (nodes in way)</returns>
        public static DataTable GetTableWaysRefs()
        {
            ConstructDataTable waysRefs = new ConstructDataTable("dbo.WaysRefs");

            waysRefs.AddColumn("idWay", TypeDataTable.Int64);
            waysRefs.AddColumn("idNode", TypeDataTable.Int64);
            waysRefs.AddColumn("orders", TypeDataTable.Int16);
            return(waysRefs.GetDataTable());
        }
Ejemplo n.º 7
0
        /// <summary>
        /// Returns the template table for imports geos as a varbinary(max) in Sql Server
        /// </summary>
        /// <returns>Template table for saving geos as a varbinary(max)</returns>
        public static DataTable GetTableGeo()
        {
            ConstructDataTable constructDataTable = new ConstructDataTable("dbo.Geo");

            constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
            constructDataTable.AddColumn("bin", TypeDataTable.ByteArray);
            constructDataTable.AddColumn("typeGeo", TypeDataTable.Int16);
            return(constructDataTable.GetDataTable());
        }
Ejemplo n.º 8
0
        /// <summary>
        /// Returns the template table for imports nodes in Sql Server
        /// </summary>
        /// <returns>Template table for saving node</returns>
        public static DataTable GetTableNodes()
        {
            ConstructDataTable nodes = new ConstructDataTable("dbo.Nodes");

            nodes.AddColumn("id", TypeDataTable.Int64);
            nodes.AddColumn("lat", TypeDataTable.Double);
            nodes.AddColumn("lon", TypeDataTable.Double);
            nodes.AddColumn("times", TypeDataTable.DateTime);
            return(nodes.GetDataTable());
        }
Ejemplo n.º 9
0
 public static DataTable GetTableTagsValuesTrans()
 {
     ConstructDataTable constructDataTable = new ConstructDataTable("dbo.TagsValuesTrans");
     constructDataTable.AddColumn("tagHash", TypeDataTable.Int32);
     constructDataTable.AddColumn("valueHash", TypeDataTable.Int32);
     constructDataTable.AddColumn("tagTrans", TypeDataTable.String);
     constructDataTable.AddColumn("valTrans", TypeDataTable.String);
     constructDataTable.AddColumn("LCID", TypeDataTable.Int16);
     constructDataTable.AddColumn("typeTrans", TypeDataTable.Byte);
     return constructDataTable.GetDataTable();
 }
Ejemplo n.º 10
0
 /// <summary>
 /// Creates a table for storing tags and their values
 /// </summary>
 /// <returns>Table for storing tags and their values</returns>
 public static DataTable GetTableTagsValue()
 {
     ConstructDataTable constructDataTable = new ConstructDataTable("dbo.TagsValues");
     constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
     constructDataTable.AddColumn("tag", TypeDataTable.Int32);
     constructDataTable.AddColumn("vType", TypeDataTable.Int16);
     constructDataTable.AddColumn("vHash", TypeDataTable.Int32);
     constructDataTable.AddColumn("vString", TypeDataTable.String);
     constructDataTable.AddColumn("vInt", TypeDataTable.Int32);
     return constructDataTable.GetDataTable();
 }
Ejemplo n.º 11
0
        /// <summary>
        /// Creates a table for storing tags and their values
        /// </summary>
        /// <returns>Table for storing tags and their values</returns>
        public static DataTable GetTableTagsValue()
        {
            ConstructDataTable constructDataTable = new ConstructDataTable("dbo.TagsValues");

            constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
            constructDataTable.AddColumn("tag", TypeDataTable.Int32);
            constructDataTable.AddColumn("vType", TypeDataTable.Int16);
            constructDataTable.AddColumn("vHash", TypeDataTable.Int32);
            constructDataTable.AddColumn("vString", TypeDataTable.String);
            constructDataTable.AddColumn("vInt", TypeDataTable.Int32);
            return(constructDataTable.GetDataTable());
        }
Ejemplo n.º 12
0
        public static DataTable GetTableTagsValuesTrans()
        {
            ConstructDataTable constructDataTable = new ConstructDataTable("dbo.TagsValuesTrans");

            constructDataTable.AddColumn("tagHash", TypeDataTable.Int32);
            constructDataTable.AddColumn("valueHash", TypeDataTable.Int32);
            constructDataTable.AddColumn("tagTrans", TypeDataTable.String);
            constructDataTable.AddColumn("valTrans", TypeDataTable.String);
            constructDataTable.AddColumn("LCID", TypeDataTable.Int16);
            constructDataTable.AddColumn("typeTrans", TypeDataTable.Byte);
            return(constructDataTable.GetDataTable());
        }
Ejemplo n.º 13
0
 /// <summary>
 /// Returns the template table for imports ways in Sql Server
 /// </summary>
 /// <returns>Template table for saving way</returns>
 private DataTable GetTableWays()
 {
     ConstructDataTable ways = new ConstructDataTable("dbo.Ways");
     ways.AddColumn("id", TypeDataTable.Int64);
     ways.AddColumn("typeGeo", TypeDataTable.Byte);
     ways.AddColumn("orders", TypeDataTable.Int16);
     ways.AddColumn("idNode", TypeDataTable.Int64);
     ways.AddColumn("times", TypeDataTable.DateTime);
     return ways.GetDataTable();
 }
Ejemplo n.º 14
0
 /// <summary>
 /// Creates a table for storing tags and their values
 /// </summary>
 /// <returns>Table for storing tags and their values</returns>
 private DataTable GetTableTagsValue()
 {
     ConstructDataTable constructDataTable = new ConstructDataTable(_importConfigurator.DataBaseConfig.TableNameValues);
     constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
     constructDataTable.AddColumn("tag", TypeDataTable.Int32);
     constructDataTable.AddColumn("vType", TypeDataTable.Int16);
     constructDataTable.AddColumn("vHash", TypeDataTable.Int32);
     constructDataTable.AddColumn("vString", TypeDataTable.String);
     constructDataTable.AddColumn("vInt", TypeDataTable.Int32);
     return constructDataTable.GetDataTable();
 }
Ejemplo n.º 15
0
 /// <summary>
 /// Returns the template table for imports node as a varbinary(max) in Sql Server
 /// </summary>
 /// <returns>Template table for saving node as a varbinary(max)</returns>
 private DataTable GetTableGeo()
 {
     ConstructDataTable constructDataTable = new ConstructDataTable(_importConfigurator.DataBaseConfig.TableNameGeo);
     constructDataTable.AddColumn("idGeo", TypeDataTable.Int64);
     constructDataTable.AddColumn("bin", TypeDataTable.ByteArray);
     constructDataTable.AddColumn("typeGeo", TypeDataTable.Int16);
     return constructDataTable.GetDataTable();
 }