In[]:=
(*SetHistoryLength*)​​ClearAll["`*"];​​CloseAll;​​$HistoryLength=2;​​(*Setworkingdirectory*)​​SetDirectory["/Volumes/Home/Projects/Stocks-EODData/Db/"];
In[]:=
Directory[]
Out[]=
/Volumes/Home/Projects/Stocks-EODData/Db
(*Getcommandstohandledatabaseschemas​​Needs["DatabaseLink`"]*)
In[]:=
(*CreatetheStockDbdatabase,registeritforSQLexternalevauator*)​​StockDb=FileNameJoin[Directory[],"StockDb.db"];​​CreateFile[StockDb];​​StockDbRef=DatabaseReference[File[StockDb]];​​RegisterExternalEvaluator["SQL",StockDbRef]
CreateFile
:/Volumes/Home/Projects/Stocks-EODData/Db/StockDb.db already exists.
Out[]=
aa71fc05-620c-883a-a189-a208dc1041f6
​
〉
In[]:=
CREATE TABLE Exchange( ExId INTEGER PRIMARY KEY, ExName TEXT NOT NULL, ExValAtHand NUMERIC(16,4), ExCashProduced Numeric(16,4));
In[]:=
dbSchema=RelationalDatabase[StockDbRef]
Out[]=
RelationalDatabase
Table count: 0
Backend: SQLite
