public static OsmWay ConvertTo(SimpleWay way, List<long> nodes)
{
OsmWay new_way = new OsmWay();
new_way.Id = way.Id.Value;
new_way.Nds = nodes;
new_way.Tags = PrimitiveExtensions.ConvertTo(way.Tags);
return new_way;
}
/// <summary>
/// Updates a way.
/// </summary>
/// <param name="way"></param>
public void UpdateWay(SimpleWay way)
{
_ways[way.Id.Value] = way;
}
public override void AddWay(SimpleWay way)
{
DataRow way_row = _way_table.NewRow();
// format data and create parameters.
long? id = way.Id.Value; // id should always contain a value.
way_row["id"] = id.ConvertToDBValue<long>();
long? changeset_id = way.ChangeSetId;
way_row["changeset_id"] = changeset_id.ConvertToDBValue<long>();
bool? visible = way.Visible;
int visible_int = 1;
if (!visible.HasValue || !visible.Value)
{
visible_int = 0;
}
way_row["visible"] = visible_int;
DateTime? timestamp = way.TimeStamp;
way_row["timestamp"] = timestamp.ConvertToDBValue<DateTime>();
ulong? version = way.Version;
way_row["version"] = version.ConvertToDBValue<ulong>();
// set the usr
way_row["usr"] = way.UserName.ToStringEmptyWhenNull();
way_row["usr_id"] = way.UserId.ConvertToDBValue<long>();
// add the way and it's tags.
_way_table.Rows.Add(way_row);
// tags.
if (way.Tags != null)
{
foreach (KeyValuePair<string, string> tag in way.Tags)
{
string key = tag.Key;
string value = tag.Value;
if (key == null || key.Length == 0)
{
//throw new Exception();
}
else
{
DataRow tag_row = _way_tags_table.NewRow();
tag_row["way_id"] = id;
tag_row["key"] = key.Truncate(255);
tag_row["value"] = value.Truncate(255);
_way_tags_table.Rows.Add(tag_row);
}
}
}
// insert way nodes.
if (way.Nodes != null)
{
long way_id = way.Id.Value;
for (int idx = 0; idx < way.Nodes.Count; idx++)
{
long node_id = way.Nodes[idx];
DataRow tag_row = _way_nodes_table.NewRow();
tag_row["way_id"] = id;
tag_row["node_id"] = node_id;
tag_row["sequence_id"] = idx;
_way_nodes_table.Rows.Add(tag_row);
}
}
// bulk insert if needed.
if (_way_table.Rows.Count >= _batch_ways)
{
this.BulkCopy(_way_table, "way");
this.BulkCopy(_way_tags_table, "way_tags");
this.BulkCopy(_way_nodes_table, "way_nodes");
this.CreateWayTables();
}
}
/// <summary>
/// Modifies the given way.
/// </summary>
/// <param name="way"></param>
private void Modify(SimpleWay way)
{
OracleCommand command;
string sql = string.Empty;
DateTime? timestamp = way.TimeStamp;
if (timestamp.HasValue)
{
sql = "update way set changeset_id=:changeset_id,visible=:visible,timestamp=to_date('{0}','YYYY/MM/DD HH24:MI'),version=:version, usr=:usr, usr_id=:usr_id where id = :id";
sql = string.Format(sql, timestamp.Value.ToString("yyyy/MM/dd HH:mm"));
}
else
{
sql = "update way set changeset_id=:changeset_id,visible=:visible,timestamp=null,version=:version where id = :id";
}
command = this.CreateCommand(sql);
// format data and create parameters.
long? id = way.Id;
command.Parameters.Add(new OracleParameter("id", id.ConvertToDBValue<long>()));
long? changeset_id = way.ChangeSetId;
command.Parameters.Add(new OracleParameter("changeset_id", changeset_id.ConvertToDBValue<long>()));
bool? visible = way.Visible;
int visible_int = 1;
if (!visible.HasValue || !visible.Value)
{
visible_int = 0;
}
command.Parameters.Add("visible", visible_int);
long? version = (long)way.Version;
command.Parameters.Add(new OracleParameter("version", version.ConvertToDBValue<long>()));
command.Parameters.Add("usr", way.UserName);
command.Parameters.Add("usr_id", way.UserId);
command.ExecuteNonQuery();
command.Dispose();
if (this.Exists("way", way.Id.Value))
{
// update tags.
this.ModifyTags(way.Id.Value, way.Tags, "way_tags", "way_id");
// modify nodes.
this.ModifyWayNodes(way.Id.Value, way.Nodes);
}
// raise the modified event.
this.RaiseChange(SimpleChangeType.Modify, SimpleOsmGeoType.Way, way.Id.Value);
}
/// <summary>
/// Converts simple primitives.
/// </summary>
/// <param name="pbf_primitive"></param>
/// <returns></returns>
internal SimpleOsmGeo Convert(KeyValuePair<PrimitiveBlock, object> pbf_primitive)
{
if (pbf_primitive.Value == null || pbf_primitive.Key == null)
{
throw new ArgumentNullException("pbf_primitive");
}
PrimitiveBlock block = pbf_primitive.Key; // get the block properties this object comes from.
if (pbf_primitive.Value is Node)
{
Node node = (pbf_primitive.Value as Node);
SimpleNode simple_node = new SimpleNode();
simple_node.ChangeSetId = node.info.changeset;
simple_node.Id = node.id;
simple_node.Latitude = .000000001 * ((double)block.lat_offset
+ ((double)block.granularity * (double)node.lat));
simple_node.Longitude = .000000001 * ((double)block.lon_offset
+ ((double)block.granularity * (double)node.lon));
simple_node.Tags = new Dictionary<string, string>();
for (int tag_idx = 0; tag_idx < node.keys.Count; tag_idx++)
{
string key = ASCIIEncoding.ASCII.GetString(block.stringtable.s[(int)node.keys[tag_idx]]);
string value = ASCIIEncoding.ASCII.GetString(block.stringtable.s[(int)node.vals[tag_idx]]);
if (!simple_node.Tags.ContainsKey(key))
{
simple_node.Tags.Add(new KeyValuePair<string, string>(key, value));
}
}
simple_node.TimeStamp = OsmSharp.Tools.Utilities.FromUnixTime((long)node.info.timestamp *
(long)block.date_granularity);
simple_node.Visible = true;
simple_node.Version = (uint)node.info.version;
simple_node.UserId = node.info.uid;
simple_node.UserName = ASCIIEncoding.ASCII.GetString(block.stringtable.s[node.info.user_sid]);
simple_node.Version = (ulong)node.info.version;
simple_node.Visible = true;
return simple_node;
}
else if (pbf_primitive.Value is Way)
{
Way way = (pbf_primitive.Value as Way);
SimpleWay simple_way = new SimpleWay();
simple_way.Id = way.id;
simple_way.Nodes = new List<long>(way.refs.Count);
long node_id = 0;
for (int node_idx = 0; node_idx < way.refs.Count; node_idx++)
{
node_id = node_id + way.refs[node_idx];
simple_way.Nodes.Add(node_id);
}
simple_way.Tags = new Dictionary<string, string>();
for (int tag_idx = 0; tag_idx < way.keys.Count; tag_idx++)
{
string key = ASCIIEncoding.ASCII.GetString(block.stringtable.s[(int)way.keys[tag_idx]]);
string value = ASCIIEncoding.ASCII.GetString(block.stringtable.s[(int)way.vals[tag_idx]]);
if (!simple_way.Tags.ContainsKey(key))
{
simple_way.Tags.Add(new KeyValuePair<string, string>(key, value));
}
}
if (way.info != null)
{ // add the metadata if any.
simple_way.ChangeSetId = way.info.changeset;
simple_way.TimeStamp = OsmSharp.Tools.Utilities.FromUnixTime((long)way.info.timestamp *
(long)block.date_granularity);
simple_way.UserId = way.info.uid;
simple_way.UserName = ASCIIEncoding.ASCII.GetString(block.stringtable.s[way.info.user_sid]);
simple_way.Version = (ulong)way.info.version;
}
simple_way.Visible = true;
return simple_way;
}
else if (pbf_primitive.Value is Relation)
{
Relation relation = (pbf_primitive.Value as Relation);
SimpleRelation simple_relation = new SimpleRelation();
simple_relation.Id = relation.id;
simple_relation.Members = new List<SimpleRelationMember>();
long member_id = 0;
for (int member_idx = 0; member_idx < relation.types.Count; member_idx++)
{
member_id = member_id + relation.memids[member_idx];
string role = ASCIIEncoding.ASCII.GetString(
block.stringtable.s[relation.roles_sid[member_idx]]);
SimpleRelationMember member = new SimpleRelationMember();
member.MemberId = member_id;
member.MemberRole = role;
switch(relation.types[member_idx])
{
case Relation.MemberType.NODE:
member.MemberType = SimpleRelationMemberType.Node;
break;
case Relation.MemberType.WAY:
member.MemberType = SimpleRelationMemberType.Way;
break;
case Relation.MemberType.RELATION:
member.MemberType = SimpleRelationMemberType.Relation;
break;
}
simple_relation.Members.Add(member);
}
simple_relation.Tags = new Dictionary<string, string>();
for (int tag_idx = 0; tag_idx < relation.keys.Count; tag_idx++)
{
string key = ASCIIEncoding.ASCII.GetString(block.stringtable.s[(int)relation.keys[tag_idx]]);
string value = ASCIIEncoding.ASCII.GetString(block.stringtable.s[(int)relation.vals[tag_idx]]);
if (!simple_relation.Tags.ContainsKey(key))
{
simple_relation.Tags.Add(new KeyValuePair<string, string>(key, value));
}
}
if (relation.info != null)
{ // read metadata if any.
simple_relation.ChangeSetId = relation.info.changeset;
simple_relation.TimeStamp = OsmSharp.Tools.Utilities.FromUnixTime((long)relation.info.timestamp *
(long)block.date_granularity);
simple_relation.UserId = relation.info.uid;
simple_relation.UserName = ASCIIEncoding.ASCII.GetString(block.stringtable.s[relation.info.user_sid]);
simple_relation.Version = (ulong)relation.info.version;
}
simple_relation.Visible = true;
return simple_relation;
}
throw new Exception(string.Format("PBF primitive with type {0} not supported!",
pbf_primitive.GetType().ToString()));
}
public void init()
{
// initialize the connection.
APIConnection api_instance = new APIConnection(
"http://api06.dev.openstreetmap.org/",
"osmsharp", "osmsharp");
// open a changeset.
long changeset_id = api_instance.ChangeSetOpen("An example comment!");
// initialize the nodes.
SimpleNode node1 = new SimpleNode();
node1.Latitude = -0.494497;
node1.Longitude = -24.119325;
node1.Tags = new Dictionary<string, string>();
node1.Tags.Add("type", "testnode1");
node1.Visible = true;
node1 = api_instance.NodeCreate(node1); // create
SimpleNode node2 = new SimpleNode();
node2.Latitude = -0.494497 + 0.0001f;
node2.Longitude = -24.119325 + 0.0001f;
node2.Tags = new Dictionary<string, string>();
node2.Tags.Add("type", "testnode2");
node2.Visible = true;
node2 = api_instance.NodeCreate(node2); // create
// initialize the way.
SimpleWay way = new SimpleWay();
way.Tags = new Dictionary<string, string>();
way.Tags.Add("type", "testway");
way.Nodes = new List<long>();
way.Visible = true;
way.Nodes.Add(node1.Id.Value);
way.Nodes.Add(node2.Id.Value);
way = api_instance.WayCreate(way); // create
// initialize the relation.
SimpleRelation relation = new SimpleRelation();
relation.Tags = new Dictionary<string, string>();
relation.Tags.Add("type", "testrelation");
relation.Members = new List<SimpleRelationMember>();
relation.Visible = true;
relation.Members.Add(new SimpleRelationMember()
{
MemberId = node1.Id.Value,
MemberRole = "some_nodes_role",
MemberType = SimpleRelationMemberType.Node
});
relation.Members.Add(new SimpleRelationMember()
{
MemberId = node2.Id.Value,
MemberRole = "some_nodes_role",
MemberType = SimpleRelationMemberType.Node
});
relation.Members.Add(new SimpleRelationMember()
{
MemberId = way.Id.Value,
MemberRole = "some_ways_role",
MemberType = SimpleRelationMemberType.Way
});
// save the relation.
relation = api_instance.RelationCreate(relation);
// close the changeset.
api_instance.ChangeSetClose();
}
/// <summary>
/// Adds a way.
/// </summary>
/// <param name="way"></param>
public override void AddWay(SimpleWay way)
{
}
internal static SimpleWay ConvertToSimple(Osm.Xml.v0_6.way wa)
{
SimpleWay way = new SimpleWay();
// set id
if (wa.idSpecified)
{
way.Id = wa.id;
}
// set changeset.
if (wa.changesetSpecified)
{
way.ChangeSetId = wa.changeset;
}
// set visible.
if (wa.visibleSpecified)
{
way.Visible = wa.visible;
}
else
{ // if visible is not specified it is default true.
way.Visible = true;
}
// set timestamp.
if (wa.timestampSpecified)
{
way.TimeStamp = wa.timestamp;
}
// set uid
if (wa.uidSpecified)
{
way.UserId = wa.uid;
}
// set version
if (wa.versionSpecified)
{
way.Version = wa.version;
}
// set user
way.UserName = wa.user;
// set tags.
way.Tags = XmlSimpleConverter.ConvertToTags(wa.tag);
// set nodes.
if (wa.nd != null && wa.nd.Length > 0)
{
way.Nodes = new List<long>();
for (int idx = 0; idx < wa.nd.Length; idx++)
{
way.Nodes.Add(wa.nd[idx].@ref);
}
}
return way;
}
public void APITestWayCreateGet()
{
// intialize the connection.
APIConnection api_instance = new APIConnection("http://api06.dev.openstreetmap.org/",
"osmsharp", "osmsharp");
// open a changeset.
long changeset_id = api_instance.ChangeSetOpen("Simple Way Creation Test");
// initialize the way.
SimpleWay way = new SimpleWay();
way.Tags = new Dictionary<string, string>();
way.Tags.Add("type", "testway");
way.Nodes = new List<long>();
way.Visible = true;
// initialize the nodes.
SimpleNode node = new SimpleNode();
node.Latitude = -0.494497;
node.Longitude = -24.119325;
node.Tags = new Dictionary<string, string>();
node.Tags.Add("type", "testnode1");
node.Visible = true;
node = api_instance.NodeCreate(node);
way.Nodes.Add(node.Id.Value);
node = new SimpleNode();
node.Latitude = -0.494497 + 0.0001f;
node.Longitude = -24.119325 + 0.0001f;
node.Tags = new Dictionary<string, string>();
node.Tags.Add("type", "testnode2");
node.Visible = true;
node = api_instance.NodeCreate(node);
way.Nodes.Add(node.Id.Value);
// save the way.
way = api_instance.WayCreate(way);
// close the changeset.
api_instance.ChangeSetClose();
// check if the id now has a value.
Assert.IsTrue(way.Id.HasValue);
// get the new way id.
long way_id = way.Id.Value;
// get the way from the api.
SimpleWay way_api = api_instance.WayGet(way.Id.Value);
Assert.AreEqual(way_id, way_api.Id.Value);
Assert.AreEqual(way.Tags.Count, way_api.Tags.Count);
Assert.AreEqual(way.Visible, way_api.Visible);
Assert.IsTrue(way_api.ChangeSetId.HasValue);
Assert.AreEqual(changeset_id, way_api.ChangeSetId.Value);
Assert.AreEqual(way.Nodes[0], way_api.Nodes[0]);
Assert.AreEqual(way.Nodes[1], way_api.Nodes[1]);
}
/// <summary>
/// Converts this relation into it's simple counterpart.
/// </summary>
/// <returns></returns>
public override SimpleOsmGeo ToSimple()
{
SimpleWay way = new SimpleWay();
way.Id = this.Id;
way.ChangeSetId = this.ChangeSetId;
way.Tags = this.Tags;
way.TimeStamp = this.TimeStamp;
way.UserId = this.UserId;
way.UserName = this.User;
way.Version = (ulong?)this.Version;
way.Visible = this.Visible;
way.Nodes = new List<long>();
foreach (Node node in this.Nodes)
{
way.Nodes.Add(node.Id);
}
return way;
}
/// <summary>
/// Converts an API v6 xml node to a SimpleWay object.
/// </summary>
/// <param name="xml_way"></param>
/// <returns></returns>
private SimpleWay Convertv6XmlWay(way xml_way)
{
SimpleWay way = new SimpleWay();
way.Id = xml_way.id;
if (xml_way.tag != null)
{
way.Tags = new Dictionary<string, string>();
foreach (Osm.Xml.v0_6.tag xml_tag in xml_way.tag)
{
way.Tags.Add(xml_tag.k, xml_tag.v);
}
}
if (xml_way.nd != null)
{
way.Nodes = new List<long>();
foreach (Osm.Xml.v0_6.nd xml_nd in xml_way.nd)
{
way.Nodes.Add(xml_nd.@ref);
}
}
way.ChangeSetId = xml_way.changeset;
way.TimeStamp = xml_way.timestamp;
way.UserName = xml_way.user;
way.UserId = xml_way.uid;
way.Version = xml_way.version;
way.Visible = xml_way.visible;
return way;
}
/// <summary>
/// Updates the given way by adding it's changes to the current changeset.
/// </summary>
/// <param name="way"></param>
public void WayUpdate(SimpleWay way)
{
if (_current_changeset == null)
{
throw new InvalidOperationException("No open changeset found!");
}
if (!way.Id.HasValue)
{
throw new ArgumentOutOfRangeException("Cannot update an object without an id!");
}
// build a new node.
way xml_way = way.ConvertTo();
xml_way.changeset = _current_changeset.id;
xml_way.changesetSpecified = true;
// encapsulate into an osm object.
OsmSharp.Osm.Xml.v0_6.osm osm = new Osm.Xml.v0_6.osm();
osm.way = new Osm.Xml.v0_6.way[1];
osm.way[0] = xml_way;
// serialize the changeset.
XmlSerializer serializer = new XmlSerializer(typeof(OsmSharp.Osm.Xml.v0_6.osm));
MemoryStream mem_stream = new MemoryStream();
Stream stream = mem_stream;
serializer.Serialize(stream, osm);
stream.Flush();
mem_stream.Flush();
byte[] put_data = mem_stream.ToArray();
// do the api call.
string response_string = this.DoApiCall(true, string.Format("api/0.6/way/{0}", way.Id.Value),
Method.PUT, put_data);
}
/// <summary>
/// Creates a new way by adding it to the current changeset.
/// </summary>
/// <param name="way"></param>
public SimpleWay WayCreate(SimpleWay way)
{
if (_current_changeset == null)
{
throw new InvalidOperationException("No open changeset found!");
}
// build a new node.
way xml_way = way.ConvertTo();
xml_way.changeset = _current_changeset.id;
xml_way.changesetSpecified = true;
// encapsulate into an osm object.
OsmSharp.Osm.Xml.v0_6.osm osm = new Osm.Xml.v0_6.osm();
osm.way = new Osm.Xml.v0_6.way[1];
osm.way[0] = xml_way;
// serialize the changeset.
XmlSerializer serializer = new XmlSerializer(typeof(OsmSharp.Osm.Xml.v0_6.osm));
MemoryStream mem_stream = new MemoryStream();
Stream stream = mem_stream;
serializer.Serialize(stream, osm);
stream.Flush();
mem_stream.Flush();
byte[] put_data = mem_stream.ToArray();
// do the api call.
string response_string = this.DoApiCall(true, "api/0.6/way/create",
Method.PUT, put_data);
// get the id-response.
long id;
if (!long.TryParse(response_string, out id))
{ // invalid response!
throw new APIException(string.Format("Invalid response when creating a new way: {0}", response_string));
}
way.Id = id;
return way;
}
private bool MoveNextWay()
{
if (_wayReader == null)
{
SQLiteCommand way_command = new SQLiteCommand("select * from way where id > 26478817 order by id");
way_command.Connection = _connection;
_wayReader = way_command.ExecuteReader();
if (!_wayReader.Read())
{
_wayReader.Close();
}
SQLiteCommand way_tag_command = new SQLiteCommand("select * from way_tags where way_id > 26478817 order by way_id");
way_tag_command.Connection = _connection;
_wayTagReader = way_tag_command.ExecuteReader();
if (!_wayTagReader.IsClosed && !_wayTagReader.Read())
{
_wayTagReader.Close();
}
SQLiteCommand way_node_command = new SQLiteCommand("select * from way_nodes where way_id > 26478817 order by way_id,sequence_id");
way_node_command.Connection = _connection;
_wayNodeReader = way_node_command.ExecuteReader();
if (!_wayNodeReader.IsClosed && !_wayNodeReader.Read())
{
_wayNodeReader.Close();
}
}
// read next way.
if (!_wayReader.IsClosed)
{
SimpleWay way = new SimpleWay();
way.Id = _wayReader.GetInt64(0);
way.ChangeSetId = _wayReader.GetInt64(1);
way.TimeStamp = _wayReader.IsDBNull(3) ? DateTime.MinValue : _wayReader.GetDateTime(3);
//way.UserId = _way_reader.GetInt64(6);
//way.UserName = _way_reader.GetString(5);
way.Version = (ulong)_wayReader.GetInt64(4);
way.Visible = _wayReader.GetInt64(2) == 1;
if (!_wayTagReader.IsClosed)
{
long returned_id = _wayTagReader.GetInt64(_wayTagReader.GetOrdinal("way_id"));
while (returned_id == way.Id.Value)
{
if (way.Tags == null)
{
way.Tags = new Dictionary<string, string>();
}
string key = _wayTagReader.GetString(1);
string value = _wayTagReader.GetString(2);
way.Tags.Add(key, value);
if (!_wayTagReader.Read())
{
_wayTagReader.Close();
returned_id = -1;
}
else
{
returned_id = _wayTagReader.GetInt64(0);
}
}
}
if (!_wayNodeReader.IsClosed)
{
long returned_id = _wayNodeReader.GetInt64(_wayNodeReader.GetOrdinal("way_id"));
while (returned_id == way.Id.Value)
{
if (way.Nodes == null)
{
way.Nodes = new List<long>();
}
long node_id = _wayNodeReader.GetInt64(1);
way.Nodes.Add(node_id);
if (!_wayNodeReader.Read())
{
_wayNodeReader.Close();
returned_id = -1;
}
else
{
returned_id = _wayNodeReader.GetInt64(0);
}
}
}
// set the current variable!
_current = way;
// advance the reader(s).
if (!_wayReader.Read())
{
_wayReader.Close();
}
if (!_wayTagReader.IsClosed && !_wayTagReader.Read())
{
_wayTagReader.Close();
}
if (!_wayNodeReader.IsClosed && !_wayNodeReader.Read())
{
_wayNodeReader.Close();
}
return true;
}
else
{
_wayReader.Close();
_wayReader.Dispose();
_wayReader = null;
_wayTagReader.Close();
_wayTagReader.Dispose();
_wayTagReader = null;
_currentType = SimpleOsmGeoType.Relation;
return false;
}
}
/// <summary>
/// Adds a given way.
/// </summary>
/// <param name="simple_way"></param>
public override void AddWay(SimpleWay simple_way)
{
Way way = OsmBaseFactory.CreateWayFrom(_string_table, simple_way, _nodes);
if (way != null)
{
_ways[way.Id] = way;
_source.AddWay(way);
}
}
/// <summary>
/// Adds a way.
/// </summary>
/// <param name="way"></param>
public void AddWay(SimpleWay way)
{
_ways[way.Id.Value] = way;
}
public void APITestWayCreateGetDelete()
{
// intialize the connection.
APIConnection api_instance = new APIConnection("http://api06.dev.openstreetmap.org/",
"osmsharp", "osmsharp");
// open a changeset.
long changeset_id = api_instance.ChangeSetOpen("Simple Way Creation Test");
// initialize the way.
SimpleWay way = new SimpleWay();
way.Tags = new Dictionary<string, string>();
way.Tags.Add("type", "testway");
way.Nodes = new List<long>();
way.Visible = true;
// initialize the nodes.
SimpleNode node = new SimpleNode();
node.Latitude = -0.494497;
node.Longitude = -24.119325;
node.Tags = new Dictionary<string, string>();
node.Tags.Add("type", "testnode1");
node.Visible = true;
node = api_instance.NodeCreate(node);
way.Nodes.Add(node.Id.Value);
node = new SimpleNode();
node.Latitude = -0.494497 + 0.0001f;
node.Longitude = -24.119325 + 0.0001f;
node.Tags = new Dictionary<string, string>();
node.Tags.Add("type", "testnode2");
node.Visible = true;
node = api_instance.NodeCreate(node);
way.Nodes.Add(node.Id.Value);
// save the way.
way = api_instance.WayCreate(way);
// close the changeset.
api_instance.ChangeSetClose();
// check if the id now has a value.
Assert.IsTrue(way.Id.HasValue);
// get the new way id.
long way_id = way.Id.Value;
// get the way again: a way can only be deleted using the correct changesetid and version.
way = api_instance.WayGet(way.Id.Value);
// open new changeset.
changeset_id = api_instance.ChangeSetOpen("Simple Way Delete Test");
// get the way.
api_instance.WayDelete(way);
// close the current changeset.
api_instance.ChangeSetClose();
// get the way.
SimpleWay api_way = api_instance.WayGet(way.Id.Value);
Assert.IsNull(api_way);
}
public void APITestWayCreateGetUpdate()
{
// intialize the connection.
APIConnection api_instance = new APIConnection("http://api06.dev.openstreetmap.org/",
"osmsharp", "osmsharp");
// open a changeset.
long changeset_id = api_instance.ChangeSetOpen("Simple Way Creation Test");
// initialize the way.
SimpleWay way = new SimpleWay();
way.Tags = new Dictionary<string, string>();
way.Tags.Add("type", "testway");
way.Nodes = new List<long>();
way.Visible = true;
// initialize the nodes.
SimpleNode node = new SimpleNode();
node.Latitude = -0.494497;
node.Longitude = -24.119325;
node.Tags = new Dictionary<string, string>();
node.Tags.Add("type", "testnode1");
node.Visible = true;
node = api_instance.NodeCreate(node);
way.Nodes.Add(node.Id.Value);
node = new SimpleNode();
node.Latitude = -0.494497 + 0.0001f;
node.Longitude = -24.119325 + 0.0001f;
node.Tags = new Dictionary<string, string>();
node.Tags.Add("type", "testnode2");
node.Visible = true;
node = api_instance.NodeCreate(node);
way.Nodes.Add(node.Id.Value);
// save the way.
way = api_instance.WayCreate(way);
// close the changeset.
api_instance.ChangeSetClose();
// check if the id now has a value.
Assert.IsTrue(way.Id.HasValue);
// get the new way id.
long way_id = way.Id.Value;
// open new changeset.
changeset_id = api_instance.ChangeSetOpen("Simple Way Update Test");
// get the way.
SimpleWay api_way = api_instance.WayGet(way.Id.Value);
api_way.Tags.Add("another_tag", "test adding a tag!");
api_instance.WayUpdate(api_way);
// close the current changeset.
api_instance.ChangeSetClose();
// get the api way.
api_way = api_instance.WayGet(way.Id.Value);
Assert.AreEqual(2, api_way.Tags.Count);
Assert.IsTrue(api_way.Tags.ContainsKey("another_tag"));
Assert.AreEqual("test adding a tag!", api_way.Tags["another_tag"]);
}
private bool MoveNextWay()
{
if (_way_reader == null)
{
OracleCommand way_command = new OracleCommand("select * from way order by id");
way_command.Connection = _connection;
_way_reader = way_command.ExecuteReader();
if (!_way_reader.Read())
{
_way_reader.Close();
}
OracleCommand way_tag_command = new OracleCommand("select * from way_tags order by way_id");
way_tag_command.Connection = _connection;
_way_tag_reader = way_tag_command.ExecuteReader();
if (!_way_tag_reader.IsClosed && !_way_tag_reader.Read())
{
_way_tag_reader.Close();
}
OracleCommand way_node_command = new OracleCommand("select * from way_nodes order by way_id,sequence_id");
way_node_command.Connection = _connection;
_way_node_reader = way_node_command.ExecuteReader();
if (!_way_node_reader.IsClosed && !_way_node_reader.Read())
{
_way_node_reader.Close();
}
}
// read next way.
if (!_way_reader.IsClosed)
{
// load/parse data.
long id = _way_reader.GetInt64(0);
long changeset_id = _way_reader.GetInt64(1);
DateTime timestamp = _way_reader.GetDateTime(2);
bool visible = _way_reader.GetInt64(3) == 1;
long version = _way_reader.GetInt64(4);
string user = _way_reader.GetString(5);
long uid = _way_reader.GetInt64(6);
SimpleWay way = new SimpleWay();
way.Id = id;
way.ChangeSetId = changeset_id;
way.TimeStamp = timestamp;
way.UserId = uid;
way.UserName = user;
way.Version = (ulong)version;
way.Visible = visible;
if (!_way_tag_reader.IsClosed)
{
long returned_id = _way_tag_reader.GetInt64(_way_tag_reader.GetOrdinal("way_id"));
while (returned_id == way.Id.Value)
{
if (way.Tags == null)
{
way.Tags = new Dictionary<string, string>();
}
string key = _way_tag_reader.GetString(1);
string value = _way_tag_reader.GetString(2);
way.Tags.Add(key, value);
if (!_way_tag_reader.Read())
{
_way_tag_reader.Close();
returned_id = -1;
}
else
{
returned_id = _way_tag_reader.GetInt64(0);
}
}
}
if (!_way_node_reader.IsClosed)
{
long returned_id = _way_node_reader.GetInt64(_way_node_reader.GetOrdinal("way_id"));
while (returned_id == way.Id.Value)
{
if (way.Nodes == null)
{
way.Nodes = new List<long>();
}
long node_id = _way_node_reader.GetInt64(1);
way.Nodes.Add(node_id);
if (!_way_node_reader.Read())
{
_way_node_reader.Close();
returned_id = -1;
}
else
{
returned_id = _way_node_reader.GetInt64(0);
}
}
}
// set the current variable!
_current = way;
// advance the reader(s).
if (!_way_reader.Read())
{
_way_reader.Close();
}
if (!_way_tag_reader.IsClosed && !_way_tag_reader.Read())
{
_way_tag_reader.Close();
}
if (!_way_node_reader.IsClosed && !_way_node_reader.Read())
{
_way_node_reader.Close();
}
return true;
}
else
{
_way_reader.Close();
_way_reader.Dispose();
_way_reader = null;
_way_tag_reader.Close();
_way_tag_reader.Dispose();
_way_tag_reader = null;
_current_type = SimpleOsmGeoType.Relation;
return false;
}
}
private void Create(SimpleWay way)
{
OracleCommand command;
DateTime? timestamp = way.TimeStamp;
string timestamp_str = timestamp.Value.ToString("HH:mm dd/MM/yyyy");
command = this.CreateCommand(string.Format(
"insert into way (id,changeset_id,timestamp,visible,version,usr,usr_id) values (:id,:changeset_id,to_date('{0}','HH24:MI DD/MM/YYYY'),:visible,:version,:usr,:usr_id)",
timestamp_str));
// format data and create parameters.
long? id = way.Id;
command.Parameters.Add(new OracleParameter("id", id.ConvertToDBValue<long>()));
long? changeset_id = way.ChangeSetId;
command.Parameters.Add(new OracleParameter("changeset_id", changeset_id.ConvertToDBValue<long>()));
bool? visible = way.Visible;
int visible_int = 1;
if (!visible.HasValue)
{
visible_int = 0;
}
command.Parameters.Add(new OracleParameter("visible", visible_int));
long? version = (long)way.Version;
command.Parameters.Add(new OracleParameter("version", version.ConvertToDBValue<long>()));
command.Parameters.Add("usr", way.UserName);
command.Parameters.Add("usr_id", way.UserId);
command.ExecuteNonQuery();
command.Dispose();
// insert tags.
this.CreateTags(way.Id.Value, way.Tags, "way_tags", "way_id");
// insert way_nodes.
this.CreateWayNodes(way.Id.Value, way.Nodes);
}
/// <summary>
/// Adds a way to the target.
/// </summary>
/// <param name="way"></param>
public override void AddWay(SimpleWay way)
{
if (_base_objects == null)
{ // the base object collection is null.
throw new InvalidOperationException("No target collection set!");
}
// add the way to the collection.
_base_objects.Add(way);
}
private void Delete(SimpleWay way)
{
OracleCommand command;
command = this.CreateCommand("delete from way_nodes where way_id = :way_id");
command.Parameters.Add(new OracleParameter("way_id", way.Id.Value));
command.ExecuteNonQuery();
command.Dispose();
command = this.CreateCommand("delete from way_tags where way_id = :way_id");
command.Parameters.Add(new OracleParameter("way_id", way.Id.Value));
command.ExecuteNonQuery();
command.Dispose();
command = this.CreateCommand("delete from way where id = :id");
command.Parameters.Add(new OracleParameter("id", way.Id.Value));
command.ExecuteNonQuery();
command.Dispose();
}
/// <summary> /// Adds a way to the target. /// </summary> /// <param name="way"></param> public abstract void AddWay(SimpleWay way);
/// <summary>
/// Adds a way to this database.
/// </summary>
/// <param name="way"></param>
public override void AddWay(SimpleWay way)
{
// converts the way.
OsmWay new_way = PrimitiveExtensions.ConvertTo(way, way.Nodes);
// only insert it if it is an highway.
if (new_way.IsHighway)
{
string way_key = new_way.GetRedisKey();
_way_type_client.SetEntry(way_key, new_way);
// add all the needed nodes.
foreach (long id in way.Nodes)
{
SimpleNode node = null;
OsmNode new_node = null;
if (_cached_nodes.TryGetValue(id, out node)
&& !_nodes_in_ways.TryGetValue(id, out new_node))
{
// convert to the new node.
new_node = PrimitiveExtensions.ConvertTo(node);
_nodes_in_ways.Add(id, new_node);
}
if (new_node != null)
{
new_node.Ways.Add(way.Id.Value);
}
}
}
}