Patrick Shanahan (2018-Sep-24, excerpt):
> * [email protected] <[email protected]> [09-24-18 06:00]:
> > Hmmm, Patrick, does your comment answer my question? Or did it relate
> > to something else? I'm not sure:
> >
> > Patrick Shanahan (2018-Sep-23, excerpt):
> > ...
> > > > > > So for me it's three styles. I want to delete the one with id 2:
> > > > > >
> > > > > > sqlite> delete from styles where id = 2;
> > ...
> > > > > > So I guess that's what Patrick suggested. But this has only deleted
> > > > > > the (id, name, description) triplet. Where is the actual style
> > > > > > definition? Is that in style_items? I don't know...
> > ...
> > > no, you must import styles. but once you import them they are available
> > > for use until you delete them.
> >
> > Let me state my question again:
> >
> > The style information must be somewhere, but I'm sure I have not yet
> > deleted it with above recipe. Or does this trigger deletion due to DB
> > constraints? Or do I need to explicitly delete something else?
>
> you must import the styles before they become available in dt. then the
> styles and their information is retained in ~/.control/darktable/data.db.
> removing the style data using sqlite or sqlite browser from data.db
> negates the previous import action and the styles will no longer be
> available in dt. has nothing to do with the directory where you store
> those styles.
>
> and you will have "explicitly" deleted something, the data-base
> information.
$ sqlite3 .config/darktable/data.db
sqlite> .schema styles
CREATE TABLE styles (id INTEGER, name VARCHAR, description VARCHAR);
If I delete a row from the `styles` table, then *only* the triplet
(id, name, description) is removed from the database. The information
that actually constitutes the style is *not* deleted, because it is
not contained in that triplet.
I agree, it's not visible in DT anymore.
I could imagine (but I do not know, and that's the gist of my
question) that the style information is in the table `style_items`,
and that it might be referenced from the `styles` table by its
attribute `styleid`.
sqlite> .schema style_items
CREATE TABLE style_items (styleid INTEGER, num INTEGER, module INTEGER,
operation VARCHAR(256), op_params BLOB, enabled INTEGER, blendop_params BLOB,
blendop_version INTEGER, multi_priority INTEGER, multi_name VARCHAR(256));
If that was the case, one would also need to
sqlite> delete from style_items where styleid = 2;
to delete the data imported from the style file — under the assumption
that `2` refers to the style to delete.
Is that so?
If yes: Is there any other place where imported style info is stored?
If no: Then where is the actual style data?
--
http://stefan-klinger.de o/X
I prefer receiving plain text messages, not exceeding 32kB. /\/
\
____________________________________________________________________________
darktable user mailing list
to unsubscribe send a mail to [email protected]
