Daiyi Yang dyangrev
dyangrev
/ gist:cdb8730249a51c70ac87
Created
September 5, 2014 19:40
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> show processlist; | |
| +---------+----------+----------------------+---------+---------+------+-------+------------------+ | |
| | Id | User | Host | db | Command | Time | State | Info | | |
| +---------+----------+----------------------+---------+---------+------+-------+------------------+ | |
| | 4774850 | revinate | 10.208.236.14:45699 | inguest | Sleep | 1 | | NULL | | |
| | 4778642 | revinate | 10.208.236.14:50485 | inguest | Sleep | 1 | | NULL | | |
| | 4778655 | revinate | 10.208.230.201:59397 | inguest | Sleep | 2 | | NULL | | |
| | 4778661 | revinate | 10.208.236.14:50522 | inguest | Sleep | 2 | | NULL | | |
| | 4778689 | revinate | 10.208.234.88:59617 | inguest | Sleep | 1 | | NULL | | |
| | 4778694 | revinate | 10.208.234.88:59655 | inguest | Sleep | 2 | | NULL | |
dyangrev
/ gist:5649fea7837c1d025fd8
Created
August 7, 2014 18:23
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
| $ sfconsole revinate:debug:daiyi --env=dev | |
| object(Revinate\SharedBundle\Elasticsearch\Entity\GRM\GuestProperty)#610 (22) { | |
| ["id":protected]=> | |
| string(32) "4beb38bb055a079db06bb619e92cf956" | |
| ["propertyId":protected]=> | |
| int(360) | |
| ["city":protected]=> | |
| string(9) "Sunnyvale" | |
| ["firstName":protected]=> | |
| string(5) "Vinay" |
dyangrev
/ gist:71b9e8d17b9e497c2068
Created
August 5, 2014 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
| xdebug.collect_params=2 | |
| xdebug.default_enable=0 # do not enable by default | |
| # profiler config | |
| xdebug.profiler_output_dir=/var/log/xdebug | |
| xdebug.profiler_append=1 | |
| xdebug.profiler_enable=0 | |
| # trigger manually only | |
| xdebug.profiler_enable_trigger=1 | |
| xdebug.profiler_output_name=profile.%R.%t |
dyangrev
/ gist:b4d1fcc287444bcf770b
Created
August 5, 2014 18:50
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
| object(Revinate\SharedBundle\Elasticsearch\Entity\GRM\GuestProperty)#247 (21) { | |
| ["id":protected]=> | |
| string(32) "4beb38bb055a079db06bb619e92cf956" | |
| ["propertyId":protected]=> | |
| int(360) | |
| ["city":protected]=> | |
| NULL | |
| ["firstName":protected]=> | |
| string(5) "Vinay" | |
| ["lastName":protected]=> |
dyangrev
/ gist:6d27c8921f4b63b8ea0b
Created
June 18, 2014 17:21
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
| { | |
| "from": "0", | |
| "size": "25", | |
| "query": { | |
| "bool": { | |
| "must": [{ | |
| "filtered": { | |
| "query": { | |
| "custom_score": { | |
| "script": "_score >= 1 ? 100000000000 : 0", |
dyangrev
/ gist:117232c53e171a57aada
Created
May 22, 2014 19: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
| daiyi at Daiyi in ~ | |
| $ npm uninstall -g faker | |
| unbuild [email protected] | |
| daiyi at Daiyi in ~ | |
| $ npm uninstall -g moment | |
| unbuild [email protected] | |
| daiyi at Daiyi in ~ | |
| $ npm uninstall -g Faker | |
| npm WARN uninstall not installed in /usr/local/lib/node_modules: "Faker" | |
| daiyi at Daiyi in ~ |
dyangrev
/ gist:0c2507c2a53c926595e7
Created
May 15, 2014 05:11
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
| Job 11319: 2014-05-13 15:02:30 PDT - statds incrementing New guest gets persisted during import --- historyId : 11136, email : [email protected] | |
| Job 11319: 2014-05-13 15:02:30 PDT - statds incrementing saving guest stay --- 1202 s. gumwood__sep____sep__pharr__sep__tx__sep__78577__sep__us__sep____sep____sep__benjamin__sep__zepeda__sep__tijerinajessica@yahoo.com__sep__956-330-9018__sep__515__sep__85.00__sep____sep____sep____sep____sep__1399766400__sep__1399939200__sep____sep__78577__sep__ | |
| Job 11319: 2014-05-13 15:02:30 PDT - statds incrementing New guest gets schedule to be inserted --- | |
| Job 11319: 2014-05-13 15:02:31 PDT - statds incrementing new guest stay created by pms/manual upload --- propertyId : 4, guestStayId : 2915363 | |
| Job 11319: 2014-05-13 15:02:31 PDT - statds incrementing indexing guest stay --- 1202 s. gumwood__sep____sep__pharr__sep__tx__sep__78577__sep__us__sep____sep____sep__benjamin__sep__zepeda__sep__tijerinajessica@yahoo.com__sep__956-330-9018__sep__515__sep__85.00__sep____sep____sep__ |
dyangrev
/ gist:16d413eb7786378729a5
Created
May 15, 2014 05: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
| query: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED | |
| params: [] | |
| query: "START TRANSACTION" | |
| params: null | |
| query: SELECT DISTINCT id0 FROM (SELECT g0_.id AS id0, g0_.guest_id AS guest_id1, g0_.property_id AS property_id2, g0_.token AS token3, g0_.confirmation_code AS confirmation_code4, g0_.room_number AS room_number5, g0_.checkin_date_time AS checkin_date_time6, g0_.booking_date AS booking_date7, g0_.checkin_date AS checkin_date8, g0_.is_checked_in AS is_checked_in9, g0_.checkout_date AS checkout_date10, g0_.trip_type AS trip_type11, g0_.room_type AS room_type12, g0_.room_rate AS room_rate13, g0_.reservation_source AS reservation_source14, g0_.reservation_amount AS reservation_amount15, g0_.is_from_pms AS is_from_pms16, g0_.guest_list_import_history_id AS guest_list_import_history_id17, g0_.hash AS hash18, g0_.debug_hash AS debug_hash19, g0_.private_id AS private_id20, g0_.email AS email21, g0_.phone AS phone22, g0_.average_room_rate AS average_room_rate23, g0_.title AS title24, g0_.online_checkin_at |
dyangrev
/ gist:1c438b34ed6bc1915d96
Created
May 8, 2014 21:57
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
| query: "COMMIT" | |
| params: null | |
| query: SELECT g0_.id AS id0, g0_.push_id AS push_id1, g0_.created_at AS created_at2, g0_.updated_at AS updated_at3, g0_.guest_identity_id AS guest_identity_id4, g0_.guest_list_import_history_id AS guest_list_import_history_id5, g0_.guest_identity_id AS guest_identity_id6, g0_.guest_list_import_history_id AS guest_list_import_history_id7 FROM Guest g0_ WHERE g0_.id = ? | |
| params: [2756156] | |
| query: SELECT t0.id AS id1, t0.name AS name2, t0.isStopped AS isStopped3, t0.lastConfigurationStoppedAt AS lastConfigurationStoppedAt4, t0.lastScriptStartedAt AS lastScriptStartedAt5 FROM CommandRunnerConfiguration t0 WHERE t0.name = ? LIMIT 1 | |
| params: ["revinate:guestList:manualImportProcess"] | |
| query: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED | |
| params: [] | |
| query: "START TRANSACTION" | |
| params: null |
dyangrev
/ gist:8c3c6bbfb13d9fb58fee
Created
May 8, 2014 21:40
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
| query: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED | |
| params: [] | |
| query: SELECT g0_.id AS id0, g0_.guest_id AS guest_id1, g0_.property_id AS property_id2, g0_.method AS method3, g0_.value AS value4, g0_.sanitized_value AS sanitized_value5, g0_.created_at AS created_at6, g0_.updated_at AS updated_at7, g0_.is_from_pms AS is_from_pms8, g0_.is_valid AS is_valid9, g0_.guest_list_import_history_id AS guest_list_import_history_id10, g0_.is_primary AS is_primary11, g0_.guest_id AS guest_id12, g0_.property_id AS property_id13, g0_.guest_list_import_history_id AS guest_list_import_history_id14 FROM GuestContact g0_ WHERE (g0_.sanitized_value = ? AND g0_.method = ?) AND g0_.property_id = ? AND g0_.guest_id = ? AND g0_.is_from_pms = ? LIMIT 1 FOR UPDATE | |
| params: ["+13105532482","sms",4,null,true] | |
| query: SELECT g0_.id AS id0, g0_.guest_id AS guest_id1, g0_.property_id AS property_id2, g0_.method AS method3, g0_.value AS value4, g0_.sanitized_value AS sanitized_value5, g0_.created_at AS created_at6, g0_.updated_at |