DatascienceSql
所属分类：大数据
开发工具：Python
文件大小：0KB
下载次数：0
上传日期：2022-04-06 23:29:45
上 传 者：
sh-1993
说明： 用于为我们的数据科学学校项目设置数据库的python脚本。
(A python script for setting up the database for our data science school project.)
文件列表:
__init__.py (2745, 2022-04-06)
sql/ (0, 2022-04-06)
sql/raw_db_create.sql (8197, 2022-04-06)
sql/raw_db_fill.sql (5359, 2022-04-06)
sql/real_db_create.sql (13663, 2022-04-06)
sql/real_db_create_actor.sql (777, 2022-04-06)
sql/real_db_create_actress.sql (787, 2022-04-06)
sql/real_db_create_biography.sql (256, 2022-04-06)
sql/real_db_create_business.sql (276, 2022-04-06)
sql/real_db_create_country.sql (896, 2022-04-06)
sql/real_db_create_genre.sql (829, 2022-04-06)
sql/real_db_create_movie.sql (514, 2022-04-06)
sql/real_db_create_movie_locations.sql (473, 2022-04-06)
sql/real_db_create_movie_rating.sql (457, 2022-04-06)
sql/real_db_create_movie_runtime.sql (510, 2022-04-06)
sql/real_db_create_serie.sql (536, 2022-04-06)
sql/real_db_create_serie_locations.sql (497, 2022-04-06)
sql/real_db_create_serie_rating.sql (481, 2022-04-06)
sql/real_db_create_serie_runtime.sql (533, 2022-04-06)
sql/real_db_create_writer.sql (770, 2022-04-06)
# Datascience SQL
This is a python project with sql scripts for setting up the database used by the web application. For parsing the data to files that can be used by this python project we redirect you to [\[this\]](https://github.com/Medooosa/Csharp-Parser) C# project. When the setup of the database is complete using we will redirect you to [\[this\]](https://github.com/sidneydijkstra/DatascienceWeb/) node.js project.
### Dependencies
This list contains all the dependencies used by the project.
```
+-- dotenv
+-- mysqldb
+-- sqlparse
```
All these dependencies can be install with pip install commands:
```
pip install python-dotenv
pip install mysqlclient
pip install sqlparse
```
### Env
A connection with the database is established using the variables in the .env file. Create this file and add these parameters to connect with the database:
```
DATABASE_IP=
DATABASE_PORT=
DATABASE_USERNAME=
DATABASE_PASSWORD=
```
### Run
For running the project we can use a easy python command and need a folder containing all the data files. The location of this folder can be changed in the file 'raw_db_fill.sql'.
Command:
```
python __init__.py
```
近期下载者：
相关文件：
收藏者：