using Dapper;
using VolPro.Core.EFDbContext;
using VolPro.Core.UserManager;
using VolPro.Entity.DomainModels;

namespace VolPro.Core.Generic
{
    /// <summary>
    /// MySql 通用 CRUD 实现
    /// </summary>
    public class GenericMySqlProvider : GenericDbProviderBase
    {
        protected override string LeftQuote => "`";
        protected override string RightQuote => "`";

        public GenericMySqlProvider() : base()
        {
        }
        protected override string BuildIdentitySql(TableColumnField keyColumn, bool batch = false)
        {
            // 单条插入和批量插入统一使用 LAST_INSERT_ID()
            // 批量场景下返回的是本次批量的起始自增值，上层根据行数自行推算每条的 Id
            return $" ;SELECT LAST_INSERT_ID();";
        }
    }
}