A stupid question

[Auntie Mangos]

you can use this:

http://getmangos.eu/community/topic/14757/mangos-sql-update-generator/

to generate 1 combined sql file that you can read before applying

[Auntie Mangos]

I have also made a SQL updater in Python which will actually check for the last update and then apply any after that.

http://getmangos.eu/community/topic/15590/python-yet-another-script-for-sql-updates/

Well, pythod scripts will require you to have Pythod env installed, while console binary can run on any supported platform since runtime is already there Yeah, pythod is great but we are here to learn something, aren't we :rolleyes:

So Windows batch scripts can run on Linux and bash scripts can run on Windows?

And before saying "install bash" why not "install Python"?

Python is still a better cross-platform solution. It has a standard language that runs on every platform Python supports (pretty much all of them.) Shell scripts have many different languages for many different platforms.

[water]

I am new to mangos. This is my first time to compile it in my pc. When I try to update the databases for sqlyog, I think it is Time-consuming.

from mangos\\sql\\characters.sql

DROP TABLE IF EXISTS `character_db_version`;
CREATE TABLE `character_db_version` (
 `required_10664_01_characters_arena_team_stats` bit(1) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Last applied sql update to DB';

it shows 10664_01_characters_arena_team_stats.sql is needed. If I keep updating the sql, I have to update 10662_01_characters_item_loot.sql and so. It's not just one or two files.

Is there a way to publish as a single file like character_upate.sql which include all the neccessary sql files?

What's the reason keep it so troublesome?

[Ambal]

Yeah, current way of applying SQL updates for mangos is PITA. If I'll find time, I'll write a small executable which will do all this painful work for you ...Because I already tired doing everything manually

[Schmoozerd]

there are tons of scripts doing this work,

you can copy the files of the needed updates to a directory, (con)cat them to one file and apply this file, or so many other things to speed up this process

Edit - as the system independency is a valid point, this one should work in git-bash too: (it just needs an additional created directory "processed" where it moves files that went through without problems

#!/bin/sh

USERNAME="<username>"
PASSWORD="<userpass>"

if [ "$#" -ne "1" ]
then
 echo "call with name of database"
 exit 1
fi

DATABASE="$1"

for i in *.sql
do
 echo "Process $i"
 mysql -u$USERNAME -p$PASSWORD $DATABASE < $i

 if [ "$?" -ne "0" ]
 then
   echo "An error happened"
   exit 1
 fi

 ## Done i, mv to processed
 mv $i processed/
done
echo "all done"

[kyle1]

There is a benefit of keeping SQL updates as separate files - anyone can update MaNGOS database to revision he/she needs.

Automating updates is great but writing executables will make people on other platforms sad. Maybe a python script?

[Ambal]

Well, pythod scripts will require you to have Pythod env installed, while console binary can run on any supported platform since runtime is already there Yeah, pythod is great but we are here to learn something, aren't we :rolleyes:

[VladimirMangos]

It not safe apply sql updates in brainless batch mode... to real DB data.

Main task of sql updates keep DB structure compatible with code, and only optionally if possible keep data.

In some cases just impossible convert existed data by generic rule, without additional data not included in core DB part.

In fact most safer way wait used DB release and not used sql updates directly. Ofc, 99% sql updates safe

but expected that before apply you will open unkknown new sql update and look what it do and is it safe for your DB.

I strongly against including any automation tools in mangos repo for this by provided reasons.

[water]

I got the point.

Safty is more important.

:cool:

thanks for replying,

using script is good, it's easy than a short code( some time ).

I always think doing a task for more than 3 times is too heavy for me~~~. In fact update db just spend me a few minutes,