Hey there! I plan to read, store and generating graphs for voltage. ADC is ADS1115 and database is MySQL. Can Weewx work without hardware driver? I just need to point weewx to already prepared data from database and next use weewx as usually (plotting, statistics etc.). I need small how-to for this.
DB SQL sample is attached. Many Thanks! Andrej -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
-- phpMyAdmin SQL Dump -- version 4.6.6deb4 -- https://www.phpmyadmin.net/ -- -- Host: localhost:3306 -- Generation Time: Jan 20, 2019 at 06:32 PM -- Server version: 10.1.37-MariaDB-0+deb9u1 -- PHP Version: 7.0.33-0+deb9u1 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `DataLogger` -- -- -------------------------------------------------------- -- -- Table structure for table `ADS1115Table` -- CREATE TABLE `ADS1115Table` ( `id` int(11) NOT NULL, `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `deviceid` int(11) NOT NULL, `channel0_voltage` float NOT NULL, `channel0_raw` int(11) NOT NULL, `channel1_voltage` float NOT NULL, `channel1_raw` int(11) NOT NULL, `channel2_voltage` float NOT NULL, `channel2_raw` int(11) NOT NULL, `channel3_voltage` float NOT NULL, `channel3_raw` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `ADS1115Table` -- INSERT INTO `ADS1115Table` (`id`, `timestamp`, `deviceid`, `channel0_voltage`, `channel0_raw`, `channel1_voltage`, `channel1_raw`, `channel2_voltage`, `channel2_raw`, `channel3_voltage`, `channel3_raw`) VALUES (372, '2019-01-16 19:51:25', 0, 1.203, 3224, 1.208, 3143, 1.201, 3234, 1.213, 3145), (373, '2019-01-16 19:51:30', 0, 1.192, 3208, 1.205, 3226, 1.216, 3148, 1.158, 3322), (374, '2019-01-16 19:51:35', 0, 1.2, 3170, 1.198, 3233, 1.221, 3149, 1.145, 3317), (375, '2019-01-16 19:51:40', 0, 1.19, 3215, 1.207, 3235, 1.216, 3145, 1.159, 3317), (376, '2019-01-16 19:51:45', 0, 1.196, 3197, 1.202, 3224, 1.217, 3148, 1.161, 3313), (377, '2019-01-16 19:51:50', 0, 1.175, 3270, 1.221, 3180, 1.165, 3254, 1.23, 3193); -- -- Indexes for dumped tables -- -- -- Indexes for table `ADS1115Table` -- ALTER TABLE `ADS1115Table` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `ADS1115Table` -- ALTER TABLE `ADS1115Table` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=627; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
