Comments (1)
As far as I can see, this is the answer:
Assuming the library is compiled with foreign key constraints enabled, it must still be enabled by the application at runtime, using the PRAGMA foreign_keys command. For example:
sqlite> PRAGMA foreign_keys = ON;
Foreign key constraints are disabled by default (for backwards compatibility), so must be enabled separately for each database connection.
My grepping suggests that TMSU never enables the above pragma. I'm not sure what it is worth that entering PRAGMA foreign_keys;
to query the value returns 0 on a freshly initialized TMSU db, but I guess it counts as some evidence that it is not enabled by default on the database; I'm unsure whether 'enabled by default on the database' is a sensible possibility or not (maybe it's strictly the application runtime has to choose every time)
Now, it is the case that turning this pragma ON in sqlite3
has no immediate effects. I'm not interested in testing further, but given the description of how foreign key constraints work, you may find that turning the pragma ON and then making some modification to the file_tag table triggers an error.
from tmsu.
Related Issues (20)
- List all the tags with values HOT 11
- small contribution: sc-im interface for changing tmsu tags HOT 2
- Question: what does the error message mean? HOT 3
- --name=never removes lines HOT 2
- database locked occasionally
- VFS can be very slow
- Feature Request in VFS: Listing files outside of the `files` folder and hiding `queries` folder
- Cannot install TMSU HOT 1
- Package available in Void Linux
- too many SQL variables - transport endpoint is not connected when too many tag values exist
- Use unique indexes and upserts? HOT 1
- "tmsu init" ignores TMSU_DB environment variable
- release v0.8 HOT 2
- `tmsu tag -h` should be an alias for `tmsu help tag`
- `tmsu repair` should operate on the root or on `.` if no paths are given
- another app using the database? HOT 1
- Tags attributes HOT 3
- Unit tests are shaky: Fingerprint incorrect
- `tmsu help repair` message contains a typo
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tmsu.