public void Load(MarkovFactory factory)
{
Log.Debug ( TAG, "Loading." );
myDatabase = context.OpenOrCreateDatabase (DATABASE_NAME, FileCreationMode.WorldReadable, null);
ICursor cursor = myDatabase.RawQuery ("SELECT * FROM 'words'", null);
int firstWordIndex = cursor.GetColumnIndex("firstWord");
int secondWordIndex = cursor.GetColumnIndex("secondWord");
int instanceCountIndex = cursor.GetColumnIndex("instanceCount");
string firstWord, secondWord;
int instanceCount;
cursor.MoveToFirst ();
while (!cursor.IsAfterLast)
{
firstWord = cursor.GetString ( firstWordIndex );
secondWord = cursor.GetString ( secondWordIndex );
instanceCount = cursor.GetInt( instanceCountIndex );
if (!factory.chain.ContainsKey( firstWord ) )
{
MarkovWord link = new MarkovWord(firstWord);
factory.chain.Add( firstWord, link );
}
MarkovWord afterWord;
if (!factory.chain.ContainsKey ( secondWord ) )
{
afterWord = new MarkovWord ( secondWord );
factory.chain.Add( secondWord, afterWord );
}
afterWord = factory.chain[secondWord];
factory.chain[ firstWord ].afters.Add( afterWord, instanceCount );
cursor.MoveToNext();
}
}
public List<Question> getAllQuestions() {
List<Question> quesList = new List<Question>();
// Select All Query
string selectQuery = "SELECT * FROM " + TABLE_QUEST;
dbase = this.ReadableDatabase;
Cursor cursor = dbase.RawQuery(selectQuery, null);
// looping through all rows and adding to list
if (cursor.MoveToFirst()) {
do {
Question quest = new Question();
quest.setID(cursor.GetInt(0));
quest.setQUESTION(cursor.GetString(1));
quest.setANSWER(cursor.GetString(2));
quest.setOPTA(cursor.GetString(3));
quest.setOPTB(cursor.GetString(4));
quest.setOPTC(cursor.GetString(5));
quesList.Add(quest);
} while (cursor.MoveToNext());
}
// return quest list
return quesList;
}
