sonic | 🦔 Fast, lightweight & schema-less search backend. An alternative to Elasticsearch that runs on a fe | Search Engine library

library(tidyverse)

library(openintro)

library(lm.beta)

fastfood <- openintro::fastfood

head(fastfood)

fastfood.corr <- cor(fastfood$calories, fastfood$total_fat, fastfood$sugar, fastfood$calcium,use="pairwise.complete.obs" ,method = "pearson")

float* ptr = vec.data();
int num_samples = sonicChangeFloatSpeed(ptr, vec.size(), 1., 1.5, 1., 1., 0, 41000, 1);
vec.assign(ptr, ptr + num_samples);

$date = (Get-Date).tostring("yyyy.MM.dd.")

$dbserver = "server"
$dbdatabase = "database"
$dbuser = "user"
$dbpass = "password"
$conn = New-Object system.data.sqlclient.sqlconnection
$conn.connectionstring = "server=$dbserver;database=$dbdatabase;user id=$dbuser;password=$dbpass;"

$query = @"
SELECT DISTINCT
    ORS.Reference2 AS 'CDL OrderID',
    ORS.PKID AS 'Sonic Tracking',
    D.DisplayCode AS 'HUB',
    ZRZ.RouteID AS 'Default Route',
    ORS.ROUTEID AS 'Assigned Route',
    CAST(ORS.CREATEDWHEN AS DATE) AS 'Order Created Date',
    p2.createdwhen  AS 'RECEIVE Scan Date',
    CASE WHEN p2.createdby like 'driver 9[0-9][0-9][0-9]' then 'Y'
         ELSE ''    
         END AS 'Scanned?',
    ORS.POSTDATE AS 'Post Date',
    ors.pod AS 'POD',
    ORS.COMPLETEDTIME AS 'CompletedTime',
    (STUFF((SELECT ', ', EC.ExceptionDesc, ' ( Added: ',  OSC.createdWhen, ' By: ',OSC.createdBy, ') ' 
    FROM tblOrderRouteStops_StatusCodes OSC 
    LEFT JOIN tblexceptioncodes ec on osc.statuscode = ec.exceptionid
    WHERE OSC.ORSID = ORS.PKID 
    ORDER BY osc.createdwhen
    FOR XML PATH(''), TYPE).value('.', 'varchar(max)'), 1, 1, ' ') )
    AS  'Status Code'     

FROM tblOrderRouteStops ORS
    LEFT JOIN tblParcel P ON ORS.PKID = P.ORDERID and p.reference like '128%AP1'
    Left Join tblParcel p2 on p.reference = p2.reference and p2.createdby like 'driver 9[0-9][0-9][0-9]' 
    LEFT JOIN tblZones Z ON ORS.Zip = Z.Zip
    LEFT JOIN tblDepots D ON Z.DepotID = D.DepotID
    LEFT JOIN tblZonesRouteZones ZRZ ON Z.ZoneID = ZRZ.ZoneID AND ZRZ.ROUTELOOKUPID = 1
    LEFT JOIN tblOrderRouteStops_StatusCodes OSC ON ORS.PKID = OSC.ORSID
    LEFT JOIN tblExceptionCodes EC ON OSC.statusCode = EC.ExceptionID

WHERE 1=1
      
    AND ORS.CUSTID = 3919
    AND ORS.CREATEDWHEN > '2021-06-10'
    AND ORS.REFERENCE2 <> ''
      
ORDER BY ORS.pkid DESC

"@

$sqlcmd = New-Object system.data.sqlclient.sqlcommand
$sqlcmd.CommandText = $query
$sqlcmd.Connection = $conn
$sqladpt = New-Object system.data.sqlclient.sqldataadapter
$sqladpt.selectcommand = $sqlcmd
$data = new-object system.data.dataset
$sqladpt.fill($data)
$dataset = $data.Tables[0] 


#$wb = 'C:\Users\jthompson\Desktop\CDL Daily\' + $date + 'ReviewOrders.xlsx'
$wb = 'C:\Users\jthompson\Desktop\CDL Daily\test.xlsx'
$excel = new-object -ComObject excel.application
$excel.visible = $false
$excel.DisplayAlerts = $false
$wb = $excel.workbooks.open($wb)
$ws1 = $wb.worksheets.item(1)
$ws2 = $wb.worksheets.add()

$dataset | convertto-csv -notype -delimiter `t | clip
[void]$ws2.cells.item(1).pastespecial()

$ws2.usedrange.entirecolumn.autofit()
$ws1.UsedRange.horizontalalignment = -4131
$ws2.UsedRange.horizontalalignment = -4131
$ws2.columns.item(6).numberformat = "MM/dd/yyy"
$ws2.columns.item(7).numberformat = "MM/dd/yyy"
$ws2.columns.item(9).numberformat = "MM/dd/yyy"
$ws2.columns.item(1).numberformat = "0.000001"

//this will format it with the correct decimals, but does not change it from text to number  
$ws1.columns.item(1).numberformat = 0.000001


$wb.Save()
$wb.close()
$excel.Quit()
[System.Runtime.InteropServices.Marshal]::ReleaseComObject($excel)
Remove-Variable excel

# Your header should go here, each comment should be initialed -DK
import pygame, sys
import os
# https://youtu.be/jO6qQDNa2UY
pygame.init()
FPS = 60
# Useful Variables
  # Size

size = height, width = 900, 500
zonhw = zheight, zwidth = 70, 70
scale2 = height2, width2 = 600, 300
lscale = lheight, lwidth = 80, 80
beamsz = bheight, bwidth = 50,25
platz = pheight, pwidth = 10, 70
  # RGB 
white = (255, 255, 255)
black = (0,0,0)
blue = (0, 0, 128)
green = (0, 255, 0)
brown = (165,42,42)
  # Speed
VEL = 5
beamspeed = 3
  # Position
laserpos = posx, posy = 500,250
  #other
i = 0
life = 3
score = 0


# graphics
screen = pygame.display.set_mode(size)
pygame.display.set_caption("Zonic bootleg")
font = pygame.font.Font('freesansbold.ttf', 32)
zonic = pygame.image.load(os.path.join("image","zonic.gif"))
zonic = pygame.transform.scale(zonic, zonhw)
bg =  pygame.image.load(os.path.join("image","sonic-back.jpg"))
bg = pygame.transform.scale(bg, size)
gg = pygame.image.load(os.path.join("image","gg.jpg"))
gg= pygame.transform.scale(gg, size)
lazerz = pygame.image.load(os.path.join("image","Lazerz.gif"))
lazerz = pygame.transform.scale(lazerz, lscale)
beam = pygame.image.load(os.path.join("image","laserbeam.jpg"))
beam = pygame.transform.scale(beam, beamsz)
lives = pygame.image.load(os.path.join("image","health.png"))
lives = pygame.transform.scale(lives,(40,40))
# zoncz = pygame.image.load(os.path.join("image","zoncz.png"))
# zoncz = pygame.transform.scale(zoncz, scale2)




#coalitions 
def collider(life,beamrect,zonicrect,lazerect): 
  beamrect.x -= beamspeed
  if zonicrect.colliderect(beamrect):
    beamrect.x = lazerect.x+21
    zonicrect.x = 0
    
  if beamrect.x <-60:
    #screen.blit(beam, (posx, posy))
    beamrect.x += 550
  
def updating(score, beamrect):
  if beamrect.x == 0:
    score += 1



#Death
def death():
  while life <= 0:
    death = font.render("Death", True, white)
    screen.fill(black)
    screen.blit(death,(250, 250))
  
# zonic movement
def KWS(keyvar, zonicrect,flip):
  
  if keyvar[pygame.K_RIGHT]:  # right
    zonicrect.x += VEL
    flip = False
  if zonicrect.x > 500:
    zonicrect.x -= VEL
    
  if keyvar[pygame.K_LEFT] and zonicrect.x + VEL > 0:  # left
    zonicrect.x -= VEL
    flip = True
  
def flipx(flip,zonicrect):
  if flip:
    screen.blit(pygame.transform.flip(zonic,True,False),(zonicrect.x,zonicrect.y))
  if flip == False:
      screen.blit(pygame.transform.flip(zonic,False,False),(zonicrect.x,zonicrect.y))

  

    
# text = font.render('Lives: {0}'.format(life), True, green, blue)
def heart(beamrect,zonicrect,lazerect):
    x = 1
    i = -33
    while life >= x:
      x +=1 
      i+=32
      screen.blit(lives, (2+i,0))

# draw
def drawingfunc(zonicrect,lazerect, beamrect,flip, zonczrect):
    #screen.blit(death,(0,0))
    screen.blit(bg, (0, 0))
    heart(beamrect,zonicrect,lazerect)
    flipx(flip,zonicrect)
    #screen.blit(zonic,(zonicrect.x, zonicrect.y))
    screen.blit(beam, (beamrect.x, beamrect.y+15))
    screen.blit(lazerz, (lazerect.x+21,lazerect.y))
    # score = font.render('Score: ') 
    # screen.blit(zonic, (zonczrect.x, zonczrect.y))
    sore = font.render("Score: {0}".format(score), True, black, white)
    screen.blit(sore, (30, 70))
    pygame.draw.rect(screen, brown, pygame.Rect(200, 200, 100, 50))
    pygame.display.update()


   
          


# mainloop and refresh rate
def main():
    jump = False
    jumpCount = 0
    jumpMax = 15
    flip = False
    zonicrect = pygame.Rect(10, 250, zheight, zwidth)
    lazerect = pygame.Rect(posx, posy, lheight, lwidth)
    beamrect = pygame.Rect(posx, posy, bheight, bwidth)
    zonczrect = pygame.Rect(50, 25, height2, width2)
    
    # (30,0,32,32)
    # livesrect = pygame.Rect(0,0,10,10)
    
    
    
      
    
    clock = pygame.time.Clock()
    run = True
    while run:
        clock.tick(FPS)
         
        
        
        for event in pygame.event.get():
            if event.type == pygame.QUIT:
                run = False
            if event.type == pygame.KEYDOWN:
              if not jump and event.key == pygame.K_SPACE:
                  jump = True
                  jumpCount = jumpMax 
  
        
        death()
        collider(life,beamrect,zonicrect,lazerect)
        keyspressed = pygame.key.get_pressed()
        KWS(keyspressed, zonicrect,flip)
        updating(score, beamrect)        
        drawingfunc(zonicrect,lazerect, beamrect,flip, zonczrect)
        flipx(flip, zonicrect)
        
        if jump:
            zonicrect.y -= jumpCount
            if jumpCount > -jumpMax:                                                              
              jumpCount -= 1                                                              
            else:
              jump = False

    pygame.quit()                                                              
                                                              

# calling function NOTE: needs to always be at the end of file
if __name__ == "__main__":
  main()

#include 
#include 
#include 
#include 
using namespace std;

int main() {
    while (true) {
        enum fields { KEY, HINT, Locked };
        const int NUM_WORDS = 10;
        const string WORDS[NUM_WORDS][Locked] = {

            {"MITCHELL", "NICKNAME IS MITCH,SO WHAT IS MY NAME?"},
            {"PIZZA", "MY FAVORITE FOOD, IS ITALY."},
            {"ROYCE", "SOME TUMBLE AND SOME ROLLS...?"},
            {"INFINITY", "THE IMAGINARY NUMBER IS?"},
            {"AMY", "FAVORITE SONIC CHARACTER IS ?"},
            {"FIAT", "CRYPTO OVER; THIS TYPE OF CURRENCY?"},
            {"RUSSIA", "SAINT PETERSBURG IS IN ?"},
            {"DONETELLO", "TEENAGE MUTANT NINJA TURTLES"},
            {"SON", "BROOKLYN PEOPLE SAY THIS WORD"},
            {"FUN", "FEELING HAPPY"}

        };
        srand(static_cast(time(0)));
        int choice = (rand() % NUM_WORDS);
        string theWord = WORDS[choice][KEY];   // GUESSING THE WORDS
        string theHint = WORDS[choice][HINT];  // Hint for Words

        // Randomizing using the string; swapping charcters equal to the length of the words
        string Jumble = theWord;  // jumbled version of word
        int length = Jumble.size();
        for (int i = 0; i < length; ++i) {
            int index1 = (rand() % length);  // Random
            int index2 = (rand() % length);  // Random
            char temp = Jumble[index1];
            Jumble[index1] = Jumble[index2];  // Swapping charcters
            Jumble[index2] = temp;
        }
        cout << "\t\t\Welcome to Word Jumble!\n\n";  // USING CARRIAGE RETURN; USING TITLE
        cout << "Unscramble the letters to make a word.\n";
        cout << "Enter 'hint' for a hint.\n";
        cout << "Enter 'quit' to quit the game.\n\n";
        cout << "The jumble is:" << Jumble;
        string guess;
        cout << "\n\nYour guess:";
        cin >> guess;

        while ((guess != theWord) && (guess != "quit")) {
            if (guess == "hint") {
                cout << theHint;
            } else {
                cout << "Sorry, that's not it.";
            }
            cout << "\n\nYour guess:";
            cin >> guess;
        }
        if (guess == theWord) {
            cout << "\nTHat's it! You guessed it!\n";
        }

        cout << "\nThanks for playing.\n";
        return 0;
    }
}

const _questions = [
  {
    'question': 'How long is New Zealand’s Ninety Mile Beach?',
    'answers': [
      '88km, so 55 miles long.',
      '55km, so 34 miles long.',
      '90km, so 56 miles long.'
    ],
    'answer': 1,
  },
  {
    'question':
        'In which month does the German festival of Oktoberfest mostly take place?',
    'answers': ['January', 'October', 'September'],
    'answer': 2,
  },
  {
    'question': 'Who composed the music for Sonic the Hedgehog 3?',
    'answers': [
      'Britney Spears',
      'Timbaland',
      'Michael Jackson',
    ],
    'answer': 1,
  },
]

class QuestionNumber with ChangeNotifier {
List answerlist= [1, 2, 1];
}

class Player(pygame.sprite.Sprite):
    def __init__(self):
        super().__init__()
        #[...]

    def update(self):
        hits_4 = pygame.sprite.collide_rect(player, platform4)
            if self.vel.y > 0:        
                if hits_4:
                    if self.pos.y < hits_4[0].rect.bottom:               
                        self.pos.y = hits_4[0].rect.top +1
                        self.vel.y = 0
    def jump(self):
        hits4 = pygame.sprite.collide_rect(self, platform4)
        if hits4:
            self.vel.y = -15 // 2

import requests, json, sqlite3, os, csv, datetime, re
from google.cloud import bigquery
#from google.cloud import storage

list_city = []
with open("list_of_cities.txt", "r") as pointer:
    for line in pointer:
        list_city.append(line.strip())

API_key = "PLACEHOLDER"
Base_URL = "http://api.weatherapi.com/v1/history.json?key="

yday = datetime.date.today() - datetime.timedelta(days = 1)
Date = yday.strftime("%Y-%m-%d")

table_id = f"sonic-cat-315013.weather_data.Historical_Weather_{yday.isocalendar()[0]}_{yday.isocalendar()[1]}"

credentials_path = r"PATH_TO_JSON_FILE"
os.environ["GOOGLE_APPLICATION_CREDENTIALS"] = credentials_path

client = bigquery.Client()

try:
    schema = [
        bigquery.SchemaField("city", "STRING", mode="REQUIRED"),
        bigquery.SchemaField("Date", "Date", mode="REQUIRED"),
        bigquery.SchemaField("Hour", "INTEGER", mode="REQUIRED"),
        bigquery.SchemaField("Temperature", "FLOAT", mode="REQUIRED"),
        bigquery.SchemaField("Humidity", "FLOAT", mode="REQUIRED"),
        bigquery.SchemaField("Condition", "STRING", mode="REQUIRED"),
        bigquery.SchemaField("Chance_of_rain", "FLOAT", mode="REQUIRED"),
        bigquery.SchemaField("Precipitation_mm", "FLOAT", mode="REQUIRED"),
        bigquery.SchemaField("Cloud_coverage", "INTEGER", mode="REQUIRED"),
        bigquery.SchemaField("Visibility_km", "FLOAT", mode="REQUIRED")
    ]


    table = bigquery.Table(table_id, schema=schema)
    table.time_partitioning = bigquery.TimePartitioning(
        type_=bigquery.TimePartitioningType.DAY,
        field="Date",  # name of column to use for partitioning
    )
    table = client.create_table(table)  # Make an API request.
    print(
        "Created table {}.{}.{}".format(table.project, table.dataset_id, table.table_id)
    )
except:
    print("Table {}_{} already exists".format(yday.isocalendar()[0], yday.isocalendar()[1]))

    
def get_weather():
    try:
        x["location"]
    except:
        print(f"API could not call city {city_name}")
        
    global day, time, dailytemp, dailyhum, dailycond, chance_rain, Precipitation, Cloud_coverage, Visibility_km    
    
    day = []
    time = []
    dailytemp = []
    dailyhum = []
    dailycond = []
    chance_rain = []
    Precipitation = []
    Cloud_coverage = []
    Visibility_km = []
    
    for i in range(24):
        dayval = re.search("^\S*\s" ,x["forecast"]["forecastday"][0]["hour"][i]["time"])
        timeval = re.search("\s(.*)" ,x["forecast"]["forecastday"][0]["hour"][i]["time"])
       
        day.append(dayval.group()[:-1])
        time.append(timeval.group()[1:])
        dailytemp.append(x["forecast"]["forecastday"][0]["hour"][i]["temp_c"])
        dailyhum.append(x["forecast"]["forecastday"][0]["hour"][i]["humidity"])
        dailycond.append(x["forecast"]["forecastday"][0]["hour"][i]["condition"]["text"])
        chance_rain.append(x["forecast"]["forecastday"][0]["hour"][i]["chance_of_rain"])
        Precipitation.append(x["forecast"]["forecastday"][0]["hour"][i]["precip_mm"])
        Cloud_coverage.append(x["forecast"]["forecastday"][0]["hour"][i]["cloud"])
        Visibility_km.append(x["forecast"]["forecastday"][0]["hour"][i]["vis_km"])
    for i in range(len(time)):
        time[i] = int(time[i][:2])

def main():
    i = 0
    while i < len(list_city):
        try:
            global city_name
            city_name = list_city[i]
            complete_URL = Base_URL + API_key + "&q=" + city_name + "&dt=" + Date
            response = requests.get(complete_URL, timeout = 10)
            global x
            x = response.json()

            get_weather()
            table = client.get_table(table_id)
            varlist = []
            for j in range(24):
                variables = city_name, day[j], time[j], dailytemp[j], dailyhum[j], dailycond[j], chance_rain[j], Precipitation[j], Cloud_coverage[j], Visibility_km[j]
                varlist.append(variables)
                
            client.insert_rows(table, varlist)
            print(f"City {city_name}, ({i+1} out of {len(list_city)}) successfully inserted")
            i += 1
        except Exception as e:
            print(e)
            continue

dat1<-structure(list(artistName = c("Adele", "Mariah Carey", "D-Block Europe", 
"Wham!", "Ed Sheeran", "Adele", "Adele", "Elton John & Dua Lipa", 
"ArrDee", "GAYLE", "Ed Sheeran", "The Pogues", "Ed Sheeran", 
"Shakin' Stevens", "Leona Lewis", "Sam Fender", "Acraze", "Kelly Clarkson", 
"Joel Corry", "SwitchOTR"), name = c("Easy On Me", "All I Want For Christmas Is You", 
"Overseas (feat. Central Cee)", "Last Christmas", "Shivers", 
"Oh My God", "I Drink Wine", "Cold Heart (PNAU Remix)", "Flowers (Say My Name)", 
"abcdefu", "Bad Habits", "Fairytale of New York", "Overpass Graffiti", 
"Merry Christmas Everyone", "One More Sleep", "Seventeen Going Under", 
"Do It To It (feat. Cherish)", "Underneath the Tree", "I Wish (feat. Mabel)", 
"Coming for You (feat. A1 x J1)")), row.names = c(NA, 20L), class = "data.frame")

dat2<-structure(list(artistName = c("Adele", "Rod Wave", "Kodak Black", 
"Drake", "Nardo Wick", "Drake", "Adele", "Bruno Mars, Anderson .Paak & Silk Sonic", 
"Adele", "Summer Walker & SZA", "Mariah Carey", "GAYLE", "Drake", 
"Doja Cat", "Lil Nas X & Jack Harlow", "Taylor Swift", "The Kid LAROI & Justin Bieber", 
"Adele", "Summer Walker", "Drake"), name = c("Easy On Me", "By Your Side", 
"Super Gremlin", "Knife Talk (feat. 21 Savage & Project Pat)", 
"Who Want Smoke?? (feat. G Herbo, Lil Durk & 21 Savage)", "Way 2 Sexy (feat. Future & Young Thug)", 
"Oh My God", "Smokin Out The Window", "My Little Love", "No Love", 
"All I Want For Christmas Is You", "abcdefu", "Girls Want Girls (feat. Lil Baby)", 
"Need To Know", "INDUSTRY BABY", "All Too Well (10 Minute Version) (Taylor's Version) (From The Vault)", 
"STAY", "I Drink Wine", "Insane", "Fair Trade (feat. Travis Scott)"
)), row.names = c(NA, 20L), class = "data.frame")