iphone - CoreData sqlite3 db - populating timestamp column with python script -


i have coredata model backed sqllite db. want populate db initial data.

i have been using python far , has been working well. bit isn't working inserting dates. understand coredata stores dates in epoch format inserting them via python this:

time.mktime(datetime(2012, 7, 1, 12, 30, 30).timetuple())

however, doesn't give me correct date when data loaded via coredata. ideas on how format date read in correctly via coredata?

*note: realise people recommend doing via small app uses same model rather using python script, find python syntax more concise constructing , inserting lots of objects.

e.g. can call methods insert data this:

insertdata(con, 1, 1, 'data 1', 'description')

vs objective-c long-winded method calls:

[self insertdata withcon:con id: 1 i2:1 val:@"data 1", desc:@"description"];

core data appears use 1 january 2001, gmt reference date (same nsdate method timeintervalsincereferencedate) , not 1970, mktime function in python, you'd have calculate timestamp based on that.

this entirely undocumented of course, , i'd agree dpjanes' answer approach bad idea.

if really want this, construct appropriate timestamp in python this:

import time datetime import datetime ref = time.mktime(datetime(2001, 1, 1, 0, 0, 0).timetuple()) = time.time() - ref

Comments

Post a Comment

Popular posts from this blog

javascript - backbone.js Collection.add() doesn't `construct` (`initialize`) an object -

<!doctype html public "-//w3c//dtd xhtml 1.0 strict//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-strict.dtd"> <html> <head> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script> <script src="http://documentcloud.github.com/underscore/underscore-min.js"></script> <script src="http://documentcloud.github.com/backbone/backbone-min.js"></script> </head> <body> <button id="cmd_create_event" name="cmd_create_event" type="button">create new `event`</button> <script type="text/javascript"> var eventmodel = backbone.model.extend({ initialize : function() { console.log("`event` initialized. id: " + this.cid); this.bind("change:status", function() { console.log(this.get("status") + " value `status`"); }); this.bind("error", function(model, e...
Read more

c++ - Accessing inactive union member and undefined behavior? -

i under impression accessing union member other last 1 set ub, can't seem find solid reference (other answers claiming it's ub without support standard). so, undefined behavior? the confusion c explicitly permits type-punning through union, whereas c++ ( c++11 ) has no such permission. c11 6.5.2.3 structure , union members 95) if member used read contents of union object not same member last used store value in object, appropriate part of object representation of value reinterpreted object representation in new type described in 6.2.6 (a process called ‘‘type punning’’). might trap representation. the situation c++: c++11 9.5 unions [class.union] in union, @ 1 of non-static data members can active @ time, is, value of @ 1 of non-static data members can stored in union @ time. c++ later has language permitting use of unions containing struct s common initial sequences; doesn't permit type-punning. to determine whether union type-punning is allowe...
Read more

php - Get uncommon values from two or more arrays -

is there function in php give array of uncommon values 2 or more arrays? for example: $array1 = array( "green", "red", "blue"); $array2 = array( "green", "yellow", "red"); .... $result = function_needed($array1, $array2,...); print_r($result); should give output: array("blue", "yellow", ...); use array_diff , array_merge : $result = array_merge(array_diff($array1, $array2), array_diff($array2, $array1)); here's demo. for multiple arrays, combine callback , array_reduce : function unique(&$a, $b) { return $a ? array_merge(array_diff($a, $b), array_diff($b, $a)) : $b; } $arrays = array( array('green', 'red', 'blue'), array('green', 'yellow', 'red') ); $result = array_reduce($arrays, 'unique'); and here's demo of that.
Read more