thebrettbarlow

SELECT Id, Company, LeadSource, format(CreatedDate)
FROM Lead
ORDER BY CreatedDate
LIMIT 10

thebrettbarlow

SELECT Id, FirstName, LastName, Title, Account.Name
FROM Contact
WHERE Title = 'CEO'

thebrettbarlow

SELECT Id, Name, (SELECT Id, Name, Amount, CloseDate FROM Opportunities)
FROM Account

thebrettbarlow

SELECT Id, Name, (SELECT Id, Name, Amount, CloseDate FROM Opportunities)
FROM Account
WHERE Id IN (SELECT AccountId FROM Opportunity)

thebrettbarlow

# This will open a login page that will let you connect your org to the CLI
sfdx force:auth:web:login --setalias HelloWorldOrg

# You will now see the org you connected with!
sfdx force:org:list

thebrettbarlow

soql "select id, username from user where firstname = 'chatty'" -u dev1

thebrettbarlow

soql "
select id, name, ownerid, owner.name 
from account 
where ownerid = '005j000000Ea93uAAB'
" -u dev1 -r csv > chatty_accounts_to_move.csv

thebrettbarlow

sfdx force:data:bulk:upsert \
     --sobjecttype account \
     --externalid id \
     --csvfile chatty_accounts_to_move.csv \
     --targetusername dev1 \
     --wait 10

thebrettbarlow

# query the accounts and put them in chatty_accounts_to_move__backup.csv
soql "
select id, name, ownerid, owner.name
from account
where ownerid = '005j000000Ea93uAAB'
" -u dev1 -r csv > chatty_accounts_to_move__backup.csv &&

# cut out the Id of each account and set the new OwnerId
cat chatty_accounts_to_move__backup.csv | \
cut -d "," -f 1 | \