python - Deploying cx_Oracle onto various versions of Oracle Client -

-

I have some small python applications that use cx_Oracle to connect to an Oracle database. I deploy these apps with py2exe, which works fine in many cases.

The problem is that many standard Oracle client versions (for example, 9i and 10 grams) do not need to install a lot of people, and this is standardized on the same Oracle client version It would be very disappointing to try. I am currently using 9.2 client for 9i customer, and when I include the Cx_Oracle 4.4.1 library in the exe as a result of PE2XX and will not work with 10g customers.

I do not use any specific features of any Oracle versions, so there really is not a specific reason for me that the client version is being used except for CX_ORRALIC compatibility issues.

The ideal solution will be compiled in any way, a version which is completely independent of the Oracle client installed on the machine.

If this is not possible, then I would be willing to compile the different exes for each major Oracle version (my_app_9i.exe, my_app_10g.exe, etc.) but I also set up a new method Even after I can not do that my old version can be notified, I have to change the library further and backward to compile other versions.

Any advice or other options are welcome. If you want to create multiple cx_orracle versions (like: cx_Oracle10g, cx_Oracle11g, etc.), then you have to cx_Oracle

setup () ; The first parameter is to name the module. You only need to change "cx_ oracle" "cx_ oracle" + ver , where ver is 10g , 11g < / Code>, etc. Either make multiple scripts and hard-codes, or add another parameter to dynamically select setup.py .

Of course, once you've found that, you need a mechanism to load the right module on the runtime. To do this, you want to create your own cx_ oracle module that has a __init __.py file that looks like this: 

 Try: Try: Importing from CX_Oracle 9G import * Excluding IRR: Try: CX_Oracle 10G import * Excluding import error: Try: CX_Orcl 11G import * to

You just have your custom cx_Oracle module plus right cx_OracleXg module with your application.

Alternatively, you can dynamically check your custom cx_Oracle module for each available Oracle client library (9G, 10G, 11G, etc.) and its After importing only the correct match cx_OracleXg module In this case, you only need to make a binary shipment, in which your custom cx_ oracle module plus all cx_OracleXg Modules are included.


Comments

Post a Comment

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

-
I'm new to this I'm writing a clr. stored procedure that can be used to get values ​​used in a calculation Call for another stored procedure for Gives an archived methodology int (I think SqlInt32? Value of the table's value is int) which is then necessary to convert to decimal. Here I have the code: Public static integral mood (SQL MDMMYLUE, escalistering AMY type, out of SQLDCM Result) {aResult = 0; Try {SqlConnection conn = New SqlConnection ("Reference Connection = True"); SqlCommand cmd = New SqlCommand ("sp_GetType", conn); Cmd.Parameters.AddWithValue ("@ myValueType", aMyValueType); Cmd.CommandType = CommandType.StoredProcedure; Conn.Open (); Object type = CMD. Exclamation Asser (); Conn.Close (); Decimal type FORCalculation = Convert. ToDecimal (type); Decimal value = convert toDecimal (aMyValue); // ** calculation calc = new calculation (); Decimal result = calorie.docalulation (typefarculation, value); I get an exception...
Read more

Calling GetGUIThreadInfo from Outlook VBA -

-
I need to find the active window'm writing a VBA macro in MS Outlook, which is a specific process. The goal of this is to get the active window / document name even if its original application has more than one document interface. User processor with GetCurrentThreadId is active, I am using GetGUIThreadInfo to get .dll. Here is the correct code: private type RECT as as Left LongPtr top LongPtr right LongPtr down LongPtr termination of private type GUITHREADINFO cbSize as LongPtr flags LongPtr hwndActive LongPtr hwndFocus LongPtr hwndCapture LongPtr as as as as as reset as LongPtr rcCaret as LongPtr hwndCreate as LongPtr hwndMoveSize as HwndMenuOwner end of Private Equity PtrSafe function GetWindowThreadProcessId Lib "user32" (_BVV hnw LongPtr as LongPtr Nig Mr. announced as PtrSafe function GetGUIThreadInfo Lib "user32" _ (ByVal dwthreadid as LongPtr, _ lpguithreadinfo as GUITHREADINFO) LongPtr Sub MyFunction () as dim strWindowTitle string = space as s...
Read more

Obfuscating Python code? -

-
I'm looking for a way to hide my Python source code. print "Hello World!" How can I encode this example so that it is not human-readable? I have been asked to use Base 64 but I'm not sure how. itemprop = "text"> It is limited only, first level ambiguous resolution, but has built-in: byte-code in Python Is a compiler for: dragon-o-m py_compile & lt; Your program.py & gt; creates a .pyo file with a byte-code, and where the docstrings are removed, etc. You can rename .pyo with the .py extension, and python & lt; Your program.py & gt; runs as your program, but it does not have your source code. PS : If your program blur modules like this, you need to rename them with the .pyc suffix (I Not sure it will not break a day), or you can work with .pyo and run them with python -o ... .pyo ( Import should work). This will allow dragon to search your modules (otherwise, Python looks for the .py module).
Read more