public override void BuildColumnRenameSql(DbObjectChange change, DbColumnInfo oldColumn, DbColumnInfo newColumn)
{
change.AddScript(DbScriptType.ColumnRename,
$"ALTER TABLE {newColumn.Table.FullName} RENAME COLUMN {oldColumn.ColumnNameQuoted} TO {newColumn.ColumnNameQuoted};");
}
OdbcType GetSqlDbType(DbColumnInfo column)
{
var dbtype = column.DbTypeText;
var isarray = dbtype.EndsWith("[]");
if (isarray)
{
dbtype = dbtype.Remove(dbtype.Length - 2);
}
var ret = OdbcType.VarChar;
switch (dbtype.ToLower().TrimStart('_'))
{
case "tinyint": ret = OdbcType.TinyInt; break;
case "int2": ret = OdbcType.SmallInt; break;
case "int4": ret = OdbcType.Int; break;
case "int8": ret = OdbcType.BigInt; break;
case "numeric": ret = OdbcType.Numeric; break;
case "float4": ret = OdbcType.Real; break;
case "float8": ret = OdbcType.Double; break;
case "money": ret = OdbcType.Numeric; break;
case "char": ret = column.MaxLength == 36 ? OdbcType.UniqueIdentifier : OdbcType.Char; break;
case "bpchar": ret = OdbcType.Char; break;
case "varchar": ret = OdbcType.VarChar; break;
case "text": ret = OdbcType.Text; break;
case "timestamp": ret = OdbcType.Timestamp; break;
case "timestamptz": ret = OdbcType.Timestamp; break;
case "date": ret = OdbcType.Date; break;
case "time": ret = OdbcType.Time; break;
case "timetz": ret = OdbcType.Time; break;
case "interval": ret = OdbcType.Time; break;
case "bool": ret = OdbcType.Bit; break;
case "blob": ret = OdbcType.VarBinary; break;
case "bytea": ret = OdbcType.VarBinary; break;
case "bit": ret = OdbcType.Bit; break;
case "varbit": ret = OdbcType.VarBinary; break;
case "uuid": ret = OdbcType.UniqueIdentifier; break;
}
return(ret);
}
public string GetCsType(DbColumnInfo column) => _dicDbToCs.TryGetValue(column.DbTypeTextFull, out var trydc) ? (column.IsNullable ? trydc.csType : trydc.csType.Replace("?", "")) : null;
public string GetCsConvert(DbColumnInfo column) => _dicDbToCs.TryGetValue(column.DbType, out var trydc) ? (column.IsNullable ? trydc.csConvert : trydc.csConvert.Replace("?", "")) : null;
public string GetDataReaderMethod(DbColumnInfo column) => _dicDbToCs.TryGetValue(column.DbType, out var trydc) ? trydc.dataReaderMethod : null;
OdbcType GetSqlDbType(DbColumnInfo column)
{
switch (column.DbTypeText.ToLower())
{
case "bit": return(OdbcType.Bit);
case "tinyint": return(OdbcType.TinyInt);
case "smallint": return(OdbcType.SmallInt);
case "int": return(OdbcType.Int);
case "bigint": return(OdbcType.BigInt);
case "numeric":
case "decimal": return(OdbcType.Decimal);
case "smallmoney": return(OdbcType.Decimal);
case "money": return(OdbcType.Decimal);
case "float": return(OdbcType.Double);
case "real": return(OdbcType.Real);
case "date": return(OdbcType.Date);
case "datetime":
case "datetime2": return(OdbcType.DateTime);
case "datetimeoffset": return(OdbcType.DateTime);
case "smalldatetime": return(OdbcType.SmallDateTime);
case "time": return(OdbcType.Time);
case "char": return(OdbcType.Char);
case "varchar": return(OdbcType.VarChar);
case "text": return(OdbcType.Text);
case "nchar": return(OdbcType.NChar);
case "nvarchar": return(OdbcType.NVarChar);
case "ntext": return(OdbcType.NText);
case "binary": return(OdbcType.Binary);
case "varbinary": return(OdbcType.VarBinary);
case "image": return(OdbcType.Image);
case "timestamp": return(OdbcType.Timestamp);
case "uniqueidentifier": return(OdbcType.UniqueIdentifier);
default: return(OdbcType.NVarChar);
}
}
public SqlColumnValuePlaceHolder(DbColumnInfo column, ParameterDirection direction = ParameterDirection.Input)
{
Column = column;
ParamDirection = direction;
base.FormatLiteral = column.TypeInfo.TypeDef.ToLiteral;
}
protected virtual void KeyAction(EntityColumnInfo item, DbColumnInfo dbColumn, out bool pkDiff, out bool idEntityDiff)
{
pkDiff = item.IsPrimarykey != dbColumn.IsPrimarykey;
idEntityDiff = item.IsIdentity != dbColumn.IsIdentity;
}
OracleDbType GetSqlDbType(DbColumnInfo column)
{
var dbfull = column.DbTypeTextFull.ToLower();
switch (dbfull)
{
case "number(1)": return(OracleDbType.Boolean);
case "number(4)": return(OracleDbType.Decimal);
case "number(6)": return(OracleDbType.Int16);
case "number(11)": return(OracleDbType.Int32);
case "number(21)": return(OracleDbType.Int64);
case "number(3)": return(OracleDbType.Byte);
case "number(5)": return(OracleDbType.Decimal);
case "number(10)": return(OracleDbType.Decimal);
case "number(20)": return(OracleDbType.Decimal);
case "float(126)": return(OracleDbType.Double);
case "float(63)": return(OracleDbType.Single);
case "number(10,2)": return(OracleDbType.Decimal);
case "interval day(2) to second(6)": return(OracleDbType.IntervalDS);
case "timestamp(6)": return(OracleDbType.TimeStamp);
case "timestamp(6) with local time zone": return(OracleDbType.TimeStampLTZ);
case "blob": return(OracleDbType.Blob);
case "nvarchar2(255)": return(OracleDbType.NVarchar2);
case "char(36 char)": return(OracleDbType.Char);
}
switch (column.DbTypeText.ToLower())
{
case "number":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["number(10,2)"]);
return(OracleDbType.Decimal);
case "float":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["float(126)"]);
return(OracleDbType.Double);
case "interval day to second":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["interval day(2) to second(6)"]);
return(OracleDbType.IntervalDS);
case "date":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["date(7)"]);
return(OracleDbType.IntervalDS);
case "timestamp":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["timestamp(6)"]);
return(OracleDbType.TimeStamp);
case "timestamp with local time zone":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["timestamp(6) with local time zone"]);
return(OracleDbType.TimeStampLTZ);
case "blob":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["blob"]);
return(OracleDbType.Blob);
case "nvarchar2":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OracleDbType.NVarchar2);
case "varchar2":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OracleDbType.Varchar2);
case "char":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OracleDbType.Char);
case "nchar":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OracleDbType.NChar);
case "clob":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OracleDbType.Clob);
case "nclob":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OracleDbType.NClob);
case "raw":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["blob"]);
return(OracleDbType.Raw);
case "long raw":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["blob"]);
return(OracleDbType.LongRaw);
case "binary_float":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["float(63)"]);
return(OracleDbType.BinaryFloat);
case "binary_double":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["float(126)"]);
return(OracleDbType.BinaryDouble);
case "rowid":
default:
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OracleDbType.NVarchar2);
}
throw new NotImplementedException($"未实现 {column.DbTypeTextFull} 类型映射");
}
public override void BuildColumnRenameSql(DbObjectChange change, DbColumnInfo oldColumn, DbColumnInfo newColumn)
{
change.AddScript(DbScriptType.ColumnRename, "EXEC SYS.SP_RENAME '{0}.{1}.{2}' , '{3}', 'COLUMN'",
oldColumn.Table.Schema, oldColumn.Table.TableName, oldColumn.ColumnName, newColumn.ColumnName);
}
public int GetDbType(DbColumnInfo column) => (int)GetOscarDbType(column);
public override void BuildColumnRenameSql(DbObjectChange change, DbColumnInfo oldColumn, DbColumnInfo newColumn)
{
change.AddScript(DbScriptType.ColumnRename, "ALTER TABLE {0} RENAME COLUMN \"{1}\" TO \"{2}\";", newColumn.Table.FullName, oldColumn.ColumnName, newColumn.ColumnName);
}
private void btnTestConn_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtConnStrGen.Text))
{
try
{
if (skinLVConns.SelectedItems.Count > 0)
{
labelConnStatus.Text = "";
var a = skinLVConns.SelectedItems[0];
string testConnStr = txtConnStrGen.Text;
string DataBaseType = a.SubItems[5].Text;
SqlSugar.DbType sdt = SqlSugar.DbType.SqlServer;
switch (DataBaseType)
{
case "MSSql":
sdt = SqlSugar.DbType.SqlServer;
break;
case "Cache*":
break;
case "Oracle*":
sdt = SqlSugar.DbType.Oracle;
break;
default:
break;
}
using (SqlSugarClient ssc = SqlSugarUtils.GetDb(testConnStr, sdt))
{
List <DbColumnInfo> columns = new List <DbColumnInfo>();
DbColumnInfo column = new DbColumnInfo();
column.DataType = "varchar";
column.DbColumnName = "testcol";
column.Length = 50;
columns.Add(column);
bool result = ssc.DbMaintenance.CreateTable("HydTestDbTable", columns);
if (result)
{
ssc.DbMaintenance.DropTable("HydTestDbTable");
labelConnStatus.Text = "测试成功!";
}
else
{
labelConnStatus.Text = "连接失败!";
}
}
}
}
catch (Exception ex)
{
labelConnStatus.Text = "连接失败! " + ex.Message;
}
}
else
{
MessageBox.Show("请先 生成连接字符串");
}
}
DbType GetSqlDbType(DbColumnInfo column)
{
var dbfull = column.DbTypeTextFull.ToLower();
switch (dbfull)
{
case "boolean": return(DbType.Boolean);
case "smallint": return(DbType.Int16);
case "integer": return(DbType.Int32);
case "bigint": return(DbType.Int64);
case "int2": return(DbType.Byte);
case "unsigned": return(DbType.Decimal);
case "decimal(10,0)": return(DbType.Decimal);
case "decimal(21,0)": return(DbType.Decimal);
case "double": return(DbType.Double);
case "float": return(DbType.Single);
case "decimal(10,2)": return(DbType.Decimal);
case "datetime": return(DbType.DateTime);
case "blob": return(DbType.Binary);
case "nvarchar(255)": return(DbType.String);
case "character(36)": return(DbType.AnsiString);
}
switch (column.DbTypeText.ToLower())
{
case "int":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["integer"]);
return(DbType.Int32);
case "tinyint":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["int2"]);
return(DbType.Byte);
case "mediumint":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["bigint"]);
return(DbType.Int64);
case "unsigned big int":
case "int8":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["bigint"]);
return(DbType.Int64);
case "numeric":
case "decimal":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["decimal(10,2)"]);
return(DbType.Decimal);
case "date":
case "smalldatetime":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["datetime"]);
return(DbType.Date);
case "real":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["float"]);
return(DbType.Double);
case "double precision":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["double"]);
return(DbType.Double);
case "blob":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["blob"]);
return(DbType.Binary);
case "character":
case "varchar":
case "varying character":
case "nchar":
case "native character":
case "nvarchar":
case "text":
case "clob":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar(255)"]);
return(DbType.String);
default:
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar(255)"]);
return(DbType.String);
}
throw new NotImplementedException($"未实现 {column.DbTypeTextFull} 类型映射");
}
OdbcType GetOdbcType(DbColumnInfo column)
{
var is_unsigned = column.DbTypeTextFull.ToLower().EndsWith(" unsigned");
switch (column.DbTypeText.ToLower())
{
case "bit": return(OdbcType.Bit);
case "tinyint": return(is_unsigned ? OdbcType.TinyInt : OdbcType.SmallInt);
case "smallint": return(is_unsigned ? OdbcType.Int : OdbcType.SmallInt);
case "mediumint": return(is_unsigned ? OdbcType.Int : OdbcType.Int);
case "int": return(is_unsigned ? OdbcType.BigInt : OdbcType.Int);
case "bigint": return(is_unsigned ? OdbcType.Decimal : OdbcType.BigInt);
case "real":
case "double": return(OdbcType.Double);
case "float": return(OdbcType.Real);
case "numeric":
case "decimal": return(OdbcType.Decimal);
case "year": return(OdbcType.Int);
case "time": return(OdbcType.Time);
case "date": return(OdbcType.Date);
case "timestamp": return(OdbcType.Timestamp);
case "datetime": return(OdbcType.DateTime);
case "tinyblob": return(OdbcType.VarBinary);
case "blob": return(OdbcType.VarBinary);
case "mediumblob": return(OdbcType.VarBinary);
case "longblob": return(OdbcType.VarBinary);
case "binary": return(OdbcType.Binary);
case "varbinary": return(OdbcType.VarBinary);
case "tinytext": return(OdbcType.Text);
case "text": return(OdbcType.Text);
case "mediumtext": return(OdbcType.Text);
case "longtext": return(OdbcType.Text);
case "char": return(column.MaxLength == 36 ? OdbcType.Char : OdbcType.VarChar);
case "varchar": return(OdbcType.VarChar);
case "set": return(OdbcType.VarChar);
case "enum": return(OdbcType.VarChar);
default: return(OdbcType.VarChar);
}
}
protected virtual void ProcessColumn(DbColumnInfo info)
{
}
MySqlDbType GetMySqlDbType(DbColumnInfo column)
{
var is_unsigned = column.DbTypeTextFull?.ToLower().EndsWith(" unsigned") == true;
switch (column.DbTypeText?.ToLower())
{
case "bit": return(MySqlDbType.Bit);
case "tinyint": return(is_unsigned ? MySqlDbType.UByte : MySqlDbType.Byte);
case "smallint": return(is_unsigned ? MySqlDbType.UInt16 : MySqlDbType.Int16);
case "mediumint": return(is_unsigned ? MySqlDbType.UInt24 : MySqlDbType.Int24);
case "int": return(is_unsigned ? MySqlDbType.UInt32 : MySqlDbType.Int32);
case "bigint": return(is_unsigned ? MySqlDbType.UInt64 : MySqlDbType.Int64);
case "real":
case "double": return(MySqlDbType.Double);
case "float": return(MySqlDbType.Float);
case "numeric":
case "decimal": return(MySqlDbType.Decimal);
case "year": return(MySqlDbType.Year);
case "time": return(MySqlDbType.Time);
case "date": return(MySqlDbType.Date);
case "timestamp": return(MySqlDbType.Timestamp);
case "datetime": return(MySqlDbType.DateTime);
case "tinyblob": return(MySqlDbType.TinyBlob);
case "blob": return(MySqlDbType.Blob);
case "mediumblob": return(MySqlDbType.MediumBlob);
case "longblob": return(MySqlDbType.LongBlob);
case "binary": return(MySqlDbType.Binary);
case "varbinary": return(MySqlDbType.VarBinary);
case "tinytext": return(MySqlDbType.TinyText);
case "text": return(MySqlDbType.Text);
case "mediumtext": return(MySqlDbType.MediumText);
case "longtext": return(MySqlDbType.LongText);
case "char": return(column.MaxLength == 36 ? MySqlDbType.Guid : MySqlDbType.String);
case "varchar": return(MySqlDbType.VarChar);
case "set": return(MySqlDbType.Set);
case "enum": return(MySqlDbType.Enum);
case "point": return(MySqlDbType.Geometry);
case "linestring": return(MySqlDbType.Geometry);
case "polygon": return(MySqlDbType.Geometry);
case "geometry": return(MySqlDbType.Geometry);
case "multipoint": return(MySqlDbType.Geometry);
case "multilinestring": return(MySqlDbType.Geometry);
case "multipolygon": return(MySqlDbType.Geometry);
case "geometrycollection": return(MySqlDbType.Geometry);
default: return(MySqlDbType.String);
}
}
protected override void BuildKeyColomn(DbColumnInfo info)
{
Result.Append(info.IsAutoIncrement ? "\t[DbKey]\r\n" : "\t[DbKey(IsDbGenerate = false)]\r\n");
BuildColumn(info);
}
NpgsqlDbType GetNpgsqlDbType(DbColumnInfo column)
{
var dbtype = column.DbTypeText;
var isarray = dbtype.EndsWith("[]");
if (isarray)
{
dbtype = dbtype.Remove(dbtype.Length - 2);
}
NpgsqlDbType ret = NpgsqlDbType.Unknown;
switch (dbtype.ToLower().TrimStart('_'))
{
case "int2": ret = NpgsqlDbType.Smallint; break;
case "int4": ret = NpgsqlDbType.Integer; break;
case "int8": ret = NpgsqlDbType.Bigint; break;
case "numeric": ret = NpgsqlDbType.Numeric; break;
case "float4": ret = NpgsqlDbType.Real; break;
case "float8": ret = NpgsqlDbType.Double; break;
case "money": ret = NpgsqlDbType.Money; break;
case "bpchar": ret = NpgsqlDbType.Char; break;
case "varchar": ret = NpgsqlDbType.Varchar; break;
case "text": ret = NpgsqlDbType.Text; break;
case "timestamp": ret = NpgsqlDbType.Timestamp; break;
case "timestamptz": ret = NpgsqlDbType.TimestampTz; break;
case "date": ret = NpgsqlDbType.Date; break;
case "time": ret = NpgsqlDbType.Time; break;
case "timetz": ret = NpgsqlDbType.TimeTz; break;
case "interval": ret = NpgsqlDbType.Interval; break;
case "bool": ret = NpgsqlDbType.Boolean; break;
case "bytea": ret = NpgsqlDbType.Bytea; break;
case "bit": ret = NpgsqlDbType.Bit; break;
case "varbit": ret = NpgsqlDbType.Varbit; break;
case "point": ret = NpgsqlDbType.Point; break;
case "line": ret = NpgsqlDbType.Line; break;
case "lseg": ret = NpgsqlDbType.LSeg; break;
case "box": ret = NpgsqlDbType.Box; break;
case "path": ret = NpgsqlDbType.Path; break;
case "polygon": ret = NpgsqlDbType.Polygon; break;
case "circle": ret = NpgsqlDbType.Circle; break;
case "cidr": ret = NpgsqlDbType.Cidr; break;
case "inet": ret = NpgsqlDbType.Inet; break;
case "macaddr": ret = NpgsqlDbType.MacAddr; break;
case "json": ret = NpgsqlDbType.Json; break;
case "jsonb": ret = NpgsqlDbType.Jsonb; break;
case "uuid": ret = NpgsqlDbType.Uuid; break;
case "int4range": ret = NpgsqlDbType.Range | NpgsqlDbType.Integer; break;
case "int8range": ret = NpgsqlDbType.Range | NpgsqlDbType.Bigint; break;
case "numrange": ret = NpgsqlDbType.Range | NpgsqlDbType.Numeric; break;
case "tsrange": ret = NpgsqlDbType.Range | NpgsqlDbType.Timestamp; break;
case "tstzrange": ret = NpgsqlDbType.Range | NpgsqlDbType.TimestampTz; break;
case "daterange": ret = NpgsqlDbType.Range | NpgsqlDbType.Date; break;
case "hstore": ret = NpgsqlDbType.Hstore; break;
case "geometry": ret = NpgsqlDbType.Geometry; break;
}
return(isarray ? (ret | NpgsqlDbType.Array) : ret);
}
protected virtual void BuildKeyColomn(DbColumnInfo info)
{
}
OdbcType GetSqlDbType(DbColumnInfo column)
{
var dbfull = column.DbTypeTextFull.ToLower();
switch (dbfull)
{
case "number(1)": return(OdbcType.Bit);
case "number(4)": return(OdbcType.SmallInt);
case "number(6)": return(OdbcType.SmallInt);
case "number(11)": return(OdbcType.Int);
case "number(21)": return(OdbcType.BigInt);
case "number(3)": return(OdbcType.TinyInt);
case "number(5)": return(OdbcType.SmallInt);
case "number(10)": return(OdbcType.BigInt);
case "number(20)": return(OdbcType.Decimal);
case "float(126)": return(OdbcType.Double);
case "float(63)": return(OdbcType.Real);
case "number(10,2)": return(OdbcType.Decimal);
case "interval day(2) to second(6)": return(OdbcType.Time);
case "timestamp(6)": return(OdbcType.DateTime);
case "timestamp(6) with local time zone": return(OdbcType.DateTime);
case "blob": return(OdbcType.VarBinary);
case "nvarchar2(255)": return(OdbcType.NVarChar);
case "char(36 char)": return(OdbcType.Char);
}
switch (column.DbTypeText.ToLower())
{
case "number":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["number(10,2)"]);
return(OdbcType.Decimal);
case "float":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["float(126)"]);
return(OdbcType.Double);
case "interval day to second":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["interval day(2) to second(6)"]);
return(OdbcType.Time);
case "date":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["date(7)"]);
return(OdbcType.DateTime);
case "timestamp":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["timestamp(6)"]);
return(OdbcType.DateTime);
case "timestamp with local time zone":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["timestamp(6) with local time zone"]);
return(OdbcType.DateTime);
case "blob":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["blob"]);
return(OdbcType.VarBinary);
case "nvarchar2":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OdbcType.NVarChar);
case "varchar2":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OdbcType.NVarChar);
case "char":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OdbcType.Char);
case "nchar":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OdbcType.NChar);
case "clob":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OdbcType.NVarChar);
case "nclob":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OdbcType.NVarChar);
case "raw":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["blob"]);
return(OdbcType.VarBinary);
case "long raw":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["blob"]);
return(OdbcType.VarBinary);
case "binary_float":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["float(63)"]);
return(OdbcType.Real);
case "binary_double":
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["float(126)"]);
return(OdbcType.Double);
case "rowid":
default:
_dicDbToCs.TryAdd(dbfull, _dicDbToCs["nvarchar2(255)"]);
return(OdbcType.NVarChar);
}
throw new NotImplementedException($"未实现 {column.DbTypeTextFull} 类型映射");
}
public bool AddUsings(DbColumnInfo col, Dictionary <string, string> usings)
{
return(false);
}
public string GetCsTypeValue(DbColumnInfo column) => _dicDbToCs.TryGetValue(column.DbType, out var trydc) ? trydc.csTypeValue : null;
public List <DbTableInfo> GetTablesByDatabase(params string[] database)
{
var olddatabase = "";
using (var conn = _orm.Ado.MasterPool.Get(TimeSpan.FromSeconds(5)))
{
olddatabase = conn.Value.Database;
}
var dbs = database == null || database.Any() == false ? new[] { olddatabase } : database;
var tables = new List <DbTableInfo>();
foreach (var db in dbs)
{
if (string.IsNullOrEmpty(db))
{
continue;
}
var loc1 = new List <DbTableInfo>();
var loc2 = new Dictionary <int, DbTableInfo>();
var loc3 = new Dictionary <int, Dictionary <string, DbColumnInfo> >();
var sql = $@"
use [{db}];
select
a.Object_id
,b.name 'Owner'
,a.name 'Name'
,(select value from sys.extended_properties where major_id = a.object_id AND minor_id = 0 AND name = 'MS_Description') 'Comment'
,'TABLE' type
from sys.tables a
inner join sys.schemas b on b.schema_id = a.schema_id
where not(b.name = 'dbo' and a.name = 'sysdiagrams')
union all
select
a.Object_id
,b.name 'Owner'
,a.name 'Name'
,(select value from sys.extended_properties where major_id = a.object_id AND minor_id = 0 AND name = 'MS_Description') 'Comment'
,'VIEW' type
from sys.views a
inner join sys.schemas b on b.schema_id = a.schema_id
union all
select
a.Object_id
,b.name 'Owner'
,a.name 'Name'
,(select value from sys.extended_properties where major_id = a.object_id AND minor_id = 0 AND name = 'MS_Description') 'Comment'
,'StoreProcedure' type
from sys.procedures a
inner join sys.schemas b on b.schema_id = a.schema_id
where a.type = 'P' and charindex('diagram', a.name) = 0
order by type desc, b.name, a.name
;
use [{olddatabase}];
";
var ds = _orm.Ado.ExecuteArray(CommandType.Text, sql);
if (ds == null)
{
return(loc1);
}
var loc6 = new List <int[]>();
var loc66 = new List <int[]>();
var loc6_1000 = new List <int>();
var loc66_1000 = new List <int>();
foreach (object[] row in ds)
{
int object_id = int.Parse(string.Concat(row[0]));
var owner = string.Concat(row[1]);
var table = string.Concat(row[2]);
var comment = string.Concat(row[3]);
Enum.TryParse <DbTableType>(string.Concat(row[4]), out var type);
loc2.Add(object_id, new DbTableInfo {
Id = object_id.ToString(), Schema = owner, Name = table, Comment = comment, Type = type
});
loc3.Add(object_id, new Dictionary <string, DbColumnInfo>());
switch (type)
{
case DbTableType.VIEW:
case DbTableType.TABLE:
loc6_1000.Add(object_id);
if (loc6_1000.Count >= 500)
{
loc6.Add(loc6_1000.ToArray());
loc6_1000.Clear();
}
break;
case DbTableType.StoreProcedure:
loc66_1000.Add(object_id);
if (loc66_1000.Count >= 500)
{
loc66.Add(loc66_1000.ToArray());
loc66_1000.Clear();
}
break;
}
}
if (loc6_1000.Count > 0)
{
loc6.Add(loc6_1000.ToArray());
}
if (loc66_1000.Count > 0)
{
loc66.Add(loc66_1000.ToArray());
}
if (loc6.Count == 0)
{
return(loc1);
}
Func <List <int[]>, StringBuilder> getloc8Sb = loclist =>
{
if (loclist.Count == 0)
{
return(new StringBuilder());
}
var loc8sb = new StringBuilder().Append("(");
for (var loc8sbidx = 0; loc8sbidx < loclist.Count; loc8sbidx++)
{
if (loc8sbidx > 0)
{
loc8sb.Append(" OR ");
}
loc8sb.Append("a.table_name in (");
for (var loc8sbidx2 = 0; loc8sbidx2 < loclist[loc8sbidx].Length; loc8sbidx2++)
{
if (loc8sbidx2 > 0)
{
loc8sb.Append(",");
}
loc8sb.Append(loclist[loc8sbidx][loc8sbidx2]);
}
loc8sb.Append(")");
}
loc8sb.Append(")");
return(loc8sb);
};
var loc8 = getloc8Sb(loc6);
var loc88 = getloc8Sb(loc66);
var tsql_place = @"
select
isnull(e.name,'') + '.' + isnull(d.name,'')
,a.Object_id
,a.name 'Column'
,b.name 'Type'
,case
when b.name in ('Text', 'NText', 'Image') then -1
when b.name in ('NChar', 'NVarchar') then a.max_length / 2
else a.max_length end 'Length'
,b.name + case
when b.name in ('Char', 'VarChar', 'NChar', 'NVarChar', 'Binary', 'VarBinary') then '(' +
case when a.max_length = -1 then 'MAX'
when b.name in ('NChar', 'NVarchar') then cast(a.max_length / 2 as varchar)
else cast(a.max_length as varchar) end + ')'
when b.name in ('Numeric', 'Decimal') then '(' + cast(a.precision as varchar) + ',' + cast(a.scale as varchar) + ')'
else '' end as 'SqlType'
,( select value from sys.extended_properties where major_id = a.object_id AND minor_id = a.column_id AND name = 'MS_Description') 'Comment'
{0} a
inner join sys.types b on b.user_type_id = a.user_type_id
left join sys.tables d on d.object_id = a.object_id
left join sys.schemas e on e.schema_id = d.schema_id
where {1}
";
sql = string.Format(tsql_place, @"
,a.is_nullable 'IsNullable'
,a.is_identity 'IsIdentity'
from sys.columns", loc8.ToString().Replace("a.table_name", "a.object_id"));
if (loc88.Length > 0)
{
sql += "union all" +
string.Format(tsql_place.Replace(
" select value from sys.extended_properties where major_id = a.object_id AND minor_id = a.column_id",
" select value from sys.extended_properties where major_id = a.object_id AND minor_id = a.parameter_id"), @"
,cast(0 as bit) 'IsNullable'
,a.is_output 'IsIdentity'
from sys.parameters", loc88.ToString().Replace("a.table_name", "a.object_id"));
}
sql = $"use [{db}];{sql};use [{olddatabase}]; ";
ds = _orm.Ado.ExecuteArray(CommandType.Text, sql);
if (ds == null)
{
return(loc1);
}
foreach (object[] row in ds)
{
var table_id = string.Concat(row[0]);
var object_id = int.Parse(string.Concat(row[1]));
var column = string.Concat(row[2]);
var type = string.Concat(row[3]);
var max_length = int.Parse(string.Concat(row[4]));
var sqlType = string.Concat(row[5]);
var comment = string.Concat(row[6]);
var is_nullable = bool.Parse(string.Concat(row[7]));
var is_identity = bool.Parse(string.Concat(row[8]));
if (max_length == 0)
{
max_length = -1;
}
loc3[object_id].Add(column, new DbColumnInfo
{
Name = column,
MaxLength = max_length,
IsIdentity = is_identity,
IsNullable = is_nullable,
IsPrimary = false,
DbTypeText = type,
DbTypeTextFull = sqlType,
Table = loc2[object_id],
Coment = comment
});
loc3[object_id][column].DbType = this.GetDbType(loc3[object_id][column]);
loc3[object_id][column].CsType = this.GetCsTypeInfo(loc3[object_id][column]);
}
sql = $@"
use [{db}];
select
a.object_id 'Object_id'
,c.name 'Column'
,b.name 'Index_id'
,b.is_unique 'IsUnique'
,b.is_primary_key 'IsPrimaryKey'
,cast(case when b.type_desc = 'CLUSTERED' then 1 else 0 end as bit) 'IsClustered'
,case when a.is_descending_key = 1 then 1 else 0 end 'IsDesc'
from sys.index_columns a
inner join sys.indexes b on b.object_id = a.object_id and b.index_id = a.index_id
left join sys.columns c on c.object_id = a.object_id and c.column_id = a.column_id
where {loc8.ToString().Replace("a.table_name", "a.object_id")}
;
use [{olddatabase}];
";
ds = _orm.Ado.ExecuteArray(CommandType.Text, sql);
if (ds == null)
{
return(loc1);
}
var indexColumns = new Dictionary <int, Dictionary <string, DbIndexInfo> >();
var uniqueColumns = new Dictionary <int, Dictionary <string, DbIndexInfo> >();
foreach (object[] row in ds)
{
int object_id = int.Parse(string.Concat(row[0]));
string column = string.Concat(row[1]);
string index_id = string.Concat(row[2]);
bool is_unique = bool.Parse(string.Concat(row[3]));
bool is_primary_key = bool.Parse(string.Concat(row[4]));
bool is_clustered = bool.Parse(string.Concat(row[5]));
bool is_desc = string.Concat(row[6]) == "1";
if (loc3.ContainsKey(object_id) == false || loc3[object_id].ContainsKey(column) == false)
{
continue;
}
DbColumnInfo loc9 = loc3[object_id][column];
if (loc9.IsPrimary == false && is_primary_key)
{
loc9.IsPrimary = is_primary_key;
}
Dictionary <string, DbIndexInfo> loc10 = null;
DbIndexInfo loc11 = null;
if (!indexColumns.TryGetValue(object_id, out loc10))
{
indexColumns.Add(object_id, loc10 = new Dictionary <string, DbIndexInfo>());
}
if (!loc10.TryGetValue(index_id, out loc11))
{
loc10.Add(index_id, loc11 = new DbIndexInfo());
}
loc11.Columns.Add(new DbIndexColumnInfo {
Column = loc9, IsDesc = is_desc
});
if (is_unique && !is_primary_key)
{
if (!uniqueColumns.TryGetValue(object_id, out loc10))
{
uniqueColumns.Add(object_id, loc10 = new Dictionary <string, DbIndexInfo>());
}
if (!loc10.TryGetValue(index_id, out loc11))
{
loc10.Add(index_id, loc11 = new DbIndexInfo());
}
loc11.Columns.Add(new DbIndexColumnInfo {
Column = loc9, IsDesc = is_desc
});
}
}
foreach (var object_id in indexColumns.Keys)
{
foreach (var column in indexColumns[object_id])
{
loc2[object_id].IndexesDict.Add(column.Key, column.Value);
}
}
foreach (var object_id in uniqueColumns.Keys)
{
foreach (var column in uniqueColumns[object_id])
{
column.Value.Columns.Sort((c1, c2) => c1.Column.Name.CompareTo(c2.Column.Name));
loc2[object_id].UniquesDict.Add(column.Key, column.Value);
}
}
sql = $@"
use [{db}];
select
b.object_id 'Object_id'
,c.name 'Column'
,e.name 'FKId'
,a.referenced_object_id
,cast(1 as bit) 'IsForeignKey'
,d.name 'Referenced_Column'
,null 'Referenced_Sln'
,null 'Referenced_Table'
from sys.foreign_key_columns a
inner join sys.tables b on b.object_id = a.parent_object_id
inner join sys.columns c on c.object_id = a.parent_object_id and c.column_id = a.parent_column_id
inner join sys.columns d on d.object_id = a.referenced_object_id and d.column_id = a.referenced_column_id
left join sys.foreign_keys e on e.object_id = a.constraint_object_id
where {loc8.ToString().Replace("a.table_name", "b.object_id")}
;
use [{olddatabase}];
";
ds = _orm.Ado.ExecuteArray(CommandType.Text, sql);
if (ds == null)
{
return(loc1);
}
var fkColumns = new Dictionary <int, Dictionary <string, DbForeignInfo> >();
foreach (object[] row in ds)
{
int object_id, referenced_object_id;
int.TryParse(string.Concat(row[0]), out object_id);
var column = string.Concat(row[1]);
string fk_id = string.Concat(row[2]);
int.TryParse(string.Concat(row[3]), out referenced_object_id);
var is_foreign_key = bool.Parse(string.Concat(row[4]));
var referenced_column = string.Concat(row[5]);
var referenced_db = string.Concat(row[6]);
var referenced_table = string.Concat(row[7]);
DbColumnInfo loc9 = loc3[object_id][column];
DbTableInfo loc10 = null;
DbColumnInfo loc11 = null;
bool isThisSln = referenced_object_id != 0;
if (isThisSln)
{
loc10 = loc2[referenced_object_id];
loc11 = loc3[referenced_object_id][referenced_column];
}
else
{
}
Dictionary <string, DbForeignInfo> loc12 = null;
DbForeignInfo loc13 = null;
if (!fkColumns.TryGetValue(object_id, out loc12))
{
fkColumns.Add(object_id, loc12 = new Dictionary <string, DbForeignInfo>());
}
if (!loc12.TryGetValue(fk_id, out loc13))
{
loc12.Add(fk_id, loc13 = new DbForeignInfo {
Table = loc2[object_id], ReferencedTable = loc10
});
}
loc13.Columns.Add(loc9);
loc13.ReferencedColumns.Add(loc11);
}
foreach (var table_id in fkColumns.Keys)
{
foreach (var fk in fkColumns[table_id])
{
loc2[table_id].ForeignsDict.Add(fk.Key, fk.Value);
}
}
foreach (var table_id in loc3.Keys)
{
foreach (var loc5 in loc3[table_id].Values)
{
loc2[table_id].Columns.Add(loc5);
if (loc5.IsIdentity)
{
loc2[table_id].Identitys.Add(loc5);
}
if (loc5.IsPrimary)
{
loc2[table_id].Primarys.Add(loc5);
}
}
}
foreach (var loc4 in loc2.Values)
{
//if (loc4.Primarys.Count == 0 && loc4.UniquesDict.Count > 0)
//{
// foreach (var loc5 in loc4.UniquesDict.First().Value.Columns)
// {
// loc5.Column.IsPrimary = true;
// loc4.Primarys.Add(loc5.Column);
// }
//}
loc4.Primarys.Sort((c1, c2) => c1.Name.CompareTo(c2.Name));
loc4.Columns.Sort((c1, c2) =>
{
int compare = c2.IsPrimary.CompareTo(c1.IsPrimary);
if (compare == 0)
{
bool b1 = loc4.ForeignsDict.Values.Where(fk => fk.Columns.Where(c3 => c3.Name == c1.Name).Any()).Any();
bool b2 = loc4.ForeignsDict.Values.Where(fk => fk.Columns.Where(c3 => c3.Name == c2.Name).Any()).Any();
compare = b2.CompareTo(b1);
}
if (compare == 0)
{
compare = c1.Name.CompareTo(c2.Name);
}
return(compare);
});
loc1.Add(loc4);
}
loc1.Sort((t1, t2) =>
{
var ret = t1.Schema.CompareTo(t2.Schema);
if (ret == 0)
{
ret = t1.Name.CompareTo(t2.Name);
}
return(ret);
});
loc2.Clear();
loc3.Clear();
tables.AddRange(loc1);
}
return(tables);
}
public int GetDbType(DbColumnInfo column) => (int)GetSqlDbType(column);
/// <summary> /// null. /// </summary> /// <param name="column">Coluna.</param> /// <returns>null.</returns> public override string MethodDeclaration(DbColumnInfo column) => null;
public string GetCsStringify(DbColumnInfo column) => _dicDbToCs.TryGetValue(column.DbTypeTextFull, out var trydc) ? trydc.csStringify : null;
/// <summary> /// null. /// </summary> /// <param name="column">Coluna.</param> /// <returns>null.</returns> public override string ConstrutorBody(DbColumnInfo column) => null;
public Type GetCsTypeInfo(DbColumnInfo column) => _dicDbToCs.TryGetValue(column.DbTypeTextFull, out var trydc) ? trydc.csTypeInfo : null;
private bool IsPrimaryKey(DbColumnInfo it)
{
var result = GetPrimaryKeys().Any(p => p.Equals(it.DbColumnName, StringComparison.CurrentCultureIgnoreCase) || p.Equals(it.PropertyName, StringComparison.CurrentCultureIgnoreCase));
return(result);
}
