using System.Text;

namespace SyncEngine.SqlServer
{
    public static class SqlIdentifierHelper
    {
        public static string SanitizeConstraintName(string value)
        {
            if (string.IsNullOrWhiteSpace(value))
            {
                return "unnamed";
            }

            var sb = new StringBuilder(value.Length);
            foreach (var ch in value)
            {
                if (char.IsLetterOrDigit(ch))
                {
                    sb.Append(ch);
                }
                else
                {
                    sb.Append('_');
                }
            }

            var result = sb.ToString().Trim('_');
            return string.IsNullOrEmpty(result) ? "unnamed" : result;
        }
    }
}