Hi! I'm trying to port my wear os app to tizen (due to switching from ticwatch pro to galaxy watch), but i have some problems. I have a db in my shared/res directory in visual studio project, and i'm trying to open it with sqlite (throught methods of System.Data.SQLite), without success, because i obtain a segmentation error when i create sqlite connection to db...is shared/res maybe read only directory, as in android? If yes, how can i solve the problem?
Here is the code:.
MainApps:
protected override void OnStart()
{
// Handle when your app starts
String db_path = "/opt/usr/apps/com.feduss.example.BusFinder.Tizen.Wearable/shared/res/CTM_BUS.sqlite";
SQLiteDatabase db = new SQLiteDatabase(db_path);
if (File.Exists(db_path))
{
Console.WriteLine("File exists...");
SQLiteCommand selectBusLines = new SQLiteCommand
("SELECT * from Routes");
DataTable res = db.GetDataTable(selectBusLines);
}
else
{
Console.WriteLine("File does not exist!");
}
}
SQLiteDatabase.cs:
public class SQLiteDatabase
{
private readonly string _dbConnection;
public SQLiteDatabase(string dataSource)
{
_dbConnection = string.Format("Data Source={0}", dataSource);
}
public DataTable GetDataTable(SQLiteCommand command)
{
if (command == null) throw new ArgumentNullException("command");
using (SQLiteConnection connection = new SQLiteConnection(_dbConnection))
{
connection.Open();
command.Connection = connection;
using (SQLiteDataReader reader = command.ExecuteReader())
{
DataTable result = new DataTable();
result.Load(reader);
return result;
}
}
}
public SQLiteCommand GetCommand(string sql)
{
if (string.IsNullOrEmpty(sql))
throw new ArgumentNullException("sql");
return new SQLiteCommand
{
CommandText = sql,
CommandType = CommandType.Text
};
}
public int ExecuteNonQuery(SQLiteCommand command)
{
if (command == null) throw new ArgumentNullException("command");
using (SQLiteConnection connection = new SQLiteConnection(_dbConnection))
{
connection.Open();
command.Connection = connection;
return command.ExecuteNonQuery();
}
}
}