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

Download this file

18 lines (16 with data), 1.5 kB

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
ILFWNlf.table=ilfs
ILFWNlf.create=CREATE TABLE IF NOT EXISTS %ILFWNlf.table% (wordid INTEGER NOT NULL,synsetid INTEGER NOT NULL,lf TEXT NOT NULL,prettylf TEXT NOT NULL,text TEXT NULL);
ILFWNlf.insert=INSERT INTO %ILFWNlf.table% (wordid,synsetid,lf,prettylf,text) VALUES (?,?,?,?,?);
ILFWNlf.unq=CREATE UNIQUE INDEX IF NOT EXISTS unq_%ILFWNlf.table%_wordid_synsetid_lf_prettylf ON %ILFWNlf.table% (wordid,synsetid,lf,prettylf);
ILFWNlf.no-unq=DROP INDEX IF EXISTS unq_%ILFWNlf.table%_wordid_synsetid_lf_prettylf;
ILFWNlf.index1=CREATE INDEX IF NOT EXISTS k_%ILFWNlf.table%_wordid ON %ILFWNlf.table% (wordid);
ILFWNlf.no-index1=DROP INDEX IF EXISTS k_%ILFWNlf.table%_wordid;
ILFWNlf.index2=CREATE INDEX IF NOT EXISTS k_%ILFWNlf.table%_synsetid ON %ILFWNlf.table% (synsetid);
ILFWNlf.no-index2=DROP INDEX IF EXISTS k_%ILFWNlf.table%_synsetid;
ILFWNlf.fk1=
ILFWNlf.no-fk1=
ILFWNlf.fk2=
ILFWNlf.no-fk2=
ILFWNlf.select=SELECT %ILFWNlf.table%.synsetid,%ILFWNlf.table%.wsd,%ILFWNlf.table%.text FROM %ILFWNlf.table% WHERE %ILFWNlf.table%.synsetid = ? AND %ILFWNlf.table%.lf = ? AND %ILFWNlf.table%.text = ?;
ILFWNlf.select2=SELECT %ILFWNlf.table%.synsetid,%ILFWNlf.table%.wsd,%ILFWNlf.table%.text FROM %ILFWNlf.table% WHERE %ILFWNlf.table%.synsetid = ? AND %ILFWNlf.table%.lf = ? AND %ILFWNlf.table%.text IS NULL;
ILFWNSense.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 = ?;

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

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks