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

Download this file

19 lines (17 with data), 1.6 kB

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
GLFlf.table=glfs
GLFlf.create=CREATE TABLE IF NOT EXISTS %GLFlf.table% (wordid INTEGER NOT NULL,synsetid INTEGER NOT NULL,lf TEXT NOT NULL,text TEXT NULL,issub BOOLEAN NOT NULL);
GLFlf.insert=INSERT INTO %GLFlf.table% (wordid,synsetid,lf,text,issub) VALUES (?,?,?,?,?);
GLFlf.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%GLFlf.table%_wordid_synsetid_lf_issub ON %GLFlf.table% (wordid,synsetid,lf,issub);
GLFlf.no-unq=DROP INDEX IF EXISTS unq_%GLFlf.table%_wordid_synsetid_lf_issub;
GLFlf.index1=CREATE INDEX IF NOT EXISTS k_%GLFlf.table%_wordid ON %GLFlf.table% (wordid);
GLFlf.no-index1=DROP INDEX IF EXISTS k_%GLFlf.table%_wordid;
GLFlf.index2=CREATE INDEX IF NOT EXISTS k_%GLFlf.table%_synsetid ON %GLFlf.table% (synsetid);
GLFlf.no-index2=DROP INDEX IF EXISTS k_%GLFlf.table%_synsetid;
GLFlf.fk1=
GLFlf.no-fk1=
GLFlf.fk2=
GLFlf.no-fk2=
GLFlf.select=SELECT %GLFlf.table%.synsetid,%GLFlf.table%.wsd,%GLFlf.table%.text FROM %GLFlf.table% WHERE %GLFlf.table%.synsetid = ? AND %GLFlf.table%.lf = ? AND %GLFlf.table%.text = ?;
GLFlf.select2=SELECT %GLFlf.table%.synsetid,%GLFlf.table%.wsd,%GLFlf.table%.text FROM %GLFlf.table% WHERE %GLFlf.table%.synsetid = ? AND %GLFlf.table%.lf = ? AND %GLFlf.table%.text IS NULL;
GLFSense.select=SELECT wordid,synsetid,definition FROM %Word.table% LEFT JOIN %Sense.table% USING (wordid) LEFT JOIN %Synset.table% USING (synsetid) WHERE lemma = ? AND sensenum = ? AND pos = ?;
GLFSense.select.adj=SELECT wordid,synsetid,definition FROM %Word.table% LEFT JOIN %Sense.table% USING (wordid) LEFT JOIN %Synset.table% USING (synsetid) WHERE lemma = ? AND sensenum = ? AND (pos = 'a' OR pos = 's');

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

Sign up for the SourceForge newsletter:





No, thanks