Tryton/tryton-db-migration
2
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
tryton-db-migration/reports/updateChanges/product.md
T

3100 lines
92 KiB
Markdown
Raw Permalink Normal View History

Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
# modul product
first version compare.py: compile changes by module
2026-08-07 22:54:22 +02:00
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
## Tabelle product_configuration_default_cost_price_method
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
### 5.6
- **before_super** `table_exist`
- object: `backend.TableHandler`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- files:
- `configuration.py`
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- args: `cls._table`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- code:
'backend.TableHandler.table_exist(cls._table)'
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
### 6.0
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `configuration.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
### 6.4
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `configuration.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
### 6.8
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `configuration.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
## Tabelle product_cost_price
### 5.0
- **after_super** `execute`
- condition: `cost_price_table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns], values=cost_price.select(*[Column(cost_price, c) for c in columns]))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns])))'
- **after_super** `insert`
- condition: `cost_price_table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns]`
- values: `cost_price.select(*[Column(cost_price, c) for c in columns])`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns]))'
- **after_super** `select`
- condition: `cost_price_table.column_exist('template')`
- object: `cost_price`
- files:
- `product.py`
- args: `*[Column(cost_price, c) for c in columns]`
- code:
'cost_price.select(
*[Column(cost_price, c) for c in columns])'
- **after_super** `add_column`
- condition: `not exist`
- object: `table`
- files:
- `product.py`
- args: `'template', 'INTEGER'`
- code:
'table.add_column('template', 'INTEGER')'
- **after_super** `execute`
- condition: `table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns] + [sql_table.product], values=sql_table.join(product, condition=sql_table.template == product.template).select(*[Column(sql_table, c) for c in columns] + [product.id], where=(sql_table.template != Null) & (sql_table.product == Null)))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns]
+ [sql_table.product],
values=sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null))))'
- **after_super** `insert`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns] + [sql_table.product]`
- values: `sql_table.join(product, condition=sql_table.template == product.template).select(*[Column(sql_table, c) for c in columns] + [product.id], where=(sql_table.template != Null) & (sql_table.product == Null))`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns]
+ [sql_table.product],
values=sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null)))'
- **after_super** `execute`
- condition: `table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.delete(where=(sql_table.template != Null) & (sql_table.product == Null))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.delete(
where=(sql_table.template != Null)
& (sql_table.product == Null)))'
- **after_super** `delete`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- where: `(sql_table.template != Null) & (sql_table.product == Null)`
- code:
'sql_table.delete(
where=(sql_table.template != Null)
& (sql_table.product == Null))'
- **after_super** `drop_column`
- condition: `table.column_exist('template')`
- object: `table`
- files:
- `product.py`
- args: `'template'`
- code:
'table.drop_column('template')'
### 5.4
- **after_super** `execute`
- condition: `cost_price_table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns], values=cost_price.select(*[Column(cost_price, c) for c in columns]))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns])))'
- **after_super** `insert`
- condition: `cost_price_table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns]`
- values: `cost_price.select(*[Column(cost_price, c) for c in columns])`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns]))'
- **after_super** `select`
- condition: `cost_price_table.column_exist('template')`
- object: `cost_price`
- files:
- `product.py`
- args: `*[Column(cost_price, c) for c in columns]`
- code:
'cost_price.select(
*[Column(cost_price, c) for c in columns])'
- **after_super** `add_column`
- condition: `not exist`
- object: `table`
- files:
- `product.py`
- args: `'template', 'INTEGER'`
- code:
'table.add_column('template', 'INTEGER')'
- **after_super** `execute`
- condition: `table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns] + [sql_table.product], values=sql_table.join(product, condition=sql_table.template == product.template).select(*[Column(sql_table, c) for c in columns] + [product.id], where=(sql_table.template != Null) & (sql_table.product == Null)))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns]
+ [sql_table.product],
values=sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null))))'
- **after_super** `insert`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns] + [sql_table.product]`
- values: `sql_table.join(product, condition=sql_table.template == product.template).select(*[Column(sql_table, c) for c in columns] + [product.id], where=(sql_table.template != Null) & (sql_table.product == Null))`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns]
+ [sql_table.product],
values=sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null)))'
- **after_super** `execute`
- condition: `table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.delete(where=(sql_table.template != Null) & (sql_table.product == Null))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.delete(
where=(sql_table.template != Null)
& (sql_table.product == Null)))'
- **after_super** `delete`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- where: `(sql_table.template != Null) & (sql_table.product == Null)`
- code:
'sql_table.delete(
where=(sql_table.template != Null)
& (sql_table.product == Null))'
- **after_super** `drop_column`
- condition: `table.column_exist('template')`
- object: `table`
- files:
- `product.py`
- args: `'template'`
- code:
'table.drop_column('template')'
compare.py fasst nach Klassen zusammen
2026-08-08 00:58:56 +02:00
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
compare.py fasst nach Klassen zusammen
2026-08-08 00:58:56 +02:00
### 5.6
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
### 5.8
- **after_super** `execute`
- condition: `cost_price_table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns], values=cost_price.select(*[Column(cost_price, c) for c in columns]))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns])))'
- **after_super** `insert`
- condition: `cost_price_table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns]`
- values: `cost_price.select(*[Column(cost_price, c) for c in columns])`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns]))'
- **after_super** `select`
- condition: `cost_price_table.column_exist('template')`
- object: `cost_price`
- files:
- `product.py`
- args: `*[Column(cost_price, c) for c in columns]`
- code:
'cost_price.select(
*[Column(cost_price, c) for c in columns])'
- **after_super** `add_column`
- condition: `not exist`
- object: `table`
- files:
- `product.py`
- args: `'template', 'INTEGER'`
- code:
'table.add_column('template', 'INTEGER')'
- **after_super** `execute`
- condition: `table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns] + [sql_table.product], values=sql_table.join(product, condition=sql_table.template == product.template).select(*[Column(sql_table, c) for c in columns] + [product.id], where=(sql_table.template != Null) & (sql_table.product == Null)))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns]
+ [sql_table.product],
values=sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null))))'
- **after_super** `insert`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns] + [sql_table.product]`
- values: `sql_table.join(product, condition=sql_table.template == product.template).select(*[Column(sql_table, c) for c in columns] + [product.id], where=(sql_table.template != Null) & (sql_table.product == Null))`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns]
+ [sql_table.product],
values=sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null)))'
- **after_super** `execute`
- condition: `table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.delete(where=(sql_table.template != Null) & (sql_table.product == Null))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.delete(
where=(sql_table.template != Null)
& (sql_table.product == Null)))'
- **after_super** `delete`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- where: `(sql_table.template != Null) & (sql_table.product == Null)`
- code:
'sql_table.delete(
where=(sql_table.template != Null)
& (sql_table.product == Null))'
- **after_super** `drop_column`
- condition: `table.column_exist('template')`
- object: `table`
- files:
- `product.py`
- args: `'template'`
- code:
'table.drop_column('template')'
### 6.0
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
### 6.2
- **after_super** `execute`
- condition: `cost_price_table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns], values=cost_price.select(*[Column(cost_price, c) for c in columns]))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns])))'
- **after_super** `insert`
- condition: `cost_price_table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns]`
- values: `cost_price.select(*[Column(cost_price, c) for c in columns])`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns]))'
- **after_super** `select`
- condition: `cost_price_table.column_exist('template')`
- object: `cost_price`
- files:
- `product.py`
- args: `*[Column(cost_price, c) for c in columns]`
- code:
'cost_price.select(
*[Column(cost_price, c) for c in columns])'
- **after_super** `add_column`
- condition: `not exist`
- object: `table`
- files:
- `product.py`
- args: `'template', 'INTEGER'`
- code:
'table.add_column('template', 'INTEGER')'
- **after_super** `execute`
- condition: `table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns] + [sql_table.product], values=sql_table.join(product, condition=sql_table.template == product.template).select(*[Column(sql_table, c) for c in columns] + [product.id], where=(sql_table.template != Null) & (sql_table.product == Null)))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns]
+ [sql_table.product],
values=sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null))))'
- **after_super** `insert`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns] + [sql_table.product]`
- values: `sql_table.join(product, condition=sql_table.template == product.template).select(*[Column(sql_table, c) for c in columns] + [product.id], where=(sql_table.template != Null) & (sql_table.product == Null))`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns]
+ [sql_table.product],
values=sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null)))'
- **after_super** `execute`
- condition: `table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.delete(where=(sql_table.template != Null) & (sql_table.product == Null))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.delete(
where=(sql_table.template != Null)
& (sql_table.product == Null)))'
- **after_super** `delete`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- where: `(sql_table.template != Null) & (sql_table.product == Null)`
- code:
'sql_table.delete(
where=(sql_table.template != Null)
& (sql_table.product == Null))'
- **after_super** `drop_column`
- condition: `table.column_exist('template')`
- object: `table`
- files:
- `product.py`
- args: `'template'`
- code:
'table.drop_column('template')'
### 6.4
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
### 6.6
- **after_super** `execute`
- condition: `cost_price_table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns], values=cost_price.select(*[Column(cost_price, c) for c in columns]))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns])))'
- **after_super** `insert`
- condition: `cost_price_table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns]`
- values: `cost_price.select(*[Column(cost_price, c) for c in columns])`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns]))'
- **after_super** `select`
- condition: `cost_price_table.column_exist('template')`
- object: `cost_price`
- files:
- `product.py`
- args: `*[Column(cost_price, c) for c in columns]`
- code:
'cost_price.select(
*[Column(cost_price, c) for c in columns])'
- **after_super** `add_column`
- condition: `not exist`
- object: `table`
- files:
- `product.py`
- args: `'template', 'INTEGER'`
- code:
'table.add_column('template', 'INTEGER')'
- **after_super** `execute`
- condition: `table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns] + [sql_table.product], values=sql_table.join(product, condition=sql_table.template == product.template).select(*[Column(sql_table, c) for c in columns] + [product.id], where=(sql_table.template != Null) & (sql_table.product == Null)))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns]
+ [sql_table.product],
values=sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null))))'
- **after_super** `insert`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns] + [sql_table.product]`
- values: `sql_table.join(product, condition=sql_table.template == product.template).select(*[Column(sql_table, c) for c in columns] + [product.id], where=(sql_table.template != Null) & (sql_table.product == Null))`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns]
+ [sql_table.product],
values=sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null)))'
- **after_super** `execute`
- condition: `table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.delete(where=(sql_table.template != Null) & (sql_table.product == Null))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.delete(
where=(sql_table.template != Null)
& (sql_table.product == Null)))'
- **after_super** `delete`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- where: `(sql_table.template != Null) & (sql_table.product == Null)`
- code:
'sql_table.delete(
where=(sql_table.template != Null)
& (sql_table.product == Null))'
- **after_super** `drop_column`
- condition: `table.column_exist('template')`
- object: `table`
- files:
- `product.py`
- args: `'template'`
- code:
'table.drop_column('template')'
### 6.8
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
## Tabelle product_cost_price_method
### 5.0
- **after_super** `execute`
- condition: `cost_price_table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns], values=cost_price.select(*[Column(cost_price, c) for c in columns]))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns])))'
- **after_super** `insert`
- condition: `cost_price_table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns]`
- values: `cost_price.select(*[Column(cost_price, c) for c in columns])`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns]))'
### 5.4
- **after_super** `execute`
- condition: `cost_price_table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns], values=cost_price.select(*[Column(cost_price, c) for c in columns]))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns])))'
- **after_super** `insert`
- condition: `cost_price_table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns]`
- values: `cost_price.select(*[Column(cost_price, c) for c in columns])`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns]))'
### 5.6
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
### 5.8
- **after_super** `execute`
- condition: `cost_price_table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns], values=cost_price.select(*[Column(cost_price, c) for c in columns]))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns])))'
- **after_super** `insert`
- condition: `cost_price_table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns]`
- values: `cost_price.select(*[Column(cost_price, c) for c in columns])`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns]))'
### 6.0
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
### 6.2
- **after_super** `execute`
- condition: `cost_price_table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns], values=cost_price.select(*[Column(cost_price, c) for c in columns]))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns])))'
- **after_super** `insert`
- condition: `cost_price_table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns]`
- values: `cost_price.select(*[Column(cost_price, c) for c in columns])`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns]))'
### 6.4
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
### 6.6
- **after_super** `execute`
- condition: `cost_price_table.column_exist('template')`
- object: `cursor`
- files:
- `product.py`
- args: `*sql_table.insert(columns=[Column(sql_table, c) for c in columns], values=cost_price.select(*[Column(cost_price, c) for c in columns]))`
- code:
'(Transaction().connection.cursor()).execute(*sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns])))'
- **after_super** `insert`
- condition: `cost_price_table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- kwargs:
- columns: `[Column(sql_table, c) for c in columns]`
- values: `cost_price.select(*[Column(cost_price, c) for c in columns])`
- code:
'sql_table.insert(
columns=[Column(sql_table, c) for c in columns],
values=cost_price.select(
*[Column(cost_price, c) for c in columns]))'
### 6.8
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
## Tabelle product_list_price
### 5.6
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
### 6.0
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
### 6.4
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
### 6.8
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
## Tabelle product_product
### 5.6
compare.py fasst nach Klassen zusammen
2026-08-08 00:58:56 +02:00
- **after_super** `execute`
several small fixes:
2026-08-08 01:29:43 +02:00
- condition: `fill_suffix_code`
compare.py fasst nach Klassen zusammen
2026-08-08 00:58:56 +02:00
- object: `cursor`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- files:
- `product.py`
several small fixes:
2026-08-08 01:29:43 +02:00
- args: `*table.update([table.suffix_code], [table.code])`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- code:
'(Transaction().connection.cursor()).execute(*table.update(
[table.suffix_code],
[table.code]))'
several small fixes:
2026-08-08 01:29:43 +02:00
- **after_super** `update`
- condition: `fill_suffix_code`
- object: `table`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- files:
- `product.py`
several small fixes:
2026-08-08 01:29:43 +02:00
- args: `[table.suffix_code], [table.code]`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- code:
'table.update(
[table.suffix_code],
[table.code])'
compare.py fasst nach Klassen zusammen
2026-08-08 00:58:56 +02:00
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
### 6.0
- **after_super** `execute`
- condition: `fill_suffix_code`
- object: `cursor`
- files:
- `product.py`
- args: `*table.update([table.suffix_code], [table.code])`
- code:
'(Transaction().connection.cursor()).execute(*table.update(
[table.suffix_code],
[table.code]))'
- **after_super** `update`
- condition: `fill_suffix_code`
- object: `table`
- files:
- `product.py`
- args: `[table.suffix_code], [table.code]`
- code:
'table.update(
[table.suffix_code],
[table.code])'
### 6.4
- **after_super** `execute`
- condition: `fill_suffix_code`
- object: `cursor`
- files:
- `product.py`
- args: `*table.update([table.suffix_code], [table.code])`
- code:
'(Transaction().connection.cursor()).execute(*table.update(
[table.suffix_code],
[table.code]))'
- **after_super** `update`
- condition: `fill_suffix_code`
- object: `table`
- files:
- `product.py`
- args: `[table.suffix_code], [table.code]`
- code:
'table.update(
[table.suffix_code],
[table.code])'
### 6.8
- **after_super** `execute`
- condition: `fill_suffix_code`
- object: `cursor`
- files:
- `product.py`
- args: `*table.update([table.suffix_code], [table.code])`
- code:
'(Transaction().connection.cursor()).execute(*table.update(
[table.suffix_code],
[table.code]))'
- **after_super** `update`
- condition: `fill_suffix_code`
- object: `table`
- files:
- `product.py`
- args: `[table.suffix_code], [table.code]`
- code:
'table.update(
[table.suffix_code],
[table.code])'
### 7.2
- **after_super** `execute`
- condition: `fill_suffix_code`
- object: `cursor`
- files:
- `product.py`
- args: `*table.update([table.suffix_code], [table.code])`
- code:
'(Transaction().connection.cursor()).execute(*table.update(
[table.suffix_code],
[table.code]))'
- **after_super** `update`
- condition: `fill_suffix_code`
- object: `table`
- files:
- `product.py`
- args: `[table.suffix_code], [table.code]`
- code:
'table.update(
[table.suffix_code],
[table.code])'
## Tabelle unknown
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
compare.py fasst nach Klassen zusammen
2026-08-08 00:58:56 +02:00
### 5.0
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- **before_super** `get`
- object: `backend`
- files:
- `party.py`
- args: `'TableHandler'`
- code:
'backend.get('(backend.get('TableHandler'))')'
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- **before_super** `table_exist`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- object: `TableHandler`
- files:
- `party.py`
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- args: `cls._table`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- code:
'(backend.get('TableHandler')).table_exist(cls._table)'
- **before_super** `column_exist`
- condition: `exist`
- object: `table`
- files:
- `party.py`
- args: `'company'`
- code:
'table.column_exist('company')'
- **after_super** `migrate_property`
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- condition: `not exist`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- files:
- `party.py`
- args: `'party.configuration', cls._configuration_value_field, cls, cls._configuration_value_field`
- kwargs:
- fields: `['company']`
- code:
'migrate_property(
'party.configuration', cls._configuration_value_field,
cls, cls._configuration_value_field, fields=['company'])'
- **after_super** `_migrate_property`
- condition: `not exist`
- object: `super(PartyLang, cls)`
- files:
- `party.py`
- args: `field_names, value_names, fields`
- code:
'super(PartyLang, cls)._migrate_property(
field_names, value_names, fields)'
- **after_super** `super`
- condition: `not exist`
- files:
- `party.py`
- args: `PartyLang, cls`
- code:
'super(PartyLang, cls)'
- **after_super** `Transaction`
- files:
- `action.py`
- code:
'Transaction()'
- **after_super** `cursor`
- object: `transaction.connection`
- files:
- `action.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **before_super** `cursor`
- object: `Transaction().connection`
- files:
- `action.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **before_super** `Transaction`
- files:
- `action.py`
- code:
'Transaction()'
- **after_super** `Concat`
- condition: `table.column_exist('digest') and table.column_exist('collision')`
- files:
- `attachment.py`
- args: `Concat(attachment.digest, '-'), attachment.collision`
- code:
'Concat(Concat(attachment.digest, '-'),
attachment.collision)'
- **after_super** `Concat`
- condition: `table.column_exist('digest') and table.column_exist('collision')`
- files:
- `attachment.py`
- args: `attachment.digest, '-'`
- code:
'Concat(attachment.digest, '-')'
- **before_super** `Pool`
- files:
- `module.py`
- code:
'Pool()'
- **before_super** `table_rename`
- condition: `TableHandler.table_exist(old_table)`
- object: `TableHandler`
- files:
- `module.py`
- args: `old_table, cls._table`
- code:
'(backend.get('TableHandler')).table_rename(old_table, cls._table)'
- **after_super** `in_`
- object: `model_data_sql_table.fs_id`
- files:
- `module.py`
- args: `button_fs_ids`
- code:
'model_data_sql_table.fs_id.in_(button_fs_ids)'
- **before_super** `cursor`
- object: `transaction.connection`
- files:
- `translation.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **after_super** `timedelta`
- condition: `table.column_exist('minimum_delay')`
- object: `datetime`
- files:
- `trigger.py`
- kwargs:
- hours: `delay`
- code:
'datetime.timedelta(hours=(datetime.timedelta(hours=delay)))'
- **after_super** `Concat`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `Coalesce(sql_table.street, ''), Concat('\n', Coalesce(sql_table.streetbis, ''))`
- code:
'Concat(
Coalesce(sql_table.street, ''),
Concat('\n', Coalesce(sql_table.streetbis, '')))'
- **after_super** `Coalesce`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `sql_table.street, ''`
- code:
'Coalesce(sql_table.street, '')'
- **after_super** `Concat`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `'\n', Coalesce(sql_table.streetbis, '')`
- code:
'Concat('\n', Coalesce(sql_table.streetbis, ''))'
- **after_super** `Coalesce`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `sql_table.streetbis, ''`
- code:
'Coalesce(sql_table.streetbis, '')'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `configuration.py`
- args: `'party.configuration', field_names, cls, value_names`
- kwargs:
- fields: `fields`
- code:
'migrate_property(
'party.configuration', field_names, cls, value_names,
fields=fields)'
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- **after_super** `execute`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- condition: `party_h.column_exist('lang')`
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- object: `cursor`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- files:
- `party.py`
- args: `*query`
- code:
'(Transaction().connection.cursor()).execute(*(table.insert(
[table.party, table.lang],
party.select(party.id, party.lang))))'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `party.py`
- args: `'party.party', field_names, cls, value_names`
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- kwargs:
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- parent: `'party'`
- fields: `fields`
- code:
'migrate_property(
'party.party', field_names, cls, value_names,
parent='party', fields=fields)'
- **after_super** `cls`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- files:
- `party.py`
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- kwargs:
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- party: `party_id`
- code: `code`
- type: `type`
- code:
'cls(party=party_id, code=code, type=type)'
- **after_super** `save`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- object: `cls`
- files:
- `party.py`
- args: `identifiers`
- code:
'cls.save(identifiers)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `configuration.py`
- args: `'product.configuration', field_names, cls, value_names`
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- kwargs:
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- fields: `fields`
- code:
'migrate_property(
'product.configuration', field_names, cls, value_names,
fields=fields)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `product.py`
- args: `'product.template', field_names, cls, value_names`
several small fixes:
2026-08-08 01:29:43 +02:00
- kwargs:
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- parent: `'template'`
- fields: `fields`
- code:
'migrate_property(
'product.template', field_names, cls, value_names,
parent='template', fields=fields)'
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- **before_super** `table_exist`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- object: `TableHandler`
- files:
- `product.py`
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- args: `ProductCostPrice._table`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- code:
'(backend.get('TableHandler')).table_exist(ProductCostPrice._table)'
- **after_super** `TableHandler`
- condition: `not exist and cost_price_exist`
- files:
- `product.py`
- args: `ProductCostPrice, module_name`
- code:
'(backend.get('TableHandler'))(ProductCostPrice, module_name)'
- **after_super** `Column`
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- condition: `cost_price_table.column_exist('template')`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- files:
- `product.py`
- args: `sql_table, c`
- code:
'Column(sql_table, c)'
- **after_super** `Column`
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- condition: `cost_price_table.column_exist('template')`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- files:
- `product.py`
- args: `cost_price, c`
- code:
'Column(cost_price, c)'
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- **after_super** `select`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- condition: `table.column_exist('template')`
- object: `sql_table.join(product, condition=sql_table.template == product.template)`
- files:
- `product.py`
- args: `*[Column(sql_table, c) for c in columns] + [product.id]`
- kwargs:
- where: `(sql_table.template != Null) & (sql_table.product == Null)`
- code:
'sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null))'
- **after_super** `join`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- args: `product`
- kwargs:
- condition: `sql_table.template == product.template`
- code:
'sql_table.join(product,
condition=sql_table.template == product.template
)'
several small fixes:
2026-08-08 01:29:43 +02:00
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
### 5.2
- **after_super** `get_cc_module`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- files:
- `party.py`
- args: `*type.split('_', 1)`
- code:
'get_cc_module(*type.split('_', 1))'
- **after_super** `split`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- object: `type`
- files:
- `party.py`
- args: `'_', 1`
- code:
'type.split('_', 1)'
### 5.4
- **before_super** `get`
- object: `backend`
- files:
- `party.py`
- args: `'TableHandler'`
- code:
'backend.get('(backend.get('TableHandler'))')'
- **before_super** `table_exist`
- object: `TableHandler`
- files:
- `party.py`
- args: `cls._table`
- code:
'(backend.get('TableHandler')).table_exist(cls._table)'
- **before_super** `column_exist`
- condition: `exist`
- object: `table`
- files:
- `party.py`
- args: `'company'`
- code:
'table.column_exist('company')'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `party.py`
- args: `'party.configuration', cls._configuration_value_field, cls, cls._configuration_value_field`
- kwargs:
- fields: `['company']`
- code:
'migrate_property(
'party.configuration', cls._configuration_value_field,
cls, cls._configuration_value_field, fields=['company'])'
- **after_super** `_migrate_property`
- condition: `not exist`
- object: `super(PartyLang, cls)`
- files:
- `party.py`
- args: `field_names, value_names, fields`
- code:
'super(PartyLang, cls)._migrate_property(
field_names, value_names, fields)'
- **after_super** `super`
- condition: `not exist`
- files:
- `party.py`
- args: `PartyLang, cls`
- code:
'super(PartyLang, cls)'
- **before_super** `Pool`
- files:
- `country.py`
- code:
'Pool()'
- **before_super** `cursor`
- object: `Transaction().connection`
- files:
- `country.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **before_super** `Transaction`
- files:
- `country.py`
- code:
'Transaction()'
- **after_super** `Transaction`
- files:
- `action.py`
- code:
'Transaction()'
- **after_super** `cursor`
- object: `transaction.connection`
- files:
- `action.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **after_super** `Concat`
- condition: `table.column_exist('digest') and table.column_exist('collision')`
- files:
- `attachment.py`
- args: `Concat(attachment.digest, '-'), attachment.collision`
- code:
'Concat(Concat(attachment.digest, '-'),
attachment.collision)'
- **after_super** `Concat`
- condition: `table.column_exist('digest') and table.column_exist('collision')`
- files:
- `attachment.py`
- args: `attachment.digest, '-'`
- code:
'Concat(attachment.digest, '-')'
- **before_super** `table_rename`
- condition: `TableHandler.table_exist(old_table)`
- object: `TableHandler`
- files:
- `module.py`
- args: `old_table, cls._table`
- code:
'(backend.get('TableHandler')).table_rename(old_table, cls._table)'
- **after_super** `in_`
- object: `model_data_sql_table.fs_id`
- files:
- `module.py`
- args: `button_fs_ids`
- code:
'model_data_sql_table.fs_id.in_(button_fs_ids)'
- **before_super** `cursor`
- object: `transaction.connection`
- files:
- `translation.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **after_super** `timedelta`
- condition: `table.column_exist('minimum_delay')`
- object: `datetime`
- files:
- `trigger.py`
- kwargs:
- hours: `delay`
- code:
'datetime.timedelta(hours=(datetime.timedelta(hours=delay)))'
- **after_super** `Concat`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `Coalesce(sql_table.street, ''), Concat('\n', Coalesce(sql_table.streetbis, ''))`
- code:
'Concat(
Coalesce(sql_table.street, ''),
Concat('\n', Coalesce(sql_table.streetbis, '')))'
- **after_super** `Coalesce`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `sql_table.street, ''`
- code:
'Coalesce(sql_table.street, '')'
- **after_super** `Concat`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `'\n', Coalesce(sql_table.streetbis, '')`
- code:
'Concat('\n', Coalesce(sql_table.streetbis, ''))'
- **after_super** `Coalesce`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `sql_table.streetbis, ''`
- code:
'Coalesce(sql_table.streetbis, '')'
- **after_super** `execute`
- condition: `table_h.column_exist('country')`
- object: `cursor`
- files:
- `address.py`
- args: `*query`
- code:
'(Transaction().connection.cursor()).execute(*(table.update(
[table.language_code],
language.select(
Substring(language.code, 0, 2),
where=language.id == table.language))))'
- **after_super** `Substring`
- condition: `table_h.column_exist('language')`
- files:
- `address.py`
- args: `language.code, 0, 2`
- code:
'Substring(language.code, 0, 2)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `configuration.py`
- args: `'party.configuration', field_names, cls, value_names`
- kwargs:
- fields: `fields`
- code:
'migrate_property(
'party.configuration', field_names, cls, value_names,
fields=fields)'
- **after_super** `execute`
- condition: `party_h.column_exist('lang')`
- object: `cursor`
- files:
- `party.py`
- args: `*query`
- code:
'(Transaction().connection.cursor()).execute(*(table.insert(
[table.party, table.lang],
party.select(party.id, party.lang))))'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `party.py`
- args: `'party.party', field_names, cls, value_names`
- kwargs:
- parent: `'party'`
- fields: `fields`
- code:
'migrate_property(
'party.party', field_names, cls, value_names,
parent='party', fields=fields)'
- **after_super** `cls`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- files:
- `party.py`
- kwargs:
- party: `party_id`
- code: `code`
- type: `type`
- code:
'cls(party=party_id, code=code, type=type)'
- **after_super** `save`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- object: `cls`
- files:
- `party.py`
- args: `identifiers`
- code:
'cls.save(identifiers)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `configuration.py`
- args: `'product.configuration', field_names, cls, value_names`
- kwargs:
- fields: `fields`
- code:
'migrate_property(
'product.configuration', field_names, cls, value_names,
fields=fields)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `product.py`
- args: `'product.template', field_names, cls, value_names`
- kwargs:
- parent: `'template'`
- fields: `fields`
- code:
'migrate_property(
'product.template', field_names, cls, value_names,
parent='template', fields=fields)'
- **before_super** `table_exist`
- object: `TableHandler`
- files:
- `product.py`
- args: `ProductCostPrice._table`
- code:
'(backend.get('TableHandler')).table_exist(ProductCostPrice._table)'
- **after_super** `TableHandler`
- condition: `not exist and cost_price_exist`
- files:
- `product.py`
- args: `ProductCostPrice, module_name`
- code:
'(backend.get('TableHandler'))(ProductCostPrice, module_name)'
- **after_super** `Column`
- condition: `cost_price_table.column_exist('template')`
- files:
- `product.py`
- args: `sql_table, c`
- code:
'Column(sql_table, c)'
- **after_super** `Column`
- condition: `cost_price_table.column_exist('template')`
- files:
- `product.py`
- args: `cost_price, c`
- code:
'Column(cost_price, c)'
- **after_super** `select`
- condition: `table.column_exist('template')`
- object: `sql_table.join(product, condition=sql_table.template == product.template)`
- files:
- `product.py`
- args: `*[Column(sql_table, c) for c in columns] + [product.id]`
- kwargs:
- where: `(sql_table.template != Null) & (sql_table.product == Null)`
- code:
'sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null))'
- **after_super** `join`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- args: `product`
- kwargs:
- condition: `sql_table.template == product.template`
- code:
'sql_table.join(product,
condition=sql_table.template == product.template
)'
several small fixes:
2026-08-08 01:29:43 +02:00
first version compare.py: compile changes by module
2026-08-07 22:54:22 +02:00
compare.py fasst nach Klassen zusammen
2026-08-08 00:58:56 +02:00
### 5.6
first version compare.py: compile changes by module
2026-08-07 22:54:22 +02:00
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- **after_super** `Pool`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- code:
'Pool()'
- **after_super** `Concat`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- args: `action_model, Concat('|', sql_table.action_function)`
- code:
'Concat((model.select(
model.model, where=model.id == sql_table.action_model)), Concat(
'|', sql_table.action_function))'
- **after_super** `Concat`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- args: `'|', sql_table.action_function`
- code:
'Concat(
'|', sql_table.action_function)'
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- **before_super** `table_exist`
- object: `backend.TableHandler`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- files:
- `configuration.py`
extract gets and saves most tables worked on
2026-08-08 22:32:31 +02:00
- args: `cls._table`
Dedublizierung gefixt
2026-08-20 13:27:23 +02:00
- code:
'backend.TableHandler.table_exist(cls._table)'
- **after_super** `get_cc_module`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- files:
- `party.py`
- args: `*type.split('_', 1)`
- code:
'get_cc_module(*type.split('_', 1))'
- **after_super** `split`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- object: `type`
- files:
- `party.py`
- args: `'_', 1`
- code:
'type.split('_', 1)'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `product.py`
- args: `'code'`
- code:
'table_h.column_exist('code')'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `product.py`
- args: `'suffix_code'`
- code:
'table_h.column_exist('suffix_code')'
- **after_super** `cursor`
- object: `Transaction().connection`
- files:
- `product.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `ProductCostPrice._table`
- code:
'backend.TableHandler.table_exist(
ProductCostPrice._table)'
- **after_super** `TableHandler`
- condition: `not exist and cost_price_exist`
- object: `backend`
- files:
- `product.py`
- args: `ProductCostPrice, module_name`
- code:
'backend.TableHandler(
ProductCostPrice, module_name)'
### 5.8
- **before_super** `column_exist`
- condition: `exist`
- object: `table`
- files:
- `party.py`
- args: `'company'`
- code:
'table.column_exist('company')'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `party.py`
- args: `'party.configuration', cls._configuration_value_field, cls, cls._configuration_value_field`
- kwargs:
- fields: `['company']`
- code:
'migrate_property(
'party.configuration', cls._configuration_value_field,
cls, cls._configuration_value_field, fields=['company'])'
- **after_super** `_migrate_property`
- condition: `not exist`
- object: `super(PartyLang, cls)`
- files:
- `party.py`
- args: `field_names, value_names, fields`
- code:
'super(PartyLang, cls)._migrate_property(
field_names, value_names, fields)'
- **after_super** `super`
- condition: `not exist`
- files:
- `party.py`
- args: `PartyLang, cls`
- code:
'super(PartyLang, cls)'
- **before_super** `Pool`
- files:
- `country.py`
- code:
'Pool()'
- **before_super** `cursor`
- object: `Transaction().connection`
- files:
- `country.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **before_super** `Transaction`
- files:
- `country.py`
- code:
'Transaction()'
- **after_super** `Transaction`
- files:
- `action.py`
- code:
'Transaction()'
- **after_super** `cursor`
- object: `transaction.connection`
- files:
- `action.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **after_super** `Concat`
- condition: `table.column_exist('digest') and table.column_exist('collision')`
- files:
- `attachment.py`
- args: `Concat(attachment.digest, '-'), attachment.collision`
- code:
'Concat(Concat(attachment.digest, '-'),
attachment.collision)'
- **after_super** `Concat`
- condition: `table.column_exist('digest') and table.column_exist('collision')`
- files:
- `attachment.py`
- args: `attachment.digest, '-'`
- code:
'Concat(attachment.digest, '-')'
- **after_super** `in_`
- object: `model_data_sql_table.fs_id`
- files:
- `module.py`
- args: `button_fs_ids`
- code:
'model_data_sql_table.fs_id.in_(button_fs_ids)'
- **before_super** `cursor`
- object: `transaction.connection`
- files:
- `translation.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **after_super** `timedelta`
- condition: `table.column_exist('minimum_delay')`
- object: `datetime`
- files:
- `trigger.py`
- kwargs:
- hours: `delay`
- code:
'datetime.timedelta(hours=(datetime.timedelta(hours=delay)))'
- **after_super** `Concat`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `Coalesce(sql_table.street, ''), Concat('\n', Coalesce(sql_table.streetbis, ''))`
- code:
'Concat(
Coalesce(sql_table.street, ''),
Concat('\n', Coalesce(sql_table.streetbis, '')))'
- **after_super** `Coalesce`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `sql_table.street, ''`
- code:
'Coalesce(sql_table.street, '')'
- **after_super** `Concat`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `'\n', Coalesce(sql_table.streetbis, '')`
- code:
'Concat('\n', Coalesce(sql_table.streetbis, ''))'
- **after_super** `Coalesce`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `sql_table.streetbis, ''`
- code:
'Coalesce(sql_table.streetbis, '')'
- **after_super** `execute`
- condition: `table_h.column_exist('country')`
- object: `cursor`
- files:
- `address.py`
- args: `*query`
- code:
'(Transaction().connection.cursor()).execute(*(table.update(
[table.language_code],
language.select(
Substring(language.code, 0, 2),
where=language.id == table.language))))'
- **after_super** `Substring`
- condition: `table_h.column_exist('language')`
- files:
- `address.py`
- args: `language.code, 0, 2`
- code:
'Substring(language.code, 0, 2)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `configuration.py`
- args: `'party.configuration', field_names, cls, value_names`
- kwargs:
- fields: `fields`
- code:
'migrate_property(
'party.configuration', field_names, cls, value_names,
fields=fields)'
- **after_super** `execute`
- condition: `party_h.column_exist('lang')`
- object: `cursor`
- files:
- `party.py`
- args: `*query`
- code:
'(Transaction().connection.cursor()).execute(*(table.insert(
[table.party, table.lang],
party.select(party.id, party.lang))))'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `party.py`
- args: `'party.party', field_names, cls, value_names`
- kwargs:
- parent: `'party'`
- fields: `fields`
- code:
'migrate_property(
'party.party', field_names, cls, value_names,
parent='party', fields=fields)'
- **after_super** `cls`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- files:
- `party.py`
- kwargs:
- party: `party_id`
- code: `code`
- type: `type`
- code:
'cls(party=party_id, code=code, type=type)'
- **after_super** `save`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- object: `cls`
- files:
- `party.py`
- args: `identifiers`
- code:
'cls.save(identifiers)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `configuration.py`
- args: `'product.configuration', field_names, cls, value_names`
- kwargs:
- fields: `fields`
- code:
'migrate_property(
'product.configuration', field_names, cls, value_names,
fields=fields)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `product.py`
- args: `'product.template', field_names, cls, value_names`
- kwargs:
- parent: `'template'`
- fields: `fields`
- code:
'migrate_property(
'product.template', field_names, cls, value_names,
parent='template', fields=fields)'
- **after_super** `Column`
- condition: `cost_price_table.column_exist('template')`
- files:
- `product.py`
- args: `sql_table, c`
- code:
'Column(sql_table, c)'
- **after_super** `Column`
- condition: `cost_price_table.column_exist('template')`
- files:
- `product.py`
- args: `cost_price, c`
- code:
'Column(cost_price, c)'
- **after_super** `select`
- condition: `table.column_exist('template')`
- object: `sql_table.join(product, condition=sql_table.template == product.template)`
- files:
- `product.py`
- args: `*[Column(sql_table, c) for c in columns] + [product.id]`
- kwargs:
- where: `(sql_table.template != Null) & (sql_table.product == Null)`
- code:
'sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null))'
- **after_super** `join`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- args: `product`
- kwargs:
- condition: `sql_table.template == product.template`
- code:
'sql_table.join(product,
condition=sql_table.template == product.template
)'
### 6.0
- **before_super** `Pool`
- files:
- `res.py`
- code:
'Pool()'
- **before_super** `Transaction`
- files:
- `res.py`
- code:
'Transaction()'
- **after_super** `cursor`
- object: `transaction.connection`
- files:
- `res.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **after_super** `Pool`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- code:
'Pool()'
- **after_super** `Concat`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- args: `action_model, Concat('|', sql_table.action_function)`
- code:
'Concat((model.select(
model.model, where=model.id == sql_table.action_model)), Concat(
'|', sql_table.action_function))'
- **after_super** `Concat`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- args: `'|', sql_table.action_function`
- code:
'Concat(
'|', sql_table.action_function)'
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `configuration.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
- **after_super** `get_cc_module`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- files:
- `party.py`
- args: `*type.split('_', 1)`
- code:
'get_cc_module(*type.split('_', 1))'
- **after_super** `split`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- object: `type`
- files:
- `party.py`
- args: `'_', 1`
- code:
'type.split('_', 1)'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `product.py`
- args: `'code'`
- code:
'table_h.column_exist('code')'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `product.py`
- args: `'suffix_code'`
- code:
'table_h.column_exist('suffix_code')'
- **after_super** `cursor`
- object: `Transaction().connection`
- files:
- `product.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `ProductCostPrice._table`
- code:
'backend.TableHandler.table_exist(
ProductCostPrice._table)'
- **after_super** `TableHandler`
- condition: `not exist and cost_price_exist`
- object: `backend`
- files:
- `product.py`
- args: `ProductCostPrice, module_name`
- code:
'backend.TableHandler(
ProductCostPrice, module_name)'
### 6.2
- **before_super** `column_exist`
- condition: `exist`
- object: `table`
- files:
- `party.py`
- args: `'company'`
- code:
'table.column_exist('company')'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `party.py`
- args: `'party.configuration', cls._configuration_value_field, cls, cls._configuration_value_field`
- kwargs:
- fields: `['company']`
- code:
'migrate_property(
'party.configuration', cls._configuration_value_field,
cls, cls._configuration_value_field, fields=['company'])'
- **after_super** `_migrate_property`
- condition: `not exist`
- object: `super(PartyLang, cls)`
- files:
- `party.py`
- args: `field_names, value_names, fields`
- code:
'super(PartyLang, cls)._migrate_property(
field_names, value_names, fields)'
- **after_super** `super`
- condition: `not exist`
- files:
- `party.py`
- args: `PartyLang, cls`
- code:
'super(PartyLang, cls)'
- **before_super** `cursor`
- object: `Transaction().connection`
- files:
- `country.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **after_super** `Transaction`
- files:
- `action.py`
- code:
'Transaction()'
- **after_super** `Concat`
- condition: `table.column_exist('digest') and table.column_exist('collision')`
- files:
- `attachment.py`
- args: `Concat(attachment.digest, '-'), attachment.collision`
- code:
'Concat(Concat(attachment.digest, '-'),
attachment.collision)'
- **after_super** `Concat`
- condition: `table.column_exist('digest') and table.column_exist('collision')`
- files:
- `attachment.py`
- args: `attachment.digest, '-'`
- code:
'Concat(attachment.digest, '-')'
- **after_super** `in_`
- object: `model_data_sql_table.fs_id`
- files:
- `module.py`
- args: `button_fs_ids`
- code:
'model_data_sql_table.fs_id.in_(button_fs_ids)'
- **before_super** `cursor`
- object: `transaction.connection`
- files:
- `translation.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **after_super** `timedelta`
- condition: `table.column_exist('minimum_delay')`
- object: `datetime`
- files:
- `trigger.py`
- kwargs:
- hours: `delay`
- code:
'datetime.timedelta(hours=(datetime.timedelta(hours=delay)))'
- **after_super** `Concat`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `Coalesce(sql_table.street, ''), Concat('\n', Coalesce(sql_table.streetbis, ''))`
- code:
'Concat(
Coalesce(sql_table.street, ''),
Concat('\n', Coalesce(sql_table.streetbis, '')))'
- **after_super** `Coalesce`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `sql_table.street, ''`
- code:
'Coalesce(sql_table.street, '')'
- **after_super** `Concat`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `'\n', Coalesce(sql_table.streetbis, '')`
- code:
'Concat('\n', Coalesce(sql_table.streetbis, ''))'
- **after_super** `Coalesce`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `sql_table.streetbis, ''`
- code:
'Coalesce(sql_table.streetbis, '')'
- **after_super** `execute`
- condition: `table_h.column_exist('country')`
- object: `cursor`
- files:
- `address.py`
- args: `*query`
- code:
'(Transaction().connection.cursor()).execute(*(table.update(
[table.language_code],
language.select(
Substring(language.code, 0, 2),
where=language.id == table.language))))'
- **after_super** `Substring`
- condition: `table_h.column_exist('language')`
- files:
- `address.py`
- args: `language.code, 0, 2`
- code:
'Substring(language.code, 0, 2)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `configuration.py`
- args: `'party.configuration', field_names, cls, value_names`
- kwargs:
- fields: `fields`
- code:
'migrate_property(
'party.configuration', field_names, cls, value_names,
fields=fields)'
- **after_super** `execute`
- condition: `party_h.column_exist('lang')`
- object: `cursor`
- files:
- `party.py`
- args: `*query`
- code:
'(Transaction().connection.cursor()).execute(*(table.insert(
[table.party, table.lang],
party.select(party.id, party.lang))))'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `party.py`
- args: `'party.party', field_names, cls, value_names`
- kwargs:
- parent: `'party'`
- fields: `fields`
- code:
'migrate_property(
'party.party', field_names, cls, value_names,
parent='party', fields=fields)'
- **after_super** `cls`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- files:
- `party.py`
- kwargs:
- party: `party_id`
- code: `code`
- type: `type`
- code:
'cls(party=party_id, code=code, type=type)'
- **after_super** `save`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- object: `cls`
- files:
- `party.py`
- args: `identifiers`
- code:
'cls.save(identifiers)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `configuration.py`
- args: `'product.configuration', field_names, cls, value_names`
- kwargs:
- fields: `fields`
- code:
'migrate_property(
'product.configuration', field_names, cls, value_names,
fields=fields)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `product.py`
- args: `'product.template', field_names, cls, value_names`
- kwargs:
- parent: `'template'`
- fields: `fields`
- code:
'migrate_property(
'product.template', field_names, cls, value_names,
parent='template', fields=fields)'
- **after_super** `Column`
- condition: `cost_price_table.column_exist('template')`
- files:
- `product.py`
- args: `sql_table, c`
- code:
'Column(sql_table, c)'
- **after_super** `Column`
- condition: `cost_price_table.column_exist('template')`
- files:
- `product.py`
- args: `cost_price, c`
- code:
'Column(cost_price, c)'
- **after_super** `select`
- condition: `table.column_exist('template')`
- object: `sql_table.join(product, condition=sql_table.template == product.template)`
- files:
- `product.py`
- args: `*[Column(sql_table, c) for c in columns] + [product.id]`
- kwargs:
- where: `(sql_table.template != Null) & (sql_table.product == Null)`
- code:
'sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null))'
- **after_super** `join`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- args: `product`
- kwargs:
- condition: `sql_table.template == product.template`
- code:
'sql_table.join(product,
condition=sql_table.template == product.template
)'
### 6.4
- **before_super** `Pool`
- files:
- `res.py`
- code:
'Pool()'
- **before_super** `Transaction`
- files:
- `res.py`
- code:
'Transaction()'
- **after_super** `cursor`
- object: `transaction.connection`
- files:
- `res.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **after_super** `Pool`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- code:
'Pool()'
- **after_super** `Concat`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- args: `action_model, Concat('|', sql_table.action_function)`
- code:
'Concat((model.select(
model.model, where=model.id == sql_table.action_model)), Concat(
'|', sql_table.action_function))'
- **after_super** `Concat`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- args: `'|', sql_table.action_function`
- code:
'Concat(
'|', sql_table.action_function)'
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `configuration.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
- **after_super** `get_cc_module`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- files:
- `party.py`
- args: `*type.split('_', 1)`
- code:
'get_cc_module(*type.split('_', 1))'
- **after_super** `split`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- object: `type`
- files:
- `party.py`
- args: `'_', 1`
- code:
'type.split('_', 1)'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `product.py`
- args: `'code'`
- code:
'table_h.column_exist('code')'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `product.py`
- args: `'suffix_code'`
- code:
'table_h.column_exist('suffix_code')'
- **after_super** `cursor`
- object: `Transaction().connection`
- files:
- `product.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `ProductCostPrice._table`
- code:
'backend.TableHandler.table_exist(
ProductCostPrice._table)'
- **after_super** `TableHandler`
- condition: `not exist and cost_price_exist`
- object: `backend`
- files:
- `product.py`
- args: `ProductCostPrice, module_name`
- code:
'backend.TableHandler(
ProductCostPrice, module_name)'
### 6.6
- **before_super** `column_exist`
- condition: `exist`
- object: `table`
- files:
- `party.py`
- args: `'company'`
- code:
'table.column_exist('company')'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `party.py`
- args: `'party.configuration', cls._configuration_value_field, cls, cls._configuration_value_field`
- kwargs:
- fields: `['company']`
- code:
'migrate_property(
'party.configuration', cls._configuration_value_field,
cls, cls._configuration_value_field, fields=['company'])'
- **after_super** `_migrate_property`
- condition: `not exist`
- object: `super(PartyLang, cls)`
- files:
- `party.py`
- args: `field_names, value_names, fields`
- code:
'super(PartyLang, cls)._migrate_property(
field_names, value_names, fields)'
- **after_super** `super`
- condition: `not exist`
- files:
- `party.py`
- args: `PartyLang, cls`
- code:
'super(PartyLang, cls)'
- **before_super** `cursor`
- object: `Transaction().connection`
- files:
- `country.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **after_super** `Transaction`
- files:
- `action.py`
- code:
'Transaction()'
- **after_super** `Concat`
- condition: `table.column_exist('digest') and table.column_exist('collision')`
- files:
- `attachment.py`
- args: `Concat(attachment.digest, '-'), attachment.collision`
- code:
'Concat(Concat(attachment.digest, '-'),
attachment.collision)'
- **after_super** `Concat`
- condition: `table.column_exist('digest') and table.column_exist('collision')`
- files:
- `attachment.py`
- args: `attachment.digest, '-'`
- code:
'Concat(attachment.digest, '-')'
- **after_super** `in_`
- object: `model_data_sql_table.fs_id`
- files:
- `module.py`
- args: `button_fs_ids`
- code:
'model_data_sql_table.fs_id.in_(button_fs_ids)'
- **before_super** `cursor`
- object: `transaction.connection`
- files:
- `translation.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **after_super** `timedelta`
- condition: `table.column_exist('minimum_delay')`
- object: `datetime`
- files:
- `trigger.py`
- kwargs:
- hours: `delay`
- code:
'datetime.timedelta(hours=(datetime.timedelta(hours=delay)))'
- **after_super** `Concat`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `Coalesce(sql_table.street, ''), Concat('\n', Coalesce(sql_table.streetbis, ''))`
- code:
'Concat(
Coalesce(sql_table.street, ''),
Concat('\n', Coalesce(sql_table.streetbis, '')))'
- **after_super** `Coalesce`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `sql_table.street, ''`
- code:
'Coalesce(sql_table.street, '')'
- **after_super** `Concat`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `'\n', Coalesce(sql_table.streetbis, '')`
- code:
'Concat('\n', Coalesce(sql_table.streetbis, ''))'
- **after_super** `Coalesce`
- condition: `table.column_exist('streetbis')`
- files:
- `address.py`
- args: `sql_table.streetbis, ''`
- code:
'Coalesce(sql_table.streetbis, '')'
- **after_super** `execute`
- condition: `table_h.column_exist('country')`
- object: `cursor`
- files:
- `address.py`
- args: `*query`
- code:
'(Transaction().connection.cursor()).execute(*(table.update(
[table.language_code],
language.select(
Substring(language.code, 0, 2),
where=language.id == table.language))))'
- **after_super** `Substring`
- condition: `table_h.column_exist('language')`
- files:
- `address.py`
- args: `language.code, 0, 2`
- code:
'Substring(language.code, 0, 2)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `configuration.py`
- args: `'party.configuration', field_names, cls, value_names`
- kwargs:
- fields: `fields`
- code:
'migrate_property(
'party.configuration', field_names, cls, value_names,
fields=fields)'
- **after_super** `execute`
- condition: `party_h.column_exist('lang')`
- object: `cursor`
- files:
- `party.py`
- args: `*query`
- code:
'(Transaction().connection.cursor()).execute(*(table.insert(
[table.party, table.lang],
party.select(party.id, party.lang))))'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `party.py`
- args: `'party.party', field_names, cls, value_names`
- kwargs:
- parent: `'party'`
- fields: `fields`
- code:
'migrate_property(
'party.party', field_names, cls, value_names,
parent='party', fields=fields)'
- **after_super** `cls`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- files:
- `party.py`
- kwargs:
- party: `party_id`
- code: `code`
- type: `type`
- code:
'cls(party=party_id, code=code, type=type)'
- **after_super** `save`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- object: `cls`
- files:
- `party.py`
- args: `identifiers`
- code:
'cls.save(identifiers)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `configuration.py`
- args: `'product.configuration', field_names, cls, value_names`
- kwargs:
- fields: `fields`
- code:
'migrate_property(
'product.configuration', field_names, cls, value_names,
fields=fields)'
- **after_super** `migrate_property`
- condition: `not exist`
- files:
- `product.py`
- args: `'product.template', field_names, cls, value_names`
- kwargs:
- parent: `'template'`
- fields: `fields`
- code:
'migrate_property(
'product.template', field_names, cls, value_names,
parent='template', fields=fields)'
- **after_super** `Column`
- condition: `cost_price_table.column_exist('template')`
- files:
- `product.py`
- args: `sql_table, c`
- code:
'Column(sql_table, c)'
- **after_super** `Column`
- condition: `cost_price_table.column_exist('template')`
- files:
- `product.py`
- args: `cost_price, c`
- code:
'Column(cost_price, c)'
- **after_super** `select`
- condition: `table.column_exist('template')`
- object: `sql_table.join(product, condition=sql_table.template == product.template)`
- files:
- `product.py`
- args: `*[Column(sql_table, c) for c in columns] + [product.id]`
- kwargs:
- where: `(sql_table.template != Null) & (sql_table.product == Null)`
- code:
'sql_table.join(product,
condition=sql_table.template == product.template
).select(
*[Column(sql_table, c) for c in columns]
+ [product.id],
where=(sql_table.template != Null)
& (sql_table.product == Null))'
- **after_super** `join`
- condition: `table.column_exist('template')`
- object: `sql_table`
- files:
- `product.py`
- args: `product`
- kwargs:
- condition: `sql_table.template == product.template`
- code:
'sql_table.join(product,
condition=sql_table.template == product.template
)'
### 6.8
- **before_super** `Pool`
- files:
- `res.py`
- code:
'Pool()'
- **before_super** `Transaction`
- files:
- `res.py`
- code:
'Transaction()'
- **after_super** `cursor`
- object: `transaction.connection`
- files:
- `res.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **after_super** `Pool`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- code:
'Pool()'
- **after_super** `Concat`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- args: `action_model, Concat('|', sql_table.action_function)`
- code:
'Concat((model.select(
model.model, where=model.id == sql_table.action_model)), Concat(
'|', sql_table.action_function))'
- **after_super** `Concat`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- args: `'|', sql_table.action_function`
- code:
'Concat(
'|', sql_table.action_function)'
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `configuration.py`
- args: `cls._table`
- code:
'backend.TableHandler.table_exist(cls._table)'
- **after_super** `get_cc_module`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- files:
- `party.py`
- args: `*type.split('_', 1)`
- code:
'get_cc_module(*type.split('_', 1))'
- **after_super** `split`
- condition: `party_h.column_exist('vat_number') and party_h.column_exist('vat_country')`
- object: `type`
- files:
- `party.py`
- args: `'_', 1`
- code:
'type.split('_', 1)'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `product.py`
- args: `'code'`
- code:
'table_h.column_exist('code')'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `product.py`
- args: `'suffix_code'`
- code:
'table_h.column_exist('suffix_code')'
- **after_super** `cursor`
- object: `Transaction().connection`
- files:
- `product.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **before_super** `table_exist`
- object: `backend.TableHandler`
- files:
- `product.py`
- args: `ProductCostPrice._table`
- code:
'backend.TableHandler.table_exist(
ProductCostPrice._table)'
### 7.0
- **before_super** `cursor`
- object: `Transaction().connection`
- files:
- `country.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `export.py`
- args: `'user'`
- code:
'table_h.column_exist('user')'
- **after_super** `cursor`
- object: `Transaction().connection`
- files:
- `trigger.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **after_super** `Transaction`
- files:
- `trigger.py`
- code:
'Transaction()'
- **after_super** `execute`
- condition: `table_h.column_exist('country')`
- object: `cursor`
- files:
- `address.py`
- args: `*query`
- code:
'(Transaction().connection.cursor()).execute(*(table.update(
[table.language_code],
language.select(
Substring(language.code, 0, 2),
where=language.id == table.language))))'
- **after_super** `Substring`
- condition: `table_h.column_exist('language')`
- files:
- `address.py`
- args: `language.code, 0, 2`
- code:
'Substring(language.code, 0, 2)'
- **after_super** `cls`
- files:
- `configuration.py`
- args: `1`
- code:
'cls(1)'
- **after_super** `tuple`
- condition: `configuration.identifier_types`
- files:
- `configuration.py`
- args: `map(replace_vat, configuration.identifier_types)`
- code:
'tuple(map(
replace_vat, configuration.identifier_types))'
- **after_super** `map`
- condition: `configuration.identifier_types`
- files:
- `configuration.py`
- args: `replace_vat, configuration.identifier_types`
- code:
'map(
replace_vat, configuration.identifier_types)'
- **after_super** `sql_format`
- condition: `configuration.identifier_types != identifier_types`
- object: `cls.identifier_types`
- files:
- `configuration.py`
- args: `identifier_types`
- code:
'cls.identifier_types.sql_format(identifier_types)'
- **after_super** `replace_vat`
- files:
- `party.py`
- args: `old`
- code:
'replace_vat(old)'
### 7.2
- **before_super** `Pool`
- files:
- `res.py`
- code:
'Pool()'
- **before_super** `Transaction`
- files:
- `res.py`
- code:
'Transaction()'
- **after_super** `cursor`
- object: `transaction.connection`
- files:
- `res.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **before_super** `cursor`
- object: `transaction.connection`
- files:
- `model.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **after_super** `Pool`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- code:
'Pool()'
- **after_super** `Concat`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- args: `action_model, Concat('|', sql_table.action_function)`
- code:
'Concat((model.select(
model.model, where=model.id == sql_table.action_model)), Concat(
'|', sql_table.action_function))'
- **after_super** `Concat`
- condition: `table_h.column_exist('action_model') and table_h.column_exist('action_function')`
- files:
- `trigger.py`
- args: `'|', sql_table.action_function`
- code:
'Concat(
'|', sql_table.action_function)'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `product.py`
- args: `'code'`
- code:
'table_h.column_exist('code')'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `product.py`
- args: `'suffix_code'`
- code:
'table_h.column_exist('suffix_code')'
### 7.4
- **before_super** `cursor`
- object: `Transaction().connection`
- files:
- `country.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `export.py`
- args: `'user'`
- code:
'table_h.column_exist('user')'
- **after_super** `cursor`
- object: `Transaction().connection`
- files:
- `trigger.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **after_super** `Transaction`
- files:
- `trigger.py`
- code:
'Transaction()'
- **after_super** `execute`
- condition: `table_h.column_exist('country')`
- object: `cursor`
- files:
- `address.py`
- args: `*query`
- code:
'(Transaction().connection.cursor()).execute(*(table.update(
[table.language_code],
language.select(
Substring(language.code, 0, 2),
where=language.id == table.language))))'
- **after_super** `Substring`
- condition: `table_h.column_exist('language')`
- files:
- `address.py`
- args: `language.code, 0, 2`
- code:
'Substring(language.code, 0, 2)'
- **after_super** `cls`
- files:
- `configuration.py`
- args: `1`
- code:
'cls(1)'
- **after_super** `tuple`
- condition: `configuration.identifier_types`
- files:
- `configuration.py`
- args: `map(replace_vat, configuration.identifier_types)`
- code:
'tuple(map(
replace_vat, configuration.identifier_types))'
- **after_super** `map`
- condition: `configuration.identifier_types`
- files:
- `configuration.py`
- args: `replace_vat, configuration.identifier_types`
- code:
'map(
replace_vat, configuration.identifier_types)'
- **after_super** `sql_format`
- condition: `configuration.identifier_types != identifier_types`
- object: `cls.identifier_types`
- files:
- `configuration.py`
- args: `identifier_types`
- code:
'cls.identifier_types.sql_format(identifier_types)'
- **after_super** `replace_vat`
- files:
- `party.py`
- args: `old`
- code:
'replace_vat(old)'
### 7.6
- **before_super** `Transaction`
- files:
- `export.py`
- code:
'Transaction()'
- **before_super** `Pool`
- files:
- `model.py`
- code:
'Pool()'
- **before_super** `cursor`
- object: `transaction.connection`
- files:
- `model.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
### 7.8
- **before_super** `cursor`
- object: `Transaction().connection`
- files:
- `export.py`
- code:
'Transaction().connection.(Transaction().connection.cursor())()'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `export.py`
- args: `'user'`
- code:
'table_h.column_exist('user')'
- **after_super** `cls`
- files:
- `configuration.py`
- args: `1`
- code:
'cls(1)'
- **after_super** `tuple`
- condition: `configuration.identifier_types`
- files:
- `configuration.py`
- args: `map(replace_vat, configuration.identifier_types)`
- code:
'tuple(map(
replace_vat, configuration.identifier_types))'
- **after_super** `map`
- condition: `configuration.identifier_types`
- files:
- `configuration.py`
- args: `replace_vat, configuration.identifier_types`
- code:
'map(
replace_vat, configuration.identifier_types)'
- **after_super** `sql_format`
- condition: `configuration.identifier_types != identifier_types`
- object: `cls.identifier_types`
- files:
- `configuration.py`
- args: `identifier_types`
- code:
'cls.identifier_types.sql_format(identifier_types)'
- **after_super** `replace_vat`
- files:
- `party.py`
- args: `old`
- code:
'replace_vat(old)'
### 8.0
- **before_super** `Transaction`
- files:
- `export.py`
- code:
'Transaction()'
- **before_super** `Pool`
- files:
- `model.py`
- code:
'Pool()'
- **before_super** `cursor`
- object: `transaction.connection`
- files:
- `model.py`
- code:
'transaction.connection.(transaction.connection.cursor())()'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `party.py`
- args: `'code'`
- code:
'table_h.column_exist('code')'
- **before_super** `column_exist`
- object: `table_h`
- files:
- `party.py`
- args: `'code_compact'`
- code:
'table_h.column_exist('code_compact')'
first version compare.py: compile changes by module
2026-08-07 22:54:22 +02:00
Reference in New Issue Copy Permalink