ignite-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From akuznet...@apache.org
Subject [1/3] incubator-ignite git commit: # IGNITE-330 WIP Demo.
Date Fri, 20 Mar 2015 10:50:29 GMT
Repository: incubator-ignite
Updated Branches:
  refs/heads/ignite-45 6fa2e992d -> 73ba6d66a


# IGNITE-330 WIP Demo.


Project: http://git-wip-us.apache.org/repos/asf/incubator-ignite/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-ignite/commit/f2c3c2b5
Tree: http://git-wip-us.apache.org/repos/asf/incubator-ignite/tree/f2c3c2b5
Diff: http://git-wip-us.apache.org/repos/asf/incubator-ignite/diff/f2c3c2b5

Branch: refs/heads/ignite-45
Commit: f2c3c2b5915e90809e7f9e91494b43ad50da9bde
Parents: 747b4b8
Author: AKuznetsov <akuznetsov@gridgain.com>
Authored: Fri Mar 20 10:53:04 2015 +0700
Committer: AKuznetsov <akuznetsov@gridgain.com>
Committed: Fri Mar 20 10:53:04 2015 +0700

----------------------------------------------------------------------
 examples/schema-import/db-demo-script.bat | 99 ++++++++++++++++++++++++++
 examples/schema-import/db-demo-server.bat | 97 +++++++++++++++++++++++++
 examples/schema-import/db-demo-wizard.bat | 89 +++++++++++++++++++++++
 examples/schema-import/db-demo.bat        | 93 ++++++++++++++++++++++++
 examples/schema-import/demo.sql           | 10 +++
 5 files changed, 388 insertions(+)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-ignite/blob/f2c3c2b5/examples/schema-import/db-demo-script.bat
----------------------------------------------------------------------
diff --git a/examples/schema-import/db-demo-script.bat b/examples/schema-import/db-demo-script.bat
new file mode 100644
index 0000000..7a87a74
--- /dev/null
+++ b/examples/schema-import/db-demo-script.bat
@@ -0,0 +1,99 @@
+::
+:: Licensed to the Apache Software Foundation (ASF) under one or more
+:: contributor license agreements.  See the NOTICE file distributed with
+:: this work for additional information regarding copyright ownership.
+:: The ASF licenses this file to You under the Apache License, Version 2.0
+:: (the "License"); you may not use this file except in compliance with
+:: the License.  You may obtain a copy of the License at
+::
+::      http://www.apache.org/licenses/LICENSE-2.0
+::
+:: Unless required by applicable law or agreed to in writing, software
+:: distributed under the License is distributed on an "AS IS" BASIS,
+:: WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+:: See the License for the specific language governing permissions and
+:: limitations under the License.
+::
+
+::
+:: Starts H2 database for Ignite Schema Import demo.
+::
+
+@echo off
+
+if "%OS%" == "Windows_NT"  setlocal
+
+:: Check JAVA_HOME.
+if not "%JAVA_HOME%" == "" goto checkJdk
+    echo %0, ERROR: JAVA_HOME environment variable is not found.
+    echo %0, ERROR: Please create JAVA_HOME variable pointing to location of JDK 1.7 or JDK
1.8.
+    echo %0, ERROR: You can also download latest JDK at: http://java.sun.com/getjava
+goto error_finish
+
+:checkJdk
+:: Check that JDK is where it should be.
+if exist "%JAVA_HOME%\bin\java.exe" goto checkJdkVersion
+    echo %0, ERROR: The JDK is not found in %JAVA_HOME%.
+    echo %0, ERROR: Please modify your script so that JAVA_HOME would point to valid location
of JDK.
+goto error_finish
+
+:checkJdkVersion
+"%JAVA_HOME%\bin\java.exe" -version 2>&1 | findstr "1\.[78]\." > nul
+if %ERRORLEVEL% equ 0 goto checkIgniteHome1
+    echo %0, ERROR: The version of JAVA installed in %JAVA_HOME% is incorrect.
+    echo %0, ERROR: Please install JDK 1.7 or 1.8.
+    echo %0, ERROR: You can also download latest JDK at: http://java.sun.com/getjava
+goto error_finish
+
+:: Check IGNITE_HOME.
+:checkIgniteHome1
+if not "%IGNITE_HOME%" == "" goto checkIgniteHome2
+    pushd "%~dp0"/../..
+    set IGNITE_HOME=%CD%
+    popd
+
+:checkIgniteHome2
+:: Strip double quotes from IGNITE_HOME
+set IGNITE_HOME=%IGNITE_HOME:"=%
+
+:: remove all trailing slashes from IGNITE_HOME.
+if %IGNITE_HOME:~-1,1% == \ goto removeTrailingSlash
+if %IGNITE_HOME:~-1,1% == / goto removeTrailingSlash
+goto checkIgniteHome3
+
+:removeTrailingSlash
+set IGNITE_HOME=%IGNITE_HOME:~0,-1%
+goto checkIgniteHome2
+
+:checkIgniteHome3
+if exist "%IGNITE_HOME%\config" goto checkIgniteHome4
+    echo %0, ERROR: Ignite installation folder is not found or IGNITE_HOME environment variable
is not valid.
+    echo Please create IGNITE_HOME environment variable pointing to location of
+    echo Ignite installation folder.
+    goto error_finish
+
+:checkIgniteHome4
+
+::
+:: Set SCRIPTS_HOME - base path to scripts.
+::
+set SCRIPTS_HOME=%IGNITE_HOME%\bin
+
+:: Remove trailing spaces
+for /l %%a in (1,1,31) do if /i "%SCRIPTS_HOME:~-1%" == " " set SCRIPTS_HOME=%SCRIPTS_HOME:~0,-1%
+
+:run
+
+::
+:: Set IGNITE_LIBS
+::
+call "%SCRIPTS_HOME%\include\setenv.bat"
+
+::
+:: Starts Visor console.
+::
+"%JAVA_HOME%\bin\java.exe" -cp "%IGNITE_LIBS%" org.h2.tools.RunScript -url jdbc:h2:tcp://localhost/demo
-script demo.sql
+
+:error_finish
+
+exit
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ignite/blob/f2c3c2b5/examples/schema-import/db-demo-server.bat
----------------------------------------------------------------------
diff --git a/examples/schema-import/db-demo-server.bat b/examples/schema-import/db-demo-server.bat
new file mode 100644
index 0000000..1f206d6
--- /dev/null
+++ b/examples/schema-import/db-demo-server.bat
@@ -0,0 +1,97 @@
+::
+:: Licensed to the Apache Software Foundation (ASF) under one or more
+:: contributor license agreements.  See the NOTICE file distributed with
+:: this work for additional information regarding copyright ownership.
+:: The ASF licenses this file to You under the Apache License, Version 2.0
+:: (the "License"); you may not use this file except in compliance with
+:: the License.  You may obtain a copy of the License at
+::
+::      http://www.apache.org/licenses/LICENSE-2.0
+::
+:: Unless required by applicable law or agreed to in writing, software
+:: distributed under the License is distributed on an "AS IS" BASIS,
+:: WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+:: See the License for the specific language governing permissions and
+:: limitations under the License.
+::
+
+::
+:: Starts H2 database for Ignite Schema Import demo.
+::
+
+@echo off
+
+if "%OS%" == "Windows_NT"  setlocal
+
+:: Check JAVA_HOME.
+if not "%JAVA_HOME%" == "" goto checkJdk
+    echo %0, ERROR: JAVA_HOME environment variable is not found.
+    echo %0, ERROR: Please create JAVA_HOME variable pointing to location of JDK 1.7 or JDK
1.8.
+    echo %0, ERROR: You can also download latest JDK at: http://java.sun.com/getjava
+goto error_finish
+
+:checkJdk
+:: Check that JDK is where it should be.
+if exist "%JAVA_HOME%\bin\java.exe" goto checkJdkVersion
+    echo %0, ERROR: The JDK is not found in %JAVA_HOME%.
+    echo %0, ERROR: Please modify your script so that JAVA_HOME would point to valid location
of JDK.
+goto error_finish
+
+:checkJdkVersion
+"%JAVA_HOME%\bin\java.exe" -version 2>&1 | findstr "1\.[78]\." > nul
+if %ERRORLEVEL% equ 0 goto checkIgniteHome1
+    echo %0, ERROR: The version of JAVA installed in %JAVA_HOME% is incorrect.
+    echo %0, ERROR: Please install JDK 1.7 or 1.8.
+    echo %0, ERROR: You can also download latest JDK at: http://java.sun.com/getjava
+goto error_finish
+
+:: Check IGNITE_HOME.
+:checkIgniteHome1
+if not "%IGNITE_HOME%" == "" goto checkIgniteHome2
+    pushd "%~dp0"/../..
+    set IGNITE_HOME=%CD%
+    popd
+
+:checkIgniteHome2
+:: Strip double quotes from IGNITE_HOME
+set IGNITE_HOME=%IGNITE_HOME:"=%
+
+:: remove all trailing slashes from IGNITE_HOME.
+if %IGNITE_HOME:~-1,1% == \ goto removeTrailingSlash
+if %IGNITE_HOME:~-1,1% == / goto removeTrailingSlash
+goto checkIgniteHome3
+
+:removeTrailingSlash
+set IGNITE_HOME=%IGNITE_HOME:~0,-1%
+goto checkIgniteHome2
+
+:checkIgniteHome3
+if exist "%IGNITE_HOME%\config" goto checkIgniteHome4
+    echo %0, ERROR: Ignite installation folder is not found or IGNITE_HOME environment variable
is not valid.
+    echo Please create IGNITE_HOME environment variable pointing to location of
+    echo Ignite installation folder.
+    goto error_finish
+
+:checkIgniteHome4
+
+::
+:: Set SCRIPTS_HOME - base path to scripts.
+::
+set SCRIPTS_HOME=%IGNITE_HOME%\bin
+
+:: Remove trailing spaces
+for /l %%a in (1,1,31) do if /i "%SCRIPTS_HOME:~-1%" == " " set SCRIPTS_HOME=%SCRIPTS_HOME:~0,-1%
+
+:run
+
+::
+:: Set IGNITE_LIBS
+::
+call "%SCRIPTS_HOME%\include\setenv.bat"
+
+::
+:: Starts Visor console.
+::
+"%JAVA_HOME%\bin\java.exe" -cp "%IGNITE_LIBS%" org.h2.tools.Server -tcp -baseDir "%IGNITE_HOME%\examples\schema-import"
+
+:error_finish
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ignite/blob/f2c3c2b5/examples/schema-import/db-demo-wizard.bat
----------------------------------------------------------------------
diff --git a/examples/schema-import/db-demo-wizard.bat b/examples/schema-import/db-demo-wizard.bat
new file mode 100644
index 0000000..ef3f327
--- /dev/null
+++ b/examples/schema-import/db-demo-wizard.bat
@@ -0,0 +1,89 @@
+::
+:: Licensed to the Apache Software Foundation (ASF) under one or more
+:: contributor license agreements.  See the NOTICE file distributed with
+:: this work for additional information regarding copyright ownership.
+:: The ASF licenses this file to You under the Apache License, Version 2.0
+:: (the "License"); you may not use this file except in compliance with
+:: the License.  You may obtain a copy of the License at
+::
+::      http://www.apache.org/licenses/LICENSE-2.0
+::
+:: Unless required by applicable law or agreed to in writing, software
+:: distributed under the License is distributed on an "AS IS" BASIS,
+:: WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+:: See the License for the specific language governing permissions and
+:: limitations under the License.
+::
+
+::
+:: Starts Ignite Schema Import demo.
+::
+
+@echo off
+
+if "%OS%" == "Windows_NT"  setlocal
+
+:: Check JAVA_HOME.
+if not "%JAVA_HOME%" == "" goto checkJdk
+    echo %0, ERROR: JAVA_HOME environment variable is not found.
+    echo %0, ERROR: Please create JAVA_HOME variable pointing to location of JDK 1.7 or JDK
1.8.
+    echo %0, ERROR: You can also download latest JDK at: http://java.sun.com/getjava
+goto error_finish
+
+:checkJdk
+:: Check that JDK is where it should be.
+if exist "%JAVA_HOME%\bin\java.exe" goto checkJdkVersion
+    echo %0, ERROR: The JDK is not found in %JAVA_HOME%.
+    echo %0, ERROR: Please modify your script so that JAVA_HOME would point to valid location
of JDK.
+goto error_finish
+
+:checkJdkVersion
+"%JAVA_HOME%\bin\java.exe" -version 2>&1 | findstr "1\.[78]\." > nul
+if %ERRORLEVEL% equ 0 goto checkIgniteHome1
+    echo %0, ERROR: The version of JAVA installed in %JAVA_HOME% is incorrect.
+    echo %0, ERROR: Please install JDK 1.7 or 1.8.
+    echo %0, ERROR: You can also download latest JDK at: http://java.sun.com/getjava
+goto error_finish
+
+:: Check IGNITE_HOME.
+:checkIgniteHome1
+if not "%IGNITE_HOME%" == "" goto checkIgniteHome2
+    pushd "%~dp0"/../..
+    set IGNITE_HOME=%CD%
+    popd
+
+:checkIgniteHome2
+:: Strip double quotes from IGNITE_HOME
+set IGNITE_HOME=%IGNITE_HOME:"=%
+
+:: remove all trailing slashes from IGNITE_HOME.
+if %IGNITE_HOME:~-1,1% == \ goto removeTrailingSlash
+if %IGNITE_HOME:~-1,1% == / goto removeTrailingSlash
+goto checkIgniteHome3
+
+:removeTrailingSlash
+set IGNITE_HOME=%IGNITE_HOME:~0,-1%
+goto checkIgniteHome2
+
+:checkIgniteHome3
+if exist "%IGNITE_HOME%\config" goto run
+    echo %0, ERROR: Ignite installation folder is not found or IGNITE_HOME environment variable
is not valid.
+    echo Please create IGNITE_HOME environment variable pointing to location of
+    echo Ignite installation folder.
+    goto error_finish
+
+:run
+
+"%IGNITE_HOME%\bin\ignite-schema-import.bat" ^
+ jdbc.db.preset=0 ^
+ jdbc.driver.jar="%IGNITE_HOME%\libs\ignite-indexing\h2-1.3.175.jar" ^
+ jdbc.driver.class=org.h2.Driver ^
+ jdbc.url="jdbc:h2:tcp://localhost/%IGNITE_HOME%\examples\schema-import\demo" ^
+ jdbc.user=sa ^
+ outFolder="%IGNITE_HOME%\examples\src\main\java" ^
+ pojo.package="org.apache.ignite.schema-import.demo" ^
+ pojo.constructor=true
+
+:error_finish
+
+exit
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ignite/blob/f2c3c2b5/examples/schema-import/db-demo.bat
----------------------------------------------------------------------
diff --git a/examples/schema-import/db-demo.bat b/examples/schema-import/db-demo.bat
new file mode 100644
index 0000000..8aac263
--- /dev/null
+++ b/examples/schema-import/db-demo.bat
@@ -0,0 +1,93 @@
+::
+:: Licensed to the Apache Software Foundation (ASF) under one or more
+:: contributor license agreements.  See the NOTICE file distributed with
+:: this work for additional information regarding copyright ownership.
+:: The ASF licenses this file to You under the Apache License, Version 2.0
+:: (the "License"); you may not use this file except in compliance with
+:: the License.  You may obtain a copy of the License at
+::
+::      http://www.apache.org/licenses/LICENSE-2.0
+::
+:: Unless required by applicable law or agreed to in writing, software
+:: distributed under the License is distributed on an "AS IS" BASIS,
+:: WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+:: See the License for the specific language governing permissions and
+:: limitations under the License.
+::
+
+::
+:: Starts Ignite Schema Import demo.
+::
+
+@echo off
+
+if "%OS%" == "Windows_NT"  setlocal
+
+:: Check JAVA_HOME.
+if not "%JAVA_HOME%" == "" goto checkJdk
+    echo %0, ERROR: JAVA_HOME environment variable is not found.
+    echo %0, ERROR: Please create JAVA_HOME variable pointing to location of JDK 1.7 or JDK
1.8.
+    echo %0, ERROR: You can also download latest JDK at: http://java.sun.com/getjava
+goto error_finish
+
+:checkJdk
+:: Check that JDK is where it should be.
+if exist "%JAVA_HOME%\bin\java.exe" goto checkJdkVersion
+    echo %0, ERROR: The JDK is not found in %JAVA_HOME%.
+    echo %0, ERROR: Please modify your script so that JAVA_HOME would point to valid location
of JDK.
+goto error_finish
+
+:checkJdkVersion
+"%JAVA_HOME%\bin\java.exe" -version 2>&1 | findstr "1\.[78]\." > nul
+if %ERRORLEVEL% equ 0 goto checkIgniteHome1
+    echo %0, ERROR: The version of JAVA installed in %JAVA_HOME% is incorrect.
+    echo %0, ERROR: Please install JDK 1.7 or 1.8.
+    echo %0, ERROR: You can also download latest JDK at: http://java.sun.com/getjava
+goto error_finish
+
+:: Check IGNITE_HOME.
+:checkIgniteHome1
+if not "%IGNITE_HOME%" == "" goto checkIgniteHome2
+    pushd "%~dp0"/../..
+    set IGNITE_HOME=%CD%
+    popd
+
+:checkIgniteHome2
+:: Strip double quotes from IGNITE_HOME
+set IGNITE_HOME=%IGNITE_HOME:"=%
+
+:: remove all trailing slashes from IGNITE_HOME.
+if %IGNITE_HOME:~-1,1% == \ goto removeTrailingSlash
+if %IGNITE_HOME:~-1,1% == / goto removeTrailingSlash
+goto checkIgniteHome3
+
+:removeTrailingSlash
+set IGNITE_HOME=%IGNITE_HOME:~0,-1%
+goto checkIgniteHome2
+
+:checkIgniteHome3
+if exist "%IGNITE_HOME%\config" goto run
+    echo %0, ERROR: Ignite installation folder is not found or IGNITE_HOME environment variable
is not valid.
+    echo Please create IGNITE_HOME environment variable pointing to location of
+    echo Ignite installation folder.
+    goto error_finish
+
+:run
+
+@echo on
+
+:: Start server.
+start "%IGNITE_HOME%\examples\schema-import\db-demo-server.bat"
+
+:: Wait for server start.
+ping 127.0.0.1 -n 3 -w 3000 > NUL
+
+:: Populate db with sample tables and data.
+start "%IGNITE_HOME%\examples\schema-import\db-demo-script.bat"
+
+:: Start Ignite Schema Import Wizard.
+start "%IGNITE_HOME%\examples\schema-import\db-demo-wizard.bat"
+
+:error_finish
+
+exit
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/incubator-ignite/blob/f2c3c2b5/examples/schema-import/demo.sql
----------------------------------------------------------------------
diff --git a/examples/schema-import/demo.sql b/examples/schema-import/demo.sql
new file mode 100644
index 0000000..bef0550
--- /dev/null
+++ b/examples/schema-import/demo.sql
@@ -0,0 +1,10 @@
+create table if not exists PERSON(id integer not null, first_name varchar(50), last_name
varchar(50), PRIMARY KEY(id));
+
+delete from PERSON;
+
+insert into PERSON(id, first_name, last_name) values(1, 'Johannes', 'Kepler');
+insert into PERSON(id, first_name, last_name) values(2, 'Galileo', 'Galilei');
+insert into PERSON(id, first_name, last_name) values(3, 'Henry', 'More');
+insert into PERSON(id, first_name, last_name) values(4, 'Polish', 'Brethren');
+insert into PERSON(id, first_name, last_name) values(5, 'Robert', 'Boyle');
+insert into PERSON(id, first_name, last_name) values(6, 'Isaac', 'Newton');
\ No newline at end of file


Mime
View raw message