package com.basic.security.manager; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.os.SystemClock; import com.basic.security.base.BaseApplication; import com.basic.security.manager.impl.cblite.DeviceManager; import com.basic.security.manager.impl.cblite.PersonIdentityManager; import com.basic.security.manager.impl.cblite.PersonManager; import com.basic.security.manager.impl.cblite.RuleManager; import com.basic.security.manager.impl.cblite.UserManager; import com.basic.security.manager.impl.erlang.ErlangProcess; import com.basic.security.manager.impl.erlang.NodeNameManager; import com.basic.security.manager.impl.sqlite.DatabaseManager; import com.basic.security.manager.impl.sqlite.FeatureManager; import com.basic.security.manager.impl.sqlite.SlBaseManager; import com.basic.security.manager.impl.sqlite.SlDeviceManager; import com.basic.security.manager.impl.sqlite.SlHintDoorAccessManager; import com.basic.security.utils.Constants; import com.basic.security.utils.IpUtils; import com.basic.security.model.ModelAdapter; import java.util.ArrayList; import java.util.Arrays; import java.util.List; public class SystemInitManager { public static void initTablesAndDefaultValues() { new Thread(){ @Override public void run() { createTablesInBaseDatabase(); createTablesInCacheDatabase(); createTablesInSyncDatabase(); initDefaultValues(); FeatureManager.initCppFeatureMap(); OfficeDeviceManager.initOfficeDevice(); } }.start(); } public static void initDefaultValues() { try { String deviceId = SlDeviceManager.getDeviceId(); ModelAdapter adminIdentity = SlBaseManager.findById("identity", "adminIdentity"); if (adminIdentity == null) { adminIdentity = new ModelAdapter( "adminIdentity"); adminIdentity.setString("table", "identity"); adminIdentity.setString("name", "管理员"); adminIdentity.setString("auto_init", "1"); adminIdentity.setString("device_id", DeviceManager.getDeviceId()); adminIdentity.setString("company_id", DeviceManager.getCompareId()); } RuleManager.saveRule(adminIdentity); ModelAdapter staffIdentity = SlBaseManager.findById("identity", "staffIdentity"); if (staffIdentity == null) { staffIdentity = new ModelAdapter( "staffIdentity"); staffIdentity.setString("table", "identity"); staffIdentity.setString("name", "老师"); staffIdentity.setString("device_id", DeviceManager.getDeviceId()); staffIdentity.setString("company_id", DeviceManager.getCompareId()); } RuleManager.saveRule(staffIdentity); ModelAdapter blackListIdentity = SlBaseManager.findById("identity", "blackListIdentity"); if (blackListIdentity == null) { blackListIdentity = new ModelAdapter( "blackListIdentity"); blackListIdentity.setString("table", "identity"); blackListIdentity.setString("name", "内部人员"); blackListIdentity.setString("device_id", DeviceManager.getDeviceId()); blackListIdentity.setString("company_id", DeviceManager.getCompareId()); } RuleManager.saveRule(blackListIdentity); // ModelAdapter autoSignUpIdentity = SlBaseManager.findById("identity", "autoSignUpIdentity"); // if (autoSignUpIdentity == null) { // autoSignUpIdentity = new ModelAdapter( "autoSignUpIdentity"); // autoSignUpIdentity.setString("table", "identity"); // autoSignUpIdentity.setString("name", "自助注册"); // autoSignUpIdentity.setString("device_id", DeviceManager.getDeviceId()); // autoSignUpIdentity.setString("company_id", DeviceManager.getCompareId()); // } // RuleManager.saveRule(autoSignUpIdentity); ModelAdapter admin_person = SlBaseManager.findById("person", deviceId + "admin_person"); if (admin_person == null) { admin_person = new ModelAdapter(deviceId + "admin_person") .setString("name", "系统管理员") .setString("sign_up_status", "已注册") .setString("verify_status", "不需要验证身份证") .setString("sign_up_method", "系统初始化分配") .setString("sign_up_time", System.currentTimeMillis() + "") .setString("device_id", DeviceManager.getDeviceId()) //是系统初始化默认设定的 不能删除这个person的管理员身份 .setString("auto_init", "1") .setString("company_id", DeviceManager.getCompareId()) .setString("table", "person"); } PersonManager.savePerson(admin_person); ModelAdapter admin_user_table = SlBaseManager.findById("user", deviceId + "admin_user"); if (admin_user_table == null) { admin_user_table = new ModelAdapter(deviceId + "admin_user") .setString("table", "user") .setString("name", "系统管理员") .setString("person_id", admin_person.getId()) .setString("username", "admin") .setString("auto_init", "1") .setString("password", "admin123") .setString("device_id", DeviceManager.getDeviceId()) .setString("company_id", DeviceManager.getCompareId()); } UserManager.saveUser(admin_user_table); ModelAdapter admin_person_identity = SlBaseManager.findById("person_identity", deviceId + "admin_person_identity"); if (admin_person_identity == null) { admin_person_identity = new ModelAdapter(deviceId + "admin_person_identity") .setString("table", "person_identity") .setString("identity_id", adminIdentity.getId()) .setString("auto_init", "1") .setString("person_id", admin_person.getId()) .setString("device_id", DeviceManager.getDeviceId()) .setString("company_id", DeviceManager.getCompareId()); } PersonIdentityManager.savePersonIdentity(admin_person_identity); ModelAdapter baseSetting = SlBaseManager.findById("base_setting", deviceId + "base_setting"); if (baseSetting == null) { baseSetting = new ModelAdapter(deviceId + "base_setting"); //自动注册模式 1是，0否 baseSetting.setString("auto_mode", "0"); baseSetting.setString("auto_mode_verify_phone", "1"); //管理员授权注册模式 1是，0否 baseSetting.setString("admin_mode", "1"); //自动注册模式身份证是否必选 1必选，0非必选 ////这个 好像 原来没加 2018/10/12 10：12 zyg //是否为普通验证 1是，0否 baseSetting.setString("admin_normal_verify", "1"); //普通验证 手机号是否必填 1是，0否 baseSetting.setString("admin_normal_verify_phone", "0"); //普通验证 身份证号是否必填 1是，0否 baseSetting.setString("admin_normal_verify_idcard", "0"); //普通验证 姓名是否必填 1是，0否 baseSetting.setString("admin_normal_verify_name", "0"); //身份证验证1是，0否 baseSetting.setString("admin_idcard_verify", "0"); //身份证验证,手机号是否必填 1是，0否 baseSetting.setString("admin_idcard_verify_phone", "1"); //管理员登入后几分钟自动退出 baseSetting.setString("edit_setting", "1"); //几秒返回首页 baseSetting.setString("back_to_home", "10"); //人脸占屏幕比例 baseSetting.setString("face_ratio", "2/10"); //人脸角度 baseSetting.setString("face_angle", "30"); //是否设置图片轮播 1是，0否 baseSetting.setString("image_play_interval", "1"); //轮播图片时间 baseSetting.setString("image_play_time", "5"); //允许多张人脸检测 1是，0否 baseSetting.setString("detect_multiple_face", "0"); //开门时长 baseSetting.setString("open_door_duration", "10"); //表名 baseSetting.setString("table", "base_setting"); baseSetting.setString("device_id", DeviceManager.getDeviceId()); baseSetting.setString("company_id", DeviceManager.getCompareId()); SlBaseManager.save(baseSetting); } ModelAdapter device = SlBaseManager.findById("device", deviceId + "device"); if (device == null) { device = new ModelAdapter(deviceId + "device"); device.setString("device_id", SlDeviceManager.getDeviceId()); device.setString("ip", IpUtils.getIpAddress(BaseApplication.getApplication())); device.setString("name", DeviceManager.getDeviceId()); device.setString("open_door_time", "5"); device.setString("no_face_delay", "10"); device.setString("table", "device"); } SlBaseManager.save(device); ModelAdapter hintDoorAccess = SlHintDoorAccessManager.findById("hint_door_access", deviceId + "hint_door_access"); if (hintDoorAccess == null) { hintDoorAccess = new ModelAdapter(deviceId + "hint_door_access"); hintDoorAccess.setString("access_identity", "1"); hintDoorAccess.setString("access_name", "1"); hintDoorAccess.setString("access_hint", "请通行"); hintDoorAccess.setString("not_reached_time_hint", "未到时间,请稍等"); hintDoorAccess.setString("not_reached_time_remind", "60"); hintDoorAccess.setString("time_unit", "分钟"); hintDoorAccess.setString("confirm_pass_identity", "1"); hintDoorAccess.setString("confirm_pass_name", "1"); hintDoorAccess.setString("confirm_pass_hint", "请通行"); hintDoorAccess.setString("refuse_pass_identity", "1"); hintDoorAccess.setString("refuse_pass_name", "1"); hintDoorAccess.setString("refuse_pass_hint", "拒绝通行"); hintDoorAccess.setString("device_id", SlDeviceManager.getDeviceId()); hintDoorAccess.setString("table", "hint_door_access"); SlBaseManager.save(hintDoorAccess); } ModelAdapter hint_recognize_message = SlHintDoorAccessManager.findById("hint_recognize_message", deviceId + "hint_recognize_message"); if (hint_recognize_message == null) { hint_recognize_message = new ModelAdapter(deviceId + "hint_recognize_message"); hint_recognize_message.setString("head_up", "15"); hint_recognize_message.setString("head_up_message", "请低头"); hint_recognize_message.setString("head_down", "15"); hint_recognize_message.setString("head_down_message", "请抬头"); hint_recognize_message.setString("face_max", "15"); hint_recognize_message.setString("face_max_message", "请正脸对准摄像头"); hint_recognize_message.setString("face_min", "15"); hint_recognize_message.setString("face_min_message", "请正脸对准摄像头"); hint_recognize_message.setString("rotation_left", "15"); hint_recognize_message.setString("rotation_left_message", "请正脸对准摄像头"); hint_recognize_message.setString("rotation_right", "15"); hint_recognize_message.setString("rotation_right_message", "请正脸对准摄像头"); // hint_recognize_message.setString("all_fit", "正在识别中"); hint_recognize_message.setString("all_fit", "请调整人脸角度和距离"); hint_recognize_message.setString("device_id", SlDeviceManager.getDeviceId()); hint_recognize_message.setString("table", "hint_recognize_message"); SlBaseManager.save(hint_recognize_message); } ModelAdapter hint_sign_up = SlHintDoorAccessManager.findById("hint_sign_up", deviceId + "hint_sign_up"); if (hint_sign_up == null) { hint_sign_up = new ModelAdapter(deviceId + "hint_sign_up"); hint_sign_up.setString("no_register", "请注册"); hint_sign_up.setString("id_card_message", "请刷身份证"); hint_sign_up.setString("id_card_success", "身份证验证成功"); hint_sign_up.setString("id_card_fail", "身份证验证失败"); hint_sign_up.setString("edit_message", "请完善信息"); hint_sign_up.setString("register_success", "注册成功"); hint_sign_up.setString("admin_logout", "请联系管理员为您注册"); hint_sign_up.setString("device_id", SlDeviceManager.getDeviceId()); hint_sign_up.setString("table", "hint_sign_up"); SlBaseManager.save(hint_sign_up); } // DatabaseManager.getDatabase(Constants.cacheDatabasePath).close(); // DatabaseManager.getDatabase(Constants.syncDatabasePath).close(); SystemClock.sleep(1000); ErlangProcess.erlangProcessCanStart = true; NodeNameManager.start(); } catch (Exception e) { e.printStackTrace(); } } public static void createTablesInCacheDatabase() { try { SQLiteDatabase cacheDatabase = SQLiteDatabase.openOrCreateDatabase( Constants.cacheDatabasePath, null); cacheDatabase.execSQL("CREATE TABLE\n" + "IF NOT EXISTS SqlCache (\n" + " uuid TEXT PRIMARY KEY,\n" + " func TEXT DEFAULT NULL,\n" + " sql TEXT DEFAULT NULL,\n" + " create_time TEXT,\n" + " create_by TEXT\n" + ")"); cacheDatabase.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_sql_cache ON SqlCache (uuid)"); cacheDatabase.execSQL("CREATE TABLE\n" + "IF NOT EXISTS sql_cache_device (\n" + " sql_cache_id TEXT ,\n" + " receive_device_id TEXT, \n"+ " CONSTRAINT idx_sql_cache_device UNIQUE (sql_cache_id, receive_device_id)"+ ")"); cacheDatabase.close(); } catch (Exception e) { e.printStackTrace(); } } public static void createTablesInBaseDatabase() { DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS base_setting (\"open_door_duration\" TEXT, \"auto_register_rule\" TEXT, \"auto_checked_time_rule_id\" TEXT, \"device_setting\" TEXT, \"relation_person\" TEXT, \"relation_device\" TEXT, \"device_name_ip\" TEXT,\"server_name_ip\" TEXT,\"no_face_delay\" TEXT,\"picture_rotation_angle\" TEXT,\"id\" TEXT, \"auto_mode\" TEXT, \"admin_mode\" TEXT, \"pass_mode\" TEXT, \"visitor_mode\" TEXT, \"admin_normal_verify\" TEXT, \"admin_normal_verify_phone\" TEXT, \"admin_normal_verify_idcard\" TEXT, \"admin_normal_verify_name\" TEXT, \"admin_idcard_verify\" TEXT, \"admin_idcard_verify_phone\" TEXT, \"back_to_home\" TEXT, \"image_play_interval\" TEXT, \"detect_multiple_face\" TEXT, \"face_ratio\" TEXT, \"face_angle\" TEXT, \"image_play_time\" TEXT, \"login_expire_long\" TEXT, \"auto_mode_verify_phone\" TEXT, \"auto_normal_verify\" TEXT, \"auto_normal_verify_phone\" TEXT, \"auto_normal_verify_idcard\" TEXT, \"auto_normal_verify_name\" TEXT, \"auto_idcard_verify\" TEXT, \"auto_idcard_verify_phone\" TEXT, \"auto_register_identity_id\" TEXT, \"auto_register_identity_name\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_base_setting ON base_setting (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS business (\"id\" TEXT, \"business_name\" TEXT, \"create_time\" TEXT, \"only_allow\" TEXT, \"only_allow_start\" TEXT, \"only_allow_end\" TEXT, \"choose_from_time_rule\" TEXT, \"checked_time_rule_id\" TEXT, \"access_table_name\" TEXT,\"access_identity\" TEXT, \"access_name\" TEXT, \"access_hint\" TEXT, \"not_reached_time_hint\" TEXT, \"not_reached_time_remind\" TEXT, \"time_unit\" TEXT, \"confirm_pass_identity\" TEXT, \"confirm_pass_name\" TEXT, \"confirm_pass_hint\" TEXT, \"time_ids\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_business ON business (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS business_person (\"id\" TEXT, \"person_id\" TEXT, \"business_id\" TEXT, \"pass_model\" TEXT, \"contact_person\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_business_person ON business_person (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS confirm (\"id\" TEXT, \"from_device_id\" TEXT, \"from_person_id\" TEXT, \"from_time\" TEXT, \"valid_long\" TEXT, \"confirm_device_id\" TEXT, \"confirm_user_id\" TEXT, \"confirm_time\" TEXT, \"del_flag\" TEXT, \"company_id\" TEXT, \"table\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_confirm ON confirm (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS device (\"id\" TEXT, \"name\" TEXT, \"ip\" TEXT, \"mask\" TEXT, \"gateway\" TEXT, \"no_face_delay\" TEXT, \"address\" TEXT, \"server_ip\" TEXT, \"apply_device_ids\" TEXT, \"device_id\" TEXT, \"open_door_time\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_device ON device (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS hint_door_access (\"id\" TEXT, \"name\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"access_identity\" TEXT, \"access_name\" TEXT, \"access_hint\" TEXT, \"not_reached_time_hint\" TEXT, \"not_reached_time_remind\" TEXT, \"confirm_pass_identity\" TEXT, \"confirm_pass_name\" TEXT, \"confirm_pass_hint\" TEXT, \"refuse_pass_identity\" TEXT, \"refuse_pass_name\" TEXT, \"refuse_pass_hint\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_hint_door_access ON hint_door_access (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS hint_recognize_message (\"id\" TEXT, \"name\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"head_up\" TEXT, \"head_up_message\" TEXT, \"head_down\" TEXT, \"head_down_message\" TEXT, \"face_max\" TEXT, \"face_max_message\" TEXT, \"face_min\" TEXT, \"face_min_message\" TEXT, \"rotation_left\" TEXT, \"rotation_left_message\" TEXT, \"rotation_right\" TEXT, \"rotation_right_message\" TEXT, \"all_fit\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_hint_recognize_message ON hint_recognize_message (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS hint_sign_up (\"id\" TEXT, \"name\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"no_register\" TEXT, \"id_card_message\" TEXT, \"id_card_success\" TEXT, \"id_card_fail\" TEXT, \"edit_message\" TEXT, \"register_success\" TEXT, \"admin_logout\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_hint_sign_up ON hint_sign_up (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS identity (\"id\" TEXT, \"name\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_identity ON identity (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS org (\"id\" TEXT, \"pid\" TEXT, \"name\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_org ON org (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS person (\"camera_image_feature_path\" text, \"checked_time_rule_id\" TEXT, \"sign_up_rule\" TEXT,\"id\" TEXT, \"name\" TEXT, \"camera_image_path\" TEXT, \"camera_image_feature\" TEXT, \"camera_image_fastdfs_path\" TEXT, \"id_card_number\" TEXT, \"id_card_image_path\" TEXT, \"id_card_image_feature\" TEXT, \"type\" TEXT, \"phone\" TEXT, \"sign_up_time\" TEXT, \"sign_up_method\" TEXT, \"sign_up_status\" TEXT, \"verify_status\" TEXT, \"auto_init\" TEXT, \"update_time\" TEXT, \"del_flag\" TEXT, \"all_device\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"device_id\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_person ON person (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS person_identity (\"id\" TEXT, \"person_id\" TEXT, \"identity_id\" TEXT, \"del_flag\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_person_identity ON person_identity (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS temporary_person (\"id\" TEXT, \"save_time\" TEXT, \"ip\" TEXT, \"camera_image_path\" TEXT, \"camera_image_feature\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_temporary_person ON temporary_person (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS time (\"id\" TEXT, \"time_rule_name\" TEXT, \"week_json\" TEXT, \"date_json\" TEXT, \"is_use\" TEXT, \"del_flag\" TEXT, \"table\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_time ON time (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS user (\"id\" TEXT, \"person_id\" TEXT, \"username\" TEXT, \"password\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_user ON user (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS visit (\"id\" TEXT, \"person_id\" TEXT, \"person_name\" TEXT, \"device_name\" TEXT, \"visit_time\" TEXT, \"verify_result\" TEXT, \"exit_time\" TEXT, \"target_person_id\" TEXT, \"target_person_name\" TEXT, \"target_org_id\" TEXT, \"target_org_name\" TEXT, \"del_flag\" TEXT, \"person_id_number\" TEXT, \"person_phone\" TEXT, \"person_type\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"table\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_visit ON visit (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS business_apply_device (\"id\" TEXT, \"business_id\" TEXT, \"device_id\" TEXT, \"table\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_business_apply_device ON business_apply_device (id)"); DatabaseManager.execSQL("CREATE TABLE IF NOT EXISTS OfficeDevice (\"id\" TEXT,\"deviceIp\" TEXT, \"deviceName\" TEXT, \"device_id\" TEXT, \"company_id\" TEXT, \"ip\" TEXT, \"valid\" TEXT, \"del_flag\" TEXT, PRIMARY KEY(id))"); DatabaseManager.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_OfficeDevice ON OfficeDevice (id)"); initTableColumnNames(); } public static void createTablesInSyncDatabase() { try { SQLiteDatabase syncDatabase = SQLiteDatabase.openOrCreateDatabase( Constants.syncDatabasePath, null); syncDatabase.execSQL("CREATE TABLE IF NOT EXISTS 'device_info'(\"father_node\" text, \"table\" text ,uuid text PRIMARY KEY, node_id text, device_id text, cluster_id text, create_time text, update_time text, create_by text, del_flag text )"); syncDatabase.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_device_info ON device_info (uuid)"); syncDatabase.execSQL("CREATE TABLE IF NOT EXISTS 'cluster_info'(\"table\" text, cluster_id text PRIMARY KEY,cluster_name text,create_time text ,update_time text,create_by text,del_flag text )"); syncDatabase.execSQL("CREATE UNIQUE INDEX IF NOT EXISTS idx_cluster_info ON cluster_info (cluster_id)"); syncDatabase.close(); } catch (Exception e) { e.printStackTrace(); } } private static void initTableColumnNames() { SQLiteDatabase mDataBase = DatabaseManager.getDatabase(); Cursor c = mDataBase.rawQuery("SELECT name FROM sqlite_master WHERE type='table'", null); List tableNameList = new ArrayList<>(); if (c.moveToFirst()) { while (!c.isAfterLast()) { tableNameList.add(c.getString(0)); c.moveToNext(); } } c.close(); for (String tableName : tableNameList) { Cursor dbCursor = mDataBase.query(tableName, null, null, null, null, null, null); String[] columnNames = dbCursor.getColumnNames(); SlBaseManager.tableColumnNames.put(tableName, Arrays.asList(columnNames)); dbCursor.close(); } } /*device_id=1 company_id=1 couchbase_server_ip=192.168.1.133 port=5555*/ // public void initLocalSetting() { // // 把本地设置写到SD卡中 // File file = new File("/sdcard/config.ini"); // if (!file.exists()) { // CopyToSdcard.getInstance(this).copyAssetsToSD("config.ini", "/config.ini"); // } // // try { // //这个判断语句使我们常用的：判断手机是否插入了SD卡和是否有访问权限，如果都有就返回true // if (Environment.getExternalStorageState().equals(Environment.MEDIA_MOUNTED)) { // FileInputStream fis = new FileInputStream("/sdcard/config.ini"); // List lines = IOUtils.readLines(fis); // for (String line : lines) { // String[] split = line.split("="); // localSetting.put(split[0], split[1]); // } // DeviceManager.device_id = localSetting.get("device_id"); // DeviceManager.company_id = localSetting.get("company_id"); // DeviceManager.couchbase_server_ip = localSetting.get("couchbase_server_ip"); // DeviceManager.port = localSetting.get("port"); // // } // // } catch (Exception e) { // e.printStackTrace(); // } // // } }