Tuesday, October 14, 2014

Day 21: What do you eat at Canadian Thanksgiving?

Turkey, apparently. Similar to that of the American Thanksgiving. Though, there is less poultry-mixing (no turduckens) and a significant lack of deep-fried anything.

There was actually no work today. But I'm having a tough time getting off the beautifully clean five days a week numbering system.

We, however, did not have turkey today. 

Thankfully, Loki and I are both feeling much better after our rough and tough Friday. As such, I felt up to particularly special Thanksgiving dinner. 

Home-fried chicken sandwiches it is! Admittedly, not the best thing for me. But after three days of protein shakes, apple sauce and tomato soup, it sure sounded amazing! So far, the body is holding up fine despite the solid food interruption. Good news things. 

What else are we doing to celebrate the festive day? Why, watching all of the Harry Potter movies, of course! Man, things have really improved since 2001.

Burgess Family Infirmary

This weekend wasn't what we were expecting.

We had plans to go down to Seattle for the three day weekend. Visit Michael, see the Space Needle, visit the site of the World's Fair. All the Seattle things. 

But things were working against the Burgess clan.

I've been having constant stomach pains since Sunday night. They got worse at night, when I moved around or lied down. They got better when I ate. Sometimes the pain radiated through to my back. I finally gave in to go see a doctor on Thursday. He told me I have mild pancreatitis.

He then told us I should eat really gentle things for a few days to give my pancreas a break and let it heal itself. You know, steamed vegetables, bananas, mashed potatoes, rice. All of the things that I don't eat. Great. 

I did some internet medical research on my own and figured out that an all-liquids weekend was probably the best thing I could do for it. The doctor also gave me some pills that are essentially Prevacid to help calm down my stomach. 

After we got home from the doctor and propped me up with a heating pad, tomato soup, and tons of pillows, we noticed Loki was keeping his right eye closed. Because we weren't already up to our elbows in ailments. 

We called a vet to make sure there wasn't anything more seriously wrong with him. Initially we got the all clear, with instructions to bring him in if it didn't clear up. 

Friday night, of course, it hadn't cleared up. 

We'd already decided to stay in town for the weekend. My pain was getting worse, and walking around Seattle all weekend really wasn't in the cards. 

Loki had a trip back to the vet. He asked us a series of questions and we were initially hopeful as our answers were all "no." He hadn't been sneezing, or coughing, or itching at the eye, eating less or not drinking, there was not watery or gunky discharge. Evidently these were not the right answers and only made the vet more concerned. 

He gave Loki some drops to "freeze" the eye (still not sure what that was, but he said it would help with the pain he was having). Then he dropped in some dye that would stay in any scratches. Then he had to flush the eye with water.

Now, even with humans, flushing an eye with water is not an easy or pleasant experience. With cats, even worse. Loki hated every minute of this. The vet had a very large syringe without a needle so that he could repeatedly squirt the water at poor Loki's eye. 

The final step was to turn off all of the lights and use a florescent flashlight to look for any dye remaining in Loki's eye. To our horror, a spot the size of a pea shone bright green on his cornea. This is a corneal ulcer, one of the largest the vet had seen. Holy moly. 

He said the pain would be very harsh and it was odd that there had been no discharge. It would have started with a small scratch while he and Amelia were playing, or while Loki was grooming, or with a small foreign body, such as dust. The most important thing now was making sure that any treatment avenue we chose worked as fast as possible.

The vet brought in a gel-like eye drop antibiotic, dropping one drop into his eye and making sure it spread across the whole eye. This would need to be done every 2 hours for 24 hours, then every 4 hours for another 24 hours, then every 6 hours for 4 days. However, if there was no difference in the first 12 hours, we would need to switch to a stronger dose of two different antibiotics. 

Welcome to the long holiday weekend.

Monday, October 13, 2014

Day 20: Is this safe?

Yesterday I picked up a ticket that involved data from a remote database. It involved some values in a grade sheet that were deleted. 

Since we had minimal access to the backup with the values still there, it would be a pretty basic fix to restore them.

I found the exporter for the grade sheet and pulled a copy of the grades. 

Now, the next step was to use the importer to restore them. 

But holy moly things on the live site. 

Messing around on a copy of a backup is one thing. Even if (when) things DO go horribly wrong, the only person it effects is you! If you ruin things on a live site, the client and the company as a whole suffer! That is scary stuff for a new developer!

So I checked with everyone I could about whether I should do this and if I was doing it properly. 

The tricky part is Thanksgiving. Yeah, that's right, Thanksgiving in October. It's Monday. Several people also took Friday off in order to have an extra long weekend. There were less people around to help in case I broke everything.

Yipes.

I had a member of the customer service team actually sit down and walk me through the importer on the live site. Thankfully, it went off without a hitch! I was able to wrap up another ticket and get home since I wasn't feeling well and we were worried about Loki.