ios - Cant use Fast enumeration to fill sqlite table -

-

i have messages object called mastermessages. looks this: 

self.messages = ( "<lean: 0x7fcf98665140, objectid: vgle1uj5ki, localid: (null)> {\n    messagebody = jj;\n    recipientid = xvvxetqjph;\n    senderid = xvvxetqjph;\n    timestamp = \"1424991590106.210938\";\n}", "<lean: 0x7fcf98667940, objectid: rgbfybmklu, localid: (null)> {\n    messagebody = \"test 3 ian\";\n    recipientid = xvvxetqjph;\n    senderid = hoy7ujlzoh;\n    timestamp = \"1424631667110.638184\";\n}", "<lean: 0x7fcf98667f30, objectid: hb5uhwsysu, localid: (null)> {\n    messagebody = \"test 2 user1\";\n    recipientid = xvvxetqjph;\n    senderid = vqzxwbdnal;\n    timestamp = \"1424630904935.162109\";\n}", "<lean: 0x7fcf986685b0, objectid: doe2b9oq5b, localid: (null)> {\n    messagebody = \"test 1\";\n    recipientid = xvvxetqjph;\n    senderid = xvvxetqjph;\n    timestamp = \"1424630808309.478027\";\n}" )

i create sqlite database calling method in viewdidload , saying sqlite3_errmsg variable being used incorrectly (it used char):

-(void)createdatabase{  nsstring *docsdir; nsarray *dirpaths;  // documents directory dirpaths = nssearchpathfordirectoriesindomains(                                                nsdocumentdirectory, nsuserdomainmask, yes);  docsdir = dirpaths[0];  // build path database file _databasepath = [[nsstring alloc]                  initwithstring: [docsdir stringbyappendingpathcomponent:                                   @"messages.db"]];  nsfilemanager *filemgr = [nsfilemanager defaultmanager];  if ([filemgr fileexistsatpath: _databasepath ] == no) {     const char *dbpath = [_databasepath utf8string];      if (sqlite3_open(dbpath, &_messagesdb) == sqlite_ok)     {         sqlite3_errmsg *errmsg;         const char *sql_stmt =         "create table if not exists messages (id integer primary key autoincrement, objectid text, messagebody text, recipientid text, senderid text, create_time text)";          if (sqlite3_exec(_messagesdb, sql_stmt, null, null, &errmsg) != sqlite_ok)         {             nslog(@"failed create table");          }         sqlite3_close(_messagesdb);     } else {         nslog(@"failed open/create database");     } }  }

i'm trying save mastermessages sqlite 'messages' table using fast enumeration , sqlite3_bind_xxx rmaddy suggested believe invoking incorrectly because keep getting error of expected identifier.

-(void)savequery{ sqlite3_stmt    *statement; const char *dbpath = [_databasepath utf8string];  if (sqlite3_open(dbpath, &_messagesdb) == sqlite_ok) {     (id lean in mastermessages) {         int *insertsql = [int sqlite3_bind("insert messages (objectid, messagebody, recipientid, senderid, create_time) values (\"%@\", \"%@\", \"%@\", \"%@\", \"%@\")",                            [lean valueforkeypath:@"objectid"],                            [lean valueforkeypath:@"messagebody"],                            [lean valueforkeypath:@"recipientid"],                            [lean valueforkeypath:@"senderid"],                            [lean valueforkeypath:@"timestamp"])];          nslog(@"insertsql = %@", insertsql);          const char *insert_stmt = [insertsql utf8string];         sqlite3_prepare_v2(_messagesdb, insert_stmt,                         -1, &statement, null);         if (sqlite3_step(statement) == sqlite_done)         {             nslog(@"message added");         } else {             nslog(@"failed add message");         }     }     sqlite3_finalize(statement);     sqlite3_close(_messagesdb); } }

how fix this?

thank you.


Comments

Post a Comment

Popular posts from this blog

google chrome - Developer tools - How to inspect the elements which are added momentarily (by JQuery)? -

-
i looking @ how website designed using inspector in chrome. can use firefox developer tools or firefox web developer add-on or chrome web developer extension. so website has slide-show , using jquery it. looking @ markup , css in inspector, i see 2 things constantly changing slides change: one opacity css property understandable, i'd see changing values, changes fast see read anything. second- a div added in div slides change momentarily , moment when appears short notice except div . so question is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? where can inspect div element gets added such short moment , , gets removed? , can see changes in value of opacity takes place? is there way stop slideshow can temporarily rid of blinking sort of effect (by speedy adding , removal , changing of elements , values)? if opacity animated css transition or animation,
Read more

angularjs - Showing an empty as first option in select tag -

-
my app showing empty select field first entry. have read other solution given , tried still not working. my controller code is: .controller('usercreatecontroller', function(user,profile,auth) { alert("hello"); var vm = this; vm.type = 'create'; profile.all() //this service fetch profiles shown in select field .success(function(data){ vm.profile = data; }); vm.userdata.profile = vm.profile[0]; //here have set default value select field and html page is: <label class="col-sm-2 control-label">profile</label> <div class="col-sm-8"> <select ng-model="user.userdata.profile" ng-options="person._id person.profilename person in user.profile"> </select> </div> hierarchy of vm.profile { "_id": 46, "profile": objectid("5516498e95b84548156db754"), "isactive": true, "password": "$2
Read more

php - Cloud9 cloud IDE and CakePHP -

-
i attempting cakephp running on cloud9, cloud based ide. unaware, cloud collaboration ide intermixes services such bitbucket. site gives sudo rights, , installed cakephp using these instructions: https://www.digitalocean.com/community/tutorials/how-to-install-cakephp-on-an-ubuntu-12-04-vps when attempt run database exported machine cakephp installed, error message "url rewriting not configured on server." attempted solve issue using official guide cakephp: http://book.cakephp.org/2.0/en/installation/url-rewriting.html but no cigar, same error message. has gotten cakephp working, or aware of cloud ide free/low cost cloud9 support cakephp? here's how got working now: sudo apt-get update sudo apt-get install php5-intl curl -ss https://getcomposer.org/installer | php -- --filename=composer ./composer create-project --prefer-dist cakephp/app this creates project in /app default. move workspace docroot: mv app/* ./ mv app/.* ./ rm -rf app then de
Read more