/// <summary>
/// Retrieves and returns the collection of vocab matching the
/// given filters.
/// </summary>
/// <param name="kanji">Kanji filter. Only vocab containing this
/// kanji will be filtered in.</param>
/// <param name="readingFilter">Reading filter. Only vocab containing
/// this string in their kana or kanji reading will be filtered in.</param>
/// <param name="meaningFilter">Meaning filter. Only vocab containing
/// this string as part of at least one of their meaning entries will
/// be filtered in.</param>
/// <param name="categoryFilter">If not null, this category is used as the filter.</param>
/// <param name="jlptLevel">The JLPT level to filter
/// (1-5, where a lower value means it is not covered on the JLPT
/// and a higher value means that this filter will be ignored).</param>
/// <param name="wkLevel">The WaniKani level to filter
/// (1-60, where a higher value means it is not taught by WaniKani
/// and a lower value means that this filter will be ignored).</param>
/// <param name="isCommonFirst">Indicates if common vocab should be
/// presented first. If false, results are sorted only by the length
/// of their writing (asc or desc depending on the parameter)</param>
/// <param name="isShortWritingFirst">Indicates if results should
/// be sorted by ascending or descending writing length.
/// If True, short readings come first. If False, long readings
/// come first.</param>
/// <returns>Vocab entities matching the filters.</returns>
public IEnumerable <VocabEntity> GetFilteredVocab(KanjiEntity kanji,
string readingFilter, string meaningFilter, VocabCategory categoryFilter,
int jlptLevel, int wkLevel,
bool isCommonFirst, bool isShortWritingFirst)
{
List <DaoParameter> parameters = new List <DaoParameter>();
string sqlFilterClauses = BuildVocabFilterClauses(parameters, kanji,
readingFilter, meaningFilter, categoryFilter, jlptLevel, wkLevel);
string sortClause = "ORDER BY ";
if (isCommonFirst)
{
sortClause += string.Format("v.{0} DESC,", SqlHelper.Field_Vocab_IsCommon);
}
sortClause += string.Format("length(v.{0}) {1}",
SqlHelper.Field_Vocab_KanaWriting,
(isShortWritingFirst ? "ASC" : "DESC"));
DaoConnection connection = null;
DaoConnection srsConnection = null;
try
{
connection = DaoConnection.Open(DaoConnectionEnum.KanjiDatabase);
srsConnection = new DaoConnection(DaoConnectionEnum.SrsDatabase);
srsConnection.OpenAsync();
IEnumerable <NameValueCollection> vocabs = connection.Query(
string.Format("SELECT DISTINCT v.* FROM {0} v {1}{2}",
SqlHelper.Table_Vocab,
sqlFilterClauses,
sortClause),
parameters.ToArray());
VocabBuilder vocabBuilder = new VocabBuilder();
foreach (NameValueCollection nvcVocab in vocabs)
{
VocabEntity vocab = vocabBuilder.BuildEntity(nvcVocab, null);
IncludeCategories(connection, vocab);
IncludeMeanings(connection, vocab);
IncludeKanji(connection, srsConnection, vocab);
IncludeSrsEntries(srsConnection, vocab);
IncludeVariants(connection, vocab);
yield return(vocab);
}
}
finally
{
if (connection != null)
{
connection.Dispose();
}
}
}
/// <summary>
/// Gets a set of kanji matching the given filters.
/// </summary>
/// <param name="radicals">Filters out kanji which do not contain all
/// of the contained radicals.</param>
/// <param name="textFilter">If set, filters out all kanji that are not
/// contained in the string.</param>
/// <param name="meaningFilter">Filter for the meaning of the kanji.</param>
/// <param name="anyReadingFilter">Filter matching any reading of the kanji.
/// <remarks>If set, this parameter will override the three reading filters.
/// </remarks></param>
/// <param name="onYomiFilter">Filter for the on'yomi reading of the kanji.
/// <remarks>This parameter will be ignored if
/// <paramref name="anyReadingFilter"/> is set.</remarks></param>
/// <param name="kunYomiFilter">Filter for the kun'yomi reading of the kanji.
/// <remarks>This parameter will be ignored if
/// <paramref name="anyReadingFilter"/> is set.</remarks></param>
/// <param name="nanoriFilter">Filter for the nanori reading of the kanji.
/// <remarks>This parameter will be ignored if
/// <paramref name="anyReadingFilter"/> is set.</remarks></param>
/// <returns>Kanji matching the given filters.</returns>
public IEnumerable <KanjiEntity> GetFilteredKanji(RadicalGroup[] radicals, string textFilter,
string meaningFilter, string anyReadingFilter, string onYomiFilter, string kunYomiFilter,
string nanoriFilter, int jlptLevel, int wkLevel)
{
List <DaoParameter> parameters = new List <DaoParameter>();
string sqlFilter = BuildKanjiFilterClauses(parameters, radicals, textFilter,
meaningFilter, anyReadingFilter, onYomiFilter, kunYomiFilter, nanoriFilter,
jlptLevel, wkLevel);
DaoConnection connection = null;
DaoConnection srsConnection = null;
try
{
// Create and open synchronously the primary Kanji connection.
connection = DaoConnection.Open(DaoConnectionEnum.KanjiDatabase);
// Create the secondary Srs connection and open it asynchronously.
srsConnection = new DaoConnection(DaoConnectionEnum.SrsDatabase);
srsConnection.OpenAsync();
// FILTERS COMPUTED.
// Execute the final request.
IEnumerable <NameValueCollection> results = connection.Query(string.Format(
"SELECT * FROM {0} k {1}ORDER BY (k.{2} IS NULL),(k.{2});",
SqlHelper.Table_Kanji,
sqlFilter,
SqlHelper.Field_Kanji_MostUsedRank),
parameters.ToArray());
KanjiBuilder kanjiBuilder = new KanjiBuilder();
foreach (NameValueCollection nvcKanji in results)
{
KanjiEntity kanji = kanjiBuilder.BuildEntity(nvcKanji, null);
IncludeKanjiMeanings(connection, kanji);
IncludeRadicals(connection, kanji);
IncludeSrsEntries(srsConnection, kanji);
yield return(kanji);
}
}
finally
{
if (connection != null)
{
connection.Dispose();
}
if (srsConnection != null)
{
srsConnection.Dispose();
}
}
}
/// <summary>
/// Retrieves and returns the complete VocabEntity matching the given ID.
/// </summary>
/// <param name="id">Id to search.</param>
/// <returns>The VocabEntity that matches the given ID, or null if not found.</returns>
public VocabEntity GetVocabById(long id)
{
VocabEntity result = null;
DaoConnection connection = null;
DaoConnection srsConnection = null;
try
{
connection = DaoConnection.Open(DaoConnectionEnum.KanjiDatabase);
srsConnection = new DaoConnection(DaoConnectionEnum.SrsDatabase);
srsConnection.OpenAsync();
IEnumerable <NameValueCollection> vocabs = connection.Query(
string.Format("SELECT * FROM {0} WHERE {1}=@id",
SqlHelper.Table_Vocab,
SqlHelper.Field_Vocab_Id),
new DaoParameter("@id", id));
if (vocabs.Any())
{
VocabBuilder builder = new VocabBuilder();
VocabEntity vocab = builder.BuildEntity(vocabs.First(), null);
IncludeCategories(connection, vocab);
IncludeMeanings(connection, vocab);
IncludeKanji(connection, srsConnection, vocab);
IncludeSrsEntries(srsConnection, vocab);
IncludeVariants(connection, vocab);
result = vocab;
}
}
finally
{
if (connection != null)
{
connection.Dispose();
}
}
return(result);
}
/// <summary>
/// Retrieves and returns the collection of vocab matching the
/// given filters.
/// </summary>
/// <param name="kanji">Kanji filter. Only vocab containing this
/// kanji will be filtered in.</param>
/// <param name="readingFilter">Reading filter. Only vocab containing
/// this string in their kana or kanji reading will be filtered in.</param>
/// <param name="meaningFilter">Meaning filter. Only vocab containing
/// this string as part of at least one of their meaning entries will
/// be filtered in.</param>
/// <param name="isCommonFirst">Indicates if common vocab should be
/// presented first. If false, results are sorted only by the length
/// of their writing (asc or desc depending on the parameter)</param>
/// <param name="isShortWritingFirst">Indicates if results should
/// be sorted by ascending or descending writing length.
/// If True, short readings come first. If False, long readings
/// come first.</param>
/// <returns>Vocab entities matching the filters.</returns>
public IEnumerable<VocabEntity> GetFilteredVocab(KanjiEntity kanji,
string readingFilter, string meaningFilter, bool isCommonFirst,
bool isShortWritingFirst)
{
List<DaoParameter> parameters = new List<DaoParameter>();
string sqlFilterClauses = BuildVocabFilterClauses(parameters, kanji,
readingFilter, meaningFilter);
string sortClause = "ORDER BY ";
if (isCommonFirst)
{
sortClause += "v." + SqlHelper.Field_Vocab_IsCommon + " DESC,";
}
sortClause += "length(v." + SqlHelper.Field_Vocab_KanaWriting + ") "
+ (isShortWritingFirst ? "ASC" : "DESC");
DaoConnection connection = null;
DaoConnection srsConnection = null;
try
{
connection = DaoConnection.Open(DaoConnectionEnum.KanjiDatabase);
srsConnection = new DaoConnection(DaoConnectionEnum.SrsDatabase);
srsConnection.OpenAsync();
IEnumerable<NameValueCollection> vocabs = connection.Query(
"SELECT DISTINCT v.* FROM " + SqlHelper.Table_Vocab + " v "
+ sqlFilterClauses
+ sortClause,
parameters.ToArray());
VocabBuilder vocabBuilder = new VocabBuilder();
foreach (NameValueCollection nvcVocab in vocabs)
{
VocabEntity vocab = vocabBuilder.BuildEntity(nvcVocab, null);
IncludeCategories(connection, vocab);
IncludeMeanings(connection, vocab);
IncludeKanji(connection, srsConnection, vocab);
IncludeSrsEntries(srsConnection, vocab);
IncludeVariants(connection, vocab);
yield return vocab;
}
}
finally
{
if (connection != null)
{
connection.Dispose();
}
}
}
/// <summary>
/// Retrieves and returns the complete VocabEntity matching the given ID.
/// </summary>
/// <param name="id">Id to search.</param>
/// <returns>The VocabEntity that matches the given ID, or null if not found.</returns>
public VocabEntity GetVocabById(long id)
{
VocabEntity result = null;
DaoConnection connection = null;
DaoConnection srsConnection = null;
try
{
connection = DaoConnection.Open(DaoConnectionEnum.KanjiDatabase);
srsConnection = new DaoConnection(DaoConnectionEnum.SrsDatabase);
srsConnection.OpenAsync();
IEnumerable<NameValueCollection> vocabs = connection.Query(
"SELECT * FROM " + SqlHelper.Table_Vocab + " WHERE "
+ SqlHelper.Field_Vocab_Id + "=@id",
new DaoParameter("@id", id));
if (vocabs.Any())
{
VocabBuilder builder = new VocabBuilder();
VocabEntity vocab = builder.BuildEntity(vocabs.First(), null);
IncludeCategories(connection, vocab);
IncludeMeanings(connection, vocab);
IncludeKanji(connection, srsConnection, vocab);
IncludeSrsEntries(srsConnection, vocab);
IncludeVariants(connection, vocab);
result = vocab;
}
}
finally
{
if (connection != null)
{
connection.Dispose();
}
}
return result;
}
/// <summary>
/// Gets a set of kanji matching the given filters.
/// </summary>
/// <param name="radicals">Filters out kanji which do not contain all
/// of the contained radicals.</param>
/// <param name="textFilter">If set, filters out all kanji that are not
/// contained in the string.</param>
/// <param name="meaningFilter">Filter for the meaning of the kanji.</param>
/// <param name="anyReadingFilter">Filter matching any reading of the kanji.
/// <remarks>If set, this parameter will override the three reading filters.
/// </remarks></param>
/// <param name="onYomiFilter">Filter for the on'yomi reading of the kanji.
/// <remarks>This parameter will be ignored if
/// <paramref name="anyReadingFilter"/> is set.</remarks></param>
/// <param name="kunYomiFilter">Filter for the kun'yomi reading of the kanji.
/// <remarks>This parameter will be ignored if
/// <paramref name="anyReadingFilter"/> is set.</remarks></param>
/// <param name="nanoriFilter">Filter for the nanori reading of the kanji.
/// <remarks>This parameter will be ignored if
/// <paramref name="anyReadingFilter"/> is set.</remarks></param>
/// <returns>Kanji matching the given filters.</returns>
public IEnumerable<KanjiEntity> GetFilteredKanji(RadicalGroup[] radicals, string textFilter,
string meaningFilter, string anyReadingFilter, string onYomiFilter, string kunYomiFilter,
string nanoriFilter)
{
List<DaoParameter> parameters = new List<DaoParameter>();
string sqlFilter = BuildKanjiFilterClauses(parameters, radicals, textFilter,
meaningFilter, anyReadingFilter, onYomiFilter, kunYomiFilter, nanoriFilter);
DaoConnection connection = null;
DaoConnection srsConnection = null;
try
{
// Create and open synchronously the primary Kanji connection.
connection = DaoConnection.Open(DaoConnectionEnum.KanjiDatabase);
// Create the secondary Srs connection and open it asynchronously.
srsConnection = new DaoConnection(DaoConnectionEnum.SrsDatabase);
srsConnection.OpenAsync();
// FILTERS COMPUTED.
// Execute the final request.
IEnumerable<NameValueCollection> results = connection.Query(
"SELECT * "
+ "FROM " + SqlHelper.Table_Kanji + " k "
+ sqlFilter
+ "ORDER BY (k." + SqlHelper.Field_Kanji_MostUsedRank + " IS NULL),"
+ "(k." + SqlHelper.Field_Kanji_MostUsedRank + ");",
parameters.ToArray());
KanjiBuilder kanjiBuilder = new KanjiBuilder();
foreach (NameValueCollection nvcKanji in results)
{
KanjiEntity kanji = kanjiBuilder.BuildEntity(nvcKanji, null);
IncludeKanjiMeanings(connection, kanji);
IncludeRadicals(connection, kanji);
IncludeSrsEntries(srsConnection, kanji);
yield return kanji;
}
}
finally
{
if (connection != null)
{
connection.Dispose();
}
if (srsConnection != null)
{
srsConnection.Dispose();
}
}
}
