Revision 47606 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/test/java/org/gvsig/sqlite/dal/operations/usecases/arena2/TestSelectWithLocalVariables.java
TestSelectWithLocalVariables.java | ||
---|---|---|
8 | 8 |
import org.gvsig.expressionevaluator.LexicalAnalyzer; |
9 | 9 |
import org.gvsig.expressionevaluator.MutableSymbolTable; |
10 | 10 |
import org.gvsig.expressionevaluator.SymbolTable; |
11 |
import org.gvsig.fmap.dal.DALLocator; |
|
12 |
import org.gvsig.fmap.dal.DataManager; |
|
13 |
import org.gvsig.fmap.dal.feature.FeatureStore; |
|
14 | 11 |
import org.gvsig.fmap.dal.store.jdbc2.AbstractTestUtils; |
15 |
import org.gvsig.fmap.dal.store.jdbc2.JDBCServerExplorer; |
|
16 | 12 |
import org.gvsig.sqlite.dal.TestUtilsSQLite; |
17 | 13 |
import org.gvsig.tools.library.impl.DefaultLibrariesInitializer; |
18 | 14 |
import org.slf4j.Logger; |
... | ... | |
85 | 81 |
|
86 | 82 |
public void testSelectWithLocalVariables() throws Exception { |
87 | 83 |
try { |
88 |
FeatureStore sourceStore = utils().openCountriesStore(); |
|
84 |
// FeatureStore sourceStore = utils().openCountriesStore(); |
|
85 |
// |
|
86 |
// JDBCServerExplorer explorer = utils().openServerExplorer("testCountXXXXX"); |
|
87 |
// |
|
88 |
// utils().info_jdbc(explorer); |
|
89 |
// utils().drop_tables(explorer, sourceStore.getName()); |
|
90 |
// |
|
91 |
// utils().create_table_from(explorer, sourceStore.getName(), sourceStore); |
|
92 |
// utils().insert_into_from(explorer, sourceStore.getName(), sourceStore, FeatureStore.MODE_APPEND); |
|
93 |
// |
|
94 |
// DataManager dataManager = DALLocator.getDataManager(); |
|
95 |
// dataManager.getStoresRepository().add(sourceStore.getName(), explorer.get(sourceStore.getName())); |
|
89 | 96 |
|
90 |
JDBCServerExplorer explorer = utils().openServerExplorer("testCountXXXXX"); |
|
91 |
|
|
92 |
utils().info_jdbc(explorer); |
|
93 |
utils().drop_tables(explorer, sourceStore.getName()); |
|
94 |
|
|
95 |
utils().create_table_from(explorer, sourceStore.getName(), sourceStore); |
|
96 |
utils().insert_into_from(explorer, sourceStore.getName(), sourceStore, FeatureStore.MODE_APPEND); |
|
97 |
|
|
98 |
DataManager dataManager = DALLocator.getDataManager(); |
|
99 |
dataManager.getStoresRepository().add(sourceStore.getName(), explorer.get(sourceStore.getName())); |
|
100 |
|
|
101 | 97 |
StringBuilder source = new StringBuilder(); |
102 | 98 |
source.append("BEGIN "); |
103 | 99 |
source.append("CREATE PROCEDURE fn1() AS"); |
Also available in: Unified diff