public int Count <T>(Expression <Func <T, bool> > expression = null)
where T : class
{
using (Connection.Lock())
{
return(expression != null?Connection.Table <T>().Where(expression).Count()
: Connection.Table <T>().Count());
}
}
/// <summary>
/// 导出所有时间标签
/// </summary>
public JObject DumpTimeMarks()
{
var data = new JObject();
var result = _db.Table <TimeMark>().ToList();
foreach (var timeMark in result)
{
data[timeMark.ID] = JsonConvert.SerializeObject(timeMark);
}
return(data);
}
public VideoItem GetFromPath(String path)
{
using (connection.Lock())
{
return(connection.Table <VideoItem>().Where(x => x.Path == path).FirstOrDefault());
}
}
internal List <Wyniki> getWyniki()
{
using (var connection = new SQLiteConnectionWithLock(new SQLitePlatformWinRT(), new SQLiteConnectionString(path2, false)))
{
return(connection.Table <Wyniki>().ToList());
}
}
public List <BackgroundTrackItem> LoadPlaylist()
{
using (connection.Lock())
{
return(connection.Table <BackgroundTrackItem>().ToList());
}
}
private int GetCurrentVersion()
{
_connection.CreateTable <VersionRow>();
var version = _connection.Table <VersionRow>()
.OrderByDescending(x => x.Version)
.FirstOrDefault();
return(version?.Version ?? 0);
}
public AsyncTableQuery <T> Table <T>()
where T : new()
{
//
// This isn't async as the underlying connection doesn't go out to the database
// until the query is performed. The Async methods are on the query iteself.
//
SQLiteConnectionWithLock conn = GetConnection();
return(new AsyncTableQuery <T>(conn.Table <T>(), _taskScheduler, _taskCreationOptions));
}
public List <string> SearchIngredients(string query)
{
if (_isDisposed)
{
throw new ObjectDisposedException(nameof(SearchService));
}
var q = _parser.Parse(query);
if (q == null)
{
return(new List <string>());
}
List <RecipeTextFieldRow> list;
using (_connection.Lock())
{
list = _connection.Table <RecipeTextFieldRow>()
.Where(x => x.Type == RecipeTextType.Ingredient && x.Value.Contains(q))
.ToList();
}
return(list.Select(x => x.Value).ToList());
}
public List <Example> GetAllExamples()
{
var list = _connection.Table <Example>().ToList();
return(list);
}
public AlbumItem LoadAlbumFromId(int albumId)
{
using (connection.Lock())
{
return(connection.Table <AlbumItem>().Where(x => x.Id.Equals(albumId)).FirstOrDefault());
}
}
public List <QrCodeResult> GetAllQrCodeResults()
{
var list = _connection.Table <QrCodeResult>().ToList();
return(list);
}
