This repository has been archived by the owner on Jan 29, 2023. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 18
/
Connect_Disconnect.ino
123 lines (93 loc) · 4.13 KB
/
Connect_Disconnect.ino
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
/*********************************************************************************************************************************
Connect_Disconnect.ino
Library for communicating with a MySQL or MariaDB Server
Based on and modified from Dr. Charles A. Bell's MySQL_Connector_Arduino Library https://github.com/ChuckBell/MySQL_Connector_Arduino
to support nRF52, SAMD21/SAMD51, SAM DUE, STM32F/L/H/G/WB/MP1, ESP8266, ESP32, etc. boards using W5x00, ENC28J60, LAM8742A Ethernet,
WiFiNINA, ESP-AT, built-in ESP8266/ESP32 WiFi.
The library provides simple and easy Client interface to MySQL or MariaDB Server.
Built by Khoi Hoang https://github.com/khoih-prog/MySQL_MariaDB_Generic
Licensed under MIT license
**********************************************************************************************************************************/
/*
MySQL Connector/Arduino Example : connect and disconnect (close)
This example demonstrates how to use the connection to open at the start
of a loop, perform some query, then close the connection. Use this technique
for solutions that must sleep for a long period or otherwise require
additional processing or delays. The connect/close pair allow you to
control how long the connection is open and thus reduce the amount of
time a connection is held open. It also helps for lossy connections.
This example demonstrates how to connect to a MySQL server and specifying
the default database when connecting.
For more information and documentation, visit the wiki:
https://github.com/ChuckBell/MySQL_Connector_Arduino/wiki.
INSTRUCTIONS FOR USE
1) Change the address of the server to the IP address of the MySQL server
2) Change the user and password to a valid MySQL user and password
3) Connect a USB cable to your Arduino
4) Select the correct board and port
5) Compile and upload the sketch to your Arduino
6) Once uploaded, open Serial Monitor (use 115200 speed) and observe
Created by: Dr. Charles A. Bell
*/
#include "defines.h"
#include <MySQL_Generic.h>
// Select the static Local IP address according to your local network
IPAddress ip(192, 168, 2, 222);
#define USING_HOST_NAME true
#if USING_HOST_NAME
// Optional using hostname, and Ethernet built-in DNS lookup
char server[] = "your_account.ddns.net"; // change to your server's hostname/URL
#else
IPAddress server(192, 168, 2, 112);
#endif
uint16_t server_port = 5698; //3306;
char user[] = "invited-guest"; // MySQL user login username
char password[] = "the-invited-guest"; // MySQL user login password
MySQL_Connection conn((Client *)&client);
MySQL_Query query = MySQL_Query(&conn);
void setup()
{
Serial.begin(115200);
while (!Serial && millis() < 5000); // wait for serial port to connect
MYSQL_DISPLAY3("\nStarting Connect_Disconnect on", BOARD_NAME, ", with", SHIELD_TYPE);
MYSQL_DISPLAY(MYSQL_MARIADB_GENERIC_VERSION);
// start the ethernet connection and the server:
// Use DHCP dynamic IP and random mac
uint16_t index = millis() % NUMBER_OF_MAC;
// Use Static IP
//Ethernet.begin(mac[index], ip);
Ethernet.begin(mac[index]);
MYSQL_DISPLAY1("Using mac index =", index);
MYSQL_DISPLAY1("Connected! IP address:", Ethernet.localIP());
}
void runQuery()
{
MYSQL_DISPLAY("Running a query: SELECT * FROM test_arduino.hello_arduino LIMIT 6;");
// Execute the query
// KH, check if valid before fetching
if ( !query.execute("SELECT * FROM test_arduino.hello_arduino LIMIT 6;") )
{
MYSQL_DISPLAY("Querying error");
return;
}
query.show_results(); // show the results
query.close(); // close the query
}
void loop()
{
MYSQL_DISPLAY("Connecting...");
//if (conn.connect(server, server_port, user, password))
if (conn.connectNonBlocking(server, server_port, user, password) != RESULT_FAIL)
{
delay(500);
runQuery();
conn.close(); // close the connection
}
else
{
MYSQL_DISPLAY("\nConnect failed. Trying again on next iteration.");
}
MYSQL_DISPLAY("\nSleeping...");
MYSQL_DISPLAY("================================================");
delay(60000);
}