aleksejkozin

const testQuery = async query => {
  const pool = new sql.ConnectionPool({ // ... //})

  try {
    await pool.connect()
    return await pool.request().query(`
      BEGIN TRANSACTION
      ${query}
      ROLLBACK TRANSACTION
    `)

aleksejkozin

const {Pool} = require('pg')
const express = require('express')
const {auth, requiresAuth} = require('express-openid-connect')

const app = express()

// Enable OIDC support
// To login into the app use cirnotoss@gmail.com/Lol2021
app.use(
  auth({

aleksejkozin

SELECT *
FROM (
         SELECT IT.ID,
                ROW_NUMBER()
                        OVER (
                            PARTITION BY
                            IT.VendorId,
                            IT.ItemNumber,
                            I.StoreID
                            ORDER BY I.InvoiceDate DESC, IT.InvoiceID DESC

aleksejkozin

// Browsers.tsx

export function Browsers() {
  return <BrowsersList {...useBrowsers('https://google.com/myData.json')} />
}

// useBrowsers.ts

export function useBrowsers(url: string): BrowsersListProps {
  const {loading, data} = useFetch<FetchBrowsersResults>(url)

aleksejkozin

import {useState} from 'react'
import {Browser, BrowsersListProps} from '../components/BrowsersList'
import {useFetch} from '../../../hooks/useFetch'

export type FetchBrowsersResults = {
  Browsers: Browser[]
}

export function useBrowsers(url: string): BrowsersListProps {
  const {loading, data} = useFetch<FetchBrowsersResults>(url)

aleksejkozin

import {useEffect, useState} from 'react'
import {Alert} from 'react-native'

export type UseFetch<T> = {
  loading: boolean
  data?: T 
}

export function useFetch<T>(url: string): UseFetch<T> {
  const [loading, setLoading] = useState<boolean>(false)

aleksejkozin

export type FetchBrowsersResults = {
  Browsers: Browser[]
}

export type UseFetch<T> = {
  loading: boolean
  
  // We use Generic. T - is a type argument that can be any type.
  // We can useFetch() with any type
  // ? means, that T can be undefined

aleksejkozin

import {useEffect, useState} from 'react'
import {Browser, BrowsersListProps} from '../components/BrowsersList'

export function useBrowsers(url: string): BrowsersListProps {
  const [loading, setLoading] = useState(false)
  const [browsers, setBrowsers] = useState<Browser[]>([])
  const [selectedBrowser, setSelectedBrowser] = useState<Browser | undefined>(
    undefined,
  )

aleksejkozin

import React from 'react'
import {StyleSheet, View} from 'react-native'
import AddModal from '../../../components/AddModal'
import BrowserItem from '../../../components/BrowserItem'
import {UIFriendlyList} from '../../../components/UIFriendlyList'

const styles = StyleSheet.create({
  container: {
    justifyContent: 'center',
    alignItems: 'center',

aleksejkozin

import React from 'react'
import {FlatList, FlatListProps, Text} from 'react-native'
import LoadingIndicator from './LoadingIndicator'

export type UIFriendlyListProps<T> = FlatListProps<T> & {loading?: boolean}

export function UIFriendlyList<T>(props: UIFriendlyListProps<T>) {
  if (props.loading) {
    return <LoadingIndicator />
  }