<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" xmlns:v =
"urn:schemas-microsoft-com:vml" xmlns:o =
"urn:schemas-microsoft-com:office:office" xmlns:w =
"urn:schemas-microsoft-com:office:word" xmlns:m =
"http://schemas.microsoft.com/office/2004/12/omml"><HEAD>
<META content="text/html; charset=utf-8" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 11.00.9600.18763">
<STYLE>@font-face {
font-family: Courier;
}
@font-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: inherit;
}
@page WordSection1 {size: 612.0pt 792.0pt; margin: 70.85pt 70.85pt 2.0cm 70.85pt; }
P.MsoNormal {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN: 0cm 0cm 0pt; mso-fareast-language: EN-US
}
LI.MsoNormal {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN: 0cm 0cm 0pt; mso-fareast-language: EN-US
}
DIV.MsoNormal {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN: 0cm 0cm 0pt; mso-fareast-language: EN-US
}
A:link {
TEXT-DECORATION: underline; COLOR: #0563c1; mso-style-priority: 99
}
SPAN.MsoHyperlink {
TEXT-DECORATION: underline; COLOR: #0563c1; mso-style-priority: 99
}
A:visited {
TEXT-DECORATION: underline; COLOR: #954f72; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
TEXT-DECORATION: underline; COLOR: #954f72; mso-style-priority: 99
}
PRE {
FONT-SIZE: 10pt; FONT-FAMILY: "Courier New"; MARGIN: 0cm 0cm 0pt; mso-style-priority: 99; mso-style-link: "HTML Vorformatiert Zchn"
}
P.msonormal0 {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; mso-style-name: msonormal; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
LI.msonormal0 {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; mso-style-name: msonormal; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
DIV.msonormal0 {
FONT-SIZE: 11pt; FONT-FAMILY: "Calibri",sans-serif; MARGIN-LEFT: 0cm; MARGIN-RIGHT: 0cm; mso-style-name: msonormal; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.HTMLVorformatiertZchn {
FONT-FAMILY: "Courier New"; mso-fareast-language: DE; mso-style-priority: 99; mso-style-link: "HTML Vorformatiert"; mso-style-name: "HTML Vorformatiert Zchn"
}
SPAN.E-MailFormatvorlage20 {
FONT-FAMILY: "Calibri",sans-serif; COLOR: windowtext; mso-style-type: personal
}
SPAN.kwd {
mso-style-name: kwd
}
SPAN.pln {
mso-style-name: pln
}
SPAN.pun {
mso-style-name: pun
}
SPAN.str {
mso-style-name: str
}
SPAN.E-MailFormatvorlage25 {
FONT-FAMILY: "Calibri",sans-serif; COLOR: windowtext; mso-style-type: personal-reply
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
DIV.WordSection1 {
page: WordSection1
}
</STYLE>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></HEAD>
<BODY lang=DE link=#0563c1 bgColor=#ffffff vLink=#954f72>
<DIV><FONT size=2 face=Arial>Habe auch das Problem, das ich bei meinem Webhoster
nur 1Gb pro Datenbank habe</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Wäre es nicht sinnvoll, direkt was ins Web-UI
einzubauen, um die Daten pro Kanal zu löschen?</FONT></DIV>
<DIV><FONT size=2 face=Arial>Man könnte es z.B. für den jeweils aktivierten
Zeitraum löschen?</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Grüße</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial>Klaus</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<DIV><FONT size=2 face=Arial></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; PADDING-RIGHT: 0px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=thomas@fambesse.de href="mailto:thomas@fambesse.de">fambesse</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=volkszaehler-users@demo.volkszaehler.org
href="mailto:volkszaehler-users@demo.volkszaehler.org">'volkszaehler.org -
users'</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, August 24, 2017 11:44
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [vz-users] Daten aus
Datenbank löschen</DIV>
<DIV><BR></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><A name=_MailEndCompose>Ja Super, <o:p></o:p></A></P>
<P class=MsoNormal><SPAN style="mso-bookmark: _MailEndCompose">hat geklappt
über die API. <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="mso-bookmark: _MailEndCompose">Das mit den
Loschen mittels SQL werde ich aber auch noch testen. <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="mso-bookmark: _MailEndCompose"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN style="mso-bookmark: _MailEndCompose">Besten dank an
alle die mir geholfen haben. <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="mso-bookmark: _MailEndCompose"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="mso-bookmark: _MailEndCompose"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="mso-bookmark: _MailEndCompose"><o:p> </o:p></SPAN></P>
<DIV>
<P class=MsoNormal><SPAN style="mso-bookmark: _MailEndCompose"><SPAN
style="FONT-FAMILY: Courier; COLOR: black; mso-fareast-language: DE">----------------------------------------------------------</SPAN></SPAN><SPAN
style="mso-bookmark: _MailEndCompose"><SPAN
style='FONT-FAMILY: "Times New Roman",serif; COLOR: black; mso-fareast-language: DE'>
</SPAN></SPAN><SPAN style="mso-bookmark: _MailEndCompose"><SPAN
style="mso-fareast-language: DE"><o:p></o:p></SPAN></SPAN></P>
<P class=MsoNormal><SPAN style="mso-bookmark: _MailEndCompose"><SPAN
style="FONT-FAMILY: Courier; COLOR: black; mso-fareast-language: DE">Thomas
Besse
</SPAN></SPAN><SPAN style="mso-bookmark: _MailEndCompose"><SPAN
style='FONT-FAMILY: "Times New Roman",serif; COLOR: black; mso-fareast-language: DE'>
</SPAN></SPAN><SPAN style="mso-bookmark: _MailEndCompose"><SPAN
style="mso-fareast-language: DE"><o:p></o:p></SPAN></SPAN></P>
<P class=MsoNormal><SPAN style="mso-bookmark: _MailEndCompose"><SPAN
style="FONT-FAMILY: Courier; COLOR: black; mso-fareast-language: DE">57250
Netphen
e-mail: </SPAN></SPAN><A href="mailto:thomas@fambesse.de"><SPAN
style="mso-bookmark: _MailEndCompose"><SPAN
style="FONT-FAMILY: Courier; mso-fareast-language: DE">thomas@fambesse.de</SPAN></SPAN><SPAN
style="mso-bookmark: _MailEndCompose"></SPAN></A><SPAN
style="mso-bookmark: _MailEndCompose"><SPAN
style="FONT-FAMILY: Courier; COLOR: black; mso-fareast-language: DE"> </SPAN></SPAN><SPAN
style="mso-bookmark: _MailEndCompose"><SPAN
style='FONT-FAMILY: "Times New Roman",serif; COLOR: black; mso-fareast-language: DE'>
</SPAN></SPAN><SPAN style="mso-bookmark: _MailEndCompose"><SPAN
style="mso-fareast-language: DE"><o:p></o:p></SPAN></SPAN></P>
<P class=MsoNormal><SPAN style="mso-bookmark: _MailEndCompose"><SPAN
style="FONT-FAMILY: Courier; COLOR: black; mso-fareast-language: DE">----------------------------------------------------------</SPAN></SPAN><SPAN
style="mso-bookmark: _MailEndCompose"><SPAN style="mso-fareast-language: DE">
<o:p></o:p></SPAN></SPAN></P></DIV>
<P class=MsoNormal><SPAN
style="mso-bookmark: _MailEndCompose"><o:p> </o:p></SPAN></P><SPAN
style="mso-bookmark: _MailEndCompose"></SPAN>
<DIV>
<DIV
style="BORDER-TOP: #e1e1e1 1pt solid; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0cm; PADDING-TOP: 3pt; PADDING-LEFT: 0cm; BORDER-LEFT: medium none; PADDING-RIGHT: 0cm">
<P class=MsoNormal><B><SPAN
style="mso-fareast-language: DE">Von:</SPAN></B><SPAN
style="mso-fareast-language: DE"> volkszaehler-users
[mailto:volkszaehler-users-bounces@demo.volkszaehler.org] <B>Im Auftrag von
</B>Friedrich Kessler<BR><B>Gesendet:</B> Mittwoch, 23. August 2017
17:54<BR><B>An:</B> volkszaehler.org - users
<volkszaehler-users@demo.volkszaehler.org><BR><B>Betreff:</B> Re:
[vz-users] Daten aus Datenbank löschen<o:p></o:p></SPAN></P></DIV></DIV>
<P class=MsoNormal><o:p> </o:p></P>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10.5pt; COLOR: black">Hallo,</SPAN><SPAN
style="FONT-SIZE: 10.5pt; COLOR: black; mso-fareast-language: DE"><o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN style="FONT-SIZE: 10.5pt; COLOR: black">Ich
exportiere Daten aus der vz DB mit diesem Script (nur bestimmte
Channels):<o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10.5pt; COLOR: black"><o:p> </o:p></SPAN></P></DIV>
<DIV><PRE><SPAN style="COLOR: black"> select channel_id, timestamp,value from data<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"> where from_unixtime(timestamp/1000) > ('2015-06-05 12:43:16')<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"> and from_unixtime(timestamp/1000) < ('2015-08-06 09:40:37')<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"> and channel_id > 12 and channel_id < 20<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"> INTO outfile '/tmp/last_values' fields terminated by ‚;<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">Du kannst ja die Daten vor dem löschen selektieren um zu prüfen ob es die richtigen sind:<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"> <o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"> select channel_id, timestamp,value from data<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"> where from_unixtime(timestamp/1000) > ('2015-06-05 12:43:16')<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"> and from_unixtime(timestamp/1000) < ('2015-08-06 09:40:37')<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"> and channel_id > 12 and channel_id < 20;<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">Löschen:<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">delete from data<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"> where from_unixtime(timestamp/1000) > ('2015-06-05 12:43:16')<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"> and from_unixtime(timestamp/1000) < ('2015-08-06 09:40:37')<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"> and channel_id > 12 and channel_id < 20;<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black"><o:p> </o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">Gruss<o:p></o:p></SPAN></PRE><PRE><SPAN style="COLOR: black">Friedrich <o:p></o:p></SPAN></PRE></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10.5pt; COLOR: black"><o:p> </o:p></SPAN></P></DIV>
<DIV
style="BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; BORDER-BOTTOM: medium none; PADDING-BOTTOM: 0cm; PADDING-TOP: 3pt; PADDING-LEFT: 0cm; BORDER-LEFT: medium none; PADDING-RIGHT: 0cm">
<P class=MsoNormal><B><SPAN style="COLOR: black">Von: </SPAN></B><SPAN
style="COLOR: black">fambesse <<A
href="mailto:thomas@fambesse.de">thomas@fambesse.de</A>><BR><B>Antworten
an: </B>"volkszaehler.org - users" <<A
href="mailto:volkszaehler-users@demo.volkszaehler.org">volkszaehler-users@demo.volkszaehler.org</A>><BR><B>Datum:
</B>Mittwoch, 23. August 2017 09:42<BR><B>An: </B><<A
href="mailto:volkszaehler-users@lists.volkszaehler.org">volkszaehler-users@lists.volkszaehler.org</A>><BR><B>Betreff:
</B>[vz-users] Daten aus Datenbank löschen<o:p></o:p></SPAN></P></DIV>
<DIV>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10.5pt; COLOR: black"><o:p> </o:p></SPAN></P></DIV>
<DIV>
<DIV>
<P class=MsoNormal><SPAN style="COLOR: black">Hallo zusammen,
<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">leider ist mein SQL etwas
eingerostet und ich hoffe hier kann mir jemand helfen. <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Ich möchte gerne von einem Tag
bzw. zwischen zwei Tagen oder zwei Timestamps die Daten
löschen.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Hier haben sich bei mir an einem
Tag falsche Werte eingeschlichen. <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black"> <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Folgendes habe ich habe ich
schon probiert:<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt; BORDER-TOP: windowtext 1pt; FONT-FAMILY: inherit; BORDER-RIGHT: windowtext 1pt; BACKGROUND: #eff0f1; BORDER-BOTTOM: windowtext 1pt; COLOR: #101094; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm; PADDING-LEFT: 0cm; BORDER-LEFT: windowtext 1pt; PADDING-RIGHT: 0cm; mso-fareast-language: DE"> </SPAN><SPAN
style="COLOR: black"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt; BORDER-TOP: windowtext 1pt; FONT-FAMILY: inherit; BORDER-RIGHT: windowtext 1pt; BACKGROUND: #eff0f1; BORDER-BOTTOM: windowtext 1pt; COLOR: #101094; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm; PADDING-LEFT: 0cm; BORDER-LEFT: windowtext 1pt; PADDING-RIGHT: 0cm; mso-fareast-language: DE">SELECT
* FROM 'data' WHERE `timestamp` BETWEEN '1502229600' AND
'1502316000';</SPAN><SPAN style="COLOR: black"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN lang=EN-US
style="FONT-SIZE: 10pt; BORDER-TOP: windowtext 1pt; FONT-FAMILY: inherit; BORDER-RIGHT: windowtext 1pt; BACKGROUND: #eff0f1; BORDER-BOTTOM: windowtext 1pt; COLOR: #101094; PADDING-BOTTOM: 0cm; PADDING-TOP: 0cm; PADDING-LEFT: 0cm; BORDER-LEFT: windowtext 1pt; PADDING-RIGHT: 0cm; mso-fareast-language: DE"> </SPAN><SPAN
style="COLOR: black"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Die Timestamps sollten der
09.08.2017 00:00:00 bis 10.08.2017 00:00:00 sein.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black">Besten Dank
vorab.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black"> <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN style="COLOR: black"> <o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: Courier; COLOR: black; mso-fareast-language: DE">----------------------------------------------------------</SPAN><SPAN
style='FONT-FAMILY: "Times New Roman",serif; COLOR: black'> </SPAN><SPAN
style="COLOR: black"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: Courier; COLOR: black; mso-fareast-language: DE">Thomas
Besse
</SPAN><SPAN
style='FONT-FAMILY: "Times New Roman",serif; COLOR: black'> </SPAN><SPAN
style="COLOR: black"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: Courier; COLOR: black; mso-fareast-language: DE">57250
Netphen
e-mail: <A
href="mailto:thomas@fambesse.de">thomas@fambesse.de</A> </SPAN><SPAN
style='FONT-FAMILY: "Times New Roman",serif; COLOR: black'> </SPAN><SPAN
style="COLOR: black"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-FAMILY: Courier; COLOR: black; mso-fareast-language: DE">----------------------------------------------------------</SPAN><SPAN
style="COLOR: black; mso-fareast-language: DE"> </SPAN><SPAN
style="COLOR: black"><o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="COLOR: black"> <o:p></o:p></SPAN></P></DIV></DIV></DIV></BLOCKQUOTE></BODY></HTML>