Changeset 19191 for trunk/FACT++/src/root2sql.cc
- Timestamp:
- 08/28/18 20:21:02 (6 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/FACT++/src/root2sql.cc
r19187 r19191 65 65 ("conditional", po_switch(), "Conditional insert. Only insert if no entry exists yet with the constants defined by --const") 66 66 ("delete", po_switch(), "Delete all entries first which fit all constant columns defined by --const") 67 ("index", po_switch(), "If a table is created, all const columns are used as a single index") 67 ("index", po_switch(), "If a table is created, all const columns are used as a single index (INDEX)") 68 ("unique", po_switch(), "If a table is created, all const columns are used as a unqiue index (UNIQUE)") 68 69 ; 69 70 … … 205 206 "with the --index option.\n" 206 207 "\n" 208 "To create the index as a UNIQUE INDEX, you can use the --unique option which " 209 "implies --index.\n" 210 "\n" 207 211 "If a query failed, the query is printed to stderr together with the error message. " 208 212 "For the main INSERT query, this is only true if the verbosity level is at least 2 " … … 356 360 const bool run_delete = conf.Get<bool>("delete"); 357 361 const bool index = conf.Get<bool>("index"); 362 const bool unique = conf.Get<bool>("unique"); 358 363 359 364 const string engine = conf.Get<string>("engine"); … … 629 634 query += ",\n PRIMARY KEY USING BTREE (`"+boost::algorithm::join(primary, "`, `")+"`)"; 630 635 631 if (!vindex.empty() && index)632 query += ",\n INDEX USING BTREE (`"+boost::algorithm::join(vindex, "`, `")+"`)";636 if (!vindex.empty() && (index || unique)) 637 query += ",\n "+string(unique?"UNIQUE ":"")+"INDEX USING BTREE (`"+boost::algorithm::join(vindex, "`, `")+"`)"; 633 638 634 639 query +=
Note:
See TracChangeset
for help on using the changeset viewer.