Closed Bug 403377 Opened 17 years ago Closed 10 years ago

add method for creating indices to mozIStorageConnection

Categories

(Toolkit :: Storage, enhancement)

Product:
Toolkit
Component:
Storage
Type:
enhancement
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED WONTFIX

People

(Reporter: myk, Unassigned)

Details

It would be useful for mozIStorageConnection to have a method for creating indices.  It's possible to do so using executeSimpleSQL (which is what I use in my patch on bug 403375), but it would be easier if there were a method in the interface, just as the interface has a method for creating tables.

The method could take an index name, table name, array of columns, and a boolean that indicated whether or not to die if the index already exists (i.e. the equivalent of the IF NOT EXISTS clause to the CREATE INDEX statement).
it's easy enough to run a simple query to create an index, abstracting any Sqlite functionality is not in the plans, especially in the new async API.
Status: NEW → RESOLVED
Closed: 10 years ago
Resolution: --- → WONTFIX
You need to log in before you can comment on or make changes to this bug.