import frappe

def execute():
	if frappe.db.exists('DocType', 'View log'):
		frappe.reload_doc('core', 'doctype', 'view_log', force=True)
		frappe.db.sql("INSERT INTO `tabView Log` SELECT * from `tabView log`")
		frappe.delete_doc('DocType', 'View log')
		frappe.reload_doc('core', 'doctype', 'view_log', force=True)
	else:
		frappe.reload_doc('core', 'doctype', 'view_log')

import frappe

def execute():
	if frappe.db.exists('DocType', 'View log'):
		# for mac users direct renaming would not work since mysql for mac saves table name in lower case
		# so while renaming `tabView log` to `tabView Log` we get "Table 'tabView Log' already exists" error
		# more info https://stackoverflow.com/a/44753093/5955589 ,
		# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names

		# here we are creating a temp table to store view log data
		frappe.db.sql("CREATE TABLE `ViewLogTemp` AS SELECT * FROM `tabView log`")

		# deleting old View log table
		frappe.db.sql("DROP table `tabView log`")
		frappe.delete_doc('DocType', 'View log')

		# reloading view log doctype to create `tabView Log` table
		frappe.reload_doc('core', 'doctype', 'view_log')
		frappe.db.commit()

		# Move the data to newly created `tabView Log` table
		frappe.db.sql("INSERT INTO `tabView Log` SELECT * FROM `ViewLogTemp`")

		# Delete temporary table
		frappe.db.sql("DROP table `ViewLogTemp`")
	else:
		frappe.reload_doc('core', 'doctype', 'view_log')

Fix rename view log patch for mac users
Fix rename view log patch for mac users

for mac users direct renaming would not work
since mysql for mac saves table name in lower case,
so while renaming `tabView log` to `tabView Log` we get
"Table 'tabView Log' already exists" error

# more info https://stackoverflow.com/a/44753093/5955589
https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names

  import frappe
  
  def execute():
  	if frappe.db.exists('DocType', 'View log'):
- 		frappe.reload_doc('core', 'doctype', 'view_log', force=True)
- 		frappe.db.sql("INSERT INTO `tabView Log` SELECT * from `tabView log`")
+ 		# for mac users direct renaming would not work since mysql for mac saves table name in lower case
+ 		# so while renaming `tabView log` to `tabView Log` we get "Table 'tabView Log' already exists" error
+ 		# more info https://stackoverflow.com/a/44753093/5955589 ,
+ 		# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names
+ 
+ 		# here we are creating a temp table to store view log data
+ 		frappe.db.sql("CREATE TABLE `ViewLogTemp` AS SELECT * FROM `tabView log`")
+ 
+ 		# deleting old View log table
+ 		frappe.db.sql("DROP table `tabView log`")
  		frappe.delete_doc('DocType', 'View log')
+ 
+ 		# reloading view log doctype to create `tabView Log` table
- 		frappe.reload_doc('core', 'doctype', 'view_log', force=True)
+ 		frappe.reload_doc('core', 'doctype', 'view_log')
+ 		frappe.db.commit()
+ 
+ 		# Move the data to newly created `tabView Log` table
+ 		frappe.db.sql("INSERT INTO `tabView Log` SELECT * FROM `ViewLogTemp`")
+ 
+ 		# Delete temporary table
+ 		frappe.db.sql("DROP table `ViewLogTemp`")
  	else:
  		frappe.reload_doc('core', 'doctype', 'view_log')
  
Fix rename view log patch for mac users
## Code Before:
import frappe

def execute():
	if frappe.db.exists('DocType', 'View log'):
		frappe.reload_doc('core', 'doctype', 'view_log', force=True)
		frappe.db.sql("INSERT INTO `tabView Log` SELECT * from `tabView log`")
		frappe.delete_doc('DocType', 'View log')
		frappe.reload_doc('core', 'doctype', 'view_log', force=True)
	else:
		frappe.reload_doc('core', 'doctype', 'view_log')

## Instruction:
Fix rename view log patch for mac users
## Code After:
import frappe

def execute():
	if frappe.db.exists('DocType', 'View log'):
		# for mac users direct renaming would not work since mysql for mac saves table name in lower case
		# so while renaming `tabView log` to `tabView Log` we get "Table 'tabView Log' already exists" error
		# more info https://stackoverflow.com/a/44753093/5955589 ,
		# https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names

		# here we are creating a temp table to store view log data
		frappe.db.sql("CREATE TABLE `ViewLogTemp` AS SELECT * FROM `tabView log`")

		# deleting old View log table
		frappe.db.sql("DROP table `tabView log`")
		frappe.delete_doc('DocType', 'View log')

		# reloading view log doctype to create `tabView Log` table
		frappe.reload_doc('core', 'doctype', 'view_log')
		frappe.db.commit()

		# Move the data to newly created `tabView Log` table
		frappe.db.sql("INSERT INTO `tabView Log` SELECT * FROM `ViewLogTemp`")

		# Delete temporary table
		frappe.db.sql("DROP table `ViewLogTemp`")
	else:
		frappe.reload_doc('core', 'doctype', 'view_log')
