database.c 7.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275
  1. #include "database.h"
  2. #include "usart.h"
  3. Database db;
  4. void Database_init(uint16_t pushSize1, uint16_t pullSize1 ,uint16_t pushSize2, uint16_t pullSize2);
  5. void Database_Push(uint16_t pushArr[], uint16_t len);
  6. void Database_Pull(uint16_t pullArr[], uint16_t len);
  7. void Database_Delete(void);
  8. void DataHandle(void);
  9. void RecordScale(void);//记录刻度
  10. void RecordScale_Eve(void);
  11. uint16_t PDA_pushArr[1024];
  12. uint16_t PT_pullArr[1024];
  13. extern TipsFlag tipsflag;
  14. extern Menu_table menu;
  15. // LocDbHeadStart ((uint32_t)0x8060000) //位置信息头部
  16. // LocDbBodyStart ((uint32_t)0x8060800) //位置信息身体
  17. // EveDbHeadStart ((uint32_t)0x8070000) //状态信息头部
  18. // EveDbBodyStart ((uint32_t)0x8070800) //状态信息身体
  19. /**
  20. * @breaf 数据库初始化
  21. * @Explanation 向各头部写入关键信息
  22. */
  23. void Database_init(uint16_t pushSize1, uint16_t pullSize1 ,uint16_t pushSize2, uint16_t pullSize2)
  24. {
  25. Flash_ReadBytes(db.LOC_InitInfo,LocDbHeadStart,4);
  26. if(db.LOC_InitInfo[0]==0xffff && db.LOC_InitInfo[2]==0xffff)//未进行写入
  27. {
  28. //*LOC_InitInfo 0:pushIndex 1:pullIndex 2:pushSize 3:pullSize
  29. db.LOC_InitInfo[0] = (uint16_t)0;//初始化入库指针
  30. db.LOC_InitInfo[1] = (uint16_t)0;//初始化出库指针
  31. db.LOC_InitInfo[2] = (uint16_t)pushSize1;
  32. db.LOC_InitInfo[3] = (uint16_t)pullSize1;
  33. Flash_WriteBytes(db.LOC_InitInfo,LocDbHeadStart,4);//4*2B
  34. HAL_Delay(200);
  35. }
  36. else//已写入
  37. {
  38. //TODO
  39. }
  40. Flash_ReadBytes(db.EVE_InitInfo,EveDbHeadStart,4);
  41. if(db.EVE_InitInfo[0]==0xffff && db.EVE_InitInfo[2]==0xffff)//未进行写入
  42. {
  43. //*EVE_InitInfo 0:pushIndex 1:pullIndex 2:pushSize 3:pullSize
  44. db.EVE_InitInfo[0] = (uint16_t)0;
  45. db.EVE_InitInfo[1] = (uint16_t)0;
  46. db.EVE_InitInfo[2] = (uint16_t)pushSize2;
  47. db.EVE_InitInfo[3] = (uint16_t)pullSize2;
  48. Flash_WriteBytes(db.EVE_InitInfo,EveDbHeadStart,4);//4*2B
  49. HAL_Delay(200);
  50. }
  51. else//已写入
  52. {
  53. //TODO
  54. }
  55. }
  56. /*
  57. *
  58. uint16_t pushArr[7]={0x1234,0x4567, 0x1111,0x2222,0x3333,0x4444, 0xAAAA};
  59. Database_Push(pushArr,7);
  60. Database_Pull(pullArr,7);
  61. uint16_t pullArr[7]={0};
  62. */
  63. HAL_StatusTypeDef PushSta;
  64. uint16_t temp_jc[7];//检测相同缓存
  65. uint16_t temp_jc_Eve[7];//检测相同缓存
  66. uint32_t newPushIndex_Loc=0;
  67. uint32_t newPullIndex_Loc=0;
  68. bool Overwrite_pushindex =false;
  69. bool Overwrite_pushindex_Eve =false;
  70. bool repeatFlag = false;
  71. bool repeatFlag_Eve = false;
  72. //***************定位信息入库
  73. void Database_Push_Loc(uint16_t pushArr[], uint16_t len)
  74. {
  75. if(db.LOC_InitInfo[0] == 0) //Loc PushIndex Init
  76. {
  77. PushSta = Flash_WriteBytes(pushArr,LocDbBodyStart,len);//len*2B
  78. if(PushSta == HAL_OK)
  79. {
  80. db.LOC_InitInfo[0] += 1;
  81. Flash_WriteBytes(db.LOC_InitInfo,LocDbHeadStart,1);//1*2B
  82. }
  83. }
  84. //*读取缓存检测
  85. Flash_ReadBytes(temp_jc,LocDbBodyStart+((db.LOC_InitInfo[0]-1)*14),7);//len*2B
  86. //*uint16_t TESTDATA[] = {db.timeStamp[0], db.timeStamp[1], db.WD_u16[0], db.WD_u16[1], db.JD_u16[0], db.JD_u16[1], db.speed[0]};//4B世纪秒+8B经纬度+2B速度
  87. if(db.LOC_InitInfo[0] > 0 && temp_jc[2]== db.WD_u16[0] && temp_jc[3]== db.WD_u16[1] && temp_jc[4]== db.JD_u16[0] && temp_jc[5]== db.JD_u16[1])//做相同检测
  88. {
  89. //*数据一样无需写入操作
  90. }
  91. else
  92. {
  93. if(Overwrite_pushindex)//重头,避免多次写入
  94. {
  95. Overwrite_pushindex = false;
  96. }
  97. else
  98. {
  99. PushSta = Flash_WriteBytes(pushArr,(LocDbBodyStart+(db.LOC_InitInfo[0]*14)),len);//len*2B
  100. if(PushSta == HAL_OK)
  101. {
  102. db.LOC_InitInfo[0] = db.LOC_InitInfo[0]+1;//写入较记录少1,在头开始写入
  103. Flash_WriteBytes(db.LOC_InitInfo,LocDbHeadStart,1);//1*2B
  104. }
  105. }
  106. }
  107. RecordScale();
  108. }
  109. void Database_Pull_Loc(uint16_t pullArr[], uint16_t len)//14B
  110. {
  111. if(db.LOC_InitInfo[1] == 0) //Loc PullIndex Init
  112. {
  113. Flash_ReadBytes(pullArr,LocDbBodyStart,len);//len*2B
  114. db.LOC_InitInfo[1] += 1;
  115. Flash_WriteBytes(&db.LOC_InitInfo[1],LocDbHeadStart+2,1);//1*2B//更新出库指针
  116. }
  117. else
  118. {
  119. if(db.LOC_InitInfo[1] == db.LOC_InitInfo[0])//*判出库刻度是否等于写入刻度
  120. {
  121. Flash_ReadBytes(pullArr,(LocDbBodyStart+(db.LOC_InitInfo[1]*14)),len);//len*2B
  122. repeatFlag = true;
  123. }
  124. else
  125. {
  126. repeatFlag = false;
  127. Flash_ReadBytes(pullArr,(LocDbBodyStart+(db.LOC_InitInfo[1]*14)),len);//len*2B
  128. db.LOC_InitInfo[1]+=1;
  129. Flash_WriteBytes(&db.LOC_InitInfo[1],LocDbHeadStart+2,1);//1*2B//更新出库指针
  130. }
  131. }
  132. RecordScale();
  133. }
  134. //***************状态信息入库
  135. void Database_Push_Eve(uint16_t pushArr[], uint16_t len)
  136. {
  137. if(db.EVE_InitInfo[0] == 0) //Loc PushIndex Init
  138. {
  139. PushSta = Flash_WriteBytes(pushArr,EveDbBodyStart,len);//len*2B
  140. if(PushSta == HAL_OK)
  141. {
  142. db.EVE_InitInfo[0] += 1;
  143. Flash_WriteBytes(db.EVE_InitInfo,EveDbHeadStart,1);//1*2B
  144. }
  145. }
  146. //*读取缓存检测
  147. Flash_ReadBytes(temp_jc_Eve,EveDbBodyStart+((db.EVE_InitInfo[0]-1)*14),14);//len*2B
  148. //*uint16_t TESTDATA[] = {db.timeStamp[0], db.timeStamp[1], db.WD_u16[0], db.WD_u16[1], db.JD_u16[0], db.JD_u16[1], db.speed[0]};//4B世纪秒+8B经纬度+2B速度
  149. if(db.EVE_InitInfo[0] > 0 && temp_jc_Eve[2]== db.WD_u16[0] && temp_jc_Eve[3]== db.WD_u16[1] && temp_jc_Eve[4]== db.JD_u16[0] && temp_jc_Eve[5]== db.JD_u16[1])//做相同检测
  150. {
  151. //*数据一样无需写入操作
  152. }
  153. else
  154. {
  155. if(Overwrite_pushindex_Eve)//重头,避免多次写入
  156. {
  157. Overwrite_pushindex_Eve = false;
  158. }
  159. else
  160. {
  161. PushSta = Flash_WriteBytes(pushArr,(EveDbBodyStart+(db.EVE_InitInfo[0]*28)),len);//len*2B
  162. if(PushSta == HAL_OK)
  163. {
  164. db.EVE_InitInfo[0] = db.EVE_InitInfo[0]+1;//写入较记录少1,在头开始写入
  165. Flash_WriteBytes(db.EVE_InitInfo,EveDbHeadStart,1);//1*2B
  166. }
  167. }
  168. }
  169. RecordScale_Eve();
  170. }
  171. void DataHandle(void)//接收与发送数据处理
  172. {
  173. }
  174. void RecordScale(void)//记录刻度
  175. {
  176. Flash_ReadBytes(db.LOC_InitInfo, LocDbHeadStart, 4); //读取入库刻度
  177. if(db.LOC_InitInfo[0] == db.LOC_InitInfo[2])//入库结束(返回
  178. {
  179. db.LOC_InitInfo[0]=0;
  180. Flash_WriteBytes(db.LOC_InitInfo,LocDbHeadStart,1);//1*2B 更新最新刻度
  181. Overwrite_pushindex=true;
  182. }
  183. else if(db.LOC_InitInfo[1] == db.LOC_InitInfo[3])//出库结束(返回
  184. {
  185. db.LOC_InitInfo[1]=0;
  186. Flash_WriteBytes(&db.LOC_InitInfo[1],LocDbHeadStart+2,1);//1*2B 更新最新刻度
  187. }
  188. }
  189. void RecordScale_Eve(void)//记录刻度
  190. {
  191. Flash_ReadBytes(db.EVE_InitInfo, EveDbHeadStart, 4); //读取入库刻度
  192. if(db.EVE_InitInfo[0] == db.EVE_InitInfo[2])//入库结束(返回
  193. {
  194. db.EVE_InitInfo[0]=0;
  195. Flash_WriteBytes(db.EVE_InitInfo,EveDbHeadStart,1);//1*2B 更新最新刻度
  196. Overwrite_pushindex_Eve=true;
  197. }
  198. }
  199. void testLoc(void)
  200. {
  201. uint16_t TESTDATA[] = {db.timeStamp[0], db.timeStamp[1], db.WD_u16[0], db.WD_u16[1], db.JD_u16[0], db.JD_u16[1], db.speed[0]};//4B世纪秒+8B经纬度+2B速度
  202. Database_Push_Loc(TESTDATA, 7);//14B 写入操作
  203. uint16_t TESTDATApull[7];
  204. Database_Pull_Loc(TESTDATApull, 7);
  205. if(!repeatFlag)
  206. {
  207. printf("出库:%04X%04X%04X%04X%04X%04X%04X\n",TESTDATApull[0],TESTDATApull[1],TESTDATApull[2],TESTDATApull[3],TESTDATApull[4],TESTDATApull[5],TESTDATApull[6]);
  208. }
  209. else
  210. {
  211. printf("与上次相同\r\n");
  212. }
  213. }
  214. void testEve(void)
  215. {
  216. uint16_t TESTDATA[] = {db.timeStamp[0], db.timeStamp[1], db.WD_u16[0], db.WD_u16[1], db.JD_u16[0], db.JD_u16[1], \
  217. db.LockSn[0],db.LockSn[1],db.LockSn[2], db.OperationType[0],db.OperationResults[0], db.perators[0], db.perators[1], db.ElectricityLevel[0]};//4B世纪秒+8B经纬度+2B速度
  218. //Database_Push_Eve(TESTDATA, 14);//28B 写入操作
  219. }