id_code: 862012249
entry_time: 2016-10-28 23:36:08
parent_id_code: 783924049_861760507288022
author_name: Lia+nik+son
author_code: 1294333813357
author_url: https://www.facebook.com/120357
author_image_url: http://graph.facebook.com/17/picture
entry_url: https://business.facebook.com/28262849
entry_types: COMMENT
status_code: MOD
entry_text: +so%2C++it%27s+the+home+team%21
entry_data: false,"can_comment":false}
last_update: 0000-00-00 00:00:00
pull_time: 2016-11-16 18:53:40
queue_code: NULL
####
id_code: 281938224734_10154342971729735
item_name: pull_run_id
item_value: 1480804468
item_data: NULL
####
DBD::mysql::st fetchrow_array failed: fetch() without execute() at /home/rdscopy.pl line 199.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at /home/rdscopy.pl line 199
####
#get Id_Codes based on entry time
my $feed_table_ext_idcode = $dbh2->prepare("SELECT id_code FROM $feed_table WHERE entry_time >= ?");
$feed_table_ext_idcode->execute($time);
my $feed_table_ext_results = $dbh2->prepare("SELECT * from $feed_table_ext WHERE id_code = ?");
while (my @row = $feed_table_ext_idcode->fetchrow_array())
{
#print "@row\n";
$feed_table_ext_results->execute(@row);
}
####
Returned after querying facebook_321_ext table in production and need to copy them to staging
************************** 24. row ***************************
id_code: 281938224734_10154342971729735
item_name: PRE_MOD_Krttime
item_value: 1480804542
item_data: NULL
*************************** 25. row ***************************
id_code: 281gfg154342971729735
item_name: PRE_MOD_SetQueue
item_value: UNKNOWN
item_data: NULL
*************************** 26. row ***************************
id_code: 281938224734_101gf29735
item_name: PRE_MOD_SetQueue_time
item_value: 1480804587
item_data: NULL
*************************** 27. row ***************************
id_code: 281938224734_10154342971729735
item_name: PRE_MOD_Textalfggtect
item_value: POSITIVE
item_data: NULL
*************************** 28. row ***************************
id_code: 281938224734_10154342971729735
item_name: PRE_MOD_TgfentDetect_time
item_value: 1480804573
item_data: NULL
*************************** 29. row ***************************
id_code: 281938224734_10154342971729735
item_name: pull_run_id
item_value: 1480804468
item_data: NULL
*************************** 30. row ***************************
id_code: 281938224734_10154342971729735
item_name: pugfme
item_value: 1480804471
item_data: NULL
####
my $ext_insert = $dbh3->prepare("INSERT IGNORE INTO $feed_table_ext (id_code, item_name, item_value, item_data) VALUES (?, ?, ?, ?)") or die $dbh3->errstr;
while (my @insert_ext = $feed_table_ext_results->fetchrow_array())
{
$ext_insert->execute(@insert_ext) or die $sth_insert->errstr;
}