Mathieu Benoit
de9779cfc2
- erplibre separate venv erplibre and odoo - rename python-version to python-odoo-version - add conf/python-erplibre-version - rename .venv to .venv.erplibre - move .venv/repo to .venv.erplibre/bin/repo - install pyenv into .venv.erplibre - install poetry into .venv.odooVERSION - first installation show odoo version to install - can install erplibre without odoo - update README.md information about installation with TODO - change image from github to locally - remove link creation .venv - update version: remove code to force create symbolic link .venv - use dynamic merge manifest, will be able to merge different odoo version - can add dev tools - default manifest is empty to remove conflict
29 lines
895 B
Bash
Executable file
29 lines
895 B
Bash
Executable file
#!/usr/bin/env bash
|
|
|
|
SQL_PATH=./script/database/mariadb_sql_example_1.sql
|
|
|
|
# You need to set no password to mysql root user
|
|
# SET PASSWORD FOR root@localhost='';
|
|
# FLUSH PRIVILEGES;
|
|
|
|
# Second solution
|
|
# ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '';
|
|
# FLUSH PRIVILEGES;
|
|
|
|
echo "Create database and user"
|
|
mysql -u root << EOF
|
|
DROP DATABASE IF EXISTS mariadb_sql_example_1;
|
|
CREATE USER IF NOT EXISTS 'organization'@'localhost' IDENTIFIED BY 'organization';
|
|
GRANT ALL PRIVILEGES ON *.* TO 'organization'@'localhost' IDENTIFIED BY 'organization';
|
|
FLUSH PRIVILEGES;
|
|
CREATE DATABASE mariadb_sql_example_1;
|
|
EOF
|
|
|
|
echo "Fix SQL file"
|
|
sed -i "s/'0000-00-00'/NULL/g" ${SQL_PATH}
|
|
|
|
echo "Import SQL file"
|
|
mysql -u organization -porganization mariadb_sql_example_1 < ${SQL_PATH}
|
|
|
|
echo "Fix SQL in database"
|
|
./.venv.erplibre/bin/python ./script/database/fix_mariadb_sql_example_1.py
|