huangzhibiao / bgdb_oc Goto Github PK

View Code? Open in Web Editor NEW

45.0 5.0 5.0 339 KB

BGDB OC版震撼出世.

Objective-C 94.53% Ruby 5.09% C 0.38%

fmdb sqlite lkdbsqlite jrdbsqlite bgdb

bgdb_oc's People

Contributors

Stargazers

Watchers

Forkers

zhwx600 summer1988 melodyym kevinheader wenzhefan

bgdb_oc's Issues

BGSqlite有很多方法是崩溃的

通过uniqueKey获取对象中的uniqueKeyVlaue时一直报错，比如BGSqlite的509和518行代码，id uniqueKeyVlaue = [self valueForKey:uniqueKey]，应该改为id uniqueKeyVlaue = [object valueForKey:uniqueKey]吧，self代表BGSqlite，不是要存储的对象，怎么可能取到相应的值

@property (nonatomic, assign) CLLocationCoordinate2D location 存此类型会直接 crash

@Property (nonatomic, assign) CLLocationCoordinate2D location 存此类型会直接 crash

往有唯一约束的表中插入不带唯一约束的数据，第一次成功。第二次失败（也没有提示原因）。第一次插入的数据唯一约束为0

insert another sqlite table

I persisted some objects in a table called Categories and I didn't get any issue there so far but now I want to persist some objects in another table called Channels but I get this error :

this is my code :

 NSArray *channelData = [channelsResults valueForKey:@"data"];
        
        for (id details in channelData ) {
            
            [Channels setDebug:YES];
    
            Channels *channelsData = [Channels new];

            channelsData.channelID = [details valueForKey:@"id"];
            channelsData.name = [details valueForKey:@"name"];
            channelsData.picture = [details valueForKey:@"picture"];
            channelsData.categoryID = [details valueForKey:@"category_id"];
            channelsData.desc = [details valueForKey:@"description"];
            [channelData saveOrUpdate];
        }

0.239657保存不上

请问为什么保存不上0.239657这样的CGFloat，保留的结果只为0；
1.239657保留的结果只为1；
小数点后面的能保留吗？

这个方法不会触发update，只会insert。bg_saveOrUpdate方法调用的是BigSqlite的+(BOOL)insertOrUpdate:(id)object ignoredKeys:(NSArray* const)ignoredKeys方法，不是+(BOOL)insertOrUpdate:(id)object，在+(BOOL)insertOrUpdate:(id)object ignoredKeys:(NSArray* const)ignoredKeys方法的511、513和519行代码，没有判断uniqueKeyVlaue是否是字符串，导致查询不出来已有的数据

is there a way to delete a single object from database?

this is my table :

I want to delete the object in "favoriteID" not the whole row

this is my code:

   NSString *cond = [NSString stringWithFormat:@"where favoriteID = '%@'",self.subchannelModel.subID];
    [Subchannels deleteWhere:cond];

when I use this code it will delete the whole row!

 for (id details in results ) {
           
           [Categories setDebug:YES];
            
            Categories *categoriesData = [Categories new];
            categoriesData.categoryID = [details valueForKey:@"id"];
            categoriesData.picture = [details valueForKey:@"picture"];
            categoriesData.display_name = [details valueForKey:@"display_name"];
            categoriesData.name = [details valueForKey:@"name"];
            
            [categoriesData saveOrUpdate];
        }
        
        NSLog(@"%@",[Categories findAll]);