Files

84 lines
3.2 KiB
C#

using System;
using System.Data.Common;
using Swarmops.Common.Enums;
using Swarmops.Database;
using Swarmops.Logic.Swarm;
namespace Swarmops.Utility.Migrations
{
public class PeopleOptionalData
{
public static void Migrate()
{
SwarmDb db = SwarmDb.GetDatabaseForAdmin();
using (DbConnection connection = db.GetSqlServerDbConnection())
{
connection.Open();
DbCommand command = connection.CreateCommand();
command.CommandText =
"SELECT PeopleOptionalData.PersonId, PersonOptionalDataTypes.Name AS PersonOptionalDataType, " +
"PeopleOptionalData.Data FROM PeopleOptionalData,PersonOptionalDataTypes " +
"WHERE PeopleOptionalData.PersonOptionalDataTypeId=PersonOptionalDataTypes.PersonOptionalDataTypeId ORDER BY PersonId";
using (DbDataReader reader = command.ExecuteReader())
{
int lastPersonId = 0;
while (reader.Read())
{
int personId = reader.GetInt32 (0);
string personOptionalDataTypeString = reader.GetString (1);
string data = reader.GetString (2);
string displayData = data;
if (displayData.Length > 40)
{
displayData = displayData.Substring (0, 40);
}
displayData = displayData.Replace ("\r\n", "#");
PersonOptionalDataKey key =
(PersonOptionalDataKey)
Enum.Parse (typeof (PersonOptionalDataKey), personOptionalDataTypeString);
// Display
Person person = null;
try
{
person = Person.FromIdentity (personId);
}
catch (Exception)
{
Console.WriteLine ("PERSON #{0} IS NOT IN DATABASE", personId);
}
if (person != null)
{
if (personId != lastPersonId)
{
Console.WriteLine (person.Canonical + " -- ");
lastPersonId = personId;
}
ObjectOptionalDataType dataType =
(ObjectOptionalDataType)
Enum.Parse (typeof (ObjectOptionalDataType), personOptionalDataTypeString);
Console.WriteLine (" -- {0,-20} {1}", dataType, displayData);
if (data.Trim().Length > 0)
{
db.SetObjectOptionalData (person, dataType, data);
}
}
}
}
}
}
}
}