[6ff7b6]: legacy / src / main / resources / org / wnsql / builder / legacy / test.properties  Maximize  Restore  History

Download this file

87 lines (79 with data), 8.8 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 NOT NULL DEFAULT '0',synsetid INTEGER NOT NULL DEFAULT '0',pos CHARACTER (1) NOT NULL,senseid INTEGER NULL,sensenum SMALLINT NOT NULL DEFAULT '0',sensekey VARCHAR (100) DEFAULT NULL,CONSTRAINT pk_%LegacySense$X$.table% PRIMARY KEY (wordid,synsetid));
LegacySense$X$.pk=
LegacySense$X$.no-pk=
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=
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 = ?;
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 = ?;
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.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.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;

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

Sign up for the SourceForge newsletter:





No, thanks