#!/bin/bash

# MySQL search
echo "Starting MySQL search."
MYSQL_ROOT_PASSWORD=...
DATABASE_LIST=$(docker exec lasmysql /usr/bin/mysql -u root --password=$MYSQL_ROOT_PASSWORD -sN -e 'show databases;' | grep -v hamilton|grep -v information_schema| grep -v mysql| grep -v performance_schema| grep -v ^Database$| grep -v sys)
echo $DATABASE_LIST
for db in $DATABASE_LIST;do
echo $db
docker exec lasmysql /usr/bin/mysql -u root --password=$MYSQL_ROOT_PASSWORD -sN -e "use $db;UPDATE auth_user SET username = 'gunhild', email= 'g.m.malandsmo@ous-research.no' WHERE username = 'xxgunhild';" 2>&1 |grep -v "Using a password"

done

CREATE (n:User {identifier:'gunhild'}) return n
MATCH (n:User {identifier:'gunhild'}) SET n : Social RETURN n

MATCH (u:User),(g:WG)
WHERE u.identifier = 'gunhild' AND g.identifier = 'Oslo_WG'
CREATE (u)-[r:belongs]->(g)
RETURN type(r)

Obnovil jsem gunhild v MySQL ``` #!/bin/bash # MySQL search echo "Starting MySQL search." MYSQL_ROOT_PASSWORD=... DATABASE_LIST=$(docker exec lasmysql /usr/bin/mysql -u root --password=$MYSQL_ROOT_PASSWORD -sN -e 'show databases;' | grep -v hamilton|grep -v information_schema| grep -v mysql| grep -v performance_schema| grep -v ^Database$| grep -v sys) echo $DATABASE_LIST for db in $DATABASE_LIST;do echo $db docker exec lasmysql /usr/bin/mysql -u root --password=$MYSQL_ROOT_PASSWORD -sN -e "use $db;UPDATE auth_user SET username = 'gunhild', email= 'g.m.malandsmo@ous-research.no' WHERE username = 'xxgunhild';" 2>&1 |grep -v "Using a password" done ``` Přidal funkční pwd hash a nastavil is_active V Neo4J Vytvořil object gunhild, přidal label Social a navázal na Oslo_WG ``` CREATE (n:User {identifier:'gunhild'}) return n MATCH (n:User {identifier:'gunhild'}) SET n : Social RETURN n MATCH (u:User),(g:WG) WHERE u.identifier = 'gunhild' AND g.identifier = 'Oslo_WG' CREATE (u)-[r:belongs]->(g) RETURN type(r) ```