Exemplo n.º 1
0
        private void Form1_Load(object sender, EventArgs e)
        {
            /*
            WebClient webClient = new WebClient();
            webClient.DownloadFile("http://api.netflix.com/catalog/titles/full?v=2.0?oauth_consumer_key=vwhxtj7gjyze6mvddb28znjd&oauth_nonce=FlucT&oauth_signature=lujB0gjGYHdm2DCDQQ%2FYxCzjvR8%3D&oauth_signature_method=HMAC-SHA1&oauth_timestamp=1328651121&oauth_version=1.0&output=xml", @"c:\netflix2.xml");
             */

            var conn = new MySqlConnectionInfo("localhost", "root", "Password01", "Netflix");

               // int countdown = 250;

            using (_sql = new MySqlConnection(conn.ConnectionString))
            {
                _sql.Open();

                MySqlTransaction transaction = _sql.BeginTransaction();

                _sql.NewCommandEx("DELETE FROM Title"       ).ExecuteNonQuery();
                _sql.NewCommandEx("DELETE FROM Category"    ).ExecuteNonQuery();
                _sql.NewCommandEx("DELETE FROM Link"        ).ExecuteNonQuery();
                _sql.NewCommandEx("DELETE FROM External"    ).ExecuteNonQuery();
                _sql.NewCommandEx("DELETE FROM Availability").ExecuteNonQuery();

                var textReader = new XmlTextReader("C:\\netflix.xml");

                // Read until end of file
                while (textReader.Read())
                {
                    XmlNodeType nType = textReader.NodeType;

                    // if node type is an element
                    if (nType == XmlNodeType.Element)
                    {
                        if (textReader.Name == "title_index_item")
                        {
                            ParseTitleIndexItem(textReader);
                            //countdown--;

                            //if (countdown == 0)
                             //   break;
                        }
                    }
                }

                transaction.Commit();
            }

            return;
        }