问题没有解决“dbtype, host, port, user, passwd, dbName, charset,hasHadoop = config_read("config.ini")
dbName=dbName.replace(" ","").strip()
print(dbtype, host, port, user, passwd, dbName, charset)
if dbtype == 'mysql':
DATABASES = {
'default': {
# 'ENGINE': 'django.db.backends.sqlite3',
# 'NAME': os.path.join(BASE_DIR, 'db.sqlite3'),
'ENGINE': 'django.db.backends.mysql',
'OPTIONS': {
'sql_mode': 'traditional',
'init_command': "SET sql_mode='traditional'", # STRICT_TRANS_TABLES
},
'NAME': dbName,
'USER': user,
'PASSWORD': passwd,
'HOST': host,
'PORT': port,
'charset': charset,
'TEST': {
'CHARSET': charset,
'COLLATION': 'utf8_general_ci',
},
'CONN_MAX_AGE':60
},
}
else:
print("请使用mysql5.5数据库")
os._exit(1)
if 'spark' in hasHadoop or 'hive' in hasHadoop:
jar_fielpath=os.path.join(BASE_DIR,"bin","mysql-connector-java-8.0.32.jar")
print(jar_fielpath)
jar_fielpath="D:/work/jiudian/djangoci6g6vu6/bin/mysql-connector-java-8.0.32.jar"
print(jar_fielpath)
if os.path.exists(jar_fielpath)==False:
print('请检查mysql-connector-java-8.0.32.jar文件是否存在')
os._exit(1)
try:
spark = SparkSession.builder.config("spark.jars",jar_fielpath).master("local").appName("django").getOrCreate()
print('dddd', e)
except Exception as e:
print('请检查spark配置',e)
os._exit(1)
jdbc_url=f'jdbc:mysql://{host}:{port}/{dbName}?user={user}&password={passwd}&driver=com.mysql.jdbc.Driver'
# Password validation
# https://docs.djangoproject.com/en/2.0/ref/settings/#auth-password-validators
”