forked from rosh/MQL5Book
42 lines
1.7 KiB
MQL5
42 lines
1.7 KiB
MQL5
 | //+------------------------------------------------------------------+
| ||
//| DBcreateTable.mq5 |
| |||
//| Copyright 2022, MetaQuotes Ltd. |
| |||
//| https://www.mql5.com |
| |||
//+------------------------------------------------------------------+
| |||
#property description "Creates a table in a given database. If the database doesn't exist, it creates it beforehand."
| |||
#property script_show_inputs
| |||
| |||
input string Database = "MQL5Book/DB/Example1";
| |||
input string Table = "table1";
| |||
| |||
#include "..\..\Include\DBSQLite.mqh"
| |||
| |||
//+------------------------------------------------------------------+
| |||
//| Script program start function |
| |||
//+------------------------------------------------------------------+
| |||
void OnStart()
| |||
{
| |||
DBSQLite db(Database);
| |||
if(db.isOpen())
| |||
{
| |||
PRTF(db.execute(StringFormat("CREATE TABLE %s (msg text)", Table)));
| |||
// the following modification will not throw error
| |||
// on attempt of creating already existing table
| |||
// PRTF(db.execute(StringFormat("CREATE TABLE IF NOT EXISTS %s (msg text)", Table)));
| |||
PRTF(db.hasTable(Table));
| |||
}
| |||
}
| |||
//+------------------------------------------------------------------+
| |||
/*
| |||
1-st run with default inputs
| |||
| |||
db.execute(StringFormat(CREATE TABLE %s (msg text),Table))=true / ok
| |||
db.hasTable(Table)=true / ok
| |||
| |||
2-nd run with default inputs
| |||
| |||
database error, table table1 already exists
| |||
db.execute(StringFormat(CREATE TABLE %s (msg text),Table))=false / DATABASE_ERROR(5601)
| |||
db.hasTable(Table)=true / ok
| |||
*/
| |||
//+------------------------------------------------------------------+
|