/// <summary>
		/// The execute query simple.
		/// </summary>
		/// <param name="query">The query.</param>
		/// <param name="parameterValues">The parameter values.</param>
		/// <param name="version">The version.</param>
		/// <param name="progress">The progress.</param>
		/// <param name="groups">The groups.</param>
		/// <returns>
		/// The <see cref="QueryInstanceResultInfo" />.
		/// </returns>
		public QueryInstanceResultInfo ExecuteQuerySimple(
			QueryInfo                query,
			QueryExecutionParams     parameters,
			InstanceVersion          version,
			ProgressItem             progress,
			params GroupDefinition[] groups
		)
		{
			// Log.InfoFormat("73:query:'{0}'",
			// 	query
			// );

			QueryInstanceResultInfo result = new QueryInstanceResultInfo(this.Instance);
			QueryItemInfo queryItem        = query.Items.GetQueryItemForVersion(version);

			this.PrepareProgress(progress, groups);

			this.ExecuteQuery(
				query,
				parameters,
				progress,
				groups,
				result,
				queryItem
			);

			return result;
		}

        public void GetStatementTest()
        {
            var inf = new QueryInfo();
            var input1 = "select * from A";
            (inf.AsDynamic().GetStatement(input1) as string[]).IsStructuralEqual(new[] { "select * from A" });

            var input2 = "select * from A;";
            (inf.AsDynamic().GetStatement(input2) as string[]).IsStructuralEqual(new[] { "select * from A" });

            var input3 = "select * from A; select * from B";
            (inf.AsDynamic().GetStatement(input3) as string[]).IsStructuralEqual(new[] { "select * from A", "select * from B" });

            var input4 = @"" + Environment.NewLine +
                      @" create trigger set_foo_primary for foo" + Environment.NewLine +
                      @"before insert" + Environment.NewLine +
                      @"" + Environment.NewLine +
                      @"as begin" + Environment.NewLine +
                      @"" + Environment.NewLine +
                      @"new.a = gen_id(gen_foo, 1);" + Environment.NewLine +
                      @"end" + Environment.NewLine +
                      @";" + Environment.NewLine +
                      @"  select* from A;" + Environment.NewLine +
                      @" create table V(a integer, b nvarchar(5))";
            (inf.AsDynamic().GetStatement(input4) as string[]).IsStructuralEqual(new[] {
                  @"create trigger set_foo_primary for foo" + Environment.NewLine +
                      @"before insert" + Environment.NewLine +
                      @"" + Environment.NewLine +
                      @"as begin" + Environment.NewLine +
                      @"" + Environment.NewLine +
                      @"new.a = gen_id(gen_foo, 1);" + Environment.NewLine +
                      @"end" ,
                "select* from A", "create table V(a integer, b nvarchar(5))" });
        }

        /// <summary>
        /// Load the artist search.
        /// </summary>
        public override void Load(XmlDocument doc, QueryInfo query)
        {
            last_query = query;

            foreach (Widget widget in album_box.Children)
                album_box.Remove (widget);

            XmlNodeList list = doc.GetElementsByTagName ("getArtistResponse");
            if (list.Count == 0)
                return;

            string artist = null;
            XmlNodeList albums_node = null;

            //look for artist name
            foreach (XmlNode node in list[0].ChildNodes)
            {
                if (node.Name == "artist")
                {
                    artist = node.InnerText;
                    search_title.Markup = "<b><big><big>" + Utils.ParseMarkup (artist) + "</big></big></b>\n";
                }
                else if (node.Name == "albums")
                    albums_node = node.ChildNodes;
            }

            if (albums_node == null || albums_node.Count == 0)
                return;

            string name = null;
            string year = null;

            album_box.PackStart (new HSeparator (), false, false, 2);

            foreach (XmlNode node in albums_node)
            {
                switch (node.Name)
                {
                    case "album":
                        name = node.InnerText;
                        break;

                    case "year":
                        if (node.InnerText != "0")
                            year = node.InnerText;
                        break;

                    case "songs":
                        Album album = new Album (artist, name, year, node.ChildNodes);

                        album_box.PackStart (new AlbumBox (album, main), false ,false, 0);
                        album_box.PackStart (new HSeparator (), false, false, 2);

                        name = null;
                        year = null;
                        break;
                }
            }
        }

 public static Word GetModel(QueryInfo queryInfo)
 {
     List<Word> list = GetList(queryInfo);
     if (list == null || list.Count == 0)
         return null;
     else
         return list[0];
 }

 public static SmallClass GetModel(QueryInfo queryInfo)
 {
     List<SmallClass> list = GetList(queryInfo);
     if (list == null || list.Count == 0)
         return null;
     else
         return list[0];
 }

 public static ItemInCustomSmallType GetModel(QueryInfo queryInfo)
 {
     List<ItemInCustomSmallType> list = GetList(queryInfo);
     if (list == null || list.Count == 0)
         return null;
     else
         return list[0];
 }

        /// <summary>
        /// The query to execute.
        /// </summary>
        public override string GetQuery(QueryInfo query)
        {
            if (query.Equals (last_query, QueryField.Username))
                return null;

            string url = "http://ws.audioscrobbler.com/1.0/user/{0}/topartists.xml";
            return ParseQuery (url, query.Username);
        }

        /// <summary>
        /// The query to execute.
        /// </summary>
        public override string GetQuery(QueryInfo query)
        {
            if (query.Equals (last_query, QueryField.Artist, QueryField.Title))
                return null;

            string url = "http://lyricwiki.org/api.php?artist={0}&song={1}&fmt=xml";
            return ParseQuery (url, query.Artist, query.Title);
        }

        /// <summary>
        /// The query to execute.
        /// </summary>
        public override string GetQuery(QueryInfo query)
        {
            if (query.Equals (last_query, QueryField.Artist, QueryField.Album))
                return null;

            string url = "http://ws.audioscrobbler.com/1.0/album/{0}/{1}/info.xml";
            return ParseQuery (url, query.Artist, query.Album);
        }

        /// <summary>
        /// The query to execute.
        /// </summary>
        public override string GetQuery(QueryInfo query)
        {
            if (query.Equals (last_query, QueryField.Artist))
                return null;

            string url = "http://ws.audioscrobbler.com/1.0/artist/{0}/toptracks.xml";
            return ParseQuery (url, query.Artist);
        }

 public static CustomBigType GetModel(QueryInfo queryInfo)
 {
     List<CustomBigType> list = GetList(queryInfo);
     if (list == null || list.Count == 0)
         return null;
     else
         return list[0];
 }

        /// <inheritdoc />
        protected override QueryItemInfo GetQueryForGroups(QueryInfo query, InstanceVersion version)
        {
            if (query.GroupSelect != null && query.GroupSelect.Count > 0)
            {
                return query.GroupSelect.GetQueryItemForVersion(version);
            }

            return query.DatabaseSelect.GetQueryItemForVersion(version);
        }

		/// <summary>
		/// The get groups.
		/// </summary>
		/// <param name="query">
		/// The query information.
		/// </param>
		/// <param name="parameterValues">
		/// The parameter values.
		/// </param>
		/// <param name="version">
		/// The version.
		/// </param>
		/// <returns>
		/// The <see cref="Dictionary{TKey,TValue}"/>.
		/// </returns>
		public virtual ICollection<GroupDefinition> GetGroups(
			QueryInfo                   query,
			IEnumerable<ParameterValue> parameterValues,
			InstanceVersion             version
		)
		{
			var groups = new List<GroupDefinition>();

			// TODO: Create GroupDefinition with childrens
			QueryItemInfo selectGroupsSql = this.GetQueryForGroups(query, version);

			if (selectGroupsSql != null)
			{
				try
				{
					var paramsArray = parameterValues as ParameterValue[] ?? parameterValues.ToArray();

					DataTable[] groupsTabels = this.ExecuteSqlFunction(
						this.Instance,
						selectGroupsSql,
						null,
						query.Parameters,
						paramsArray,
						null,
						true
					);

					foreach (DataTable groupTable in groupsTabels)
					{
						this.AddGroupsFromTable(groupTable, groups);
					}

					if (selectGroupsSql.ChildGroups.IsNullOrEmpty())
					{
						return groups;
					}

					foreach (GroupDefinition groupDefinition in groups)
					{
						this.GetChildGroupsDefinitions(selectGroupsSql, groupDefinition, paramsArray, version);
					}
				}
				catch (OperationCanceledException ex)
				{
					log.Error(ex);
					throw;
				}
				catch (Exception ex)
				{
					log.Error("instance=" + this.Instance.Name + " query=" + query, ex);
				}
			}

			return groups;
		}

        public void ExecuteQueryTest()
        {
            SetupTestDbFb2();
            var inf = new QueryInfo();
            inf.ExecuteQuery(GetFb2ConnectionString(), "select * from test").ToList()[0].View.Rows.Count.Is(0);

            var result = inf.ExecuteQuery(GetFb2ConnectionString(), "insert into test(int_test, char_test) values (1, 'aaaaaaaaaa');update test set varchar_test = 'testtesttesttest' where int_test = 1;select * from test").ToList();
            result[0].View.Rows[0].Is(x => ((string)x[0]).Contains("実行しました。"));
            result[1].View.Rows[0].Is(x => ((string)x[0]).Contains("更新しました。"));
            result[2].View.Rows.Count.Is(1);
        }

        public void ExecuteQueryTestFb3()
        {
            SetupTestDbFb3();
            var inf = new QueryInfo();
            var conStr = GetFb3ConnectionString();
            inf.ExecuteQuery(conStr, "select * from test").ToList()[0].View.Rows.Count.Is(0);

            var result = inf.ExecuteQuery(conStr, "insert into test values (1, 123456789000, null, '12asd', '2016-07-24', 50000, 2.5, 2.5555, 4500, 10, '10:00:00', current_timestamp, 'asdfghjk', true);update test set varchar_test = 'testtesttesttest' where int_test = 1;select * from test").ToList();
            result[0].View.Rows[0].Is(x => ((string)x[0]).Contains("実行しました。"));
            result[1].View.Rows[0].Is(x => ((string)x[0]).Contains("更新しました。"));
            result[2].View.Rows.Count.Is(1);
        }

 /// <inheritdoc />
 public override ICollection<GroupDefinition> GetGroups(QueryInfo query, IEnumerable<ParameterValue> values, InstanceVersion i)
 {
     return new List<GroupDefinition>()
                {
                    new GroupDefinition(this.Instance, string.Empty, string.Empty)
                        {
                            GroupType
                                =
                                QueryScope
                                .Instance
                        }
                };
 }

        /// <summary>
        /// Load the top tracks.
        /// </summary>
        public override void Load(XmlDocument doc, QueryInfo query)
        {
            last_query = query;
            top_tracks.Clear ();

            XmlNodeList list = doc.GetElementsByTagName ("mostknowntracks");
            if (list.Count == 0)
                return;

            foreach (XmlNode node in list[0].ChildNodes)
                if (node.LocalName == "track")
                    top_tracks.Add (new TopTrack (node.ChildNodes));

            page_navigator.UpdatePageNumber ();
            ShowPage ();
        }

        /// <summary>
        /// Load the artist list.
        /// </summary>
        public override void Load(XmlDocument doc, QueryInfo query)
        {
            last_query = query;
            list.Clear ();

            XmlNodeList node_list = doc.GetElementsByTagName ("topartists");
            if (node_list.Count == 0)
                return;

            foreach (XmlNode node in node_list[0].ChildNodes)
                if (node.LocalName == "artist")
                    list.Add (new TopArtist (node));

            page_navigator.UpdatePageNumber ();
            ShowPage ();
        }

 protected void Page_Load(object sender, EventArgs e)
 {
     string searchWords = Request.QueryString["SearchWords"];
     string indexNames = Request.QueryString["IndexNames"];
     //Response.Write(searchWords);
     string hostname = ConfigurationManager.AppSettings["HostName"];
     int port = int.Parse(ConfigurationManager.AppSettings["PortNum"]);
     TcpClient client;
     NetworkStream ns;
     BinaryFormatter formater;
     DateTime now = DateTime.Now;
     try
     {
         client = new TcpClient(hostname, port);
         ns = client.GetStream();
         formater = new BinaryFormatter();
         SearchInfo sinfo = new SearchInfo();
         QueryInfo info = new QueryInfo();
         info.IndexNames = "";
         info.SearchWords = searchWords;
         info.IndexNames = indexNames;
         sinfo.Query = info;
         sinfo.PageSize = 10;
         formater.Serialize(ns, sinfo);
         SearchResult sr = (SearchResult)formater.Deserialize(ns);
         //WriteLog(Server.MapPath(".") + "searchutils.log", searchWords, indexNames, sr.Records.Count, sr);
         XmlSerializer xmlSerializer = new XmlSerializer(typeof(SearchResult));
         StringBuilder builder = new StringBuilder();
         StringWriter writer = new StringWriter(builder);
         xmlSerializer.Serialize(writer, sr);
         XmlDocument doc = new XmlDocument();
         doc.LoadXml(builder.ToString());
         writer.Close();
         ns.Close();
         Response.Write(doc.DocumentElement.OuterXml);
         //FileStream fs = new FileStream(@"result.xml", FileMode.Truncate);
         //xmlSerializer.Serialize(writer, fs);
         //fs.Close();
     }
     catch (Exception se)
     {
         Response.Write(se.StackTrace.ToString());
         return;
     }
 }

        public void GetStatementTest2()
        {
            var inf = new QueryInfo();
            var input1 =
            @"--comment1
            create trigger set_foo_primary for foo
            before insert
            as begin
            new.a = gen_id(gen_foo, 1);
            end;

            --comment2
            select *
            from test
            where a = 1;

            --comment3
            create trigger set_foo_primary for foo2
            before insert
            as begin
            new.a = gen_id(gen_foo, 1);
            end;

            select * from fuga where hoho = 'eeee'
            --comment4";

            (inf.AsDynamic().GetStatement(input1) as string[]).IsStructuralEqual(new[] {
            @"create trigger set_foo_primary for foo
            before insert
            as begin
            new.a = gen_id(gen_foo, 1);
            end",
            @"select *
            from test
            where a = 1",
            @"create trigger set_foo_primary for foo2
            before insert
            as begin
            new.a = gen_id(gen_foo, 1);
            end",
            @"select * from fuga where hoho = 'eeee'"
            });
        }