topic cx_Oracle and python to move table data to numpy array in Python Questions https://community.esri.com/t5/python-questions/cx-oracle-and-python-to-move-table-data-to-numpy/m-p/448150#M35151 <HTML><HEAD></HEAD><BODY><P>Hi everyone <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I've got a question regarding moving some table data from an Oracle DB to a numpy arrays. I've looked into the possibility of using cx_Oracle to access my Oracle DB and read data (tested, works) and now I'd like to make numpy arrays out of the data to work with the table data locally. The thing is, I don't know the table/field structure of the source data before I begin, so I can't really hardcode the numpy.dptyp() field types up front. Do anyone know if there is a way of getting this from the Oracle DB using cx_Oracle so I can build the numpy.dptyp() for each table? </P><P></P><P>Alternatively, of course, is there a better way of achieving this that I haven't thought of? (Let's assume I don't have access to arcpy and Oracle connections there...)</P></BODY></HTML> Thu, 07 May 2015 14:53:14 GMT HåvardMoe 2015-05-07T14:53:14Z cx_Oracle and python to move table data to numpy array https://community.esri.com/t5/python-questions/cx-oracle-and-python-to-move-table-data-to-numpy/m-p/448150#M35151 <HTML><HEAD></HEAD><BODY><P>Hi everyone <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I've got a question regarding moving some table data from an Oracle DB to a numpy arrays. I've looked into the possibility of using cx_Oracle to access my Oracle DB and read data (tested, works) and now I'd like to make numpy arrays out of the data to work with the table data locally. The thing is, I don't know the table/field structure of the source data before I begin, so I can't really hardcode the numpy.dptyp() field types up front. Do anyone know if there is a way of getting this from the Oracle DB using cx_Oracle so I can build the numpy.dptyp() for each table? </P><P></P><P>Alternatively, of course, is there a better way of achieving this that I haven't thought of? (Let's assume I don't have access to arcpy and Oracle connections there...)</P></BODY></HTML> Thu, 07 May 2015 14:53:14 GMT https://community.esri.com/t5/python-questions/cx-oracle-and-python-to-move-table-data-to-numpy/m-p/448150#M35151 HåvardMoe 2015-05-07T14:53:14Z Re: cx_Oracle and python to move table data to numpy array https://community.esri.com/t5/python-questions/cx-oracle-and-python-to-move-table-data-to-numpy/m-p/448151#M35152 <HTML><HEAD></HEAD><BODY><P><A href="http://cx-oracle.readthedocs.org/en/latest/cursor.html#Cursor.description">Cursor.description</A> will provide you the information you need, but you will have to create a mapping between cx_Oracle types and NumPy types.&nbsp; It might also be worth checking out <A href="https://github.com/esheldon/espy/blob/master/oracle_util.py">oracle_util.py </A>on GitHub.</P></BODY></HTML> Fri, 08 May 2015 00:16:38 GMT https://community.esri.com/t5/python-questions/cx-oracle-and-python-to-move-table-data-to-numpy/m-p/448151#M35152 JoshuaBixby 2015-05-08T00:16:38Z Re: cx_Oracle and python to move table data to numpy array https://community.esri.com/t5/python-questions/cx-oracle-and-python-to-move-table-data-to-numpy/m-p/448152#M35153 <HTML><HEAD></HEAD><BODY><P>Thank you.. The cursor.description seems to be what I'm looking for. The results from there should be parseable per table, and should be useable to create my numpy tables <IMG src="https://community.esri.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I'll have a look at oracle_util.py as well. I've looked into it before and didn't quite like that it required a hack to cx_Oracle. </P></BODY></HTML> Fri, 08 May 2015 12:43:55 GMT https://community.esri.com/t5/python-questions/cx-oracle-and-python-to-move-table-data-to-numpy/m-p/448152#M35153 HåvardMoe 2015-05-08T12:43:55Z