Ejemplo n.º 1
0
 public ShipsCache(SQLiteConnection db, AssetDatabase assets, DesignsCache designs)
     : base(db, assets)
 {
     this.designIDToShipID     = new Dictionary <int, int>();
     this.designs              = designs;
     designs.RowObjectDirtied += new RowObjectDirtiedEventHandler <int>(this.designs_RowObjectDirtied);
 }
Ejemplo n.º 2
0
        private static DesignSectionInfo GetDesignSectionInfoFromRow(
            Row row,
            SQLiteConnection db,
            AssetDatabase assets)
        {
            int               integer       = row[0].SQLiteValueToInteger();
            string            filename      = row[1].SQLiteValueToString();
            DesignSectionInfo designSection = new DesignSectionInfo()
            {
                ID               = integer,
                FilePath         = filename,
                ShipSectionAsset = assets.GetShipSectionAsset(filename),
                WeaponBanks      = DesignsCache.GetWeaponBankInfosForDesignSection(db, integer).ToList <WeaponBankInfo>(),
                Techs            = DesignsCache.GetTechsForDesignSection(db, integer).ToList <int>()
            };
            List <DesignModuleInfo> list = DesignsCache.GetModuleInfosForDesignSection(db, designSection).ToList <DesignModuleInfo>();

            designSection.Modules = new List <DesignModuleInfo>();
            foreach (LogicalModuleMount module in designSection.ShipSectionAsset.Modules)
            {
                LogicalModuleMount mount            = module;
                DesignModuleInfo   designModuleInfo = list.FirstOrDefault <DesignModuleInfo>((Func <DesignModuleInfo, bool>)(x => x.MountNodeName == mount.NodeName));
                if (designModuleInfo != null)
                {
                    designSection.Modules.Add(designModuleInfo);
                    list.Remove(designModuleInfo);
                }
            }
            return(designSection);
        }
Ejemplo n.º 3
0
 private static IEnumerable <WeaponBankInfo> GetWeaponBankInfosForDesignSection(
     SQLiteConnection db,
     int designSectionID)
 {
     foreach (Row row in db.ExecuteTableQuery(string.Format(Queries.GetWeaponBankInfos, (object)designSectionID.ToSQLiteValue()), true))
     {
         yield return(DesignsCache.GetWeaponBankInfoFromRow(row));
     }
 }
Ejemplo n.º 4
0
 private static IEnumerable <DesignModuleInfo> GetModuleInfosForDesignSection(
     SQLiteConnection db,
     DesignSectionInfo designSection)
 {
     foreach (Row row in db.ExecuteTableQuery(string.Format(Queries.GetDesignModuleInfos, (object)designSection.ID.ToSQLiteValue()), true))
     {
         yield return(DesignsCache.GetDesignModuleInfoFromRow(db, row, designSection));
     }
 }
Ejemplo n.º 5
0
 private static IEnumerable <ModulePsionicInfo> GetModulePsionicInfosByDesignModule(
     SQLiteConnection db,
     int designModuleId)
 {
     foreach (Row row in db.ExecuteTableQuery(string.Format(Queries.GetModulePsionicsByDesignModule, (object)designModuleId.ToSQLiteValue()), true))
     {
         yield return(DesignsCache.GetModulePsionicInfoFromRow(row));
     }
 }
Ejemplo n.º 6
0
 private static IEnumerable <DesignSectionInfo> GetDesignSectionInfos(
     SQLiteConnection db,
     AssetDatabase assets,
     int designID)
 {
     foreach (Row row in db.ExecuteTableQuery(string.Format(Queries.GetDesignSectionInfo, (object)designID), true))
     {
         yield return(DesignsCache.GetDesignSectionInfoFromRow(row, db, assets));
     }
 }
Ejemplo n.º 7
0
        protected override int OnInsert(SQLiteConnection db, int?key, DesignInfo value)
        {
            if (key.HasValue)
            {
                throw new ArgumentOutOfRangeException(nameof(key), "Design insertion does not permit explicit specification of an ID.");
            }
            if (ScriptHost.AllowConsole)
            {
                if (value.DesignSections == null || value.DesignSections.Length == 0)
                {
                    throw new InvalidDataException("DesignInfo does not supply any DesignSections.");
                }
            }
            else
            {
                RowCache <int, DesignInfo> .Warn(string.Format("DesignsCache.OnInsert: DesignInfo does not supply any DesignSections (player={0}, stationType={1}, stationLevel={2})", (object)value.PlayerID, (object)value.StationType.ToString(), (object)value.StationLevel.ToString()));
            }
            value.HackValidateRole();
            int num = db.ExecuteIntegerQuery(string.Format(Queries.InsertDesign, (object)value.PlayerID.ToOneBasedSQLiteValue(), (object)value.Name.ToSQLiteValue(), (object)value.Armour.ToSQLiteValue(), (object)value.Structure.ToSQLiteValue(), (object)value.NumTurrets.ToSQLiteValue(), (object)value.Mass.ToSQLiteValue(), (object)0.ToSQLiteValue(), (object)value.Acceleration.ToSQLiteValue(), (object)value.TopSpeed.ToSQLiteValue(), (object)value.SavingsCost.ToSQLiteValue(), (object)value.ProductionCost.ToSQLiteValue(), (object)((int)value.Class).ToSQLiteValue(), (object)value.CrewAvailable.ToSQLiteValue(), (object)value.PowerAvailable.ToSQLiteValue(), (object)value.SupplyAvailable.ToSQLiteValue(), (object)value.CrewRequired.ToSQLiteValue(), (object)value.PowerRequired.ToSQLiteValue(), (object)value.SupplyRequired.ToSQLiteValue(), (object)GameDatabase.GetTurnCount(db).ToSQLiteValue(), (object)((int)value.Role).ToSQLiteValue(), (object)((int)value.WeaponRole).ToSQLiteValue(), (object)value.isPrototyped.ToSQLiteValue(), (object)value.isAttributesDiscovered.ToSQLiteValue(), (object)((int)value.StationType).ToSQLiteValue(), (object)value.StationLevel.ToSQLiteValue(), (object)value.PriorityWeaponName.ToSQLiteValue(), (object)value.RetrofitBaseID.ToOneBasedSQLiteValue()));

            value.ID = num;
            foreach (DesignSectionInfo designSection in value.DesignSections)
            {
                designSection.DesignInfo = value;
                int designSectionId = db.ExecuteIntegerQuery(string.Format(Queries.InsertDesignSection.ToSQLiteValue(), (object)num.ToSQLiteValue(), (object)designSection.FilePath.ToSQLiteValue()));
                designSection.ID = designSectionId;
                if (designSection.WeaponBanks == null)
                {
                    designSection.WeaponBanks = new List <WeaponBankInfo>();
                }
                foreach (WeaponBankInfo weaponBank in designSection.WeaponBanks)
                {
                    weaponBank.ID = DesignsCache.InsertWeaponBank(db, designSectionId, weaponBank);
                }
                if (designSection.Modules == null)
                {
                    designSection.Modules = new List <DesignModuleInfo>();
                }
                foreach (DesignModuleInfo module in designSection.Modules)
                {
                    module.DesignSectionInfo = designSection;
                    module.ID = DesignsCache.InsertDesignModuleInfo(db, module);
                }
                if (designSection.Techs == null)
                {
                    designSection.Techs = new List <int>();
                }
                foreach (int tech in designSection.Techs)
                {
                    db.ExecuteIntegerQuery(string.Format(Queries.InsertDesignSectionTech, (object)designSectionId.ToSQLiteValue(), (object)tech.ToSQLiteValue()));
                }
            }
            return(num);
        }
Ejemplo n.º 8
0
 public SectionInstancesCache(
     SQLiteConnection db,
     AssetDatabase assets,
     DesignsCache designs,
     ShipsCache ships,
     StationsCache stations)
     : base(db, assets)
 {
     this.designs                = designs;
     this.ships                  = ships;
     this.stations               = stations;
     designs.RowObjectRemoving  += new RowObjectDirtiedEventHandler <int>(this.designs_RowObjectRemoving);
     ships.RowObjectRemoving    += new RowObjectDirtiedEventHandler <int>(this.ships_RowObjectRemoving);
     stations.RowObjectRemoving += new RowObjectDirtiedEventHandler <int>(this.stations_RowObjectRemoving);
 }
Ejemplo n.º 9
0
        private static DesignInfo GetDesignInfoFromRow(
            SQLiteConnection db,
            AssetDatabase assets,
            Row row)
        {
            int        integer    = row[0].SQLiteValueToInteger();
            DesignInfo designInfo = new DesignInfo()
            {
                ID                     = integer,
                DesignSections         = DesignsCache.GetDesignSectionInfos(db, assets, integer).ToArray <DesignSectionInfo>(),
                PlayerID               = row[1].SQLiteValueToOneBasedIndex(),
                Name                   = row[2],
                Armour                 = int.Parse(row[3]),
                Structure              = float.Parse(row[4]),
                NumTurrets             = int.Parse(row[5]),
                Mass                   = float.Parse(row[6]),
                Acceleration           = float.Parse(row[8]),
                TopSpeed               = float.Parse(row[9]),
                SavingsCost            = int.Parse(row[10]),
                ProductionCost         = int.Parse(row[11]),
                Class                  = (ShipClass)int.Parse(row[12]),
                CrewAvailable          = int.Parse(row[13]),
                PowerAvailable         = int.Parse(row[14]),
                SupplyAvailable        = int.Parse(row[15]),
                CrewRequired           = int.Parse(row[16]),
                PowerRequired          = int.Parse(row[17]),
                SupplyRequired         = int.Parse(row[18]),
                NumBuilt               = int.Parse(row[19]),
                DesignDate             = int.Parse(row[20]),
                Role                   = (ShipRole)int.Parse(row[21]),
                WeaponRole             = (WeaponRole)int.Parse(row[22]),
                isPrototyped           = bool.Parse(row[23]),
                isAttributesDiscovered = bool.Parse(row[24]),
                StationType            = (StationType)int.Parse(row[25]),
                StationLevel           = int.Parse(row[26]),
                PriorityWeaponName     = row[28] ?? string.Empty,
                NumDestroyed           = int.Parse(row[29]),
                RetrofitBaseID         = row[30].SQLiteValueToOneBasedIndex()
            };

            designInfo.HackValidateRole();
            foreach (DesignSectionInfo designSection in designInfo.DesignSections)
            {
                designSection.DesignInfo = designInfo;
            }
            return(designInfo);
        }
Ejemplo n.º 10
0
        internal static DesignModuleInfo GetDesignModuleInfoFromRow(
            SQLiteConnection db,
            Row row,
            DesignSectionInfo designSection)
        {
            int integer = row[0].SQLiteValueToInteger();

            row[1].SQLiteValueToInteger();
            DesignModuleInfo designModuleInfo1 = new DesignModuleInfo();

            designModuleInfo1.ID = integer;
            designModuleInfo1.DesignSectionInfo = designSection;
            designModuleInfo1.ModuleID          = row[2].SQLiteValueToInteger();
            designModuleInfo1.WeaponID          = row[3].SQLiteValueToNullableInteger();
            designModuleInfo1.MountNodeName     = row[4].SQLiteValueToString();
            DesignModuleInfo designModuleInfo2 = designModuleInfo1;
            int?nullableInteger = row[5].SQLiteValueToNullableInteger();

            ModuleEnums.StationModuleType?nullable = nullableInteger.HasValue ? new ModuleEnums.StationModuleType?((ModuleEnums.StationModuleType)nullableInteger.GetValueOrDefault()) : new ModuleEnums.StationModuleType?();
            designModuleInfo2.StationModuleType = nullable;
            designModuleInfo1.DesignID          = row.Count <string>() > 6 ? row[6].SQLiteValueToNullableInteger() : new int?();
            designModuleInfo1.PsionicAbilities  = DesignsCache.GetModulePsionicInfosByDesignModule(db, integer).ToList <ModulePsionicInfo>();
            return(designModuleInfo1);
        }
Ejemplo n.º 11
0
 protected override IEnumerable <KeyValuePair <int, DesignInfo> > OnSynchronizeWithDatabase(
     SQLiteConnection db,
     IEnumerable <int> range)
 {
     if (range == null)
     {
         foreach (Row row in db.ExecuteTableQuery(Queries.GetDesignInfos, true))
         {
             DesignInfo o = DesignsCache.GetDesignInfoFromRow(db, this.Assets, row);
             yield return(new KeyValuePair <int, DesignInfo>(o.ID, o));
         }
     }
     else
     {
         foreach (int num in range)
         {
             foreach (Row row in db.ExecuteTableQuery(string.Format(Queries.GetDesignInfo, (object)num.ToSQLiteValue()), true))
             {
                 DesignInfo o = DesignsCache.GetDesignInfoFromRow(db, this.Assets, row);
                 yield return(new KeyValuePair <int, DesignInfo>(o.ID, o));
             }
         }
     }
 }