/** @odoo-module **/
import { MockServer } from "./helpers/mock_server";
let data;
QUnit.module("MockServer", (hooks) => {
hooks.beforeEach(() => {
data = {
models: {
partner: {
fields: {
active: { string: "Active", type: "bool", default: true },
},
records: [
{ id: 1, name: "Jean-Michel" },
{ id: 2, name: "Raoul", active: false },
],
},
bar: {
fields: {
bool: { string: "Boolean", type: "boolean" },
date: { string: "Date", type: "date" },
datetime: { string: "DateTime", type: "datetime" },
foo: { string: "Foo", type: "integer" },
partner_id: { string: "Main buddy", type: "many2one", relation: "partner" },
partner_ids: { string: "Buddies", type: "many2many", relation: "partner" },
select: {
string: "Stage",
type: "selection",
selection: [
["new", "New"],
["dev", "Ongoing"],
["done", "Done"],
],
},
many2one_field: { type: "many2one", relation: "foo" },
one2many_field: {
type: "one2many",
relation: "foo",
inverse_fname_by_model_name: { foo: "many2one_field" },
},
many2many_field: {
type: "many2many",
relation: "foo",
inverse_fname_by_model_name: { foo: "many2many_field" },
},
partner_ref: {
type: "reference",
selection: [["partner", "Partner"]],
},
},
records: [
{
foo: 12,
bool: true,
date: "2016-12-14",
datetime: "2016-12-14 12:34:56",
name: "zzz",
partner_ids: [1, 2],
select: "dev",
partner_ref: "partner,1",
},
{
foo: 1,
bool: true,
date: "2016-10-26",
datetime: "2016-10-26 12:34:56",
name: "ddd",
partner_id: 2,
partner_ids: [1],
select: "new",
partner_ref: "partner,2",
},
{
foo: 17,
bool: false,
date: "2016-12-15",
datetime: "2016-12-15 12:34:56",
name: "xxx",
partner_ids: [2],
select: "done",
},
{
foo: 2,
bool: true,
date: "2016-04-11",
datetime: "2016-04-11 12:34:56",
name: "zzz",
partner_id: 1,
select: "new",
},
{
foo: 0,
bool: false,
date: "2016-12-15",
datetime: "2016-12-15 12:34:56",
name: "aaa",
select: "done",
},
{
foo: 42,
bool: true,
date: "2019-12-30",
datetime: "2019-12-30 12:34:56",
name: "mmm",
partner_id: 1,
select: "new",
},
],
},
foo: {
fields: {
one2many_field: {
type: "one2many",
relation: "bar",
inverse_fname_by_model_name: { bar: "many2one_field" },
},
many2one_field: {
type: "many2one",
relation: "bar",
inverse_fname_by_model_name: { bar: "one2many_field" },
},
many2many_field: {
type: "many2many",
relation: "bar",
inverse_fname_by_model_name: { bar: "many2many_field" },
},
many2one_reference: {
type: "many2one_reference",
model_name_ref_fname: "res_model",
inverse_fname_by_model_name: { bar: "one2many_field" },
},
res_model: { type: "char" },
},
records: [],
},
},
};
});
QUnit.test("performRPC: search with active_test=false", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "partner",
method: "search",
args: [[]],
kwargs: {
context: { active_test: false },
},
});
assert.deepEqual(result, [1, 2]);
});
QUnit.test("performRPC: search with active_test=true", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "partner",
method: "search",
args: [[]],
kwargs: {
context: { active_test: true },
},
});
assert.deepEqual(result, [1]);
});
QUnit.test("performRPC: search_read with active_test=false", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "partner",
method: "search_read",
args: [[]],
kwargs: {
fields: ["name"],
context: { active_test: false },
},
});
assert.deepEqual(result, [
{ id: 1, name: "Jean-Michel" },
{ id: 2, name: "Raoul" },
]);
});
QUnit.test("performRPC: search_read with active_test=true", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "partner",
method: "search_read",
args: [[]],
kwargs: {
fields: ["name"],
context: { active_test: true },
},
});
assert.deepEqual(result, [{ id: 1, name: "Jean-Michel" }]);
});
QUnit.test("performRPC: search_count", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "partner",
method: "search_count",
args: [[]],
kwargs: {},
});
assert.deepEqual(result, 1);
});
QUnit.test("performRPC: search_count with domain", async function (assert) {
data.models.partner.records.push({ id: 4, name: "José" });
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "partner",
method: "search_count",
args: [[["name", "=", "José"]]],
kwargs: {},
});
assert.deepEqual(result, 1);
});
QUnit.test("performRPC: search_count with domain matching no record", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "partner",
method: "search_count",
args: [[[0, "=", 1]]],
kwargs: {},
});
assert.deepEqual(result, 0);
});
QUnit.test("performRPC: search_count with archived records", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "partner",
method: "search_count",
args: [[]],
kwargs: {
context: { active_test: false },
},
});
assert.deepEqual(result, 2);
});
QUnit.test("performRPC: read_group, no group", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo"],
domain: [["foo", "=", -10]],
groupby: [],
},
});
assert.deepEqual(result, [{ __count: 0, foo: false, __domain: [["foo", "=", -10]] }]);
});
QUnit.test("performRPC: read_group, group by char", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["name"],
domain: [],
groupby: ["name"],
},
});
assert.deepEqual(result, [
{ name: "aaa", __domain: [["name", "=", "aaa"]], name_count: 1 },
{ name: "ddd", __domain: [["name", "=", "ddd"]], name_count: 1 },
{ name: "mmm", __domain: [["name", "=", "mmm"]], name_count: 1 },
{ name: "xxx", __domain: [["name", "=", "xxx"]], name_count: 1 },
{ name: "zzz", __domain: [["name", "=", "zzz"]], name_count: 2 },
]);
});
QUnit.test("performRPC: read_group, group by boolean", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["bool"],
domain: [],
groupby: ["bool"],
},
});
assert.deepEqual(result, [
{ bool: false, __domain: [["bool", "=", false]], bool_count: 2 },
{ bool: true, __domain: [["bool", "=", true]], bool_count: 4 },
]);
});
QUnit.test("performRPC: read_group, group by date", async function (assert) {
const server = new MockServer(data, {});
let result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo"],
domain: [],
groupby: ["date"], //Month by default
},
});
assert.deepEqual(
result.map((x) => x.date),
["April 2016", "October 2016", "December 2016", "December 2019"]
);
assert.deepEqual(
result.map((x) => x.date_count),
[1, 1, 3, 1]
);
assert.deepEqual(
result.map((x) => x.__domain),
[
[
["date", ">=", "2016-04-01"],
["date", "<", "2016-05-01"],
],
[
["date", ">=", "2016-10-01"],
["date", "<", "2016-11-01"],
],
[
["date", ">=", "2016-12-01"],
["date", "<", "2017-01-01"],
],
[
["date", ">=", "2019-12-01"],
["date", "<", "2020-01-01"],
],
]
);
assert.deepEqual(
result.map((x) => x.__range["date"]),
[
{ from: "2016-04-01", to: "2016-05-01" },
{ from: "2016-10-01", to: "2016-11-01" },
{ from: "2016-12-01", to: "2017-01-01" },
{ from: "2019-12-01", to: "2020-01-01" },
]
);
result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo"],
domain: [],
groupby: ["date:day"],
},
});
assert.deepEqual(
result.map((x) => x["date:day"]),
["2016-04-11", "2016-10-26", "2016-12-14", "2016-12-15", "2019-12-30"]
);
assert.deepEqual(
result.map((x) => x.date_count),
[1, 1, 1, 2, 1]
);
assert.deepEqual(
result.map((x) => x.__domain),
[
[
["date", ">=", "2016-04-11"],
["date", "<", "2016-04-12"],
],
[
["date", ">=", "2016-10-26"],
["date", "<", "2016-10-27"],
],
[
["date", ">=", "2016-12-14"],
["date", "<", "2016-12-15"],
],
[
["date", ">=", "2016-12-15"],
["date", "<", "2016-12-16"],
],
[
["date", ">=", "2019-12-30"],
["date", "<", "2019-12-31"],
],
]
);
assert.deepEqual(
result.map((x) => x.__range["date:day"]),
[
{ from: "2016-04-11", to: "2016-04-12" },
{ from: "2016-10-26", to: "2016-10-27" },
{ from: "2016-12-14", to: "2016-12-15" },
{ from: "2016-12-15", to: "2016-12-16" },
{ from: "2019-12-30", to: "2019-12-31" },
]
);
result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo"],
domain: [],
groupby: ["date:week"],
},
});
assert.deepEqual(
result.map((x) => x["date:week"]),
["W15 2016", "W43 2016", "W50 2016", "W01 2020"]
);
assert.deepEqual(
result.map((x) => x.date_count),
[1, 1, 3, 1]
);
assert.deepEqual(
result.map((x) => x.__domain),
[
[
["date", ">=", "2016-04-11"],
["date", "<", "2016-04-18"],
],
[
["date", ">=", "2016-10-24"],
["date", "<", "2016-10-31"],
],
[
["date", ">=", "2016-12-12"],
["date", "<", "2016-12-19"],
],
[
["date", ">=", "2019-12-30"],
["date", "<", "2020-01-06"],
],
]
);
assert.deepEqual(
result.map((x) => x.__range["date:week"]),
[
{ from: "2016-04-11", to: "2016-04-18" },
{ from: "2016-10-24", to: "2016-10-31" },
{ from: "2016-12-12", to: "2016-12-19" },
{ from: "2019-12-30", to: "2020-01-06" },
]
);
result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo"],
domain: [],
groupby: ["date:quarter"],
},
});
assert.deepEqual(
result.map((x) => x["date:quarter"]),
["Q2 2016", "Q4 2016", "Q4 2019"]
);
assert.deepEqual(
result.map((x) => x.date_count),
[1, 4, 1]
);
assert.deepEqual(
result.map((x) => x.__domain),
[
[
["date", ">=", "2016-04-01"],
["date", "<", "2016-07-01"],
],
[
["date", ">=", "2016-10-01"],
["date", "<", "2017-01-01"],
],
[
["date", ">=", "2019-10-01"],
["date", "<", "2020-01-01"],
],
]
);
assert.deepEqual(
result.map((x) => x.__range["date:quarter"]),
[
{ from: "2016-04-01", to: "2016-07-01" },
{ from: "2016-10-01", to: "2017-01-01" },
{ from: "2019-10-01", to: "2020-01-01" },
]
);
result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo"],
domain: [],
groupby: ["date:year"],
},
});
assert.deepEqual(
result.map((x) => x["date:year"]),
["2016", "2019"]
);
assert.deepEqual(
result.map((x) => x.date_count),
[5, 1]
);
assert.deepEqual(
result.map((x) => x.__domain),
[
[
["date", ">=", "2016-01-01"],
["date", "<", "2017-01-01"],
],
[
["date", ">=", "2019-01-01"],
["date", "<", "2020-01-01"],
],
]
);
assert.deepEqual(
result.map((x) => x.__range["date:year"]),
[
{ from: "2016-01-01", to: "2017-01-01" },
{ from: "2019-01-01", to: "2020-01-01" },
]
);
});
QUnit.test("performRPC: read_group, group by datetime", async function (assert) {
const server = new MockServer(data, {});
let result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo"],
domain: [],
groupby: ["datetime"], //Month by default
},
});
assert.deepEqual(
result.map((x) => x.datetime),
["April 2016", "October 2016", "December 2016", "December 2019"]
);
assert.deepEqual(
result.map((x) => x.datetime_count),
[1, 1, 3, 1]
);
assert.deepEqual(
result.map((x) => x.__domain),
[
[
["datetime", ">=", "2016-03-31 23:00:00"],
["datetime", "<", "2016-04-30 23:00:00"],
],
[
["datetime", ">=", "2016-09-30 23:00:00"],
["datetime", "<", "2016-10-31 23:00:00"],
],
[
["datetime", ">=", "2016-11-30 23:00:00"],
["datetime", "<", "2016-12-31 23:00:00"],
],
[
["datetime", ">=", "2019-11-30 23:00:00"],
["datetime", "<", "2019-12-31 23:00:00"],
],
]
);
assert.deepEqual(
result.map((x) => x.__range["datetime"]),
[
{ from: "2016-03-31 23:00:00", to: "2016-04-30 23:00:00" },
{ from: "2016-09-30 23:00:00", to: "2016-10-31 23:00:00" },
{ from: "2016-11-30 23:00:00", to: "2016-12-31 23:00:00" },
{ from: "2019-11-30 23:00:00", to: "2019-12-31 23:00:00" },
]
);
result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo"],
domain: [],
groupby: ["datetime:hour"],
},
});
assert.deepEqual(
result.map((x) => x["datetime:hour"]),
["13:00 11 Apr", "13:00 26 Oct", "13:00 14 Dec", "13:00 15 Dec", "13:00 30 Dec"]
);
assert.deepEqual(
result.map((x) => x.datetime_count),
[1, 1, 1, 2, 1]
);
assert.deepEqual(
result.map((x) => x.__domain),
[
[
["datetime", ">=", "2016-04-11 12:00:00"],
["datetime", "<", "2016-04-11 13:00:00"],
],
[
["datetime", ">=", "2016-10-26 12:00:00"],
["datetime", "<", "2016-10-26 13:00:00"],
],
[
["datetime", ">=", "2016-12-14 12:00:00"],
["datetime", "<", "2016-12-14 13:00:00"],
],
[
["datetime", ">=", "2016-12-15 12:00:00"],
["datetime", "<", "2016-12-15 13:00:00"],
],
[
["datetime", ">=", "2019-12-30 12:00:00"],
["datetime", "<", "2019-12-30 13:00:00"],
],
]
);
assert.deepEqual(
result.map((x) => x.__range["datetime:hour"]),
[
{ from: "2016-04-11 12:00:00", to: "2016-04-11 13:00:00" },
{ from: "2016-10-26 12:00:00", to: "2016-10-26 13:00:00" },
{ from: "2016-12-14 12:00:00", to: "2016-12-14 13:00:00" },
{ from: "2016-12-15 12:00:00", to: "2016-12-15 13:00:00" },
{ from: "2019-12-30 12:00:00", to: "2019-12-30 13:00:00" },
]
);
result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo"],
domain: [],
groupby: ["datetime:day"],
},
});
assert.deepEqual(
result.map((x) => x["datetime:day"]),
["2016-04-11", "2016-10-26", "2016-12-14", "2016-12-15", "2019-12-30"]
);
assert.deepEqual(
result.map((x) => x.datetime_count),
[1, 1, 1, 2, 1]
);
assert.deepEqual(
result.map((x) => x.__domain),
[
[
["datetime", ">=", "2016-04-10 23:00:00"],
["datetime", "<", "2016-04-11 23:00:00"],
],
[
["datetime", ">=", "2016-10-25 23:00:00"],
["datetime", "<", "2016-10-26 23:00:00"],
],
[
["datetime", ">=", "2016-12-13 23:00:00"],
["datetime", "<", "2016-12-14 23:00:00"],
],
[
["datetime", ">=", "2016-12-14 23:00:00"],
["datetime", "<", "2016-12-15 23:00:00"],
],
[
["datetime", ">=", "2019-12-29 23:00:00"],
["datetime", "<", "2019-12-30 23:00:00"],
],
]
);
assert.deepEqual(
result.map((x) => x.__range["datetime:day"]),
[
{ from: "2016-04-10 23:00:00", to: "2016-04-11 23:00:00" },
{ from: "2016-10-25 23:00:00", to: "2016-10-26 23:00:00" },
{ from: "2016-12-13 23:00:00", to: "2016-12-14 23:00:00" },
{ from: "2016-12-14 23:00:00", to: "2016-12-15 23:00:00" },
{ from: "2019-12-29 23:00:00", to: "2019-12-30 23:00:00" },
]
);
result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo"],
domain: [],
groupby: ["datetime:week"],
},
});
assert.deepEqual(
result.map((x) => x["datetime:week"]),
["W15 2016", "W43 2016", "W50 2016", "W01 2020"]
);
assert.deepEqual(
result.map((x) => x.datetime_count),
[1, 1, 3, 1]
);
assert.deepEqual(
result.map((x) => x.__domain),
[
[
["datetime", ">=", "2016-04-10 23:00:00"],
["datetime", "<", "2016-04-17 23:00:00"],
],
[
["datetime", ">=", "2016-10-23 23:00:00"],
["datetime", "<", "2016-10-30 23:00:00"],
],
[
["datetime", ">=", "2016-12-11 23:00:00"],
["datetime", "<", "2016-12-18 23:00:00"],
],
[
["datetime", ">=", "2019-12-29 23:00:00"],
["datetime", "<", "2020-01-05 23:00:00"],
],
]
);
assert.deepEqual(
result.map((x) => x.__range["datetime:week"]),
[
{ from: "2016-04-10 23:00:00", to: "2016-04-17 23:00:00" },
{ from: "2016-10-23 23:00:00", to: "2016-10-30 23:00:00" },
{ from: "2016-12-11 23:00:00", to: "2016-12-18 23:00:00" },
{ from: "2019-12-29 23:00:00", to: "2020-01-05 23:00:00" },
]
);
result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo"],
domain: [],
groupby: ["datetime:quarter"],
},
});
assert.deepEqual(
result.map((x) => x["datetime:quarter"]),
["Q2 2016", "Q4 2016", "Q4 2019"]
);
assert.deepEqual(
result.map((x) => x.datetime_count),
[1, 4, 1]
);
assert.deepEqual(
result.map((x) => x.__domain),
[
[
["datetime", ">=", "2016-03-31 23:00:00"],
["datetime", "<", "2016-06-30 23:00:00"],
],
[
["datetime", ">=", "2016-09-30 23:00:00"],
["datetime", "<", "2016-12-31 23:00:00"],
],
[
["datetime", ">=", "2019-09-30 23:00:00"],
["datetime", "<", "2019-12-31 23:00:00"],
],
]
);
assert.deepEqual(
result.map((x) => x.__range["datetime:quarter"]),
[
{ from: "2016-03-31 23:00:00", to: "2016-06-30 23:00:00" },
{ from: "2016-09-30 23:00:00", to: "2016-12-31 23:00:00" },
{ from: "2019-09-30 23:00:00", to: "2019-12-31 23:00:00" },
]
);
result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo"],
domain: [],
groupby: ["datetime:year"],
},
});
assert.deepEqual(
result.map((x) => x["datetime:year"]),
["2016", "2019"]
);
assert.deepEqual(
result.map((x) => x.datetime_count),
[5, 1]
);
assert.deepEqual(
result.map((x) => x.__domain),
[
[
["datetime", ">=", "2015-12-31 23:00:00"],
["datetime", "<", "2016-12-31 23:00:00"],
],
[
["datetime", ">=", "2018-12-31 23:00:00"],
["datetime", "<", "2019-12-31 23:00:00"],
],
]
);
assert.deepEqual(
result.map((x) => x.__range["datetime:year"]),
[
{ from: "2015-12-31 23:00:00", to: "2016-12-31 23:00:00" },
{ from: "2018-12-31 23:00:00", to: "2019-12-31 23:00:00" },
]
);
});
QUnit.test("performRPC: read_group, group by m2m", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["partner_ids"],
domain: [],
groupby: ["partner_ids"],
},
});
assert.deepEqual(result, [
{ partner_ids: false, __domain: [["partner_ids", "=", false]], partner_ids_count: 3 },
{
partner_ids: [1, "Jean-Michel"],
__domain: [["partner_ids", "=", 1]],
partner_ids_count: 2,
},
{
partner_ids: [2, "Raoul"],
__domain: [["partner_ids", "=", 2]],
partner_ids_count: 2,
},
]);
});
QUnit.test("performRPC: read_group, group by m2o", async function (assert) {
data.models.partner.fields.sequence = { type: "integer" };
data.models.partner.records[0].sequence = 1;
data.models.partner.records[1].sequence = 0;
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["partner_id"],
domain: [],
groupby: ["partner_id"],
},
});
assert.deepEqual(result, [
{ partner_id: false, __domain: [["partner_id", "=", false]], partner_id_count: 3 },
{ partner_id: [2, "Raoul"], __domain: [["partner_id", "=", 2]], partner_id_count: 1 },
{
partner_id: [1, "Jean-Michel"],
__domain: [["partner_id", "=", 1]],
partner_id_count: 2,
},
]);
});
QUnit.test("performRPC: read_group, group by integer", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo"],
domain: [],
groupby: ["foo"],
},
});
assert.deepEqual(result, [
{
__domain: [["foo", "=", 0]],
foo: 0,
foo_count: 1,
},
{
__domain: [["foo", "=", 1]],
foo: 1,
foo_count: 1,
},
{
__domain: [["foo", "=", 2]],
foo: 2,
foo_count: 1,
},
{
__domain: [["foo", "=", 12]],
foo: 12,
foo_count: 1,
},
{
__domain: [["foo", "=", 17]],
foo: 17,
foo_count: 1,
},
{
__domain: [["foo", "=", 42]],
foo: 42,
foo_count: 1,
},
]);
});
QUnit.test("performRPC: read_group, group by selection", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["select"],
domain: [],
groupby: ["select"],
},
});
assert.deepEqual(result, [
{ select: "new", __domain: [["select", "=", "new"]], select_count: 3 },
{ select: "dev", __domain: [["select", "=", "dev"]], select_count: 1 },
{ select: "done", __domain: [["select", "=", "done"]], select_count: 2 },
]);
});
QUnit.test("performRPC: read_group, group by two levels", async function (assert) {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["bool", "partner_ids"],
domain: [],
groupby: ["bool", "partner_ids"],
lazy: false,
},
});
assert.deepEqual(result, [
{
__domain: [
["partner_ids", "=", false],
["bool", "=", false],
],
__count: 1,
bool: false,
partner_ids: false,
},
{
__domain: [
["partner_ids", "=", 2],
["bool", "=", false],
],
__count: 1,
bool: false,
partner_ids: [2, "Raoul"],
},
{
__domain: [
["partner_ids", "=", false],
["bool", "=", true],
],
__count: 2,
bool: true,
partner_ids: false,
},
{
__domain: [
["partner_ids", "=", 1],
["bool", "=", true],
],
__count: 2,
bool: true,
partner_ids: [1, "Jean-Michel"],
},
{
__domain: [
["partner_ids", "=", 2],
["bool", "=", true],
],
__count: 1,
bool: true,
partner_ids: [2, "Raoul"],
},
]);
});
QUnit.test(
"performRPC: read_group with special measure specifications",
async function (assert) {
data.models.bar.fields.float = { string: "Float", type: "float" };
data.models.bar.records[0].float = 2;
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["float:sum", "foo_sum:sum(foo)"],
domain: [],
groupby: ["bool"],
lazy: false,
},
});
assert.deepEqual(result, [
{
__count: 2,
__domain: [["bool", "=", false]],
bool: false,
float: 0,
foo_sum: 17,
},
{
__count: 4,
__domain: [["bool", "=", true]],
bool: true,
float: 2,
foo_sum: 57,
},
]);
}
);
QUnit.test("performRPC: read_group with array_agg", async function (assert) {
const server = new MockServer(data, {});
const aggregateValue = [null, 2, null, 1, null, 1];
const result1 = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["aggregateLabel:array_agg(partner_id)"],
domain: [],
groupby: [],
},
});
assert.deepEqual(result1, [
{
__count: 6,
__domain: [],
aggregateLabel: aggregateValue,
},
]);
const result2 = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["partner_id:array_agg"],
domain: [],
groupby: [],
},
});
assert.deepEqual(result2, [
{
__count: 6,
__domain: [],
partner_id: aggregateValue,
},
]);
});
QUnit.test("performRPC: read_group with array_agg on id", async function (assert) {
const server = new MockServer(data, {});
const result1 = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["aggregateLabel:array_agg(id)"],
domain: [],
groupby: [],
},
});
assert.deepEqual(result1, [
{
__count: 6,
__domain: [],
aggregateLabel: [1, 2, 3, 4, 5, 6],
},
]);
const result2 = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["id:array_agg"],
domain: [["id", "in", [2, 3, 5]]],
groupby: [],
},
});
assert.deepEqual(result2, [
{
__count: 3,
__domain: [["id", "in", [2, 3, 5]]],
id: [2, 3, 5],
},
]);
});
QUnit.test(
"performRPC: read_group with array_agg on an integer field",
async function (assert) {
const server = new MockServer(data, {});
const aggregateValue = [12, 1, 17, 2, 0, 42];
const result1 = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["aggregateLabel:array_agg(foo)"],
domain: [],
groupby: [],
},
});
assert.deepEqual(result1, [
{
__count: 6,
__domain: [],
aggregateLabel: aggregateValue,
},
]);
const result2 = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["foo:array_agg"],
domain: [],
groupby: [],
},
});
assert.deepEqual(result2, [
{
__count: 6,
__domain: [],
foo: aggregateValue,
},
]);
}
);
QUnit.test("performRPC: read_group with count_distinct", async function (assert) {
const server = new MockServer(data, {});
const result1 = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["aggregateLabel:count_distinct(partner_id)"],
domain: [],
groupby: [],
},
});
assert.deepEqual(result1, [
{
__count: 6,
__domain: [],
aggregateLabel: 2,
},
]);
const result2 = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["partner_id:count_distinct"],
domain: [],
groupby: [],
},
});
assert.deepEqual(result2, [
{
__count: 6,
__domain: [],
partner_id: 2,
},
]);
const result3 = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["partner_id:count_distinct"],
domain: [[0, "=", 1]],
groupby: [],
},
});
assert.deepEqual(result3, [
{
__count: 0,
__domain: [[0, "=", 1]],
partner_id: 0,
},
]);
const result4 = await server.performRPC("", {
model: "bar",
method: "read_group",
args: [[]],
kwargs: {
fields: ["partner_ref:count_distinct"],
domain: [],
groupby: [],
},
});
assert.deepEqual(result4, [
{
__count: 6,
__domain: [],
partner_ref: 2,
},
]);
});
QUnit.test("performRPC: read_progress_bar grouped by boolean", async (assert) => {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "bar",
method: "read_progress_bar",
args: [],
kwargs: {
domain: [],
group_by: "bool",
progress_bar: {
colors: { new: "success", dev: "warning", done: "danger" },
field: "select",
},
},
});
assert.deepEqual(result, {
False: { new: 0, dev: 0, done: 2 },
True: { new: 3, dev: 1, done: 0 },
});
});
QUnit.test("performRPC: read_progress_bar grouped by datetime", async (assert) => {
const server = new MockServer(data, {});
const result = await server.performRPC("", {
model: "bar",
method: "read_progress_bar",
args: [],
kwargs: {
domain: [],
group_by: "datetime:week",
progress_bar: {
colors: { new: "aaa", dev: "bbb", done: "ccc" },
field: "select",
},
},
});
assert.deepEqual(result, {
"W01 2020": { dev: 0, done: 0, new: 1 },
"W15 2016": { dev: 0, done: 0, new: 1 },
"W43 2016": { dev: 0, done: 0, new: 1 },
"W50 2016": { dev: 1, done: 2, new: 0 },
});
});
QUnit.test("many2one_ref should auto fill inverse field", async function (assert) {
data.models.bar.records = [{ id: 1 }];
data.models.foo.records = [
{
id: 2,
res_model: "bar",
many2one_reference: 1,
},
];
const mockServer = new MockServer(data);
assert.deepEqual(mockServer.models.bar.records[0].one2many_field, [2]);
mockServer.mockUnlink("foo", [2]);
assert.deepEqual(mockServer.models.bar.records[0].one2many_field, []);
});
QUnit.test("many2one should auto fill inverse field", async function (assert) {
data.models.bar.records = [{ id: 1 }];
data.models.foo.records = [
{
id: 2,
many2one_field: 1,
},
];
const mockServer = new MockServer(data);
assert.deepEqual(mockServer.models.bar.records[0].one2many_field, [2]);
mockServer.mockUnlink("foo", [2]);
assert.deepEqual(mockServer.models.bar.records[0].one2many_field, []);
});
QUnit.test("one2many should auto fill inverse field", async function (assert) {
data.models.bar.records = [{ id: 1 }, { id: 2 }];
data.models.foo.records = [
{
id: 3,
one2many_field: [1, 2],
},
];
const mockServer = new MockServer(data);
assert.strictEqual(mockServer.models.bar.records[0].many2one_field, 3);
assert.strictEqual(mockServer.models.bar.records[1].many2one_field, 3);
mockServer.mockUnlink("foo", [3]);
assert.strictEqual(mockServer.models.bar.records[0].many2one_field, false);
assert.strictEqual(mockServer.models.bar.records[1].many2one_field, false);
});
QUnit.test("many2many should auto fill inverse field", async function (assert) {
data.models.bar.records = [{ id: 1 }];
data.models.foo.records = [
{
id: 2,
many2many_field: [1],
},
];
const mockServer = new MockServer(data);
assert.deepEqual(mockServer.models.bar.records[0].many2many_field, [2]);
mockServer.mockUnlink("foo", [2]);
assert.deepEqual(mockServer.models.bar.records[0].many2many_field, []);
});
QUnit.test("one2many update should update inverse field", async function (assert) {
data.models.bar.records = [{ id: 1 }, { id: 2 }];
data.models.foo.records = [
{
id: 3,
one2many_field: [1, 2],
},
];
const mockServer = new MockServer(data);
mockServer.mockWrite("foo", [[3], { one2many_field: [1] }]);
assert.strictEqual(mockServer.models.bar.records[0].many2one_field, 3);
assert.strictEqual(mockServer.models.bar.records[1].many2one_field, false);
});
QUnit.test("many2many update should update inverse field", async function (assert) {
data.models.bar.records = [{ id: 1 }];
data.models.foo.records = [
{
id: 2,
many2many_field: [1],
},
];
const mockServer = new MockServer(data);
mockServer.mockWrite("foo", [[2], { many2many_field: [] }]); // save nothing
assert.deepEqual(mockServer.models.bar.records[0].many2many_field, [2]);
});
QUnit.test("many2one update should update inverse field", async function (assert) {
data.models.bar.records = [{ id: 1 }];
data.models.foo.records = [
{
id: 2,
many2one_field: 1,
},
];
const mockServer = new MockServer(data);
mockServer.mockWrite("foo", [[2], { many2one_field: false }]);
assert.deepEqual(mockServer.models.bar.records[0].one2many_field, []);
});
QUnit.test("many2one_ref update should update inverse field", async function (assert) {
data.models.bar.records = [{ id: 1 }];
data.models.foo.records = [
{
id: 2,
res_model: "bar",
many2one_reference: 1,
},
];
const mockServer = new MockServer(data);
mockServer.mockWrite("foo", [[2], { many2one_reference: false }]);
assert.deepEqual(mockServer.models.bar.records[0].one2many_field, []);
});
QUnit.test("webRead sub-fields of a many2one field", async function (assert) {
data.models.partner.fields.test_name = { string: "Test Name", type: "char" };
data.models.partner.fields.test_number = { string: "Number", type: "integer" };
data.models.partner.records = [{ id: 1, test_name: "Jean-Michel", test_number: 5 }];
data.models.bar.records = [{ id: 1, partner_id: 1 }];
const mockServer = new MockServer(data);
const result = mockServer.mockWebRead("bar", [[1]], {
specification: { partner_id: { fields: { test_name: {}, test_number: {} } } },
});
assert.deepEqual(result, [
{ id: 1, partner_id: { id: 1, test_name: "Jean-Michel", test_number: 5 } },
]);
});
QUnit.test("List View: invisible on processed Arch", async function (assert) {
data.views = {
"bar,10001,list": `