source: src/main/java/weka/experiment/DatabaseUtils.props.sqlite3 @ 12

Last change on this file since 12 was 4, checked in by gnappo, 14 years ago

Import di weka.

File size: 2.7 KB
Line 
1# Database settings for sqlite 3.x
2#
3# General information on database access can be found here:
4# http://weka.wikispaces.com/Databases
5#
6# url:     http://www.sqlite.org/
7# jdbc:    http://www.zentus.com/sqlitejdbc/
8# author:  Fracpete (fracpete at waikato dot ac dot nz)
9# version: $Revision: 5837 $
10
11# JDBC driver (comma-separated list)
12jdbcDriver=org.sqlite.JDBC
13
14# database URL
15jdbcURL=jdbc:sqlite:/path/to/database.db
16
17# specific data types
18# string, getString() = 0;    --> nominal
19# boolean, getBoolean() = 1;  --> nominal
20# double, getDouble() = 2;    --> numeric
21# byte, getByte() = 3;        --> numeric
22# short, getByte()= 4;        --> numeric
23# int, getInteger() = 5;      --> numeric
24# long, getLong() = 6;        --> numeric
25# float, getFloat() = 7;      --> numeric
26# date, getDate() = 8;        --> date
27# text, getString() = 9;      --> string
28# time, getTime() = 10;       --> date
29
30# other options
31CREATE_DOUBLE=DOUBLE
32CREATE_STRING=TEXT
33CREATE_INT=INT
34CREATE_DATE=DATETIME
35DateFormat=yyyy-MM-dd HH:mm:ss
36checkUpperCaseNames=false
37checkLowerCaseNames=false
38checkForTable=true
39
40# All the reserved keywords for this database
41# Based on the keywords listed at the following URL (2009-04-13):
42# http://www.sqlite.org/lang_keywords.html
43Keywords=\
44  ABORT,\
45  ADD,\
46  AFTER,\
47  ALL,\
48  ALTER,\
49  ANALYZE,\
50  AND,\
51  AS,\
52  ASC,\
53  ATTACH,\
54  AUTOINCREMENT,\
55  BEFORE,\
56  BEGIN,\
57  BETWEEN,\
58  BY,\
59  CASCADE,\
60  CASE,\
61  CAST,\
62  CHECK,\
63  COLLATE,\
64  COLUMN,\
65  COMMIT,\
66  CONFLICT,\
67  CONSTRAINT,\
68  CREATE,\
69  CROSS,\
70  CURRENT_DATE,\
71  CURRENT_TIME,\
72  CURRENT_TIMESTAMP,\
73  DATABASE,\
74  DEFAULT,\
75  DEFERRABLE,\
76  DEFERRED,\
77  DELETE,\
78  DESC,\
79  DETACH,\
80  DISTINCT,\
81  DROP,\
82  EACH,\
83  ELSE,\
84  END,\
85  ESCAPE,\
86  EXCEPT,\
87  EXCLUSIVE,\
88  EXISTS,\
89  EXPLAIN,\
90  FAIL,\
91  FOR,\
92  FOREIGN,\
93  FROM,\
94  FULL,\
95  GLOB,\
96  GROUP,\
97  HAVING,\
98  IF,\
99  IGNORE,\
100  IMMEDIATE,\
101  IN,\
102  INDEX,\
103  INDEXED,\
104  INITIALLY,\
105  INNER,\
106  INSERT,\
107  INSTEAD,\
108  INTERSECT,\
109  INTO,\
110  IS,\
111  ISNULL,\
112  JOIN,\
113  KEY,\
114  LEFT,\
115  LIKE,\
116  LIMIT,\
117  MATCH,\
118  NATURAL,\
119  NOT,\
120  NOTNULL,\
121  NULL,\
122  OF,\
123  OFFSET,\
124  ON,\
125  OR,\
126  ORDER,\
127  OUTER,\
128  PLAN,\
129  PRAGMA,\
130  PRIMARY,\
131  QUERY,\
132  RAISE,\
133  REFERENCES,\
134  REGEXP,\
135  REINDEX,\
136  RELEASE,\
137  RENAME,\
138  REPLACE,\
139  RESTRICT,\
140  RIGHT,\
141  ROLLBACK,\
142  ROW,\
143  SAVEPOINT,\
144  SELECT,\
145  SET,\
146  TABLE,\
147  TEMP,\
148  TEMPORARY,\
149  THEN,\
150  TO,\
151  TRANSACTION,\
152  TRIGGER,\
153  UNION,\
154  UNIQUE,\
155  UPDATE,\
156  USING,\
157  VACUUM,\
158  VALUES,\
159  VIEW,\
160  VIRTUAL,\
161  WHEN,\
162  WHERE
163
164# The character to append to attribute names to avoid exceptions due to
165# clashes between keywords and attribute names
166KeywordsMaskChar=_
167
168#flags for loading and saving instances using DatabaseLoader/Saver
169nominalToStringLimit=50
170idColumn=auto_generated_id
171
Note: See TracBrowser for help on using the repository browser.