// Lolz; process for loading anki .apkg: rename to .zip, unzip, load .anki2 into sqlite, read cards based on format
// defined in this particular anki deck
public override FlashDeck GetFlashDeck(CardServer cardServer, string deckPath, string deckName = null)
{
deckName = deckName ?? GetDeckNameFromFileName(deckPath);
// SQLite connection
string connectionString = String.Format("Data Source={0};Version=3;", deckPath);
SQLiteConnection connection = new SQLiteConnection(connectionString);
connection.Open();
// Get Reader
string sql = "select flds from notes";
var command = new SQLiteCommand(sql, connection);
command.CommandType = CommandType.Text;
SQLiteDataReader dataReader = command.ExecuteReader();
// Read
FlashDeck deck = FlashDeck.FromNothing(cardServer, deckName);
string[] unicodeSpaceSeperator = { "\u001f" };
while (dataReader.Read())
{
string row = Convert.ToString(dataReader["flds"]);
string[] splitRow = row.Split(unicodeSpaceSeperator, StringSplitOptions.None);
string french = splitRow[1];
string english = splitRow[3];
Card loadedCard = new Card(french, english);
deck.AddCard(loadedCard);
}
return(deck);
}
public void ReloadWithDeckNames(string[] deckNames)
{
if (!ReloadRequested && !ShouldReloadDeck(deckNames))
{
return;
}
ReloadRequested = false;
_currentCard = null;
_cardServer = GlobalFactory.Container.Resolve <CardServer>();
_previouslyLoadedDecks = deckNames;
_myDeck = _database.GetCompoundDeck(_cardServer, deckNames);
ShowingFront = true;
GetNextCard(TrialPerformance.Fail); // TODO move this to a start event in WPF or something else...
}
private FlashDeck LoadSingleColumnCSV(CardServer cardServer, string deckPath, string deckName, string delimiter = ",")
{
FlashDeck deckToLoad = FlashDeck.FromNothing(cardServer, deckName);
using (TextFieldParser deckCSVParser = new TextFieldParser(@deckPath, System.Text.Encoding.GetEncoding("iso-8859-1")))
{
deckCSVParser.HasFieldsEnclosedInQuotes = false;
deckCSVParser.TextFieldType = FieldType.Delimited;
deckCSVParser.SetDelimiters(delimiter);
while (!deckCSVParser.EndOfData)
{
string[] flashCardSides = deckCSVParser.ReadFields();
Card loadedCard = new Card(flashCardSides[0], flashCardSides[1]);
deckToLoad.AddCard(loadedCard);
}
}
return(deckToLoad);
}
public FlashDeck GetFlashDeck()
{
FlashDeck deck = FlashDeck.FromAnki(_cardServer, Path.GetFullPath(relativeDatabasePath), deckName);
return(deck);
}
public FlashDeck GetFlashDeck()
{
FlashDeck deck = _database.GetDeck(_cardServer, deckName);
return(deck);
}
