python - NoSuchTable Error Message -


i getting "nosuchtable" error message. know table (dba_users) exists because can query in separate script , results returned. i'm parameters "pull_data" recognized because "print 'processing=' table_name" returns correct value. script listed below.

processing dba_users pulling schema source server 2013-07-25 08:15:15,661 info sqlalchemy.engine.base.engine select user dual 2013-07-25 08:15:15,661 info sqlalchemy.engine.base.engine {} 2013-07-25 08:15:15,802 info sqlalchemy.engine.base.engine select column_name, data_type, char_length, data_precision, data_scale, nullable, data_default all_tab_columns table_name = :table_name , owner = :owner  order column_id 2013-07-25 08:15:15,802 info sqlalchemy.engine.base.engine {'owner': u'itaudit', 'table_name': u'dba_users'} 
import data import getopt import sys quick_mapper import quick_mapper make_session import make_session sqlalchemy import metadata, table sqlalchemy import create_engine sqlalchemy.orm import sessionmaker sqlalchemy.ext.declarative import declarative_base    # main event, creates several objects access both source , destination.   def pull_data(from_db, to_db, tables):     source, sengine = make_session(from_db)     smeta = metadata(bind=sengine)     destination, dengine = make_session(to_db)        table_name in tables:         print 'processing', table_name         print 'pulling schema source server'         table = table(table_name, smeta, autoload = true)         print 'creating table on destination server'         table.create_all(dengine)         newrecord = quick_mapper(table)         columns = table.columns.keys()         print 'transferring records'         record in source.query(table).all():             data = dict(                 [(str(column), getattr(record, column)) column in columns]             )             destination.merge(newrecord(**data))     print 'committing changes'     destination.commit()  def make_session(connection_string):     engine = create_engine(connection_string, echo=true, convert_unicode=true)     session = sessionmaker(bind=engine)     return session(), engine  pull_data('oracle://uid:pass@111.111.1.1:port/sid', 'mysql://uid:pass@999.999.9.9:port/access_benchmark_staging', ["dba_users"])


Comments

Post a Comment

Popular posts from this blog

curl - PHP fsockopen help required -

i trying work on cloudflare api , have found in documentation. unfortunately have no idea how can use in fsockopen or through curl. here example of post request. need know how can make request below data post using curl or fsockopen curl https://www.cloudflare.com/api_json.html -d 'a=cache_lvl' \ -d 'tkn=8afbe6dea02407989af4dd4c97bb6e25' \ -d 'email=sample@example.com' \ -d 'z=example.com' \ -d 'v=agg' here link cloudflare https://www.cloudflare.com/docs/client-api.html#s4.2 try one: $ch = curl_init("https://www.cloudflare.com/api_json.html"); curl_setopt($ch, curlopt_returntransfer,1); curl_setopt($ch, curlopt_followlocation, 1); curl_setopt($ch, curlopt_ssl_verifypeer,false); // handling of -d curl parameter here. $param = array( 'a' => 'cache_lvl', 'tkn' => '8afbe6dea02407989af4dd4c97bb6e25', 'email' => 'sample@example.com', 'z' =...
Read more

HTTP/1.0 407 Proxy Authentication Required PHP -

i working in restricted network/limited access internet. since have use proxy make web service call. here php code calling web service , response . $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' => $proxy_host, 'proxy_port' => $proxy_port, 'proxy_login' => $proxy_login, 'proxy_password' => $proxy_password)); response is fatal error: uncaught soapfault exception: [wsdl] soap-error: parsing wsdl: couldn't load ' http://www.xyz.com/abc/wsdls/login.wsdl ' : failed load external entity if copy url error message , paste in browser(with same proxy settings) works. 2nd scenario is, if pass values instead of variables giving me diffarant response $client = new soapclient("http: //www.xyz.com/abc/wsdls/login.wsdl", array("trace" => 1, "exceptions" => 1, 'proxy_host' ...
Read more

java - More than one row with the given identifier was found: 1, for class: com.model.Diagnosis -

below model, service implementation , error trace of code. model class: @entity @table(name = "ph_diagnosis_history") @jsonidentityinfo(generator = objectidgenerators.propertygenerator.class, property = "id",scope=diagnosis.class) public class diagnosis extends abstractentity { @column(name = "diagnosis_notes", length=255) @length(max = 255, message = iprprop.max_len_255_msg) private string diagnosisnote; @enumerated(enumtype.string) private diagnosistypeenum type; @temporal(temporaltype.date) @column(name = "diagnosis_date") @jsonserialize(using = jsondateserializer.class) private date diagnosisdate; @manytoone @joincolumn(name = "patient_chart_id") private patientchart patientchart; public string getdiagnosisnote() { return diagnosisnote; } public void setdiagnosisnote(string diagnosisnote) { this.diagnosisnote = diagnosisnote; } public d...
Read more