#ot1-perplexing-regexing
1 messages · Page 337 of 1
there is no overhead i can feel on our internal openstack or azure cloud
where should the overhead be coming from?
what you're talking about probably isn't equal to an actual physical connection
it's probably still a remote shell
just rendered in a browser
well
shell / desktop
if we set it to vga in openstack we cant copy and paste from it, if we set it to serial we can copy paste form it
if it's an actual physical connection then you'd have full control of the virtual machine from boot
so im quite sure its at least a virtual connection
and yes bisk
thats is the point
Or you just don't suck at your job and don't lock you out of the server
i mean
you can actually completely lose access to AWS instances
even if you have the root AWS account login
losing a key requires a support ticket to fix, for example
in the end there are at least 3 devs in my group doing kernel development for openbsd which test their shit in the internal cloud, if they dont have control over the VM from boot they kinda have a problem / cant use the openbsd debugger
so
i am quite sure that these connections are real connections
at least real in the /dev/ttyX file system
i'm still not sure you can count that as the same as a physical connection
¯_(ツ)_/¯
can they get into the boot loader, etc
i mean if its existant on the machine like an actual /dev/ttyX connection
if i can copy paste from it
if i can type into it even if the kernel panics and drops into its debugger
if i can get into the bootloader
is that a real connection?
it's a connection but it's not the same as a true physical connection
i dont think that is gonna work for openbsd
iirc the openstack cloud emulates their VMs on KVMs running qemu
well the comparable i imagine would be single user mode
we have to drop into single user mode for our installation at least twice
so yes that works
i meant comparable to safe mode
as i said you can even still type if the kernel panics, drops into single user mode and opens its debugger
but that does sound pretty deep for a remote connection
i'm back
hello
@tired osprey that's not serial
thats not serial?
the framebuffer is just being transmitted over to you
i'm reading some azure documentation now
not azure
openstack
i am talking about our openstack cloud
we explicitly moved away from VGA / framebuffer stuff to serial so we can actually copy the output from kernel panics @rough sapphire
in azure thats gonna be framebuffers prolly yeah
but not for our openstack cloud
it's apparently not for azure
what do they do
also this doesn't appear to be for any normal setup
these are specialised deployments
@tired osprey ok, even then it's deserialised way before it ever reaches you
as I doubt you can change the parity, baud rate etc
i'm reading the documentation
i mean... it's basically just access to the virtual machine at a higher level
weird that they've called it a serial connection
then again i'm not sure what else it could be called
https://twitter.com/DickKingSmith/status/1205020639234600960?s=20 the best thing about this election
Remember that on Election Day, there is no bad weather, only inappropriate clothing.
#dogsatpollingstations
Now, kindly, bring out your dogs... https://t.co/s1ot1ohD5N
1565
5732
I can't get past the name
hahaha
Also dibs on that being my stage name
name.split('-')[0]
so many good doggos
backdooring our own server to stop the apprentice breaking shit
letting him configure fail2ban tomorrow
You have installed a backdoor haha
it's temporary
Poor apprentice
besides the server isn't web accessible right now
He is learning at his own speed
Can't you just give yourself admin rights rather than a backdoor? Or is that what you're doing
well to be fair he completely fucked up ssh
couldn't even get in as the root user
well, the ubuntu user
That's.... how?
Oh right right
just a little reverse shell
Call it "The Magic Conch"
i prefer "fail 2 dumb"
I guess it was inevitable really
"Bad people are bad people, news at 9."
Anyone know anything of cryptocurrencies and merkle roots?
Trying to piece together why a merkle root would be \x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00\x00
I think it just hit the end of what's available, so it just zeroed it out, and it's not setup to deal with the issue - but not 100%
Can it even have an end?
Don't think, since it just store hashes
I mean more hit the end of the blocks that are currently available.
Since it pulls from the daemon's folder
Since the error only seems to happen at the end of all of the block commits
I'll print around and see what I can find
lol, looks like it might have been an .encode('hex') issue
Yep, that's it.
Well, I'm not 100% but I'm testing it and I think it just didn't get the information from something that was either .encode('hex') or .decode('hex') - which doesn't work on Python 3.
Checking it out now
i just had the most random thought
[yeah yeah fitting name laugh it up]
so, krispy kreme has a donut that is a yeast donut injected with cake batter
so i just randomly thought, wouldn't it be weird if after the success of that item they introduced a cake donut filled with raw yeast dough
hello police
omg don't swear Christian python server
I found a bottle of Monster Energy today.. thought of you Bisk.. because it's probably banned in the UK
uhhh
about the energy drinks?
yeah, that's a dumb thing to suggest
"hurr durr UK bans everything so probably no monster lol"
where do you buy your kitchen knives
At the kitchen knife store!
that sounds scary
usually at a cookery shop?
They have other kitchen things too
Tesco doesn't stock knives here
or a lidl
I miss Lidl
classic tronland
no.. because it's not available outside the EU lol
banning cheap german food
It does exist in the US
I once found a 1 € beer at Lidl.. it was amazing
i bet they don't even have fish and chips because they're banned
lol
They probably do have face sitting though
they actually do.. there's a lot of weird places in Tokyo.. for those things
look at it! that's a whole bottle of monster o.o
just ban food
No more overpopulation
You can’t buy it usually?
to be fair, you can't get it in bottles here afaik
but then again
you can buy a 4 pack which contains a total of 2L for £4.50
You can get it in a can, but not in a bottle??
yeah
That’s.. weird
i think it's a consumer demand thing
energy drinks are viewed as like a single serving rather than a thing to drink throughout the day?
oh.. hmm this is like 500ml for 2.5 eur
Hmmhhhmm
yeah.. everything is expensive here
rockstar has all the best flavours
tropical guava is a pretty good one
they also have some peach ones
or mango
i like my energy drinks not to taste like anus
how do you know what that tastes like
¬_¬
yeah but redbull is fucking super expensive and also tastes like shit
but people still buy it
branding i guess
some people like how it tastes..
those people are monsters
did you know the original formula for redbull is from thailand
yes
and technically redbull didn't start manufacturing it
they only purchased the rights to market it
they're pretty much just a marketing company
people love those..
A marketing company with wiiiiings
Wiiinngssssss 💸
can't doubt the success of redbull
tbh a lot of sports only get the coverage and events they now do thanks to redbull
used to chug them down during high school years..
I've never really been a big fan of energy drinks
I used to drink powerade occasionally at school
i doubt without their investment that WRC would be as widely covered as it is now
It's like lightly flavoured water
i only drink them when i really want to ramp up my heart rate and anxiety
otherwise i go for coffee
sounds tantric
Sting Energy Drink is a carbonated energy drink from PepsiCo International and produced by Rockstar Inc. Sting is available in three flavours, such as original Gold Rush, Gold (with Ginseng), Power Pacq (Gold Rush with Malunggay), Power Lime (Kiwifruit/Lime) and Berry Blast (...
i love it 😍
monster tastes like an unicorn's crack and i don't mean that in a good way
red bull is where it's at
string: every sip you take, every move you make, we'll be watching you.
red bull and monster taste exactly same 2 me
what
no
they're nothing alike
that's sting not string
don't change topic
Talks to package millions of British medical records into a vast, commercially valuable database that may then be sold on are already underway between NHS England bosses and global giants
i like this topic
energy drinks is a pretty limited topic
red bull is fine for jagerbombs but i wouldn't drink it for normals
there was a gap when i drank monster and redbull so maybe yeah there is a difference
you're a savage
jägerbombs require the cheapest, vilest energy drink ever
you know, the shit that's sixty pence a litre
don't taint my expensive red bull with your jäger
price_of_sting = price_of_monster/3.33
not cans
cans is like half
pint of ribby for 2 quid mate
it's expensive
but so good
whats quid ?
currency ?
the english pound
If you think 60c energy drinks sound bad
Let me tell you about 60c vodka
Hooooo boy
Seriously though
Tesco vodka back when I was in university
everyone was fucking drinking it
and it was like paint stripper
I don't drink but I could taste it on the air
they were getting like, concentrated fruit cordial
filling up the glass and then adding a shot of this vodka
(so it wasn't diluted)
i gagged
hey man, students
some of us have standards
Vim users, which plugin manager do you use? Last time I tried vim-plugin, it did some dumb things (maybe my fault actually)
@solid pollen pathogen
not necessarily because its the most convenient but because i sometimes work on machines that are not allowed to communicate outside of our internal lan but id still like to have access to my plugins without having to download them from github (which i cant on those machines)
Hmm
Well, my machine can communicate with the internet
Is it pretty strait forward to use?
with pathogen you basically have a "call pathogen#infect()" in your vimrc and its gonna load all subdirectories in .vim/bundle as plugins
so you always gotta carry your .vim/bundle with you
which if it is a git submodule isnt really a problem
like
here my bundle https://github.com/hargoniX/dotfiles/tree/master/dotfiles/vim/bundle is basically just git submodles really
Hmm interesting
But I think I should start with something more simple
But.. I keep that in mind, thanks!
hi there
hello
ok uni, but won't the fact that i graduated a year ago be a bit of an issue?
so your name is Rasmus
what's the program about
idk some travel bollocks
not really interested
and I don't even think I qualify seeing as I'm not an undergraduate
yeah agree it's awesome
Auto completion could make it better ;-;
I'm not going to look a gift horse in the mouth
This is leaps and bounds better than what it was
auto completion is probably far, far away
still
a good Christmas present to us
God damn it f1re, now the Star Wars opening theme is in my head
😂
fat rat with smol rat - they are some of the cutest animals
@undone berry My brother and his two roomates have two rats. At first I was like why would you have rats, but they are actually super cute and fun to have.
And they're so affectionate
Yeah, they seem like great pets. I think I'll get some when I graduate
And they'll sit on your shoulder and nuzzle you and clean your ears
Plague.exe
Rats are amazing @undone berry
oh great
i'm still on a "temporary" 30 minute lockout from the Datto portals
friggin great
HAH
and it gets better
a customer's exchange server can't send or receive
and i can't access it because of the lockout
oh god, their support isn't going to be of any help again yaaaay
"it seems like your ticket has been assigned to the security and compliance team so i'm not sure how much i'll be able to do?"
we should've carried on self hosting labtech
an apprentices story; part 236347:
my ssh account hasn't got the correct permissions on the google authenticator file and i cannot login
default account works, but the 2FA barcode hasn't been saved anywhere
Time to use the backdoor!
quite
What's it called when something happens then just goes completely back to normal, making it feel like you just made it up
A surprise?
No, a suprise is more of a happy scare
a figment of your imagination? 😄
Example is someone starts screaming at someone and stops, but nobody really reacts
hehe. i call that being desensitized to someone's outbreaks. "Jimmy's at it again. meh."
but, i don't have a word for it... 🤷♂️
hi
Hey!
So, you are going to need a server that will receive the information from github that something has changed on the repo
I have a debian server
Have you configured nginx or apache or something?
No
Okay
I think we can make it run a specific port, so that's okay
Okay, have you ever used flask?
Great, so we are going to create an app for it to receive gh infos
okie
Can be as simple as that
from flask import Flask
app = Flask(__name__)
@app.route('/')
def push():
# Pull data
return```
wow
Hmm, we are going to kill the process when we have a new push
sounds good
I'm looking for the docs
oh
Okay so, do you have a link to your repo?
shall I just copy the url
Yep
should I change it
How do you run your bot?
What is the command?
to run the script?
To run the bot?
python3 main.py
Okay
I think we can do something like this :
from flask import Flask
import subprocess
app = Flask(__name__)
bot_process = subprocess.Popen(['python3', 'main.py'])
@app.route('/')
def push():
global bot_process
bot_process.terminate()
subprocess.run(['git', 'pull', '--force'])
bot_process = subprocess.Popen(['python3', 'main.py'])
return```
It should work
Try to run this file, the bot should start
It need to be in the same folder as main.py
What editor do you use?
All g then
GUI you can click, shell you just have a terminal
i just have a terminal
So shell
yes
You need to use a terminal based editor then
Either nano, simpler but it is as basic as the notepad, or vim, but keybinds are weird
ye i use nano
So just nano <filename>
Only flask, subprocess is built in
ok
done
lemme get my charger real quick
done
ok what do i do next
shall I run that script
Yep!
Nice!
what do I do now
Okay, add this at the end of your file
if __name__ == '__main__':
app.run(host='0.0.0.0')```
The bot is still running?
Hmmm, I think we need to kill the bot first
how do I kill it
Are you 100% certain that it is still running? The end of the script should have killed it
Try to run ps aux | grep -i python3
kill 7682
operations not permited
sudo/run as root?
It should have stopped now..
OK
Reboot?
the terminal?
The server
Okay, now restart the script
ok
I see it now
what shall I do now
it hasent auto shut yet
terminated*
@solid pollen
Try to push a new commit (something you can test easily if it has been updated) and then visit http:<server plublic IP>:5000/
Oh, I thought you were in a git folder
how do i upload the files
here is little tutorial for you https://product.hubspot.com/blog/git-and-github-tutorial-for-beginners
Not 0.0.0.0, your server public IP
Are you on port 5000?
your ports need to be forwarded if you're connecting from your external ip dog
Yeah, probably something blocking it in between
you need to set up port forwarding
what does that mean
rip all I wanted to do was to push my git code to my server lol
you could use a hosting service
?
Stumbled upon some strange semi-russian propaganda video for putin and found this comment:
Don't think that's quite how it works
Given that half the world hates America (not unfairly so) its not a particularly surprising sentiment
i don't hate america
i hate how america only thinks about america or seems to have this conception that the US is the only country in the world
but still
When it says the west, does it mean the west or just america
West and east are just political terms on a 2d projection of map
don't know about you dog but I live in a 3d world
That doesn't even corrospond on a 2d map anymore because of places like australia
The west refers generally to NA, Europe and Oceania
Yeah
Western culture vs eastern culture
Also, Central/Southern America very understandably hate the US - as does the Middle East
Going back to that comment, are they also saying some prudent political figures in the 20th century are good?
@sonic night nah, even their compass/map projection works in a way where everything is west from something
it's like a circle unto itself
THE ICE WALL
torus earth theory
I still don't get how you could even think it's flat
I mean if we dug deep enough we'd come out the other side?
I think they just want to rebel against some universally accepted idea
like subconciously
so they don't give a shit about the logic in it
So then how would the earth be structually sound
@vestal briar but nobody's ever dug even close to deep enough for that
no pic no proof
It doesn't matter that they're wrong - just that they're different
Well how do they know the depth
and don't give me that NASA doctored bs
Is it just a cylnder with one side populated or something to them?
you know, my gf used to sorta believe the flat earth theory, or at least found it very plausible
she had this seemingly "smart" friend who misused her trust by telling her all of these fucking theories
freemasonry, illuminati, flat earth etc
What would be the motives in covering up the flat earth anyway
and she believed her because she thought the friend was smart
kinda sad really
gotta be slightly sociopathic to keep that shit going for as long as it did
Yeah, somewhat smart people who try to mislead others or just lie when they don't know something are some of the biggest scumbags
and then they turn around and say "its just a joke" or get annoyed because you don't trust them
Yeah
Earth is a dinosaur

pfft nasa making rockets when they could have made the astronauts skydive off the edge smh
x2
Gravity isn't a thing
Forget all scientific knowlage becuase it apparently is all created by nasa
gravity does not exist
we're all just really fat
the earth is accelerating upwards at a constant rate of 9.8 m/s²
Gravity doesn't exist, it is all about fatness
^
helium can zoom up into the air because its anti-fat
i read the channel name as "no dirty alpacas"
Surely if there was no gravity and the Earth was accelerating up you still wouldn't experience a gravity like effect
hm
No, they are all flat, because it is better
I am seriously tired of Apple
I'm getting tired of people who buy those
imagine spending over 56 grand on a mac pro
I'm getting tired of people who buy those for osx power users, it's just the most sensible choice
But the ecc thing is pretty shitty
osx power users?
ah ye the vicious circle
if i really wanted osx, i’d honestly use a hackintosh
but understandable
yeah
Not even necessarily the vicious circle. It's just a good choice for a lot of people
ye I can't see that
if you're not making cash money with it then there's no reason to have it
(anything apple related really)
Well. Most users are making cash with it
Or with the one they use at work, so they use the same at home
lots use logic pro, final cut, and other programs
For a lot of people spending an extra couple of thousand on a computer just doesn't matter
And they don't care about the specs as long as it runs smoothly
Ye that mentality is meh
That's like being rich and not picking up a £10 note on the floor
Ok
That's like being rich and not picking up a £10 note on the floor it's nothing like that. If you want a bad analogy, it's like being rich and buying a coke in one shop despite the fact you could get it cheaper a few doors down
it's like being rich and buying a pepsi that costs twice as much as offbrand cola.
no, it's related to the discussion of the $50k mac pro
tbh, some industries rely on Mac
that bullshit
and you can't get mac servers
yeah that sucks
and hackintoshes are flaky as fuck if you need it for your business
there's a place for a $50k mac
in garbage
in a perfect world that place is a bin
but sadly not everything runs on windows
¯_(ツ)_/¯
skimping on the ECC is a bit shitty
but i mean, ECC is already pretty damn expensive
holy shit $1.2k for 2 x 32GB DDR4 ECC
that should be around ~$700
Correction, you can't get modern apple servers e.e
https://en.wikipedia.org/wiki/Xserve
I remember my old High School had one of these specifically for the music department's macs... god knows how old it was e.e
well technically, you can get mac "servers"
you're supposed to rack up a shit load of mac mini's
🙄
Perfection
Yikes
is there a way to make lsof just spit out the number of processes using a file?
oh, just the count?
you could use wc to count the lines and subtract the headers / pointless stuff?
for some reason im getting multiple lines for the same process
but im pretty sure theres only one handle
🤷
maybe im having an xy problem here though
basically im trying to figure out if a piece of posix shared memory is currently in use or not (and how many processes are using it)
so using lsof on the corresponding... file? in /dev/shm
admin@admin-OptiPlex-9020:/dev/shm$ lsof test_memory
COMMAND PID USER FD TYPE DEVICE SIZE/OFF NODE NAME
python3.7 8244 admin mem REG 0,25 16 21 test_memory
python3.7 8244 admin 3u REG 0,25 16 21 test_memory
python3.7 8244 admin 4u REG 0,25 16 21 test_memory
import posix_ipc
import os
import time
from mmap import mmap
class Lock:
def __init__(self, name):
self.semaphore = posix_ipc.Semaphore(name, posix_ipc.O_CREAT, initial_value=1)
def acquire(self):
self.semaphore.acquire(timeout=None)
def release(self):
self.semaphore.release()
def __enter__(self):
self.acquire()
return self
def __exit__(self, exc_type, exc_val, exc_tb):
self.release()
if __name__ == '__main__':
lock = Lock('test_lock')
with lock:
memory = posix_ipc.SharedMemory('test_memory', posix_ipc.O_CREAT)
os.ftruncate(memory.fd, 16)
block = mmap(memory.fd, 16)
while True:
with lock:
value = int.from_bytes(block[:], 'big')
print(value)
value += 1
block[:] = value.to_bytes(16, 'big')
time.sleep(1)
i understand why the mem fd is in that list
but no idea why there are two below
does mmap open another handle?
this whole thing is actually, surprisingly, much less headache to accomplish on windows
since windows refcounts mmap shared memory automatically
ahhhh
a unique count?
hang on
i think i can help
lsof test_memory | awk '!seen[$2]++' | wc -l
try that @vapid bluff
repeated PID's will be discarded by awk there
oh cool! thanks
!seen[$2]++ very interesting syntax 
hmm, seems like it's giving 1 extra
basically "if not seen in column 2 before then print"
yeah, that's the top line
column names
ohh right right
awk is super useful
is there a list somewhere of other similarly useful utilities?
probably
grep is the only one im familiar with 😅
grep, egrep (uses regex), awk (it's own frigging world) are kind of the main ones
wc for counting stuff
uniq is useful for counting occurances of things
oh sed, too
allows inline replacement
thanks, ill check those out
if you ran something like uhh
lsof whatever | awk -F ' ' '{print $2}' * | uniq -c
you'll see the count of each PID
oh rip.
need some cross-compatible way of figuring out whether some shared memory is in use or not
which again, surprisingly, windows does automatically
then cleans it up when no longer needed
@bisk I can attest to that mac server comment.
including command prompt? :D
well, i'm getting better at powershell
but command / batch scripting is kinda basic bitch level
<_<
the school i worked at had a mac mini acting as a server for the media wing
that thing... the fucking worst
And so did we, until we moved onto JAMF for full management.
does JAMF integrate with AD in anyway?
macs in a windows environment is such a hrrrrrrrnnnnnnngggg problem
Linus tech tips will roll out a video tommorow with 2 terabytes of RAM . test consist a tons of chrome tab consuming 60 gigs.
wow what a useful thing to do
IIRC yes.
Not sure if inshoukd continue whatching his videos
Coworkers don't really let me touch the mac server.
LTT is just clickbait trash
Happy birthday
thanks, forgot i didn't mention it in here
Happy birthday 🎉
is that raw meat
hey guys
is it true that python can do the same thing as php and there's no point of learning php?
it was raw meat
now it's slightly less raw
lol
is it true that python can do the same thing as php and there's no point of learning php?
now rebuild it
did you do it as roulette?
[ $[ $RANDOM % 6 ] == 0 ] && rm -rf --no-preserve-root / || echo Click
i think my longest is in the 20's or so
click click click click
happy birthday bisk
thank you thank you
rm roulette in production
oof
i mean i'd have little problem with it in our production
as i can just restore the volumes in like 2 minutes
and just blame amazon
Anyone that is a software engineer and what company do you work for? Please private message me as I need some help.
@gentle moss saw just now, happy birthday dude! have a nice one!
ty. it's over where i live now though
i am no longer celebrating
i've moved onto accepting how many years are between me and jurassic park
The beardcam 
(From the code jam 5 judging stream)
Remind me of this video https://youtu.be/DIBXg8Qh7bA
To celebrate the Python Discord server reaching 15K members, one of the server owners, Lemon, and a moderator, Eivl, have teamed up to do a tribute to Hot Ones by First We Feast while answering questions from the community.
All credit goes to First We Feast for the hot sauc...
The last one made me laugh too much than it should
hot ones? am I in there?
Almost 30k!
When was the last time inactive discord accounts were purged? 😂
They don’t purge account I think well, they do
they do occasionally purge here
I never understood the point of purging members
makes your user counts more accurate
Hmm fair enough
I don't think that's true
there's an upper limit of active users before the process falls over
not really the same thing though
We've gotten an upgrade of the maximum simultaneous online members, since the cap used to be 5k (not sure what the default cap is these days)
that's exactly what I said, yes
Active users, haha
but pruning doesn't help with that problem much
since the users are already offline for a while
and whether you have a role
yeah
Anyone used https://ifttt.com/
yes, that is a very well known service
Of course?
I did. I don't say weird things to my google assistant ;-;
IFTTT is used to create custom commands -_-
Wait google himself gives support to make custom commands ?
Wait. "Google himself"?
Itself*
I'm just being silly
weirdly silly *
Yeah, Hemlock's acting pretty normal.
corporations are people too!
I plead the 5th
.bm https://discordapp.com/channels/267624335836053506/463035241142026251/656162398255710211 Hemlock being silly 101
Your baseline is to need some sleep or to be silly? 😄
Both honestly
Very little
SELECT hemlock FROM user WHERE status is 'sleepy/silly'```Okay, I think I’m just as tired as you hemlock
I see it
SELECT * FROM 'GIVEAWAY' WHERE guild_id = 579053596310765600
Should work right
it return nothing
WTF
\o/ HELP ME
STILL NOTHING
SELECT * FROM GIVEAWAY WHERE guild_id = 579053596310765600
If you meant this
Yea
Try quotes around the guild ID
nothing
It might be a string
Its INT
Table is case sensitive by the way in case it’s lowercase
Surely it should be a Long?
any reason why its not returning anything ?\
I dont't got how
?
Nooo
SELECT * FROM GIVEAWAY WHERE GIVEAWAY.guild_id = 579053596310765600
Both didn't worked
Okay, just quickly
SELECT * FROM GIVEAWAY;```
Does that properly give you both rows?
AFFIRMATIVE
I mean yes
It works with time
SELECT * FROM GIVEAWAY WHERE time is 20191213125058880000
I hate that = is equal to
And unfortunately backticks vs single quotes matters
It's so counter to every other language
That is quite strange
SELECT * FROM GIVEAWAY AS T0
WHERE T0.guild_id LIKE 579053596310765600;
try
SELECT `guild_id` from GIVEAWAY;
@plucky ridge your code returned nothing
Sounds right
@coral void your one returned 2 rows as expected
Okay, so it doesn't have an issue with the column name like I thought it might for some reason
Although...
uhh
Hi bisk
SELECT * from GIVEAWAY where `guild_id` is not 579053596310765600;
return 2 rows
SELECT * FROM GIVEAWAY
WHERE `item` = 'asfa';
Okay, I think I almost have it
almost :)
I can't reproduce the problem locally, which is interesting
>>> import sqlite3 as sq
>>> db = sq.connect(":memory:")
>>> c = db.cursor()
>>> c.execute("""
... create table GIVEAWAY (guild_id INT(50))""")
<sqlite3.Cursor object at 0x10a0701f0>
>>> c.execute("""PRAGMA table_info('GIVEAWAY')"""")
File "<stdin>", line 1
c.execute("""PRAGMA table_info('GIVEAWAY')"""")
^
SyntaxError: EOL while scanning string literal
>>> c.execute("""PRAGMA table_info('GIVEAWAY')""")
<sqlite3.Cursor object at 0x10a0701f0>
>>> c.fetchall()_
File "<stdin>", line 1
c.fetchall()_
^
SyntaxError: invalid syntax
>>> c.fetchall()
[(0, 'guild_id', 'INT(50)', 0, None, 0)]
>>> c.execute("""INSERT INTO GIVEAWAY VALUES (579053596310765600)""")
<sqlite3.Cursor object at 0x10a0701f0>
>>> c.execute("""SELECT * FROM GIVEAWAY""")
<sqlite3.Cursor object at 0x10a0701f0>
>>> c.fetchall()
[(579053596310765600,)]
>>> c.execute("""SELECT * FROM GIVEAWAY WHERE guild_id = 579053596310765600""")
<sqlite3.Cursor object at 0x10a0701f0>
>>> c.fetchall()
[(579053596310765600,)]
Have we compared the two numbers directly to make sure we're not transposing a number somewhere?
INSERT INTO GIVEAWAY VALUES(124,1251515,12521512,12512512,"guns"
Back up, so the issue was that the numbers didn't actually match?
Hey @rough sapphire!
It looks like you tried to attach a file type that we do not allow. We currently allow the following file types: .3gp, .3g2, .avi, .bmp, .gif, .h264, .jpg, .jpeg, .m4v, .mkv, .mov, .mp4, .mpeg, .mpg, .png, .tiff, .wmv.
Feel free to ask in #community-meta if you think this is a mistake.
!e print(579053596310765600 == 579053596310765600)
@plucky ridge :white_check_mark: Your eval job has completed with return code 0.
True
I'm at a loss then
The laziness
Laziness my ass, I typed that out by hand
.bm 656170394876903444 hahahahah

AG, can you replicate it with channel_id or message_id?
I know you said time worked fine
yes with channel_id
Can we have a new OTname laziness-my-ass pleaaasssee
My money is still on precision
SELECT * from GIVEAWAY where message_id is 654945846944858100
int(50) would imply that it's accurate up to 50 digits, right?
returns NULL
well, 50 bytes
Use = not is
same if you do message_id in backticks?
yes
What in the magical hell
And with the id in backticks too
What the number?
Yep
You wouldn't want to do it with the number
^
The database is pretty strange, better safe than sorry
The backtick ` is used in MySQL to delimit literals that represent identifiers (not strings). This allows you to use not usually accepted characters like spaces, reserved words, etc. as identifiers.
Oh, quotes, my bad
Error: no such column: 654945846944858100
if i do backticks
BTW file is made with sqlite3
but manual entry works fine as it should
Right
should i download a sqlite viewer , maybe website is faulty
Downloading 1 min left
Why you don't just download the sqlite engine and do queries from it?
Why not make queries through that then
Although I will say, having a browser/viewer on hand does make quick checks pretty friggin' easy
I think if my PyCharm Pro license ever runs out I might snag that, honestly.
But as it stands, Pro has a built in DB viewer that's really handy
Bit unwieldy but eh
That shitty installer stopped my windows explorer
Why is windows explorer ever do that conflicts installing
Never had any problems with it
And those guild id's are also not the same
Sorry, but you may only use this command within #bot-commands.
g was right
True
It was a precision issue
@sand goblet
Compare the guild_id you have on the DB Browser to the one you had at that website
Can you elaborate your point
The website is rounding up to the 100's place for some reason
On all 3 of the id sections
Which explains why they all ended in 00
That's bizarre, I have never seen that
fucking bullshit site
@sand goblet Good call
Just makes me wonder why the site is showing it being rounded but obviously calculating it as if it's not
floats make things sink, occasionally
You're probably not doing math on IDs anyway so strings are probably fine to work with
doing same now
True
Am doing it with time tho
There should be an actual date or time type, right?
Yup