public static void WriteBar(JournalLoadingPercentChangedEventArgs args)
{
StringBuilder output = new StringBuilder();
int fillLen = 0;
char filler = '#', spacer = ' ';
output.Append(" ");
for (int i = 0; i < 10; i++) {
char c = i < args.Label.Length ? args.Label[i] : ' ';
output.Append(c);
}
output.Append(" [");
fillLen = Convert.ToInt32(((decimal)args.Percent / 100) * 60);
for (int i = 0; i < 60; i++) {
output.Append(i <= fillLen ? filler : spacer);
}
output.Append("] ");
output.Append(args.Percent + "%");
lock (__consoleWriteLock) {
Console.Write("\r");
Console.ForegroundColor = ConsoleColor.Cyan;
Console.Write(output.ToString());
Console.ResetColor();
}
}
static void journal_JournalLoadingPercentChanged(object sender, JournalLoadingPercentChangedEventArgs e)
{
ConsoleEx.WriteBar(e);
}
protected void Process()
{
sec = new SEconomy(null);
SEconomyPlugin.Instance = sec;
XmlTransactionJournal journal = null;
int oldPercent = 0, skipped = 0;
Dictionary<long, long> oldNewTransactions = new Dictionary<long, long>();
JournalLoadingPercentChangedEventArgs args = new JournalLoadingPercentChangedEventArgs() {
Label = "Accounts"
};
sec.Configuration = Config.FromFile(Config.BaseDirectory + Path.DirectorySeparatorChar + "seconomy.config.json");
journal = new XmlTransactionJournal(sec, Config.BaseDirectory + Path.DirectorySeparatorChar + "SEconomy.journal.xml.gz");
JournalLoadingPercentChanged += journal_JournalLoadingPercentChanged;
journal.JournalLoadingPercentChanged += journal_JournalLoadingPercentChanged;
journal.LoadJournal();
Console.WriteLine();
if (DatabaseExists() == false) {
Console.WriteLine("Your SEconomy database does not exist. Create it?");
Console.Write("[y/n] ");
if (Console.ReadKey().KeyChar != 'y') {
return;
}
CreateDatabase();
}
Console.WriteLine("Your SEconomy database will be flushed. All accounts, and transactions will be deleted before the import.");
Console.Write("Continue? [y/n] ");
if (Console.ReadKey().KeyChar != 'y') {
return;
}
Console.WriteLine();
Connection.Query(string.Format("DELETE FROM `{0}`.`bank_account`;", sec.Configuration.SQLConnectionProperties.DbName));
Connection.Query(string.Format("ALTER TABLE `{0}`.`bank_account` AUTO_INCREMENT 0;", sec.Configuration.SQLConnectionProperties.DbName));
Connection.Query(string.Format("DELETE FROM `{0}`.`bank_account_transaction`;", sec.Configuration.SQLConnectionProperties.DbName));
Connection.Query(string.Format("ALTER TABLE `{0}`.`bank_account_transaction` AUTO_INCREMENT 0;", sec.Configuration.SQLConnectionProperties.DbName));
Console.WriteLine("This will probably take a while...\r\n");
Console.WriteLine();
if (JournalLoadingPercentChanged != null) {
JournalLoadingPercentChanged(null, args);
}
for (int i = 0; i < journal.BankAccounts.Count; i++) {
IBankAccount account = journal.BankAccounts.ElementAtOrDefault(i);
double percentComplete = (double)i / (double)journal.BankAccounts.Count * 100;
long id = -1;
string query = null;
if (account == null) {
continue;
}
query = @"INSERT INTO `bank_account`
(user_account_name, world_id, flags, flags2, description, old_bank_account_k)
VALUES (@0, @1, @2, @3, @4, @5);";
try {
Connection.QueryIdentity(query, out id, account.UserAccountName, account.WorldID,
(int)account.Flags, 0, account.Description, account.BankAccountK);
} catch (Exception ex) {
TShock.Log.ConsoleError(" seconomy mysql: sql error adding bank account: " + ex.ToString());
continue;
}
for (int t = 0; t < account.Transactions.Count(); t++) {
long tranId = -1;
ITransaction transaction = account.Transactions.ElementAtOrDefault(t);
string txQuery = @"INSERT INTO `bank_account_transaction`
(bank_account_fk, amount, message, flags, flags2, transaction_date_utc, old_bank_account_transaction_k)
VALUES (@0, @1, @2, @3, @4, @5, @6);";
try {
Connection.QueryIdentity(txQuery, out tranId, id, (long)transaction.Amount, transaction.Message,
(int)BankAccountTransactionFlags.FundsAvailable, (int)transaction.Flags2, transaction.TransactionDateUtc,
transaction.BankAccountTransactionK);
if (oldNewTransactions.ContainsKey(transaction.BankAccountTransactionK) == false) {
oldNewTransactions[transaction.BankAccountTransactionK] = tranId;
}
} catch (Exception ex) {
TShock.Log.ConsoleError(" seconomy mysql: Database error in BeginSourceTransaction: " + ex.Message);
continue;
}
}
if (oldPercent != (int)percentComplete) {
args.Percent = (int)percentComplete;
if (JournalLoadingPercentChanged != null) {
JournalLoadingPercentChanged(null, args);
}
oldPercent = (int)percentComplete;
}
}
args.Label = "Reseed";
args.Percent = 0;
if (JournalLoadingPercentChanged != null) {
JournalLoadingPercentChanged(null, args);
}
string updateQuery = @"update bank_account_transaction as OLDT
inner join (
select bank_account_transaction_id, old_bank_account_transaction_k
from bank_account_transaction
) as NEWT on OLDT.old_bank_account_transaction_k = NEWT.old_bank_account_transaction_k
set OLDT.bank_account_transaction_fk = NEWT.bank_account_transaction_id";
Connection.Query(updateQuery);
Connection.Query("update `bank_account_transaction` set `old_bank_account_transaction_k` = null;");
args.Percent = 100;
if (JournalLoadingPercentChanged != null) {
JournalLoadingPercentChanged(null, args);
}
Console.WriteLine("import complete", skipped);
Console.WriteLine("Press any key to exit");
Console.Read();
}