mysql - Python/Raspberry pi 3: comparing strftime time to integer time in database -


my goal have simple if statement compares actual time displayed on raspberry pi (for example, 5pm reads 1700 on pi), integer user has defined , stored in database. (for example, user inputted military time reading of 5pm in military time 1700, once submitted, integer value 1700 gets stored in database.

if users inputted time equal actual time, want print hello world or of sort.

i think problem having database integer not retuning value can compared strftime("%h%m") command... suggestions?

when print value of userin_time1 (variable assigned retrieve newest value in database, 2018), return value is:

(2018l,)

the command use actual time on pi strftime("%h%m") returns value:

2018

i thinking maybe parenthesis , l , comma messing logic edited strftime function this:

strftime("(%h%ml,)")

in doing this, code compiles , returns value:

(2018l,)

when assign both pi's time (strftime function) , users inputted time (userin_time1 function) new variable x , y respectively, , compare them using statement:

if(x==y): print 'hello world'

the code runs when condition met (the times line each other perfectly) nothing happens...

you can try this, 

from datetime import datetime time import gmtime, strftime  d = datetime.strptime("2018", "%h%m") db_time = d.strftime("%i:%m%p") #results '08:18pm' current_time = strftime("%i:%m:%p", gmtime()) if db_time == current_time:     print "time matched" else:     print "time not matched"

is expecting?


Comments

Post a Comment

Popular posts from this blog

How to put a lock and transaction on table using spring 4 or above using jdbcTemplate and annotations like @Transactional? -

i trying put lock on table while writing on table , if happened in between roll-back . trying convert below code lock table test_g1 read; lock table test_g write; -- begin; start transaction; insert test_g1 values(143); insert test_g values(145); select * test_g1; select * test_g; rollback; select * test_g; unlock tables; how convert above code @transactional spring jdbctemplate code? @transactional(rollbackfor={dataaccessexception.class}) public void test(){ jdbctemplate.execute("insert test1 (id, nam) values (4, 'a')"); throw new dataaccessexception("error") { }; } here trying throw error, insert statement should rollback it's not happening . thanks edit-1 attaching code , doing in jdbcdaoimpl.java , mentioned problem comment above test() . app.java package com.cgiri.javabrains.spring4; import org.springframework.beans.factory.annotation.autowired; import org.springframework.context.applic...
Read more

c# - Update a combobox from a presenter (MVP) -

i using mvp in project, new in mvp. have 2 comboboxes. when select option in combobox, combobox should filled new data. this action in presenter. view 'view1' in presenter, , introduced combobox1 , combobox2 properties in 'view1', because need 'datasource', 'displaymember', 'valuemember' , 'refresh()' in method below. but, when using pattern, enough send property like public string combobox2 { { return combobox1.selectedvalue.tosstring(); } } into presenter not whole combobox. how can solve problem? public void onselectedindexchangedcombobox1() { if (view1.combobox1.selectedindex == -1) { return; } datatable dt = tools.getdatatable("a path"); var query = (from o in dt.asenumerable() o.field<string>("afield") == farmerview.combobox1.selectedvalue.tostring() orderby o.field<string>("anotherfield") select...
Read more

How to understand 2 main() functions after using uftrace to profile the C++ program? -

i trying uftrace profile following simple c++ program: #include <iostream> class { public: a() {std::cout << "a created" << std::endl;} ~a() {std::cout << "a destroyed" << std::endl;} }; int main() { a; return 0; } the profile result this: # uftrace a.out created destroyed # duration tid function 2.026 [ 4828] | __cxa_atexit(); [ 4828] | main() { [ 4828] | __static_initialization_and_destruction_0() { 89.397 [ 4828] | std::ios_base::init::init(); 0.768 [ 4828] | __cxa_atexit(); 93.029 [ 4828] | } /* __static_initialization_and_destruction_0 */ 94.425 [ 4828] | } /* main */ [ 4828] | main() { [ 4828] | a::a() { 11.104 [ 4828] | std::operator <<(); 10.825 [ 4828] | std::basic_ostream::operator <<(); 24.514 [ 4828] | } /* a::a */ [ 4828] | a::~a() { 0.978 [ 4828] | ...
Read more