def test_transform_concat(self):
nodes = {
"table":
"tableau",
"columns": [
"id",
"code",
"level",
],
"children": [
{
"table": "Child1",
"columns": [
"column_1",
"column_2",
],
"relationship": {
"variant": "object",
"type": "one_to_one",
},
"transform": {
"concat": {
"columns": ["column_1", "column_2"],
"destination": "column_3",
"delimiter": "_",
}
},
},
{
"table": "Child2",
"columns": [
"column1",
"column2",
],
"relationship": {
"variant": "object",
"type": "one_to_many",
},
"transform": {
"concat": {
"columns": ["column1"],
"destination": "column3",
"delimiter": "-",
}
},
},
{
"table": "Child3",
"columns": [
"column_1",
"column_2",
],
"relationship": {
"variant": "object",
"type": "one_to_many",
},
"transform": {
"concat": {
"columns": ["column_1", "column_2"],
"destination": "column_9",
"delimiter": "@",
}
},
},
],
"transform": {
"concat": {
"columns": ["id", "level"],
"destination": "column_x",
"delimiter": "=",
}
},
}
row = {
"level":
1,
"id":
"007",
"code":
"be",
"Child1": [
{
"column_1": 2,
"column_2": "aa"
},
{
"column_1": 3,
"column_2": "bb"
},
],
"Child2": [
{
"column1": 2,
"column2": "cc"
},
{
"column1": 3,
"column2": "dd"
},
],
"Child3": {
"column_1": 4,
"column_2": "ee",
},
}
row = transform(row, nodes)
assert row == {
"Child1": [
{
"column_1": 2,
"column_2": "aa",
"column_3": "2_aa"
},
{
"column_1": 3,
"column_2": "bb",
"column_3": "3_bb"
},
],
"Child2": [
{
"column1": 2,
"column2": "cc",
"column3": "2"
},
{
"column1": 3,
"column2": "dd",
"column3": "3"
},
],
"Child3": {
"column_1": 4,
"column_2": "ee",
"column_9": "4@ee"
},
"code":
"be",
"column_x":
"007=1",
"id":
"007",
"level":
1,
}
def test_transform_concat(self):
node = {
'table': 'tableau',
'columns': [
'id',
'code',
'level',
],
'children': [
{
'table': 'Child1',
'columns': [
'column_1',
'column_2',
],
'relationship': {
'variant': 'object',
'type': 'one_to_one',
},
'transform': {
'concat': {
'columns': ['column_1', 'column_2'],
'destination': 'column_3',
'delimiter': '_',
}
}
},
{
'table': 'Child2',
'columns': [
'column1',
'column2',
],
'relationship': {
'variant': 'object',
'type': 'one_to_many',
},
'transform': {
'concat': {
'columns': ['column1'],
'destination': 'column3',
'delimiter': '-',
}
}
},
{
'table': 'Child3',
'columns': [
'column_1',
'column_2',
],
'relationship': {
'variant': 'object',
'type': 'one_to_many',
},
'transform': {
'concat': {
'columns': ['column_1', 'column_2'],
'destination': 'column_9',
'delimiter': '@',
}
}
}
],
'transform': {
'concat': {
'columns': ['id', 'level'],
'destination': 'column_x',
'delimiter': '=',
}
}
}
row = {
'level': 1,
'id': '007',
'code': 'be',
'Child1': [
{'column_1': 2, 'column_2': 'aa'},
{'column_1': 3, 'column_2': 'bb'},
],
'Child2': [
{'column1': 2, 'column2': 'cc'},
{'column1': 3, 'column2': 'dd'},
],
'Child3': {
'column_1': 4,
'column_2': 'ee',
},
}
row = transform(row, node)
assert row == {
'Child1': [
{'column_1': 2, 'column_2': 'aa', 'column_3': '2_aa'},
{'column_1': 3, 'column_2': 'bb', 'column_3': '3_bb'},
],
'Child2': [
{'column1': 2, 'column2': 'cc', 'column3': '2'},
{'column1': 3, 'column2': 'dd', 'column3': '3'},
],
'Child3': {'column_1': 4, 'column_2': 'ee', 'column_9': '4@ee'},
'code': 'be',
'column_x': '1=007',
'id': '007',
'level': 1,
}
def test_transform_rename(self):
nodes = {
"table":
"tableau",
"columns": [
"id",
"code",
"level",
],
"children": [
{
"table": "child_1",
"columns": [
"column_1",
"column_2",
],
"label": "Child1",
"relationship": {
"variant": "object",
"type": "one_to_one",
},
"transform": {
"rename": {
"column_1": "column1"
}
},
},
{
"table": "child_2",
"columns": [
"column_1",
"column_2",
],
"label": "Child2",
"relationship": {
"variant": "object",
"type": "one_to_many",
},
"transform": {
"rename": {
"column_2": "column2"
}
},
},
],
"transform": {
"rename": {
"id": "my_id",
"code": "my_code",
"level": "levelup",
}
},
}
row = {
"level":
1,
"id":
"007",
"code":
"be",
"Child1": [
{
"column_1": 2,
"column_2": "aa"
},
{
"column_1": 3,
"column_2": "bb"
},
],
"Child2": [
{
"column_1": 2,
"column_2": "aa"
},
{
"column_1": 3,
"column_2": "bb"
},
],
}
row = transform(row, nodes)
assert row == {
"Child1": [
{
"column1": 2,
"column_2": "aa"
},
{
"column1": 3,
"column_2": "bb"
},
],
"Child2": [
{
"column2": "aa",
"column_1": 2
},
{
"column2": "bb",
"column_1": 3
},
],
"levelup":
1,
"my_code":
"be",
"my_id":
"007",
}
def test_transform_rename(self):
node = {
'table': 'tableau',
'columns': [
'id',
'code',
'level',
],
'children': [
{
'table': 'child_1',
'columns': [
'column_1',
'column_2',
],
'label': 'Child1',
'relationship': {
'variant': 'object',
'type': 'one_to_one',
},
'transform': {
'rename': {
'column_1': 'column1'
}
}
},
{
'table': 'child_2',
'columns': [
'column_1',
'column_2',
],
'label': 'Child2',
'relationship': {
'variant': 'object',
'type': 'one_to_many',
},
'transform': {
'rename': {
'column_2': 'column2'
}
}
}
],
'transform': {
'rename': {
'id': 'my_id',
'code': 'my_code',
'level': 'levelup',
}
}
}
row = {
'level': 1,
'id': '007',
'code': 'be',
'Child1': [
{'column_1': 2, 'column_2': 'aa'},
{'column_1': 3, 'column_2': 'bb'},
],
'Child2': [
{'column_1': 2, 'column_2': 'aa'},
{'column_1': 3, 'column_2': 'bb'},
],
}
row = transform(row, node)
assert row == {
'Child1': [
{'column1': 2, 'column_2': 'aa'},
{'column1': 3, 'column_2': 'bb'},
],
'Child2': [
{'column2': 'aa', 'column_1': 2},
{'column2': 'bb', 'column_1': 3},
],
'levelup': 1,
'my_code': 'be',
'my_id': '007',
}