Re: SQL Examples
Re: SQL Examples
- Subject: Re: SQL Examples
- From: Daniel Rhoden <email@hidden>
- Date: Fri, 13 Mar 2009 09:14:03 -0500
The Create SQLite Database action isn't a standard Automator action.
So it would have been handy to know which one you were referring to.
I found one at http://automator.us/developer-02.html#1003, but who's
to keep anyone else from creating an Action with the same name.
This action's description points out that its expected input is an
AppleScript list, not text or sql. So using it properly will almost
certainly improve your outcome. I toyed around with it and don't see
a lot of benefit to what you are trying to accomplish. Since you will
have a csv file you will know the structure of the data (unless that
is the part you are wanting to automate). I suggest manually creating
the database file and table structure. I have one main database file
that I use in nearly all my sql-related actions and just create new
tables for each new project. I then move it out to MySQL when cleaned
up, processed, etc.
On Mar 12, 2009, at 12:16 PM, Bruce Robertson wrote:
It would be helpful to see some simple examples of using the
Automator SQL
funtions like Convert CSV to SQL, Apply SQL, and Execute SQL.
Bruce Robertson
For instance if Do this in Convert CSV to SQL:
Before:
BEGIN TRANSACTION;create table bikes( company);
Per Row:
INSERT INTO bikes values (%{1}@);
After:
end transaction;
And feed it to action Create SQLite Database, then the result does not
contain any of the data.
Instead, it contains tables ZFIELD, ZRECORD, Z_METADATA, Z_PRIMARYKEY
And none of these table contain my data.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Automator-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Automator-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden