Builder Update

Update data in the Database

First

Excepted Types in set

• String
• Integer
• Arithmetic

Example

connection.table("myTable").update()

Repeatable

• all of conditions builder
• all of base join extention
• set(column: str, value) - set the data of a specific column
• join_set(join_table: str, join_column: str, value) - set the data of a specific column of a join table, but you have to specify the table of the join from which you want to set the column.
• im_sure_im_not_use_conditions() - security so that you do not unknowingly overwrite everything
• set_json(self, json: Dict[str, any], pop: List[str] = None) - set data with a valid json, witch you can example get it with a select. Sub dict will default insert as a join, so do not forget when it is time to set a join builder. Pop- pop keys from the json, if you have joins in select that not should insert in a table.

Endpoints

• execute()
• get_sql()

Example Code

# update all
connection.table("myTable").update().set("age", 25).im_sure_im_not_use_conditions().execute()
# update multiple
connection.table("myTable").update().set("age", 25).set("name", "Helgo").im_sure_im_not_use_conditions().execute()

# update with where statements
connection.table("myTable").update().set("age", 25).where("id", 10).execute()

# update with join

connection.table("myTable").update().set("age", 26).join(InnerJoinBuilder("otherTable").condition("id", "otherId")).join_set("otherTable", "note", "Birthday today").execute()