import frappe
from frappe.model.utils.rename_field import rename_field

def execute():
	frappe.reload_doc("hr", "doctype", "leave_type")
	frappe.db.sql_ddl("""ALTER table `tabLeave Type` modify max_days_allowed int(8) NOT NULL""")
	rename_field("Leave Type", "max_days_allowed", "max_continuous_days_allowed") 

import frappe

def execute():
	frappe.db.sql("""
		UPDATE `tabLeave Type`
		SET max_days_allowed = '0'
		WHERE trim(coalesce(max_days_allowed, '')) = ''
	""")
	frappe.db.sql_ddl("""ALTER table `tabLeave Type` modify max_days_allowed int(8) NOT NULL""")


Set null values to '0' before changing column type
[fix] Set null values to '0' before changing column type

  import frappe
- from frappe.model.utils.rename_field import rename_field
  
  def execute():
- 	frappe.reload_doc("hr", "doctype", "leave_type")
+ 	frappe.db.sql("""
+ 		UPDATE `tabLeave Type`
+ 		SET max_days_allowed = '0'
+ 		WHERE trim(coalesce(max_days_allowed, '')) = ''
+ 	""")
  	frappe.db.sql_ddl("""ALTER table `tabLeave Type` modify max_days_allowed int(8) NOT NULL""")
- 	rename_field("Leave Type", "max_days_allowed", "max_continuous_days_allowed") 
  
+ 
Set null values to '0' before changing column type
## Code Before:
import frappe
from frappe.model.utils.rename_field import rename_field

def execute():
	frappe.reload_doc("hr", "doctype", "leave_type")
	frappe.db.sql_ddl("""ALTER table `tabLeave Type` modify max_days_allowed int(8) NOT NULL""")
	rename_field("Leave Type", "max_days_allowed", "max_continuous_days_allowed") 

## Instruction:
Set null values to '0' before changing column type
## Code After:
import frappe

def execute():
	frappe.db.sql("""
		UPDATE `tabLeave Type`
		SET max_days_allowed = '0'
		WHERE trim(coalesce(max_days_allowed, '')) = ''
	""")
	frappe.db.sql_ddl("""ALTER table `tabLeave Type` modify max_days_allowed int(8) NOT NULL""")

