gistfile1.sql

BEGIN;
  BEGIN TRANSACTION;
    INSERT INTO urls (url)
      SELECT 'sefsefefsves'
      WHERE NOT EXISTS (SELECT id FROM urls WHERE urls.url = 'sefsefefsves');
  COMMIT;
  INSERT INTO prices (price, guid, currency, url, datetime, store)
  VALUES (100.00, 4, 'USD', SELECT id FROM urls WHERE url = 'sefsefefsves', '2015-03-22T06:34:45.926013+00:00', SELECT id FROM stores WHERE name = 'Win Condition Cards');
END;