Software Development
Eclipse Luna – had “Build Automatically” checked when Eclipse stopped compiling my classes automatically. Finally figured out that the .project file was missing an entry for the javabuilder, so I opened it and added:
|
1 2 3 4 5 |
<buildCommand> <name>org.eclipse.jdt.core.javabuilder</name> <arguments> </arguments> </buildCommand> |
Then it worked.
For a web service that is going to be called from an external site, we need to add the CORS headers to make sure the browser will allow it:
|
1 2 3 4 5 6 7 8 9 |
def _acao_response(response): response['Access-Control-Allow-Origin'] = '*' response['Access-Control-Allow-Methods'] = 'GET' def home_view(request): r = { 'response': 'OK', 'data': None } response = HttpResponse(json.dumps(r), content_type = "application/json") _acao_response(response) return response |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 |
<form role="form" class="form-horizontal"> <div class="col-xs-12 well" style="border: 1px solid black;"> <div class="col-xs-6" style="margin-top: 1em;" > <div class="form-group"> <label class="control-label col-xs-4" for="requestor_name">Requestor Name:</label> <div class="col-xs-8"> <input class="form-control" type="text" name="requestor_name"/> </div> </div> <div class="form-group"> <label class="control-label col-xs-4" for="requestor_phone">Requestor Phone:</label> <div class="col-xs-8"> <input class="form-control" type="text" name="requestor_phone"/> </div> </div> <div class="form-group"> <label class="control-label col-xs-4" for="requestor_email">Requestor email:</label> <div class="col-xs-8"> <input class="form-control" type="text" name="requestor_email"/> </div> </div> <div class="form-group"> <label class="control-label col-xs-4" for="site_address">Site Address:</label> <div class="col-xs-8"> <input class="form-control" type="text" name="site_address"/> </div> </div> <div class="form-group"> <label class="control-label col-xs-4" for="csz">City, State, ZIP:</label> <div class="col-xs-8"> <input class="form-control" type="text" name="csz"/> </div> </div> </div> <!-- /.div col-xs-6 (form left column)--> <div class="col-xs-6" style="margin-top: 1em;" > <div class="form-group"> <label class="control-label col-xs-4" for="date_requested">Date Requested:</label> <div class="col-xs-8"> <input class="form-control" type="text" name="date_requested"'/> </div> </div> <div class="form-group"> <label class="control-label col-xs-4" for="site_contact_name">Site Contact Name:</label> <div class="col-xs-8"> <input class="form-control" type="text" name="site_contact_name"'/> </div> </div> <div class="form-group"> <label class="control-label col-xs-4" for="site_contact_phone">Site Contact Phone:</label> <div class="col-xs-8"> <input class="form-control" type="text" name="site_contact_phone"'/> </div> </div> <div class="form-group"> <label class="control-label col-xs-4" for="site_contact_email">Site Contact Email:</label> <div class="col-xs-8"> <input class="form-control" type="text" name="site_contact_email"'> </div> </div> </div> <!-- /.div col-xs-6 (form right column)--> </div><!-- End of contact information div --> <div class="col-xs-12"><h3>Request Details</h3></div> <div class="col-xs-12 well" style="border: 1px solid black;"> <div class="col-xs-6 form-group"> <label class="control-label col-xs-4" for="service_type">Type of Service Requested:</label> <div class="col-xs-8"> <table> <tr> <td> <input type="radio" name="service_type" value="access_control">Access Control </td> <td> <input type="radio" name="service_type" value="intrusion">Intrusion </td> </tr> <tr> <td> <input type="radio" name="service_type" value="video">Video </td> <td> <input type="radio" name="service_type" value="other">Other </td> </tr> </table> </div> </div> <!-- /.div col-xs-6 (form left column)--> <div class="col-xs-6 form-group"> <label class="control-label col-xs-4" for="service_type">Priority Level:</label> <div class="col-xs-8"> <table> <tr> <td> <input type="radio" name="priority_level" value="standard_response">Standard Response </td> </tr> <tr> <td> <input type="radio" name="priority_level" value="urgent_response">Urgent Response </td> </tr> </table> </div> </div> <!-- /.div col-xs-6 (form left column)--> <div class="col-xs-12 form-group"> <label class="control_label col-xs-4" for="detailed_description">Detailed Incident Description:</label> <div class="col-xs-8"> <textarea style="width: 100%;" name="detailed_description"></textarea> </div> </div> <div class="col-xs-12 form-group"> <label class="control_label col-xs-4" for="site_specific">Site Specific Requirements and/or Restrictions:</label> <div class="col-xs-8"> <textarea style="width: 100%;" name="site_specific"></textarea> </div> </div> <div class="col-xs-12 form-group"> <label class="control_label col-xs-4" for="after_hours">After Hours Service Requested:</label> <div class="col-xs-8"> <table><tr><td> <input type="radio" name="after_hours" value="yes">Yes </td><td> <input type="radio" name="after_hours" value="no">No </td></tr> <tr><td colspan="2"> <p><strong> *Please Note: After hours rates and 4 hour minimum will apply unless otherwise covered by a Platinum Maintenance Agreement. Business hours are 8:00 a.m.-5:00 p.m. M-F, excluding holidays. Anything outside of this time frame is considered after hours </strong></p> </td></tr> </table> </div> </div> </div> <!-- End of request details div --> </form> |
Working with PowerShell, I had a program that was scheduled and was using Write-Host to print messages. This works great if you’re running it in the terminal, but it is not redirectable.
This means that if you schedule it and redirect the output (powershell.exe output-demo.ps1 >out.txt), you get nothing.
However, Write-Host for a comma separated list writes all of the list items on one line. Write-Output puts a newline in between. Take a look at this script:
|
1 2 |
Write-Host "Hello", "1234" Write-Output "Hello", "2345" |
Here is the output:
|
1 2 3 |
Hello 1234 Hello 2345 |
The first line is the Write-Host and the next 2 are from the Write-Output. I don’t know why this is and will update with more information.
Having issues getting the System.Disagnostics.Process.Start(…) method to run a process and hide the window. I tried all sorts of things including:
|
1 2 3 4 5 6 7 8 9 10 11 12 |
String proc = "d:\\php-5.6.8\\php-cgi.exe"; String args = "-b localhost:9000";ProcessStartInfo psi = new ProcessStartInfo(); psi.WindowStyle = ProcessWindowStyle.Hidden; psi.RedirectStandardOutput = true; psi.RedirectStandardError = true; psi.UseShellExecute = false; psi.CreateNoWindow = true; p = new Process(); p.StartInfo = psi; p = Process.Start(proc, args); |
Finally came across this page on the msdn site that says:
If the UseShellExecute property is true or the UserName and Password properties are not Nothing, the CreateNoWindow property value is ignored and a new window is created.
I’m using the method:
Start(String command, String arguments)
However, there is another method that is:
Start(String command, String arguments, String user, SecureString password, String domain)
So, if we change the last line from:
p = Process.Start(proc, args);
to:
p = Process.Start(proc, args, null, null, null);
it works! Here is the complete code listing:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 |
class Program { Process p; String proc = "d:\\php-5.6.8\\php-cgi.exe"; String args = "-b localhost:9000"; public Program(){ } public void RunProgram(){ Console.Write("Running: " + proc); ProcessStartInfo psi = new ProcessStartInfo(); psi.WindowStyle = ProcessWindowStyle.Hidden; psi.RedirectStandardOutput = true; psi.RedirectStandardError = true; psi.UseShellExecute = false; psi.CreateNoWindow = true; p = new Process(); p.StartInfo = psi; p = Process.Start(proc, args, null, null, null); Console.Write("Process started..."); } public void Terminate(){ p.Kill(); p.Close(); p.Dispose(); } public static void Main(string[] args) { Console.WriteLine("Hello World!"); Program myp = new Program(); myp.RunProgram(); Console.Write("Press any key to continue . . . "); Console.ReadKey(true); myp.Terminate(); } } |
Here’s code for a controller to allow Spring to process dates properly.
|
1 2 3 4 |
@InitBinder public void initBinder(WebDataBinder binder) { binder.registerCustomEditor(Date.class, new CustomDateEditor(new SimpleDateFormat("yyyy-MM-dd"), true, 10)); } |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
"""Distance helpers.""" import math # EARTH_RADIUS = 6378168 # Distance will be in meters # EARTH_RADIUS = 6378168 / 1000 # Distance will be in kilometers #EARTH_RADIUS = (6378168 / 1609.344) * 5280 # Distance will be in feet EARTH_RADIUS = 6378168 / 1609.344 # Distance will be in miles def great_circle_distance(latlong_a, latlong_b): """ Pass in tuples like (lat1, lon1), (lat2, lon2) to get the distance between the two points """ lat1, lon1 = latlong_a lat2, lon2 = latlong_b dLat = math.radians(lat2 - lat1) dLon = math.radians(lon2 - lon1) a = (math.sin(dLat / 2) * math.sin(dLat / 2) + math.cos(math.radians(lat1)) * math.cos(math.radians(lat2)) * math.sin(dLon / 2) * math.sin(dLon / 2)) c = 2 * math.atan2(math.sqrt(a), math.sqrt(1 - a)) d = EARTH_RADIUS * c return d a = (39.663112, -77.6759584) b = (31.968380, -52.266380) print great_circle_distance(a, b) #/ 1609.344 |
This requires the jackson databind lib, here’s the maven dependency:
|
1 2 3 4 |
<dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-databind</artifactId> </dependency> |
|
1 2 3 4 5 6 7 8 9 10 |
private String toJson(List<String> l) throws JsonGenerationException, JsonMappingException, IOException { final OutputStream out = new ByteArrayOutputStream(); final ObjectMapper mapper = new ObjectMapper(); mapper.writeValue(out, l); final byte[] data = ((ByteArrayOutputStream) out).toByteArray(); return new String(data); } |
|
1 2 3 4 5 6 7 8 9 10 11 12 |
SELECT d.datname AS Name, pg_catalog.pg_get_userbyid(d.datdba) AS Owner, CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT') THEN pg_catalog.pg_size_pretty(pg_catalog.pg_database_size(d.datname)) ELSE 'No Access' END AS Size FROM pg_catalog.pg_database d ORDER BY CASE WHEN pg_catalog.has_database_privilege(d.datname, 'CONNECT') THEN pg_catalog.pg_database_size(d.datname) ELSE NULL END DESC -- nulls first LIMIT 20 |
Introduction
Here is the source for this project
This is my system designed around a Raspberry Pi B+, 2 magnetic overhead door contacts, and 2 5-volt relays. Wired into a 2 car garage this makes an internet enabled garage door opener/monitor that can be accessed from anywhere.
Requirements
* Raspberry Pi B+ kit
* overhead door contacts (one for each door)
* 5-volt relay (one for each door)
* NEMA or other enclosure to mount everything
* 18/4 wire (or some other low voltage wire)
* 2 Terminal blocks
* Various connectors to wire the devices together – Ribbon and jumpers
* Screw drivers and tools
My door contacts needed a 2.5 inch or less gap to work. This made it easy to mount the sensor (the part with the wires) on the wall at the top corner of the door and to put the other part of the contact on the top corner of the door itself. Since there is only about a 3 foot space between the doors,
I mounted the right door’s contact on the upper left side and the left door’s contact on the upper right side. This meant that the 2 wires from each contact could meet in the middle and I could use 1 strand of the 4 conductor wire to get both contacts back to the NEMA box.
My door switch is on the inside wall, and is simply a contact closure switch that causes the motor to start going up or down. This is pretty simple, and it means that a relay is the perfect way to “push” the button with the Pi. To do this, we have to have 2 wires (or half of our 4 wires in the cable) wired to the NO side of the relay so when we send a signal to the relay it closes the loop and “pushes” the button.
There is a terminal strip on the back of the opener with 4 screw-in terminals. The wireless remote and door switch are already run to these terminals, and the 2 inside terminals are the ones that we want. I checked this by taking a screwdriver and shorting these 2 points; this caused door to open just like we’d pushed the button.
This means we have to run wire from the opener on the ceiling to the location of our equipment, just like the contact wiring. Since the openers are about 5 feet apart, I ran one wire to each unit even though I only needed half of the 4 wires.
Now, we mount the components on a board and put this into the NEMA box. Then, we pull the wires into the box and hook everything up. I used one inch pegboard to put the components on, but anything that closes to keep the dust out is good. The only issue with using an all-metal box is that the wireless does not work inside the box (I guess it’s a Faraday cage or something).
At this point, the Pi should be able to control the relay. My relay is activated when the activation pin on the relay goes low. In other words, the GPIO pin connected to the relay should be ON unless we are pulsing the input. This means that to “push” the button we start with the relay ON, when we want to push the button we turn the GPIO off, wait .2 seconds and then turn it back on.
Assuming your switch is on pin 3, here is how you would do this in python:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
#!/usr/bin/python from RPi import GPIO switch_pin = 3 contact_pin = 10 GPIO.setmode(GPIO.BOARD) GPIO.setup(contact_pin, GPIO.IN, pull_up_down = GPIO.PUD_UP) GPIO.setup(switch_pin, GPIO.OUT) print "Status is %s" %(GPIO.input(contact_pin)) print "Pulsing %s" %(switch_pin) GPIO.output(switch_pin, False) time.sleep(.21) GPIO.output(switch_pin, True) |
Now, we don’t have the other side of the relay hooked up yet, but you should be able to hear the relays click when the switch is activated.
Locate one pair of wires coming from one of the opener units. You can check the wires because if you have the correct pair you can touch them together to short them and the door should close or open.
Hook these wires up to the terminal block on one side, and hook up one of the relay common and NO pins on these. This means that when the relay is activated the NO and common pins will be shorted and the motor should start. If you have it hooked up correctly, you should be able to run your pulse script again and the garage door should work!
Do this for the other pair of wires for the other opener and the other relay.
The door contact should be hooked up with one wire going to the ground, and one wire going to a GPIO input. The input is setup with a PULL_UP resistor which means that you will get a 1 (or True) when the contact switch is closed, and a 0 (or False) when the contact switch is open.
To create your SSL keys for the app to use, once you’ve setup the software on your pi and created the */etc/garage* directory, you can run:
|
1 |
sudo openssl req -x509 -nodes -days 365 -newkey rsa:2048 -keyout /etc/garage/garage.key -out /etc/garage/garage.crt |
This will setup your SSL keys so you can use https, which you want to do if you’re going to setup port forwarding and enable this from the Internet.
Checkout door code, configure json file of doors, create ssl keys and make sure you have all the required packages. Run the site.py file and then connect to https://raspberr-pi to see the site:
