public void WriteFrameData(HandShapeModel handModel)
{
if (connection == null || command == null) return;
// cmd = String.Format("INSERT INTO FrameData " +
// "(FrameDataId, SignInfoId, FrameCount, OffsetedFrameCount, " + //0, 1, 2
//"SkeletonHeadX, SkeletonHeadY, SkeletonHeadZ, " +
//"SkeletonShoulderCenterX, SkeletonShoulderCenterY, SkeletonShoulderCenterZ, " +
//"SkeletonShoulderLeftX, SkeletonShoulderLeftY, SkeletonShoulderLeftZ, " +
//"SkeletonShoulderRightX, SkeletonShoulderRightY, SkeletonShoulderRightZ, " +
//"SkeletonSpineX, SkeletonSpineY, SkeletonSpineZ, " +
//"SkeletonHipCenterX, SkeletonHipCenterY, SkeletonHipCenterZ, " +
//"SkeletonHipLeftX, SkeletonHipLeftY, SkeletonHipLeftZ, " +
//"SkeletonHipRightX, SkeletonHipRightY, SkeletonHipRightZ, " +
//"SkeletonElbowLeftX, SkeletonElbowLeftY, SkeletonElbowLeftZ, " +
//"SkeletonWristLeftX, SkeletonWristLeftY, SkeletonWristLeftZ, " +
//"SkeletonHandLeftX, SkeletonHandLeftY, SkeletonHandLeftZ, " +
//"SkeletonElbowRightX, SkeletonElbowRightY, SkeletonElbowRightZ, " +
//"SkeletonWristRightX, SkeletonWristRightY, SkeletonWristRightZ, " +
//"SkeletonHandRightX, SkeletonHandRightY, SkeletonHandRightZ, " +
// "HandCount, " +
// "Hand0FingertipCount, " +
// "Hand0Fingertip0X, Hand0Fingertip0Y, Hand0Fingertip0Z, " +
// "Hand0Fingertip1X, Hand0Fingertip1Y, Hand0Fingertip1Z, " +
// "Hand0Fingertip2X, Hand0Fingertip2Y, Hand0Fingertip2Z, " +
// "Hand0Fingertip3X, Hand0Fingertip3Y, Hand0Fingertip3Z, " +
// "Hand0Fingertip4X, Hand0Fingertip4Y, Hand0Fingertip4Z, " +
// "Hand0EllipseCenterX, Hand0EllipseCenterY, " +
// "Hand0EllipseMajorAxis, Hand0EllipseMinorAxis, " +
// "Hand0EllipseAspectRatio, Hand0AxisTheta, " +
// "Hand1FingertipCount, " +
// "Hand1Fingertip0X, Hand1Fingertip0Y, Hand1Fingertip0Z, " +
// "Hand1Fingertip1X, Hand1Fingertip1Y, Hand1Fingertip1Z, " +
// "Hand1Fingertip2X, Hand1Fingertip2Y, Hand1Fingertip2Z, " +
// "Hand1Fingertip3X, Hand1Fingertip3Y, Hand1Fingertip3Z, " +
// "Hand1Fingertip4X, Hand1Fingertip4Y, Hand1Fingertip4Z, " +
// "Hand1EllipseCenterX, Hand1EllipseCenterY, " +
// "Hand1EllipseMajorAxis, Hand1EllipseMinorAxis, " +
// "Hand1EllipseAspectRatio, Hand1AxisTheta) " +
// "VALUES(NULL, {0}, {1}, {2}{3})",
// SignInfoId, frameData.frameCount, frameData.OffsetedFrameCount, frameData.GetFrameDataArgString()
// );
// insertions.Add(cmd);
//} else {
// if (insertions.Count > 0) { //Batch insertion
// var sw = Stopwatch.StartNew();
// reader.Close();
// SQLiteTransaction trans = connection.BeginTransaction(); // <-------------------
// try
// {
// foreach (string insertion in insertions)
// {
// command.CommandText = insertion;
// command.ExecuteNonQuery();
// }
// insertions.Clear();
// trans.Commit(); // <-------------------
// }
// catch
// {
// trans.Rollback(); // <-------------------
// throw; // <-------------------
// }
// Console.WriteLine("save data:" + sw.ElapsedMilliseconds);
// }
//}
//if (!reader.IsClosed) {
// reader.Close();
//}
////if (cmd != String.Empty) {
//// command.CommandText = cmd;
//// command.ExecuteNonQuery();
////}
}