示例#1
0
        private object ConvertToColumnDefinitionDDL(NewTableParameters parameters)
        {
            List <string> ddl     = new List <string>();
            string        current = "";
            var           pkre    = new Regex(@"\s+primary\s+key($|\s+)");
            var           hasPk   = false;

            foreach (string item in parameters.Columns)
            {
                if (item.StartsWith("-"))
                {
                    if (!String.IsNullOrEmpty(current))
                    {
                        hasPk = hasPk || pkre.IsMatch(current);
                        ddl.Add(current);
                    }
                    current = item.TrimStart('-').Replace(":", "");
                }
                else
                {
                    current += " " + item;
                }
            }

            if (!String.IsNullOrEmpty(current))
            {
                hasPk = hasPk || pkre.IsMatch(current);
                ddl.Add(current);
            }

            if (!hasPk)
            {
                ddl.Add("_id integer primary key");
            }

            return(String.Join(", ", ddl.ToArray()));
        }
示例#2
0
        private object ConvertToColumnDefinitionDDL(NewTableParameters parameters)
        {
            List<string> ddl = new List<string>();
            string current = "";
            var pkre = new Regex(@"\s+primary\s+key($|\s+)");
            var hasPk = false;

            foreach (string item in parameters.Columns )
            {
                if( item.StartsWith("-"))
                {
					if (!String.IsNullOrEmpty(current))
					{
						hasPk = hasPk || pkre.IsMatch(current);
						ddl.Add(current);
					}
					current = item.TrimStart('-').Replace (":", "");
                }
                else
                {
                    current += " " + item;
                }
            }

            if (!String.IsNullOrEmpty(current))
            {
                hasPk = hasPk || pkre.IsMatch(current);
                ddl.Add(current);
            }

            if (!hasPk)
            {
                ddl.Add("_id integer primary key");
            }

            return String.Join(", ", ddl.ToArray());
        }