平台介绍 >> /jscode/develop/{PROJECT/}database.json 数据库配置文件
/jscode/develop/{PROJECT/}database.json 数据库配置文件
{
"-desc": "数据库类型,支持sqlite/mysql/mssql",
"default_db": "sqlite",
"db_opt_list": {"local": "mysql_dev","service": "mysql_service"},
"db_opt_list-desc": "config.json的db_opt属性值指定值对应db_opt_list属性名对应的值为默认数据库,级别高于default_db",
"db_list": {
"com": {
"db_type": "mysql",
"mysql_loginname": "root",
"mysql_loginpwd": "root",
"mysql_server": "localhsot",
"mysql_port": 3306,
"mysql_dbname": "jssaas",
"sqlite_driverName": "sqlite3",
"sqlite_dataSourceName": "$JSCODEPATH$/database/database.db",
"mssql_server": "localhost",
"mssql_database": "jssaas",
"mssql_userid": "sa",
"mssql_password": "123456",
"mssql_port": 1433,
"mssql_encrypt": "disable"
},
"mysql_dev": {
"db_type": "mysql",
"mysql_loginname": "root",
"mysql_loginpwd": "root",
"mysql_server": "localhost",
"mysql_port": 3306,
"mysql_dbname": "erp"
},
"mysql_service": {
"db_type": "mysql",
"mysql_loginname": "root",
"mysql_loginpwd": "root",
"mysql_server": "localhost",
"mysql_port": 3306,
"mysql_dbname": "erp"
},
"sqlite": {
"db_type": "sqlite",
"sqlite_driverName": "sqlite3",
"sqlite_dataSourceName": "$JSCODEPATH$/database/database.db"
},
"mssql": {
"db_type": "mssql",
"mssql_server": "localhost",
"mssql_database": "jssaas",
"mssql_userid": "sa",
"mssql_password": "123456",
"mssql_port": 1433,
"mssql_encrypt": "disable"
}
},
"tablenameprefix": "",
"tablenameprefix-desc": "表名前缀",
"tablenameprefixsplit": "",
"tablenameprefixsplit-desc": "表名前缀分隔符,取分隔符后面的的表名,有值时优先级比tablenameprefix高"
}