odbc create test db queries

create-odbc-test-order.sql

CREATE TABLE test_order (
`orderId` int unsigned NOT NULL AUTO_INCREMENT,
orderNumber varchar(255),
orderDate varchar(255),
shipperReference varchar(255),
shipperReference2 varchar(255),
shippingService varchar(255),
orderGroup varchar(255),
`name` varchar(255),
company varchar(255),
address1 varchar(255),
address2 varchar(255),
address3 varchar(255),
city varchar(255),
state varchar(255),
zip varchar(255),
country varchar(255),
email varchar(255),
phone varchar(255),
weight varchar(255),
length varchar(255),
width varchar(255),
height varchar(255),
weightUnit varchar(255),
dimUnit varchar(255),
itemSku varchar(255),
itemTitle varchar(255),
itemQuantity varchar(255),
itemPrice varchar(255),
itemWeight varchar(255),
`status` varchar(255),
carrier varchar(255),
serviceCode varchar(255),
trackingNumber varchar(255),
totalShippingCost varchar(255), 
shipmentDate varchar(255), 
shippingWeight varchar(255)
)

get-orders.sql

select * from test_order

insert-into-order.sql

insert into test_order set
orderId =1,
orderNumber = 1,
orderDate = '12/30/2020',
shipperReference = 'ship reference 1',
shipperReference2  = 'ship reference 2',
shippingService  = 'fast shipping',
orderGroup = 'grouping1',
`name` = 'joe',
company = 'rsis',
address1 = '123 W Fake St',
address2 = 'unit 3',
address3 = 'back porch',
city = 'american fork',
state = 'ut',
zip = '84003',
country = 'us',
email = '[email protected]',
phone = '8017090417',
weight = '5',
length = '1',
width = '1',
height = '1',
weightUnit = 'lb',
dimUnit = 'in',
itemSku = '123SKU',
itemTitle = 'Test Item',
itemQuantity = '4',
itemPrice = '5.00',
itemWeight = '1',
`status` = 'pending'

update-order.sql

update test_order set
  carrier = @carrier,
  serviceCode = @serviceCode,
  trackingNumber = @trackingNumber,
  totalShippingCost = @totalShippingCost, 
  shipmentDate = @shipmentDate, 
  shippingWeight = @weight
where orderId = @orderId