From a2f34f6b460dd89168c1be5b18c40078164d8e53 Mon Sep 17 00:00:00 2001
From: vovasty <vovasty@aramzamzam.net>
Date: Wed, 18 Feb 2009 22:22:31 +0300
Subject: [PATCH] initial coords import

---
 rentdom-web/pom.xml                                | 111 +++++++++++----------
 .../ru/rentdom/services/tools/CoordsImport.java    |  32 ++++++
 .../rentdom/services/tools/CoordsImportTest.java   |  13 +++
 3 files changed, 103 insertions(+), 53 deletions(-)
 create mode 100644 rentdom-web/src/main/java/ru/rentdom/services/tools/CoordsImport.java
 create mode 100644 rentdom-web/src/test/ru/rentdom/services/tools/CoordsImportTest.java

diff --git a/rentdom-web/pom.xml b/rentdom-web/pom.xml
index bd8a4f4..4e90367 100644
--- a/rentdom-web/pom.xml
+++ b/rentdom-web/pom.xml
@@ -52,56 +52,61 @@
 			</exclusions>
 		</dependency>
 		<dependency>
-	      <groupId>org.apache.tapestry</groupId>
-	      <artifactId>tapestry-hibernate</artifactId>
-	      <version>${tapestry-release-version}</version>
+			<groupId>org.apache.tapestry</groupId>
+			<artifactId>tapestry-hibernate</artifactId>
+			<version>${tapestry-release-version}</version>
+			<exclusions>
+				<exclusion>
+					<groupId>org.hibernate</groupId>
+					<artifactId>hibernate-core</artifactId>
+				</exclusion>
+				<exclusion>
+					<groupId>org.hibernate</groupId>
+					<artifactId>hibernate-annotations</artifactId>
+				</exclusion>
+			</exclusions>
+		</dependency>
+		<dependency>
+			<groupId>postgresql</groupId>
+			<artifactId>postgresql</artifactId>
+			<version>8.3-603.jdbc4</version>
+		</dependency>
+		<dependency>
+			<groupId>org.hibernate</groupId>
+			<artifactId>hibernate-core</artifactId>
+			<version>${hibernate-core-release-version}</version>
+		</dependency>
+		<dependency>
+			<groupId>org.hibernate</groupId>
+			<artifactId>hibernate-annotations</artifactId>
+			<version>${hibernate-annontations-release-version}</version>
 			<exclusions>
-	            <exclusion>
-	              <groupId>org.hibernate</groupId>
-	              <artifactId>hibernate-core</artifactId>
-	            </exclusion>
-		        <exclusion>
-		          <groupId>org.hibernate</groupId>
-		  		  <artifactId>hibernate-annotations</artifactId>
-		        </exclusion>
-		  	</exclusions>
-	    </dependency>
-	    <dependency>
-		    <groupId>postgresql</groupId>
-		    <artifactId>postgresql</artifactId>
-		    <version>8.3-603.jdbc4</version>
-		</dependency> 
-    <dependency>
-      <groupId>org.hibernate</groupId>
-      <artifactId>hibernate-core</artifactId>
-      <version>${hibernate-core-release-version}</version>
-    </dependency>
-	<dependency>
-      <groupId>org.hibernate</groupId>
-      <artifactId>hibernate-annotations</artifactId>
-      <version>${hibernate-annontations-release-version}</version>
-      <exclusions>
-        <exclusion>
-            <groupId>org.hibernate</groupId>
-            <artifactId>hibernate</artifactId>
-        </exclusion>
-      </exclusions>
-    </dependency>
-    <dependency>
-	    <groupId>net.aramzamzam.commons</groupId>
-	    <artifactId>commons-hibernate</artifactId>
-	    <version>1.0-SNAPSHOT</version>
-  	</dependency> 
-    <dependency>
-	    <groupId>net.aramzamzam.commons</groupId>
-	    <artifactId>commons-tokens</artifactId>
-	    <version>1.0-SNAPSHOT</version>
-  	</dependency>
-  	<dependency>
-	    <groupId>net.aramzamzam.commons</groupId>
-	    <artifactId>commons-pages-behavoir</artifactId>
-	    <version>1.0-SNAPSHOT</version>
-  	</dependency> 
+				<exclusion>
+					<groupId>org.hibernate</groupId>
+					<artifactId>hibernate</artifactId>
+				</exclusion>
+			</exclusions>
+		</dependency>
+		<dependency>
+			<groupId>net.aramzamzam.commons</groupId>
+			<artifactId>commons-hibernate</artifactId>
+			<version>1.0-SNAPSHOT</version>
+		</dependency>
+		<dependency>
+			<groupId>net.aramzamzam.commons</groupId>
+			<artifactId>commons-tokens</artifactId>
+			<version>1.0-SNAPSHOT</version>
+		</dependency>
+		<dependency>
+			<groupId>net.aramzamzam.commons</groupId>
+			<artifactId>commons-pages-behavoir</artifactId>
+			<version>1.0-SNAPSHOT</version>
+		</dependency>
+		<dependency>
+			<groupId>dk.eobjects.metamodel</groupId>
+			<artifactId>MetaModel-full</artifactId>
+			<version>1.1.4</version>
+		</dependency>
 	</dependencies>
 	<build>
 		<finalName>rentdom-web</finalName>
@@ -173,10 +178,10 @@
 			<name>OpenQA Release Repository</name>
 			<url>http://archiva.openqa.org/repository/releases/</url>
 		</repository>
-		 <repository>
-		    <id>localhost.nu</id>
-		    <url>http://www.localhost.nu/java/mvn</url>
-  		 </repository>
+		<repository>
+			<id>localhost.nu</id>
+			<url>http://www.localhost.nu/java/mvn</url>
+		</repository>
 	</repositories>
 
 	<pluginRepositories>
diff --git a/rentdom-web/src/main/java/ru/rentdom/services/tools/CoordsImport.java b/rentdom-web/src/main/java/ru/rentdom/services/tools/CoordsImport.java
new file mode 100644
index 0000000..365d43f
--- /dev/null
+++ b/rentdom-web/src/main/java/ru/rentdom/services/tools/CoordsImport.java
@@ -0,0 +1,32 @@
+package ru.rentdom.services.tools;
+
+import java.io.File;
+
+import dk.eobjects.metamodel.DataContext;
+import dk.eobjects.metamodel.DataContextFactory;
+import dk.eobjects.metamodel.data.DataSet;
+import dk.eobjects.metamodel.query.Query;
+import dk.eobjects.metamodel.schema.Column;
+import dk.eobjects.metamodel.schema.Schema;
+import dk.eobjects.metamodel.schema.Table;
+
+public class CoordsImport {
+	public void process()
+	{
+		DataContext dataContext = DataContextFactory.createExcelDataContext(new File("/Users/vovasty/Documents/SampleData.xls"), false);
+		Schema schema = dataContext.getDefaultSchema();
+		// A simple way of getting the table object is just to pick the first one (the first sheet in the spreadsheet)
+		Table table = schema.getTables()[0];
+		Column countryColumn = table.getColumnByName("country");
+		Column townColumn = table.getColumnByName("town");
+		Column districtColumn = table.getColumnByName("district");
+		Column streetColumn = table.getColumnByName("street");
+		Column metroColumn = table.getColumnByName("metro");
+		Query q = new Query().select(countryColumn, townColumn, districtColumn, streetColumn, metroColumn).from(table);
+		DataSet dataSet = dataContext.executeQuery(q);
+		while (dataSet.next()) {
+		    System.out.println(dataSet.getRow());
+		}
+		dataSet.close();
+	}
+}
diff --git a/rentdom-web/src/test/ru/rentdom/services/tools/CoordsImportTest.java b/rentdom-web/src/test/ru/rentdom/services/tools/CoordsImportTest.java
new file mode 100644
index 0000000..452a09a
--- /dev/null
+++ b/rentdom-web/src/test/ru/rentdom/services/tools/CoordsImportTest.java
@@ -0,0 +1,13 @@
+package ru.rentdom.services.tools;
+
+import org.testng.Assert;
+import org.testng.annotations.Test;
+
+public class CoordsImportTest extends Assert{
+	@Test
+	public void testProcess()
+	{
+		CoordsImport im=new CoordsImport();
+		im.process();
+	}
+}
-- 
2.11.4.GIT