Alex

From UG

(Difference between revisions)

Jump to: navigation, search

Revision as of 17:35, 28 April 2012

Current Work

0002237: [SmartPhone App] ............. <proj parent>
0002515: [Estim P&L / Accruals] .......<parent>

Code Reviews

repos

Acc

tblCurrency

tbl Currency


-- Table "tblCurrency" DDL

CREATE TABLE `tblCurrency` (
  `Id` int(10) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) NOT NULL,
  `Abbreviation` varchar(3) NOT NULL,
  `IsMain` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 9216 kB';

DELIMITER ;;
CREATE TRIGGER `tblCurrency_after_ins_tr` AFTER INSERT ON `tblCurrency` FOR EACH ROW BEGIN
    INSERT INTO `tblCurrencyExchangeRate` (FromCurrencyId, ToCurrencyId, OfficeId)
    SELECT NEW.Id, `tblCurrency`.Id, `tblOffice`.Id
        FROM tblCurrency, tblOffice
        WHERE NOT `tblCurrency`.Id=NEW.Id;
    INSERT INTO `tblCurrencyExchangeRate` (FromCurrencyId, ToCurrencyId, OfficeId)
    SELECT `tblCurrency`.Id, NEW.Id, `tblOffice`.Id
        FROM tblCurrency, tblOffice
        WHERE NOT `tblCurrency`.Id=NEW.Id;
END;;
DELIMITER ;

+--------------+-------------+------+-----+---------+----------------+
| Field        | Type        | Null | Key | Default | Extra          |
+--------------+-------------+------+-----+---------+----------------+
| Id           | int(10)     | NO   | PRI | NULL    | auto_increment |
| Name         | varchar(50) | NO   |     | NULL    |                |
| Abbreviation | varchar(3)  | NO   |     | NULL    |                |
| IsMain       | tinyint(1)  | NO   |     | 0       |                |
+--------------+-------------+------+-----+---------+----------------+
4 rows in set

SVN updates

Weekly Reports

Related: 0002610: {Alex} ........... <mh report>

2012 w16

Mon 16 Apr

Tue 17 Apr

W 18 Apr

GM Split - 1h
- SIT, etc

Estim GM - 5h
- completely rewriting SOW: more clear/ simple approach, etc

Mobile App - 0h

Meetings/Misc - 2h
- ihelp - helping AG to cover for Denise, etc
- weekly Perry's meeting
- meeting w/ Marc
- discussing code management w/ Perry

TOTAL: 8 hours

2012 w17

GM Split
Est GM
Mobile
Misc

M 23 Apr

GM Split
Est GM
Mobile
Misc

Tu 24 Apr

GM Split
Est GM
Mobile
Misc
- meeting with Denise
- https issue

W 25 Apr

GM Split
Est GM
Mobile
Misc

Th 26 Apr

GM Split
Est GM
Mobile
Misc

F 27 Apr

GM Split
Est GM
Mobile
Misc

Misc

SVN addr etc

Reply Reply to all Forward Close Help

You replied on 12/27/2011 2:25 PM.

	Follow up
From: 	 Vlad Spichek [v.spichek@elcosol.com]	 Sent: 	 Tue 12/27/2011 2:16 PM
To: 	 Alex Dobrovolsky
Cc: 	 
Subject: 	 Fwd: Re: SVN relocation
Attachments:

View As Web Page

Original Message --------

Subject: Re: SVN relocation Date: Sat, 05 Mar 2011 22:59:40 -0800 From: Vlad Spichek <vspichek@gmail.com> To: Konstantin Ushakov <ushakovk@mail.ru>, a.pivniak@gmail.com, Gurzov@gmail.com, Roman.Lakhno@gmail.com, andriy.koltsov@gmail.com, mihail.tymoshenko@gmail.com, Alex Dobrovolsky <alex@jaguarfreight.com>

Hi,

Correction: To be able to use TortoiseSVN from outside the office, slightly different setting is needed: In the "TortoiseSVN Setting -> Networks -> SSH" SSH client should be set to <"C:\Program Files\TortoiseSVN\bin\TortoisePlink.exe" -P 8822 -l username -pw password>

Note the port number needs to be specified explicitly.

Regards, Vlad

On 03/01/2011 12:47 AM, Vlad Spichek wrote: Hi,

Please be informed that SVN repository will be moved to the Kiev office by the morning of Wednesday, March 2nd.

Please consider committing your work to the existing repository at the end of Tuesday, March 1st. This will greatly reduce possibility of complications.

There will be changes to the way repository is accessed. Unfortunately the transition isn't seamless.

1. Server address will change. Unfortunately the Kiev office doesn't run any naming scheme which could allow for uniform access from inside and outside of the office. Server's internal address is 192.168.0.2, server's external address is 82.207.113.107 (aka kuchma.jaguarfreight.com). If you have suggestions of a name for the server other than <kuchma>, please let me know, it's not too late to change it. 2. The protocol used to access the repository will change to "svn+ssh://". The full URL then will look like

<svn+ssh://kostya@192.168.0.2:8822/srv/repos/cybertrax/trunk/...>

svn+ssh://kostya@82.207.113.107:8822/srv/repos/cybertrax/trunk/

<kostya> will need to be changed to your name. For access from outside the office <192.168.0.2> will need to be changed to <82.207.113.107> or <kuchma.jaguarfreight.com>. If needed </trunk/> will be replaced to specification of tag or branch you are interested in. 3. Authentication will be done by SSH, against standard Linux password database and/or SSH public key. I have created standard Linux accounts for everyone on the server, and assigned initial passwords, at the earliest convenience, please, changes them to your individual secret combination.

To change your Linux password. For this you need to have Putty SSH client, it can be downloaded from <http://www.chiark.greenend.org.uk/~sgtatham/putty/>, no installation is required. Please open SSH connection to the server (using port 8822). After you get to the Linux command line enter <passwd>, enter your old password, then, twice your desired new password.
As is TortoiseSVN will as for a password each time you do anything with the repository. To remove this inconvenience there are two ways:

1) To hardcode the password in TortoiseSVN configuration. This is not the preferable way, but very easy to start. From the pop-up menu of the File Manager, select TortoiseSVN Setting -> Networks -> SSH and set ssh client to TortoisePlink.exe, which comes together with TortoiseSVN (It is usually in <C:\Program Files\TortoiseSVN\bin\TortoisePlink.exe>). You can add two additional arguments after TortoisePlink.exe to avoid entering your username and password everytime: <C:\Program Files\TortoiseSVN\bin\TortoisePlink.exe -l username -pw password>

2) To use SSH open key authentication, follow one of these manuals: <http://www.noah.org/wiki/Tortoise_SVN_with_PuTTY> <http://www.ualberta.ca/CNS/RESEARCH/LinuxClusters/pka-putty.html> <http://www.mono-project.com/Putty_and_TortoiseSvn>

On Wednesday I'll be checking my email and Skype more often to help resolve any troubles you might have. Don't hesitate to contact me if you have any questions/suggestions.

PS together with Linux passwords, please change also Samba passwords using "smbpasswd".