Home Explore Help
Register Sign In
lmstack
/
data_analyze_platform
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: 945d1a9614
Branches Tags
data_analyze...
/
函数说明
/
DBManager.html

DBManager.html 6.2 KB
History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111 
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
    2. 

  2. <html><head><title>Python: module DBManager</title>
    3. 

  3. <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    4. 

  4. </head><body bgcolor="#f0f0f8">
    5. 

  5. 

  6. <table width="100%" cellspacing=0 cellpadding=2 border=0 summary="heading">
    7. 

  7. <tr bgcolor="#7799ee">
    8. 

  8. <td valign=bottom>&nbsp;<br>
    9. 

  9. <font color="#ffffff" face="helvetica, arial">&nbsp;<br><big><big><strong>DBManager</strong></big></big></font></td
    10. 

  10. ><td align=right valign=bottom
    11. 

  11. ><font color="#ffffff" face="helvetica, arial"><a href=".">index</a><br><a href="file:f%3A%5Cwork%5Cqx%5Cdata_analyze_platform%5Clib%5Cbackend%5Cdbmanager.py">f:\work\qx\data_analyze_platform\lib\backend\dbmanager.py</a></font></td></tr></table>
    12. 

  12.     <p><tt>暂时采用http方式获取历史数据。<br>
    13. 

  13. &nbsp;<br>
    14. 

  14. 预留：后期若改用通过访问数据库的形式进行数据的获取，则本文件负责数据库的连接，sql指令的执行，数据获取等功能。</tt></p>
    15. 

  15. <p>
    16. 

  16. <table width="100%" cellspacing=0 cellpadding=2 border=0 summary="section">
    17. 

  17. <tr bgcolor="#aa55cc">
    18. 

  18. <td colspan=3 valign=bottom>&nbsp;<br>
    19. 

  19. <font color="#ffffff" face="helvetica, arial"><big><strong>Modules</strong></big></font></td></tr>
    20. 

  20.     
    21. 

  21. <tr><td bgcolor="#aa55cc"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</tt></td><td>&nbsp;</td>
    22. 

  22. <td width="100%"><table width="100%" summary="list"><tr><td width="25%" valign=top><a href="datetime.html">datetime</a><br>
    23. 

  23. <a href="json.html">json</a><br>
    24. 

  24. <a href="numpy.html">numpy</a><br>
    25. 

  25. </td><td width="25%" valign=top><a href="os.html">os</a><br>
    26. 

  26. <a href="pandas.html">pandas</a><br>
    27. 

  27. <a href="pdb.html">pdb</a><br>
    28. 

  28. </td><td width="25%" valign=top><a href="requests.html">requests</a><br>
    29. 

  29. <a href="time.html">time</a><br>
    30. 

  30. <a href="urllib.html">urllib</a><br>
    31. 

  31. </td><td width="25%" valign=top></td></tr></table></td></tr></table><p>
    32. 

  32. <table width="100%" cellspacing=0 cellpadding=2 border=0 summary="section">
    33. 

  33. <tr bgcolor="#ee77aa">
    34. 

  34. <td colspan=3 valign=bottom>&nbsp;<br>
    35. 

  35. <font color="#ffffff" face="helvetica, arial"><big><strong>Classes</strong></big></font></td></tr>
    36. 

  36.     
    37. 

  37. <tr><td bgcolor="#ee77aa"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</tt></td><td>&nbsp;</td>
    38. 

  38. <td width="100%"><dl>
    39. 

  39. <dt><font face="helvetica, arial"><a href="builtins.html#object">builtins.object</a>
    40. 

  40. </font></dt><dd>
    41. 

  41. <dl>
    42. 

  42. <dt><font face="helvetica, arial"><a href="DBManager.html#DBManager">DBManager</a>
    43. 

  43. </font></dt></dl>
    44. 

  44. </dd>
    45. 

  45. </dl>
    46. 

  46.  <p>
    47. 

  47. <table width="100%" cellspacing=0 cellpadding=2 border=0 summary="section">
    48. 

  48. <tr bgcolor="#ffc8d8">
    49. 

  49. <td colspan=3 valign=bottom>&nbsp;<br>
    50. 

  50. <font color="#000000" face="helvetica, arial"><a name="DBManager">class <strong>DBManager</strong></a>(<a href="builtins.html#object">builtins.object</a>)</font></td></tr>
    51. 

  51.     
    52. 

  52. <tr bgcolor="#ffc8d8"><td rowspan=2><tt>&nbsp;&nbsp;&nbsp;</tt></td>
    53. 

  53. <td colspan=2><tt><a href="#DBManager">DBManager</a>(host='',&nbsp;port='',&nbsp;auth='',&nbsp;db='',&nbsp;username='',&nbsp;password='')<br>
    54. 

  54. &nbsp;<br>
    55. 

  55. #&nbsp;import&nbsp;http.client<br>
    56. 

  56. #&nbsp;http.client.HTTPConnection._http_vsn&nbsp;=&nbsp;10<br>
    57. 

  57. #&nbsp;http.client.HTTPConnection._http_vsn_str&nbsp;=&nbsp;'HTTP/1.1'<br>&nbsp;</tt></td></tr>
    58. 

  58. <tr><td>&nbsp;</td>
    59. 

  59. <td width="100%">Methods defined here:<br>
    60. 

  60. <dl><dt><a name="DBManager-__enter__"><strong>__enter__</strong></a>(self)</dt></dl>
    61. 

  61. 

  62. <dl><dt><a name="DBManager-__exit__"><strong>__exit__</strong></a>(self)</dt></dl>
    63. 

  63. 

  64. <dl><dt><a name="DBManager-__init__"><strong>__init__</strong></a>(self, host='', port='', auth='', db='', username='', password='')</dt><dd><tt>Initialize&nbsp;self.&nbsp;&nbsp;See&nbsp;help(type(self))&nbsp;for&nbsp;accurate&nbsp;signature.</tt></dd></dl>
    65. 

  65. 

  66. <dl><dt><a name="DBManager-close"><strong>close</strong></a>(self)</dt></dl>
    67. 

  67. 

  68. <dl><dt><a name="DBManager-connect"><strong>connect</strong></a>(self)</dt></dl>
    69. 

  69. 

  70. <dl><dt><a name="DBManager-get_data"><strong>get_data</strong></a>(self, url='http://172.16.126.13/store/load?dataType={}&amp;limit=0&amp;sn={}', sn='', start_time='', end_time='', data_groups=['bms', 'gps'])</dt><dd><tt>获取指定&nbsp;sn&nbsp;和起止日期的bms和gps数据.<br>
    71. 

  71. 添加了重试机制。<br>
    72. 

  72. &nbsp;<br>
    73. 

  73. --------------输入参数------------<br>
    74. 

  74. url：数据获取url，&nbsp;可采用默认值<br>
    75. 

  75. sn:&nbsp;str,&nbsp;电池sn号<br>
    76. 

  76. start_time:&nbsp;str,&nbsp;开始时间<br>
    77. 

  77. end_time:&nbsp;str,&nbsp;结束时间<br>
    78. 

  78. data_groups:&nbsp;&nbsp;选择需要获取的数据组，可填入多个字符串（默认只获取bms和gps数据）<br>
    79. 

  79. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;bms:&nbsp;bms数据<br>
    80. 

  80. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;gps：gps数据<br>
    81. 

  81. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;system：system数据<br>
    82. 

  82. &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;accum：accum数据<br>
    83. 

  83. &nbsp;<br>
    84. 

  84. &nbsp;<br>
    85. 

  85. --------------输出参数------------<br>
    86. 

  86. df_data:&nbsp;{'bms':dataframe,&nbsp;'gps':dataframe,&nbsp;'system':dataframe,&nbsp;;accum':dataframe}</tt></dd></dl>
    87. 

  87. 

  88. <hr>
    89. 

  89. Data descriptors defined here:<br>
    90. 

  90. <dl><dt><strong>__dict__</strong></dt>
    91. 

  91. <dd><tt>dictionary&nbsp;for&nbsp;instance&nbsp;variables&nbsp;(if&nbsp;defined)</tt></dd>
    92. 

  92. </dl>
    93. 

  93. <dl><dt><strong>__weakref__</strong></dt>
    94. 

  94. <dd><tt>list&nbsp;of&nbsp;weak&nbsp;references&nbsp;to&nbsp;the&nbsp;object&nbsp;(if&nbsp;defined)</tt></dd>
    95. 

  95. </dl>
    96. 

  96. </td></tr></table></td></tr></table><p>
    97. 

  97. <table width="100%" cellspacing=0 cellpadding=2 border=0 summary="section">
    98. 

  98. <tr bgcolor="#55aa55">
    99. 

  99. <td colspan=3 valign=bottom>&nbsp;<br>
    100. 

  100. <font color="#ffffff" face="helvetica, arial"><big><strong>Data</strong></big></font></td></tr>
    101. 

  101.     
    102. 

  102. <tr><td bgcolor="#55aa55"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</tt></td><td>&nbsp;</td>
    103. 

  103. <td width="100%"><strong>S</strong> = &lt;RegexFlag.DOTALL: 16&gt;</td></tr></table><p>
    104. 

  104. <table width="100%" cellspacing=0 cellpadding=2 border=0 summary="section">
    105. 

  105. <tr bgcolor="#7799ee">
    106. 

  106. <td colspan=3 valign=bottom>&nbsp;<br>
    107. 

  107. <font color="#ffffff" face="helvetica, arial"><big><strong>Author</strong></big></font></td></tr>
    108. 

  108.     
    109. 

  109. <tr><td bgcolor="#7799ee"><tt>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</tt></td><td>&nbsp;</td>
    110. 

  110. <td width="100%">wlm</td></tr></table>
    111. 

  111. </body></html>
    112.