👤 🏾 👓 NSCalendarを使用したSQLiteの最適化 🏈 💧 ㊙️

前の記事では、このDBMSの拡張機能を記述することで、SQLite週ベースのカレンダーを誤って使用する問題を解決しました。

計算は収束しましたが、作業の速度には多くの要望がありました。 2500レコードのみを含むテーブルの処理には約6秒かかりました。 strftime（）を使用したクエリは10分の1秒で実行されました。

開始する前に、以下では、プレゼンテーションを簡素化するために、エラー処理と一部のクラスの強調表示が省略されていることに注意してください。コメントでコードを議論する前に、dodikk / ESLocaleプロジェクトのページを見るのを怠laにしないでください。

最初の近似では、関数は次のようになりました。

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 .

プロファイラーを実行すると、ほとんどの場合、テキストの書式設定ではなく、NSDateFormatterのインスタンスの作成（39..45行目）が必要であることがわかりました。

この関数を使用するモデルには、リクエスト間でのみロケールとフォーマットを変更することが含まれます。 1つのリクエスト内で、これらのパラメーターはほとんど変更されません。これは、単純な最適化のアイデアにつながります。

リソースを消費するNSDateFormatterをシングルトーンオブジェクトに配置します。次に、フォーマット単位は次のようになります。

SqlitePersistentDateFormatter * fmt_ = [SqlitePersistentDateFormatterインスタンス]; //シングルトーンを作成します
NSString * result_ = nil;
@synchronized（fmt_） //フォーマットはアトミックでスレッドセーフでなければなりません
{
//必要に応じて形式とロケールを更新します
[fmt_ setFormat：format_
ロケール：localeIdentifier_];
//結果をフォーマットします
result_ = [fmt_ getFormattedDate：strDate_];
}
*このソースコードは、ソースコードハイライターで強調表示されました。

そして、今度は内部を調べる時間です。古典的な問題として、スレッドセーフなシングルトーンの実装を省略します。残りの部分では、次のものが得られます。

@implementation SqlitePersistentDateFormatter
{
@ private //重いオブジェクト
NSDateFormatter * ansiFormatter;
NSDateFormatter * targetFormatter;
}
// ansiFormatterは標準であるため変更されません
//したがって、init内で作成します。
-（id）init
{
self = [super init];
if （nil == self）
{
nilを返します。
}
self-> ansiFormatter = [ESLocaleFactory ansiDateFormatter];
自己を返す ;
}
//ここで最も興味深い
-（BOOL）setFormat :( NSString *）dateFormat_
ロケール:( NSString *）locale_
{
NSParameterAssert（nil！= Locale_）;
BOOL isNoFormatter_ =（nil == self-> targetFormatter）;
BOOL isOtherLocale_ =！[Self-> targetFormatter.locale.localeIdentifier isEqualToString：locale_];
//ロケールが変更された場合にのみ新しいNSDateFormatterを作成します
if （isNoFormatter_ || isOtherLocale_）
{
NSCalendar * cal_ = [ESLocaleFactory gregorianCalendarWithLocaleId：locale_];
self-> targetFormatter = [NSDateFormatter new ];
[ESLocaleFactory setCalendar：cal_
forDateFormatter：self-> targetFormatter];
}
//日付を設定します
self-> targetFormatter.dateFormat = dateFormat_;
YESを返します。
}
//主な作業はすでに完了しています。
//準備されたNSDateFormatterを適用するためにのみ残ります
-（NSString *）getFormattedDate :( NSString *）strDate_;
{
NSDate * date_ = [self-> ansiFormatter dateFromString：strDate_];
NSString * result_ = [self-> targetFormatter stringFromDate：date_];
return result_;
}
*このソースコードは、ソースコードハイライターで強調表示されました。

そのため、strftimeに匹敵する時間で機能する、FP関数（純粋関数）の点でほぼ純粋なスレッドセーフを取得しました。
githubでコードの完全版を見つけることができます

NSCalendarを使用したSQLiteの最適化

More articles: