Optimizing SQLite with NSCalendar

In the previous article, we solved the problem of incorrect use of the SQLite week based calendar by writing our own extension for this DBMS.

Our calculation came together, but the speed of its work left much to be desired. Processing a table containing only 2500 records took about 6 seconds. While queries using strftime () were executed in tenths of a second.

')
Before starting, I want to note that here and later, to simplify the presentation, error handling and the allocation of some classes are omitted. Before discussing the code in the comments, do not be lazy to look at the page of the project dodikk / ESLocale.

In the first approximation, our function looked like this:

void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .
void ObjcFormatAnsiDateUsingLocale( sqlite3_context* ctx_, int argc_, sqlite3_value** argv_ ) { assert( ctx_ ); // @autoreleasepool // ObjC . { // argc_, argv_ const unsigned char * rawFormat_ = sqlite3_value_text( argv_[0] ); const unsigned char * rawDate_ = sqlite3_value_text( argv_[1] ); const unsigned char * rawLocaleIdentifier_ = sqlite3_value_text( argv_[2] ); // , crash NSString if ( NULL == rawFormat_ || NULL == rawDate_ || NULL == rawLocaleIdentifier_ ) { sqlite3_result_error( ctx_, "ObjcFormatAnsiDate - NULL argument passed" , 3 ); return ; } // NSString NSString* strDate_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawDate_ length: strlen( ( const char *)rawDate_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* format_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawFormat_ length: strlen( ( const char *)rawFormat_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; NSString* localeIdentifier_ = [ [ NSString alloc ] initWithBytesNoCopy: ( void *)rawLocaleIdentifier_ length: strlen( ( const char *)rawLocaleIdentifier_ ) encoding: NSUTF8StringEncoding freeWhenDone: NO ]; // . en_US_POSIX yyyy-MM-dd NSDateFormatter* ansiFormatter_ = [ ESLocaleFactory ansiDateFormatter ]; // . , NSLocale* locale_ = [ [ NSLocale alloc ] initWithLocaleIdentifier: localeIdentifier_ ]; NSDateFormatter* targetFormatter_ = [ ESLocaleFactory gregorianDateFormatterWithLocale: locale_ ]; targetFormatter_.dateFormat = format_; // , NSDate* date_ = [ ansiFormatter_ dateFromString: strDate_ ]; NSString* result_ = [ targetFormatter_ stringFromDate: date_ ]; // if ( nil == result_ || [ result_ isEqualToString: @"" ] ) { sqlite3_result_null( ctx_ ); } else { sqlite3_result_text ( ctx_, ( const char *)[ result_ cStringUsingEncoding : NSUTF8StringEncoding ], ( int )[ result_ lengthOfBytesUsingEncoding: NSUTF8StringEncoding ], SQLITE_TRANSIENT // SQLite - ); } } } * This source code was highlighted with Source Code Highlighter .

Having driven through the profiler, we saw that most of the time it took not the formatting of the text, but the creation of instances of NSDateFormatter (line 39..45).

The model of using this function assumes a change of locale and format only between requests. Within the limits of one request these parameters most likely will not change. This leads us to a simple optimization idea.

We will put the resource-intensive NSDateFormatter in some Singletone object. Then the formatter will look like this:

SqlitePersistentDateFormatter * fmt_ = [SqlitePersistentDateFormatter instance]; // create singletone
NSString * result_ = nil;
@synchronized (fmt_) // formatting must be atomic and thread safe
{
// update the format and locale if necessary
[fmt_ setFormat: format_
locale: localeIdentifier_];
// format the result
result_ = [fmt_ getFormattedDate: strDate_];
}
* This source code was highlighted with Source Code Highlighter .

And now it's time to look under the hood. The implementation of thread-safe singletone is omitted as a classic task. In the rest we get the following:

@implementation SqlitePersistentDateFormatter
{
@ private // our heavy objects
NSDateFormatter * ansiFormatter;
NSDateFormatter * targetFormatter;
}
// ansiFormatter does not change, because it is standard
// therefore create it inside init.
- (id) init
{
self = [super init];
if (nil == self)
{
return nil;
}
self-> ansiFormatter = [ESLocaleFactory ansiDateFormatter];
return self;
}
// the most interesting thing here
- (BOOL) setFormat :( NSString *) dateFormat_
locale :( NSString *) locale_
{
NSParameterAssert (nil! = Locale_);
BOOL isNoFormatter_ = (nil == self-> targetFormatter);
BOOL isOtherLocale_ =! [Self-> targetFormatter.locale.localeIdentifier isEqualToString: locale_];
// create a new NSDateFormatter only if the locale has changed
if (isNoFormatter_ || isOtherLocale_)
{
NSCalendar * cal_ = [ESLocaleFactory gregorianCalendarWithLocaleId: locale_];
self-> targetFormatter = [NSDateFormatter new ];
[ESLocaleFactory setCalendar: cal_
forDateFormatter: self-> targetFormatter];
}
// set the date
self-> targetFormatter.dateFormat = dateFormat_;
return YES;
}
// the main work has already been done.
// It remains only to apply harvested NSDateFormatter
- (NSString *) getFormattedDate :( NSString *) strDate_;
{
NSDate * date_ = [self-> ansiFormatter dateFromString: strDate_];
NSString * result_ = [self-> targetFormatter stringFromDate: date_];
return result_;
}
* This source code was highlighted with Source Code Highlighter .

So, we have a thread-safe, almost pure in terms of the FP function (pure function), which works in a time comparable to strftime.
You can find the full version of the code on github.

Source: https://habr.com/ru/post/144192/

All Articles

Optimizing SQLite with NSCalendar

More articles: