public void CreateClassFromSqlTableReferenceForActualUseWhenNeedingToGenerateCSharpClasses()
{
var sqlTableReference = new SqlTableReference(SqlConnectionProviders.PbsiCopy, "PbsiWM.MTDINV_LINE");
var sqlTable = SqlTableFactory.Create(sqlTableReference);
var cSharpClass = CSharpClassGeneratorFromSqlTable.GenerateClass(sqlTable);
Console.WriteLine(cSharpClass);
}
public void CreateClassFromSqlTableReference()
{
var sqlTableReference = new SqlTableReference(SqlConnectionProviders.AdventureWorksDb, TableName);
var sqlTable = SqlTableFactory.Create(sqlTableReference);
var cSharpClass = CSharpClassGeneratorFromSqlTable.GenerateClass(sqlTable);
Console.WriteLine(cSharpClass);
}
public static string GenerateClassFromTable(this ISqlConnectionProvider sqlConnectionProvider,
string schemaname, string tableName,
string className = null)
{
className = className ?? tableName;
var sqlTableReference = new SqlTableReference(sqlConnectionProvider, schemaname, tableName);
var sqlTable = SqlTableFactory.Create(sqlTableReference);
return(CSharpClassGeneratorFromSqlTable.GenerateClass(sqlTable, className));
}
public void CreateManyRandomClassesFromInformationSchema()
{
string outputText = String.Empty;
var randomSqlTableReferences = RandomTableSelector.GetRandomSqlTableReferences(SqlConnectionProviders.AdventureWorksDb, 400);
foreach (var sqlTableReference in randomSqlTableReferences)
{
var sqlTable = SqlTableFactory.Create(sqlTableReference);
var cSharpClass = CSharpClassGeneratorFromSqlTable.GenerateClass(sqlTable);
outputText += cSharpClass;
}
Console.WriteLine(outputText);
}
public void CreateManyRandomClassesFromDescribeResultSet()
{
string outputText = String.Empty;
var randomSqlTableReferences = RandomTableSelector.GetRandomSqlTableReferences(SqlConnectionProviders.AdventureWorksDb, 400).OrderBy(x => x.SchemaName).ThenBy(x => x.TableName);
foreach (var sqlTableReference in randomSqlTableReferences)
{
var sqlTable = SqlTableFactory.Create(sqlTableReference);
var cSharpClass = CSharpClassGeneratorFromQueryViaSqlDescribeResultSet.GenerateClass(
sqlTableReference.SqlConnectionProvider, $"SELECT * FROM {sqlTable.Schema}.{sqlTable.Name}", sqlTable.Name);
outputText += cSharpClass + "\r\n";
}
Console.WriteLine(outputText);
}
public void TestCompilationOfManyClasses()
{
int errorCount = 0;
int successCount = 0;
IList <SqlTableReference> randomSqlTableReferences = null;
"Given a list of SqlTableReferences"
._(() =>
{
randomSqlTableReferences =
RandomTableSelector.GetRandomSqlTableReferences(SqlConnectionProviders.AdventureWorksDb, 400);
});
"Convert each table reference to a C# class and check for syntax errors using Roslyn"
._foreach(randomSqlTableReferences, sqlTableReference =>
{
var sqlTable = SqlTableFactory.Create(sqlTableReference);
var cSharpClass = CSharpClassGeneratorFromSqlTable.GenerateClass(sqlTable);
var compileResult = RoslynHelper.TryCompile(cSharpClass);
if (compileResult.IsValid())
{
successCount++;
}
else
{
errorCount++;
Console.WriteLine("Error found in the following:\r\n" + cSharpClass);
}
});
"Then print out testing results"
._(() =>
{
Console.WriteLine("Successes: {0}", successCount);
Console.WriteLine("Failures: {0}", errorCount);
errorCount.Should().Be(0);
});
}
public override void Initialize()
{
ExtendedFileTools.InitConfig();
SqlTableFactory.GetInstance <BankManager>(TShock.DB).InitializeTable();
SqlTableFactory.GetInstance <PrisonManager>(TShock.DB).InitializeTable();
SqlTableFactory.GetInstance <RaffleManager>(TShock.DB).InitializeTable();
SqlTableFactory.GetInstance <RegionHelperManager>(TShock.DB).InitializeTable();
ServerHooks.Join += new Action <int, System.ComponentModel.HandledEventArgs>(ServerHooks_Join);
NetHooks.GetData += new NetHooks.GetDataD(NetHooks_GetData);
NetHooks.SendData += new NetHooks.SendDataD(NetHooks_SendData);
GameHooks.Update += new Action(GameHooks_Update);
ServerHooks.Chat += new Action <messageBuffer, int, string, HandledEventArgs>(ServerHooks_Chat);
ServerHooks.Command += new ServerHooks.CommandD(ServerHooks_Command);
#region Initialize Commands
Commands.ChatCommands.Add(new Command(Permissions.manageregion, CommandHandlers.GetUserName, "username", "un"));
Commands.ChatCommands.Add(new Command(ExtendedPermissions.caninvincible, CommandHandlers.HandleInvincible, "invincible"));
Commands.ChatCommands.Add(new Command(Permissions.spawnmob, CommandHandlers.SpawnMobAtPlayerHandler, "spawnmobat", "sma"));
Commands.ChatCommands.Add(new Command(CommandHandlers.HandleLockDoor, "lockdoors", "ld"));
Commands.ChatCommands.Add(new Command(CommandHandlers.HandleUnlockDoor, "unlockdoors", "ud"));
Commands.ChatCommands.Add(new Command(CommandHandlers.HandleCurrentRegion, "currentregion"));
Commands.ChatCommands.Add(new Command(CommandHandlers.BuyRaffleTicket, "buyraffleticket"));
Commands.ChatCommands.Add(new Command(CommandHandlers.RaffleInfo, "raffleinfo"));
Commands.ChatCommands.Add(new Command(ExtendedPermissions.rafflemanager, CommandHandlers.StartRaffle, "startraffle"));
Commands.ChatCommands.Add(new Command(ExtendedPermissions.prisonmanager, CommandHandlers.SendToPrison, "sendtoprison"));
Commands.ChatCommands.Add(new Command(ExtendedPermissions.prisonmanager, CommandHandlers.ReleaseFromPrison, "releaseprisoner"));
Commands.ChatCommands.Add(new Command(ExtendedPermissions.prisonmanager, CommandHandlers.ClearPrison, "clearprison"));
Commands.ChatCommands.Add(new Command(ExtendedPermissions.prisonmanager, CommandHandlers.ExtendSentence, "extendsentence"));
Commands.ChatCommands.Add(new Command(ExtendedPermissions.canghost, CommandHandlers.Ghost, "ghost"));
Commands.ChatCommands.Add(new Command(Permissions.tphere, CommandHandlers.TpTo, "tpto"));
Commands.ChatCommands.Add(new Command(Permissions.buffplayer, CommandHandlers.BuffAll, "buffall", "ba"));
Commands.ChatCommands.Add(new Command(ExtendedPermissions.pvpbuff, CommandHandlers.Buff, "selfbuff"));
Commands.ChatCommands.Add(new Command(ExtendedPermissions.pvpheal, CommandHandlers.Heal, "selfheal"));
Commands.ChatCommands.Add(new Command(ExtendedPermissions.bank, CommandHandlers.Bank, "bank"));
#endregion
}
