本文整理汇总了C#中TShockAPI.DB.SqlTable类的典型用法代码示例。如果您正苦于以下问题：C# SqlTable类的具体用法？C# SqlTable怎么用？C# SqlTable使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
SqlTable类属于TShockAPI.DB命名空间，在下文中一共展示了SqlTable类的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的C#代码示例。
示例1: InitTerraDB
public static void InitTerraDB()
{
string sql = Path.Combine(terraDB);
if (!File.Exists(terraDB))
{
SqliteConnection.CreateFile(terraDB);
}
DB = new SqliteConnection(string.Format("uri=file://{0},Version=3", sql));
SQLWriter = new SqlTableCreator(DB, new SqliteQueryCreator());
var table = new SqlTable("Clans",
new SqlColumn("clanname", MySqlDbType.Text) { Unique = true },
new SqlColumn("clangroup", MySqlDbType.Text),
new SqlColumn("leaders", MySqlDbType.Text),
new SqlColumn("members", MySqlDbType.Text),
new SqlColumn("motd", MySqlDbType.Text),
new SqlColumn("invites", MySqlDbType.Text)
);
SQLWriter.EnsureExists(table);
table = new SqlTable("FoundQueue",
new SqlColumn("clanname", MySqlDbType.Text) { Unique = true },
new SqlColumn("founder", MySqlDbType.Text),
new SqlColumn("cofounder", MySqlDbType.Text)
);
SQLWriter.EnsureExists(table);
}
开发者ID:UB1AFU，项目名称:TerraClans，代码行数:25，代码来源:TCdb.cs
示例2: CheckTables
internal static void CheckTables(IDbConnection connection)
{
SQLWriter = new SqlTableCreator(connection, new MysqlQueryCreator());
var table = new SqlTable("BannedIP",
new SqlColumn("IP", MySqlDbType.Text),
new SqlColumn("BanDate", MySqlDbType.Int32),
new SqlColumn("UnbanDate", MySqlDbType.Int32),
new SqlColumn("BannedBy", MySqlDbType.Text),
new SqlColumn("Reason", MySqlDbType.Text)
);
SQLWriter.EnsureExists(table);
table = new SqlTable("BannedPlayer",
new SqlColumn("Player", MySqlDbType.Text),
new SqlColumn("BanDate", MySqlDbType.Int32),
new SqlColumn("UnbanDate", MySqlDbType.Int32),
new SqlColumn("BannedBy", MySqlDbType.Text),
new SqlColumn("Reason", MySqlDbType.Text)
);
SQLWriter.EnsureExists(table);
table = new SqlTable("MutedPlayer",
new SqlColumn("Player", MySqlDbType.Text),
new SqlColumn("MuteDate", MySqlDbType.Int32),
new SqlColumn("UnmuteDate", MySqlDbType.Int32),
new SqlColumn("MutedBy", MySqlDbType.Text),
new SqlColumn("Reason", MySqlDbType.Text)
);
SQLWriter.EnsureExists(table);
}
开发者ID:CoderCow，项目名称:ExtendedBans，代码行数:28，代码来源:EBData.cs
示例3: GroupManager
public GroupManager(IDbConnection db)
{
database = db;
var table = new SqlTable("GroupList",
new SqlColumn("GroupName", MySqlDbType.VarChar, 32) {Primary = true},
new SqlColumn("Parent", MySqlDbType.VarChar, 32),
new SqlColumn("Commands", MySqlDbType.Text),
new SqlColumn("ChatColor", MySqlDbType.Text),
new SqlColumn("Prefix", MySqlDbType.Text),
new SqlColumn("Suffix", MySqlDbType.Text)
);
var creator = new SqlTableCreator(db,
db.GetSqlType() == SqlType.Sqlite
? (IQueryBuilder) new SqliteQueryCreator()
: new MysqlQueryCreator());
creator.EnsureExists(table);
//Add default groups
AddGroup("guest", "canbuild,canregister,canlogin,canpartychat,cantalkinthird");
AddGroup("default", "guest", "warp,canchangepassword");
AddGroup("newadmin", "default", "kick,editspawn,reservedslot");
AddGroup("admin", "newadmin",
"ban,unban,whitelist,causeevents,spawnboss,spawnmob,managewarp,time,tp,pvpfun,kill,logs,immunetokick,tphere");
AddGroup("trustedadmin", "admin", "maintenance,cfg,butcher,item,heal,immunetoban,usebanneditem,manageusers");
AddGroup("vip", "default", "reservedslot");
}
开发者ID:kmcfate，项目名称:TShock，代码行数:27，代码来源:GroupManager.cs
示例4: GroupManager
public GroupManager(IDbConnection db)
{
database = db;
var table = new SqlTable("GroupList",
new SqlColumn("GroupName", MySqlDbType.VarChar, 32) { Primary = true },
new SqlColumn("Parent", MySqlDbType.VarChar, 32),
new SqlColumn("Commands", MySqlDbType.Text),
new SqlColumn("ChatColor", MySqlDbType.Text)
);
var creator = new SqlTableCreator(db, db.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator());
creator.EnsureExists(table);
//Add default groups
AddGroup("default", "canwater,canlava,warp,canbuild");
AddGroup("newadmin", "default", "kick,editspawn,reservedslot");
AddGroup("admin", "newadmin", "ban,unban,whitelist,causeevents,spawnboss,spawnmob,managewarp,time,tp,pvpfun,kill,logs,immunetokick,tphere");
AddGroup("trustedadmin", "admin", "maintenance,cfg,butcher,item,heal,immunetoban,ignorecheatdetection,ignoregriefdetection,usebanneditem,manageusers");
AddGroup("vip", "default", "canwater,canlava,warp,canbuild,reservedslot");
String file = Path.Combine(TShock.SavePath, "groups.txt");
if (File.Exists(file))
{
using (StreamReader sr = new StreamReader(file))
{
String line;
while ((line = sr.ReadLine()) != null)
{
if (!line.Equals("") && !line.Substring(0, 1).Equals("#"))
{
String[] info = line.Split(' ');
String comms = "";
int size = info.Length;
for (int i = 1; i < size; i++)
{
if (!comms.Equals(""))
comms = comms + ",";
comms = comms + info[i].Trim();
}
string query = "";
if (TShock.Config.StorageType.ToLower() == "sqlite")
query = "INSERT OR IGNORE INTO GroupList (GroupName, Commands) VALUES (@0, @1);";
else if (TShock.Config.StorageType.ToLower() == "mysql")
query = "INSERT IGNORE INTO GroupList SET [email protected], [email protected];";
db.Query(query, info[0].Trim(), comms);
}
}
}
String path = Path.Combine(TShock.SavePath, "old_configs");
String file2 = Path.Combine(path, "groups.txt");
if (!Directory.Exists(path))
Directory.CreateDirectory(path);
if (File.Exists(file2))
File.Delete(file2);
File.Move(file, file2);
}
}
开发者ID:char213，项目名称:TShock，代码行数:60，代码来源:GroupManager.cs
示例5: CharacterManager
public CharacterManager(IDbConnection db)
{
database = db;
var table = new SqlTable("tsCharacter",
new SqlColumn("Account", MySqlDbType.Int32) {Primary = true},
new SqlColumn("Health", MySqlDbType.Int32),
new SqlColumn("MaxHealth", MySqlDbType.Int32),
new SqlColumn("Mana", MySqlDbType.Int32),
new SqlColumn("MaxMana", MySqlDbType.Int32),
new SqlColumn("Inventory", MySqlDbType.Text),
new SqlColumn("extraSlot", MySqlDbType.Int32),
new SqlColumn("spawnX", MySqlDbType.Int32),
new SqlColumn("spawnY", MySqlDbType.Int32),
new SqlColumn("skinVariant", MySqlDbType.Int32),
new SqlColumn("hair", MySqlDbType.Int32),
new SqlColumn("hairDye", MySqlDbType.Int32),
new SqlColumn("hairColor", MySqlDbType.Int32),
new SqlColumn("pantsColor", MySqlDbType.Int32),
new SqlColumn("shirtColor", MySqlDbType.Int32),
new SqlColumn("underShirtColor", MySqlDbType.Int32),
new SqlColumn("shoeColor", MySqlDbType.Int32),
new SqlColumn("hideVisuals", MySqlDbType.Int32),
new SqlColumn("skinColor", MySqlDbType.Int32),
new SqlColumn("eyeColor", MySqlDbType.Int32),
new SqlColumn("questsCompleted", MySqlDbType.Int32)
);
var creator = new SqlTableCreator(db,
db.GetSqlType() == SqlType.Sqlite
? (IQueryBuilder) new SqliteQueryCreator()
: new MysqlQueryCreator());
creator.EnsureTableStructure(table);
}
开发者ID:sylar605，项目名称:TshockCN，代码行数:33，代码来源:CharacterManager.cs
示例6: WarpplateManager
public WarpplateManager(IDbConnection db)
{
this.database = db;
string arg_ED_0 = "Warpplates";
SqlColumn[] array = new SqlColumn[11];
array[0] = new SqlColumn("X1", MySqlDbType.Int32);
array[1] = new SqlColumn("Y1", MySqlDbType.Int32);
array[2] = new SqlColumn("width", MySqlDbType.Int32);
array[3] = new SqlColumn("height", MySqlDbType.Int32);
SqlColumn[] arg_7E_0 = array;
int arg_7E_1 = 4;
SqlColumn sqlColumn = new SqlColumn("WarpplateName", MySqlDbType.VarChar, new int?(50));
sqlColumn.Primary = true;
arg_7E_0[arg_7E_1] = sqlColumn;
array[5] = new SqlColumn("WorldID", MySqlDbType.Text);
array[6] = new SqlColumn("UserIds", MySqlDbType.Text);
array[7] = new SqlColumn("Protected", MySqlDbType.Int32);
array[8] = new SqlColumn("WarpplateDestination", MySqlDbType.VarChar, new int?(50));
array[9] = new SqlColumn("Delay", MySqlDbType.Int32);
array[10] = new SqlColumn("Label", MySqlDbType.Text);
SqlTable sqlTable = new SqlTable(arg_ED_0, array);
IQueryBuilder arg_10D_1;
if (DbExt.GetSqlType(db) != SqlType.Sqlite)
{
IQueryBuilder queryBuilder = new MysqlQueryCreator();
arg_10D_1 = queryBuilder;
}
else
{
arg_10D_1 = new SqliteQueryCreator();
}
SqlTableCreator sqlTableCreator = new SqlTableCreator(db, arg_10D_1);
sqlTableCreator.EnsureExists(sqlTable);
this.ReloadAllWarpplates();
}
开发者ID:Enerdy，项目名称:AdvancedWarpplates，代码行数:35，代码来源:WarpplateManager.cs
示例7: GetColumns
public List<string> GetColumns(SqlTable table)
{
var ret = new List<string>();
var name = database.GetSqlType();
if (name == SqlType.Sqlite)
{
using (var reader = database.QueryReader("PRAGMA table_info({0})".SFormat(table.Name)))
{
while (reader.Read())
ret.Add(reader.Get<string>("name"));
}
}
else if (name == SqlType.Mysql)
{
using (
var reader =
database.QueryReader(
"SELECT COLUMN_NAME FROM information_schema.COLUMNS WHERE [email protected] AND [email protected]", table.Name,
database.Database))
{
while (reader.Read())
ret.Add(reader.Get<string>("COLUMN_NAME"));
}
}
else
{
throw new NotSupportedException();
}
return ret;
}
开发者ID:sliekasirdis79，项目名称:TShock，代码行数:31，代码来源:SqlTable.cs
示例8: BanManager
/// <summary>
/// Initializes a new instance of the <see cref="TShockAPI.DB.BanManager"/> class.
/// </summary>
/// <param name="db">A valid connection to the TShock database</param>
public BanManager(IDbConnection db)
{
database = db;
var table = new SqlTable("Bans",
new SqlColumn("IP", MySqlDbType.String, 16) {Primary = true},
new SqlColumn("Name", MySqlDbType.Text),
new SqlColumn("UUID", MySqlDbType.Text),
new SqlColumn("Reason", MySqlDbType.Text),
new SqlColumn("BanningUser", MySqlDbType.Text),
new SqlColumn("Date", MySqlDbType.Text),
new SqlColumn("Expiration", MySqlDbType.Text)
);
var creator = new SqlTableCreator(db,
db.GetSqlType() == SqlType.Sqlite
? (IQueryBuilder) new SqliteQueryCreator()
: new MysqlQueryCreator());
try
{
creator.EnsureTableStructure(table);
}
catch (DllNotFoundException)
{
System.Console.WriteLine("Possible problem with your database - is Sqlite3.dll present?");
throw new Exception("Could not find a database library (probably Sqlite3.dll)");
}
}
开发者ID:sliekasirdis79，项目名称:TShock，代码行数:31，代码来源:BanManager.cs
示例9: InitializeTable
public void InitializeTable()
{
var table = new SqlTable("RegionHelper",
new SqlColumn("RegionName", MySql.Data.MySqlClient.MySqlDbType.Text),
new SqlColumn("IsLocked", MySql.Data.MySqlClient.MySqlDbType.Text));
var creator = new SqlTableCreator(_Connection, _Connection.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator());
creator.EnsureExists(table);
}
开发者ID:middas，项目名称:ExtendedAdmin，代码行数:9，代码来源:RegionHelper.cs
示例10: AlterTable
/// <summary>
/// Alter a table from source to destination
/// </summary>
/// <param name="from">Must have name and column names. Column types are not required</param>
/// <param name="to">Must have column names and column types.</param>
/// <returns></returns>
public string AlterTable(SqlTable from, SqlTable to)
{
var rstr = rand.NextString(20);
var alter = "RENAME TABLE {0} TO {1}_{0}".SFormat(from.Name, rstr);
var create = CreateTable(to);
//combine all columns in the 'from' variable excluding ones that aren't in the 'to' variable.
//exclude the ones that aren't in 'to' variable because if the column is deleted, why try to import the data?
var insert = "INSERT INTO {0} ({1}) SELECT {1} FROM {2}_{0}".SFormat(from.Name, string.Join(", ", from.Columns.Where(c => to.Columns.Any(c2 => c2.Name == c.Name)).Select(c => c.Name)), rstr);
var drop = "DROP TABLE {0}_{1}".SFormat(rstr, from.Name);
return "{0}; {1}; {2}; {3};".SFormat(alter, create, insert, drop);
}
开发者ID:pfchrono，项目名称:Toaria，代码行数:17，代码来源:IQueryBuilder.cs
示例11: Initialize
public static void Initialize()
{
if (!Directory.Exists(SavePath))
Directory.CreateDirectory(SavePath);
switch (TShock.Config.StorageType.ToLower())
{
case "mysql":
string[] host = TShock.Config.MySqlHost.Split(':');
Database = new MySqlConnection()
{
ConnectionString = string.Format("Server={0}; Port={1}; Database={2}; Uid={3}; Pwd={4};",
host[0],
host.Length == 1 ? "3306" : host[1],
TShock.Config.MySqlDbName,
TShock.Config.MySqlUsername,
TShock.Config.MySqlPassword)
};
break;
case "sqlite":
string sql = Path.Combine(SavePath, "Clans.sqlite");
Database = new SqliteConnection(string.Format("uri=file://{0},Version=3", sql));
break;
}
SqlTableCreator SQLcreator = new SqlTableCreator(Database, Database.GetSqlType() == SqlType.Sqlite
? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator());
SqlTable[] tables = new SqlTable[]
{
new SqlTable("Clans",
new SqlColumn("Name", MySqlDbType.VarChar) { Primary=true, Unique=true },
new SqlColumn("Owner", MySqlDbType.VarChar),
new SqlColumn("InviteMode", MySqlDbType.Int32),
new SqlColumn("TileX", MySqlDbType.Int32),
new SqlColumn("TileY", MySqlDbType.Int32),
new SqlColumn("ChatColor", MySqlDbType.VarChar),
new SqlColumn("Bans", MySqlDbType.VarChar)
),
new SqlTable("ClanMembers",
new SqlColumn("Username",MySqlDbType.VarChar) { Primary=true, Unique=true },
new SqlColumn("ClanName", MySqlDbType.VarChar)
),
new SqlTable("ClanWarps",
new SqlColumn("WarpName",MySqlDbType.VarChar) { Primary=true, Unique=true }
)
};
for (int i = 0; i < tables.Length; i++)
SQLcreator.EnsureTableStructure(tables[i]);
Config = Config.Read();
LoadClans();
}
开发者ID:MichaelMan57，项目名称:Clans，代码行数:53，代码来源:ClanManager.cs
示例12: VocationManager
public VocationManager(IDbConnection conn)
{
_conn = conn;
var table = new SqlTable(TableName,
new SqlColumn("id", MySqlDbType.Int32) { Primary = true },
new SqlColumn("level", MySqlDbType.Int32),
new SqlColumn("experience", MySqlDbType.Int64),
new SqlColumn("vocation", MySqlDbType.VarChar) { Primary = true, Length = 16 });
var creator = new SqlTableCreator(conn, DbProvider);
creator.EnsureTableStructure(table);
}
开发者ID:hastinbe，项目名称:VocationPlugin，代码行数:13，代码来源:VocationManager.cs
示例13: ChatManager
public ChatManager(IDbConnection db)
{
database = db;
var table = new SqlTable("Chat",
new SqlColumn("ID", MySqlDbType.Int32) { Primary = true, AutoIncrement = true },
new SqlColumn("Username", MySqlDbType.VarChar, 32),
new SqlColumn("ToUsername", MySqlDbType.VarChar, 32),
new SqlColumn("Message", MySqlDbType.VarChar, 32)
);
var creator = new SqlTableCreator(db, db.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator());
creator.EnsureExists(table);
}
开发者ID:RogerPaladin，项目名称:TShock，代码行数:13，代码来源:ChatManager.cs
示例14: InventoryManager
public InventoryManager(IDbConnection db)
{
database = db;
var table = new SqlTable("Inventory",
new SqlColumn("Account", MySqlDbType.Int32) { Primary = true },
new SqlColumn("MaxHealth", MySqlDbType.Int32),
new SqlColumn("MaxMana", MySqlDbType.Int32),
new SqlColumn("Inventory", MySqlDbType.Text)
);
var creator = new SqlTableCreator(db, db.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator());
creator.EnsureExists(table);
}
开发者ID:DaGamesta，项目名称:TShock，代码行数:13，代码来源:InventoryManager.cs
示例15: ArmorShopManager
public ArmorShopManager(IDbConnection db)
{
database = db;
var table = new SqlTable("Armor",
new SqlColumn("ID", MySqlDbType.Int32) { Primary = true, AutoIncrement = true },
new SqlColumn("Name", MySqlDbType.VarChar, 32),
new SqlColumn("InGameName", MySqlDbType.VarChar, 128),
new SqlColumn("Contains", MySqlDbType.VarChar, 128),
new SqlColumn("Price", MySqlDbType.Int32));
var creator = new SqlTableCreator(db, db.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator());
creator.EnsureExists(table);
}
开发者ID:RogerPaladin，项目名称:TShock，代码行数:13，代码来源:ArmorShopManager.cs
示例16: InventoryManager
public InventoryManager(IDbConnection db)
{
database = db;
var table = new SqlTable("Inventory",
new SqlColumn("Username", MySqlDbType.VarChar, 32) { Unique = true, Primary = true},
new SqlColumn("Slot0", MySqlDbType.VarChar, 32),
new SqlColumn("Slot1", MySqlDbType.VarChar, 32),
new SqlColumn("Slot2", MySqlDbType.VarChar, 32),
new SqlColumn("Slot3", MySqlDbType.VarChar, 32),
new SqlColumn("Slot4", MySqlDbType.VarChar, 32),
new SqlColumn("Slot5", MySqlDbType.VarChar, 32),
new SqlColumn("Slot6", MySqlDbType.VarChar, 32),
new SqlColumn("Slot7", MySqlDbType.VarChar, 32),
new SqlColumn("Slot8", MySqlDbType.VarChar, 32),
new SqlColumn("Slot9", MySqlDbType.VarChar, 32),
new SqlColumn("Slot10", MySqlDbType.VarChar, 32),
new SqlColumn("Slot11", MySqlDbType.VarChar, 32),
new SqlColumn("Slot12", MySqlDbType.VarChar, 32),
new SqlColumn("Slot13", MySqlDbType.VarChar, 32),
new SqlColumn("Slot14", MySqlDbType.VarChar, 32),
new SqlColumn("Slot15", MySqlDbType.VarChar, 32),
new SqlColumn("Slot16", MySqlDbType.VarChar, 32),
new SqlColumn("Slot17", MySqlDbType.VarChar, 32),
new SqlColumn("Slot18", MySqlDbType.VarChar, 32),
new SqlColumn("Slot19", MySqlDbType.VarChar, 32),
new SqlColumn("Slot20", MySqlDbType.VarChar, 32),
new SqlColumn("Slot21", MySqlDbType.VarChar, 32),
new SqlColumn("Slot22", MySqlDbType.VarChar, 32),
new SqlColumn("Slot23", MySqlDbType.VarChar, 32),
new SqlColumn("Slot24", MySqlDbType.VarChar, 32),
new SqlColumn("Slot25", MySqlDbType.VarChar, 32),
new SqlColumn("Slot26", MySqlDbType.VarChar, 32),
new SqlColumn("Slot27", MySqlDbType.VarChar, 32),
new SqlColumn("Slot28", MySqlDbType.VarChar, 32),
new SqlColumn("Slot29", MySqlDbType.VarChar, 32),
new SqlColumn("Slot30", MySqlDbType.VarChar, 32),
new SqlColumn("Slot31", MySqlDbType.VarChar, 32),
new SqlColumn("Slot32", MySqlDbType.VarChar, 32),
new SqlColumn("Slot33", MySqlDbType.VarChar, 32),
new SqlColumn("Slot34", MySqlDbType.VarChar, 32),
new SqlColumn("Slot35", MySqlDbType.VarChar, 32),
new SqlColumn("Slot36", MySqlDbType.VarChar, 32),
new SqlColumn("Slot37", MySqlDbType.VarChar, 32),
new SqlColumn("Slot38", MySqlDbType.VarChar, 32),
new SqlColumn("Slot39", MySqlDbType.VarChar, 32)
);
var creator = new SqlTableCreator(db, db.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator());
creator.EnsureExists(table);
}
开发者ID:RogerPaladin，项目名称:TShock，代码行数:50，代码来源:InventoryManager.cs
示例17: RemeberedPosManager
public RemeberedPosManager(IDbConnection db)
{
database = db;
var table = new SqlTable("RememberedPos",
new SqlColumn("Name", MySqlDbType.VarChar, 50) { Primary = true },
new SqlColumn("IP", MySqlDbType.Text),
new SqlColumn("X", MySqlDbType.Int32),
new SqlColumn("Y", MySqlDbType.Int32),
new SqlColumn("WorldID", MySqlDbType.Text)
);
var creator = new SqlTableCreator(db, db.GetSqlType() == SqlType.Sqlite ? (IQueryBuilder)new SqliteQueryCreator() : new MysqlQueryCreator());
creator.EnsureExists(table);
}
开发者ID:BlueJayofEvil，项目名称:TShock，代码行数:14，代码来源:RememberPosManager.cs
示例18: CreateTable
public override string CreateTable(SqlTable table)
{
var columns =
table.Columns.Select(
c =>
"'{0}' {1} {2} {3} {4}".SFormat(c.Name,
DbTypeToString(c.Type, c.Length),
c.Primary ? "PRIMARY KEY" : "",
c.AutoIncrement ? "AUTOINCREMENT" : "",
c.NotNull ? "NOT NULL" : ""));
var uniques = table.Columns.Where(c => c.Unique).Select(c => c.Name);
return "CREATE TABLE {0} ({1} {2})".SFormat(EscapeTableName(table.Name),
string.Join(", ", columns),
uniques.Count() > 0 ? ", UNIQUE({0})".SFormat(string.Join(", ", uniques)) : "");
}
开发者ID:sliekasirdis79，项目名称:TShock，代码行数:15，代码来源:IQueryBuilder.cs
示例19: UserManager
public UserManager(IDbConnection db)
{
database = db;
var table = new SqlTable("users",
new SqlColumn("steam64", MySqlDbType.VarChar, 64),
new SqlColumn("username", MySqlDbType.VarChar, 32) {Primary = true, Unique = true},
new SqlColumn("banned", MySqlDbType.Int32)
);
var creator = new SqlTableCreator(db,
db.GetSqlType() == SqlType.Sqlite
? (IQueryBuilder) new SqliteQueryCreator()
: new MysqlQueryCreator());
creator.EnsureExists(table);
database.Query("UPDATE Users set steam64 = @0 WHERE username=\"olink\"", 76561198011175230);
}
开发者ID:nicatronTg，项目名称:white-lotus，代码行数:15，代码来源:UserManager.cs
示例20: EnsureExists
public void EnsureExists(SqlTable table)
{
var columns = GetColumns(table);
if (columns.Count > 0)
{
if (!table.Columns.All(c => columns.Contains(c.Name)) || !columns.All(c => table.Columns.Any(c2 => c2.Name == c)))
{
var from = new SqlTable(table.Name, columns.Select(s => new SqlColumn(s, MySqlDbType.String)).ToList());
database.Query(creator.AlterTable(from, table));
}
}
else
{
database.Query(creator.CreateTable(table));
}
}
开发者ID:pfchrono，项目名称:Toaria，代码行数:16，代码来源:SqlTable.cs
注：本文中的TShockAPI.DB.SqlTable类示例由纯净天空整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。 |
客服电话
APP下载
官方微信
请发表评论