/// <summary>
/// Get database insertion execution command
/// </summary>
/// <param name="translator">Query translator</param>
/// <param name="command">Command</param>
/// <returns>Return a database insertion command</returns>
DatabaseExecutionCommand GetDatabaseInsertionCommand(IQueryTranslator translator, DefaultCommand command)
{
translator.DataAccessContext.SetCommand(command);
string objectName = translator.DataAccessContext.GetCommandEntityObjectName(command);
var fields = DataManager.GetEditFields(CurrentDatabaseServerType, command.EntityType);
var fieldCount = fields.GetCount();
var insertFormatResult = PostgreSqlManager.FormatInsertionFields(command.EntityType, fieldCount, fields, command.Parameters, translator.ParameterSequence);
if (insertFormatResult == null)
{
return(null);
}
string cmdText = $"INSERT INTO {PostgreSqlManager.WrapKeyword(objectName)} ({string.Join(",", insertFormatResult.Item1)}) VALUES ({string.Join(",", insertFormatResult.Item2)});";
CommandParameters parameters = insertFormatResult.Item3;
translator.ParameterSequence += fieldCount;
return(new DatabaseExecutionCommand()
{
CommandText = cmdText,
CommandType = PostgreSqlManager.GetCommandType(command),
MustAffectedData = command.MustAffectedData,
Parameters = parameters
});
}
