# Rows inserted in 'Insert into Table Select * from Table' Stmt

[vwake7]

@jeffreyaven Is there a way to figure out the # Rows inserted in 'Insert into Table Select * from Table' Stmt in Pystackql

[jeffreyaven]

don't believe we have this feature at the moment, but it is a good request, can you comment @general-kroll-4-life

[jeffreyaven]

actually we can add this to pystackql @vwake7 by counting the stderr lines back from the executeStmt method, e.g.

stackql  >>INSERT INTO google.compute.instances(   project,   zone,   data__name,   data__machineType,   data__disks,   data__networkInterfaces ) 
stackql  >>SELECT   
stackql  >>'stackql-demo-2' as project,   
stackql  >>'australia-southeast1-a' as zone, 
stackql  >>instanceId as name, 
stackql  >>CASE instanceType 
stackql  >>WHEN 't2.micro' 
stackql  >>THEN 'https://www.googleapis.com/compute/v1/projects/stackql-demo-2/zones/australia-southeast1-a/machineTypes/e2-micro' 
stackql  >>END as machineType,
stackql  >>'[{"autoDelete":true,"boot":true,"initializeParams":{"diskSizeGb":"10","sourceImage":"https://compute.googleapis.com/compute/v1/projects/ubuntu-os-cloud/global/images/family/ubuntu-2004-lts"},"mode":"READ_WRITE","type":"PERSISTENT"}]'
stackql  >>as disks,   
stackql  >>'[{"subnetwork":"https://www.googleapis.com/compute/v1/projects/stackql-demo-2/regions/australia-southeast1/subnetworks/default"}]' as networkInterfaces 
stackql  >>FROM aws.ec2_api.instances WHERE region = 'ap-southeast-2' AND instanceType = 't2.micro';
The operation was despatched successfully
The operation was despatched successfully

can you raise a feature request in pystackql and we will work on this

[vwake7]

Sure @jeffreyaven

[jeffreyaven]

Hey @vwake7 pystackql/3.6.2 now includes a rowsaffected field from the executeStmt method, this should be what you are looking for