python - Mapping non-ascii, long column names in SQLAlchemy fails with NoSuchColumnError -

-

Could it be that the key of the RowProxy object is shortened to some length?

I have a legacy. MSSQL database has some column names with letters with accented letters

I am mapping it with the following code for the Python property: 

  @ event.listens_for (table, "column_reflect") def column_reflect (inspector, table, column_info): If table.name == 'D_Allomanylista_Komplex_V': # set column.key = "attr_ & LT; lower_case_name & gt;" Colm_to_chenj = { 'Olpot' "Elepot 'Bijhteniv' 'Bijhttoyo_ave, U'levlejh \ xe 9siC \ xedmUtca': 'Levelejhsi Simayutaka, U'sjerjh \ u0151d \ xe9sSorsz \ xe1m': 'Sjhejhods Sjham, Colm_info [ 'key'] = columns_to_change.get (column_info [ 'name'], column_info [ 'name']) komplex_table = inspect_komplex_table () class BiztositasokModel (base): __table__ = komplex_table __mapper_args__ = { 'primary_key': [ komplex_table.c [u 'KTVSZAM'], komplex_table.c [u'NyugtaSzam '], komplex_table.c [u'ajanlatszam'], komplex_table.c [ 'SzerzodesSzam'],], 'include_properties': [ 'biztosito_neve', Compleks_teblkk [ 'Allpot'], Compleks_teblkk [ 'Levelezesisimutka'], Compleks_teblkk [ 'Szerjodaeszm'], 'Ktvszm' Nugtszm 'Ajnltszm']}   < P> Unfortunately, this code gives an error saying that  SzerzodesSzam  column does not exist, when I try to query.  
  /Users/viktornagy/.virtualenvs/dosszie/lib/python2. _instance (line, result) 361 detection in the site-packages / sqlalchemy / orm / loading.pyc Identify Ykey = (362 identities-square, -> 363 tople ([row [column in pk_cols] column]) 364 ) 365 /Users/viktornagy/.virtualenvs/dosszie/lib/python2.7/site-packages/sqlalchemy/engine/result.pyc in _key_fallback (self, key, raiseerr) lifting 329 exc.NoSuchColumnError (330% "column"% S 'column' -> 331 expression._string_or_unprintable (key)) 332 left: 333 No return NoSuchColumnError: "D_Allomanylista_Komplex_V.Szerz \ 'u0151d in the row for column column could not be found" \\ xe9sSorsz \\ xe1m '"  
 I get this issue He went into debugging mode to find out the root, and found that the top column on line 363 is  column ('Szerz \ u0151d \ xe9sSorsz \ xe1m', integer (), table = & lt; D_Allomanylista_Komplex_V & gt; Key = 'SzerzodesSzam', null = false)  while this is the  line.key ()  is  you_a_lammnist_complex_V signatures \ u0151d \ xe9sSorsz '. If the key has to be small ( u'Szerz \ u0151d \ xe9sSorsz ' one more and  u'szerz \ u0151d \ xe9sSorsz \ xe1m'  at another point) .  
 query  line [u'D_Allomanylista_Komplex_V_Szerz \ u0151d \ xe9sSorsz ']  actually works, and gives expected results.  
 Is there a way to avoid it?  
 
 
 
 The above pyodbc driver has a limit. Problem solved by switching to pymssql

Comments

Post a Comment

Popular posts from this blog

ios - Adding an SKSpriteNode to SKScene from a child SKSpriteNode -

-
I have a SKScene where I am adding an SKSpriteNode I have subclassed the SKSpriteNode class to create this node. In the subclass I am defining some SKActions on Sprite. What do I want to do when the end of this phantom ends the SKAction sequence, then I add a new Prayer node to this scene. How is this possible. The following code is mine: The code for the sequence is that I'm running on the Scansprinitode subclass (TEMissileNode): - SKAction * moveDown = [SKAction moveToY: Self.position.y - 20 Duration: 0.2]; SKAction * animation = [SKAction animateWithTextures: textures timePerFrame: time / 7]; SKAction * moveMissileProjectile = [SKAction Moving: Pointoffscreen Term: Time]; SKAction * group = [SKAction group: @ [animation, movement projectile]]; SKAction * Sequence = [SKAction Sequence: @ [Hilldown, Group, [SKAction removalFromParent]]]; [Self run action: sequence]; From the main scene, I call those actions that execute these tasks TEMissileNode * missile = [tmissil...
Read more

Matlab transpose a table vector -

-
An embarrassing simple question seems to be, but how can I move a Matlab table vector? aTableT = aTable '; I tried a standard syntax for the simple interaction of a line vector to a line vector aTable : ATableT = reshape (aTable, 1, Height (aTable)); and aTableT = rot90 (aTable); According to the head, the last time table should work for table, see. However, I get this error code: Error type in using table / permit (line 396) Undefined function 'permute' for the input arguments. Error in rot 90 (line 29) b = magnitude (b, [2 1 3: ndims (a)]); NB: fliplr is not useful either pretty sure I have covered clear angles - any ideas? Thanks! Try changing your table into an array, move it, then back to a table In other words, try doing this: aTableArray = table2array (aTable); ATableT = array 2table (aTableArray. '); I have also read the document for rot90 , and it says that rot90 is definitely working for tables Do, and I find you...
Read more

c# - Textbox not clickable but editable -

-
I have a small form with 10 text boxes, I have set them in the correct tab order. I want them on my tab service I was wondering if there is a way to set the text box so that they can be selected for editing until they are tabbed. That is ... I do not want the end user to edit the text box to click on them, I just want to make them editable through tabu. this should do the trick public partial category poor text box: Text Box {Safe Override Zero WndProc (Ref: Message Message) {if (m.msg == (Int) WM.LBUTTONDOWN) {Return; // mount down events} base.WndProc (ref m); }} Window message enum can be found. How to do this without anherizing: text box : class EatMouseDown: netwindows {safe override zero WndProc (ref message message) {if (m.msg == (int) WM.LBUTTONDOWN) {return; } Base.WandProc (Ref M); }} Safe Override Zero Onload (EventEurge E) {base.OnLoad (e); How to do this without any part: left a clean part, whatever is important, this can be a buggy but it works R...
Read more