Files
uha4 a55774eff2 neues skript sql_dump_diff.py zum Vergleich von 2 sql-dumps.
- leere, frisch initialisierte Datenbanken der Versionen verglichen
- datasetprogramme erkennen jetzt auch suche nach standardtabellen wie uom
2026-08-22 17:45:46 +02:00

775 lines
17 KiB
YAML

{
"records": [
{
"key": "scenario_party_erase__party",
"model": "party.party",
"fields": {
"name": "Pam",
"active": false
}
},
{
"key": "scenario_party_erase__attachment",
"model": "ir.attachment",
"fields": {
"resource": {
"$ref": "scenario_party_erase__party"
},
"name": "Attachment"
}
},
{
"key": "scenario_party_replace__party1",
"model": "party.party",
"fields": {
"name": "Pam"
}
},
{
"key": "scenario_stock_lot_shipment_out__customer",
"model": "party.party",
"fields": {
"name": "Customer"
}
},
{
"key": "scenario_stock_product_location__supplier",
"model": "party.party",
"fields": {
"name": "Suppier"
}
},
{
"key": "scenario_stock_reporting__supplier",
"model": "party.party",
"fields": {
"name": "Supplier"
}
},
{
"key": "scenario_stock_shipment_internal__employee_party",
"model": "party.party",
"fields": {
"name": "Employee"
}
},
{
"key": "scenario_stock_shipment_internal__employee",
"model": "company.employee",
"fields": {
"party": {
"$ref": "scenario_stock_shipment_internal__employee_party"
}
}
},
{
"key": "scenario_stock_shipment_out__employee",
"model": "company.employee",
"fields": {
"party": {
"$ref": "scenario_stock_shipment_internal__employee_party"
}
}
},
{
"key": "scenario_production__template",
"model": "product.template",
"fields": {
"name": "product",
"default_uom": {
"$search": {
"model": "product.uom",
"domain": [
[
"name",
"=",
"Unit"
]
]
}
},
"type": "goods",
"producible": true,
"list_price": {
"$decimal": "30"
}
}
},
{
"key": "scenario_production__template1",
"model": "product.template",
"fields": {
"name": "component 1",
"default_uom": {
"$search": {
"model": "product.uom",
"domain": [
[
"name",
"=",
"Unit"
]
]
}
},
"type": "goods",
"list_price": {
"$decimal": "5"
}
}
},
{
"key": "scenario_production__template2",
"model": "product.template",
"fields": {
"name": "component 2",
"default_uom": {
"$search": {
"model": "product.uom",
"domain": [
[
"name",
"=",
"Meter"
]
]
}
},
"type": "goods",
"list_price": {
"$decimal": "7"
}
}
},
{
"key": "scenario_stock_average_cost_price__template",
"model": "product.template",
"fields": {
"name": "Product",
"default_uom": {
"$search": {
"model": "product.uom",
"domain": [
[
"name",
"=",
"Unit"
]
]
}
},
"type": "goods",
"list_price": {
"$decimal": "300"
},
"cost_price_method": "average"
}
},
{
"key": "scenario_stock_inventory__template2",
"model": "product.template",
"fields": {
"name": "Product",
"default_uom": {
"$search": {
"model": "product.uom",
"domain": [
[
"name",
"=",
"Kilogram"
]
]
}
},
"type": "goods",
"list_price": {
"$decimal": "140"
},
"cost_price_method": "average"
}
},
{
"key": "scenario_stock_lot_shipment_out__template",
"model": "product.template",
"fields": {
"name": "Product",
"default_uom": {
"$search": {
"model": "product.uom",
"domain": [
[
"name",
"=",
"Unit"
]
]
}
},
"type": "goods",
"list_price": {
"$decimal": "20"
}
}
},
{
"key": "scenario_production__bom",
"model": "production.bom",
"fields": {
"name": "product"
}
},
{
"key": "scenario_production__production",
"model": "production",
"fields": {
"planned_date": {
"$manual": "today"
},
"product": {
"$manual": "product"
},
"bom": {
"$ref": "scenario_production__bom"
},
"quantity": 2
}
},
{
"key": "scenario_production__production_lead_time",
"model": "production.lead_time",
"fields": {
"product": {
"$manual": "product"
},
"bom": {
"$ref": "scenario_production__bom"
},
"lead_time": {
"$manual": "datetime.timedelta(1)"
}
}
},
{
"key": "scenario_stock_shipment_internal__stock_user",
"model": "res.user",
"fields": {
"name": "Stock",
"login": "stock",
"main_company": {
"$manual": "company"
},
"employee": {
"$ref": "scenario_stock_shipment_internal__employee"
}
}
},
{
"key": "scenario_stock_shipment_out__stock_user",
"model": "res.user",
"fields": {
"name": "Stock",
"login": "stock",
"main_company": {
"$manual": "company"
},
"employee": {
"$ref": "scenario_stock_shipment_out__employee"
}
}
},
{
"key": "scenario_stock_inventory__inventory",
"model": "stock.inventory",
"fields": {
"location": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"STO"
]
]
}
},
"empty_quantity": "keep"
}
},
{
"key": "scenario_stock_inventory_empty_quantity__inventory",
"model": "stock.inventory",
"fields": {
"location": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"STO"
]
]
}
},
"empty_quantity": "empty"
}
},
{
"key": "scenario_stock_average_cost_price__storage_sub_loc",
"model": "stock.location",
"fields": {
"name": "Storage Sub",
"type": "storage",
"parent": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"STO"
]
]
}
}
}
},
{
"key": "scenario_stock_product_location__child_loc",
"model": "stock.location",
"fields": {
"name": "Child Location",
"parent": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"STO"
]
]
}
},
"code": "CHI"
}
},
{
"key": "scenario_stock_shipment_in_same_storage_input__storage1",
"model": "stock.location",
"fields": {
"name": "Storage 1",
"parent": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"STO"
]
]
}
}
}
},
{
"key": "scenario_stock_shipment_internal__internal_loc",
"model": "stock.location",
"fields": {
"name": "Internal",
"type": "storage"
}
},
{
"key": "scenario_stock_shipment_internal__lead_time",
"model": "stock.location.lead_time",
"fields": {
"from_warehouse": {
"$manual": "storage_loc.warehouse"
},
"to_warehouse": {
"$manual": "storage_loc.warehouse"
},
"lead_time": {
"$manual": "datetime.timedelta(1)"
}
}
},
{
"key": "scenario_stock_average_cost_price__incoming_move",
"model": "stock.move",
"fields": {
"product": {
"$manual": "product"
},
"uom": {
"$search": {
"model": "product.uom",
"domain": [
[
"name",
"=",
"Unit"
]
]
}
},
"quantity": 1,
"from_location": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"SUP"
]
]
}
},
"to_location": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"STO"
]
]
}
},
"planned_date": {
"$manual": "today"
},
"effective_date": {
"$manual": "today"
},
"company": {
"$manual": "company"
},
"unit_price": {
"$decimal": "200"
},
"currency": {
"$manual": "company.currency"
}
}
},
{
"key": "scenario_stock_product_location__shipment_in",
"model": "stock.shipment.in",
"fields": {
"planned_date": {
"$manual": "today"
},
"supplier": {
"$ref": "scenario_stock_product_location__supplier"
},
"warehouse": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"WH"
]
]
}
},
"company": {
"$manual": "company"
}
}
},
{
"key": "scenario_stock_reporting__shipment_in",
"model": "stock.shipment.in",
"fields": {
"planned_date": {
"$manual": "today"
},
"supplier": {
"$ref": "scenario_stock_reporting__supplier"
},
"warehouse": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"WH"
]
]
}
},
"company": {
"$manual": "company"
}
}
},
{
"key": "scenario_stock_shipment_in_same_storage_input__shipment_in",
"model": "stock.shipment.in",
"fields": {
"supplier": {
"$ref": "scenario_stock_reporting__supplier"
},
"warehouse": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"WH"
]
]
}
},
"company": {
"$manual": "company"
}
}
},
{
"key": "scenario_stock_reporting__shipment_internal",
"model": "stock.shipment.internal",
"fields": {
"planned_date": {
"$manual": "today"
},
"company": {
"$manual": "company"
},
"from_location": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"STO"
]
]
}
},
"to_location": {
"$search": {
"model": "stock.location",
"domain": [
[
"type",
"=",
"lost_found"
]
]
}
}
}
},
{
"key": "scenario_stock_shipment_internal__shipment",
"model": "stock.shipment.internal",
"fields": {
"planned_date": {
"$manual": "today"
},
"from_location": {
"$ref": "scenario_stock_shipment_internal__internal_loc"
},
"to_location": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"STO"
]
]
}
}
}
},
{
"key": "scenario_stock_lot_shipment_out__shipment_out",
"model": "stock.shipment.out",
"fields": {
"planned_date": {
"$manual": "today"
},
"customer": {
"$ref": "scenario_stock_lot_shipment_out__customer"
},
"warehouse": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"WH"
]
]
}
},
"company": {
"$manual": "company"
}
}
},
{
"key": "scenario_stock_reporting__shipment_out",
"model": "stock.shipment.out",
"fields": {
"planned_date": {
"$manual": "today"
},
"customer": {
"$ref": "scenario_stock_lot_shipment_out__customer"
},
"warehouse": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"WH"
]
]
}
},
"company": {
"$manual": "company"
}
}
},
{
"key": "scenario_stock_shipment_out__shipment_out",
"model": "stock.shipment.out",
"fields": {
"planned_date": {
"$manual": "today"
},
"customer": {
"$ref": "scenario_stock_lot_shipment_out__customer"
},
"warehouse": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"WH"
]
]
}
},
"company": {
"$manual": "company"
}
}
},
{
"key": "scenario_stock_shipment_out_same_storage_output__shipment_out",
"model": "stock.shipment.out",
"fields": {
"customer": {
"$ref": "scenario_stock_lot_shipment_out__customer"
},
"warehouse": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"WH"
]
]
}
},
"company": {
"$manual": "company"
}
}
},
{
"key": "scenario_stock_split_shipment__shipment1",
"model": "stock.shipment.out",
"fields": {
"customer": {
"$ref": "scenario_stock_lot_shipment_out__customer"
}
}
},
{
"key": "scenario_stock_product_location__shipment_out_return",
"model": "stock.shipment.out.return",
"fields": {
"customer": {
"$ref": "scenario_stock_lot_shipment_out__customer"
},
"supplier": {
"$ref": "scenario_stock_product_location__supplier"
},
"from_location": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"OUT"
]
]
}
},
"to_location": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"SUP"
]
]
}
}
}
},
{
"key": "scenario_stock_shipment_out_return_same_storage_input__shipment",
"model": "stock.shipment.out.return",
"fields": {
"customer": {
"$ref": "scenario_stock_lot_shipment_out__customer"
},
"warehouse": {
"$search": {
"model": "stock.location",
"domain": [
[
"code",
"=",
"WH"
]
]
}
},
"company": {
"$manual": "company"
}
}
}
]
}