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)); }