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 string GetRecordByEui(object conn, XMLRealiser.LexiconType lexiconType, string eui) { switch (lexiconType) { case XMLRealiser.LexiconType.NIHDB_HSQL: throw new NotImplementedException("HSQLdb disabled"); string query = "SELECT lexRecord FROM LEX_RECORD WHERE (eui = '" + eui + "' AND lastAction <> 3)"; //Statement statement = ((Connection)conn).createStatement(); //ResultSet rs = statement.executeQuery(query); //string lexRecord = ""; //while (rs.next()) //{ // lexRecord = rs.getString("lexRecord"); //} //rs.close(); //statement.close(); //return lexRecord; case XMLRealiser.LexiconType.NIHDB_SQLITE: List <string> recordStringList = new List <string>(); SQLiteCommand command = new SQLiteCommand("SELECT lexRecord FROM LEX_RECORD WHERE (eui = @ID AND lastAction <> 3)", (SQLiteConnection)conn); command.Parameters.AddWithValue("@ID", eui); SqliteAccess.ProcessDataReader((SQLiteConnection)conn, command, reader => recordStringList.Add(reader["lexRecord"] as string)); return(recordStringList[0]); } return(null); }
public static List <string> GetBasesByEui(object conn, XMLRealiser.LexiconType lexiconType, string eui) { switch (lexiconType) { case XMLRealiser.LexiconType.NIHDB_HSQL: throw new NotImplementedException("HSQLdb disabled"); //string query = "SELECT inflVar FROM INFL_VARS where (eui = '" + eui + "' and inflection = 1)"; //Statement statement = ((Connection) conn).createStatement(); //ResultSet rs = statement.executeQuery(query); //List<string> outs = new List<string>(); //while (rs.next()) //{ // string @base = rs.getString("inflVar"); // outs.Add(@base); //} //rs.close(); //statement.close(); //return outs; case XMLRealiser.LexiconType.NIHDB_SQLITE: List <string> recordStringList = new List <string>(); SQLiteCommand command = new SQLiteCommand("SELECT inflVar FROM INFL_VARS where (eui = @EUI and inflection = 1)", (SQLiteConnection)conn); command.Parameters.AddWithValue("@EUI", eui); SqliteAccess.ProcessDataReader((SQLiteConnection)conn, command, reader => recordStringList.Add(reader["inflVar"] as string)); return(recordStringList); } return(null); }
public static List <string> GetRecordsByCat(object conn, XMLRealiser.LexiconType lexiconType, long category) { string catCondition = GetCategoryCondition(category); string query = "SELECT lexRecord FROM LEX_RECORD where ((lastAction <> 3)" + catCondition + ")"; switch (lexiconType) { case XMLRealiser.LexiconType.NIHDB_HSQL: throw new NotImplementedException("HSQLdb disabled"); //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(query); 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); }