function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
gsmithfarmergsmithfarmer 

Found: SOQL ANSI-Like Command Line tool (INSERT/UPDATE/DELETE/SELECT)

Found at:  http://code.google.com/p/sqlforce/

Free.

Written because I needed it to save a lot of time. 

 

 

Command line tool that uses SOQL to manipulate a SalesForce database. Most importantly, the 200 record SOQL governing limit is managed and ANSI commands like:

  • DELETE FROM Contact WHERE ...
  • UPDATE Contact SET site="abc" WHERE ...
  • INSERT Contact( LastName, FirstName) Values(....), (.....)
  • INSERT Contact( LastName, FirstName) SELECT a,b, FROM ...
  • SELECT DISTINCT ...
  • SELECT ... UNION SELECT ...

are supported. Since the base tool is in Java, Python, Perl, and Ruby fans can integrate support easily.

Examples:

UPDATE Contact SET MailingCountry='USA'
WHERE
MailingCountry IN ('United States', 'US', 'United States of America', 'America');
SELECT DISTINCT MailingCountry FROM Contact
UNION SELECT
OtherCountry FROM Contact
UNION SELECT
ShippingCountry FROM Account
UNION SELECT
BillingCountry FROM Account
;
INSERT INTO Contact (FirstName, LastName) 
VALUES
( 'George', 'Washington'), ('Thomas', 'Jefferson');
INSERT INTO Contact (FirstName, LastName) SELECT N1, N2 FROM CustomObject__c;