Lowyat.NET: Latest topics by jackoats.my

Export images from MSSQL table

jackoats.my — Sat, 19 Sep 2020 18:10:44 +0800

Yo, anybody still working on Saturday?

I have a summary of the Product table in [AdventureWorksLT2019].[SalesLT].[Product], in which images file are embedded in the table, as shown below.

CODE

ProductID, ThumbNailPhoto, ThumbNailPhotoFileName
680, 0x47494638396150003100..., no_image_available_small.gif
739, 0x47494638396150003100..., frame_silver_small.gif
744, 0x47494638396150003100..., frame_black_small.gif

I managed to extract an image out (680.gif, hardcoded) from the table, by running the following commands:

CODE

...
SET @mynum = 680 -- something meaningful only to me
SET @sql2 = 'BCP "SELECT ThumbNailPhoto FROM [AdventureWorksLT2019].[SalesLT].[Product] where ProductID=@mynum"
QUERYOUT C:\exportdir\680.gif -T -f C:\exportdir\testblob.fm -S ' + @@SERVERNAME
...

How do I rewrite the code to extract every product's image, with the exported image's name the same as the ProductID?

See stars in JavaScript codes

jackoats.my — Mon, 31 Aug 2020 13:17:52 +0800

Question: When start() runs, how many of the message 'Workout complete!' do I see?

Given Exercise plan is made up of an exercise and its running duration. E.g. ExercisePlan_A could be like:

CODE

"ExercisePlan_A":
{
"push up",
"240"
}

And a snippets of the JavaScript code looks like this:

CODE

ngOnInit(): void {
this.workoutPlan = this.buildWorkout();
this.restExercisePlan = new ExercisePlan(new Exercise('rest', 'Relax!', 'Relax a bit', 'rest.png'), this.workoutPlan.restBetweenExercise);
this.start();
}

startExercise(exercisePlan: ExercisePlan) {
this.currentExercisePlan = exercisePlan; // exercise in progress
this.exerciseRunningDuration = 0; // and how long has it run so far

const intervalId = setInterval(() => {
if (this.exerciseRunningDuration // transition to next exercise
>= this.currentExercisePlan.duration) { // when currect exercise's duration is up
clearInterval(intervalId);
const next: ExercisePlan = this.getNextExercisePlan();
if (next) {
if (next !=this.restExercisePlan) {
this.currentExerciseIndex++;
}
this.startExercise(next);
}
else {
console.log('Workout complete!');
}
}
else {
this.exerciseRunningDuration++; // increment exerciseRunningDuration by 1 second
}
}, 1000)
}

getNextExercisePlan(): ExercisePlan {
let nextExercisePlan: ExercisePlan = null;
if (this.currentExercisePlan ===
this.restExercisePlan) { // Start next exercise after resting
nextExercisePlan = this.workoutPlan.exercisePlans[this.currentExerciseIndex + 1];
}
else if (this.currentExerciseIndex < this.workoutPlan.exercisePlans.length - 1) {
nextExercisePlan = this.restExercisePlan;
}

return nextExercisePlan;
}

start() {
this.currentExerciseIndex = 0;
this.startExercise(this.workoutPlan.exercisePlans[this.currentExerciseIndex]);
}

buildWorkout(): WorkoutPlan {
const workout = new WorkoutPlan('7MinWorkout', '7 Minute Workout', 10, []);
workout.exercisePlans.push(
new ExercisePlan(
new Exercise(
'jumpingJacks',
'Jumping Jacks',
'A jumping jack or star jump, also called side-straddle hop is a physical jumping exercise.',
'JumpingJacks.png',
'jumpingjacks.wav',
`Assume an erect position, with feet together and arms at your side.
Slightly bend your knees, and propel yourself a few inches into the air.
While in air, bring your legs out to the side about shoulder width or slightly wider.
As you are moving your legs outward, you should raise your arms up over your head; arms should be
slightly bent throughout the entire in-air movement.
Your feet should land shoulder width or wider as your hands meet above your head with arms slightly bent`,
['dmYwZH_BNd0', 'BABOdJ-2Z6o', 'c4DAnQ6DtF8']),
30));
...
workout.exercisePlans.push(
new ExercisePlan(
new Exercise(
'sidePlank',
'Side Plank',
'A variation to Plank done using one hand only.',
'sideplank.png',
'sideplank.wav',
`Lie on your side, in a straight line from head to feet, resting on your forearm.
Your elbow should be directly under your shoulder.
With your abdominals gently contracted, lift your hips off the floor, maintaining the line.
Keep your hips square and your neck in line with your spine. Hold the position.`,
['wqzrb67Dwf8', '_rdfjFSFKMY']),
30));

return workout;
}

Helping non-IT transitioning to IT going to work?

jackoats.my — Mon, 24 Aug 2020 16:23:46 +0800

I have been active in some online communities, giving some 'advice' to help non IT transitioning to IT jobs.

Some of them might think that IT industry may offer them safe harbor while their jobs are threatened by bad economy now.

Considering that IT industry is so competitive already, do you think their effort (and mine) is going to be just in vain?

One-leg-kick programmer sidekick wanted

jackoats.my — Tue, 28 Jul 2020 13:26:42 +0800

Hi, I have just started an IT blog (business tech & educational) and would need some help in a programmer sidekick. Basically there are some tiny business problems to solve using tech. Some coding required to work them out, e.g. OCR, data extraction, testing etc using Python, JavaScript or Java & Google Cloud.

I can only afford small remuneration on a freelance basis right now. When the business picks up, I hope to pay better.

Interested, please PM me with your profile & contact details. Please state your daily rate. Thank you.

Facebook Workplace development

jackoats.my — Thu, 26 Mar 2020 10:24:32 +0800

Hello. Do you guys know how to forward the identity of Facebook Workplace user to backend server together with some user info such as Name, email, telephone etc?

"Interview" question

jackoats.my — Sat, 09 Nov 2019 09:16:14 +0800

Can anyone tell me how to solve this problem?

How would you cut a rectangular cake into two equal pieces when a rectangular piece has already been cut out of it? The cut piece can be of any size and orientation. You are only allowed to make one straight cut.

How to code it in Java or Python?