public void getStoredProcedureSourceCodeTest()
{
var sqlAnalyser = new SqlAnalyser();
string spSrc = sqlAnalyser.getStoredProcedureSourceCode("dbo.ps_fwk_stock_s_warehouse_by_id");
Assert.AreEqual(@"
-- =============================================
-- Projet : ?? (MAJ du 25/01/2012 : DSI 606 - Date expédition commande)
-- Author : Sébastien Crocquesel
-- Create date : ??
-- Description : Gets a warehouse row
-- History : 1.2 (??)
-- Version : 1.2 (??) N.Bellino 25/01/2012 : ajout d'une colonne
-- =============================================
CREATE PROCEDURE [dbo].[ps_fwk_stock_s_warehouse_by_id]
(
@WarehouseId varchar(12)
)
AS
BEGIN
SET NOCOUNT ON
SELECT WarehouseId,Title, MaximumSmoothing
FROM fwk_stock_warehouse (nolock)
WHERE WarehouseId = @WarehouseId COLLATE database_default
END ", spSrc);
}
/// <summary>
/// 开局必须调用的函数
/// </summary>
/// <param name="interfaceName">如果自己有特殊接口，那么可以写自己的接口名</param>
public static void Initialize(string interfaceName = "IVasily")
{
List <Type> types = new List <Type>();
Assembly assmbly = Assembly.GetEntryAssembly();
if (assmbly == null)
{
return;
}
IEnumerator <Type> typeCollection = assmbly.ExportedTypes.GetEnumerator();
Type temp_Type = null;
while (typeCollection.MoveNext())
{
temp_Type = typeCollection.Current;
if (temp_Type.IsClass && !temp_Type.IsAbstract)
{
if (temp_Type.GetInterface(interfaceName) != null)
{
types.Add(temp_Type);
}
}
}
Parallel.ForEach(types, (element) => {
SqlAnalyser.Initialization(element);
});
}
private VasilyLink(Type type)
{
if (!VasilyCache.SqlModelCache.ContainsKey(type))
{
SqlAnalyser.Initialization(type);
}
_model = VasilyCache.SqlModelCache[type];
_maker = new SqlMaker(_model);
}
public void spIsReadOnlyTest()
{
var sqlAnalyser = new SqlAnalyser();
bool r = sqlAnalyser.spIsReadOnly("dbo.ps_fwk_stock_s_warehouse_by_id");
Assert.IsTrue(r);
r = sqlAnalyser.spIsReadOnly("dbo.ps_fwk_stock_i_vat");
Assert.IsFalse(r);
}
public override void Before(MethodInfo methodUnderTest)
{
VasilyService service = new VasilyService();
service.AddVasily(o =>
{
o.SqlSplite = "[]";
}).AddVasilyConnectionCache(o =>
{
// o.Key("house").AddConnection<MySqlConnection>(ConfigCache.Info.Connection);
}).AddVasilySqlCache(o =>
{
});
SqlAnalyser.Initialization(typeof(NormalTest));
SqlAnalyser.Initialization(typeof(AlTest));
}
