blob: 91efe13cdcf3b835437c19975aa0b7584b42001c [file] [log] [blame]
// Copyright (c) 2019, the Dart project authors. Please see the AUTHORS file
// for details. All rights reserved. Use of this source code is governed by a
// BSD-style license that can be found in the LICENSE file.
// @dart = 2.9
// VMOptions=--optimization-counter-threshold=5
import "dart:ffi";
import "dart:io";
import "package:ffi/ffi.dart";
import "package:test/test.dart";
import '../lib/sqlite.dart';
void main() {
final dbPath = Platform.script.resolve("test.db").path;
test("sqlite integration test", () {
Database d = Database(dbPath);
d.execute("drop table if exists Cookies;");
d.execute("""
create table Cookies (
id integer primary key,
name text not null,
alternative_name text
);""");
d.execute("""
insert into Cookies (id, name, alternative_name)
values
(1,'Chocolade chip cookie', 'Chocolade cookie'),
(2,'Ginger cookie', null),
(3,'Cinnamon roll', null)
;""");
Result result = d.query("""
select
id,
name,
alternative_name,
case
when id=1 then 'foo'
when id=2 then 42
when id=3 then null
end as multi_typed_column
from Cookies
;""");
for (Row r in result) {
int id = r.readColumnAsInt("id");
expect(true, 1 <= id && id <= 3);
String name = r.readColumnByIndex(1);
expect(true, name is String);
String alternativeName = r.readColumn("alternative_name");
expect(true, alternativeName is String || alternativeName == null);
dynamic multiTypedValue = r.readColumn("multi_typed_column");
expect(
true,
multiTypedValue == 42 ||
multiTypedValue == 'foo' ||
multiTypedValue == null);
print("$id $name $alternativeName $multiTypedValue");
}
result = d.query("""
select
id,
name,
alternative_name,
case
when id=1 then 'foo'
when id=2 then 42
when id=3 then null
end as multi_typed_column
from Cookies
;""");
for (Row r in result) {
int id = r.readColumnAsInt("id");
expect(true, 1 <= id && id <= 3);
String name = r.readColumnByIndex(1);
expect(true, name is String);
String alternativeName = r.readColumn("alternative_name");
expect(true, alternativeName is String || alternativeName == null);
dynamic multiTypedValue = r.readColumn("multi_typed_column");
expect(
true,
multiTypedValue == 42 ||
multiTypedValue == 'foo' ||
multiTypedValue == null);
print("$id $name $alternativeName $multiTypedValue");
if (id == 2) {
result.close();
break;
}
}
try {
result.iterator.moveNext();
} on SQLiteException catch (e) {
print("expected exception on accessing result data after close: $e");
}
try {
d.query("""
select
id,
non_existing_column
from Cookies
;""");
} on SQLiteException catch (e) {
print("expected this query to fail: $e");
}
d.execute("drop table Cookies;");
d.close();
});
test("concurrent db open and queries", () {
Database d = Database(dbPath);
Database d2 = Database(dbPath);
d.execute("drop table if exists Cookies;");
d.execute("""
create table Cookies (
id integer primary key,
name text not null,
alternative_name text
);""");
d.execute("""
insert into Cookies (id, name, alternative_name)
values
(1,'Chocolade chip cookie', 'Chocolade cookie'),
(2,'Ginger cookie', null),
(3,'Cinnamon roll', null)
;""");
Result r = d.query("select * from Cookies;");
Result r2 = d2.query("select * from Cookies;");
r.iterator..moveNext();
r2.iterator..moveNext();
r.iterator..moveNext();
Result r3 = d2.query("select * from Cookies;");
r3.iterator..moveNext();
expect(2, r.iterator.current.readColumn("id"));
expect(1, r2.iterator.current.readColumn("id"));
expect(1, r3.iterator.current.readColumn("id"));
r.close();
r2.close();
r3.close();
d.close();
d2.close();
});
test("stress test", () {
Database d = Database(dbPath);
d.execute("drop table if exists Cookies;");
d.execute("""
create table Cookies (
id integer primary key,
name text not null,
alternative_name text
);""");
int repeats = 100;
for (int i = 0; i < repeats; i++) {
d.execute("""
insert into Cookies (name, alternative_name)
values
('Chocolade chip cookie', 'Chocolade cookie'),
('Ginger cookie', null),
('Cinnamon roll', null)
;""");
}
Result r = d.query("select count(*) from Cookies;");
int count = r.first.readColumnByIndexAsInt(0);
expect(count, 3 * repeats);
r.close();
d.close();
});
test("Utf8 unit test", () {
final String test = 'Hasta MaƱana';
final medium = test.toNativeUtf8();
expect(test, medium.toDartString());
calloc.free(medium);
});
}