public static async Task InitializeDatabaseAsync()
{
var db = CreateConnection();
CreateTablesResult result = await db.CreateTableAsync <DbRisQueryParameter>();
result = await db.CreateTableAsync <DbDownloadedDocument>();
}
public LockDatabase(ILocalFilePathProvider filePathProvider)
{
_filePathProvider = filePathProvider;
var pathToDb = _filePathProvider.GetPathForFile(DefaultDbName);
_sqLiteConnection = new SQLiteAsyncConnection(pathToDb);
_createTablesResult = _sqLiteConnection.CreateTableAsync <Models.LockEntity>().Result;
}
private async void Init()
{
db = DependencyService.Get <ISqliteConnection>().GetConnection();
CreateTablesResult created = await db.CreateTableAsync <CategoryDataModels>();
created = await db.CreateTableAsync <ProductDataModels>();
created = await db.CreateTableAsync <ReviewDetailsDataModel>();
}
private async Task <bool> CreateTable()
{
var conn = new SQLiteAsyncConnection(_dbPath);
try
{
CreateTablesResult rs = await conn.CreateTableAsync <Movie>();
Log.Debug("CreateTable", "returned " + (rs.Results.ToString()));
return(true);
}
catch (SQLiteException ex)
{
Log.Debug("CreateTable", "Exception " + ex.Message);
return(false);
}
}
public Task <CreateTablesResult> CreateTablesAsync(params Type[] types)
{
if (types == null)
{
throw new ArgumentNullException("types");
}
return(Task.Factory.StartNew(() =>
{
var result = new CreateTablesResult();
SQLiteConnectionWithLock conn = GetConnection();
using (conn.Lock())
{
foreach (Type type in types)
{
int aResult = conn.CreateTable(type);
result.Results[type] = aResult;
}
}
return result;
}, CancellationToken.None, _taskCreationOptions, _taskScheduler ?? TaskScheduler.Default));
}
public Task <CreateTablesResult> CreateTablesAsync(CancellationToken cancellationToken = default(CancellationToken), [NotNull] params Type[] types)
{
if (types == null)
{
throw new ArgumentNullException("types");
}
return(Task.Factory.StartNew(() =>
{
var result = new CreateTablesResult();
var conn = GetConnection();
using (conn.Lock())
{
foreach (var type in types)
{
var aResult = conn.CreateTable(type);
result.Results[type] = aResult;
}
}
return result;
}, cancellationToken, _taskCreationOptions, _taskScheduler ?? TaskScheduler.Default));
}
public Task <CreateTablesResult> CreateTablesAsync(params Type[] types)
{
if (types == null)
{
throw new ArgumentNullException("types");
}
return(_taskFactory.StartNew(() =>
{
var result = new CreateTablesResult();
SQLiteConnectionWithLock conn = GetConnection();
using (conn.Lock())
{
foreach (Type type in types)
{
int aResult = conn.CreateTable(type);
result.Results[type] = aResult;
}
}
return result;
}));
}
private async void CreateTableAsync()
{
CreateTablesResult SettingTable = await Connection.CreateTableAsync <Setting>();
}
