4 Copyright (C) 2003-2005 SKYRIX Software AG
6 Author: Helge Hess (helge.hess@skyrix.com)
8 This file is part of the SQLite Adaptor Library
10 This library is free software; you can redistribute it and/or
11 modify it under the terms of the GNU Library General Public
12 License as published by the Free Software Foundation; either
13 version 2 of the License, or (at your option) any later version.
15 This library is distributed in the hope that it will be useful,
16 but WITHOUT ANY WARRANTY; without even the implied warranty of
17 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
18 Library General Public License for more details.
20 You should have received a copy of the GNU Library General Public
21 License along with this library; see the file COPYING.LIB.
22 If not, write to the Free Software Foundation,
23 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
26 #include "SQLiteChannel.h"
27 #import <Foundation/NSString.h>
30 @implementation NSString(SQLiteValues)
32 static Class EOExprClass = Nil;
34 - (id)initWithSQLiteInt:(int)_value {
36 sprintf(buf, "%i", _value);
37 return [self initWithCString:buf];
39 - (id)initWithSQLiteDouble:(double)_value {
41 sprintf(buf, "%g", _value);
42 return [self initWithCString:buf];
45 - (id)initWithSQLiteText:(const unsigned char *)_value {
46 return [self initWithUTF8String:_value];
49 - (id)initWithSQLiteData:(const void *)_value length:(int)_length {
52 d = [[NSData alloc] initWithBytes:_value length:_length];
53 self = [self initWithData:d encoding:NSUTF8StringEncoding];
58 - (NSString *)stringValueForSQLite3Type:(NSString *)_type
59 attribute:(EOAttribute *)_attribute
61 // TODO: all this looks slow ...
65 if ((len = [_type length]) == 0)
68 c1 = [_type characterAtIndex:0];
79 _type = [_type lowercaseString];
81 if (!([_type hasPrefix:@"char"] ||
82 [_type hasPrefix:@"varchar"] ||
83 [_type hasPrefix:@"text"]))
86 /* TODO: creates too many autoreleased strings :-( */
88 expr = [self stringByReplacingString:@"\\" withString:@"\\\\"];
90 if (EOExprClass == Nil) EOExprClass = [EOQuotedExpression class];
91 expr = [[EOExprClass alloc] initWithExpression:expr
92 quote:@"'" escape:@"\\'"];
93 s = [[expr expressionValueForContext:nil] retain];
95 return [s autorelease];
99 if ([[_type lowercaseString] hasPrefix:@"money"])
100 return [@"$" stringByAppendingString:self];
108 @end /* NSString(SQLiteValues) */