comparison sat/memory/sqlite.py @ 3317:83f25da66bec

core (memory): files are now public by default except for those in root directory: using public permissions by default makes permissions change more easy as we don't have to recursively change all permissions of sub files when changing directory. Root directories are private by default.
author Goffi <goffi@goffi.org>
date Sat, 01 Aug 2020 16:02:41 +0200
parents 780fb8dd07ef
children be6d91572633
comparison
equal deleted inserted replaced
3316:5369ce5bcecf 3317:83f25da66bec
1424 'media_type,media_subtype', 1424 'media_type,media_subtype',
1425 "substr(mime_type, 0, instr(mime_type,'/')),substr(mime_type, instr(mime_type,'/')+1)" 1425 "substr(mime_type, 0, instr(mime_type,'/')),substr(mime_type, instr(mime_type,'/')+1)"
1426 ) 1426 )
1427 statements.extend([ 1427 statements.extend([
1428 f"INSERT INTO files({cols}) SELECT {old_cols} FROM files_old", 1428 f"INSERT INTO files({cols}) SELECT {old_cols} FROM files_old",
1429 f"DROP TABLE files_old", 1429 "DROP TABLE files_old",
1430 ]) 1430 ])
1431 statements.extend(Updater.indexData2Raw(index)) 1431 statements.extend(Updater.indexData2Raw(index))
1432 return statements 1432 return statements
1433 1433
1434 def update_v8(self): 1434 def update_v8(self):