Daiyi Yang dyangrev
dyangrev
/ gist:2179b8c637443fbfec8e
Created
October 8, 2015 23:15
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766617 | |
| php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766529 | |
| php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766530 | |
| php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766531 | |
| php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766532 | |
| php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766536 | |
| php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766534 | |
| php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766537 | |
| php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766538 | |
| php /var/www/inguest/current/app/console revinate:guestList:manualImportProcess 766535 |
dyangrev
/ gist:290ac21218a376aa5291
Created
March 10, 2015 23:14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mysql> select max(created_at) from PMSImportRecord where content like "%checkinDate\":\"____-__-__T__:__:__.000+00%"; | |
| +---------------------+ | |
| | max(created_at) | | |
| +---------------------+ | |
| | 2015-02-23 20:42:35 | | |
| +---------------------+ | |
| 1 row in set (6.64 sec) | |
| mysql> select max(created_at) from PMSImportRecord where content like "%checkoutDate\":\"____-__-__T__:__:__.000+00%"; | |
| +---------------------+ |
dyangrev
/ gist:0afcab9f757d532c4ddb
Created
March 10, 2015 23:08
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"property":"BHH","bookingDate":"2015-02-23T12:14:09.000+0000","checkinDate":"2015-02-24T00:00:00.000+0000","stayLength":{"stayLength":1,"stayLengthUnits":"DAY"},"guestNotes":[{"type":"RESERVATION","text":"Negotiated rate plan name: ABC Corporate SVC","comment":"Negotiated rate plan name: ABC Corporate SVC","time":"2015-02-23T12:14:09.000+0000","mfcommentDate":"2015-02-23T12:14:09.000+0000"}],"profiles":[{"profileId":"1908939","profileType":"GUEST","phoneNumbers":[{"phoneNumber":"2072463207","phoneNumberType":"HOME"}],"firstName":"Andrewmr","lastName":"Davies","gender":"UNKNOWN","emailOptOut":"false","mailOptOut":"false"},{"profileId":"74283","profileType":"TRAVEL","postalAddresses":[{"addressType":"HOME","address1":"26 Old Bailey","city":"London","country":"GB","zipCode":"EC4M 7HS"},{"addressType":"BUSINESS","address1":"26 Old Bailey","city":"London","country":"US","state":"GB","zipCode":"EC4M 7HS"},{"addressType":"HOME","address1":"C\/0 Beazley Group Plc","address2":"Plantation Place South","city":"London", |
dyangrev
/ gist:64d3297decb28bb943f5
Created
March 6, 2015 22:39
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| mysql> select * from GuestStayInfo where value like '%[{%' order by created_at desc limit 1; | |
| +--------+---------------+---------+-------------+------------+---------------------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | |
| | id | guest_stay_id | user_id | action_type | created_by | created_at | attribute_name | value | | |
| +--------+---------------+---------+-------------+------------+---------------------+----------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | |
| | 888393 | 4446304 | NULL | add | NULL | 2015-03-06 22:35:16 | notes | {"v |
dyangrev
/ gist:29193ec6abeffca85d43
Created
March 4, 2015 21:14
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 150304 12:19:16 | |
| *** (1) TRANSACTION: | |
| TRANSACTION 95B6, ACTIVE 0 sec starting index read | |
| mysql tables in use 1, locked 1 | |
| LOCK WAIT 5 lock struct(s), heap size 1248, 2 row lock(s), undo log entries 2 | |
| MySQL thread id 587, OS thread handle 0x7fa5fdc76700, query id 5596 localhost 127.0.0.1 root Updating | |
| UPDATE GuestStay SET updated_at = '2015-03-04 20:19:16', average_room_rate = '0', es_version = 2 WHERE id = 3434580 | |
| *** (1) WAITING FOR THIS LOCK TO BE GRANTED: | |
| RECORD LOCKS space id 37 page no 13025 n bits 88 index `PRIMARY` of table `inguest`.`GuestStay` trx id 95B6 lock_mode X locks rec but not gap waiting | |
| Record lock, heap no 16 PHYSICAL RECORD: n_fields 80; compact format; info bits 0 |
dyangrev
/ gist:582ac37539e0b2a4125c
Created
January 11, 2015 20:05
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #include "mbed.h" | |
| #include "N5110.h" | |
| #define TMP102_ADD 0X48 | |
| #define TMP102_R_ADD 0x91 | |
| #define TMP102_W_ADD 0x90 | |
| #define TEMP_REG 0x00 | |
| #define CONFIG_REG 0x01 | |
| #define THIGH_REG 0x02 |
dyangrev
/ gist:d0afdaf405c3bbf8808b
Created
December 17, 2014 01:28
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ::: [inguest-es-02.stage.rpc][to1rWlMJQSSI2RCh3cE24A][inguest-es-02.stage.rpc.revinate.net][inet[/10.20.0.113:9300]]{max_local_storage_nodes=1, master=true} | |
| 26.6% (132.9ms out of 500ms) cpu usage by thread 'elasticsearch[inguest-es-02.stage.rpc][search][T#3]' | |
| 4/10 snapshots sharing following 19 elements | |
| org.apache.lucene.search.ScoreCachingWrappingScorer.score(ScoreCachingWrappingScorer.java:51) | |
| org.elasticsearch.common.lucene.MinimumScoreCollector.collect(MinimumScoreCollector.java:56) | |
| org.apache.lucene.search.Weight$DefaultBulkScorer.scoreAll(Weight.java:185) | |
| org.apache.lucene.search.Weight$DefaultBulkScorer.score(Weight.java:163) | |
| org.apache.lucene.search.BulkScorer.score(BulkScorer.java:35) | |
| org.apache.lucene.search.IndexSearcher.search(IndexSearcher.java:621) |
dyangrev
/ gist:0b1b59c0e2c7684464c0
Created
September 18, 2014 00:07
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Run post request to http://10.208.200.102:9200/grm/guest_property/_search | |
| { | |
| "from": 0, | |
| "size": 0, | |
| "query": { | |
| "match_all": {} | |
| }, | |
| "aggs": { | |
| "interests": { | |
| "terms": { |
dyangrev
/ gist:5ef017750fd36b717ec3
Created
September 15, 2014 21:32
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "_index": "grm", | |
| "_type": "guest_property", | |
| "_id": "5ea098ba43b11b8bd7b996067b0d2d83", | |
| "_score": 1, | |
| "_source": { | |
| "id": "5ea098ba43b11b8bd7b996067b0d2d83", | |
| "city": { | |
| "value": null | |
| }, |
dyangrev
/ gist:099d152babf2af31d9c9
Created
September 11, 2014 21:10
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "took": 6, | |
| "timed_out": false, | |
| "_shards": { | |
| "total": 20, | |
| "successful": 20, | |
| "failed": 0 | |
| }, | |
| "hits": { | |
| "total": 1, |