Skip to content

Instantly share code, notes, and snippets.

View alexsosn's full-sized avatar

Alex Sosnovshchenko alexsosn

View GitHub Profile
@alexsosn
alexsosn / .bashProfile
Created February 19, 2015 17:29
.bashProfile for Appium setup
export ANDROID_HOME="/Users/asos/Library/Developer/Xamarin/android-sdk-macosx"
ANDROID_TOOLS=$ANDROID_HOME/tools/:$ANDROID_HOME/platform-tools
export PATH=$ANDROID_TOOLS:$PATH
export JAVA_HOME=$(/usr/libexec/java_home)
- (void)drawRect:(CGRect)rect
{
SQLClient* client = [SQLClient sharedInstance];
client.delegate = self;
[client connect:@"10.146.1.28:1433" username:@"sa" password:@"password" database:@"Intraservice4" completion:^(BOOL success) {
if (success)
{
[client execute:@"SELECT u.Name,count(t.Id) as tot FROM [Intraservice4].[dbo].[Task] t left join TaskExecutor te on t.id = te.TaskId left join [User] u on te.UserId = u.id where 1=1 and StatusId not in ( 28,29,30,53) group by u.Name order by u.Name" completion:^(NSArray* results) {
//NSLog(@"%@",[results[0][0] valueForKey:@"tot"]);
NSLog(@"ДАННЫЕ ИЗ БД ПОЛУЧЕНЫ");