davidmartos96
commented
4 years ago Sorry @jlcool but I stopped working on this. I've never tried it on macos. If you want to use SqlCipher on desktop, this is what I'm using now.
- Install
moor_ffi - Override the sqflite native library in
main - Use a custom
DelegatedDatabaseto open moor db with password - Bundle the native sqlcipher libraries in the project (.so, .dylib and .dll files)
It works great on Linux and Windows. I don't own a Mac. But if you are able to run it on Mac with my setup it would be great to know :smile:
import 'package:moor_ffi/open_helper.dart';
Future<void> main() async {
debugDefaultTargetPlatformOverride = TargetPlatform.fuchsia;
open.overrideForAll(sqlcipherOpen);
runApp(MyApp());
}
DynamicLibrary sqlcipherOpen() {
return _dlopenPlatformSpecific(
'sqlcipher',
path: p.join(
Directory(Platform.resolvedExecutable).parent.path,
"./", // End with slash
),
);
}
DynamicLibrary _dlopenPlatformSpecific(String name, {String path}) {
final String fullPath = _platformPath(name, path: path);
return DynamicLibrary.open(fullPath);
}
String _platformPath(String name, {String path = ''}) {
if (Platform.isMacOS) {
return "${path}lib$name.dylib";
}
if (Platform.isLinux || Platform.isAndroid) {
return "${path}lib$name.so";
}
if (Platform.isWindows) {
return "$path$name.dll";
}
throw Exception("Platform not implemented");
}
class MyDatabase extends _$MyDatabase {
// we tell the database where to store the data with this constructor
MyDatabase(Directory directory)
: super(
VmDatabaseEncrypted(
File(path.join(directory.path, "$DB_NAME")),
password: "mypassword",
logStatements: true,
),
);import 'dart:async';
import 'dart:io';
import 'package:moor/backends.dart';
import 'package:moor/moor.dart';
import 'package:moor_ffi/moor_ffi.dart';
class VmDatabaseEncrypted extends DelegatedDatabase {
/// Creates a database that will store its result in the [file], creating it
/// if it doesn't exist.
factory VmDatabaseEncrypted(
File file, {
String password = '',
bool logStatements = false,
}) {
final vmDatabase = VmDatabase(file, logStatements: logStatements);
return VmDatabaseEncrypted._(vmDatabase, password);
}
factory VmDatabaseEncrypted.memory({
String password = '',
bool logStatements = false,
}) {
final vmDatabase = VmDatabase.memory(logStatements: logStatements);
return VmDatabaseEncrypted._(vmDatabase, password);
}
VmDatabaseEncrypted._(
VmDatabase vmDatabase,
this.password,
) : super(
_VmEncryptedDelegate(vmDatabase.delegate, password),
logStatements: vmDatabase.logStatements,
isSequential: vmDatabase.isSequential,
);
final String password;
}
class _VmEncryptedDelegate extends DatabaseDelegate {
final String password;
final DatabaseDelegate delegate;
_VmEncryptedDelegate(
this.delegate,
this.password,
);
@override
Future<void> open(QueryExecutorUser db) async {
await delegate.open(db);
await delegate.runCustom('PRAGMA KEY = "$password"', <dynamic>[]);
return Future.value();
}
@override
FutureOr<bool> get isOpen => delegate.isOpen;
@override
Future<void> runBatched(BatchedStatements statements) {
return delegate.runBatched(statements);
}
@override
Future<void> runCustom(String statement, List args) {
return delegate.runCustom(statement, args);
}
@override
Future<int> runInsert(String statement, List args) {
return delegate.runInsert(statement, args);
}
@override
Future<QueryResult> runSelect(String statement, List args) {
return delegate.runSelect(statement, args);
}
@override
Future<int> runUpdate(String statement, List args) {
return runUpdate(statement, args);
}
@override
TransactionDelegate get transactionDelegate => delegate.transactionDelegate;
@override
DbVersionDelegate get versionDelegate => delegate.versionDelegate;
}
jlcool
ld: warning: directory not found for option '-Lbuild/outputs/darwin' ld: warning: directory not found for option '-Fbuild/outputs/darwin' ld: library not found for -lcrypto clang: error: linker command failed with exit code 1 (use -v to see invocation) hover: Go build failed: exit status 2