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
|
|
*/
|
|
//+------------------------------------------------------------------+
|