mssql.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "6a6c95ec",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import pymysql as psql\n",
    "import pyodbc"
   ]
  },
  {
   "cell_type": "raw",
   "id": "318a4045-c4fa-4644-8d69-3782f57ee9ba",
   "metadata": {},
   "source": [
    "https://blog.csdn.net/MHapdream/article/details/9076527/"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "22a3b2f4-fc20-4524-b13e-a572963ffe1c",
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.options.display.max_columns=None\n",
    "pd.options.display.max_rows=None"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "ae91ac7f",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "# conn = psql.connect(host=\"CN-SHA-P-MSQS01\",\n",
    "#                     database=\"SEN4XDB\",\n",
    "#                     user=\"SENSIRION-ZH\\osun\",\n",
    "                    \n",
    "#                    )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "68054a7b-c705-441f-96ed-0162516711b4",
   "metadata": {},
   "outputs": [],
   "source": [
    "import sys"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "98c0e2de-e754-4a0e-8f91-639c6ffb50ae",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'C:\\\\work\\\\virtenvs\\\\3p8_64bit_SensiPython_4p0\\\\Scripts\\\\python.exe'"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sys.executable"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "9657bf17-74bb-483f-b65f-b2bdf3c3b871",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['C:\\\\python\\\\function\\\\SQL',\n",
       " 'C:\\\\Users\\\\osun\\\\Desktop\\\\Python\\\\Function\\\\testfile',\n",
       " 'C:\\\\work\\\\virtenvs\\\\3p8_64bit_SensiPython_4p0\\\\Scripts\\\\python38.zip',\n",
       " 'C:\\\\Program Files\\\\WinPython38_64bit\\\\python-3.8.6.amd64\\\\DLLs',\n",
       " 'C:\\\\Program Files\\\\WinPython38_64bit\\\\python-3.8.6.amd64\\\\lib',\n",
       " 'C:\\\\Program Files\\\\WinPython38_64bit\\\\python-3.8.6.amd64',\n",
       " 'C:\\\\work\\\\virtenvs\\\\3p8_64bit_SensiPython_4p0',\n",
       " '',\n",
       " 'C:\\\\work\\\\virtenvs\\\\3p8_64bit_SensiPython_4p0\\\\lib\\\\site-packages',\n",
       " 'c:\\\\users\\\\osun\\\\gitlab\\\\python-pm-calib-golden-samples',\n",
       " 'C:\\\\work\\\\virtenvs\\\\3p8_64bit_SensiPython_4p0\\\\lib\\\\site-packages\\\\pylatus',\n",
       " 'C:\\\\work\\\\virtenvs\\\\3p8_64bit_SensiPython_4p0\\\\lib\\\\site-packages\\\\win32',\n",
       " 'C:\\\\work\\\\virtenvs\\\\3p8_64bit_SensiPython_4p0\\\\lib\\\\site-packages\\\\win32\\\\lib',\n",
       " 'C:\\\\work\\\\virtenvs\\\\3p8_64bit_SensiPython_4p0\\\\lib\\\\site-packages\\\\Pythonwin',\n",
       " 'C:\\\\work\\\\virtenvs\\\\3p8_64bit_SensiPython_4p0\\\\lib\\\\site-packages\\\\IPython\\\\extensions',\n",
       " 'C:\\\\Users\\\\osun\\\\.ipython']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sys.path"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "dbb72318-12d4-4a1f-a854-f959f108acb1",
   "metadata": {},
   "outputs": [],
   "source": [
    "server = 'CN-SHA-D-MSQL01'\n",
    "database = 'SEN5XDB'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "966fbd98-599e-4222-84c4-385710b65a3b",
   "metadata": {},
   "outputs": [],
   "source": [
    "conn = pyodbc.connect(\"DRIVER={{SQL Server}};SERVER={Server};DATABASE={DB};Trusted_Connection=yes, autocommit=True\".format(Server=server, DB=database))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "0b2e40a4-de05-44d8-a53c-2718c10392e5",
   "metadata": {},
   "outputs": [],
   "source": [
    "# cur = conn.cursor()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "4e8ad8c8-8eb0-4e99-b791-da82c90f7ac0",
   "metadata": {},
   "outputs": [],
   "source": [
    "# cur.execute(\"show tables\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "106ad6cc-13ea-44c5-892b-734766e1cfa6",
   "metadata": {},
   "outputs": [],
   "source": [
    "# query=\"select top 10 * from MC03.t_MeasureData\"\n",
    "\n",
    "# query=\"select name from sysobjects where xtype='U'\"   #获取当前数据库中所有表名\n",
    "\n",
    "query=\"select name from syscolumns where id=object_id('MS01.t_Limits')\"   #获取表中的所有字段\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "2581c34f-bd5e-4378-af3f-749ebf03ce1c",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n"
     ]
    }
   ],
   "source": [
    "tabs = pd.read_sql(query,con=conn)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "bee9bfc4-c29c-4c78-90a8-c9ef4393d3dc",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>t_SubstrateSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>t_SubstrateSession_LogFile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>t_MeasureDataCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>t_SubstrateSession_Facility</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>t_Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>t_ApplicationSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>t_SubstrateSession_Configuration</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>t_Site</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>t_SubstrateSession_LogFile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>t_SubstrateSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>t_MS02Module</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>t_SubstrateSession_Facility</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>t_Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>t_EnvironmentSetPoint</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>t_SubstrateSession_Configuration</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>t_Site</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>t_Limits</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>t_MC04Module</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>t_SubstrateSession_LogFile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>t_LimitsCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>t_MeasureData_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>t_SubstrateSession_Facility</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>t_Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>t_EnvironmentSetPoint</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>t_MeasureData</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>t_Limits</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>t_Site</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>t_LimitsCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>t_MC02Module</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>t_MeasureData_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>t_SensiDBInformation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>t_VersionInformation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>t_MeasureDataCommon_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>t_ChangeHistory</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>t_EnvironmentSetPoint</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>t_Module</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>t_MeasureData</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>t_MeasureDataCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>t_Limits</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>t_Tray</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>t_LimitsCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>t_Configuration</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>t_MeasureData_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>t_LogFile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>t_ApplicationSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>t_MeasureDataCommon_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>t_Facility</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>t_SubstrateSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>t_FileVersion</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>t_MeasureDataCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>t_MeasureData</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>t_FacilityType</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>t_ProcessRecipe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>t_ApplicationSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>t_MeasureDataCommon_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>t_ProcessRecipe_Configuration</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>t_SubstrateSession_Configuration</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>t_SubstrateSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>t_ProcessRecipe_Admin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>t_SubstrateSession_LogFile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>t_MeasureDataCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>t_Application</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>t_SubstrateSession_Facility</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>t_BinQuality</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>t_ApplicationSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>t_Material</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>t_Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>t_SubstrateSession_Configuration</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>t_ProductGroup</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>t_Site</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>t_SubstrateSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>t_ResultStatus</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>t_SubstrateSession_LogFile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>t_MQ01Module</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>t_SubstrateGrade</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>t_SubstrateSession_Facility</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>t_TestSpec</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>t_Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>t_ApplicationSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>t_EnvironmentSetPoint</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>t_SubstrateSession_Configuration</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>t_Site</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>t_Limits</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>t_MS01Module</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>t_SubstrateSession_LogFile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>t_SubstrateSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>t_LimitsCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>t_MeasureData_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>t_SubstrateSession_Facility</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>t_Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>t_EnvironmentSetPoint</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>t_SubstrateSession_Configuration</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>t_MeasureData</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>t_Limits</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>t_Site</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>t_LimitsCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>t_MC03Module</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>t_SubstrateSession_LogFile</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>t_MeasureData_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>t_SubstrateSession_Facility</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>t_MeasureDataCommon_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>t_Contact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>t_EnvironmentSetPoint</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>t_MeasureData</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>t_MeasureDataCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>t_Limits</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>t_Site</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>t_LimitsCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>t_MC01Module</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>t_MeasureData_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>t_MeasureDataCommon_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>t_EnvironmentSetPoint</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>t_MeasureDataCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>t_MeasureData</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>t_Limits</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>t_LimitsCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>t_ApplicationSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>t_MeasureData_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>t_MeasureDataCommon_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>t_SubstrateSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>t_MeasureDataCommon</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>t_MeasureData</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>t_ApplicationSession</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>t_MeasureDataCommon_Archive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>t_SubstrateSession_Configuration</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 name\n",
       "0                  t_SubstrateSession\n",
       "1          t_SubstrateSession_LogFile\n",
       "2                 t_MeasureDataCommon\n",
       "3         t_SubstrateSession_Facility\n",
       "4                           t_Contact\n",
       "5                t_ApplicationSession\n",
       "6    t_SubstrateSession_Configuration\n",
       "7                              t_Site\n",
       "8          t_SubstrateSession_LogFile\n",
       "9                  t_SubstrateSession\n",
       "10                       t_MS02Module\n",
       "11        t_SubstrateSession_Facility\n",
       "12                          t_Contact\n",
       "13              t_EnvironmentSetPoint\n",
       "14   t_SubstrateSession_Configuration\n",
       "15                             t_Site\n",
       "16                           t_Limits\n",
       "17                       t_MC04Module\n",
       "18         t_SubstrateSession_LogFile\n",
       "19                     t_LimitsCommon\n",
       "20              t_MeasureData_Archive\n",
       "21        t_SubstrateSession_Facility\n",
       "22                          t_Contact\n",
       "23              t_EnvironmentSetPoint\n",
       "24                      t_MeasureData\n",
       "25                           t_Limits\n",
       "26                             t_Site\n",
       "27                     t_LimitsCommon\n",
       "28                       t_MC02Module\n",
       "29              t_MeasureData_Archive\n",
       "30               t_SensiDBInformation\n",
       "31               t_VersionInformation\n",
       "32        t_MeasureDataCommon_Archive\n",
       "33                    t_ChangeHistory\n",
       "34              t_EnvironmentSetPoint\n",
       "35                           t_Module\n",
       "36                      t_MeasureData\n",
       "37                t_MeasureDataCommon\n",
       "38                           t_Limits\n",
       "39                             t_Tray\n",
       "40                     t_LimitsCommon\n",
       "41                    t_Configuration\n",
       "42              t_MeasureData_Archive\n",
       "43                          t_LogFile\n",
       "44               t_ApplicationSession\n",
       "45        t_MeasureDataCommon_Archive\n",
       "46                         t_Facility\n",
       "47                 t_SubstrateSession\n",
       "48                      t_FileVersion\n",
       "49                t_MeasureDataCommon\n",
       "50                      t_MeasureData\n",
       "51                     t_FacilityType\n",
       "52                    t_ProcessRecipe\n",
       "53               t_ApplicationSession\n",
       "54        t_MeasureDataCommon_Archive\n",
       "55      t_ProcessRecipe_Configuration\n",
       "56   t_SubstrateSession_Configuration\n",
       "57                 t_SubstrateSession\n",
       "58              t_ProcessRecipe_Admin\n",
       "59         t_SubstrateSession_LogFile\n",
       "60                t_MeasureDataCommon\n",
       "61                      t_Application\n",
       "62        t_SubstrateSession_Facility\n",
       "63                       t_BinQuality\n",
       "64               t_ApplicationSession\n",
       "65                         t_Material\n",
       "66                          t_Contact\n",
       "67   t_SubstrateSession_Configuration\n",
       "68                     t_ProductGroup\n",
       "69                             t_Site\n",
       "70                 t_SubstrateSession\n",
       "71                     t_ResultStatus\n",
       "72         t_SubstrateSession_LogFile\n",
       "73                       t_MQ01Module\n",
       "74                   t_SubstrateGrade\n",
       "75        t_SubstrateSession_Facility\n",
       "76                         t_TestSpec\n",
       "77                          t_Contact\n",
       "78               t_ApplicationSession\n",
       "79              t_EnvironmentSetPoint\n",
       "80   t_SubstrateSession_Configuration\n",
       "81                             t_Site\n",
       "82                           t_Limits\n",
       "83                       t_MS01Module\n",
       "84         t_SubstrateSession_LogFile\n",
       "85                 t_SubstrateSession\n",
       "86                     t_LimitsCommon\n",
       "87              t_MeasureData_Archive\n",
       "88        t_SubstrateSession_Facility\n",
       "89                          t_Contact\n",
       "90              t_EnvironmentSetPoint\n",
       "91   t_SubstrateSession_Configuration\n",
       "92                      t_MeasureData\n",
       "93                           t_Limits\n",
       "94                             t_Site\n",
       "95                     t_LimitsCommon\n",
       "96                       t_MC03Module\n",
       "97         t_SubstrateSession_LogFile\n",
       "98              t_MeasureData_Archive\n",
       "99        t_SubstrateSession_Facility\n",
       "100       t_MeasureDataCommon_Archive\n",
       "101                         t_Contact\n",
       "102             t_EnvironmentSetPoint\n",
       "103                     t_MeasureData\n",
       "104               t_MeasureDataCommon\n",
       "105                          t_Limits\n",
       "106                            t_Site\n",
       "107                    t_LimitsCommon\n",
       "108                      t_MC01Module\n",
       "109             t_MeasureData_Archive\n",
       "110       t_MeasureDataCommon_Archive\n",
       "111             t_EnvironmentSetPoint\n",
       "112               t_MeasureDataCommon\n",
       "113                     t_MeasureData\n",
       "114                          t_Limits\n",
       "115                    t_LimitsCommon\n",
       "116              t_ApplicationSession\n",
       "117             t_MeasureData_Archive\n",
       "118       t_MeasureDataCommon_Archive\n",
       "119                t_SubstrateSession\n",
       "120               t_MeasureDataCommon\n",
       "121                     t_MeasureData\n",
       "122              t_ApplicationSession\n",
       "123       t_MeasureDataCommon_Archive\n",
       "124  t_SubstrateSession_Configuration"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tabs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "29d1e228-2fc2-4784-bdd5-83ce77e77dfd",
   "metadata": {},
   "outputs": [],
   "source": [
    "tabs['lg'] = tabs['name'].map(lambda x: len(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "e668df9a-f836-421b-a693-e59ad8b18630",
   "metadata": {},
   "outputs": [],
   "source": [
    "# tabs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "753327f0-a994-4757-a6cc-1a69002770b0",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    },
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "t_Limits\n",
      "**************************************************\n",
      "t_LimitsCommon\n",
      "**************************************************\n",
      "t_ApplicationSession\n",
      "**************************************************\n",
      "t_MeasureData_Archive\n",
      "**************************************************\n",
      "t_MeasureDataCommon_Archive\n",
      "**************************************************\n",
      "t_SubstrateSession\n",
      "**************************************************\n",
      "t_MeasureDataCommon\n",
      "**************************************************\n",
      "t_MeasureData\n",
      "**************************************************\n",
      "t_ApplicationSession\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "**************************************************\n",
      "t_MeasureDataCommon_Archive\n",
      "**************************************************\n",
      "t_SubstrateSession_Configuration\n",
      "**************************************************\n",
      "t_SubstrateSession\n",
      "**************************************************\n",
      "t_SubstrateSession_LogFile\n",
      "**************************************************\n",
      "t_MeasureDataCommon\n",
      "**************************************************\n",
      "t_SubstrateSession_Facility\n",
      "**************************************************\n",
      "t_Contact\n",
      "**************************************************\n",
      "t_ApplicationSession\n",
      "**************************************************\n",
      "t_SubstrateSession_Configuration\n",
      "**************************************************\n",
      "t_Site\n",
      "**************************************************\n",
      "t_SubstrateSession_LogFile\n",
      "**************************************************\n",
      "t_SubstrateSession\n",
      "**************************************************\n",
      "t_MS02Module\n",
      "**************************************************\n",
      "t_SubstrateSession_Facility\n",
      "**************************************************\n",
      "t_Contact\n",
      "**************************************************\n",
      "t_EnvironmentSetPoint\n",
      "**************************************************\n",
      "t_SubstrateSession_Configuration\n",
      "**************************************************\n",
      "t_Site\n",
      "**************************************************\n",
      "t_Limits\n",
      "**************************************************\n",
      "t_MC04Module\n",
      "**************************************************\n",
      "t_SubstrateSession_LogFile\n",
      "**************************************************"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "t_LimitsCommon\n",
      "**************************************************\n",
      "t_MeasureData_Archive\n",
      "**************************************************\n",
      "t_SubstrateSession_Facility\n",
      "**************************************************\n",
      "t_Contact\n",
      "**************************************************\n",
      "t_EnvironmentSetPoint\n",
      "**************************************************\n",
      "t_MeasureData\n",
      "**************************************************\n",
      "t_Limits\n",
      "**************************************************\n",
      "t_Site\n",
      "**************************************************\n",
      "t_LimitsCommon\n",
      "**************************************************"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "t_MC02Module\n",
      "**************************************************\n",
      "t_MeasureData_Archive\n",
      "**************************************************\n",
      "t_SensiDBInformation\n",
      "**************************************************\n",
      "t_VersionInformation\n",
      "**************************************************\n",
      "t_MeasureDataCommon_Archive\n",
      "**************************************************\n",
      "t_ChangeHistory\n",
      "**************************************************\n",
      "t_EnvironmentSetPoint\n",
      "**************************************************\n",
      "t_Module\n",
      "**************************************************\n",
      "t_MeasureData\n",
      "**************************************************\n",
      "t_MeasureDataCommon\n",
      "**************************************************\n",
      "t_Limits\n",
      "**************************************************\n",
      "t_Tray\n",
      "**************************************************\n",
      "t_LimitsCommon\n",
      "**************************************************\n",
      "t_Configuration\n",
      "**************************************************\n",
      "t_MeasureData_Archive\n",
      "**************************************************"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "t_LogFile\n",
      "**************************************************\n",
      "t_ApplicationSession\n",
      "**************************************************\n",
      "t_MeasureDataCommon_Archive\n",
      "**************************************************\n",
      "t_Facility\n",
      "**************************************************\n",
      "t_SubstrateSession\n",
      "**************************************************\n",
      "t_FileVersion\n",
      "**************************************************\n",
      "t_MeasureDataCommon\n",
      "**************************************************\n",
      "t_MeasureData\n",
      "**************************************************\n",
      "t_FacilityType\n",
      "**************************************************\n",
      "t_ProcessRecipe\n",
      "**************************************************\n",
      "t_ApplicationSession\n",
      "**************************************************\n",
      "t_MeasureDataCommon_Archive\n",
      "**************************************************\n",
      "t_ProcessRecipe_Configuration\n",
      "**************************************************\n",
      "t_SubstrateSession_Configuration\n",
      "**************************************************\n",
      "t_SubstrateSession\n",
      "**************************************************\n",
      "t_ProcessRecipe_Admin\n",
      "**************************************************\n",
      "t_SubstrateSession_LogFile\n",
      "**************************************************\n",
      "t_MeasureDataCommon\n",
      "**************************************************\n",
      "t_Application\n",
      "**************************************************\n",
      "t_SubstrateSession_Facility\n",
      "**************************************************"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "t_BinQuality\n",
      "**************************************************\n",
      "t_ApplicationSession\n",
      "**************************************************\n",
      "t_Material\n",
      "**************************************************\n",
      "t_Contact\n",
      "**************************************************\n",
      "t_SubstrateSession_Configuration\n",
      "**************************************************\n",
      "t_ProductGroup\n",
      "**************************************************\n",
      "t_Site\n",
      "**************************************************\n",
      "t_SubstrateSession\n",
      "**************************************************\n",
      "t_ResultStatus\n",
      "**************************************************\n",
      "t_SubstrateSession_LogFile\n",
      "**************************************************\n",
      "t_MQ01Module\n",
      "**************************************************\n",
      "t_SubstrateGrade\n",
      "**************************************************\n",
      "t_SubstrateSession_Facility\n",
      "**************************************************\n",
      "t_TestSpec\n",
      "**************************************************\n",
      "t_Contact\n",
      "**************************************************\n",
      "t_ApplicationSession\n",
      "**************************************************\n",
      "t_EnvironmentSetPoint\n",
      "**************************************************\n",
      "t_SubstrateSession_Configuration\n",
      "**************************************************\n",
      "t_Site\n",
      "**************************************************"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "t_Limits\n",
      "**************************************************\n",
      "t_MS01Module\n",
      "**************************************************\n",
      "t_SubstrateSession_LogFile\n",
      "**************************************************\n",
      "t_SubstrateSession\n",
      "**************************************************\n",
      "t_LimitsCommon\n",
      "**************************************************\n",
      "t_MeasureData_Archive\n",
      "**************************************************\n",
      "t_SubstrateSession_Facility\n",
      "**************************************************\n",
      "t_Contact\n",
      "**************************************************\n",
      "t_EnvironmentSetPoint\n",
      "**************************************************\n",
      "t_SubstrateSession_Configuration\n",
      "**************************************************\n",
      "t_MeasureData\n",
      "**************************************************\n",
      "t_Limits\n",
      "**************************************************\n",
      "t_Site\n",
      "**************************************************\n",
      "t_LimitsCommon\n",
      "**************************************************\n",
      "t_MC03Module\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "**************************************************\n",
      "t_SubstrateSession_LogFile\n",
      "**************************************************\n",
      "t_MeasureData_Archive\n",
      "**************************************************\n",
      "t_SubstrateSession_Facility\n",
      "**************************************************\n",
      "t_MeasureDataCommon_Archive\n",
      "**************************************************\n",
      "t_Contact\n",
      "**************************************************\n",
      "t_EnvironmentSetPoint\n",
      "**************************************************\n",
      "t_MeasureData\n",
      "**************************************************\n",
      "t_MeasureDataCommon\n",
      "**************************************************\n",
      "t_Limits\n",
      "**************************************************\n",
      "t_Site\n",
      "**************************************************\n",
      "t_LimitsCommon\n",
      "**************************************************\n",
      "t_MC01Module\n",
      "**************************************************\n",
      "t_MeasureData_Archive\n",
      "**************************************************\n",
      "t_MeasureDataCommon_Archive\n",
      "**************************************************\n",
      "t_EnvironmentSetPoint\n",
      "**************************************************\n",
      "t_MeasureDataCommon\n",
      "**************************************************\n",
      "t_MeasureData\n",
      "**************************************************\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n",
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n"
     ]
    }
   ],
   "source": [
    "for tab in tabs['name'].tolist():\n",
    "    print(tab)\n",
    "    query=\"select name from syscolumns where id=object_id('MC03.{}')\".format(tab)\n",
    "    dt = pd.read_sql(query,con=conn)\n",
    "    dt = dt.T\n",
    "    dt.to_csv(\"tab_{}_columns.csv\".format(tab))\n",
    "    print(\"*\"*50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "c1fb6576-b5b8-435d-8fde-0c7eca3a823d",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\work\\virtenvs\\3p8_64bit_SensiPython_4p0\\lib\\site-packages\\pandas\\io\\sql.py:761: UserWarning: pandas only support SQLAlchemy connectable(engine/connection) ordatabase string URI or sqlite3 DBAPI2 connectionother DBAPI2 objects are not tested, please consider using SQLAlchemy\n",
      "  warnings.warn(\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LimitsId</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>MD5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>T004002_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>T004002_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>T007001_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>T007001_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>T027001_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>T027001_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>T031001_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>T031001_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>T031002_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>T031002_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>T031003_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>T031003_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>T031004_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>T031004_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>T031005_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>T031005_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>T031006_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>T031006_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>T031010_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>T031010_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>T031011_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>T031011_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>T032001_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>T032001_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>T032002_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>T032002_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>T099001_Product_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>T099001_Product_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>T099002_Product_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>T099002_Product_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>T099004_Product_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>T099004_Product_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>T099005_Product_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>T099005_Product_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>T099007_Product_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>T099007_Product_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>T099008_Product_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>T099008_Product_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>T099009_Product_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>T099009_Product_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>T15_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>T15_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>T900002_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>T900002_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>T900003_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>T900003_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>T910002_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>T910002_UTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>T920001_LTL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>T920001_UTL</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   name\n",
       "0              LimitsId\n",
       "1                   MD5\n",
       "2           T004002_LTL\n",
       "3           T004002_UTL\n",
       "4           T007001_LTL\n",
       "5           T007001_UTL\n",
       "6           T027001_LTL\n",
       "7           T027001_UTL\n",
       "8           T031001_LTL\n",
       "9           T031001_UTL\n",
       "10          T031002_LTL\n",
       "11          T031002_UTL\n",
       "12          T031003_LTL\n",
       "13          T031003_UTL\n",
       "14          T031004_LTL\n",
       "15          T031004_UTL\n",
       "16          T031005_LTL\n",
       "17          T031005_UTL\n",
       "18          T031006_LTL\n",
       "19          T031006_UTL\n",
       "20          T031010_LTL\n",
       "21          T031010_UTL\n",
       "22          T031011_LTL\n",
       "23          T031011_UTL\n",
       "24          T032001_LTL\n",
       "25          T032001_UTL\n",
       "26          T032002_LTL\n",
       "27          T032002_UTL\n",
       "28  T099001_Product_LTL\n",
       "29  T099001_Product_UTL\n",
       "30  T099002_Product_LTL\n",
       "31  T099002_Product_UTL\n",
       "32  T099004_Product_LTL\n",
       "33  T099004_Product_UTL\n",
       "34  T099005_Product_LTL\n",
       "35  T099005_Product_UTL\n",
       "36  T099007_Product_LTL\n",
       "37  T099007_Product_UTL\n",
       "38  T099008_Product_LTL\n",
       "39  T099008_Product_UTL\n",
       "40  T099009_Product_LTL\n",
       "41  T099009_Product_UTL\n",
       "42              T15_LTL\n",
       "43              T15_UTL\n",
       "44          T900002_LTL\n",
       "45          T900002_UTL\n",
       "46          T900003_LTL\n",
       "47          T900003_UTL\n",
       "48          T910002_LTL\n",
       "49          T910002_UTL\n",
       "50          T920001_LTL\n",
       "51          T920001_UTL"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_sql(query,con=conn).sort_values(\"name\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "d20c7fc9-a4b3-4b33-b035-e375a3c0a1b3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'0x75'"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hex(117)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4ad53634-7809-4346-be91-4af70eecac05",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 38",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}