Презентация

Кафедра Информатики и Математического Обеспечения

Начало

Введение

XML и реляционные базы данных

Постановка задачи

Структуры для хранения данных

Реализация алгоритма

Примеры тестирования программы

Заключение

Материалы

Примеры тестирования программы

Для тестированния был написан php-скрипт, исходный текст которого можно посмотреть тут.

Результат выполнения:

Converter XML&SQL
Version: 1.0
Конвертирование базы данных в XML: convert_db_to_xml($host, $username, $password, $database)

<xml>
  <ttt>
  
    <table1>
      <param1>a</param1>
      <param2>a</param2>
      <param3>1</param3>
      <param4>1</param4>
      <param5>a</param5>
    </table1>
    <table1>
      <param1>b</param1>
      <param2>b</param2>
      <param3>2</param3>
      <param4>2</param4>
      <param5>b</param5>
    </table1>
    <table1>
      <param1>c</param1>
      <param2>c</param2>
      <param3>3</param3>
      <param4>3</param4>
      <param5>c</param5>
    </table1>
    <table1>
      <param1>d</param1>
      <param2>d</param2>
      <param3>3</param3>
      <param4>3</param4>
      <param5>d</param5>
    </table1>
  
    <table2>
      <param1>1</param1>
      <param2>a</param2>
    </table2>
    <table2>
      <param1>2</param1>
      <param2>b</param2>
    </table2>
    <table2>
      <param1>3</param1>
      <param2>c</param2>
    </table2>
  
    <test>
      <one>asda</one>
      <two>1.11</two>
      <three>1</three>
    </test>
    <test>
      <one>1231waefas</one>
      <two>11.78</two>
      <three>123</three>
    </test>
    <test>
      <one>sdsdds</one>
      <two>12.1</two>
      <three>12</three>
    </test>
  
    <test2>
      <a>ad</a>
      <b>sd</b>
    </test2>
    <test2>
      <a>df</a>
      <b>fg</b>
    </test2>
  </ttt>
</xml>

Конвертирование таблицы из базы данных в XML: convert_table_to_xml($host, $username, $password, $database, $table)

Конвертирование базы данных в SQL: convert_db_to_sql($host, $username, $password, $database)

--
-- База данных `ttt`
--

--
-- Дамп данных таблицы `table1`
--

INSERT INTO `ttt.table1` (`param1`, `param2`, `param3`, `param4`, `param5`) VALUES ('a', 'a', 1, 1, 'a');
INSERT INTO `ttt.table1` (`param1`, `param2`, `param3`, `param4`, `param5`) VALUES ('b', 'b', 2, 2, 'b');
INSERT INTO `ttt.table1` (`param1`, `param2`, `param3`, `param4`, `param5`) VALUES ('c', 'c', 3, 3, 'c');
INSERT INTO `ttt.table1` (`param1`, `param2`, `param3`, `param4`, `param5`) VALUES ('d', 'd', 3, 3, 'd');

--
-- Дамп данных таблицы `table2`
--

INSERT INTO `ttt.table2` (`param1`, `param2`) VALUES (1, 'a');
INSERT INTO `ttt.table2` (`param1`, `param2`) VALUES (2, 'b');
INSERT INTO `ttt.table2` (`param1`, `param2`) VALUES (3, 'c');

--
-- Дамп данных таблицы `test`
--

INSERT INTO `ttt.test` (`one`, `two`, `three`) VALUES ('asda', 1.11, 1);
INSERT INTO `ttt.test` (`one`, `two`, `three`) VALUES ('1231waefas', 11.78, 123);
INSERT INTO `ttt.test` (`one`, `two`, `three`) VALUES ('sdsdds', 12.1, 12);

--
-- Дамп данных таблицы `test2`
--

INSERT INTO `ttt.test2` (`a`, `b`) VALUES ('ad', 'sd');
INSERT INTO `ttt.test2` (`a`, `b`) VALUES ('df', 'fg');

Конвертирование таблицы из базы данных в SQL: convert_table_to_sql($host, $username, $password, $database, $table)

Вывод xml-массива: convert_xml_to_array($string)

Array
(
    [0] => xml2sql Object
        (
            [tag] => xml
            [value] =>
            [attributes] =>
            [next] => Array
                (
                    [0] => xml2sql Object
                        (
                            [tag] => ttt
                            [value] =>
                            [attributes] =>
                            [next] => Array
                                (
                                    [0] => xml2sql Object
                                        (
                                            [tag] => table1
                                            [value] =>
                                            [attributes] =>
                                            [next] => Array
                                                (
                                                    [0] => xml2sql Object
                                                        (
                                                            [tag] => param1
                                                            [value] => a
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[1] => xml2sql Object
                                                        (
                                                            [tag] => param2
                                                            [value] => a
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[2] => xml2sql Object
                                                        (
                                                            [tag] => param3
                                                            [value] => 1
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[3] => xml2sql Object
                                                        (
                                                            [tag] => param4
                                                            [value] => 1
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[4] => xml2sql Object
                                                        (
                                                            [tag] => param5
                                                            [value] => a
                                                            [attributes] =>
                                                            [next] =>
                                                        )

)

[1] => xml2sql Object
                                        (
                                            [tag] => table1
                                            [value] =>
                                            [attributes] =>
                                            [next] => Array
                                                (
                                                    [0] => xml2sql Object
                                                        (
                                                            [tag] => param1
                                                            [value] => b
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[1] => xml2sql Object
                                                        (
                                                            [tag] => param2
                                                            [value] => b
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[2] => xml2sql Object
                                                        (
                                                            [tag] => param3
                                                            [value] => 2
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[3] => xml2sql Object
                                                        (
                                                            [tag] => param4
                                                            [value] => 2
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[4] => xml2sql Object
                                                        (
                                                            [tag] => param5
                                                            [value] => b
                                                            [attributes] =>
                                                            [next] =>
                                                        )

)

[2] => xml2sql Object
                                        (
                                            [tag] => table1
                                            [value] =>
                                            [attributes] =>
                                            [next] => Array
                                                (
                                                    [0] => xml2sql Object
                                                        (
                                                            [tag] => param1
                                                            [value] => c
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[1] => xml2sql Object
                                                        (
                                                            [tag] => param2
                                                            [value] => c
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[2] => xml2sql Object
                                                        (
                                                            [tag] => param3
                                                            [value] => 3
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[3] => xml2sql Object
                                                        (
                                                            [tag] => param4
                                                            [value] => 3
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[4] => xml2sql Object
                                                        (
                                                            [tag] => param5
                                                            [value] => c
                                                            [attributes] =>
                                                            [next] =>
                                                        )

)

[3] => xml2sql Object
                                        (
                                            [tag] => table1
                                            [value] =>
                                            [attributes] =>
                                            [next] => Array
                                                (
                                                    [0] => xml2sql Object
                                                        (
                                                            [tag] => param1
                                                            [value] => d
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[1] => xml2sql Object
                                                        (
                                                            [tag] => param2
                                                            [value] => d
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[4] => xml2sql Object
                                                        (
                                                            [tag] => param5
                                                            [value] => d
                                                            [attributes] =>
                                                            [next] =>
                                                        )

)

[4] => xml2sql Object
                                        (
                                            [tag] => table2
                                            [value] =>
                                            [attributes] =>
                                            [next] => Array
                                                (
                                                    [0] => xml2sql Object
                                                        (
                                                            [tag] => param1
                                                            [value] => 1
                                                            [attributes] =>
                                                            [next] =>
                                                        )

)

[5] => xml2sql Object
                                        (
                                            [tag] => table2
                                            [value] =>
                                            [attributes] =>
                                            [next] => Array
                                                (
                                                    [0] => xml2sql Object
                                                        (
                                                            [tag] => param1
                                                            [value] => 2
                                                            [attributes] =>
                                                            [next] =>
                                                        )

)

[6] => xml2sql Object
                                        (
                                            [tag] => table2
                                            [value] =>
                                            [attributes] =>
                                            [next] => Array
                                                (
                                                    [0] => xml2sql Object
                                                        (
                                                            [tag] => param1
                                                            [value] => 3
                                                            [attributes] =>
                                                            [next] =>
                                                        )

)

[7] => xml2sql Object
                                        (
                                            [tag] => test
                                            [value] =>
                                            [attributes] =>
                                            [next] => Array
                                                (
                                                    [0] => xml2sql Object
                                                        (
                                                            [tag] => one
                                                            [value] => asda
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[1] => xml2sql Object
                                                        (
                                                            [tag] => two
                                                            [value] => 1.11
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[2] => xml2sql Object
                                                        (
                                                            [tag] => three
                                                            [value] => 1
                                                            [attributes] =>
                                                            [next] =>
                                                        )

)

[8] => xml2sql Object
                                        (
                                            [tag] => test
                                            [value] =>
                                            [attributes] =>
                                            [next] => Array
                                                (
                                                    [0] => xml2sql Object
                                                        (
                                                            [tag] => one
                                                            [value] => 1231waefas
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[1] => xml2sql Object
                                                        (
                                                            [tag] => two
                                                            [value] => 11.78
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[2] => xml2sql Object
                                                        (
                                                            [tag] => three
                                                            [value] => 123
                                                            [attributes] =>
                                                            [next] =>
                                                        )

)

[9] => xml2sql Object
                                        (
                                            [tag] => test
                                            [value] =>
                                            [attributes] =>
                                            [next] => Array
                                                (
                                                    [0] => xml2sql Object
                                                        (
                                                            [tag] => one
                                                            [value] => sdsdds
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[1] => xml2sql Object
                                                        (
                                                            [tag] => two
                                                            [value] => 12.1
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[2] => xml2sql Object
                                                        (
                                                            [tag] => three
                                                            [value] => 12
                                                            [attributes] =>
                                                            [next] =>
                                                        )

)

[10] => xml2sql Object
                                        (
                                            [tag] => test2
                                            [value] =>
                                            [attributes] =>
                                            [next] => Array
                                                (
                                                    [0] => xml2sql Object
                                                        (
                                                            [tag] => a
                                                            [value] => ad
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[1] => xml2sql Object
                                                        (
                                                            [tag] => b
                                                            [value] => sd
                                                            [attributes] =>
                                                            [next] =>
                                                        )

)

[11] => xml2sql Object
                                        (
                                            [tag] => test2
                                            [value] =>
                                            [attributes] =>
                                            [next] => Array
                                                (
                                                    [0] => xml2sql Object
                                                        (
                                                            [tag] => a
                                                            [value] => df
                                                            [attributes] =>
                                                            [next] =>
                                                        )

[1] => xml2sql Object
                                                        (
                                                            [tag] => b
                                                            [value] => fg
                                                            [attributes] =>
                                                            [next] =>
                                                        )

)

Конвертирование структуры в SQL: convert_array_to_sql($array)

--
-- База данных `ttt`
--

--
-- Дамп данных таблицы `table1`
--

INSERT INTO `ttt.table1' (`param1`, `param2`, `param3`, `param4`, `param5`) VALUES (`a`, `a`, 1, 1, `a`);
INSERT INTO `ttt.table1' (`param1`, `param2`, `param3`, `param4`, `param5`) VALUES (`b`, `b`, 2, 2, `b`);
INSERT INTO `ttt.table1' (`param1`, `param2`, `param3`, `param4`, `param5`) VALUES (`c`, `c`, 3, 3, `c`);
INSERT INTO `ttt.table1' (`param1`, `param2`, `param3`, `param4`, `param5`) VALUES (`d`, `d`, 3, 3, `d`);

--
-- Дамп данных таблицы `table2`
--

INSERT INTO `ttt.table2' (`param1`, `param2`) VALUES (1, `a`);
INSERT INTO `ttt.table2' (`param1`, `param2`) VALUES (2, `b`);
INSERT INTO `ttt.table2' (`param1`, `param2`) VALUES (3, `c`);

--
-- Дамп данных таблицы `test`
--

INSERT INTO `ttt.test' (`one`, `two`, `three`) VALUES (`asda`, 1.11, 1);
INSERT INTO `ttt.test' (`one`, `two`, `three`) VALUES (`1231waefas`, 11.78, 123);
INSERT INTO `ttt.test' (`one`, `two`, `three`) VALUES (`sdsdds`, 12.1, 12);

--
-- Дамп данных таблицы `test2`
--

INSERT INTO `ttt.test2' (`a`, `b`) VALUES (`ad`, `sd`);
INSERT INTO `ttt.test2' (`a`, `b`) VALUES (`df`, `fg`);

Перевод XML в SQL: convert_xml_to_sql($string)

--
-- База данных `ttt`
--

--
-- Дамп данных таблицы `table1`
--

--
-- Дамп данных таблицы `table2`
--

INSERT INTO `ttt.table2' (`param1`, `param2`) VALUES (1, `a`);
INSERT INTO `ttt.table2' (`param1`, `param2`) VALUES (2, `b`);
INSERT INTO `ttt.table2' (`param1`, `param2`) VALUES (3, `c`);

--
-- Дамп данных таблицы `test`
--

--
-- Дамп данных таблицы `test2`
--

INSERT INTO `ttt.test2' (`a`, `b`) VALUES (`ad`, `sd`);
INSERT INTO `ttt.test2' (`a`, `b`) VALUES (`df`, `fg`);

Петрозаводск – 2006