[68ae6b]: legacy / src / main / resources / org / wnsql / builder / legacy / template.properties  Maximize  Restore  History

Download this file

86 lines (79 with data), 11.2 kB

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
LegacySense.table.base=senses
LegacySynset.table.base=synsets
LegacySynsetMap.table.base=synsetmaps
LegacySenseMap.table.base=sensemaps
LegacyComputedSenseMap.table.base=sensemaps
Legacy.view.base=legacy
LegacySynset.view.base=synsets
LegacySense$X$.table=%LegacySense.table.base%$X$
LegacySense$X$.create=CREATE TABLE IF NOT EXISTS %LegacySense$X$.table% (wordid INTEGER UNSIGNED NOT NULL DEFAULT '0',synsetid INTEGER UNSIGNED NOT NULL DEFAULT '0',pos ENUM ('n','v','a','r','s') NOT NULL,senseid INTEGER UNSIGNED NULL,sensenum SMALLINT UNSIGNED NOT NULL DEFAULT '0',sensekey VARCHAR (100) DEFAULT NULL,PRIMARY KEY (wordid,synsetid));
LegacySense$X$.pk=ALTER TABLE %LegacySense$X$.table% ADD CONSTRAINT pk_%LegacySense$X$.table% PRIMARY KEY (wordid,synsetid);
LegacySense$X$.no-pk=ALTER TABLE %LegacySense$X$.table% DROP CONSTRAINT pk_%LegacySense$X$.table% CASCADE;
LegacySense$X$.unq1=CREATE UNIQUE INDEX IF NOT EXISTS unq_%LegacySense$X$.table%_senseid ON %LegacySense$X$.table% (senseid);
LegacySense$X$.no-unq1=DROP INDEX IF EXISTS unq_%LegacySense$X$.table%_senseid;
LegacySense$X$.unq2=CREATE UNIQUE INDEX IF NOT EXISTS unq_%LegacySense$X$.table%_sensekey ON %LegacySense$X$.table% (sensekey);
LegacySense$X$.no-unq2=DROP INDEX IF EXISTS unq_%LegacySense$X$.table%_sensekey;
LegacySense$X$.index1=CREATE INDEX IF NOT EXISTS k_%LegacySense$X$.table%_wordid ON %LegacySense$X$.table% (wordid);
LegacySense$X$.no-index1=DROP INDEX IF EXISTS k_%LegacySense$X$.table%_wordid;
LegacySense$X$.index2=CREATE INDEX IF NOT EXISTS k_%LegacySense$X$.table%_synsetid ON %LegacySense$X$.table% (synsetid);
LegacySense$X$.no-index2=DROP INDEX IF EXISTS k_%LegacySense$X$.table%_synsetid;
LegacySense$X$.fk=ALTER TABLE %LegacySense$X$.table% ADD CONSTRAINT fk_%LegacySense$X$.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
LegacySense$X$.no-fk=ALTER TABLE %LegacySense$X$.table% DROP CONSTRAINT fk_%LegacySense$X$.table%_wordid CASCADE;
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 UNSIGNED NOT NULL,srcsynsetid INTEGER UNSIGNED NOT NULL,quality FLOAT NOT NULL,PRIMARY KEY (synsetid,srcsynsetid,quality));
LegacySynsetMap$X$~$Y$.pk=ALTER TABLE %LegacySynsetMap$X$~$Y$.table% ADD CONSTRAINT pk_%LegacySynsetMap$X$~$Y$.table% PRIMARY KEY (synsetid,srcsynsetid,quality);
LegacySynsetMap$X$~$Y$.no-pk=ALTER TABLE %LegacySynsetMap$X$~$Y$.table% DROP CONSTRAINT pk_%LegacySynsetMap$X$~$Y$.table% CASCADE;
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=ALTER TABLE %LegacySynsetMap$X$~$Y$.table% ADD CONSTRAINT fk_%LegacySynsetMap$X$~$Y$.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
LegacySynsetMap$X$~$Y$.no-fk=ALTER TABLE %LegacySynsetMap$X$~$Y$.table% DROP CONSTRAINT fk_%LegacySynsetMap$X$~$Y$.table%_synsetid CASCADE;
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 UNSIGNED NOT NULL,synsetid INTEGER UNSIGNED NOT NULL,srcsynsetid INTEGER UNSIGNED NOT NULL,quality FLOAT NOT NULL,PRIMARY KEY (wordid,synsetid,srcsynsetid,quality));
LegacySenseMap$X$~$Y$.pk=ALTER TABLE %LegacySenseMap$X$~$Y$.table% ADD CONSTRAINT pk_%LegacySenseMap$X$~$Y$.table% PRIMARY KEY (wordid,synsetid,srcsynsetid,quality);
LegacySenseMap$X$~$Y$.no-pk=ALTER TABLE %LegacySenseMap$X$~$Y$.table% DROP CONSTRAINT pk_%LegacySenseMap$X$~$Y$.table% CASCADE;
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=ALTER TABLE %LegacySenseMap$X$~$Y$.table% ADD CONSTRAINT fk_%LegacySenseMap$X$~$Y$.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
LegacySenseMap$X$~$Y$.no-fk1=ALTER TABLE %LegacySenseMap$X$~$Y$.table% DROP CONSTRAINT fk_%LegacySenseMap$X$~$Y$.table%_wordid CASCADE;
LegacySenseMap$X$~$Y$.fk2=ALTER TABLE %LegacySenseMap$X$~$Y$.table% ADD CONSTRAINT fk_%LegacySenseMap$X$~$Y$.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
LegacySenseMap$X$~$Y$.no-fk2=ALTER TABLE %LegacySenseMap$X$~$Y$.table% DROP CONSTRAINT fk_%LegacySenseMap$X$~$Y$.table%_synsetid CASCADE;
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 UNSIGNED NOT NULL,synsetid INTEGER UNSIGNED NOT NULL,srcsynsetid INTEGER UNSIGNED NOT NULL,quality FLOAT NOT NULL,PRIMARY KEY (wordid,synsetid,srcsynsetid,quality));
LegacyComputedSenseMap$X$~$Y$.pk=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% ADD CONSTRAINT pk_%LegacyComputedSenseMap$X$~$Y$.table% PRIMARY KEY (wordid,synsetid,srcsynsetid,quality);
LegacyComputedSenseMap$X$~$Y$.no-pk=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% DROP CONSTRAINT pk_%LegacyComputedSenseMap$X$~$Y$.table% CASCADE;
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=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% ADD CONSTRAINT fk_%LegacyComputedSenseMap$X$~$Y$.table%_wordid FOREIGN KEY (wordid) REFERENCES %Word.table% (wordid);
LegacyComputedSenseMap$X$~$Y$.no-fk1=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% DROP CONSTRAINT fk_%LegacyComputedSenseMap$X$~$Y$.table%_wordid CASCADE;
LegacyComputedSenseMap$X$~$Y$.fk2=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% ADD CONSTRAINT fk_%LegacyComputedSenseMap$X$~$Y$.table%_synsetid FOREIGN KEY (synsetid) REFERENCES %Synset.table% (synsetid);
LegacyComputedSenseMap$X$~$Y$.no-fk2=ALTER TABLE %LegacyComputedSenseMap$X$~$Y$.table% DROP CONSTRAINT fk_%LegacyComputedSenseMap$X$~$Y$.table%_synsetid CASCADE;
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=CREATE OR REPLACE 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=CREATE OR REPLACE 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=CREATE OR REPLACE 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=CREATE OR REPLACE 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;

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks