Agricultural mechanization and structural change

Does farm machinery substitute labor and lead to more employment in non-agricultural sectors? Or does it make farming a more attractive occupation than ever?