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; }