RoutineBase.cs

Go to the documentation of this file.

using System;
using System.Collections.Generic;

namespace RoutineAnalyzer
{
    public abstract class RoutineBase
    {
        #region Fields
        
        protected string _sql;
        protected string _name;
        protected List<RoutineParamBase> _params = new List<RoutineParamBase>();

        #endregion

        #region Methods

        public RoutineBase(string sql)
        {
            _sql = sql;
            ParseDeclaration(_sql);
        }

        void ParseDeclaration(string declaration)
        {
            //pull out the name
            int startOfParams = FindName(declaration);
            FindAndCreateRoutineParams(declaration, startOfParams);
        }

        int FindName(string declaration)
        {
            int startOfParams = declaration.IndexOf("(");
            _name = declaration.Substring(0, startOfParams);
            return startOfParams;
        }

        void FindAndCreateRoutineParams(string declaration, int startOfParams)
        {
            //pull out the arguents and pass them off to create our param list
            int endOfParams = declaration.LastIndexOf(")");
            string args = declaration.Substring(startOfParams + 1, endOfParams - startOfParams - 1);
            string[] allArgs = args.Split(',');
            for(int i=0; i<allArgs.Length; ++ i)
            {
                RoutineParamBase param = CreateRoutineParam(allArgs[i], i);
                _params.Add(param);
            }
        }

        public abstract string GetDeclaration();

        public abstract string GetCode();

        protected abstract RoutineParamBase CreateRoutineParam(string sql, int index);

        #endregion
    }
}