Diff of /legacy/src/main/resources/org/wnsql/builder/legacy/sqlite.properties [6ff7b6] .. [68ae6b] Maximize Restore

  Switch to side-by-side view

--- a/legacy/src/main/resources/org/wnsql/builder/legacy/sqlite.properties
+++ b/legacy/src/main/resources/org/wnsql/builder/legacy/sqlite.properties
@@ -22,65 +22,64 @@
 LegacySense$X$.no-fk=
 LegacySense$X$.insert=INSERT INTO %LegacySense$X$.table% (wordid,synsetid,pos,sensenum,senseid,sensekey) VALUES (?,?,?,?,?,?);
 
-LegacySynsetMap$X$$Y$.table=%LegacySynsetMap.table.base%$X$$Y$
-LegacySynsetMap$X$$Y$.create=CREATE TABLE IF NOT EXISTS %LegacySynsetMap$X$$Y$.table% (synsetid INTEGER NOT NULL,srcsynsetid INTEGER NOT NULL,quality FLOAT NOT NULL,CONSTRAINT pk_%LegacySynsetMap$X$$Y$.table% PRIMARY KEY (synsetid,srcsynsetid,quality));
-LegacySynsetMap$X$$Y$.pk=
-LegacySynsetMap$X$$Y$.no-pk=
-LegacySynsetMap$X$$Y$.index1=CREATE INDEX IF NOT EXISTS k_%LegacySynsetMap$X$$Y$.table%_synsetid ON %LegacySynsetMap$X$$Y$.table% (synsetid);
-LegacySynsetMap$X$$Y$.no-index1=DROP INDEX IF EXISTS k_%LegacySynsetMap$X$$Y$.table%_synsetid;
-LegacySynsetMap$X$$Y$.index2=CREATE INDEX IF NOT EXISTS k_%LegacySynsetMap$X$$Y$.table%_srcsynsetid ON %LegacySynsetMap$X$$Y$.table% (srcsynsetid);
-LegacySynsetMap$X$$Y$.no-index2=DROP INDEX IF EXISTS k_%LegacySynsetMap$X$$Y$.table%_srcsynsetid;
-LegacySynsetMap$X$$Y$.fk=
-LegacySynsetMap$X$$Y$.no-fk=
-LegacySynsetMap$X$$Y$.insert=INSERT INTO %LegacySynsetMap$X$$Y$.table% (synsetid,srcsynsetid,quality) VALUES (?,?,?);
-LegacySynsetMap$X$$Y$.select=SELECT synsetid,srcsynsetid,quality FROM %LegacySynsetMap$X$$Y$.table% WHERE synsetid = ? AND srcsynsetid = ? AND quality = ?;
+LegacySynsetMap$X$~$Y$.table=%LegacySynsetMap.table.base%$X$$Y$
+LegacySynsetMap$X$~$Y$.create=CREATE TABLE IF NOT EXISTS %LegacySynsetMap$X$~$Y$.table% (synsetid INTEGER NOT NULL,srcsynsetid INTEGER NOT NULL,quality FLOAT NOT NULL,CONSTRAINT pk_%LegacySynsetMap$X$~$Y$.table% PRIMARY KEY (synsetid,srcsynsetid,quality));
+LegacySynsetMap$X$~$Y$.pk=
+LegacySynsetMap$X$~$Y$.no-pk=
+LegacySynsetMap$X$~$Y$.index1=CREATE INDEX IF NOT EXISTS k_%LegacySynsetMap$X$~$Y$.table%_synsetid ON %LegacySynsetMap$X$~$Y$.table% (synsetid);
+LegacySynsetMap$X$~$Y$.no-index1=DROP INDEX IF EXISTS k_%LegacySynsetMap$X$~$Y$.table%_synsetid;
+LegacySynsetMap$X$~$Y$.index2=CREATE INDEX IF NOT EXISTS k_%LegacySynsetMap$X$~$Y$.table%_srcsynsetid ON %LegacySynsetMap$X$~$Y$.table% (srcsynsetid);
+LegacySynsetMap$X$~$Y$.no-index2=DROP INDEX IF EXISTS k_%LegacySynsetMap$X$~$Y$.table%_srcsynsetid;
+LegacySynsetMap$X$~$Y$.fk=
+LegacySynsetMap$X$~$Y$.no-fk=
+LegacySynsetMap$X$~$Y$.insert=INSERT INTO %LegacySynsetMap$X$~$Y$.table% (synsetid,srcsynsetid,quality) VALUES (?,?,?);
+LegacySynsetMap$X$~$Y$.select=SELECT synsetid,srcsynsetid,quality FROM %LegacySynsetMap$X$~$Y$.table% WHERE synsetid = ? AND srcsynsetid = ? AND quality = ?;
 
-LegacySenseMap$X$$Y$.table=%LegacySenseMap.table.base%$X$$Y$
-LegacySenseMap$X$$Y$.create=CREATE TABLE IF NOT EXISTS %LegacySenseMap$X$$Y$.table% (wordid INTEGER NOT NULL,synsetid INTEGER NOT NULL,srcsynsetid INTEGER NOT NULL,quality FLOAT NOT NULL,CONSTRAINT pk_%LegacySenseMap$X$$Y$.table% PRIMARY KEY (wordid,synsetid,srcsynsetid,quality));
-LegacySenseMap$X$$Y$.pk=
-LegacySenseMap$X$$Y$.no-pk=
-LegacySenseMap$X$$Y$.index1=CREATE INDEX IF NOT EXISTS k_%LegacySenseMap$X$$Y$.table%_wordid ON %LegacySenseMap$X$$Y$.table% (wordid);
-LegacySenseMap$X$$Y$.no-index1=DROP INDEX IF EXISTS k_%LegacySenseMap$X$$Y$.table%_wordid;
-LegacySenseMap$X$$Y$.index2=CREATE INDEX IF NOT EXISTS k_%LegacySenseMap$X$$Y$.table%_synsetid ON %LegacySenseMap$X$$Y$.table% (synsetid);
-LegacySenseMap$X$$Y$.no-index2=DROP INDEX IF EXISTS k_%LegacySenseMap$X$$Y$.table%_synsetid;
-LegacySenseMap$X$$Y$.index3=CREATE INDEX IF NOT EXISTS k_%LegacySenseMap$X$$Y$.table%_srcsynsetid ON %LegacySenseMap$X$$Y$.table% (srcsynsetid);
-LegacySenseMap$X$$Y$.no-index3=DROP INDEX IF EXISTS k_%LegacySenseMap$X$$Y$.table%_srcsynsetid;
-LegacySenseMap$X$$Y$.fk1=
-LegacySenseMap$X$$Y$.no-fk1=
-LegacySenseMap$X$$Y$.fk2=
-LegacySenseMap$X$$Y$.no-fk2=
-LegacySenseMap$X$$Y$.insert=INSERT INTO %LegacySenseMap$X$$Y$.table% (wordid,synsetid,srcsynsetid,quality) VALUES (?,?,?,?);
-LegacySenseMap$X$$Y$.select=SELECT wordid,synsetid,srcsynsetid,quality FROM %LegacySenseMap$X$$Y$.table% WHERE wordid = ? AND synsetid = ? AND srcsynsetid = ? AND quality = ?;
+LegacySenseMap$X$~$Y$.table=%LegacySenseMap.table.base%$X$$Y$
+LegacySenseMap$X$~$Y$.create=CREATE TABLE IF NOT EXISTS %LegacySenseMap$X$~$Y$.table% (wordid INTEGER NOT NULL,synsetid INTEGER NOT NULL,srcsynsetid INTEGER NOT NULL,quality FLOAT NOT NULL,CONSTRAINT pk_%LegacySenseMap$X$~$Y$.table% PRIMARY KEY (wordid,synsetid,srcsynsetid,quality));
+LegacySenseMap$X$~$Y$.pk=
+LegacySenseMap$X$~$Y$.no-pk=
+LegacySenseMap$X$~$Y$.index1=CREATE INDEX IF NOT EXISTS k_%LegacySenseMap$X$~$Y$.table%_wordid ON %LegacySenseMap$X$~$Y$.table% (wordid);
+LegacySenseMap$X$~$Y$.no-index1=DROP INDEX IF EXISTS k_%LegacySenseMap$X$~$Y$.table%_wordid;
+LegacySenseMap$X$~$Y$.index2=CREATE INDEX IF NOT EXISTS k_%LegacySenseMap$X$~$Y$.table%_synsetid ON %LegacySenseMap$X$~$Y$.table% (synsetid);
+LegacySenseMap$X$~$Y$.no-index2=DROP INDEX IF EXISTS k_%LegacySenseMap$X$~$Y$.table%_synsetid;
+LegacySenseMap$X$~$Y$.index3=CREATE INDEX IF NOT EXISTS k_%LegacySenseMap$X$~$Y$.table%_srcsynsetid ON %LegacySenseMap$X$~$Y$.table% (srcsynsetid);
+LegacySenseMap$X$~$Y$.no-index3=DROP INDEX IF EXISTS k_%LegacySenseMap$X$~$Y$.table%_srcsynsetid;
+LegacySenseMap$X$~$Y$.fk1=
+LegacySenseMap$X$~$Y$.no-fk1=
+LegacySenseMap$X$~$Y$.fk2=
+LegacySenseMap$X$~$Y$.no-fk2=
+LegacySenseMap$X$~$Y$.insert=INSERT INTO %LegacySenseMap$X$~$Y$.table% (wordid,synsetid,srcsynsetid,quality) VALUES (?,?,?,?);
+LegacySenseMap$X$~$Y$.select=SELECT wordid,synsetid,srcsynsetid,quality FROM %LegacySenseMap$X$~$Y$.table% WHERE wordid = ? AND synsetid = ? AND srcsynsetid = ? AND quality = ?;
 
-LegacyComputedSenseMap$X$$Y$.table=%LegacyComputedSenseMap.table.base%$X$$Y$
-LegacyComputedSenseMap$X$$Y$.create=CREATE TABLE IF NOT EXISTS %LegacyComputedSenseMap$X$$Y$.table% (wordid INTEGER NOT NULL,synsetid INTEGER NOT NULL,srcsynsetid INTEGER NOT NULL,quality FLOAT NOT NULL,CONSTRAINT pk_%LegacyComputedSenseMap$X$$Y$.table% PRIMARY KEY (wordid,synsetid,srcsynsetid,quality));
-LegacyComputedSenseMap$X$$Y$.pk=
-LegacyComputedSenseMap$X$$Y$.no-pk=
-LegacyComputedSenseMap$X$$Y$.index1=CREATE INDEX IF NOT EXISTS k_%LegacyComputedSenseMap$X$$Y$.table%_wordid ON %LegacyComputedSenseMap$X$$Y$.table% (wordid);
-LegacyComputedSenseMap$X$$Y$.no-index1=DROP INDEX IF EXISTS k_%LegacyComputedSenseMap$X$$Y$.table%_wordid;
-LegacyComputedSenseMap$X$$Y$.index2=CREATE INDEX IF NOT EXISTS k_%LegacyComputedSenseMap$X$$Y$.table%_synsetid ON %LegacyComputedSenseMap$X$$Y$.table% (synsetid);
-LegacyComputedSenseMap$X$$Y$.no-index2=DROP INDEX IF EXISTS k_%LegacyComputedSenseMap$X$$Y$.table%_synsetid;
-LegacyComputedSenseMap$X$$Y$.index3=CREATE INDEX IF NOT EXISTS k_%LegacyComputedSenseMap$X$$Y$.table%_srcsynsetid ON %LegacyComputedSenseMap$X$$Y$.table% (srcsynsetid);
-LegacyComputedSenseMap$X$$Y$.no-index3=DROP INDEX IF EXISTS k_%LegacyComputedSenseMap$X$$Y$.table%_srcsynsetid;
-LegacyComputedSenseMap$X$$Y$.fk1=
-LegacyComputedSenseMap$X$$Y$.no-fk1=
-LegacyComputedSenseMap$X$$Y$.fk2=
-LegacyComputedSenseMap$X$$Y$.no-fk2=
-LegacyComputedSenseMap$X$$Y$.insert=INSERT INTO %LegacyComputedSenseMap$X$$Y$.table% (wordid,synsetid,srcsynsetid,quality) VALUES (?,?,?,?);
-LegacyComputedSenseMap$X$$Y$.select=SELECT wordid,synsetid,srcsynsetid,quality FROM %LegacyComputedSenseMap$X$$Y$.table% WHERE wordid = ? AND synsetid = ? AND srcsynsetid = ? AND quality = ?;
-LegacyComputedSenseMap$X$$Y$.select.all.synsetmaps=SELECT synsetid,srcsynsetid,quality FROM %LegacySynsetMap$X$$Y$.table% WHERE synsetid <> srcsynsetid;
-LegacyComputedSenseMap$X$$Y$.select.senses=SELECT wordid,%LegacySense.table.base%$X$.synsetid,%LegacySense.table.base%$X$.sensekey,%LegacySense.table.base%$X$.senseid,%LegacySense.table.base%$Y$.synsetid,%LegacySense.table.base%$Y$.sensekey, %LegacySense.table.base%$Y$.senseid FROM %LegacySense.table.base%$X$ INNER JOIN %LegacySense.table.base%$Y$ USING (wordid) WHERE %LegacySense.table.base%$X$.synsetid = ? AND %LegacySense.table.base%$Y$.synsetid = ?;
+LegacyComputedSenseMap$X$~$Y$.table=%LegacyComputedSenseMap.table.base%$X$$Y$
+LegacyComputedSenseMap$X$~$Y$.create=CREATE TABLE IF NOT EXISTS %LegacyComputedSenseMap$X$~$Y$.table% (wordid INTEGER NOT NULL,synsetid INTEGER NOT NULL,srcsynsetid INTEGER NOT NULL,quality FLOAT NOT NULL,CONSTRAINT pk_%LegacyComputedSenseMap$X$~$Y$.table% PRIMARY KEY (wordid,synsetid,srcsynsetid,quality));
+LegacyComputedSenseMap$X$~$Y$.pk=
+LegacyComputedSenseMap$X$~$Y$.no-pk=
+LegacyComputedSenseMap$X$~$Y$.index1=CREATE INDEX IF NOT EXISTS k_%LegacyComputedSenseMap$X$~$Y$.table%_wordid ON %LegacyComputedSenseMap$X$~$Y$.table% (wordid);
+LegacyComputedSenseMap$X$~$Y$.no-index1=DROP INDEX IF EXISTS k_%LegacyComputedSenseMap$X$~$Y$.table%_wordid;
+LegacyComputedSenseMap$X$~$Y$.index2=CREATE INDEX IF NOT EXISTS k_%LegacyComputedSenseMap$X$~$Y$.table%_synsetid ON %LegacyComputedSenseMap$X$~$Y$.table% (synsetid);
+LegacyComputedSenseMap$X$~$Y$.no-index2=DROP INDEX IF EXISTS k_%LegacyComputedSenseMap$X$~$Y$.table%_synsetid;
+LegacyComputedSenseMap$X$~$Y$.index3=CREATE INDEX IF NOT EXISTS k_%LegacyComputedSenseMap$X$~$Y$.table%_srcsynsetid ON %LegacyComputedSenseMap$X$~$Y$.table% (srcsynsetid);
+LegacyComputedSenseMap$X$~$Y$.no-index3=DROP INDEX IF EXISTS k_%LegacyComputedSenseMap$X$~$Y$.table%_srcsynsetid;
+LegacyComputedSenseMap$X$~$Y$.fk1=
+LegacyComputedSenseMap$X$~$Y$.no-fk1=
+LegacyComputedSenseMap$X$~$Y$.fk2=
+LegacyComputedSenseMap$X$~$Y$.no-fk2=
+LegacyComputedSenseMap$X$~$Y$.insert=INSERT INTO %LegacyComputedSenseMap$X$~$Y$.table% (wordid,synsetid,srcsynsetid,quality) VALUES (?,?,?,?);
+LegacyComputedSenseMap$X$~$Y$.select=SELECT wordid,synsetid,srcsynsetid,quality FROM %LegacyComputedSenseMap$X$~$Y$.table% WHERE wordid = ? AND synsetid = ? AND srcsynsetid = ? AND quality = ?;
+LegacyComputedSenseMap$X$~$Y$.select.all.synsetmaps=SELECT synsetid,srcsynsetid,quality FROM %LegacySynsetMap$X$~$Y$.table% WHERE synsetid <> srcsynsetid;
+LegacyComputedSenseMap$X$~$Y$.select.senses=SELECT wordid,%LegacySense.table.base%$X$.synsetid,%LegacySense.table.base%$X$.sensekey,%LegacySense.table.base%$X$.senseid,%LegacySense.table.base%$Y$.synsetid,%LegacySense.table.base%$Y$.sensekey, %LegacySense.table.base%$Y$.senseid FROM %LegacySense.table.base%$X$ INNER JOIN %LegacySense.table.base%$Y$ USING (wordid) WHERE %LegacySense.table.base%$X$.synsetid = ? AND %LegacySense.table.base%$Y$.synsetid = ?;
 
 LegacyXSense$X$.select=SELECT senseid FROM %LegacySense.table.base%$X$ WHERE wordid = ? AND synsetid = ?;
 LegacyXSense$X$.max=SELECT MAX(senseid) FROM %LegacySense.table.base%$X$;
 LegacyXSense$X$.insert=INSERT INTO %LegacySense.table.base%$X$ (wordid,synsetid,pos,sensenum,senseid,sensekey) VALUES (?,?,?,?,?,?);
 
-legacy0.LegacySenseMap$X$$Z$.view=%LegacySenseMap.table.base%$X$$Z$
-legacy0.LegacySenseMap$X$$Z$.createview=DROP VIEW IF EXISTS %legacy0.LegacySenseMap$X$$Z$.view%; CREATE VIEW %legacy0.LegacySenseMap$X$$Z$.view% AS SELECT m1.wordid,m1.srcsynsetid,m2.synsetid,(m1.quality*m2.quality) AS quality FROM %LegacySenseMap.table.base%$X$$Y$ m1 INNER JOIN %LegacySenseMap.table.base%$Y$$Z$ m2 ON m1.wordid = m2.wordid AND m1.synsetid = m2.srcsynsetid;
-legacy0.LegacySynsetMap$X$$Z$.view=%LegacySynsetMap.table.base%$X$$Z$
-legacy0.LegacySynsetMap$X$$Z$.createview=DROP VIEW IF EXISTS %legacy0.LegacySynsetMap$X$$Z$.view%; CREATE VIEW %legacy0.LegacySynsetMap$X$$Z$.view% AS SELECT m1.srcsynsetid,m2.synsetid,(m1.quality*m2.quality) AS quality FROM %LegacySynsetMap.table.base%$X$$Y$ m1 INNER JOIN %LegacySynsetMap.table.base%$Y$$Z$ m2 ON m1.synsetid = m2.srcsynsetid;
+legacy0.LegacySenseMap$X$~$Z$.view=%LegacySenseMap.table.base%$X$$Z$
+legacy0.LegacySenseMap$X$~$Z$.createview=DROP VIEW IF EXISTS %legacy0.LegacySenseMap$X$~$Z$.view%; CREATE VIEW %legacy0.LegacySenseMap$X$~$Z$.view% AS SELECT m1.wordid,m1.srcsynsetid,m2.synsetid,(m1.quality*m2.quality) AS quality FROM %LegacySenseMap.table.base%$X$~$Y$ m1 INNER JOIN %LegacySenseMap.table.base%$Y$~$Z$ m2 ON m1.wordid = m2.wordid AND m1.synsetid = m2.srcsynsetid;
+legacy0.LegacySynsetMap$X$~$Z$.view=%LegacySynsetMap.table.base%$X$$Z$
+legacy0.LegacySynsetMap$X$~$Z$.createview=DROP VIEW IF EXISTS %legacy0.LegacySynsetMap$X$~$Z$.view%; CREATE VIEW %legacy0.LegacySynsetMap$X$~$Z$.view% AS SELECT m1.srcsynsetid,m2.synsetid,(m1.quality*m2.quality) AS quality FROM %LegacySynsetMap.table.base%$X$~$Y$ m1 INNER JOIN %LegacySynsetMap.table.base%$Y$~$Z$ m2 ON m1.synsetid = m2.srcsynsetid;
 legacy0.LegacySynset$X$.view=%LegacySynset.view.base%$X$
-legacy0.LegacySynset$X$.createview=DROP VIEW IF EXISTS %legacy0.LegacySynset$X$.view%; CREATE VIEW %legacy0.LegacySynset$X$.view% AS SELECT DISTINCT srcsynsetid FROM %LegacySenseMap.table.base%$X$$Y$;
+legacy0.LegacySynset$X$.createview=DROP VIEW IF EXISTS %legacy0.LegacySynset$X$.view%; CREATE VIEW %legacy0.LegacySynset$X$.view% AS SELECT DISTINCT srcsynsetid FROM %LegacySenseMap.table.base%$X$~$Y$;
 legacy0.Legacy$X$.view=%Legacy.view.base%$X$
-legacy0.Legacy$X$.createview=DROP VIEW IF EXISTS %legacy0.Legacy$X$.view%; CREATE VIEW %legacy0.Legacy$X$.view% AS SELECT s.wordid,lemma,m.quality,s.sensekey AS ssensekey,d.sensekey AS dsensekey,m.srcsynsetid AS ssynsetid,m.synsetid AS dsynsetid,d.senseid AS dsenseid,d.sensenum,d.lexid,d.tagcount,definition FROM %Sense.table%$X$ AS s INNER JOIN %LegacySenseMap.table.base%$X$$Y$ m ON s.wordid = m.wordid AND s.synsetid = m.srcsynsetid INNER JOIN %Sense.table% AS d ON m.wordid = d.wordid AND m.synsetid = d.synsetid LEFT JOIN %Synset.table% AS y ON d.synsetid = y.synsetid LEFT JOIN %Word.table% AS w ON d.wordid = w.wordid;
-
+legacy0.Legacy$X$.createview=DROP VIEW IF EXISTS %legacy0.Legacy$X$.view%; CREATE VIEW %legacy0.Legacy$X$.view% AS SELECT s.wordid,lemma,m.quality,s.sensekey AS ssensekey,d.sensekey AS dsensekey,m.srcsynsetid AS ssynsetid,m.synsetid AS dsynsetid,d.senseid AS dsenseid,d.sensenum,d.lexid,d.tagcount,definition FROM %Sense.table%$X$ AS s INNER JOIN %LegacySenseMap.table.base%$X$~$Y$ m ON s.wordid = m.wordid AND s.synsetid = m.srcsynsetid INNER JOIN %Sense.table% AS d ON m.wordid = d.wordid AND m.synsetid = d.synsetid LEFT JOIN %Synset.table% AS y ON d.synsetid = y.synsetid LEFT JOIN %Word.table% AS w ON d.wordid = w.wordid;