Revision 47579 trunk/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.sqlite/org.gvsig.sqlite.provider/src/test/resources/org/gvsig/sqlite/dal/performChanges.sql

View differences:

performChanges.sql
1 1 

  		




  2
  2
  
    
-- Insert SQL


  		




  3
  
  
    
INSERT INTO "PUBLIC"."test" ( 


  		




  
  3
  
    
INSERT INTO "test" ( 


  		




  4
  4
  
    
    "ID", "Byte", "Bool1", "Long", "Timestamp", "Date", "Time", 


  		




  5
  5
  
    
    "Bool2", "String", "Bool3", "Double", "Bool4", "Float", "Bool5", 


  		




  6
  6
  
    
    "Decimal", "Geometry" 


  		




  7
  7
  
    
  ) 


  		




  8
  8
  
    
  VALUES ( 


  		




  9
  
  
    
     ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ST_GeomFromWKB((?), (?)) 


  		




  
  9
  
    
     ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? 


  		




  10
  10
  
    
  );


  		




  11
  11
  
    

  		




  12
  12
  
    
-- Delete SQL


  		




  13
  
  
    
DELETE FROM "PUBLIC"."test" WHERE ( ("ID") = (?) );


  		




  
  13
  
    
DELETE FROM "test" WHERE ( ("ID") = (?) );


  		




  14
  14
  
    

  		




  15
  15
  
    
-- Update SQL


  		




  16
  
  
    
UPDATE "PUBLIC"."test" 


  		




  
  16
  
    
UPDATE "test" 


  		




  17
  17
  
    
  SET 


  		




  18
  18
  
    
    "Byte" = ?, 


  		




  19
  19
  
    
    "Bool1" = ?, 


  		




  ......




  29
  29
  
    
    "Float" = ?, 


  		




  30
  30
  
    
    "Bool5" = ?, 


  		




  31
  31
  
    
    "Decimal" = ?, 


  		




  32
  
  
    
    "Geometry" = ST_GeomFromWKB((?), (?)) 


  		




  
  32
  
    
    "Geometry" = ? 


  		




  33
  33
  
    
  WHERE 


  		




  34
  34
  
    
    ( ("ID") = (?) );


  		




  35
  35
  
    

  		




  36
  36
  
    
-- Update Table SQL


  		




  37
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Byte" TINYINT DEFAULT NULL NULL;


  		




  38
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Bool1" BOOLEAN DEFAULT NULL NULL;


  		




  39
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Long" BIGINT DEFAULT NULL NULL;


  		




  40
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Timestamp" TIMESTAMP DEFAULT NULL NULL;


  		




  41
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Date" DATE DEFAULT NULL NULL;


  		




  42
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Time" TIME DEFAULT NULL NULL;


  		




  43
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Bool2" BOOLEAN DEFAULT NULL NULL;


  		




  44
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "String" VARCHAR(30) DEFAULT NULL NULL;


  		




  45
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Bool3" BOOLEAN DEFAULT NULL NULL;


  		




  46
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Double" DOUBLE DEFAULT NULL NULL;


  		




  47
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Bool4" BOOLEAN DEFAULT NULL NULL;


  		




  48
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Float" REAL DEFAULT NULL NULL;


  		




  49
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Bool5" BOOLEAN DEFAULT NULL NULL;


  		




  50
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Decimal" DECIMAL(6,3) DEFAULT NULL NULL;


  		




  51
  
  
    
ALTER TABLE "PUBLIC"."test" ADD COLUMN "Geometry" GEOMETRY(1) DEFAULT NULL NULL;


  		




  52
  
  
    
ALTER TABLE "PUBLIC"."test" ADD CONSTRAINT 


  		




  53
  
  
    
  IF NOT EXISTS "test_GEOM_Geometry" 


  		




  54
  
  
    
  CHECK NVL2(


  		




  55
  
  
    
    "Geometry", 


  		




  56
  
  
    
    ST_GeometryTypeCode("Geometry") = 1 AND 


  		




  57
  
  
    
      ST_CoordDim("Geometry") = 2 AND 


  		




  58
  
  
    
      ST_SRID("Geometry") = 4326, 


  		




  59
  
  
    
    TRUE


  		




  60
  
  
    
  );


  		




  
  37
  
    
ALTER TABLE "test" ADD COLUMN "Byte" TINYINT DEFAULT NULL NULL;


  		




  
  38
  
    
ALTER TABLE "test" ADD COLUMN "Bool1" BOOLEAN DEFAULT NULL NULL;


  		




  
  39
  
    
ALTER TABLE "test" ADD COLUMN "Long" BIGINT DEFAULT NULL NULL;


  		




  
  40
  
    
ALTER TABLE "test" ADD COLUMN "Timestamp" DATETIME DEFAULT NULL NULL;


  		




  
  41
  
    
ALTER TABLE "test" ADD COLUMN "Date" DATE DEFAULT NULL NULL;


  		




  
  42
  
    
ALTER TABLE "test" ADD COLUMN "Time" TIME DEFAULT NULL NULL;


  		




  
  43
  
    
ALTER TABLE "test" ADD COLUMN "Bool2" BOOLEAN DEFAULT NULL NULL;


  		




  
  44
  
    
ALTER TABLE "test" ADD COLUMN "String" VARCHAR(30) DEFAULT NULL NULL;


  		




  
  45
  
    
ALTER TABLE "test" ADD COLUMN "Bool3" BOOLEAN DEFAULT NULL NULL;


  		




  
  46
  
    
ALTER TABLE "test" ADD COLUMN "Double" DOUBLE PRECISION DEFAULT NULL NULL;


  		




  
  47
  
    
ALTER TABLE "test" ADD COLUMN "Bool4" BOOLEAN DEFAULT NULL NULL;


  		




  
  48
  
    
ALTER TABLE "test" ADD COLUMN "Float" FLOAT DEFAULT NULL NULL;


  		




  
  49
  
    
ALTER TABLE "test" ADD COLUMN "Bool5" BOOLEAN DEFAULT NULL NULL;


  		




  
  50
  
    
ALTER TABLE "test" ADD COLUMN "Decimal" DECIMAL(6,3) DEFAULT NULL NULL;


  		




  
  51
  
    
ALTER TABLE "test" ADD COLUMN "Geometry" BLOB DEFAULT NULL NULL;


  		




  
  52
  
    
--ALTER TABLE "test" ADD CONSTRAINT 


  		




  
  53
  
    
--  IF NOT EXISTS "test_GEOM_Geometry" 


  		




  
  54
  
    
--  CHECK NVL2(


  		




  
  55
  
    
--    "Geometry", 


  		




  
  56
  
    
--    ST_GeometryTypeCode("Geometry") = 1 AND 


  		




  
  57
  
    
--      ST_CoordDim("Geometry") = 2 AND 


  		




  
  58
  
    
--      ST_SRID("Geometry") = 4326, 


  		




  
  59
  
    
--    TRUE


  		




  
  60
  
    
--  )


  		




  61
  61
  
    

  		




  62
  62
  
    

  		




  63
  63
  
    

  		












Also available in:  Unified diff