public void Save(string path)
{
SqliteCore db = new SqliteCore("data source=" + path);
db.ExecuteQuery("DELETE FROM LINK_INFO");
foreach (LinkInfoRecord record in linkInfoRecords)
{
db.ExecuteQuery(string.Format("INSERT INTO LINK_INFO VALUES ({0},{1},{2})",
record.fromId, record.toId, record.distance));
}
db.CloseSqlConnection();
}
public void Save(string path)
{
SqliteCore db = new SqliteCore("data source=" + path);
db.ExecuteQuery("DELETE FROM BUILDER_NODE");
foreach (BuilderNodeRecord record in builderNodeRecords)
{
db.ExecuteQuery(string.Format("INSERT INTO BUILDER_NODE VALUES ({0},{1},{2},{3})",
record.id, "'" + record.position + "'", "'" + record.rotation + "'", record.type));
Debug.Log(record.id + record.position + record.rotation);
}
db.CloseSqlConnection();
}
public void Load(string path)
{
SqliteCore db = new SqliteCore("data source=" + path);
linkInfoRecords.Clear();
SqliteDataReader sqReader = db.ExecuteQuery("SELECT * FROM LINK_INFO");
while (sqReader.Read())
{
int _from = sqReader.GetInt32(sqReader.GetOrdinal("from_id"));
int _to = sqReader.GetInt32(sqReader.GetOrdinal("to_id"));
int _distance = sqReader.GetInt32(sqReader.GetOrdinal("distance"));
LinkInfoRecord newRecord = new LinkInfoRecord(_from, _to, _distance);
linkInfoRecords.Add(newRecord);
}
db.CloseSqlConnection();
}
public void Load(string path)
{
SqliteCore db = new SqliteCore("data source=" + path);
builderNodeRecords.Clear();
SqliteDataReader sqReader = db.ExecuteQuery("SELECT * FROM BUILDER_NODE");
while (sqReader.Read())
{
int _id = sqReader.GetInt32(sqReader.GetOrdinal("id"));
string _position = sqReader.GetString(sqReader.GetOrdinal("position"));
string _rotation = sqReader.GetString(sqReader.GetOrdinal("rotation"));
int _type = sqReader.GetInt32(sqReader.GetOrdinal("type"));
BuilderNodeRecord newRecord = new BuilderNodeRecord(_id, _position, _rotation, _type);
builderNodeRecords.Add(newRecord);
}
db.CloseSqlConnection();
}
