关键词：数据库、分开
适用机型:supernova系列
1、修改target\makefile prepareDatabase:
ifeq ($(MSTAR_TVOS), 1)
ifeq ($(SQL_DB_ENABLE), 1)
@echo "Start to prepare database image ..."
@mkdir -p $(TMP_IMG_FOLDER)
@[ '-d $(TMP_IMG_FOLDER)/Database/' ] && rm -rf $(TMP_IMG_FOLDER)/Database
@mkdir -p $(TMP_IMG_FOLDER)/Database
ifeq ($(ENABLE_4K2K_NIKEU), 1)
@if [ -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ]; then echo " " ; \
else $(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; \
$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_nike.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; fi
else ifeq ($(ENABLE_4K2K_FRC), 1)
ifeq ($(ENABLE_4K2K_FRC_LG), 1)
@if [ -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ]; then echo " " ; \
else $(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; \
$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_frc_lg.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; fi
else
@if [ -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ]; then echo " " ; \
else $(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; \
$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_frc.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; fi
endif
else ifeq ($(ENABLE_4K2K_NAPOLI), 1)
ifeq ($(URSA_TYPE), 0x06)
@if [ -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ]; then echo " " ; \
else $(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; \
$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_napoli_ursa6_vb1.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; fi
else ifeq ($(URSA_TYPE), 1000)
@if [ -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ]; then echo " " ; \
else $(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; \
$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_napoli_nova_vb1.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; fi
else ifeq ($(URSA_TYPE), 0x07)
@if [ -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ]; then echo " " ; \
else $(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; \
$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_napoli_ursa7_vb1.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; fi
else
@if [ -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ]; then echo " " ; \
else $(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; \
$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_napoli.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; fi
endif
else
@if [ -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ]; then echo " " ; else $(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db ; fi
endif
@if [ -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/customer.db ]; then echo " " ; else $(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/customer.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/customer.db ; fi
@if [ -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factory.db ]; then echo " " ; else $(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factory.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factory.db ; fi
@if [ -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factorysetup.db ]; then echo " " ; else $(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factorysetup.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factorysetup.db ; fi
@cp -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db $(TMP_IMG_FOLDER)/Database
@cp -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factory.db $(TMP_IMG_FOLDER)/Database
@cp -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/customer.db $(TMP_IMG_FOLDER)/Database
@cp -f $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factorysetup.db $(TMP_IMG_FOLDER)/Database
@touch $(TMP_IMG_FOLDER)/Database/user_setting.db-journal
@touch $(TMP_IMG_FOLDER)/Database/factory.db-journal
@touch $(TMP_IMG_FOLDER)/Database/customer.db-journal
@touch $(TMP_IMG_FOLDER)/Database/factorysetup.db-journal
@chmod 777 $(TMP_IMG_FOLDER)/Database/*.db*
@echo "Start to prepare databasebackup image ..."
@[ '-d $(TMP_IMG_FOLDER)/DatabaseBackup/' ] && rm -rf $(TMP_IMG_FOLDER)/DatabaseBackup
@mkdir -p $(TMP_IMG_FOLDER)/DatabaseBackup
@cp $(TMP_IMG_FOLDER)/Database/*.db $(TMP_IMG_FOLDER)/DatabaseBackup/
@rm -rf $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db
@rm -rf $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factory.db
@rm -rf $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/customer.db
@rm -rf $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factorysetup.db
endif
endif
2、修改projects/makefile
SEC_TOOL_IMPORT_SQL:=$(PHOTOSPHERE_ROOT)/projects/msrv/system_database/ImportSql
system_database: snlibs
ifeq ($(MSTAR_TVOS), 1)
ifeq ($(SQL_DB_ENABLE), 1)
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factory.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factory.db
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/customer.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/customer.db
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factorysetup.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/factorysetup.db
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db
ifeq ($(ENABLE_4K2K_NIKEU), 1)
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_nike.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db
else ifeq ($(ENABLE_4K2K_NAPOLI), 1)
ifeq ($(URSA_TYPE), 0x06)
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_napoli_ursa6_vb1.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db
else ifeq ($(URSA_TYPE), 1000)
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_napoli_nova_vb1.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db
else ifeq ($(URSA_TYPE), 0x07)
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_napoli_ursa7_vb1.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db
else
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_napoli.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db
endif
else ifeq ($(ENABLE_4K2K_FRC), 1)
ifeq ($(ENABLE_4K2K_FRC_LG), 1)
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_frc_lg.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db
else
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_frc.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db
endif
endif
ifeq ($(STB_ENABLE), 1)
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_box.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db
endif
ifeq ($(ISDB_SYSTEM_ENABLE),1)
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_isdb.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db
endif
ifeq ($(HDMITX_ENABLE), 1)
@$(SEC_TOOL_IMPORT_SQL)/import_sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting_4k2k_napoli_rocket.sql $(PHOTOSPHERE_ROOT)/projects/board/$(CHIP)/$(BOARD_NAME)/database/user_setting.db
endif
endif
endif
@$(MAKE) -C ./msrv/system_database LOW_MEM=$(LOW_MEM) all_libs
|
