public static List <string> GetRecordsByBase(object conn, XMLRealiser.LexiconType lexiconType, string @base) { switch (lexiconType) { case XMLRealiser.LexiconType.NIHDB_HSQL: throw new NotImplementedException("HSQLdb disabled"); string query = "SELECT lexRecord FROM LEX_RECORD where (base = '" + DbBase.FormatSqlStr(@base) + "' and lastAction <> 3)"; //Statement statement = ((Connection) conn).createStatement(); //ResultSet rs = statement.executeQuery(query); //List<string> outs = new List<string>(); //while (rs.next()) //{ // string lexRecord = rs.getString("lexRecord"); // outs.Add(lexRecord); //} //rs.close(); //statement.close(); //return outs; case XMLRealiser.LexiconType.NIHDB_SQLITE: List <string> recordStringList = new List <string>(); SQLiteCommand command = new SQLiteCommand("SELECT lexRecord FROM LEX_RECORD where (base = @BaseForm and lastAction <> 3)", (SQLiteConnection)conn); command.Parameters.Add("@BaseForm", DbType.String).Value = @base; SqliteAccess.ProcessDataReader((SQLiteConnection)conn, command, reader => recordStringList.Add(reader["lexRecord"] as string)); return(recordStringList); } return(null); }
public static List <string> GetEuis(object conn, XMLRealiser.LexiconType lexiconType, string inflVar) { switch (lexiconType) { case XMLRealiser.LexiconType.NIHDB_HSQL: throw new NotImplementedException("HSQLdb disabled"); string query = "SELECT eui FROM INFL_VARS where (inflVarLc = '" + DbBase.FormatSqlStr(inflVar.ToLower()) + "')"; //Statement statement = ((Connection) conn).createStatement(); //ResultSet rs = statement.executeQuery(query); //List<string> outs = new List<string>(); //while (rs.next()) //{ // string eui = rs.getString("eui"); // outs.Add(eui); //} //rs.close(); //statement.close(); //return outs; case XMLRealiser.LexiconType.NIHDB_SQLITE: List <string> euis = new List <string>(); SQLiteCommand command = new SQLiteCommand("SELECT eui FROM INFL_VARS where (inflVarLc = @INFLVAR)", (SQLiteConnection)conn); command.Parameters.AddWithValue("@INFLVAR", DbBase.FormatSqlStr(inflVar.ToLower())); SqliteAccess.ProcessDataReader((SQLiteConnection)conn, command, reader => euis.Add(reader["eui"] as string)); return(euis); } return(null); }