Thread: [cx-oracle-users] INSERT examples

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 422-6466

Given this:
curs1.execute("""select * from emp""")
result_set = curs1.fetchall()

can someone please provide me with sample code to INSERT into emp2
with "result_set" ?

thanks

On 6/17/10 9:38 AM, Robert wrote:
> Given this:
> curs1.execute("""select * from emp""")
> result_set = curs1.fetchall()
>
> can someone please provide me with sample code to INSERT into emp2
> with "result_set" ?

here's one way...  cx_Experts, any nice shorthand for :1,:2,:3,...?

curs1.execute('select empno,ename,job,mgr,hiredate,sal,comm,deptno from emp')

for row in curs1:
     curs2.execute('insert into emp2(empno,ename,job,mgr,hiredate,sal,comm,deptno) values (:1,:2,:3,:4,:5,:6,:7,:8)',row)

If the data is really coming from one table and going unmodified into another table, couldn't you do something like this?

curs1.execute("""insert into emp2 select * from emp""")
db.commit()

-----Original Message-----
From: Robert [mailto:web...@gm...] 
Sent: Thursday, June 17, 2010 11:38 AM
To: cx-...@li...
Subject: [cx-oracle-users] INSERT examples

Given this:
curs1.execute("""select * from emp""")
result_set = curs1.fetchall()

can someone please provide me with sample code to INSERT into emp2
with "result_set" ?

thanks

------------------------------------------------------------------------------
ThinkGeek and WIRED's GeekDad team up for the Ultimate 
GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the 
lucky parental unit.  See the prize list and enter to win: 
http://p.sf.net/sfu/thinkgeek-promo
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Thanks,
Yes, as long time Oracle dev, i know :)
Just wanted to present a very simple case.

On Thu, Jun 17, 2010 at 2:02 PM, Fawcett, David (MPCA)
<Dav...@st...> wrote:
> If the data is really coming from one table and going unmodified into another table, couldn't you do something like this?
>
> curs1.execute("""insert into emp2 select * from emp""")
> db.commit()
>

How to make below code work ?
curs1 has 8 columns, I want to insert into table with 9 columns - 'FOO' in col_9

> for row in curs1:
>     curs2.execute('insert into emp2(empno,ename,job,mgr,hiredate,sal,comm,deptno, col_9) values (:1,:2,:3,:4,:5,:6,:7,:8)',row, 'FOO')
>

TypeError: function takes at most 2 arguments (3 given)

On 6/17/10 1:33 PM, Robert wrote:
> How to make below code work ?
> curs1 has 8 columns, I want to insert into table with 9 columns - 'FOO' in col_9
>
>
>> for row in curs1:
>>      curs2.execute('insert into emp2(empno,ename,job,mgr,hiredate,sal,comm,deptno, col_9) values (:1,:2,:3,:4,:5,:6,:7,:8)',row, 'FOO')
>>
>
> TypeError: function takes at most 2 arguments (3 given)

do this:

     print row

and you will see that it is a list of length 8
that corresponds to the row fetched from curs1.

so, do these two things:

     - add :9 to the values clause, to correspond with col_9
     - add 'FOO' to row, so there will be 9 items in the list

         row.append('FOO')

and it should be good.