public void TestBoolean()
{
var sqlite3Platform = new SQLitePlatformWin32();
string tmpFile = TestPath.GetTempFileName();
var db = new DbAcs(sqlite3Platform, tmpFile);
db.buildTable();
for (int i = 0; i < 10; i++)
{
db.Insert(new VO
{
Flag = (i%3 == 0),
Text = String.Format("VO{0}", i)
});
}
// count vo which flag is true
Assert.AreEqual(4, db.CountWithFlag(true));
Assert.AreEqual(6, db.CountWithFlag(false));
Debug.WriteLine("VO with true flag:");
foreach (VO vo in db.Query<VO>("SELECT * FROM VO Where Flag = ?", true))
{
Debug.WriteLine(vo.ToString());
}
Debug.WriteLine("VO with false flag:");
foreach (VO vo in db.Query<VO>("SELECT * FROM VO Where Flag = ?", false))
{
Debug.WriteLine(vo.ToString());
}
}
private void SetUpConnection()
{
var plat = new SQLitePlatformWin32();
var connectionFactory =
new Func<SQLiteConnectionWithLock>(
() => new SQLiteConnectionWithLock(plat, new SQLiteConnectionString(PATH, false)));
_asyncConnection = new SQLiteAsyncConnection(connectionFactory);
}
public override SQLiteConnection GetDatabase(string name)
{
ISQLitePlatform platform;
if (RuntimeInfo.IsWindows)
platform = new SQLitePlatformWin32();
else
platform = new SQLitePlatformGeneric();
return new SQLiteConnection(platform, $@":memory:");
}
public void Cleanup()
{
ISQLitePlatform Platform = new SQLite.Net.Platform.Win32.SQLitePlatformWin32();
using (var connection = new SQLiteConnection(Platform, Constants.ActiveStoreageDBConnection))
{
// clean up the DB
connection.DeleteAll <Party>();
}
}
public void SetUp()
{
_sqlite3Platform = new SQLitePlatformWin32();
}
EFDbConnect CreateDemoBase(string db_name)
{
string path = PathToDb(db_name);
if (File.Exists(path))
{
File.Delete(path);
}
ILogger ILoggerMock = Mock.Of<ILogger>();
ISQLitePlatform platf = new SQLitePlatformWin32();
EFDbConnect EFDbConnect = new EFDbConnect(platf, path);
EFDbContext ctx = new EFDbContext(EFDbConnect);
LearningItem li1 = new LearningItem();
li1.Name = "First";
ctx.AddNewItemToDBContext(li1);
LearningItem li2 = new LearningItem();
li2.Name = "Second";
ctx.AddNewItemToDBContext(li2);
// Audio tracks
AudioTrack at1 = new AudioTrack();
li1.AudioTracks.Add(at1);
AudioTrack at2 = new AudioTrack();
li1.AudioTracks.Add(at2);
AudioTrack at3 = new AudioTrack();
li2.AudioTracks.Add(at3);
// Frequency dictionary
FrequencyDictionary fd1 = new FrequencyDictionary();
FrequencyDictionary fd2 = new FrequencyDictionary();
FrequencyDictionary.Item fdi1 = new FrequencyDictionary.Item();
fd1.Items.Add(fdi1);
FrequencyDictionary.Item fdi2 = new FrequencyDictionary.Item();
fd1.Items.Add(fdi2);
FrequencyDictionary.Item fdi3 = new FrequencyDictionary.Item();
fd2.Items.Add(fdi3);
FrequencyDictionary.Item fdi4 = new FrequencyDictionary.Item();
fd2.Items.Add(fdi4);
// Languages
Language lang1 = new Language();
lang1.FrequencyDictionary = fd1;
Language lang2 = new Language();
lang2.FrequencyDictionary = fd2;
Subtitles sub1 = new Subtitles();
li1.SubtitleCollection.Add(sub1);
sub1.SecondaryLanguage = lang1;
Subtitles sub2 = new Subtitles();
li1.SubtitleCollection.Add(sub2);
SubtitleItem si1 = new SubtitleItem();
sub1.Items.Add(si1);
SubtitleItem si2 = new SubtitleItem();
sub1.Items.Add(si2);
SubtitleItem si3 = new SubtitleItem();
sub2.Items.Add(si3);
SubtitleItem si4 = new SubtitleItem();
sub2.Items.Add(si4);
Subtitles sub3 = new Subtitles();
li2.SubtitleCollection.Add(sub3);
sub3.SecondaryLanguage = lang2;
SubtitleItem si5 = new SubtitleItem();
sub3.Items.Add(si5);
WordOfSubtitleItem sw1 = new WordOfSubtitleItem();
si1.WordsCollection.Add(sw1);
WordOfSubtitleItem sw2 = new WordOfSubtitleItem();
si1.WordsCollection.Add(sw2);
WordOfSubtitleItem sw3 = new WordOfSubtitleItem();
si5.WordsCollection.Add(sw3);
// Dictionary
Dictionary dic1 = new Dictionary();
ctx.AddNewItemToDBContext(dic1);
WordOfDictionary wd1 = new WordOfDictionary();
dic1.Words.Add(wd1);
TranslationOfWord tw1 = new TranslationOfWord();
wd1.translations.Add(tw1);
TranslationOfWord tw2 = new TranslationOfWord();
wd1.translations.Add(tw2);
WordOfDictionary wd2 = new WordOfDictionary();
dic1.Words.Add(wd2);
sw1.word_of_dictionary = wd1;
sw2.word_of_dictionary = wd2;
Dictionary dic2 = new Dictionary();
ctx.AddNewItemToDBContext(dic2);
WordOfDictionary wd3 = new WordOfDictionary();
dic1.Words.Add(wd3);
WordOfDictionary wd4 = new WordOfDictionary();
dic1.Words.Add(wd4);
sw3.word_of_dictionary = wd3;
ctx.SaveChanges();
return EFDbConnect;
}
public void TestFixtureSetUp()
{
_sqlite3Platform = new SQLitePlatformWin32();
_sqliteConnectionPool = new SQLiteConnectionPool(_sqlite3Platform);
}
