You need to sign in to do that
Don't have an account?
gsmithfarmer
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;