search

akmolina28 / last-watch-ai

Self-hosted computer vision automation application
MIT License
63 stars 9 forks source link

Interface to edit automations #10

Open depuits opened 3 years ago

depuits commented 3 years ago

Currently the only way to edit the automations is through the sql database. It would probably be nice if we could edit those using the ui.

akmolina28 commented 3 years ago

Agreed. Edit/delete for automations is on my to-do list.

jaycrossler commented 3 years ago

Just notes for anyone coming to this and wanting to edit automations, open the Docker container, click the 'CLI' icon on "lw_mysql".

At the command line, login to SQL with: mysql homestead --user=homestead --password=secret

Then edit automations using raw sql (here's the one I have to trigger a BlueIris camera to record in HD):

show tables;
select * from web_request_configs;
update web_request_configs set url='http://192.168.x.x:81/admin?trigger&camera=driveway_1&user=aiuser&pw=aipassword' where id=4;
akmolina28 commented 3 years ago

You can also connect using any mysql client if you prefer a GUI experience. I'm using TablePlus.

image