historian | Custom Timber tree implementation that can save logs | Database library

DECLARE @AT1Value INT,
        @AT1DateTime DateTime
SELECT  @AT1Value = Value,                              --GETS THE VALUES OF AT1 STERILISER
        @AT1DateTime = DateTime                         --GETS THE DATETIME OF AT1 STERILISER VALUES
From Runtime.dbo.v_History
Where 
    Runtime.dbo.v_History.Tagname = 'AT1_Select_ster'
AND Runtime.dbo.v_History.DateTime >= '2021-11-02 08:00'
AND Runtime.dbo.v_History.DateTime <= '2021-11-03 08:01'
AND Runtime.dbo.v_History.Value > 0


Select  a.DateTime,
        a.TagName,
        a.Value
From Runtime.dbo.v_History AS a        --GETS  THE VALUES OF THE FM TAGS AT THE DATETIME OF AT1 STERILISER VALUES
Where  
    ((a.TagName = 'FM_S1_Batch' AND a.Value = @AT1Value AND a.DateTime = @AT1DateTime)
OR  (a.Tagname = 'FM_S2_batch' AND a.Value = @AT1Value AND a.DateTime = @AT1DateTime)
OR  (a.Tagname = 'FM_S3_batch' AND a.Value = @AT1Value AND a.DateTime = @AT1DateTime)
OR  (a.Tagname = 'FM_S4_batch' AND a.Value = @AT1Value AND a.DateTime = @AT1DateTime))
AND a.Value > 0

<Routes>
          <Route path="galleria" element={<Gallery datas={data} clickEvent={handleSlideShow} />} />
          <Route path="/galleria/:urlPath" element={<Paint datas={data} />} />   
</Routes>

<Routes>
          <Route path="galleria" element={<Gallery datas={data} clickEvent={handleSlideShow} />}>
            <Route path="/galleria/:urlPath" element={<Paint datas={data} />} />
          </Route>
</Routes>

['ates test', 'TC-MSLBSecond', 'B8.L2s6_McIP.PER', 'BRamp', 'BRlation00001', 'BR.on0.0002', 'BR00003', 'BRtion00004', 'BR00005', 'Bation00006']

Input_URL =['https://servername:843/htorian-rest-api/v1/tags/properties/{Tags_Value}'.format(Tags_Value=Tags_Value)]

    Tags_Props = requests.get(url)
    json_obj = Tags_Props.json()
    return json.dumps(json_obj)

for url in Input_URL:
print return_json(url)

//Multicolor cards.
   Double Aether_Helix
   Double Beledros_Witherbloom
   Double Biomathematician
   165 Blade Historian
   166 Blood Researcher
   167 Blot Out the Sky
   168 Body of Research
   169 Closing Statement
   170 Cram Session
   171 Creative Outburst
   172 Culling Ritual
   173 Culmination of Studies
   174 Daemogoth_Titan
   175 Daemogoth_Woe-Eater
   176 Deadly_Brew
   177 Decisive_Denial
   178 Dina,_Soul_Steeper
   179 Double_Major
   180 Dramatic_Finale
   181 Elemental_Expressionist
   182 Elemental_Masterpiece
   183 Elemental_Summoning
   184 Eureka_Moment
   185 Exhilarating_Elocution
   186 Expressive_Iteration
   187 Fractal_Summoning
   188 Fracture
   189 Galazeth_Prismari
   190 Golden_Ratio
   

import discord
from discord.ext import commands

class JervisI(commands.Bot):
    def __init__(self, command_prefix, case_insensitive, botintents):
        self.command_prefix = command_prefix
        self.case_insensitive = case_insensitive
        self.botintents = botintents


J1 = JervisI(command_prefix="!", case_insensitive=True, botintents=discord.Intents.all())
J1.run("---HIDDEN TOKEN---")

Traceback (most recent call last):
  File "c:\Users\Bhavyadeep\Desktop\Discord Bot (Python)\PHub-Bot-1\jervis-1.py", line 12, in <module>
    J1.run("---HIDDEN TOKEN---")
  File "c:\Users\Bhavyadeep\Desktop\Discord Bot (Python)\PHub-Bot-1\The-Naval-Historian\lib\site-packages\discord\client.py", line 692, in run
    loop = self.loop
AttributeError: 'JervisI' object has no attribute 'loop'

DECLARE @ExpectedNumFlags AS INT = 3

  select count(*) as 'count'
  FROM
(
SELECT [Descript]
      ,[PValue]
      ,[uniqueID]
  FROM [MyBookLibraryDB].[dbo].[Historian]
  WHERE [Descript] = 'FLAG'
) AS t
INNER JOIN
(
  select count(*) as 'count'
  FROM
  (
    SELECT [Descript]
      ,[PValue]
      ,[uniqueID]
    FROM [MyBookLibraryDB].[dbo].[Historian]
    WHERE [Descript] = 'FLAG'
  ) AS z
 WHERE [PValue] = 'PASS'
 ) AS q
 on q.count = @ExpectedNumFlags -- this doesn't make sense

select  id from sqlth_te where tagpath like '%tagName%' --tagname is Param for SP

 --Result will be ID=153

SELECT  pname from sqlth_partitions where end_time >=1611489115070 and sqlth_partitions.start_time <= 1612127027358
--result [sqlt_data_1_2021_01] ,[sqlt_data_1_2021_02]

select floatvalue,t_stamp from sqlt_data_1_2021_01  where tagid='153' and t_stamp >=1611489115070--StartDate
union all
select floatvalue,t_stamp from sqlt_data_1_2021_02  where tagid='153'and t_stamp<=1612127027358--EndDate

const arr = [
  {
      "demo": [
          {
              "_id": "xx122",
              "name": "Historian",
              "tags": [
                  "demo"
              ],
              "things": [],
              "list": [],
              "queries": [],
              "notes": []
          }
      ],
      "demo_2": [
        {
            "_id": "xx123",
            "name": "Demo",
            "tags": [
                "demo_2"
            ],
            "things": [],
            "list": [],
            "queries": [],
            "notes": []
        }
    ],
  }
]


  const modArray = Object.keys(arr[0]).map(i => {
    return {id: i, ...arr[0][i]}
  });
    
  export default function Demo() {
    return (
        <div>
            <table className="table">
                <thead>
                    <tr>
                        {modArray.map((i) => (
                            <th key={i.id}>{i.id}</th>
                        ))}
                    </tr>
                </thead>
                <tbody>
                    <tr>
                        {modArray.map((items) => {
                            return Object.keys(items).map((key) => {
                                console.log(items[key]._id);
                                return <td key={items[key]._id}>{items[key]._id}</td>;
                            });
                        })}
                    </tr>
                </tbody>
            </table>
        </div>
    );
}

define(['knockout', 'dataservice'], (ko, dataservice) => {
return function () {
    let movies = ko.observableArray([]);
    let movieList = ko.observableArray([])
    let genres = ko.observableArray([]);
    let pageSizes = ko.observableArray();
    let prev = ko.observableArray();
    let next = ko.observableArray();
    let selectedPage = ko.observableArray([10]);
    self.selectedGenre = ko.observable();
    let objGenre = ko.observable();
    let movieGenres = ko.observable();

    self.selectedGenre.subscribe(() => {
        objGenre = selectedGenre().name;
        console.log(objGenre)
        });   

    console.log(chosenGenre)

    self.getMovies = function () {
        ko.mapping.fromJS(data.movies, {}, self.movies)
    }

    let getMovies = url => {
        dataservice.getMovies(url, data => {
            pageSizes(data.pageSizes);
            prev(data.prev || undefined);
            next(data.next || undefined);
            movieList(data.movieList);
            movieGenres(movieList.genre)
        });
    }
   
    let getGenres = function () {
        fetch('http://localhost:5001/api/genre')
            .then(function (response) {
                return response.json();
            })
            .then(function (data) {
                genres(data);

                console.log(genres());
            })
    };


    // INDSÆT GAMMEL FETCH

    let showPrev = movie => {
        console.log(prev());
        getMovies(prev());
    }

    let enablePrev = ko.computed(() => prev() !== undefined);

    let showNext = product => {
        console.log(next());
        getMovies(next());
    }

    let enableNext = ko.computed(() => next() !== undefined);

    selectedPage.subscribe(() => {
        var size = selectedPage()[0];
        getMovies(dataservice.getMoviesUrlWithPageSize(size));
    });


    document.getElementById("scrolltotop").addEventListener("click", function () {
        console.log("Clicked!");
        $('html,body').animate({scrollTop: $('#scrolltothisdiv').offset().top}, 1000);
    });

    document.getElementById("prevscrolltotop").addEventListener("click", function () {
        console.log("Clicked!");
        $('html,body').animate({scrollTop: $('#scrolltothisdiv').offset().top}, 1000);
    });

    getMovies();
    getGenres();

    self.optionsAfterRender = function (option, view) {
        if (view.defaultView) {
            option.className = 'defaultViewHighlight';
        }
    };


    return {
        pageSizes,
        selectedPage,
        movies,
        movieList,
        showPrev,
        enablePrev,
        showNext,
        enableNext,
        genres,
        optionsAfterRender,
        selectedGenre
    };
}

    <section class="after-head d-flex section-text-white position-relative">
    <div class="top-block top-inner container">
        <div class="top-block-content">
            <h1 class="section-title">Movies</h1>
            <div class="page-breadcrumbs">
                <a class="content-link" href="#">Home</a>
                <span class="text-theme mx-2"><i class="fas fa-chevron-right"></i></span>
                <span>Movies</span>
            </div>
        </div>
    </div>

</section>
<a id="topOfPage"></a>
<a id="top"></a>
<section class="section-long">   <!-- GENRES CONFIG HERE-->
    <div class="container">
        <div class="section-pannel">
            <div class="grid row">
                <div class="col-md-10">
                    <form autocomplete="off">
                        <div class="row form-grid">
                            <div class="col-sm-6 col-lg-3">
                                <div id="scrolltothisdiv"></div>
                                <div class="input-view-flat input-group">
                                    <select class="form-control" data-bind=
                                            "options: genres,
                                             optionsText: 'name',
                                             value: selectedGenre
                                          ">
                                    </select>
                                </div>
                            </div>
                            <div class="col-sm-6 col-lg-3">  <!-- START YEAR AND END YEAR HERE -->
                                <div class="input-view-flat date input-group" data-toggle="datetimepicker"
                                     data-target="#release-year-field">
                                    <input class="datetimepicker-input form-control" id="release-year-field"
                                           name="releaseYear" type="text" placeholder="release year"
                                           data-target="#release-year-field" data-date-format="Y"/>
                                    <div class="input-group-append">
                                        <span class="input-group-text"><i class="fas fa-calendar-alt"></i></span>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>

        <!-- WRAP DEN HER IN I KNOCKOUT ARRAY -->
        <table>

            <tbody>  <!-- FOR HVER FETCHED -->
            <tr>

                <td data-bind="foreach: movieList">
                    <article class="movie-line-entity"> <!-- HVER ARTICLE I TABLE HER CONFIG-->
                        <div class="entity-poster" data-role="hover-wrap"> <!-- HOVER OVER BILLEDER -->
                            <div class="embed-responsive embed-responsive-poster">
                                <img class="embed-responsive-item" data-bind="attr:{src: poster}" alt=""/>
                                <!-- BILLEDE SRC HER -->
                            </div>
                            <div class="d-over bg-theme-lighted collapse animated faster"
                                 data-show-class="fadeIn show" data-hide-class="fadeOut show">
                                <div class="entity-play">  <!-- NEDENSTÅENDE ER LOGO -->
                                    <svg width="1em" height="1em" viewBox="0 0 16 16"
                                         class="bi bi-box-arrow-up-right" fill="currentColor"
                                         xmlns="http://www.w3.org/2000/svg">
                                        <path fill-rule="evenodd"
                                              d="M8.636 3.5a.5.5 0 0 0-.5-.5H1.5A1.5 1.5 0 0 0 0 4.5v10A1.5 1.5 0 0 0 1.5 16h10a1.5 1.5 0 0 0 1.5-1.5V7.864a.5.5 0 0 0-1 0V14.5a.5.5 0 0 1-.5.5h-10a.5.5 0 0 1-.5-.5v-10a.5.5 0 0 1 .5-.5h6.636a.5.5 0 0 0 .5-.5z"/>
                                        <path fill-rule="evenodd"
                                              d="M16 .5a.5.5 0 0 0-.5-.5h-5a.5.5 0 0 0 0 1h3.793L6.146 9.146a.5.5 0 1 0 .708.708L15 1.707V5.5a.5.5 0 0 0 1 0v-5z"/>
                                    </svg>
                                </div>
                            </div>
                        </div>
                        <div class="entity-content">
                            <h4 class="entity-title">
                                <a class="content-link" href="movie-info-sidebar-right.html"><span
                                        data-bind="text: title_name"></span></a>
                            </h4>
                            <div data-bind="foreach: genre">
                                <div class="entity-category">
                                    <a class="content-link" href="movies-blocks.html"><span
                                            data-bind="text: $data"></span></a>,
                                </div>
                            </div>
                            <div class="entity-info">
                                <div class="info-lines"> <!--  RATING -->
                                    <div class="info info-short">
                                        <span class="text-theme info-icon"><i class="fas fa-star"></i></span>
                                        <span class="info-text"><span data-bind="text: rating"></span></span>
                                        <span class="info-rest">/10</span>
                                    </div>
                                    <div class="info info-short"> <!-- RUNTIME -->
                                        <span class="text-theme info-icon"><i class="fas fa-clock"></i></span>
                                        <span class="info-text"><span data-bind="text: runtime"></span></span>
                                        <span class="info-rest">&nbsp;<span>min</span></span>
                                    </div>
                                </div>
                            </div>
                            <p class="text-short entity-text">
                                <span data-bind="text: plot"></span>
                            </p>
                        </div>
                    </article>
                </td>
            </tr>
            </tbody>
        </table>


        <div class="section-bottom"> <!-- PAGING CONFIG HER -->
            <div class="paginator">
                <div class="navigation-buttons">
                    <button id="prevscrolltotop" onclick="scrolltotop" type="button"  class="btn btn-inverse btn-warning" data-bind="click: showPrev, enable: enablePrev" href="#"> Prev</button>
                    <button id="scrolltotop" onclick="scrolltotop" type="button" class="btn btn-warning btn-rounded" data-bind="click: showNext, enable: enableNext" href="#">Next</button>
                </div>
            </div>
        </div>

      
    </div>
</section>

{
"pageSizes": [
    5,
    10,
    15,
    20
],
"count": 55076,
"pages": 2754,
"prev": null,
"next": "http://localhost:5001/api/title?page=1&pageSize=20",
"movieList": [
    {
        "title_id": "tt0052520",
        "title_name": "The Twilight Zone",
        "poster": "https://m.media-amazon.com/images/M/MV5BNTAzMDI5MzgtMGNkMC00MzllLWJhNjctNjA1NmViNGUxMzYxXkEyXkFqcGdeQXVyMTQxNzMzNDI@._V1_SX300.jpg",
        "plot": "Ordinary people find themselves in extraordinarily astounding situations, which they each try to solve in a remarkable manner.",
        "runtime": "51",
        "genre": [
            "Fantasy",
            "Horror",
            "Drama"
        ],
        "votes": "68643",
        "rating": "9.0",
        "type": "tvSeries",
        "url": "http://localhost:5001/api/title/tt0052520"
    },
    {
        "title_id": "tt0063929",
        "title_name": "Monty Python's Flying Circus",
        "poster": "https://m.media-amazon.com/images/M/MV5BMWY2ZGI0OGUtZDc3YS00ZmVjLWJiNWQtZDdmNzFmM2UzYWFhXkEyXkFqcGdeQXVyNTA4NzY1MzY@._V1_SX300.jpg",
        "plot": "The irreverent Monty Python comedy troupe present a series of skits which are often surreal, bawdy, uncompromising and/or tasteless, but nearly always hilarious.",
        "runtime": "30",
        "genre": [
            "Comedy"
        ],
        "votes": "65618",
        "rating": "8.8",
        "type": "tvSeries",
        "url": "http://localhost:5001/api/title/tt0063929"
    },
    {
        "title_id": "tt0078672",
        "title_name": "Pride and Prejudice",
        "poster": "https://m.media-amazon.com/images/M/MV5BMjA5MTg2OTYyN15BMl5BanBnXkFtZTcwMzAwODUyMQ@@._V1_SX300.jpg",
        "plot": "Mrs. Bennet is determined to find husbands for her five daughters. The arrival of a new wealthy neighbor seems like the answer to her predicament. But while eldest daughter Jane catches Mr. Bingley''s eye, middle child Mary has her nose stuck in a book, and youngest girls, Kitty and Lydia, chase after officers in uniform; Elizabeth, the willful, intelligent, and opinionated second daughter, is snubbed by haughty gentleman Mr. Darcy... In this class-minded society, can love triumph over pride and prejudice?",
        "runtime": "265",
        "genre": [
            "Romance",
            "Comedy",
            "Drama"
        ],
        "votes": "2128",
        "rating": "7.3",
        "type": "tvMiniSeries",
        "url": "http://localhost:5001/api/title/tt0078672"
    },
    {
        "title_id": "tt0088634",
        "title_name": "The Twilight Zone",
        "poster": "https://m.media-amazon.com/images/M/MV5BOTc4YjU0ZDktNzE2Ny00MDdmLWIwZDQtMzU2NzhmODA4YmMwXkEyXkFqcGdeQXVyNjExODE1MDc@._V1_SX300.jpg",
        "plot": "An updated version of the famous 1960''s TV series created by Rod Serling. Each week presents one to three tales about some unusual situation that turns out to be even more unusual than initially suspected. Whether the tone of the story is horror, suspense or humor, there is always a surprise twist at the end.",
        "runtime": "45",
        "genre": [
            "Fantasy",
            "Horror",
            "Drama"
        ],
        "votes": "9822",
        "rating": "7.8",
        "type": "tvSeries",
        "url": "http://localhost:5001/api/title/tt0088634"
    },
    {
        "title_id": "tt0098286",
        "title_name": "Good News, Bad News",
        "poster": "N/A",
        "plot": "In this episode, the predecessor to Seinfeld (1989), Jerry is expecting a woman that he met in Michigan to come and visit him in New York. Throughout the first part of the show Jerry and George are discussing the situation. Later we meet \"Kessler\" who comes in to Jerry''s apartment to borrow some meat and uncharacteristically knocks on the door before entering.",
        "runtime": "23",
        "genre": [
            "Comedy"
        ],
        "votes": "3501",
        "rating": "7.6",
        "type": "tvEpisode",
        "url": "http://localhost:5001/api/title/tt0098286"
    },
    {
        "title_id": "tt0098769",
        "title_name": "The Civil War",
        "poster": "https://m.media-amazon.com/images/M/MV5BZDc1NzI2MGEtZDA2Yy00ZWExLTgwYmItNjU3N2QyYmM0MzYwXkEyXkFqcGdeQXVyNTA4NzY1MzY@._V1_SX300.jpg",
        "plot": "This highly acclaimed mini series traces the course of the U.S. Civil War from the abolitionist movement through all the major battles to the death of President Lincoln and the beginnings of Reconstruction. The story is mostly told in the words of the participants themselves, through their diaries, letters, and Visuals are usually still photographs and illustrations of the time, and the soundtrack is likewise made up of war-era tunes played on period instruments. Several modern-day historians offer periodic comment and insight on the war''s causes and events.",
        "runtime": "680",
        "genre": [
            "History",
            "War",
            "Documentary"
        ],
        "votes": "13075",
        "rating": "9.0",
        "type": "tvMiniSeries",
        "url": "http://localhost:5001/api/title/tt0098769"
    }

define([], () => {
const movieApiUrl = "api/title";
const genreApiUrl = "api/genre";


let getJson = (url, callback) => {
    fetch(url).then(response => response.json()).then(callback);
};

let getMovies = (url, callback) => {
    if (url === undefined) {
        url = movieApiUrl;
    }
    getJson(url, callback);
};

let getGenres = (url, callback) => {
    if(url === undefined) {
        url = genreApiUrl;
    }
    getJson(url, callback)
};

let getMoviesUrlWithPageSize = size => movieApiUrl + "?pageSize=" + size;


return {
    getMovies,
    getMovie: getJson,
    getMoviesUrlWithPageSize,
    getGenres
};