Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #83834

Re: MySQL connections

Path csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path <jacob@blindza.co.za>
X-Original-To python-list@python.org
Delivered-To python-list@mail.python.org
X-Spam-Status OK 0.000
X-Spam-Evidence '*H*': 1.00; '*S*': 0.00; 'else:': 0.03; 'value,': 0.04; 'warnings': 0.04; 'yet.': 0.04; 'argument': 0.05; 'elif': 0.05; 'insert': 0.05; '#if': 0.07; 'column': 0.07; 'currency': 0.07; 'failing': 0.07; 'filename:fname piece:py': 0.07; 'finally:': 0.07; 'float': 0.07; 'mysql,': 0.07; 'none:': 0.07; 'skip:` 10': 0.07; 'skip:l 60': 0.07; 'sys': 0.07; 'versions,': 0.07; '"__main__":': 0.09; '#print': 0.09; '__init__': 0.09; '__name__': 0.09; 'arguments': 0.09; 'arguments,': 0.09; 'executable': 0.09; 'f.close()': 0.09; 'function,': 0.09; 'insertion': 0.09; 'skip:# 30': 0.09; 'statements': 0.09; 'testing,': 0.09; 'try:': 0.09; 'cc:addr:python-list': 0.11; 'def': 0.12; 'jan': 0.12; '"":': 0.16; '"#":': 0.16; '")"': 0.16; '"-"': 0.16; '"0"': 0.16; '"["': 0.16; '"\\r\\n"': 0.16; '"about': 0.16; '"create': 0.16; '"insert': 0.16; '"w")': 0.16; '"|"': 0.16; '("",': 0.16; '.py': 0.16; '10:59': 0.16; 'bool': 0.16; 'bytearray': 0.16; 'col': 0.16; 'columns': 0.16; 'currency,': 0.16; 'exc_type,': 0.16; 'integer,': 0.16; 'itself,': 0.16; 'jacob': 0.16; 'received:opentransfer.com': 0.16; 'script,': 0.16; 'skip:\\ 30': 0.16; 'skip:{ 30': 0.16; 'tab': 0.16; 'true:': 0.16; 'unicode,': 0.16; 'value"': 0.16; 'varies': 0.16; '{0}': 0.16; '{1},': 0.16; 'exception': 0.16; 'files.': 0.16; 'skip:# 20': 0.16; 'thursday,': 0.16; 'ignore': 0.16; 'wrote:': 0.18; 'bit': 0.19; 'file,': 0.19; 'passing': 0.19; 'skip:f 30': 0.19; 'thu,': 0.19; 'written': 0.21; 'command': 0.22; 'machine': 0.22; 'select': 0.22; 'import': 0.22; 'issue.': 0.22; 'cc:addr:python.org': 0.22; 'error': 0.23; 'byte': 0.24; 'driver': 0.24; 'exists': 0.24; 'integer': 0.24; "shouldn't": 0.24; 'skip:l 30': 0.24; 'unicode': 0.24; 'versions': 0.24; 'file.': 0.24; 'cc:2**0': 0.24; 'cc:no real name:2**0': 0.24; 'sort': 0.25; 'source': 0.25; '15,': 0.26; 'query': 0.26; 'pass': 0.26; 'post': 0.26; 'primary': 0.26; 'skip:" 20': 0.27; 'values': 0.27; 'header:In-Reply-To:1': 0.27; 'tried': 0.27; 'function': 0.29; 'skip:p 30': 0.29; 'character': 0.29; 'database,': 0.30; 'errors': 0.30; 'skip:( 20': 0.30; 'code': 0.31; 'lines': 0.31; '"")': 0.31; 'decimal': 0.31; 'indentation': 0.31; 'os,': 0.31; 'pickle': 0.31; 'requesting': 0.31; 'tuples': 0.31; 'file': 0.32; 'class': 0.32; 'lists': 0.32; 'run': 0.32; 'text': 0.33; 'running': 0.33; '-----': 0.33; 'skip:# 10': 0.33; 'table': 0.34; 'minutes': 0.67; 'close': 0.67; 'skip:w 30': 0.69; 'results': 0.69; 'default': 0.69; 'ending': 0.78; '(sql': 0.84; '2015': 0.84; 'effectively,': 0.84; 'float,': 0.84; 'initiates': 0.84; 'no:': 0.84; 'relate': 0.84
Comment DKIM? See http://www.dkim.org
DKIM-Signature v=1; a=rsa-sha256; c=relaxed/relaxed; d=blindza.co.za; s=dkim-shared; x=1421945070; h=Comment: DomainKey-Signature:Received:Received:Message-ID:From:To:Cc: References:In-Reply-To:Subject:Date:MIME-Version:Content-Type; bh=SZYv4nMuo4hBj0P3jGbgP7e+hhS4JoctIEc+mkTfSsE=; b=qn3lhm/O8PUiD rptz8PFZFvdpWy13eS0JZWfstT/qO65XCn63fPZlpr/vF41wI8QNONn+2+9s3kbg RNXdKGpcYK4SieWALLA6+KDSljXHkeAOOdYd2TPJ17pVI1MGV9HmCgdR3yu6HDhC AylErE9CsxytJsXerDMso2Lo2VOFWA=
Comment DomainKeys? See http://antispam.yahoo.com/domainkeys
DomainKey-Signature a=rsa-sha1; q=dns; c=nofws; s=dkim-shared; d=blindza.co.za; h=Received:Received:X-Originating-IP:Message-ID:From:To:Cc:References:In-Reply-To:Subject:Date:MIME-Version:Content-Type:X-Priority:X-MSMail-Priority:X-Mailer:X-Mimeole; b=mp59YN90eyoBjBKPaXH3CYzlA7DrnUsBEqehWwMDmuvh9m3J0mVHNHVO0ei1c0 ZYXN46xUjIwapWeYO5IqtH0oQbPDNx7CzZmko4LCiIacvn0Rm40BcRub6LmcItTp 5fC7Tv2nCtYUxDZgpP2YI3gCHnifUHzFthItD94WpZ+o8=;
X-Originating-IP 105.237.17.61
From "Jacob Kruger" <jacob@blindza.co.za>
To "Chris Angelico" <rosuav@gmail.com>
References <DB3F78F5082B4B31A42C783C4E9BD763@JakesPC> <CAPTjJmpvaNQNVJsmvbH6YGYnQZkofNCS0F+0UFzwsy-NVqv-ug@mail.gmail.com> <5F6F0C3BBA694C15A513F94735D89E18@JakesPC> <CAPTjJmr3nA-g2eGGW1JHK=09FW+fY4dEmPhWCSYmF6xQGvSfbg@mail.gmail.com>
In-Reply-To <CAPTjJmr3nA-g2eGGW1JHK=09FW+fY4dEmPhWCSYmF6xQGvSfbg@mail.gmail.com>
Subject Re: MySQL connections
Date Thu, 15 Jan 2015 18:40:31 +0200
MIME-Version 1.0
Content-Type multipart/mixed; boundary="----=_NextPart_000_0040_01D030F2.BDD6E360"
X-Priority 3
X-MSMail-Priority Normal
X-Mailer Microsoft Windows Mail 6.0.6002.18197
X-Mimeole Produced By Microsoft MimeOLE V6.1.7601.17609
Cc python-list@python.org
X-BeenThere python-list@python.org
X-Mailman-Version 2.1.15
Precedence list
List-Id General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive <http://mail.python.org/pipermail/python-list/>
List-Post <mailto:python-list@python.org>
List-Help <mailto:python-list-request@python.org?subject=help>
List-Subscribe <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups comp.lang.python
Message-ID <mailman.17766.1421340275.18130.python-list@python.org> (permalink)
Lines 594
NNTP-Posting-Host 2001:888:2000:d::a6
X-Trace 1421340275 news.xs4all.nl 2855 [2001:888:2000:d::a6]:40630
X-Complaints-To abuse@xs4all.nl
Xref csiph.com comp.lang.python:83834

Show key headers only | View raw


[Multipart message — attachments visible in raw view] - view raw

----- Original Message ----- 
From: "Chris Angelico" <rosuav@gmail.com>
Cc: <python-list@python.org>
Sent: Thursday, January 15, 2015 2:33 PM
Subject: Re: MySQL connections


> On Thu, Jan 15, 2015 at 10:59 PM, Jacob Kruger <jacob@blindza.co.za> 
> wrote:
>> Tried generating .exe with both cx_freeze, and pyInstaller, and the code
>> itself, and both versions of executable generate errors, same as running 
>> it
>> from command line - only difference is the source of the error mentioned 
>> in
>> error message then varies from a2m.exe and python.exe , and even if 
>> compile
>> it on machine where all works, and then copy .exe back to this primary
>> machine, then get same error - think it must relate to something else on
>> this machine, but can't track it down.
>
> Okay. Ignore the .exe versions, and just work with what happens when
> you run the .py files. If it fails as part of a .py file, post the
> failing file.

If you want to check it out, have attached the full code file - might be a 
bit messy/large - but, effectively, right at bottom, launch an instance of 
the class a2m, passing through arguments, and then from within __init__ call 
convertProcess function, which then initiates process, harvesting sort of 
rendition/version of structure out of MS access database file, makes call to 
convertSQL to generate structural SQL script, and save it to a file, which 
then calls convertData function to generate insert statements to populate 
database, and then that makes a call to convertExport, if you passed a 
command line argument in requesting mysql, and that's the current issue 
function - have stripped most of actual functionality out of it, since am 
just testing, so the first 16 lines of that function are what's relevant at 
moment - think shouldn't rely on any other self. objects/attributes as such 
either, unless step-through process is an issue.

And, tried cleaning it up a bit - replaced tab indentation character with 
double spaces, but, code might not look perfect/be perfectly clean as of 
yet.

Jacob Kruger
Blind Biker
Skype: BlindZA
"Roger Wilco wants to welcome you...to the space janitor's closet..." 

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread


Thread

Re: MySQL connections "Jacob Kruger" <jacob@blindza.co.za> - 2015-01-15 18:40 +0200

csiph-web