using Microsoft.EntityFrameworkCore;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace Server.SQL
{
    [Table("dynamic_data", Schema = "gamedb")]
    public class DynamicData
    {
        [Key]
        public long id { get; set; }
        public string name { get; set; }
        public string value { get; set; }
    }

    public class DynamicDataSQL : SQL<DynamicData>
    {
        public override DbSet<DynamicData> table { get; set; }

        public DynamicData SelectName(string name)
        {
            return table.SingleOrDefault(data => data.name == name);
        }

        public DynamicData GetDataByIndex(int id)
        {
            return table.SingleOrDefault(data => data.id == id);
        }

        public void Update(int id, string value)
        {
            var existingData = table.FirstOrDefault(data => data.id == id);

            if (existingData != null)
            {
                existingData.value = value;
                SaveChanges();
            }
        }

        public override List<DynamicData> SelectUid(int user_id)
        {
            return null;//table.Where(data => data.id == user_id).ToList();
        }
    }
}